Dedicated, Result Oriented and strong Lead ETL programmer with excellent logical and communication skills, seeking a challenging and rewarding career in Decision Support Environment that leverages my technical strengths to gain accelerated growth.

Summary:

• 8+ years of Total IT experience in analysis, design, development, testing and support of Data warehousing projects in various verticals - Investments (Nationwide), Medical (Blue Cross Blue Shield), Banking (Wells Fargo), Pharmaceutical (Abbott, Pfizer) , Insurance (Ameri-Choice) and Telecom (Quest Co).
• 7+ years of Extensive Data warehousing experience using Informatica Power Center 8.6/7.1.4/7.1.2/6.1.2/5.1.2, Informatica Power Mart 6.1.2/5.1.2/5.0(Source Analyzer, Data warehousing Designer, Mapping Designer, Mapplets, Transformations), Power Connect, Power Analyzer.

Skills & Knowledge Matrix

ETL Tools

Informatica Power Center 8.6/7.1.4/7.1.2/6.1.2/5.1.2, Power Mart 6.1.2/5.1.2/5.0 (Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet, Transformations), ETL, Athanor (Informatica Data Quality), Metadata, Data mart, OLAP, OLTP, SQL*Plus, SQL*Loader, PMCMD.

Business Intelligence

Business Objects 6.0/5.1/4.5, Cognos 7.0 , Crystal Reports, MS Access Reports, Oracle Developer (Forms and Reports)

Data Modeling

Dimensional modeling, Star-Schema Modeling, Snow-flake Modeling, FACT and dimension tables, Logical / Physical designs, ERWIN4.5/4.0, Oracle Designer.

Databases

Oracle 10g/ 9i/8i/7.x,
MS SQL Server 2000/7.0/6.5, MS Access 2000,
TeraData V2/R4 , Netezza, DB2 UDB v8.1/ v7.2

Operating Systems

MS DOS, Unix, Windows (XP/2000/NT 4.0), Sun Solaris 2.6/2.7, HP-UX 11.11

Programming

SQL, PL/SQL, UNIX Shell Scripting, Java, C, C++, SQL*Plus, HTML, T-SQL, Visual Basic 6.0, Toad 6.X. Perl

Others

Activity Diagrams, Sequence Diagrams, State Chart Diagrams, SQL-Navigator, Toad, AQT, MS-Project, MS-Office, Autosys, Cron Scheduler, Tidal, Maestro.

Professional Experience:

Client: Confidential
Columbus, OH

Role:Lead ETL Developer

Oct '06 - Current

Environment: Informatica Power Center 8.6/ 7.1.4/6.2,Oracle 9i/10g , SQL Server 2000, Erwin 4.2, Business Objects 6.5, Power Analyzer, PAM Pervasive, Eagle Pace, Informatica Metadata Reporter, Visio 2000, Windows NT 4.0.

Nationwide - OOI (Office of Investments) is the financial Investments wing of Nationwide. PROSPER is a Integration Project which significantly improves efficiencies of Nationwide Investments by establishing and automating business processes between the front, middle and back offices. This will allow investment professionals to focus on their core competencies and make better, faster decisions. PROSPER is a multi-project, multi-release approach, aligned with the concepts in Nationwide's Enterprise Solution Delivery (ESD) Framework.

• Created Domain specific Target definitions and maintained common Objects which are used by DWH environment based on star schema (CIM) design and developed aggregate tables to accommodate storage of summarized data.
• Acquired strong domain knowledge, which in-turn helped in providing quick ETL solutions for various applications/sources like Bloomberg, Merrill, Lehman, PAM, PAS, ALFA (Asset management system), Nationwide Bank, LMS (Loan Mortgage system), FIE, ALTSTRAT (Alternate Strategies) and INV.
• Developed front-end / Back End applications for business users to enter data via Oracle Application Express (APEX) and handled ETL process.
• Created Data Profiling for the source mappings for trapping the data related issues.
• Designer and Transformation Developer) for creating Sources, Targets, Mappings, Reusable Transformations and Mapplets.
• Customized the data by adding filters, sorters, aggregators, formulation of join strategy, lookups and update strategy.
• Created mappings to and from various homogeneous and heterogeneous databases.
• Migrated mappings, sessions, and common objects from development to test and to production.
• Developed numerous complex Informatica mappings, mapplets and reusable transformations for the Product Line Profitability Systems to facilitate daily, monthly and yearly loading of data.
• Extensively involved in creating, enhancing and maintaining several activities of Data Warehouse for modifying target tables as per requirement.
• Improved the session performance by optimizing workflows and partitioning sessions.
• Worked in conjunction with the Data Operations and support team's in collecting the performance metrics and run stats to address the performance concerns and to reduce the nightly flow run time to meet the SLAs of the Business users.
• Prioritizing the enhancements, bug fixes appropriately and handing off to developers in a timely manner.
• Convert TQSL and PL/SQL code into ETL mappings thus bringing transparency to ETL code as per business needs.
• Generated SQL Loader scripts and shell scripts for automated daily load processes.
• Maestroscript development for scheduling daily, monthly jobs based on ETL dependency.

Client: Confidential, Detroit, MI

Role:Lead ETL Developer

Feb '05 - Oct '06

Environment:Informatica Power Center 7.1.3, Erwin 4.2, Power Connect, Power Exchange, Athanor, Oracle 10G, PL/SQL, Unix Shell Scripting, SQL, Unix, Windows NT 4.0/2000, Sun Solaris Unix.

Blue health Intelligence (BHI) warehouse is a centralized warehouse which maintains data related to all claims, pharmacy related and member related data. The BHI Project enables mid and senior management with market intelligence/sales data that enable them to effectively collaborate and compete for national accounts.

• Translate Business Requirements to functional specifications (ETL Documents) for the development of Informatica mappings to load data into various tables and defining ETL standards.
• Designed and developed ETL integration processes using Informatica Power Center and Power Exchange.
• Extensively created Mappings, Mapplets, Sessions, Worklets, Reusable components and Workflows.
• Design, Develop, test and Schedule ETL load process for the data warehouse loading as per business requirements.
• Develop and Publish Meta Data Reports from ETL, Database and Reporting for ABC (Audit, Balance and Control) needs.
• Review code, Test Cases and Mentor Junior ETL Programmers.
• Extensively used almost all of the transformations of Informatica such as the Source qualifier, Aggregators, Connected & unconnected lookups, Filters & Routers, Update Strategy.
• Actively take ownership for Change Request's (CR) and work with business, IT teams and develop both quick fixes and long term solutions.
• Tuning badly performing ETL Components thru redesigning at O/s, Tool and Database Level.
• Develop UNIX scripts for Merge, Archiving and Validation for ETL Loads.
• Publish ETL Anomaly Reports using Reformat and Discovery (Corporate data Analyzing tool) for analyzing the data.
• Create Test Plans and Test cases by cross mapping ETL code to Spec document and Performed Unit, System and Integration Testing.
• Demonstrate Consistent Expertise in Quick Root Cause analysis and providing fixes the ETL issues.

Client: Confidential, Columbus, Ohio

Role:Sr. ETL Developer

Jan '04 - Jan '05

Environment:Informatica Power Center 7.1.2/6.1.2, Erwin 4.2, Power Connect, Power Analyzer, SQL Navigator, SQL Server 2000, Oracle 9i, PL/SQL, Unix Shell Scripting, DB2 8.0, SQL, Unix, Business Objects 6.5, Toad 6.X, Windows NT 4.0/2000, HP-UNIX.

Abbott Nutrition is a health care company devoted to discovering medicines, technologies and new ways to manage health. Their products span the continuum of care, from nutritional products and laboratory diagnostics through medical devices and pharmaceutical therapies. CDW (Consumption Data Warehouse) project which deals with Factorized Sales, Shipment, Stores and external (third party) data.

Responsibilities:

• Involved in Business Analysis and Requirements Gathering, Development, Testing and Deployment at various phases of the project.
• Created 100+ mappings using Power Center's mapping designer. Also used Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, Sessions and Workflows.
• Extensively used almost all of the transformations of Informatica such as the Source qualifier, Aggregators, Connected & unconnected lookups, Filters & Routers, Update Strategy.
• Tweak existing mappings for better performance and also to apply new businessrules as per changed business requirements.
• Implement End to End upgrade solution for all business units from 6.2 to 7.1 version of Informatica.
• Design and Implement ETL batch load processes for Daily, weekly and Monthly Loads.
• Migrated mappings, sessions, and common objects from development to test and to production.
• Optimized Informatica mappings for performance improvement at mapping, transformation, and session and database level.
• Developed Interfaces using UNIX Shell Script to automate the bulk load.
• Extensively involved in the analysis and tuning of SQL statements using EXPLAIN PLAN, SQL Trace, and TKPROF.
• Designed and developed Reports using Business Objects 6.5.
• Developed BO Universes using Designer and Business Objects for the reporting system
• Performed incremental aggregation to load incremental data into Aggregate tables.
• Used Calculations, Variables, Break points, and Sorted inputs, Filters, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Developed data mart that is very helpful in deriving various reports such as Shipper Profile with various granularities, Monthly & Weekly Cases, Volume/Revenue, Competitors etc.

Additional Professional Experiences: (1999 - 2004)

• Confidential, New York, NY - ETL Developer - Sep '03 - Dec '04
• Confidential, Phoenix, AZ - Informatica Developer - Mar '02 - Aug '03
• Confidential, Denver, CO - ETL Developer - Jan 2001 - Feb 2002
• Confidential, Hyderabad, India - Database Developer - Jul '99 - Dec '01

Education /Certification

Bachelor of Engineering in Electronics Certified in Data Warehousing Concepts. Certified Informatica Designer