SUMMARY

• 8 years of total IT experience for BI/DW projects for Health - care, Bank, Energy, and Manufacturing companies.
• Experience on Informatica Power Center 9.1/8.6/8.1, BODS, SSIS 2012/2008/2005 with good understanding of business needs and Extraction, Transformation and Loading large data from various data sources i.e SQL Server, Oracle, DB2, SAP.
• Worked extensively on Power Center Client tools (Designer, Repository Manager, Workflow Manager, Workflow Monitor).
• Worked extensively on Informatica Transformations (Active, Passive, Connected & Unconnected).
• Designed mappings, mapplets, created sessions and workflows to load data, and monitored workflow progress.
• Experience in identifying and resolving performance bottlenecks at various levels like sources, mappings and sessions.
• Performed testing using DVO. Wrote ETL test cases, test plan and Technical Documentation.
• Experience in resolving Production issues, Exception-handling, performance tuning and Email Alerts.
• Scheduled and monitored jobs.
• Worked on Trillium for data cleansing and data profiling.
• Experience in writing SQL, PL/SQL, shell scripts.
• Knowledge of Conceptual, logical and physical data modelling, ER modelling and tools like Erwin, and Visio.
• Familiar with Scrum, Agile methodologies, MDM, OLAP and OLTP database schemas.
• 4 years of experience in BI Reports - Cognos, OBIEE 10/11g, SSRS 2012/2008/2005.
• Experience working with off-shore team; provided 24/7 tech support.
• Diverse background with fast Learning and creative analytical abilities with good Techn ical, Communication and Interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter9.1/8.6/8.1, SSIS 2005/2008/20012 , Ab initio 3.0.

RDBMS: Oracle10g/9i, SQL Server 2000/2005/2008 , DB2

BI Tools: Cognos 8.0/10.1, Tableau, SSRS, BI Publisher 11g/10g

Operating System: UNIX, Linux, Windows NT/2000/XP/7

Defect Management tools: HP Quality Center 9x/11, Remedy 7x, ClearCase

Languages: SQL, PL/SQL, Visual Basic, Shell Scripting

Modeling Tools: MS Visio, Erwin

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

• Worked on Informatica Power Center 9.1
• Worked with DBAs and Business Analysts to analyze and gather business requirements.
• Designed complex mappings, mapplets, created sessions and workflows to load data, and monitored workflow progress.
• Designed mappings using various types of transformations such as Active, Passive, Connected and Unconnected.
• Worked on CDC (change Data Capture) to capture insert, update, and delete activity applied to tables.
• Implemented Source Qualifier, SCDs(1/2/3), Joiner, Filter, Router, Rank, Expression, Lookup, Aggregator, Sorter, Normalization, Update Strategy, Sequence Generator, Stored Procedure transformations, Union, etc.
• Wrote SQL, PL/SQL scripts. Created/Edited korn shell scripts for pre or post-session.
• Wrote BRDs, ETL Technical Specification Docs, Test Plan, ETL Test Cases, Migration Plan Doc.
• Performed testing from source to target using DVO (Data Validation Option), performance tuning and Exception-handling. Worked on data integration and data staging levels.
• Scheduled and monitored jobs using Control-M.
• Worked on data cleansing and data profiling using Trillium.
• Worked on Tickets and provided tech support to resolved production issues. Worked with QA team to follow up on testing.
• Participated on Daily/Weekly team meetings on the Project.

Environment: Informatica PowerCenter 9.1, SAP ECC6.0, MS SQL server 2008, SSIS 2008, Oracle, Toad, DVO, PL/SQL, MS Visio, UNIX, Quality Center 11, Remedy, Windows, SharePoint, TFS, Control-M for scheduling, ClearCase, Trillium.

Confidential

Developer (Informatica)

Responsibilities:

• Worked with Business Analysts, DBAs to analyze and gather business requirements.
• Designed complex mappings, mapplets, created sessions and workflows to load data, and monitored workflow progress.
• Implemented various types of transformations such as Active, Passive, Connected and Unconnected.
• Set mapping parameters, variables, breakpoints, exception-handling, and email alerts.
• Worked on performance turning to identify performance bottlenecks.
• Worked on change Data Capture to capture insert, update, and delete activity applied to tables.
• Did testing from source to target using DVO.
• Wrote complex SQL, PL/SQL scripts.
• Worked on Trillium for data cleansing and data profiling.
• Wrote shell script after each successful run of session to update/insert/select for different scenarios either in Pre or Post session command.
• Worked on 3 rd party tool control-M to schedule jobs.
• Wrote detailed ETL designed Technical Specs Document, ETL test cases, test plan; followed up with QA team.
• Created various Reports, Dashboard, Graphs, Charts using Business Objects BI suite XI3.1.
• Participated in daily and weekly team meetings.

Environment: Informatica PowerCenter 9.1/8.6, Oracle, Toad, SAP, SQL, PL/SQL, SQL Server 2008, Trillium, Visio, Windows, TFS, Linux, Quality Center, Sharepoint, VSS, Business Objects XI3.1, VB, Ctl-M for scheduling jobs.

Confidential

Developer

Responsibilities:

• Analyzed and gathered business requirements and wrote technical specifications document.
• Designed complex mappings, mapplets, created sessions and workflows to load data, and monitored workflow progress.
• Designed mappings using various types of transformations such as Active, Passive, Connected and Unconnected.
• Worked on CDC (Change Data Capture) to capture insert, update, and delete activity applied to tables.
• Implemented Source Qualifier, Joiner, Filter, Router, Rank, Expression, Lookup, Aggregator, Sorter, Normalization, Update Strategy, Sequence Generator, Stored Procedure transformations, Union, etc.
• Wrote SQL, PL/SQL scripts. Created/Edited shell scripts for pre or post-session.
• Wrote BRDs, ETL Technical Specification Docs, Test Plan, ETL Test Cases, Migration Plan Doc.
• Performed testing from source to target using DVO (Data Validation Option), performance tuning and Exception-handling.
• Scheduled and monitored jobs.
• Worked on Tickets and provided tech support to resolved production issues. Worked with QA team to follow up on testing.
• Participated on Daily/Weekly team meetings on the Project.
• Worked with QA team and data analysts to follow-up.
• Participated in daily/weekly team meetings.

Environment: PowerCenter 8.1, SQL, PL/SQL, Oracle, MS SQL server 2008/2005, SSIS, TOAD, UNIX, Remedy, VB, OBIEE

Confidential

ETL Developer

Responsibilities:

• Analyzed ETL requirements. Created sources, targets, and transformations.
• Wrote SQL, PL/SQL Scripts.
• Designed ETL mappings using various transformations i.e. Joiner, Connected Lookup and unconnected Lookup, Rank, Router, Filter, Aggregator and Sequence Generator transformations, Source qualifier, etc..
• Tested ETL package from Source to Target.
• Wrote technical documentation, ETL test cases, test plan. Worked on tickets.
• Worked with the QA team, DBA and data analysts.
• Participated in Daily/Weekly team meetings.

Environment: Informatica Power Center 8.1, Oracle, SQL Server 2005, SSIS, SQL, PL/SQL, VISIO, Toad, Windows, UNIX, Quality Center, Remedy, Visual Basic.