Objective: Data Analyst with Data Modeling or Data Warehousing

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 Technical, 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

EXPERIENCE

Confidential

ETL Developer

• Description: CVS Caremark NYSE: CVS , headquartered in Woonsocket, RI, is the largest pharmacy health care provider in the US with integrated offerings across the entire spectrum of pharmacy care. 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

Description: SaskPower is the principal Electric Utility company in Saskatchewan. SQL Server, Oracle, SAP and Custom Applications.

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 3rd 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

Description: Lafarge North America is the largest diversified supplier of Construction Materials in the U.S. and Canada.

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

Description: The Canadian Imperial Bank of Commerce, commonly known as CIBC, is one of Canada's chartered banks, fifth largest by deposits. The bank is headquartered at Commerce Court in Toronto, Ontario. 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.

Confidential

Developer SSIS/SSRS Description Toronto Dominion Bank is the second largest back in Canada. Project was to alter the process to meet the new business requirements associated with the customer equity trading and performance. Responsibilities: Analyzed business requirements, and wrote technical specifications document.

• Designed ETL package to load data in a desired target.
• Wrote SQL queries, stored procedures.
• Proficiently implemented transformations, tasks, containers, source, target, Break-points to do extract-transform-load in a package.
• Provided technical support to resolve production issues and schedule jobs.
• Wrote Technical Requirements Document, BRDs, Migration Plan, Unit Test and Developer Testing Document.
• Created various style of Reports i.e. drill-down, linked reports, parameter, matrix reports.
• Worked with QA team and business analysts to follow-up and participated in daily/weekly team meetings.

Environment: MS SQL Server 2000, DTS, Oracle, Excel, Access, SSRS, SQL, Visual Basic