SUMMARY:

• Five Plus 5 Years of experience in Design, Analysis and development of Data Warehouse/Data Mart using ETL technologies on Windows and UNIX platforms.
• Five Plus 5 Years of experience working in domains like Finance, Banking and Health Care.
• Experience in working with Relational Database Management System using environment of Oracle 11g/10g, MySQL, PL/SQL developer, TOAD, MS SQL Server and DB2.
• Strong experience in developing Data Warehouse/Data Marts, ODS, Data Mining by Transformation and Loading ETL methodologies, OLTP and OLAP techniques using Informatica Power Center.
• Expert in using SQL and PL/SQL script to generate complex queries, Stored Procedures, Functions, Packages, Cursors, Performance Tuning, Capacity Planning, Triggers, Views and Index in distributed environment.
• Extensively worked on Business Intelligence applications using IBM Cognos, MS SQL Server suite.
• Expertise in developing complex mappings in Informatica using different transformations: Joiner, Aggregator, Update Strategy, Rank, Router, Lookup - Connected Unconnected, Sequence Generator, Sorter, Source Qualifier, expression Stored Procedure transformation etc.
• Proficient in Data Modeling on Data Warehouse and Data Mart Top Down / Requirements Driven Approach, Fact Tables and Dimension Tables, Star Join Schema, Snow-Flake Schema, Operational Logical and Physical Data Models, Normalization and Demoralization and Data Modeling on Database Relational Data Structure, ER Diagram Design .
• Strong knowledge in Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology.
• Good exposure in overall Software Development Life Cycle SDLC , including requirements analysis, design, development, documentation, testing and debugging.
• Hands on experience in Performance tuning to implement bottlenecks elimination using instance tuning and SQL tuning.
• Practical understanding in gathering requirements from users to define data and processing requirements for supporting new data products and analytics capabilities.
• Experience in writing UNIX shell scripts to support and automate the ETL process.
• Good understanding in using statistical programming language such as R and SAS.
• Knowledge in ODBC, using programming language API for accessing database management systems.
• Excellent troubleshooting skills, ability to meet deadlines and handle pressures coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

ETL Informatica Developer

Responsibilities:

• Developed and maintained ETL Data Extract, Transformation and Loading mappings to extract the data from multiple source systems and loaded into data warehouse.
• Extensively used various active and passive transformations like Filter, Router, Expression, Source Qualifier, Joiner, Lookup, Update Strategy, Sequence Generator and Aggregator Transformations.
• Performed slowly changing dimensions Type1 and Type2 mappings.
• Worked with the onsite and global team in the SDLC model to deliver high quality technical solutions that meet the needs of our clients.
• Used Informatica Power Center and Data Warehousing techniques to integrate the various source systems into the target ICDW infrastructure.
• Used Informatica debugger and logs to find out bugs in existing mappings by analyzing data flow and evaluating transformations and done unit testing for the individually developed mappings.
• Created complex, multipage reports using most of the IBM Cognos functionality such as Prompts, Conditional Formatting, Conditional Rendering .
• Used PL/SQL to modify procedures, functions, cursors and packages according to the business requirements.
• Worked on performance tuning and bottlenecks elimination to reduce the load time and monitored the data loads.
• Involved in data modeling by using Star and Snowflake schemas.
• Used UNIX shell script to manage workflows.
• Involved in scheduling the workflows using Control M.

Environment: Informatica Power Center 9.1, Cognos 10.1, Oracle 11g, SQL, PL/SQL, UNIX shell scripting, Control M and TOAD 10.5.

Confidential

ETL Developer

Responsibilities:

• Created MDM Master Data Management base objects, Landing and Staging tables to follow the comprehensive data model in MDM.
• Used Informatica as ETL tool for building the data warehouse.
• Created MDM mappings using UPMC best practices to capture the errors and have a clean load using Informatica Power Center.
• Interacted with data analysts to understand the requirements, identify gaps and to turn them into technical documents and mapping specifications.
• Worked with project manager to establish and execute project timelines.
• Worked on data integration for data warehouse.
• Performed data analysis and validation of the data received from upstream systems.
• Created ETL mappings, usage of Lookups- connected and unconnected, Aggregator, Ranking, Mapplets, and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done.
• Extracted data from heterogeneous sources like flat files, Oracle databases.
• Created, Tested and debugged the Stored Procedures, Functions, Packages, Cursors and triggers using PL/SQL.
• Implemented performance tuning to optimize session performance, found performance bottlenecks and used pipeline partition to eliminate them.
• Performed slowly changing dimension type 1 and type 2 to ensure the data accuracy.
• Used Informatica Data Quality 9.5 to get rid of the duplicate records.
• Developed and deployed Informatica in Unix/Linux and Oracle 11g database environment.
• Provided technical expertise, troubleshoots, guides and supports during design, development, testing, production and post-production.

Environment: Informatica Power Center 9.1, Informatica MDM 9.5.1, Data Quality 9.5 PL/SQL developer, Oracle 11g

Confidential

ETL Developer

Responsibilities:

• Involved in Data Analysis, Design, Development, Testing and Implementation of Business Intelligence solutions.
• Developed OSD architecture using Infromatica tools.
• Worked on Data Integration of ODS to integrated data from multiple sources.
• Developed Complex mappings and mapplets using Informatica power center 9.0 to extract , clean, transform and load ETL reality source data into ODS, and load ODS's data into data warehouse and data marts.
• Created complex mappings and workflows to meet the data migration, cleansing, integration requirements.
• Implemented Lookups, Aggregator, Rank, Filter, Router, Joiner, Source qualifiers and Update Strategy transformations.
• Used IBM Cognos to integrated data using framework manager and generate reports using query studio and report studio
• Worked in data modeling of ODS system, created logical and physical schemas.
• Loaded the data into schema using NSI Scheduling tool.
• Involved in maintaining the data model, creating the tables and granting the privileges for read and write operations for related database by SQL and PL/SQL.
• Wrote UNIX Shell Scripts to compare files, to save the time cost for data look up in database.
• Wrote complex SQL script to extract data from Oracle 10g database, included tables, data type, references and indexes, views, triggers.
• Involved in debugging mappings and tuned for better performance.
• Created staging Tables, Indexes, Sequences, Views and performance tuning like analyzing tables, proper indexing.
• Involved in coordination tasks, attending meetings, and the review of requirements, infrastructure setup and code review.

Environment: Informatica Power Center 9.0, SQL, PL/SQL developer, Oracle 10g, UNIX Shell script, IBM Cognos, NSI

Confidential

SQL PL/SQL Developer

Responsibilities:

• Involved in data analysis for impairment provision and LGD Loss Given Default calculation.
• Built schemas in Oracle 10g system, included tables, data type, references and indexes, views, triggers using Toad, SQL PLUS and PL/SQL.
• Wrote SQL script to import data from bank's database system.
• Wrote PL/SQL code to create Stored Procedures, Functions, Packages, Cursors and Object Types to realize analysis purpose.
• Used PL/SQL developer and SQL tuning to do performance tuning tuning the SQL code and SQL queries .
• Maintaining the database by adding new business requirement and trouble shooting.
• Used Unix Shell script to automate process.
• Used MS SQL Server 2008 suite analyzer and reporter to generate reports.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines.
• Worked on testing to ensure codes developed and executed in validation of system requirements.
• Troubleshoot and resolve technical issues. Participated in enhancing the performance of overall system.
• Provided support to the existing system.

Environment: PL/SQL developer, Oracle 10g, SQL, PL/SQL Developer, Toad, Unix/Linux