SUMMARY

• Seven years of Software Life Cycle experience in System Analysis, Design, Development, Implementation and Testing of Data Warehouse and Data Integration Applications in domains like Banking, Securities, Pharmaceutical and Insurance.
• Six (6 years of solid ETL (Extract Transform Load) Data Warehouse experience using Informatica PowerCenter 8.6/8.5/7.1.4/7.1.3/6.1 ).
• Expertise in Data Warehousing Concepts such as Ralph Kimball Methodology, Bill Inmon Methodology, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, and good understanding of Dimension Data Modeling using Erwin 4.2/4.0/3.5.5/3.5.2 , Microsoft Visio
• Experience in developing mappings using various transformations like Unconnected and Connected lookups, Router, Aggregator, Sorter, Ranker Joiner, Stored Procedure, Update Strategy and Re - usable transformations.
• Extensive knowledge in Folder creation, version migration from older version to teh latest version. Developed common logic using Reusable transformations and Mapplets.
• Good hands on knowledge in designing and developing Workflows, Sessions and other tasks using Work flow manager tools Task Developer, Workflow & Worklet Designer to handle different load scenarios
• System requirements analysis, ETL analysis and design, Data Modeling, Real time Data Integration, Client interactions, complete Data Warehouse project life cycle.
• Worked collaboratively wif teh Lead ETL Architect; developing ETL solutions which support defined system specifications and technical designs.
• Six years experience in Relational Databases like Oracle 10g/9i/8i/7.x, MS SQL Server 2000/7.0/6.5 , Sybase, SQL Server 12.0/11.x, Teradata, DB2 UDB, MS Access 7.0/2000, SQL, PL/SQL and SQL*Plus.
• Created BTEQ scripts and hands on experience in TD utilities such as FastLoad, FastExport, Multiload and Tpump.
• Experience in creating Test Plans, Test Cases and hands on experience in using HP Quality Center.
• Experience in Disaster Recovery planning, implementation & testing.
• Extensive experience in Production Support processes, Defect Management, Incident Management, and Change Management.
• Confident, persistent and ability to prioritize, organize and accomplish multiple tasks, both as part of a team and independently. Flexible in learning new systems, programs and procedures.
• Excellent communication skills, interpersonal skills, team player and well versed wif Software Development processes.

TECHNICAL SKILLS

ETL: Informatica PowerCenter 8.6/8.5/7.1.5/7.1.4/.1/7.0/6.1.2/6.1.1 (Repository Manager, Designer, Work Flow Manager, Work Flow Monitor), PowerExchange/Powerconnect, SQL Loader, DB2 Loader.

Data Modeling: Erwin and Microsoft Visio

Data Warehousing: Ralph Kimball Methodology, Bill Inmon Methodology, Dimensional Modeling, Star Schema, Snow Flake Schema, Fact Tables, Dimension Tables

Operating Systems: UNIX (Sun Solaris, HP, Linux), Windows 2000/98/95/3.1 , Windows NT, XP

GUI: Visual Basic 5.0/6.0, Visual InterDev 6.0, MS Excel, MS Word, SharePoint, SQL Navigator and TOAD

Databases: Oracle 10g/9i/8i,8 T-SQL, MS SQL Server 2000/7.0/6.5 , Sybase, SQL Server 12.0/11.x, Teradata, MS Access 7.0/2000, SQL, PL/SQL, SAP, DB2 UDB.

Languages: COBOL, C, C++, Java (Sun Certified Java Programmer), SQL, and PL/SQL

Scripting Languages: UNIX Shell Scripting, Perl Scripting

Job Scheduling: CA AutoSys

Internet Skills: Java Script, XML, PHP, HTML & DHTML

Testing Tools: HP Quality Center

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Senior ETL Developer

Responsibilities:

• Designed and developed teh processes to extract, transform and load data into teh Data Warehouse.
• Translated high-level design requirements of counting active FA’s into Detail design and ETL Mapping specifications. Involved in redesign of existing mappings in system, which do not meet teh exact functionality of counting FA’s. Parsing high-level design spec to simple ETL coding and mapping standards.
• Designed Mapping document, which is a guideline for ETL Coding and implemented CDC, SCDI & SCDII Mappings.
• Used SQL Loader in ODS and DB2 Loader in BDW when teh data was huge and loading was a straight load.
• Created and executed comprehensive unit test plans, develop test cases, assist wif integration and system test plans.
• Designed and developed Informatica Mappings to load data from various Source systems like Files, Relational, SAP R/3 into teh ODS, DW and then to teh Data Mart.
• Worked on Informatica PowerCenter - Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Mapplets and Reusable transformations were extensively used wherever required.
• Used Workflow Manager for Creating, Validating, Testing and running teh sequential and concurrent batches and Sessions and scheduling them to run at specified time.
• Executed all teh mappings and sessions in Development, Test, QA and Production Repositories using workflow Manager.
• Used Shell Scripts and PMCMD to interact wif Informatica Server and kicking teh jobs.
• Views are created and they are consumed by teh micro strategy tool to report teh Count of FA’s to teh Management.
• Benchmark testing of Hardware vs. Process Speeds for Informatica mappings to calculate teh lead times for batch processing.
• Worked in AGILE Methodology.

Environment: Informatica Power Center 7.1.2/Power Center 8.1/8.6, Oracle 9i/10g, MS SAP R/3, Power Exchange, DB2, Toad 9.5, Erwin 4.2, Unix, HP Quality Center and Autosys.

Confidential, Juno Beach, FL

Senior Informatica Developer

Responsibilities:

• Designed and developed teh processes to extract, transform and load data into teh Data Warehouse.
• Translated high-level design requirements of reliability indicators into Detail design and ETL Mapping specifications. Involved in redesign of existing mappings in system, which do not meet teh exact functionality of reliability indicator process flow criteria. Parsing high-level design spec to simple ETL coding and mapping standards.
• Designed Mapping document, which is a guideline for ETL Coding and implemented CDC, SCDI & SCDII Mappings wif error handling process.
• Created and executed comprehensive unit test plans, develop test cases, assist wif integration and system test plans.
• Designed and developed Informatica Mappings to load data from various Source systems like Files, Relational, SAP R/3 into teh Staging area, HUB and then to teh Data Mart.
• Worked on Informatica PowerCenter - Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Mapplets and Reusable transformations were extensively used wherever required.
• Using Informatica Designer designed Mappings dat populated teh Data into teh Target Star Schema, which is on Oracle Instance.
• Used Workflow Manager for Creating, Validating, Testing and running teh sequential and concurrent batches and Sessions and scheduling them to run at specified time.
• Executed all teh mappings and sessions in Development, Test, QA and Production Repositories using workflow Manager.
• Used Shell Scripts and PMCMD to interact wif Informatica Server from 4d-jobs (UNIX) tool.
• Benchmark testing of Hardware vs. Process Speeds for Informatica mappings to calculate teh lead times for batch processing.
• Develop data conversion, integration, loading and verification specifications and design of a Mapping Specification and creating multidimensional models.
• Setting of Error Logic for streamlining and automating teh data loads for cleansing and trapping incorrect data into error tables and re- loading it to teh data warehouse once errors are rectified.
• Involved in Informatica migration from version 7.1 to 8.6 and understood teh process thoroughly.

Environment: Informatica Power Center 7.1.2/Power Center 8.1/8.6, Oracle 9i/10g, MS SAP R/3, Power Exchange, SQL Server 2003, PL/SQL, Toad 9.5, SQL Plus, Erwin 4.2, Unix and 4D.

Confidential, Tempe, AZ

ETL Developer

Responsibilities:

• Designed and developed teh processes to extract, transform and load data into teh Data Warehouse.
• Designed, developed and documented multiple interfaces using Informatica ETL tool.
• Analyzed business requirements and worked closely wif teh various application teams and business teams to develop ETL procedures dat are consistent across all applications and systems.
• Developed PL/SQL procedures, functions, and packages.
• Developed materialized view for aggregate summary data.
• Requirement analysis in support of Data Warehousing efforts.
• Developed overall data transformation and extract design and strategy.
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer
• Creation of Transformations like Union, SQL, Sequence generator, Lookup, Joiner, Update strategy and Source qualifier transformations in Informatica Designer.
• Created Complex mappings using various scenarios for populating target table in efficient manner.
• Created Mapplets and used them in different mappings for maintaining teh standards/reusability.
• Created events and tasks in teh work flows using workflow manager
• Created BTEQ scripts to load data from staging to teh DW and to teh Data Marts.
• Developed Informatica mappings and also tuned them for better performance
• Designed strategy to extract daily incremental data.
• Created UNIX shell scripting to run teh workflow.
• Involved in Performance Tuning of Informatica mappings, SQL Query, views etc.
• Monitored job through Autosys application view and extensively involved in creating jobs for tool.
• Provided production support on a daily basis for teh load jobs.

Environment: Informatica Power Center 7.1.2/8.1.1 , Oracle 9i/10g, Teradata, Autosys, SQL Navigator and Toad 9.5.

Confidential, Bloomington, IL

Informatica/Oracle ETL developer

Responsibilities:

• Translated teh high-level design requirements of reliability indicators into Detail design and ETL Mapping specifications.
• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing, support and Documentation.
• Translated business requirements into data mart design and Analyzed teh source and target systems, met wif various levels of users to define teh requirements.
• Created data translation and migration plans. Interacted wif teh business community to explain teh migration plans and get approval.
• Created mappings using teh transformations such as teh Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, Update Strategy.
• Created and Monitored Batches and Sessions using Informatica Center.
• Managed teh Metadata associated wif teh ETL processes used to populate teh data warehouse.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.
• Extensively worked in teh performance tuning of teh programs, ETL Procedures and processes.
• Unit testing for all teh Mappings and Sessions
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations, Informatica Repository Manager and Informatica Server Manager. Teh objective is to extract data stored in different databases such as Oracle, SQL Server and to load finally into a single data warehouse repository, which is in Oracle.
• Used Shell Scripts and PMCMD to execute/schedule teh workflows wif Informatica
• Benchmark testing of Hardware vs. Process Speeds for Informatica mappings to calculate teh lead times for batch processing.
• Develop data conversion, integration, loading and verification specifications and design of a Mapping Specification and creating multidimensional models.
• Setting of Error Logic for streamlining and automating teh data loads for cleansing and trapping incorrect data on staging servers and then loading it to teh data warehouse and Populating teh warehouse.

Environment: Informatica Power Center 7.1.2, Oracle 9i, Teradata, UNIX Shell Scripts, SQL Navigator and Toad.

Confidential, Boca Raton, FL

ETL/Database developer

Responsibilities:

• Designed and developed teh processes to extract, transform and load data into teh Data Warehouse from heterogeneous sources.
• Designed, developed and documented multiple interfaces using Informatica ETL tool.
• Designing and developing teh requirement Specification through Interviewing, meeting, questioning teh user community.
• Assist team members in developing complex ETL using Informatica, SQL and UNIX Shell Scripts to meet data load requirements of business
• Meeting wif business users, project managers and technical teams to define requirements and specifications
• Work wif teh Data Warehouse Reporting team, Web Engineering team and Business Systems team to understand data sources and implement new requirements
• Coded Stored Procedures, Database Triggers and Functions and Packages using Dynamic SQL statements.
• Used various transformations like Lookup, Filter, Joiner, Aggregator, Expression, Router, Update strategy, Sequence generator in teh mappings
• Created unit test plans, test cases and reports on various test cases for testing teh developed Informatica mappings and also tuned them for better performance.
• Involved in database mapping creation and performance tuning.
• Designed and developed Informatica Mappings to load data from various Source systems like flat files, Xml, relational into teh Staging area, HUB and then to teh Data Mart.
• Designed and developed Unix shell scripts as part of teh ETL process to compare control totals, automate teh process of loading, pulling and pushing data from & to different servers.

Environment: Informatica PowerCenter 6.1/7.1, Oracle 8i, DB2, PL/SQL, UNIX Shell Scripting, Erwin, Sun Solaris, Toad, XMLSpy

Confidential

Database Developer

Responsibilities:

• Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
• Installed and configured Informatica 6.1
• Extensively used ETL to load data from source systems like Flat Files, DB2, Oracle, COBOL, ODBC, Excel Files and CSV Files into staging tables and load teh data into teh target database Oracle 8i.
• Developed Informatica mappings, reusable transformations. Developed and wrote procedures for getting teh data from teh Source systems to teh Staging and to Data Warehouse system.
• Extensively used transformations to implement teh business logic such as Sequence Generator, Normalizer, Expression, Filter, Router, Rank, Aggregator, LOOK UP (Target as well as Source), Update Strategy, Source Qualifier and Joiner, Designed complex mappings involving target load order and constraint based loading
• Create/build and run/schedule workflows and worklets using teh Workflow Manager.
• Optimizing/Tuning mappings for better performance and efficiency, Creating and Running Batches and Sessions using teh Workflow Manager, Extensively used UNIX Shell scripts for conditional execution of teh workflows. Optimized teh performance of Mappings, Workflows and Sessions by identifying and eliminating bottlenecks
• Performed Unit Testing at development level, Source code migration and documentation
• Performance Tuning of teh Informatica Mappings by adopting Explain plans, cutting down query costs using Oracle hints, changing teh mapping designs.
• Managed teh Metadata associated wif teh ETL processes used to populate teh data warehouse.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.
• Extensively worked in teh performance tuning of teh programs, ETL Procedures and processes. Coded database triggers, functions and stored procedures and written many SQL Queries. Helped coding shell scripts for various administration activities for daily backup. Involved in Physical schema implementation, objects like table-space, table rollback segments, Created database structures, objects and their modification as and when needed.
• Managed users & roles for database security, Maintained system security, control and monitor user access to database.
• Assigned predefined profiles and roles to teh users to maintain database security, CPU activity, idle time and quota management on table-spaces.

Environment: Informatica Power Center 6.1, Oracle 8i, DB2, PL/SQL, Erwin and Toad