SUMMARY

• Over 7+ years of IT experience with a strong background in SDLC, Data Integration tools including Informatica PowerCenter, Informatica PowerExchange.
• Expertise in Informatica Power Center 9.x/8.x/7.x/6.x extracting data from Oracle, SQL Server and DB2 databases.
• Extensive experience in Extraction, Transformation and Loading of data using Informatica from heterogeneous sources.
• Extensive experience with Healthcare, Energy and Media domains.
• Strong ability to analyze source systems and business requirements, identify and document business rules, design data architecture for cohesive decision support and prepare dimensional data models.
• Extensive knowledge of Dimensional Data Modeling like Star and Snowflake schemas and knowledge in designing tools like Erwin and Power Designer.
• Extensively worked in development of Informatica Mappings and Informatica Workflows.
• Experience with Informatica Advanced Techniques – Dynamic Caching, Memory Management, Parallel Processing to increase Performance throughput.
• Extensively involved in Optimization and Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, memory management and parallel threading.
• Experience in creating and using Stored Procedures, Functions, Triggers, Views, Synonyms, and Packages in SQL Server 2000/2005, Oracle 10g/9i/8i and DB2.
• Involved in Performance/ Query tuning. Generation /interpretation of explain plans and tuning SQL to improve performance.
• Skilled in Unix Shell Scripting and experience on different UNIX platforms.
• Experience in scheduling of ETL jobs using Crontab, Control-M.
• Knowledge in developing reports using Business Intelligence tools like Business Objects and Cognos.
• Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per business requirements.
• Experience in working in an onsite-offshore structure and effectively coordinated tasks between onsite and offshore teams.
• Experience in the full-cycle software development including requirements gathering, prototyping, and proof of concept, design, documentation, implementation, testing, maintenance and production support.
• A highly motivated self-starter and a good team-player with excellent verbal and written communication skills.

EDUCATION

Bachelors in Engineering

TECHNICAL SKILLS

ETL Tools: Informatica 9.x/8.x/7.x/6.x Informatica Power Exchange

Databases: Oracle 10g/9i/8i, DB28.x, SQL Server 2000/2005

Languages: SQL, PL/SQL, SQL-PL, T-SQL, Shell Scripting, XML

Operating Systems: UNIX (SOLARIS, AIX), Linux, Windows 95/98/NT/2000/XP and DOS

DB Tools: SQL Plus, SQL Loader, Toad, I-SQL, DB Visualiser, Power Designer, Erwin

BI Tools: Cognos7.x/8.x, Business-Objects 5.x/6.x

Scheduling Tools: Control-M, Crontab, Autosys

Version Control Software: IBM Rational Clear Case

Others: MS Office (MS Access, MS Excel, MS PowerPoint, MS Word)

Desktop Tools

EXPERIENCE

Confidential, Boston, MA Nov 10- Till Date

Sr. Informatica Developer

BMC Healthcare is one of the largest non-profit healthcare organizations providing healthcare services. It provides a comprehensive range of inpatient, clinical and diagnostic services in more than 70 areas of medical specialties and subspecialties. During this project I have worked closely with the data warehouse development team , customers, business analysts and other colleagues in the ITS department to analyze operational data sources, determine data availability, define the data warehouse schema and develop ETL processes for the creation, maintenance, administration and overall support of the data warehouse.

Responsibilities

• Co-ordinated Joint Application Development (JAD) sessions with Business Analysts and source developer for performing data analysis and gathering business requirements.
• Developed technical specifications of the ETL process flow
• Designed the Source - Target mappings and involved in designing the Selection Criteriadocument.
• Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in SQLServer and Oracle.
• Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different sourcesystems (SQL server, Oracle, Flat files).
• Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, SequenceGenerator and Normalizer.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Used version mapping to update the slowly changing dimensions to keep full history to the target database.
• Involved in migration of Informatica from 8.x to 9.x.
• Implemented sending of Post-Session Email once data is loaded.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Used Debugger to test the mappings and fixed the bugs.
• Tuned performance of mapping and sessions by optimizing source, target bottlenecks andimplemented pipeline partitioning.
• Worked with DBA for partitioning and creating indexes on tables used in source qualifier queries.
• Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.
• Involved in exporting database, tablespaces, tables using Datapump(10g) as well as traditional export/import (until 9i).
• Knowledge of Cold/Hot backups and RMAN backups.
• Scheduled various daily and monthly ETL loads using Control-M
• Involved in writing UNIX shell scripts to run and schedule batch jobs.
• Involved in unit testing and documentation of the ETL process
• Involved in Production Support in resolving issues and bugs.
• Created Cognos Impromptu reports utilizing existing Oracle views and tables.

Environment:Informatica Power Center 9.x/8.x, SQLServer 2005, PL/SQL ,Oracle 10g, Toad 8.0, Cognos 8.3, Windows NT, UNIX Shell Scripting.

Confidential, Oldsmar, FL Jan 09 – Oct 10

ETL Developer/Onsite Coordinator

Nielsen Media Research provides television audience estimates for broadcast and cable networks, television stations, national syndicators, regional cable television systems, satellite providers, advertisers and advertising agencies. The objective of the project is to build an Enterprise Data Warehouse (LDW - Local Data Warehouse) on DB2 that captures all the data for local viewing from various sources including Oracle, DB2 and Flatfiles. Two data marts are populated from this Local Data Warehouse to support specific applications. This multi-terabyte warehouse also delivers data to many weekly and monthly report applications.

Responsibilities

• Involved in gathering business requirements and attended technical review meetings to understand the data warehouse model.
• Involved in data modeling and design of data warehouse in star schema methodology with confirmed granular dimensions and Fact tables.
• Developed Technical Specifications of the ETL process flow
• Extensively used ETL to load data from Flat files, DB2 and Oracle into Oracle.
• Used Informatica Designer to Extract & Transform the data from various source systems by incorporating various business rules. Also used different transformations, sessions and command tasks.
• Created mappings using different transformations like Aggregator, Expression, Stored Procedure, Filter, Joiner, Lookup, Router and Update Strategy
• Worked with mapping variable, Mapping parameters and variable functions like Setvariable, Countvariable, Setminvariable and Setmaxvariable
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Using InformaticaRepository Manager maintained all the repositories of various applications, created users, user groups, and security access control.
• Developed shell scripts for job automation, which will generate the log file for every job.
• Created Stored Procedures for Audit and Error Balancing.
• Used Crontab for scheduling.
• Validated Data to Maintain Referential Integrity.
• Developed UNIX shell scripts to move source files to archive directory.
• Involved in Unit, Integration, system, and performance testing levels.
• Worked on back end programming such as PL/SQL procedures, functions and packages.
• Prepared a production monitoring and support handbook for ETL Process.
• Coordinated offshore and onsite team with a total of 7 ETL developers
• Involved in design and development of Reporting System using Business Objects.

Environment:Informatica Power Center 8.x, Oracle 10g, JDeveloper, DB2 8.1.6/8.2.0, UNIX, Windows NT 4.0, UNIX Shell Programming, PL/SQL, T-SQL, SQL*Loader, BCP, Business Objects 6.0, TOAD Quest Software

Confidential, Atlanta, Georgia Apr 07 – Dec 08

Informatica Developer

Description: The highest priority business requirement is to keep track and analyze the employee transaction events accurately. The project was for developing an integrated data mart for the Headcount across GE Power Systems. The source comes from the Oracle HR system and the business owner would be Human Resources. ETL and reporting tools are Informatica and Cognos respectively. The project is a complete data warehouse lifecycle project.

Responsibilities

• Interacted with end-users and functional analysts to identify and develop business requirements and transform them into technical requirements.
• Involved in the SDLC process beginning with the design of dimensional modeling in buildingthe data warehouse
• Worked with Data Architects during Design Stages.
• Created design specification documents and developed functional and technical specification documents.
• Extracted data from oracle, flat file and xml sources.
• Used Informatica Power Center to create mappings, sessions and workflows for populating the data into the dimension, facts, and lookup tables simultaneously from different source systems.
• Created scripts for automating table partitions.
• Created a global repository, groups, users and assigned privileges using repository manager
• Implemented rolling window method for deleting the old data.
• Created sessions and workflows.
• Worked with email,commandtasks,Mapplets, Reusable Transformations and worklets.
• Handled slowly changing dimensions of Type 1/ Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Involved in performance tuning of the sessions.
• Extensively used PL/SQL for database related functionality.
• Used Pmcmdcommands to run the Informatica mappings using Unix Scripts.
• Used Crontab for scheduling.
• Created UNIX Scripts for creating the indexes, altering the default table spaces and analyzing the tables.
• Created UNIX shell scripts for data cleaning.
• Involved in unit testing and documentation of the ETL process.
• Involved in creating the run book and migration document from development to production.
• Involved in Data warehouse month end loads and support activities.
• Generated various business reports using CognosPowerPlay, Report Studio, and Query Studio

Environment: Informatica Power Center 8.x/7.x,Oracle 9i, PL/SQL, TOAD8.0, Windows NT, Unix Shell Scripting, ERWIN 4.0,SQL loader, CognosPowerPlay 7, CognosReportNet 1.1 MR2.

Confidential Companies, NY Jan 05 -Mar 07

ETL Developer

Description:Platts, a division of the McGraw-Hill Companies, is part of the Information & Media Services segment. Platts Analytics was formed as a business unit within Platts to bring together several acquired Businesses that serve the same customer type. Platts Analytics business strategy requires the development of a single content delivery platform accessing an integrated data warehouse to support the energy business analyst customers. This system is envisioned as a must-have toolkit for analysis in the energy industry and the sector of the financial services industry serving energy.

Responsibilities

• Analysed source systems, business requirements and identified business rules for building the data warehouse.
• Developed Technical Specifications of the ETL process flow
• Designed and developed Informatica mappings, workflows to load data into Oracle ODS.
• Installed and Configured Informatica Power Center client tools and connected with each database in Data Ware house using repository server.
• Extensively used Informatica to load data from Oracle, XMLand Flat Files to Oracle.
• Used Informatica workflow manager, monitor, and repository manager to execute and monitor workflows and assign user privileges.
• Extensively worked with Aggregator, Sorter, Router, Filter, Join, Expression, Lookup and Update Strategy, Sequence generator transformations.
• Set up Metadata driven utility design for the ETL processes using Informatica.
• Used debugger to test the mapping and fixed the bugs.
• Involved in tuning the performance of sessions and mappings.
• Used the Workflow manager to create workflows and tasks, and also created worklets.
• Involved in Production Support in resolving issues and bugs.
• Worked onSQL stored procedures, functions and packages in Oracle.
• Scheduled and executed batch and session jobs on Autosys.
• Created and maintained UNIX shell scripts for pre/post session operations and various day-to-day operations.
• Developed unit and system test cases, using System Procedures to check data consistency with adherence to the data model defined.
• Involved in developing reports using Business Objects.

Environment: Informatica Power Center 6.1.1/7.0, Oracle8i, PL/SQL, Business Objects 5.1, Windows NT, HPUX 10.20, Erwin 3.5.2, Autosys.