SUMMARY

• Ten years of total IT experience working on design, development, maintenance and supporting software applications.
• Over seven years of strong Data Warehousing experience.
• Implemented star, snowflake schemas, fact and dimensions tables, incremental loads and slowly changing dimensions.
• Excellent knowledge and experience in data warehouse development life cycle that includes requirements analysis, data profiling, dimensional modeling, repository management and administration, design, development, testing, documentation and deployment of ETL processes.
• Experience analyzing and working with various sources like fixed width/delimited/XML files, Oracle, SQL Server, Mainframe and DB2 databases.
• Experience in Performance Tuning of sources, transformations, targets, mappings, worklets, workflows, sessions, batch loads and queries.
• Extensively used Kimball theory to design logical and physical data models using star and snow - flake schemas.
• Provided level 1 on call support and worked on maintenance of BO universes and ETL processes.
• Experience in UNIX Shell and Perl Scripting.
• Experience in writing and tuning complex sub queries, SQL, PL/SQL stored procedures, functions, and triggers.
• Excellent experience in managing Informatica Administration activities like installation, folder to folder copy, moving files between various environments, version control, repository creation/backup and metadata backup.
• Extensive experience in Unit Testing, System Integration Testing, Performance Volume Testing and User Acceptance Testing of the operational data sources and enterprise data warehouse.
• Experience in project tracking, project management and team coordination.
• Strong project orientation with excellent team involvement, client coordination and good written and verbal communication skills.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.1.0/8.6.1/8.1/7.1.4/6.2/5.1, PowerMart 5.1, Informatica Power Exchange, Power Connect, Data Stage

Databases: Oracle 10g/9i/8i, SQL Server 2008 R2/2005/2000, Teradata, Netezza, DB2, IBM Mainframe

Database Tools: Enterprise Manager (EM), Query Analyzer, SQL Profiler, SQL Loader, SQL Plus, Toad, MS Server Management Studio for SQL Server/DB2 databases, SQL Assistant for Teradata

OLAP Tools: Business Objects, Crystal Reports, Cognos

Designing Tool: Erwin Data Modeler

Languages: SQL, PL/ SQL, Korn Shell, Perl, C++, C, COBOL, Java, JCL

Operating Systems: Windows95/98/2000/NT, MS DOS, UNIX, Linux, AIX, Solaris

Scheduling Tools: Workload Automation, ESP, Tivoli, CA 7

Other Tools: Trillium, Mercury Quality Center, Rational Clearcase, MS-Word, MS-Excel, MS-Visio, Enterprise Architect, Power Center Mapping Architect for Visio, ProChain Enterprise

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Sr. ETL Consultant

Responsibilities:

• Working on performance tuning of ETL mappings to improve the performance of the application.
• Coordinating with the client and the offshore team.
• Validating business logic with the client on the Customer and Worker alignments.
• Responsible for creating project plans and delivery using ProChain Enterprise.
• Working on enhancements of ETLs as Lilly goes global.

Confidential, Charlotte, NC

Sr. ETL Support Analyst

Responsibilities:

• Provided on call support to all the HR Mart applications.
• Documented standard operating procedures, application level documents for production support team.
• Coordinated with the Business Users for ad-hoc enhancement requests and for all existing applications.
• Involved in project deployments.
• Worked on the stored procedure to create Batch Load ID for every job run and validate the record counts from the source and target tables.
• Modify and re-develop existing interfaces to remove bugs and increase efficiency of the applications.
• Log service requests and resolve the issues reported by the clients.

Environment: Informatica Power Center 9.1.0, SQL Server 2005/2008,SQL Server Management Studio ESP Scheduler, SQL, PL/SQL, Perl, Enterprise Architect, MS Visio, Power Center Mapping Architect for Visio, Windows XP, Sun Solaris UNIX.

Confidential

Sr. Informatica Consultant

Responsibilities:

• Involved in analyzing, design and solution delivery for the data load design.
• Worked closely with the data architect and the users to design the interfaces and data loads to ODS and Data Warehouse.
• Designed the batch processes to handle the ETL batch jobs across all the interfaces.
• Worked on Informatica Administrator to perform admin tasks.
• Worked on Enterprise Architect to design the Batch Load Process, data flow and the ETL Loading strategy.

Environment: Informatica Power Center 8.6.1/9.1.0, SQL Server 2005/2008,SQL Server Management Studio ESP Scheduler, SQL, PL/SQL, Perl, Enterprise Architect, MS Visio, Power Center Mapping Architect for Visio, Windows XP, Sun Solaris UNIX.

Confidential, Indianapolis, IN

ETL Team Lead

Responsibilities:

• Involved in gap analysis, SD, SI and testing phases of the ETL and Microsoft Biztalk processes.
• Worked closely with the data architect and the vendor on the interface design.
• Worked on informatica mappings and Biztalk maps and led a team of ETL Developers, Biztalk Developers and Test Analysts.
• Created and used Shell scripts for running workflows and generated log files for the ETL process.
• Worked on creating test data for data quality testing.
• Created documents for ETL interface specifications, technical design, Requirements Traceability Matrix (RTM), Security Supporting Document.
• Performed unit testing, integration testing and system testing ofInformatica and Biztalk processes.
• Designed processes to get data from different source systems/Siebel Source Systems/SAP system via Informatica and ESB mappings and used file comparison logic to create delta load.
• Designed and developed error handling process to simplify time taken to support the system.
• Involved in fine tuning queries for better performance (includes indexing, pre-joining and materializing views, database partitioning).
• Involved in executing test cases, verifying results and logging defects in the Mercury Quality Center during the QA process.
• Involved in system integration testing, performance volume testing and user acceptance testing.
• Worked closely with business, SMEs, data architects and mainframe developers to assess business needs and implement solutions within the data warehouse.
• Extensively worked on UNIX, TOAD and SQL Plus.

Environment: Informatica Power Center 8.1/8.6, Microsoft Biztalk 2005/2009, Oracle 10g, TOAD for Oracle, Nexus, CA7 scheduler, Workload Automation, SQL, PL/SQL, Shell, MS Visio, Windows XP, Sun Solaris UNIX, LINUX, Mercury Quality Center 9.5.

Confidential, Auburn Hills, MI

Sr. ETL Developer

Responsibilities:

• Involved in gap analysis, SD, SI and testing phases of the ETL process.
• Worked closely with the data architect on the schema design and table definitions.
• Extensively worked on star schema and snowflake schemas and modified existing schemas to meet the business requirements.
• Worked on creating profiles in Data Explorer to validate data from various source systems.
• Transformations used in Informatica Power Center are: connected & unconnected lookups for slowly changing dimensions, routers to route the data to various targets, expressions to modify data, source qualifiers to get selective data, aggregators to group data, filters to filter unwanted data, sequence generators to generate data sequences, normalizer to normalize data, connected & unconnected stored procedures, joiners to join heterogeneous sources and update strategy to update the target tables.
• Used Fast Export connectors in Informatica to extract data from Teradata into Oracle data warehouse.
• Used Teradata SQL Assistant for querying the Teradata source database.
• Data extracts were done using BTEQ and Fast export connectors.
• Used mapping variables in power center to reference and record values in mappings, and passed parameter files in sessions to reassign variable values.
• Extensively used PL/SQL stored procedures and functions.
• Created and used Perl scripts for running workflows and generated log files for the ETL process.
• Created documents for ETL interface specifications, technical design and unit test plan. Performed unit testing, integration testing and system testing ofInformatica mappings.
• Involved in fine-tuning queries for better performance (includes indexing, pre-joining and materializing views, database partitioning).
• Involved in executing test cases, verifying results and logging defects in the Mercury Quality Center during the QA process.
• Worked closely with business, SMEs, data architects and mainframe developers to assess business needs and implement solutions within the data warehouse.
• Worked on UNIX, TOAD and SQL Plus.

Environment: Informatica Power Center 7.1/7.1.4/8.5, Informatica Power Exchange 8.1 Business Objects 6.5/XI, SQL Server, Oracle 10g, Teradata, TOAD for Oracle/SQL Server, Tivoli Workflow scheduler, SQL, PL/SQL, Perl, Rational Clearcase, MS Visio, Windows XP, Sun Solaris UNIX, Peregrine Support Center.

Confidential, Arlington, VA

Sr. ETL Developer

Responsibilities:

• Involved in analysis, design, development & deployment of ETL for the data warehouse.
• Designed and developed source to target mappings using Informatica PowerCenter.
• Troubleshoot errors in mappings by checking session and error logs. Also used debugger for complex problem troubleshooting.
• Implemented business logic using PL/SQL stored procedures, functions and cursors.
• Modified power cubes and power play reports as per the requirement.
• Developed several complex reports featuring multiple prompt selections, drill through and sub reports.
• Created ad-hoc reports using Query Studio and complex reports using Reports Studio in Report Net.
• Created business mix reports, trend over time reports and forecast reports using Powerplay.

Environment: Informatica Power Center 7.1.3, Oracle 9i, PL/SQL Procedures, SQL Server, Erwin 4.0, TOAD, SUN OS, Windows NT, Rational Clearcase, Autosys, TOAD, MS Visio, Cognos Suite 6.5,AIX.

Confidential, Hartford, CT

Informatica Consultant

Responsibilities:

• Involved in data design and modeling by specifying the physical infrastructure, system study, design, and development by applying Ralph Kimball methodology of dimensional modeling using ERwin.
• Involved in upgrading the informatica version from 5.1 to 6.2.
• Involved in unit testing of mappings, mapplets also involved in integration testing and user acceptance testing.
• Extensive experience working with facets data.
• Experience using the Cadillus interface to calculate the amounts.
• Created Universes and reports using Business Objects.
• Created Classes, different kinds of Objects, Cardinalities and Strategies as a part of Universe development.
• Used Repository manager to create Repository, User groups, Users and managed users by setting up their privileges and profiles.
• Worked on admin console to install, upgrade and configure informatica and to manage user permissions,.

Environment: Informatica 7.1.1/ 6.2, Business Objects 5.1 (Reporter, Designer, Supervisor, Broadcast Agent, Web Intelligence), Facets 4.3, Cadillus UI, UNIX, SQL Server DTS, Oracle9i/8i, DB2-UDB.

Confidential 

ETL Developer

Responsibilities:

• Involved in business analysis and technical design sessions to develop requirements document and ETL specifications.
• Developed standard mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter, lookup transformation to access data from tables and used unconnected lookup to improve performance.
• Configured the mappings to handle the updated records using update strategy transformation.
• Generated reports using Business Objects.
• Created the reports using functionalities like queries, slice & dice and drill down.
• Precise documentation was done for all mappings, workflows and reports.

Environment: Informatica PowerMart 5.1, PL/SQL, Oracle 8i, Business Objects, UNIX, Windows 2000.