• 7+ years of total IT experience and strong ETLexperience across multiple platforms includes Data Warehouse Design and Development in distributed network environment.
• Seven years of strong Data Warehousing ETL experience of using Informatica 9.1.0/8.6/8.1/7.1/6.2/6.0/5.1 Power Center Client tools - Designer, Repository manager, Workflow manager/monitor and Server tools – Informatica Server, Repository Server manager.
• Expert in the design, development and implementation of RDBMSusing Oracle 8i/9i,10g, SQL Server.
• Designed and developed complex mappings, from varied transformation logic like Unconnected andConnected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Valuable experience in Data Warehouse applications, directly responsible for the Extraction, Transformation & Loading of data from multiple sources like SQL Server, Oracle, Flat files, into Data Warehouse using various versions of Informatica.
• Experience in writing, testing and implementation of the triggers, stored procedures, functions at database level and form level using PL/SQL.
• Extensively worked with XML files as the Source and Target, used transformations like XML Generator and XML Parser to transform XML files, used Oracle XMLTYPE data type to store XML files.
• Used major components like Serializers, Parsers, Mappers and Streamers in Data Transformation Studio for conversion of XML files to other formats.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to generating reports to business users.
• Have experience in E-R modeling, developing Database Schemas like Starschema and Snowflake schema used in relational, dimensional and multidimensionalmodeling.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Strong business understanding of Telecommunication, financial, pharmaceutical, Manufacturing and Service oriented industries.
• Developed business process documentation. Experienced in analysis, design specifications, development, performance tuning, testing, documentation, maintenance and trouble-shooting
• Successful in meeting new technical challenges and finding solutions to meet the needs of the client

ETL Tools

Informatica Power Center 5.X/6.X/7.X/8.X,9.1.0, Power Exchange, Power Connect, Power Mart 5. X/6.X, B2B DX/DT v 8.0

Data Modeling Tools

Erwin 4.x

Operating System

Windows 95/98/NT/2000/XP, UNIX, Solaris, Linux, MS-DOS

Databases

Oracle 8i/9i/10g,11g MS SQL Server 6.5/7.0/2000/2005, Sybase, DB2UDB, Teradata, MS Access

Languages

C,C++,JAVA

Business Intelligence Tools:

Business Objects XI, Cognos

Scheduling Tools:

Autosys, Control-M, Tidal.

Other Tools

Toad, MS Visual Studio, MS-Office, Visio, MS-Project, SQL*plus, Shell Scripting, JBuilder.

Confidential,APR’11 – Present

Role: Senior Informatica Developer

Frontier 13: Scalability, Transformation, Conversion (FTR 13 – STC)

Description:-Frontier is one of the fast growing firm in telecom industry. Frontier acquired 13 states of business from Verizon. Frontier 13 (FTR 13) project deals converting the Verizon data to Frontier standards and this has three phases - Scalability, Transformation and Conversion.

Responsibilities:

• Involved in designing the process for getting the data from all systems to Data Warehousing system.
• Performed source system analysis, reviewed source data quality. Developed specifications for transformation and cleansing.
• Architected and Designed the ETL solution that included designing Mappings and workflows, deciding load strategies, implementing appropriate error handling and error notification processes, scheduling and designing re-usable ETL pieces through parameterization.
• Developed the ETL mechanisms to load the data incrementally from the source database into the staging area and from there to feed the satellite applications in the form of flat files, XML files and relational tables. Most of the extract process was incremental, while others were full loads and snapshots.
• Extensively worked with XML files as the Source and Target, used transformations like XML Generator and XML Parser to transform XML files, used Oracle XMLTYPE data type to store XML files.
• Reviewed data models and functional specifications before creating the ETL mappings. Apart from Relational databases, these included unstructured data and non-relational data that were received on a daily basis. Automated the process using Shell Scripts (bash, Perl) and Informatica to load the newly arrived flat files.
• Designed and implemented Change Data capture processes for Fact and Dimension tables through a combination of Time Stamps, staging (before / after images) and bridge tables.
• Developed mappings for Hybrid Dimension tables. These mappings updated multiple dimension tables in a single mapping by simulating an update cascade.
• Strategically used ELT (Extract, Load, Transform) approach to increase performance of poor performing maps by using the features of relational database systems.
• Optimized SQL queries for better performance.
• Involved in performance tuning and optimization of Informaticamappings and session using features like Partitions and data/index cache.
• Improved performance of the ETL processes by benchmarking different approaches to reduce the ETL load time. Based on the benchmark figures, Implemented changes to the ETL processes that included changing the design of certain mappings, addition of new intermediate / staging tables and using database partitioning / informatica pipeline partitioning for large loads.
• Designed Mappings using B2B Data Transformation Studio.
• Used Data Transformation Studio to transform unstructured to structured forms
• Used major components like Serializers, Parsers, Mappers and Streamers in Data Transformation Studio for conversion of XML files to other formats.
• Developed UNIX shell scripts to run the pmcmd functionality to start and stop sessions and batches.
• Designed and developed the re-startability module by writing UNIX scripts. These scripts would automatically re-start the ETL jobs that fail due to specified errors like database connection errors, etc.
• Used Informatica SAS Connectors to read from and write to SAS data sets.
• Provided administrative and operational support of the Informatica environment that included installation, configuration, monitoring, maintenance, and Backups.
• Provided technical support for the enterprise data mart, including the development of enhancement requests and defect resolution.
• Extensively used Visual Source safe to archive technical documentation and UNIX / PLSQL code. Used Quality Center to track / resolve open defects.
• Created documentation to describe program development, logic, coding, testing, and any changes and corrections.

Environment: ETL Informatica Power Center 8.6.1,9.1.0 B2B DX/DT v 8.0, Oracle 11g, Teradata V12, Sales Force, UNIX (Sun Solaris 2.8), SQL, PL/SQL, XML, MS-Visio, MS-Project, HP Quality Center, Toad.

2.Confidential,HI FEB’10 – MAR’11

Role: Sr Informatica Developer
Description:-HMSA is the largest health plan company in Hawaii. This project is based on Online Enrollment system in HMSA.we generated two files, HMSAMAX, IMAX. The HMSAMax file allows HMSA to transmit group information to HMSAenroll application.
The IMAX file allows HMSA to transmit Member information to HMSAenroll application.
For developing IMAX, HMSAMAX we get triggers from LRSP&UI process these triggers through ODS and We generate HMSAMAX& IMAX XML files which we send them to BENEFITFOCUS for processing them through tumbleweed .

Responsibilities:

• Actively interacted with the Business Analysts and Business Users to gather, verify and validate various Business Requirements.
• Worked extensively with front end team to meet the business requirements.
• Analyzed ongoing processes and mapped it to business requirements and proposed technical solutions to change or improve existing processes.
• Extensively used Informatica Power Center 8.6 to extract data from various sources, which included Flat files, Sqlserver, Oracle, Ms-Access and XML.
• Extensively used Informatica Client tools-Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Worked extensively on Informatica transformations like Source Qualifier, Expression, Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator, Joiner, Union, Normalizer, and Transaction Control.
• Developed ETL mappings industry healthcare standards.
• Involved in creating Mappings using Mapping and Session Parameters in the mappings and workflows to eliminate hard coding wherever possible.
• Created Active and Passive Mapplets wherever necessary to facilitate reusability of business logic.
• Created Reusable Transformations, Worklets and made use of the Shared Folder Concept using shortcuts wherever possible to avoid redundancy.
• Used Debugger making use of Breakpoints to monitor data movement and
  troubleshoot the mappings.
• Developed Test cases for Unit Testing of the Mappings, and also was involved in the Integration Testing.
• Performed Optimization at both the Mapping Level and Session Level.
• Implemented Dynamic Parameter Files in Informatica to Improve Performance.
• Monitored and improved query performance by creating indexes, execution plan and analyzing tables.
• Worked closely with team members and QC team for finalizing ETL Specification documented test scenarios.
• Effectively documented all Development work done.
• Created and scheduled jobs in TIDAL scheduler.
• Production support Written 24/6.

Environment: Oracle 10g, Informatica 8.6, SQLDEVELOPER, ERWIN, UNIX, Shell Scripting SQL Server 2005, Teradata TIDAL Scheduler.

3.Confidential,MAR’ 09 – JAN’10

Role: Informatica Developer
Description:-Data was being extracted from source systems. . Oracle has been considered as main system .data is refined and loaded in staging initially.All the data was dumped into staging and later on as per the client requirement the data was transformed and loaded, it is checked if the client is eligible according to the requirements. Every registry is compared for verification and eligibility criteria is decided, whether or not the client is eligible for the claim norms. Also, we need to check which claims are genuine and give a notice period for the claims which is not being profitable to the organisation.

Responsibilities:

• Gathered ETL Requirements from Data Architects, Interacted with the Designers and Developers, Project Manager and SMEs to get a better understanding of the Business Processes.
• Worked with Business Users in for requirement gathering and generating right solutions for them.
• Implemented Informatica best practices like Persistent cache, partitioning etc to boost performance.
• Defined and documented ETL requirements and leading the implementation of technology solutions to help the businesses achieve objectives and provided effective and responsive operational services/support for departments.
• Involved in ETL estimates and task dependencies for Built, Implementation and Deploy face for Application.
• Worked on the change data capture (CDC) process for extract the data
• Extensively used Type I, Type II strategies to handle slowly changing dimensions.
• Proposed Data model changes for building table structures for efficient load processing and co-ordinate with Data Architect & DBA
• Worked extensively on different types of transformations like source qualifier,expression, Aggregator, Router, filter, update strategy, lookup, sorter, Union, Stored Procedure and sequence generator.
• Analysis of the source system to determine elements needed for ETL designs and did extensive data profiling forETL maps.
• Designed High Level ETL strategy for Data Architects and Detail level design documentation for development team.
• Developed Informatica Mappings and Workflows for Data Integration.
• Organized the Workflows and Sessions for the Initialand IncrementalData load runs.
• Prepared theSchedules for the Initial Load runs and Incremental Load runs.
• Designed test cases for initial and Incremental Load testing.
• Performed the performance evaluation of the ETLs for full load cycle.
• Worked on Informatica Utilities – Mapping designer, workflow designer, Monitor, Repository Manager
• Performed tuning and optimization of complex SQL queries using Teradata Created several custom tables, views and macros to support reporting and analytic requirements.
• Executed the Disaster recovery process testing for all the ETL architecture.

Environment:Oracle 10g, Informatica8.5/8.6,TOAD,ERWIN,UNIX, TERADATA, SQL Server 2005, Control-M Scheduler, Putty.

4. Confidential,WASHINGTON, DC AUG ‘08 TO JAN ‘09

Role: Informatica Consultant

Description:-Project was to build a Business Intelligence Solutions Data Warehouse for multi-dimensional analysis and market analysis. Data Marts are designed for sales and financial analysis of products and production units. Data was extracted from various sources and transformed into Oracle data warehouse database using Informatica and various OLAP reports are developed using Hyperion.

Responsibilities:

• Involved in the requirement definition and analysis in support of Data Warehouse efforts.
• Developed ETL mappings, transformations using Informatica Power Center 8.1
• Extensively used Informatica client tools – Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Extensively used ETL to load data from Flat Files to Oracle.
• Developed data Mappings between source systems and warehouse components using Mapping Designer
• Worked extensively on different types of transformations like source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Union, Stored Procedure and sequence generator.
• Implemented Type 1 & Type 2 Slowly changing dimensions.
• Analysed on the change data capture (CDC) process for extracting the data
• Created, launched & scheduled Workflows/sessions. Involved in the Performance Tuning of Mappings and Sessions
• Troubleshoot connectivity problems. Looked up and read session, event and error logs for troubleshooting
• Documentation to describe program development, logic, coding, testing, changes and corrections.
• Created and scheduled jobs in Autosys.
• Production support Written 24/6.

5.Confidential,ndover, MA Sep’ 07 – July’ 08

Role: Informatica Consultant

Description:-Putnam\'s management team has made the strategic decision to migrate the shareholder system to the TA2000 system at DST and to move peripheral systems remaining in house from the mainframe environment to a distributed environment. Due to this conversion of the Shareholder system to DST, we need to make changes to continue processing sub systems such as subsystem, Fund of Fund Underlying processing logic at Putnam. Putnam will develop an in-house system for the maintenance of all aspects of the Underlying fund/trades processing.

Responsibilities:

• Interacted with business users to understand the Business requirements
• Translated business requirements into Data ware house design
• Coordination with Offshore team for development and support activities
• Extracted data from different source systems /parameter files to load the staging tables and the master tables.
• Worked extensively with front end team to meet the business requirements
• Developed various shell scripts for ETL process, to truncate the staging tables, to ftp the files from local server to remote, file validation scripts, file archive scripts, Mailing scripts
• Worked extensively in Informatica Designer, Workflow Manager, Workflow Monitor
• Used various transformations like Source Qualifier, Lookup, Update Strategy, Router, Filter, Aggregator, Expression, and Joiner on the extracted source data according to the business rules and technical specifications
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes
• Developed PL/SQL procedures for processing business logic in the database
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse
• Used Debugger to test the mappings and fix the bugs
• Created and Scheduled jobs using Autosys
• Tested all the mappings and sessions in Development, UAT environments and also migrated into Production environment after everything was successful
• Worked closely with Production control to make sure the jobs run in success
• Associated with 24/7 Production support

Environment: Informatica PowerCenter 8.1.2/PowerConnect, Power Exchange, Oracle 10g, Cobol, DB2, MS SQl Server, Flat file, TOAD, Autosys 4.0, UNIX scripting, Linux, IBM Mainframes, Windows XP Professional.

6.Confidential,MI July ‘06 - Aug ‘07

Role: Informatica Developer

Description: - The Auto dealers exchange project. The main objective of the system is extracting the data from different legacy systems and loading into mart. Developed the business intelligence system to quickly identify customer needs and develop better target services using Informatica. With Power Center a large amount of customer-related data from diverse sources was consolidated, including customer billing, ordering, support and service usage. The idea is to build a Decision Support System for executives.

Responsibilities:

• Performed major role in understanding the business requirements and designing and loading data into data warehouse (ETL).
• Collection of data source information from all the legacy systems and existing data stores.
• Imported various Application Sources, created Targets and Transformations using Informatica Power Center 6.1 Designer (Source analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer.
• Involved in Data Extraction, Transformation and Loading from source systems to ODS.
• Developed complex mappings using multiple sources and targets in different databasesOracle, DB2, flat and XML files.
• Used various transformations like Unconnected /Connected Lookup, Aggregator, Expression Joiner, Sequence Generator, Router etc.
• Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Extensively used Dynamic lookup to implement the type 2 changes.
• Actively participated in the performance of Informatica Mappings.
• Used PMCMD commands of Informatica in UNIX scripts to schedule sessions and jobs.

B.Tech from Pondicherry University