Extensive experience in development, analysis, management and support of various domains in financial systems on a variety of technical platforms and environments. Excellent oral and written communication skills, interaction with senior management, internal and off-shore development resources, data center, network & infrastructure personnel and business end-user.

Professional Summary

• Total IT experience - 7 year 2 months.
• Served as a primary focal point for Data Warehouse Design, development, implementation and support in financial, telecom, education domain at both offshore and onsite locations with active participation in entire lifecycle of DW development.
• Extensive experience in Data Modeling using Relational and Dimensional data modeling(Star and Snow-Flake). Involved in defining logical and physical design for Data modeling, designing fact, dimensions table and defining attributes.
• Involved in creating and defining Metadata, data Flows. Analyzing the data to flow through various sources to Staging and to DW. Involved in data mining and extracting patterns from data for various projects.
• Extensive experience in ETL development using Informatica and DataStage.
• Certified professional in Informatica 7.1
• Strong knowledge in Oracle and exposure to various databases.
• Strong ability to work in teams derived from diverse sources. Excellent analytical skills and ability to quickly grasp and understand new business/technical areas.
• Developed and participated actively in numerous ETL implementation, conversion and upgrade projects for banking applications.
• Experience of Business Analysis, System Analysis, Team Lead, Onsite-Offshore co-ordination, Design and Development.
• International experience of working with Confidential NJ, Confidential Saudi Arabia and Confidential Indonesia.

Technical Proficiency:

• DW Concepts : Dimensional Data Modeling, Star and Snow-Flake schema, Fact and Dimensions Tables, Relational Data Modeling, Logical and Physical Data Modeling. Data Normalization, Enterprise and Operational Data Model.
• Tools : ETL: Informatica (6.x,7.x,8.1,8.6), Ascential DataStage 7.5, BO Data Integrator, Knowledge in Ab Initio, PeopleSoft EPM 8.8, IBM Information Server 8.0.1
• Databases : Oracle 9i and 10g, MS SQL Server
• Operating Systems : Unix (Solaris and HP UNIX), DOS, Windows NT
• Technologies : Visual Basic, Developer 2000, PL/SQL
• Languages : C, C++

Functional

Professional Experience

For Oracle Financial Services (Feb 2005 to till date)

1. Project : DbFeeds (Relational and Enterprise DW)
Client : Confidential
Duration : April 2008 to till date
Tools & Technology : Unix (Sun Solaris), Oracle 9i & 10G, Informatica 8.1 & 8.6
Role : Onsite coordinator (Team Lead), SL3 support

Description
dbFeeds provides enterprise-wide services that help data integration groups within Confidential reduce or better leverage their development /production support resources. This is achieved by sharing Extract, Transform and Load (ETL) capabilities on the Informatica platform managed and maintained by dbFeeds. Through a shared cost model, feed development resources, production support and infrastructure maintenance are centralized on one platform and opportunities for reuse and knowledge sharing are maximized.
Clients primarily use the service to develop data feeds between two or more systems where there are mapping requirements between the fields from the source system, to the target system\'s fields downstream. For example, any system that interfaces with SAP does not send their data directly to the SAP application. Instead, the source system sends their data to dbFeeds which transforms it into the required SAP format before sending to downstream to SAP. This way, the consistency of feed data sent to SAP is maintained and any incorrectly formatted data rejected at the ETL layer before causing issues in SAP.
Current data volumes exceed 20 billion inbound records per month with 70% of that volume coming from Finance and Credit Risk.

Responsibilities:

• Understand existing database model and co-ordinate with business to make change to existing data model.
• Understand the requirement of reference data and in-corporate the new requirement to fit into existing data models.
• Involved in supporting all the ETL applications (Informatica, AI2 adaptors and Databases)
• Understand the business requirements and involved in changing the mapping logic as per mapping specifications. Involved in preparing test cases and mapping specification documents.
• Involved in analysing the data to resolve reference data issues.
• Involved in resolving day-to-day issues.
• Enhance and automate the dbFeeds process.
• Client & offshore-onsite co-ordination

2. Project : Oracle General Ledger Implementation & MIS Data Warehouse
Client : Confidential (Onsite Indonesia)
Duration : March 2007 to March 2008
Tools & Technology : Unix (Sun Solaris), Oracle 9i, Informatica 8.1.1
Role : Senior ETL Developer/ Data Analyst

Description
Confidential is one of the Leading Bank in Indonesia. Removed the legacy Product GL system and installed the enterprise GL that provides better control over financial data by using best-of-breed functionality built into Enterprise-class GL product from Oracle. Integrated the financial data (GL data) from more than 12 sub-systems.

Responsibilities:

• Involved in building the ETL mapping between Source system (ICBS, OFSA, RATES, MDMC, Confidential and etc…) & Target system (EGL)
• Worked closely with business to undersand their requirments and build mapping according to the specification.
• Understand the business requirements and involved in preparing mapping specification document.
• Involved in creating ETL objects and automation the process to run daily and monthly Jobs.
• Develop PL/SQL scripts (Oracle Stored Procedures & Functions)
• Extensively made use of maplets, joiner, aggregator, Reusable transformations, sessions etc.Supporting ETL production team.

3. Project : ETL around Basel II Data model
Client : Internal
Duration : Jan 2007 to March 2007
Tools & Technology : Unix (Sun Solaris), Oracle 9i, Informatica 8.1.1, DataStage Enterprise Edition 7.5
Role : Senior ETL Developer

Description:
This project is done for integrating various source systems into single system (Basel System) using Informatica, DataStage and designing data model for Basel II system that will be implemented in various banks with initial customization.

Responsibilities:

• Involved in designing the datamodel to meet the customer demands for BASEL II system. Defining the diminsions tables and their key attributes.
• Perform business logic validation.
• Develop pre-defined ETL jobs and Automating the process through ETL.
• Creating re-usable components that are common across banks.
• Involved in creating workflows, tasks and mappings.

4. Project : Confidential
Client : Confidential (onsite Saudi Arabia)
Duration : April 2006 to Jan 2007
Tolls & Technology : Oracle 9i, DataStage 7.5 (Server Ed), Data Stage Enterprise edition PX (Parallel Extender)
Role : ETL development

Description:
This project is done for Confidential, Saudi Arabia as a part of Basel-II implementation. The Basel Committee focuses on securing international convergence of supervisory regulations governing the capital adequacy requirements of international banks and also possibility of loss. Basel-II implementation involves in calculating the risks (Credit, Market and Operational Risks). ETL work involves in extracting and integrating data from various Bank Systems, designing business logics as per Basel-II needs. Complex transformations are involved in designing the ETL as data are collected from different source systems.
The project is developed in DataStage server edition and later migrated to Data Stage PX (Parallel Extender) due to large volume of data in the bank system, also to improve the performance as Data Stage PX runs in multi processor system.

Responsibilities:

• Understand various sources and their relations, analysing data to meet the user requirment. Extracting data to populate the dimensions and fact table. Define the data.
• Involved in extraction, transformation and loading of the data using Built-in, Plug-in and Custom Stages.
• Extensively worked with Parallel Extender for parallel processing to improve job performance while working with bulk data sources.
• Extensively made use of stages Aggregator, Sort, Merge, Join, Change captures, Peek stages in Parallel Extender job.

5. Project : Global Consumer PeopleSoft EPM Rollout
Client : Confidential, USA
Duration : Mar 2005 to April 2006
Technology : Oracle 9i, SQL Loader, People Soft EPM 8.8,DataStage
Role : Development and Branch Support

Description:
PeopleSoft Enterprise Performance Manager delivered over PeopleSoft Internet Architecture and People tools is a solution that is preconfigured and can be reconfigured for any enterprise to measure the business performance across several dimensions. Citibank, UK and US have piloted the implementation of this solution to meet the local and global MIS reporting requirements. The implementation is on an ongoing basis with several other business requirements migrating from the legacy systems. Rollouts to other countries are planned after successful cutover in pilot countries.

Responsibilities:

• Understand the business requirment and define the data by grouping segment, marketplace and Region.
• Develop DataStage jobs & sequences and upload data
• Involved in preparing source to target mapping. Involved in preparing and running through the test cases.
• Involved in running the process through Process Scheduler and monitoring the process through Process Monitor
• Involved in fixing the bugs
• Involved in loading Dimensions dynamically, Member Load and Data Load

For Confidential. (Jul 2004 to Feb 2005)

1. Project : NMP-West Domain-PR
Client : Confidential (USA)
Duration : Jul 2004 - Feb 2005
Technology : Informatica 7.1, Oracle (PL SQL) 9.i, HP UNIX
Role : Analyst

Description:
This project is for analyzing trends and reporting to C2C & FCC. Data is received from Various States of US as ASCII files and needs to be uploaded into various targets. The data is maintained in data warehouse as a historical data in the form of Data Mart. Oracle procedures & functions are used in transforming the data. Informatica Mapping is created to upload data into the targets. The OLAP application team for generating various user-specific and automated reports finally uses these data.

Responsibilities:

• Involved in changing the Informatica mappings to meet the business & customer requirements
• Involved in building the data mapping exercise between Source system & Target database
• Develop Informatica mapping and upload data
• Develop PL/SQL scripts (Oracle Stored Procedures & Functions)
• Responsible for regular Informatica Repository Backup

For Confidential. (Jun 2002 - Jun 2004)

1. Project : Confidential
Client : Internal
Duration : Jun 2002 - Feb 2003
Technology : Visual basic & MS Access
Role : Trainee

Description:
Confidential is a unique web page that acts as online question bank for entrance exam in India.

Responsibilities:

• Designing the VB applications that is integrated with the WebPages for padashala.com
• Developing MS Access tables.

2. Project : SERVISYS

Client : Confidential
Duration : Feb 2003 - Aug 2003
Technology : Developer 2000, Oracle, SQL Loader, UNIX, Shell scripts
Role : Team Member

Description:
SERVISYS (SERVIce branch SYStem) is especially made for the service branch of Banking. The service branch is one of the branches of a bank, which gives the services for its own bank. It involves all the operation of service branch like Clearing, out-station cheques' clearing, National clearing, DD reconciliation, Pay order issuable and other back office works like preparation of Daybook, Transfer scroll, Trial Balance etc.
Responsibilities:

• Implementation of SERVISYS application.
• Training the users on use of application
• Bug fix and data process.
• Code Enhancement.

3. Project : Mosaic II Client Adoption
Client : Confidential, London
Duration : Sep 2003 - Jun 2004
Technology : Informatica 6.1, Athanor, Oracle 9i, UNIX
Role : Team Member

Description:
This project is for migrating data from various systems into a single adoption system called dbClient. It uses the concept of de-duplication using Athanor tool. The project involves various phases like party role identification, party de-duplication & trading relationship de-duplication. After all these phases, the data will be uploaded into a dbClient database through Informatica. PL/SQL scripts are written for balance calculation that has to be updated into the dbClient database.

Responsibilities:

• Involved in building the Data Mapping exercise
• Developing Informatica & Athanor mappings and uploading the data
• Developing PL/SQL scripts
• Perform business validation using automated scripts