PROFESSIONAL SUMMARY:

• About 10 years of Information Technology Experience in Data Warehousing using Tools like Informatica Power Center 9.6.1/9.5/9.1/8. 6.1/8.1.1 , Business Objects XI R3 and Teradata.
• Extensive experience in Insurance and Healthcare domains.
• Good experience in Full Life Cycle Implementation of applications on multi - platforms.
• Data Processing experience in designing and implementing Data Warehouse applications using ETL tool and developed ETL mappings and ETL workflows and also monitoring the Production Environment.
• Developed Complex mappings with varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Unstructured Data, Normalizer, SQL, Stored Procedure, XML Parser, Update Strategy and more.
• Well versed in Extracting, Transforming and Loading from different Source systems to Warehouse system.
• Experience with BO XI R3, Web Intelligence, Desktop Intelligence, Dashboards, Scorecards, XCelsius.
• Expertise in OLAP BI tool in Designing & creating Universes, BO Reports using Business Objects.
• Working Knowledge in Informatica Developer tools with IDQ process.
• Experience in creating IDQ Profiles and Scorecards with IDQ rules.
• Knowledge in Informatica Data Validation Option (DVO).
• Experienced with ETL tools like Informatica and Teradata utilities.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling developing Database Schemas like Star flake schema and Snowflake schema used in relational, dimensional and multidimensional modeling
• Experience in Teradata with Fast Export, Fast Load, Multi Load, BTEQ.
• Experience in Trouble shooting and implementing Performance tuning at various levels such as source, Target, Mapping, Session and System in ETL Process.
• Conducted System, UAT and Functionality testing and investigated software bugs.
• Worked on UNIX shell scripts used in scheduling Informatica pre/post session operations.
• Worked with Oracle and SQL Server Stored Procedures, Triggers, Cursors and Indexes and experienced in loading data into Data Warehouse/Data Marts.
• Experience as a Data Analyst, Data Forensics, Trouble Shooting Problem Resolution.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6.1/9.5/9.1/8. X, Informatica Developer 9.6.1, Data Validation Option

Data Modeling: Physical/Logical Data Modeling, Erwin 7

Databases: Oracle 11g/10g/9i, SQL Server 2008, Teradata, MS Access 2000, TOAD, SAP BI

Reporting Tool: BUSINESS OBJECTS XI R2/R3 - CMC, Designer, Desk I, Web I and Infoview, Scorecards, Dashboards and Crystal Reports

Tools: & Utilities: BTEQ, Fast Export, Fast Load, Mload, Autosys

Testing Tools: Bugzilla, TestDirector, Quality Center

Programming: SQL, PL/SQL, Transact SQL, SAP ABAP, HTML, and XML

Environment: Windows2003, WinNT4.0,Unix

PROFESSIONAL EXPERIENCE:

Confidential, Windsor Mill, MD

Sr. ETL Developer

Responsibilities:

• Undergone HIPAA, PII, HHS rules and HealthCare information related training Sessions.
• Involved in Analyzing the requirements & Involved in designing and development of Complex Solutions.
• Prepared Mapping document & Technical Design document based on Business requirements & Data dictionary
• Conducted walk through on Technical Design document internally with the development team and also with technical leads, team leads and Data Architects.
• Worked extensively on Power Center Designer- used various transformations like Joiner, Lookup, Filter, Union, Update Strategy, Normalizer, Stored Procedures, SQL, etc. to implement the business logic.
• Developed Worklets and created Workflows in the Workflow Manager and promptly checked the status of the workflows in the Workflow Monitor.
• Created Server Schedule document for Tivoli Workload Schedule (TWS) job creation.
• Created and updated Test scenarios Document to conduct end to end testing while moving from Development to Validation and higher environments.
• Implemented Partitioning as part of performance tuning of the ETL load through Informatica.
• Verified Cognos reports to check the data being populated is accurate to crosscheck the ETL Data loaded.
• Involved in testing of different ETL processes while migration of Informatica from Solaris to Linux.
• Created and monitored the tickets in JIRA.

Environment: Informatica Power Center 9.6.1, Oracle 11g, Cognos, Solaris, Linux, JIRA

Confidential, Columbia, MD

Sr. ETL Developer

Responsibilities:

• Undergone HIPAA, PII, HHS rules and HealthCare information related training Sessions.
• Involved in Analyzing the requirements & Involved in designing and development of Complex Solutions.
• Prepared Technical Design document based on Business requirements & Mapping document.
• Conducted walk through on Technical Design document internally with the development team and also externally with client technical leads, team leads and Data Architects and DBAs.
• Worked extensively on PowerCenter Designer- used various transformations like Joiner, Aggregate, Java, Lookup, Filter, Union, Update Strategy, Stored Procedures, XML Parser, Unstructured Data (UDT), etc. to implement the business logic., Workflow Manager and Workflow Monitor.
• Created Rules, Profiles and Scorecards as part of Data discovery and Quality with Informatica Developer (IDQ).
• Prepared D-Plan (Deployment Plan) Document and conducted walk through while moving from Development to higher environments.
• Worked on POC (Proof of Concept) for Data Validation Option (DVO) in Informatica.
• Worked with Teradata Parallel Transport (TPT) external Loader connection for Bulk data download from IDR Teradata Data source to Oracle Warehouse.
• Coordinated with QA team in resolving the defects in HP Quality Center raised by the testers.
• Involved in Administration responsibilities during Installation and created User Roles and Groups.
• Performed Administrator Role providing Access Privileges and also Monthly Maintenance to Stop and Start the Informatica server from the UNIX.
• Migration of the Code from Informatica PowerCenter Repository Manager 8.6.1 to 9.1.0 and 9.1.0 to 9.5.1 and 9.5.1 to 9.6.1.
• Involved in Folder Migrations from one environment to the other environments.

Environment: Informatica Power Center 9.6.1/9.5.1/9.1/8.6.1, Oracle 11g/9i, Teradata V13, Cognos, UNIX

Confidential, Richmond, VA

ETL/ Informatica/ Teradata Technical Lead

Responsibilities:

• Involved in Analyzing the System requirements, in designing and development of data warehouse environment.
• Preparing TSD and ETL Specs based on BSD and Mapping document.
• Conducting walk through on TSD with client tech leads, team leads and Data Archs and DBAs
• Involved in development of the Code and executed Unit Test Cases.
• Prepared SDLC Work book and conducted walk through before moving to SIT, UAT and Production.
• Conducting weekly status meetings to discuss about the progress in that week.
• Creating job setup document for job scheduling tool WLM.
• Given Technical clarifications and assigned work to off-shore team and monitored the work status daily.
• Extracted data from Flat files, SQL Server and Oracle and loaded them into Teradata.
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Transformed bulk amount of data from various sources to Teradata database using BTEQ scripts.
• Transferred data using Teradata utilities like Fast Export, Fast Load and MLoad.
• Worked on WLM to automate and Schedule the Workflows and jobs.

Environment: Informatica Power Center 8.6.1/8.1.1, Teradata V12.0, SQL Server 2008, Oracle 11g/9iTOAD, WLM (Work Load Manager), UNIX AIX, IBM Mainframes, Windows XP.

Confidential, Bloomington, IL

ETL/ BO Consultant

Responsibilities:

• Working on Informatica tools like Source Analyzer, Mapping Designer, Warehouse Designer, Workflow Manager, and Workflow Monitor.
• Used various Transformations like Joiner, Aggregate, Java, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router etc. to implement complex logics while coding a Mapping.
• Involved in Data Profiling & Analysis on heterogeneous Databases like Oracle, SQL Server, DB2 & flat files.
• Involved in Universe designing in Business Objects with solving complex loops in Universes.
• Created reports using Business Objects functionality’s like Filters, Sections, Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae.
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
• Worked with complex queries for data validation and reporting using SQL and PL/SQL.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Involved in designing and development of pre and post session routines and batch execution routines.
• Implemented Performance tuning of the ETL by utilizing dynamic cache for Lookups partitioning the sessions.
• Worked on Autosys Scheduler to automate the Workflows.
• Tested all the mappings and sessions in Development, UAT environments and also migrated into Production
• Worked as a production support 24/7 on-call, for the nightly batch process.

Environment: Informatica Power Center 8.6/8.1.1, Business Objects XIR3, Teradata, SQL Server2008Oracle 11g/9i, DB2 8.x, PL/SQL, TOAD, Autosys Scheduler, Windows 2003 Server.