SUMMARY

• Nearly 8 years of experience in IT in the areas of analysis, design, development in client server environment with focus on Data warehousing applications using ETL/OLAP tools like Informatica, Business Objects with Oracle, SQL Server, Teradata V2R5.1, DB2 databases and Netezza.
• Involved in complete software development life cycle (SDLC) of project with experience in domains like Healthcare Insurance, Automobile, Banking, Manufacturing and Pharmaceutical.
• Experience in business requirements gathering, define and capture metadata for business rules, system analysis, design, development, production support, testing, user training, and strategic decision making, problem solving associated with the ETL processes by working closely with BI team.
• Experience in developing Enterprise level datawarehouse, Data marts and Operational databases.
• Excellent knowledge and experience in data warehouse development life cycle, requirements analysis, dimensional modeling, Repository management and administration, implementation of STAR, Snowflake schemas; Incremental loads, Change Data Capture and slowly changing dimensions.
• Experience in creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism by using Informatica 9.1/8.6/7.x.
• Good knowledge in interacting with Informatica Data Quality (IDQ).
• Experience in source systems analysis and data extraction from various sources like Flat files, Oracle 10g/9i/8i, Teradata V2R5.1, DB2 UDB.
• Experience in writing complex sub queries, PL/SQL programs (functions, procedures, packages), stored procedures, and shell scripting to run pre session and post session commands.
• Worked with heterogeneous data sources like Oracle, SQL Server 2008/2005, Teradata V2R5.1, flat files, XML files, DB2 UDB, Main Frames and COBOL files.
• Used Metadata Manager to extracts metadata from application, business intelligence, data integration, data modeling, and relational metadata sources.
• Perform error handling as part of production support on Informatica as well as Unix.
• Experience in performance tuning of sources, transformations, targets, mapplets, mappings, worklets, workflows, sessions and batches
• Experience in working with Logical and Physical data models.
• Expertise in using GUI tolls like Erwin, Toad, SQL Developer, SQL Navigator and SQL *Loader.
• Excellent communication skills, team player, ability to work individually and meet tight deadlines.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.6/7.x Informatica Power Exchange 5.1/4.7/1.7, Power Analyzer 3.5, Informatica Power Connect, Informatica Data Quality and Metadata Manager.

Databases: Oracle 11g/10g/9i/8i/8.0/7.x,Teradata,DB2 9.7, MS SQL Server 7.0/2000/2005 Netezaa 4.0 and Sybase ASE 12.5.3/15.

Operating Systems: UNIX (Sun - Solaris, HP-UX), Windows NT/XP/Vista, MSDOS

Programming: SQL, SQL-Plus, PL/SQL, UNIX Shell Scripting (Korn, C), COBOL, C++, Java

Reporting Tools: Business ObjectsXIR 2/6.5/5.0/5.1 , Cognos Impromptu 7.0/6.0/5.0, Informatica Analytics Delivery Platform, MicroStrategy.

Modeling Tools: Erwin 4.1 and MS Visio

Other Tools: SQL Navigator, Rapid SQL for DB2, Quest Toad for Oracle, SQL Developer 1.5.1, Autosys, Telnet, Serena Dimensions Version Manager, MS SharePoint, Mercury Quality center, Team Track.

Methodologies: Ralph Kimball.

PROFESSIONAL EXPERIENCE

Confidential, Eagan, MN

Sr. Data warehouse Consultant

Responsibilities:

• Worked with DBA’s and Architects in Designing the Landing Strip for Confidential .
• Worked on the Confidential for making table catalogs for the end user.
• Worked with business team and architects to translate business requirement into technical design.
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Developed mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Update strategy and Normalizer for XML file.
• Involved in Performance tuning by finding bottlenecks like lookups for better performance.
• Worked on the Data Quality with IDQ.
• Participated in bi-weekly end-user meetings to discuss data quality, performance issues and ways to improve data accuracy and new requirements, etc
• Involved in Unit, System integration, User Acceptance Testing of Mappings. Wrote complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.
• Responsible for Creating workflows and worklets. Created Session, Event, Command, and Control Decision and Email tasks in Workflow Manager.
• Created UNIX scripts to generate Email Notifications and to load data from different Source systems like flat files and Oracle databases (ETL) and to schedule workflows.
• Created high-level Technical Design Document and Unit Test Plans.
• Documented Informatica mappings, design and validation rules.

Environment: Informatica Power Center 9.1, Informatica Data Quality, Oracle 10g/9i, DB2 9.7, SQL, PL/SQL, Java, XML, UNIX, Confidential 8.2/8.5

Confidential, Auburn Hills, MI

Sr. Data warehouse Consultant

Responsibilities:

• Worked with DBA’s and Architects to design the logical and Physical model for DWH.
• Worked with business team and architects to translate business requirement into tech design.
• Guided developers for successfully implementation of tech design.
• Developing several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using both the Informatica Power Center and IDQ
• Used Change data capture (CDC) for data integration that is based on the identification, capture and delivery of the changes made to enterprise data sources
• Developed mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Update strategy and Normalizer for XML file.
• Modified the existing ETL code (Mappings, Sessions and Workflows) and Perl scripts as per the user requirements.
• Involved in Performance tuning for better performance.
• Participated in weekly end-user meetings to discuss data quality, performance issues and ways to improve data accuracy and new requirements, etc
• Involved in Unit, System integration, User Acceptance Testing of Mappings.
• Wrote complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.
• Responsible for the developing ETL process/Programs with Informatica power center to extract data from client’s operational databases Transform and filter the data and load it into target data base.
• Responsible for Creating workflows and worklets. Created Session, Event, Command, and Control Decision and Email tasks in Workflow Manager.
• Worked with Informatica MDM for synchronizing the data in database.
• Created stored procedures.
• Created Perl scripts to generate Email Notifications and to load data from different Source systems like flat files and Oracle databases (ETL) and to schedule workflows.
• Created high-level Technical Design Document and Unit Test Plans.
• Documented Informatica mappings, design and validation rules.
• Worked on Business Objects XIR2 suite using Desktop Intelligence, CMC, Web Intelligence reporting and Publisher.

Environment: Informatica Power Center 8.6/7.1.4, Informatica Data Quality,Informatica MDM, Oracle 10g/9i, Teradata, Business Objects XIR2, SQL, PL/SQL, TOAD, Perl, UNIX, Clearcase, XML, Tivoli workload scheduler and Erwin 4/3.5.2

Confidential, Omaha, NE

Sr. Informatica Developer

Responsibilities:

• Involved in Analysis, Requirement Gathering with business users and Design process.
• Used Metadata Manager Web application to browse, analyze, and manage metadata from disparate metadata repositories.
• Extracted data from flat files, VSAM, XML and RDBMS systems like Oracle, Netezaa, SQL server and DB2 systems.
• Developed number of complex Informatica mappings and mapplets to implement business logic.
• Developed Informatica mappings by usage of Aggregator, SQL Overrides in Lookups, filter in Source Qualifier, and data flow management into multiple targets using Router transformations.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, Normalizer and Union to develop robust mappings using the Informatica Designer.
• Created Connected, Unconnected and Dynamic Lookup transformations to implement the logic efficiently.
• Used change data capture (CDC) to determine (and track) the data so that action can be taken using the changed data.
• Worked on as integration program for the Datawarehouse implementation.
• Used Informatica Power Exchange to connect to IBM Mainframe system (JCL, Cobol Files) and JMS (Java Messaging Services).
• Re-write IBM mainframe ETL jobs to Informatica.
• Worked on both OLTP and OLAP systems and wrote PERL scripts to perform ETL operations
• Performed Error log analysis of Mock Conversion runs and provided Load summary reports.
• Involved in Unit testing, System testing and capturing the test results.
• Provided Production support for the production issues by troubleshooting the session logs, bad files, tables and mappings.

Environment: Informatica Power Center 8.6/8.1, Informatica Power Exchange, Metadata Manager, Oracle 10g/9i, SQL Server 2005, PL/SQL, Netezza, TOAD, SQL Developer, DB2, Microsoft Access, Perl, HP/UNIX, Mercury Quality Center, Share Point and TeamTrack.

Confidential, Santa Clara, CA

Data warehouse Consultant

Responsibilities:

• Coordinating with the Business team to gather user/system requirements and convert them to Technical Specifications.
• Coordinated and perform lead duties with offshore team.
• Developing Business System Requirements (BSR), High Level Design documents (HLD), Low Level Design documents (LLD) for each Application.
• Create Logical and Physical data models in staging database using Erwin tool.
• Used Informatica Power Exchange to connect to IBM Mainframe systems (JCL, Cobol Files), JMS (Java Messaging Services) to access data in various formats such as VSAM, IMS and IDMS.
• Performed data cleansing to support data conversion activity from source to targets.
• Used Metadata Manager to browse and search metadata objects, trace data lineage, analyze metadata usage, and perform data profiling on the metadata in the Metadata Manager warehouse.
• Used metadata and metamodel asset inventory reports to locate data and integration process assets to aid data discovery and audit reporting for regulatory compliance and data governance.
• Designed/developed Stored Procedures for data mappings to implement complex business logics and called from Informatica Stored Procedure Transformations.
• Created PL/SQL scripts, Cursors, Triggers, Functions, Packages and involved in Performance tuning of the databases.
• Developed complex mappings to load data from Source System (RDBMS), XML files and flat files.
• Worked on as integration program for the Datawarehouse implementation.
• Employed different transformations like Normalizer, Stored Procedure, Update Strategy, Lookup, Router, Filter, Sequence Generator, Sorter, Expression transformations in Informatica mappings.
• Created Reusable transformations, Mapplets and Informatica Worklets for use in multiple mappings and workflows using Informatica PowerCenter Designer and Workflow Manager.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance
• Worked as an ETL Admin on a short term basis, Created Folders, new Connections for existing folders, new user addition/privileges requests and provide Power Exchange connections.
• Write Perl scripts to schedule workflows and run ETL jobs. Generate Email Notifications and to load data from different Source systems like flat files and Oracle databases.
• Made changes to the existing Informatica Mappings/Objects using Informatica Versioning.
• Involved in Unit testing, System testing and capturing the test results.
• Wrote Pre-SQL and Post-SQL scripts in Informatica sessions for complex logics.

Environment: Informatica Power Center 8.1, Informatica Power Exchange, Metadata Manager, Oracle 10g/9i, SQL Server 2008, Teradata V2R5.1, PL/SQL Procedures, TOAD, SQL*Loader, UNIX, Autosys, Rational Clearcase, MS Visio and Erwin 7.

Confidential, Hartford, CT

ETL Developer

Responsibilities:

• Developed mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Update strategy and Sequence generator.
• Created Sessions and Workflows to load data from the IBM DB2 UDB 8 databases that were hosted on HP UX 11i RISC server.
• Involved in developing design documents and mapping documents.
• Developed complex mappings to load data from Source Systems (Oracle 9i, DB2, and SQL Server 2000) to EDW in Oracle database using various oracle utilities.
• Modified the existing ETL code (Mappings, Sessions and Workflows) and the shell scripts as per the user requirements.
• Involved in production support.
• Resolved issues that cause the production jobs to fail by analyzing the ETL code and log files created by the failed jobs on the Informatica server.
• Created different transformations like Source Qualifier, Expression, Router, Filter, Lookup, Sequence Generator, XML, Normalizer transformations for loading the data into the targets.
• Wrote complex SQL scripts to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.
• Wrote pre-session and post-session commands/Unix scripts for the workflows to capture the metadata from the Session logs for auditing purposes.
• Wrote scripts to ensure e-mails sent to respective people on Failure/Success, error handling, control/auditing of different processes.
• Migrated objects from the development environment to the QA/testing environment to facilitate the testing of all objects developed and check their consistency end to end on the new environment.
• Trained and mentored two resources.
• Worked on as integration program for the Datawarehouse implementation.
• Experience in using Erwin tool for designing of data model.
• Extensively involved in unit testing, integration testing and system testing of the mappings and writing Unit and System Test Plan
• Used Test Director for tracking the issues encountered during the test cycle.
• Used the VSS for versioning the various objects like the mappings, Sessions, workflows, sql scripts and UNIX scripts.
• Was involved in gap analysis and analysis of data for creation of test data and improving data quality by embedding logic in mapping programs.
• Participated in weekly end user meetings to discuss data quality, performance issues and ways to improve data accuracy and new requirements, etc.,

Environment: Informatica PowerCenter 7.1.1, HP-Unix 11i, Oracle 9i, IBM DB2 UDB 8, Microsoft VSS, TOAD, CA7 Scheduler, Test Director

Confidential, Indianapolis, IN

Informatica Developer

Responsibilities:

• Designed, developed and maintained ETL Code to meet the requirements of the Business Intelligence group.
• Involved with the support for the production jobs that run at particular schedules.
• Resolved issues that cause the production jobs to fail by analyzing the ETL code and log files created by the failed jobs on the Informatica server.
• Automated the production jobs by scheduling them to run at particular schedules using the Informatica Scheduler.
• Performed daily maintenance operations on the Informatica Servers (Production, QA and Development) like monitoring the size, monitoring the log files and cleaning the logs that are older than a particular period using shell commands and scripts.
• Took Backup of the repositories at weekly intervals.
• Involved with running shell scripts and sql scripts as part of resolving any of the production issues.
• Used Repository manager to create, delete and edit Repository User groups, Users and managed users by setting up their privileges and profiles.
• Used pmcmd commands for server maintenance.
• Modified the existing ETL code (Mappings, Sessions and Workflows) and the shell scripts as per the user requirements.
• Involved with migrating ETL code from Dev to QA and from QA to production.
• Involved in analyzing the data files that come from an external source on a daily basis.
• Interacted and coordinated closely with the DBAs in resolving the database issues that lead to production job failures.

Environment: Informatica Power Center 7.1, Oracle 9i, UNIX Solaris, Sql Navigator (TOAD) and Autosys.