Professional Summary:

• 7+ years of work experience in IT industry in Analysis, Design, Development and Maintenance of various software applications mainly in Data Warehousing for Finances, Utilities, Banking, Retail, Healthcare and Insurance.
• Expertise in database concepts such as conceptual, logical and physical data modeling, and data definition, population and manipulation using RDBMS Databases Oracle 11g/10g/9i, IBM DB2 UDB 8.0, MS SQL Server 2000/2005/2008, MSSQL, Excel sheets, Flat files, XML files, etc.
• Experience in Relational and Dimensional modeling Methodologies such as Star Schema, SnowflakeSchema.
• Experience in modeling Transactional Databases and Data Warehouses using tools like Erwin and ER/Studio.
• Good knowledge of Software Development Life Cycle (SDLC) including Design, Analysis, Development, Testing and Implementation.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Expertise in SQL, PL/SQL, Stored Procedures, Functions, Packages, views, materialized views, table partitions strategies, indexes, Triggers, etc.
• Skilled inSQL*Plus, TOAD, SQL Assistant, SQL Developer, SQLserver Management Studio, etc.
• Experience in implementing historical loads, incremental loads and change Data capture.
• Was involved in basic Informatica administration such as creating folders, users, change management, etc., and also involved in moving code from DEV to TEST and PROD using deployment groups in Informatica Repository manager.
• Excellent capabilities in integration mappings including dynamic cache lookup, shared lookup, and persistence lookup mappings for Type I, Type II, and Type III slowly changing dimensions.
• Experience in creatingInformatica Tasks such as Sessions, Command, Email, Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control, etc.
• Experienced in doing Error handling and Troubleshooting using various log files.
• Proficient in applying Performance tuning concepts to InformaticaMappings, Session properties, and database.
• Experience in Unix Shell scripts, Autosys, Tidal, etc. for scheduling jobs.
• Proficient in Development, Testing, Debugging, Implementation, Documentation, End-user training and Production support.
• Team player with good interpersonal and problem solving skills, ability to work in team and also work individually.
• Good Communication and Inter-personal Skills: a Quick Learner and a Team Player

Technical Skills:

Informatica Power Center 9.x/8.x/7.x/Power Exchange/Power Connect.

Databases:

Oracle 11g/10g/9i/8i, SQL Server 2000/2005/2008, DB2, TeraData, Sybase, Netezza, etc

Operating System:

Unix-AIX, Windows NT/2000/XP.

Languages:

SQL, PL/SQL, Shell Scripting

Modeling Tools:

ER Studio, Erwin 4.1, MS Visio.

Data Modeling:

Star Schema Modeling, Snow-Flake Schema Modeling, Fact and Dimension Tables, Relational Modeling, Logical and Physical Data Modeling.

Other Tools:

SQL*Plus, Toad, AutoSys, Sql Developer, Sqlserver Management Studio, Microsoft Visio,Teradata SQL Assistant, etc.

Educational Background:
Bachelors of Engineering in Computer Sciences from JNTU, Andhra Pradesh, India

Professional Experience:

Client: -Confidential,NY

Duration: - DEC 2010 Till Date

Role: -ETL /Informatica Developer

Description:
AXA Equitable is a leading financial protection company and a premier provider oflife insurance, annuities and related financial services.AXA Equitable Company wanted to implement business strategies to do well with the business and give better service to the customers.AXA Equitable initiated this data migration project to migrate data from its legacy systems to Teradata environment, which involved extracting DB2 tables into flat files and then loading into Teradata. The aim of the project was to develop and implement a Data warehouse called as Renewals System Department (RSD)which will be an integral part of the processing services for managing all AXA Equitable insurance policies.

Responsibilities:

• Interacted with the Functional Analysts to understand the process flow and the business.
• Involved in gathering the business requirements from Business Analyst.
• Analyzing Source to Target mapping Excel document.
• Coordinating the team and assigning dependencies tasks to team.
• Created Data Flow Mappings to extract data from source system and Loading to staging area.
• Analyzed the AR data and developed the code to extract the data for the AR module and implemented in the informatica.
• Developed the strategy for the incremental loads.
• Worked on various tasks like Session, E-Mail task, Command task, etc.
• Worked on Informatica Scheduler for scheduling the delta loads and master loads.
• Created and used various re-usable tasks, workflows, Worklets, mapplets, and re-usable transformations.
• Worked on slowly changing dimension Type1 and Type2.
• Used the Dynamic look up to implement the CDC.
• Involved in performance tuning of the process at mapping, session and database level.
• Used parameter files and variables to design ETL process.
• Performed Functionality, Back-end and Regression testing during the various phases of the application and Data Integrity/back end testing by executing SQL statements.
• Fixed issues in Test, QA and Production.
• Developed Fast Load and Multiload Scripts in Teradata.
• Prepared the Low Level documents/mapping documents for the tasks assigned to me.
• Mode code from DEV to TEST to PROD using deployment groups.

Environment: Informatica 9.1/8.6, Erwin, Oracle 11g, Toad, DB2, Teradata, PL/SQL, SQL Developer , Tidal Software, Windows XP, PL/SQL, Sybase, SQL Server 2005/2008.

Client: - Confidential,Seattle, WA

Duration: -MAR 2010 DEC 2010

Role: -ETL /Informatica Developer

Description:
Group Health Cooperative is a national employee benefits provider with expertise in creative health care management solutions. They are also a leading provider of retirement savings plans. As a programmer analyst involved in gathering the requirements from the FACETS and design of the customer’s information and their claim’s Datamart which would serve prominent element for the Health insurance Data warehouse. Primary objective of the Datamart was to generate monthly/Daily Delta files.

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures.
• Involved in the complete life cycle of the project.
• Participated in designing the data model using Erwin.
• Created Mapplets, reusable transformations and used them in different mappings.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for clean up and update purposes.
• Successfully Loaded Data into different targets from various source systems like Oracle Database, Flat files, XML files, SQL Server etc. into the target database.
• Created users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository manager.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Dealt with data issues in the staging flat files and after it was cleaned up it is sent to the targets.
• Performed incremental aggregation to load incremental data into aggregate tables.
• Re-designed ETL mappings to improve data quality.
• Designed and developed Oracle PL/SQL Procedures.
• Trouble shooting of long running sessions and fixing the issues.
• Developed UNIX shell scripts using PMCMD and PMREP utilities and scheduled ETL load using Maestro.
• Extensive use of Persistent cache to reduce session processing time.
• Implemented performance tuning Mappings, Sessions and Databases by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Imported sources and targets from Web services Definition Language (WSDL).
• Prepared ETL mapping Documents for every mapping and Data Migration document for moving changed objects from development to testing environment and then to production environment.
• Involved in Unit testing, System testing to check whether the data loads into target is accurate, which was extracted from different source systems according to the user requirements.
• Migrated repository objects, services and scripts from development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.
• Lead the development team during the development process, this include provide help with the tasks and transfer knowledge of Informatica.

Environment: Informatica 8.6, Oracle 11g/10g, SQL Server 2008, SQL, PL/SQL, TOAD, UNIX, UNIX Shell Script,Netezza, Erwin.

Client: -Confidential,AL
Duration: -JAN 2009 FEB 2010
Role: - ETL Developer

Description:
BBVA Compass offers customers unique and industry-leading products and services with a focus on providing customers with financial solutions to fit their lives.In this we developed a warehouse which is called BBVA SPOE it manages all bank transactions and process.

Responsibilities:

• Involved in customizing data models, for the Data Warehouse, supporting data from multiple sources on real time.
• Involved in the designing of the Data Model in deriving Conceptual, Logical and Physical model’s using Erwin R7 with Architect teams and dimensional modeling of the schemas across the Data Warehousing requirements.
• Used advanced techniques of Informatica to load data from MS SQL Server, XML files, Flat files into the largest Oracle database.
• Responsible for creating XML source files, web services consumer connections and their sources.
• Responsible for creating the DATA MAPS, extracting (incremental) CDC data from Mainframe sources, exporting and updating them to the repository, importing the required source files on the staging environment by using Informatica Power Exchange.
• Imported external data (flat files) into Oracle tables using SQL*Loader.
• Implemented changes in slowly changing dimension tables.
• Optimized/Tuned mappings for better performance and efficiency.
• Used mapping parameters and variables to support efficient mapping design.
• Involved in performance tuning of the Informatica Mappings and Sessions to enhance the performance by using different Partitioning techniques and the various transformations.
• Configured Informatica Power exchange to connect to SAP source system to extract sales and spend data.
• Involved in writing SQL queries, PL/SQL procedures, Functions, Cursors, Triggers in Oracle and SQL Server.
• Developed UNIX shell script to validate flat files and audits.
• Used debugger to test the data flow between source and target and to fix data issues.
• Used session partitions, dynamic cache memory and index caches for improving performance of Informatica services/server.
• Associated with Production support team in various performances related issues.

Environment: Informatica 8.1, Oracle 10g, Toad, XML, SQL* Loader, Teradata, SQL Server, Erwin 4.1, UNIX, Win XP.

Client: -Confidential,Tampa, FL

Duration: -AUG 2007 NOV 2008

Role: -ETL/Informatica Developer

Description:
Wellcare Health Plans is one of the nation\'s largest health care services companies. This project mainly deals with the report related to performance of business associates and dealers in specific regions across time to analyze customer performance of large data warehouse for health insurance division of several reports related to customer information management and sales profile management was created.

Responsibilities:

• Participated in Requirement Gathering, Business Analysis, User meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.
• Reading the data from the FACETS and HpXr data model then written ETL Functional Design documents and ETL technical Specification documents for program development, logic, coding, changes and corrections.
• Analysis, Design and Development, testing and implementation of Informatica transformations and workflows for extracting the data from the multiple sources.
• Developed extraction mappings to load data from Source systems to ODS to Data Warehouse
• Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations.
• Used debugger to test the mapping and fixed the bugs.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
• Used session partitions, dynamic cache memory, and index cache to improve the performance.
• Documented the mappings used in ETL processes.
• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into Target.
• Wrote SQL, PL/SQL codes, stored procedures and packages.
• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
• Optimize SQL queries for better performance.
• Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance.
• Worked on UNIX shell scripts. Developed UNIX shell scripts to run the pmcmdfunctionality to start and stop sessions.
• Utilized Test Director (Defect Tracking Tool) for communication with the production personnel, developers and team members.
• Defects are logged and change requests are submitted using defects module of Test Director.

Environment:Informatica 8.1, Oracle 10g/9i, SQL, PL/SQL, TOAD, ERWIN 4.0, MS SQL Server, SQL*Plus, Windows, UNIX Shell Scripts.

Client: -Confidential,Bangalore, India
Duration: -DEC 2006 JUL 2007
Role: -Informatica Developer
Description:
Bajaj Alliance is the nation’s leading health benefits company serving the needs of approximately 44 million medical members nationwide in India. The goal was to create an Enterprise Data Warehouse (EDW) solution to create a single, authoritative source for analytical reporting by integration heterogeneous source systems.

Environment:Informatica PowerCenter 8.1, Oracle 9i, SQL Server, Erwin, UNIX (AIX), Windows NT.

Client: -Confidential,Vishakhapatnam. India

Duration: -APR 2005 NOV 2006

Role: - ETL Developer

Description:
Xinthe Technologies provides high quality professional IT services and cost effective solutions across a wide variety of platforms aimed at customer satisfaction through professionally organized teamwork. The Data Warehouse was built to maintain material management systems and managing data processing activities and system development for client. The primary aim of this project is to integrate the data sources from existing system and to provide analysis to make business related decisions.

Environment:Informatica 7.1, Windows 2000, SQL Server 2000, Oracle 8i, SQL*Plus, Tidal.