SUMMARY

• 10+ years IT experience.
• Good Exposure in all phases of data warehousing life cycle including planning, analysis, design, development, testing.
• In my data warehousing career have played various roles from Developer to Architect and have got extensive experience in ETL Informatica PC 7.x/8.6.1/9.1 and DataStage 6.0/7.0/7.5. x/8.1
• Hands on experience in handling/processing large volume of data in business critical environments.
• Extensively involved in Requirement Gathering, Data Model Design and Technical Design.
• Extensive database experience using Oracle 10g/9i/8i, UDB DB2, MS Access, SQL, PL/SQL, SQL*Plus, SQL*Loader and TOAD.
• Good in Data Analysis, Data Profiling, Data Management, Troubleshooting, Reverse Engineering and Performance tuning in various level of ETL Process.
• Have good experience in offshore/onsite model.
• Strong Experience in Manufacturing Domains.
• Designed and Prepared Functional specification documents, Technical specification documents, Mapping Documents for Source to Target mapping with ETL transformation rules.
• Followed and Implemented Best Practice methodologies.
• Experience in development and effective implementation of Data cleansing, Data acquisition and Data integration tasks using ETL tool Informatica/DataStage.
• Strong skills in design and implementation of Star Schema and Snowflake Schema used in Dimensional and Multidimensional modeling.
• Expertise in Unix shell scripting on AIX, Sun Solaris on Korn, C and Bourne Shells for scheduling jobs.
• Having good experience in large volume of data, Complex business logic and Aggressive deadline environments.
• Proactive and self starter with the great ability of leadership.

TECHNICAL SKILLS

ETL Tools: IBM Information Server 8.1/7.5.2/6.0/ EE, Parallel Extender, Informatica PowerCenter 9.1, 8.6, 6.1

Dimensional Data Modeling: Data Modeling, Star Schema Modeling, Snow - Flake Modeling, FACT and Dimensions tables, physical and logical data modeling.

Programming Languages: C, C++, Visual Basic

Databases: MS SQL Server 2000/2005, Oracle 10g/9i/8i/7.3, PL/SQL, DB2 UDB

UNIX Tools: Shell Scripts, C Shell, K-Shell Scripts.

PROFESSIONAL EXPERIENCE

Confidential, Franklin, TN

ETL Architect

Responsibilities:

• Involved in Requirement gathering, Conceptual, Logical and Physical Data model design by following the Enterprise Standards and Naming Conventions.
• Closely worked with Operation Architect Group to design the Technical Specification.
• Gathered the GAPs during Technical Review Session and made sure that everything document and signed off properly.
• Clearly defined the Scope and Assumption of Interfaces, Communicated the Risk and Mitigation plans proactively to Business Stakeholders.
• Designed and Prepared Functional specification documents, Technical specification documents, Mapping Documents for Source to Target mapping with ETL transformation rules.
• Extensively involved in Requirement Gathering, Data Model Design and Technical Design.
• Involved in Analyzing the Risk and Benefits of each requirement and change request and prioritize them accordingly.
• Followed and Implemented Best Practice methodologies.
• Optimized/Tuned the existing Informatica mapping in various level by avoiding bottleneck to get better performance without disturbing the existing system functionalities.
• Involved in loading huge volume of data from source to target.
• Written UNIX scripts to run the DataStage jobs from UNIX.
• Used the Data stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Created Test Plans for Unit Testing/Integration testing.
• Audited database logs of unsuccessful records that failed to be created or updated with appropriate reasons.

Environment: Informatica 9.1, 8.1, Erwin 7.2, Oracle 10G, 11G, AIX, SQL/PLSQL.

Confidential

Sr. Datastage Consultant

Responsibilities:

• Analyze the requirement from the business and designed the ETL Jobs.
• Architecture design and review, Technical and Functional Design (High and Low Level).
• Helping team in resolving critical, unknown technical issue. Timely communication to multiple stake holders.
• Involved in preparing Logical and Physical data model, Source Data Analysis, ETL Process flow and the schema objects with necessary Indexes, Partitions.
• Worked in the implementation of DW Incremental (pull and load) that constitutes different subject areas like (Payroll, Financial Transaction, Compensation Request, Agreement, Party, Contact Point) for different source systems.
• Gain Knowledge on DataStage Administration.
• DataStage server health check, patch/ fix pack installation, resolving unknown/new issue for various teams.
• Interacted with business analysts and modelers for better understanding of individual subject areas and modified specifications to reflect accurate user needs.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms.
• Migrated 7.5 jobs to DataStage 8.1 and did successful testing of all jobs.
• Used stages like Transformer, Sequential File, Dataset, Oracle Enterprise, ODBC, Lookup, Join, Aggregator, Remove Duplicates, Sort and CDC.
• Involved in Analyzing the Risk and Benefits of each requirement and change request and prioritize them accordingly.
• Importing the source and target metadata.
• Optimized/Tuned the existing DataStage jobs in various level by avoiding bottleneck to get better performance without disturbing the existing system functionalities.
• Involved in loading huge volume of data from source to target.
• Written UNIX scripts to run the DataStage jobs from UNIX.
• Used the Data stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Created Test Plans for Unit Testing for designed jobs.
• Audit Log database of unsuccessful records that failed to be created or updated with appropriate reasons.

Environment: Datastage 8.1/7.5, Oracle, SQL Server 2005, Mainframes, UNIX Shell Scripting.

Confidential, Lexington, KY

DataStage Consultant

Responsibilities:

• Analysis and design of ETL processes.
• As Onsite Technical Lead Interacted with Business Users and Business Analysts to understand and document the requirements and translate the requirements to technical specifications ETL Mappings in Informatica.
• Developed Business Information Model and identified the key transactions for each of the Source Systems.
• Provided technical assistance by responding to inquiries regarding errors, problems, or questions with programs/interfaces.
• Interacted with business analysts and modelers for better understanding of individual subject areas and modified specifications to reflect accurate user needs.
• Involved in sessions with SMEs and business users to analyze and gather the high level requirements.
• Managing/Coordinating the Enhancement releases from requirement gathering, Design, Development, System testing, QA and Production deployment between teams.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms.
• As a Technical lead, involved Snowflake Data Modeling both LDM, PDM Preparation
• Involved in performance tuning in various level of ETL mappings.
• Extensively developed DataStage server routines using DataStage Basic Language as part of the development process.
• Drafted Test Plans, Back out plans and Contingency measures during the Production Patches/Fixes for the existing applications.
• Developed UNIX Shell scripts for scheduling the jobs.

Environment: IBM Websphere Information Server 7.5.2/6.1 (Designer, Manager, Administrator, Director, MetaBroker), SQL, Windows NT, UNIX, SQL.

Confidential

Informatica Developer

Responsibilities:

• Involved in identifying the Key Performance Indicators (KPIs), Dimension information by analyzing the BRD and discussing with Business users to build the dimensional model.
• Designed, developed and tested the Data stage jobs using Designer and director based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Analysis and design of ETL processes.
• Involved in preparing Logical and Physical data model, Source Data Analysis, ETL Process flow and the schema objects with necessary Indexes, Partitions.
• Designed the jobs based on the understanding the Data model table relationship.
• Actively involved in gathering requirements from the end users.
• Optimized/Tuned the existing Informatica mapping in various level (Source Qualifier, Transformations and Target) by avoiding bottleneck to get better performance without disturbing the existing system functionalities.
• Actively participated in the code review meetings for each designed jobs and explain the code to Tec lead.
• Provided technical assistance by responding to inquiries regarding errors, problems, or questions with programs/interfaces
• Written Unit test cases and Prepared Unit test results and discussed with functional team.
• Created parameters and Environment variables to run the same job for different schemas.
• Did performance tuning at source, transformations, target and administrator.

Environment: Informatica 6.1, AIX-Unix, Oracle9i, SQL-Programmer.

Confidential

Informatica Developer

Responsibilities:

• Analyze the external third party vendor sources (SSB/Fact set etc) to establish feeds into Data Warehouse.
• Analyze the existing systems used by different users and establish the feeds to these systems from Data Warehouse.
• Create session tasks for each mappings and workflows to run the sessions using Informatica Workflow Manager. Monitor scheduled and running workflows using Workflow Monitor.
• Performed simple and complex transformations (Aggregator, Expression, Lookup, Joiner, Sequence Generator, Sorter, Stored Procedure, Update Strategy, etc.,) as part of Mapping between source and target.
• According to the business logic created various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, Union, Update Strategy and Sorter.
• Involved in fixing invalid mappings, testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Creation of Sessions and executing them to load the data from the source system using Informatica Server Manager.
• Performance tuning of sources, targets, mappings and SQL queries in the transformations.
• Performed Incremental loading by means of loading recently modified/added record into DW
• Map existing sources/feeds to the Data Warehouse fields.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time.
• Build the ETL layer to get the feeds into the staging/ODS tables.
• Build the ETL layer to load data from ODS to Data mart.
• Data validation checking, and adding new columns.

Environment: Informatica 5.1/6.1, Oracle, UNIX Shell Scripting, PL/SQL.

Confidential

Informatica Developer

Responsibilities:

• Analyze the existing systems used by different users and establish the feeds to these systems from Data Warehouse.
• Create session tasks for each mappings and workflows to run the sessions using Informatica Workflow Manager. Monitor scheduled and running workflows using Workflow Monitor.
• According to the business logic created various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, Union, Update Strategy and Sorter.
• Involved in fixing invalid mappings, testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Creation of Sessions and executing them to load the data from the source system using Informatica Server Manager.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time.

Environment: Informatica 5.1, Oracle 8I, UNIX Shell Scripting, PL/SQL.

Confidential

Visual Basic Developer

Responsibilities:

• Design, Coding and Unit Testing, System Integration testing

Environment: VB 6.0-ASP, MS Access, Crystal Report.