SUMMARY

• SDLC of 7+ years of IT experience in ETL architecture, database modeling, analysis, design, development, data conversion for Data Warehouse/ Data Mart / Business Intelligence.
• Experience in designing and developing ETL programs for extracting data from heterogeneous sources, transform data based on business requirements and load transformed data to required targets using Informatica Power Center as primary ETL Tool.
• Experience in working within different industry domains like Financial, Life Insurance, Pharmaceutical and Health Care Services.
• Experience in using Informatica Power Exchange to read data and write - back data from and to mainframe VSAM files respectively.
• Experience in performance tuning and implementation of several client/server applications.
• Experience in Informatica Power Center, Power Center Data Profiling, Power Analyzer, Informatica Metadata Reporter.
• Experience in Cognos BI 8 and Cognos ReportNet 1.0/1.1 (Query Studio, Report Studio, Analysis Studio, Framework Manager, Cognos Connection).
• Experience in developing Cognos BI 8/ Cognos ReportNet 1.1 reports and Business Dashboard for Business Intelligence.
• Experience in transforming the business requirements into logical data models.
• Experience with implementing CDC (Change Data Capture) and Slowly Changing Dimensions logic with in ETL process.
• Experience in Data Modeling using Erwin.
• Experience in identifying dimensions, facts and hierarchies for Dimensional models.
• Experience in working Star Schemas and Snow Flake Schemas.
• Strong analytical and conceptual skills in database design and development using Oracle, MS SQL Server and MS Access.
• Experience in using Apache Subversion for maintaining current and historical versions of source files, parameter files, odbc.ini file that contains list of data-sources and properties related to these data-sources, scripts to kickoff Informatica workflows from ESP and related documentation.
• Experience in using Rational ClearQuest & PVCS Tracker for testing process organization.
• Experience in interacting with business partners to identify information needs and business requirements for reports.
• Experience in Maintenance of Applications in the Production environment.
• Good understanding of different phases of the Software Development Life Cycle (SDLC).
• Considerable knowledge in manual testing, different phases of testing & writing SOP documents.
• Self-motivated and always enjoy working in a technically challenging environment.
• Good communication and interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/ 8.1.1/7.1.3 /6.2/6.1, Informatica Power Exchange 7.1.3

Data Modeling Tools: Erwin 7.2/4.1.4

OLAP Tools: Cognos BI8, Report Net 1.1, Informatica Metadata Reporter

Operating Systems: Windows 7/XP/2000/98/95, Windows NT4.0/5.0, UNIX and MS DOS

Databases: Oracle 11g/10g/9i/8i, SQL Server 7.0, DB2 and MS Access

Languages: PL/SQL, SQL, HTML, C, C++ and VB Script.

Office Tools: MS Word, Excel, MS Front Page 98, and MS, and Power Point.

GUI: Visual Basic 6.0 and Forms 4.5

CM Tools: DevTrack, JIRA, IBM Rational Clear-Quest and PVCS Tracker.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta

Sr. ETL Consultant

Responsibilities:

• As a Sr. ETL consultant, involved in the development of new ETL processes and enhancing existing ETL processes, by transforming the suite of business requirements into ETL code.
• Used Informatica Power Center 9.1.1 for extraction, transformation and loading (ETL) of data to the designated targets.
• Responsible for developing and testing of ETL processes/programs necessary to extract data from relational database, flat files (delimited and fixed width), transformation based on business logic and load to data stores.
• Experience in data analysis of source data and detecting patterns and exceptions.
• Created complex mappings in Power Center Designer using Aggregate, Lookup, Expression, Filter, Sequence Generator, Normalizer, SQL, Router, Union, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• Created workflows comprising of different sessions for their respective mappings in order to load data into Oracle database.
• Experience in writing SQL queries to query oracle database using SQL developer and Toad
• Responsible for creating different sessions and workflows in Informatica for the data loads into development, QA and production environments.
• Experience with implementing CDC (Change Data Capture) logic with in ETL process.
• After creating the mappings, tested and validated the mappings and documented the unit test results in the form of Use cases, Test cases and Test plan.
• Experience with DevTrack for tracking and managing the defects.
• Involved in performance tuning of the mappings for maximum efficiency.
• Active involvement in analyzing the data and the ETL code for the maintenance & production issues, updating the existing ETL code with new requirements from the user, redesigning or fixing the faulty ETL according to the business logic and creating some design strategies for fixing the data in production which got corrupted due to faulty ETL code.

Environment: ETL, Informatica (Power Center 9.1), Oracle11g/10g, PL/SQL, UNIX, Windows 7, SQL developer, Toad, DevTrack

Confidential, PA

Sr. ETL Consultant

Responsibilities:

• As an ETL/Informatica consultant, involved in the design and development of new ETL processes, by transforming the suite of business requirements into ETL code.
• Used Informatica Power Center 8.1.1/7.1.3 for extraction, transformation and loading (ETL) of data to the designated targets.
• Responsible for defining, developing and testing of ETL processes/programs necessary to extract data from VSAM files using Power Exchange 7.1.3, flat files (delimited and fixed width) and load to staging and there on to data warehouse based on transformation logic and there on load data from data warehouse to application specific data mart based on their frequency of refresh.
• Experience in Power Center Data Profiling for evaluating source data and detecting patterns and exceptions.
• Created complex mappings in Power Center Designer using Aggregate, Lookup, Expression, Filter, Sequence Generator, Normalizer, SQL, Router, Union, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• Scheduling the workflow comprising of different sessions for their respective mappings in order to load data into Oracle database.
• Responsible for creating different reusable sessions, reusable worklets and workflows in Informatica for the initial data loads into development, QA and production environments.
• Developed Informatica Mappings and Reusable Transformations for Daily, Weekly and Monthly Loading of Data.
• Experience with implementing CDC (Change Data Capture) and Slowly Changing Dimensions logic with in ETL process.
• After creating the mappings, tested and validated the mappings and documented the unit test results in the form of Use cases, Test cases and Test plan.
• Involved in performance tuning of the mappings for maximum efficiency.
• Written shell scripts for scheduling the execution of workflows.
• Active involvement in analyzing the data and the ETL code for the maintenance & production issues, updating the existing ETL code with new requirements from the user, redesigning or fixing the faulty ETL according to the business logic and creating some design strategies for fixing the data in production which got corrupted due to faulty ETL code.
• Experience in migration of Informatica objects from development environment to QA and subsequently to production.
• Pre and Post production of the project used Subversion for maintaining current and historical versions of source files for code tables, parameter files, lookup files, scripts and odbc.ini file.

Environment: ETL, Informatica (Power Center 8.1.1), Informatica Power Exchange 7.1.3, Data profiling, Oracle11g/10g, PL/SQL, UNIX, Windows XP, SQL developer 3.1.07, Subversion 1.7.4 and JIRA.

Confidential, Chicago, IL

Sr. Informatica Consultant

Responsibilities:

• As a Data Warehousing/ETL/Informatica consultant, involved in the design of the new enhancements to the existing data warehouse and in building new application specific Data marts for Business Intelligence, by transforming the suite of business requirements into ETL code.
• Used Informatica Power Center 8.1.1/7.1.3 for extraction, transformation and loading (ETL) of data in the data warehouse and subsequently to data-marts.
• Involved in designing (FACT and Dimension Tables) in the data mart.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Normalizer, Update Strategy, Rank, Joiner, Lookup and Stored procedure transformations.
• Scheduling the workflow comprising of different sessions for their respective mappings in order to load data into Oracle database.
• Responsible for creating different reusable sessions, reusable worklets and workflows in Informatica for the initial data loads into development, QA and production environments.
• Developed Informatica Mappings and Reusable Transformations for Daily, Weekly and Monthly Loading of Data.
• Experience with implementing CDC (Change Data Capture) and Slowly Changing Dimensions logic with in ETL process.
• Used Rational ClearQuest for testing process organization.
• After creating the mappings, tested and validated the mappings and documented the unit test results in the form of Use cases, Test cases and Test plan.
• Involved in performance tuning of the mappings for maximum efficiency.
• Wrote PL/SQL procedures for processing the complex business logic.
• Written shell scripts for scheduling the execution of workflows, for dropping and re-creating indexes on stage tables to decrease load time, Email on session failure, comparing source files (full length file & incremental file) & creating a difference file.
• Active involvement in analyzing the data and the ETL code for the maintenance & production issues, updating the existing ETL code with new requirements from the user, redesigning or fixing the faulty ETL according to the business logic and creating some design strategies for fixing the data in production which got corrupted due to faulty ETL code.
• Experience in migration of Informatica objects from development environment to QA and subsequently to production.

Environment: ETL, Informatica (Power Center 8.1.1/7.1.3 ), Data profiling, Oracle10g/9i, PL/SQL, UNIX, Windows XP, Toad, IBM Rational ClearQuest.

Confidential, Indianapolis, IN

Sr. ETL / Informatica Developer

Responsibilities:

• Used Informatica Power Center 7.1.3 for extraction, transformation and loading (ETL) of data in the data warehouse and data marts.
• Gathered requirements, drafted functional specifications and detail design documents.
• Responsible for Designing, Developing, and Unit Testing of ETL programs.
• Written complex SQL and PL/SQL queries and procedures as required.
• Responsible for the Extraction, Transformation and Loading (ETL) of data in Oracle, which involved writing complex SQL queries.
• As a Data Integration specialist, involved in the design of the new enhancements to the existing data warehouse, building new application specific Data mart for BI analysis and reporting.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Normalization, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• Responsible for definition, development and testing of processes/programs necessary to extract data from data warehouse, Transform data, and Load it into data marts.
• Experience with implementing CDC (Change Data Capture) logic with in ETL process.
• Involved in designing Star schema by de-normalizing dimension tables primary key to fact table foreign keys.
• Experience in using PVCS tracker and PVCS Version manager for tracking the defects and for version control of source files, parameter files and so on respectively.
• Actively involved in analyzing the data and the ETL code for the maintenance & production issues, updating the existing ETL code with new requirements from the user, redesigning or fixing the faulty ETL according to the business logic and creating some design strategies for fixing the data in production which got corrupted due to faulty ETL code.
• Involved in creating shell scripts for scheduling the execution of workflows on the Informatica server.

Environment: Informatica Power Center 7.1.3, SQL Server 2005, Oracle 10g/9i, PL/SQL, UNIX, PVCS Tracker, PVCS Version Manager and Windows XP

Confidential, Indianapolis, IN

ETL / Informatica Specialist

Responsibilities:

• Used Informatica Power Center 7.1.3 for extraction, transformation and loading (ETL) of data in the data warehouse.
• Involved in moving the data from different sources to staging and staging to warehouse.
• Used Informatica Power Center for extraction, transformation and loading (ETL) of data in the data warehouse.
• As a Data Warehousing/ETL/Informatica consultant, involved in designing, developing and unit testing all the ETL programs required for building the data warehouse.
• Involved in the best practices creation and implementation for the data warehouse.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, Transform data, and Load it into data marts.
• Scheduling the workflow comprising of different sessions in order to load data into DB2 database.
• Responsible for fix of defects in the application.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Normalization, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• Used Informatica Power Center Workflow manager to create workflows, reusable sessions, and reusable worklets to run with the logic embedded in the mappings.
• Major involvement in tuning the mappings for maximum efficiency.
• Integrated various sources into the Staging area in Data warehouse.
• Written shell scripts in for scheduling the execution of workflows on the Informatica server.

Environment: Informatica Power Center 7.1.4, Informatica Power Exchange 7.1.3, SQL Server 2005, Oracle 9i and Toad 7.3.0

Confidential, NY

ETL Developer

Responsibilities:

• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, Transform and cleanse data, and Load it into data marts.
• Designed the target warehouse using Star Schema. Built Dimension Tables and Fact Tables
• Responsible in designing and introducing new (FACT or Dimension Tables) to the existing Model and decide the granularity of Fact Tables.
• Used Forward engineering and Reverse engineering for adding new Tables.
• Created necessary Repositories to handle the metadata in the ETL process
• Developed Unix Shell scripts, PL/SQL and SQL scripts to monitor the Oracle 9i database
• Automated various database management tasks (Using SQL and Unix Shell scripts)
• Wrote complex SQL’s, stored procedures and functions in Oracle9i, which could satisfy the end users requirements for increased performance
• Wrote stored procedures, functions using PL/SQL in Oracle to implement the business logic.
• Involved in designing the Data mart and entire data warehousing life cycle designing
• Involved in the best practices creation and implementation for the data warehouse
• Worked extensively with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and populate Data Warehouse.
• Used SQL*Loader for Bulk Loading
• Used Teradata Utilities like MLOAD for multiple loading.
• Created custom defined queries using PL/SQL in Oracle to test the data
• Involved in creation of repositories using Repository Manager.
• Created the repository manager, users, user groups their access profiles.
• Assisted in design and maintenance of Metadata environment.
• Experienced in creating Star Schema for Multi-Dimensional modeling within an enterprise wide Data Warehousing effort.
• Interaction with end users, regularly in order to generate the reports required, these reports were generated using Business Objects functionality such as Slice and Dice, Master/detail, User Responses and Formulas.
• Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse.
• Responsible for designing and developing Universes for reporting purposes. Universes were created for post and pre - analysis of the marketing data through in-house Structure Business Objects methodology. Developed and documented data Mappings/Transformations, Audit procedures and Informatica sessions.
• Used the Informatica Designer, Source Analyzer, Warehouse Designer and Mapping Designer.
• Used Informatica Power Center Server manager to create sessions, batches to run with the logic embedded in the mappings. Used the update strategy to effectively migrate data from source to target. Responsible to collaborate with DBA and Data Architects on implementation of database changes.
• Involved in designing and developing complex Web Intelligence, Client, and Ad Hoc reports for corporate data, which was stored in the Oracle database.

Environment: ETL, Informatica PowerCenter7.1.1 /6.1, Teradata V2R4, Oracle 9i/8i, Erwin 3.5, UNIX and Windows XP

Confidential, Newark, NJ

Informatica Developer

Responsibilities:

• Scheduling the session’s tasks comprising of different mappings in order to load data into oracle database.
• Created necessary Repositories to handle the metadata in the ETL process
• Worked extensively with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and populate Data Warehouse.
• Developed Unix Shell scripts, PL/SQL and SQL scripts to monitor the Oracle database
• Automated various database management tasks (Using SQL and Unix Shell scripts)
• Wrote complex SQL’s, stored procedures and functions in Oracle, which could satisfy the end users requirements for increased performance
• Designed shell scripts in UNIX Korn Shell scripts to perform validations such as file integrity, date and number of records in Flat files.
• Worked extensively with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and populate Data Warehouse.
• Involved in versioning the whole process and retiring the old records using the built-in’s DD UPDATE, DD DELETE, and DD INSERT.
• Performed Data Migration from UNIX text Files.
• Used ETL, Informatica Repository Manager to create repositories and users and to give permissions to users.
• Used ETL, Informatica Designer to design mappings and coding it using reusable mapplets0.
• Major involvement in tuning the mappings, to perform maximum efficiency and performance complete knowledge of session properties in server manager.
• Managed reporting for consistent, fact-based decision-making using Cognos- impromptu drawn from data source.
• Generated various reports using Cognos Impromptu and Power Play.

Environment: Informatica 6.1, Cognos 6.0(Impromptu, Power Play, Access Manager), Oracle 8i, DB2, PL/SQL HP UNIX and Windows NT