Supervisor – Systems Accounting, Finance
Commercial Bank of Kuwait
Total years of experience :13 years, 8 Months
• Well-versed in developing reports using Cognos Business Intelligence components like Report Studio, Framework Manager, Query Studio, Analysis Studio, and Cognos Connection.
• Experience in creating end user reports (like Cross tab, list, chart etc.) using Cognos Report Studio and Query Studio.
• Extensive knowledge with Dimensional data modeling schema, Fact and dimensional tables.
• Develop, Publish Packages in Framework Manager and maintain models.
• Report developing and processing - To process regulatory reports on monthly, weekly and quarterly basis. Meet the external regulator's timelines for weekly & monthly data submissions as per their requirements.
• Support the department for generating internal reports & regulatory reports using Cognos BI tool (eg. Asset & Liability Report, Statement of condition, Balance Sheet, Provision reports, etc).
• Maintain high level business reporting integrity by developing control reports to identify GL differences and thus maintain the data accuracy
• Responsible for analyzing, querying and extracting data for reconciliation reports.
• Develop complex database objects such as stored procedures, functions and triggers using SQL and PL/SQL.
• Data mining and data extraction to meet business requirements for management reports.
• Vigorous training on ICBS - Integrated computerized banking system application server and Finance module.
• Preparation of technical specification documents.
• Created forms using Oracle Form Builder as per business requirement and documented user manual.
September, 2011- March, 2013
Client: Telstra
Role: System Engineer
Responsibilities:
• Designed and developed ETL structures to extract, transform and load data from multiple data sources into data warehouse and other databases based on requirements from the client.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Supported the existing production environment Oracle 10g DB and had to document the data changes in database functionality.
• Customization and development of Business Object Reports \[Web Intelligence\] per client requirements.
• Developing custom interfaces between various applications for integration using CGI Scripts and Perl Scripting.
• Utilized Tivoli Net cool/OMNIbus 7.3 suite of products from IBM to monitor network and service.
• Extensive experience in installing, configuring and administrating gateways, object servers and webGUI tools.
• Preparation of functional specification and design documents.
• Performed Unit Testing, System Testing, System Integrated Testing and User Acceptance Testing.
• Interacted with users to resolve any issues during the production, development and enhancement phases.
Projects Undertaken :-
Project Silver Lining -PSL Initiative delivered private and public cloud computing services targeted to enterprise and business customers. This initiative provided a secure virtualized utility computing platform that is built in to Telstra’s network.
IP Assurance Automation (IPAA) Project-This project improved operational efficiency by reducing the manual dependency to monitor alarm management system and perform trouble ticket creation (in Netcool).
September, 2010 -August, 2011
Client: Sears
Role: Java Developer
Responsibilities:
-Strong experience in IBM WebSphere Application Server Administration and web application development using J2EE technologies such as EJB, JSP, Servlets, JDBC, Java, Eclipse IDE
-Expertise in deploying J2EE components on IBM WebSphere Application server.
-Extensive experience in installing, configuring and administrating Web servers such as IBM HTTP server, Apache Tomcat 6.0 and IBM WebSphere Application server V6.0
-Developing webpages for MYGofer online shopping site which use IBM WebSphere Application Server as the runtime environment for JavaServer Pages (JSP) and servlets.
-Resolved many P2 and P1 issues in the Sears (MYGofer) webpage.
June 2006- June 2010 Viswajyothi College of Engineering & Technology, Mahatma Gandhi University, Kottayam, India Bachelor of Technology in Information Technology Engineering (B.TECH) Graduated with first class honors
April 2006, 2004 United Indian School Kuwait, C.B.S.E