SUMMARY:

• Accomplished ETL, Data Quality & BI Professional primarily focused in Banking and Financial Domain. Proven track record for leading and executing complex ETL and BI projects. Extensive experience in software engineering with excellent team building skills. Practiced in clarifying business requirements, architecting IT solutions and designing process/system improvements. Proficient in datamart architecture and design.

PROFESSIONAL EXPERIENCE:

ETL Lead

Confidential

Responsibilities:

• Developing the Customer Data Hub in different processing stages - Transform, Validation, Load and Synchronization. Improving data quality of the incoming data from various sources.
• Bulk data migration from the source systems into the Customer and Account Data Hub.
• Technology: Informatica Power Center 9.5, Informatica Data Quality 9.5 (Address Doctor), Shell Scripting, DB2
• As ETL Lead, responsible for the following tasks:
• Understanding of existing systems.
• Defining Data Quality Roadmap
• Data Profiling.
• Profiling and cross profiling source systems using IDQ
• Generating DQ rules
• Designing the Canonical Data Model
• Designing ETL Architecture
• Address Doctor
• Informatica Mapping Design
• Performance Tuning of mapping

P Management Implementation - ETL Lead

Confidential

Responsibilities:

• Creating and managing centralized P management system to provide a consistent method for managing enterprise ps using Possible Now My Ps Tool.
• Integrating with legacy systems and expanding the solution to other business units.
• Technology: Pentaho Kettle ETL Tool, Possible Now My Ps Tool, Shell Scripting
• As ETL Lead, responsible for the following activities:
• Understanding P Data from Legacy Systems.
• Architecture Design for Batch processes.
• Creating and Implementing ETL Roadmap using Pentaho Kettle
• Coordinating with different module of the project like Front end team, PMS Team, Legacy Systems, QA Team etc.
• Facilitating the code move to Production and providing support.
• Bulk load of P data from Legacy systems to the new P Management System.

MDM Implementation - Technical/Engagement Lead

Confidential

Responsibilities:

• Implementation of the Informatica MDM HUB replacing the Legacy Purisma Data Hub (PDH).
• Loading SAP and Siebel data into MDM using Batch and Real Time. Distribution of Data to the Down Streams - DW and BI. Technology: Informatica Data Quality, Informatica Power Center, Informatica Power Exchange, Oracle, UNIX
• As Technical/Engagement Lead, responsible for the following activities:
• Co-ordination between Global Business and Technology teams.
• Managing Delivery for different Interface counterparts (MDM, SAP, Siebel, DOT NET, ETL, FUSION and QA).
• Defining Data Quality Rules for Cleansing and massaging inbound heterogeneous data.
• Architecture Design for the ETL Processes.
• Designing the Data Distribution methodology for downstream systems
• Performance Tuning of Inbound and Outbound ETL Loads
• Coordinating with different module of the project - MDM Team, QA Team, SAP and SIEBEL Team etc.
• Driving the Implementation and Support Teams.

Data Management - Senior Technical Consultant

Confidential

Responsibilities:

• Technology: Informatica Powercenter 8.6, SYBASE, DB2, Oracle 11g, UNIX, Control - M
• DDS as a part of Core Data Services in Asset Management is responsible for providing accurate daily positions and transactions data, security master data, pricing data received from different accounting systems to Equity, Fixed Income trading platforms along with different downstream applications in timely manner.
• Prioritizing the DDS applications development and enhancement requests received from downstream users and support team.
• Project Management - Task assignment and coordination with global team to deliver the project modules within time and cost.
• Performance tuning of the ETL Mapping.
• Driving Implementation and Support
• Operational Data Mart (ODM) Implementation:
• Technology: Informatica Powercenter, Oracle, Sybase, DB2, UNIX, Control-M
• Developing ODM to provide data to various downstream clients including Hadoop thus reducing the direct exposure to Position and Instrument data and avoiding possible deadlocks.
• Oracle database set up for ODM
• Informatica ETL developments
• Coordinating with Global teams
• Driving Implementation and Support
• Facilitating the code move to Production
• Creating data feeds on Datameer based on the data extracts sent to Hadoop
• UK to US PTS Data Sync Implementation:
• Technology: Informatica, DB2, Control-M, UNIX
• Designing mechanism to capture any data changes in UK instance and loads the same to US
• PTS
• Requirement gathering, preparing ETL design document
• Developing ETL Code using Informatica Powercenter to implement Change Data Capture.
• Fine-tuning the mappings by setting the appropriate cache and other related properties.
• Facilitating the code move to Production and providing post implementation support.

Asset Management - Senior Technical Consultant

Confidential

Responsibilities:

• Core Data Factory to Fixed Income Info Hub (FIIH) Data Synchronization:
• Technology: Informatica Powercenter 7.x, DB2 UDB 8.x, Oracle 9i, Sybase, UNIX, Control - M
• Creating ETL solution for full and incremental load to FIIH
• Design and Development of the ETL Code using Informatica to implement Change Data Capture.
• Fine-tuning the mappings by setting the appropriate cache and other related properties.
• Debugging & troubleshooting the errors sent across by the QA team.
• Automating the load process using Perl scripts and Shell scripts.
• PTS (Position Tracking System) data load automation:
• Technology: Control-M, Shell scripts, UNIX, Sybase and DB2
• Automation of PTS Data Load processes using Firm Standard Control-M scheduler
• Creating Control-M jobs and related configuration files for
• Auditing, Error and reject handling, Ability to restart design
• Batch architecture design
• Preparing impact analysis and technical design document for any change/new development requirement along with effort estimations.
• Cognos Development and Administration:
• Technology: Cognos 7.3, 8.1, 8.4, Cognos Powerplay, Transformer, UNIX Shell scripting, Sybase, DB2, Control-M
• Migration of Cognos 7.3 server and reports from Legacy to Strategic Infrastructure.
• Installation and Configuration of Cognos server
• Creation of stored procedures in Sybase and DB2
• Creating models for cube and building the cubes with transformer
• Automation of Cognos reports and cube build processes in Strategic environment
• User creation and clean up in Sun Directory Server in Access Manager
• Migration of cron jobs to control-M in strategic solution
• Cognos Services restart and database creation when needed
• Migration of 7.3 Cognos reports to Cognos 8.1. Administering and managing 8.1 services. Rewriting the 7.3 reports in 8.1.
• Migration from Cognos 8.1 to 8.4 - setting up data sources and migrating the 8.1 packages to

Asset Management - Technical Consultant

Confidential

Responsibilities:

• As Technical Consultant responsible for the following activities:
• Preparing the design documents.
• Creating SQL stored procedures for reports not achievable in COGNOS.
• Upgrading 7.1 reports to 7.3 using Impromptu Cognos tool.
• Publishing the reports into all the environments
• Formatting the reports to achieve required look