SUMMARY:

• 9 years of Strong experience in Complete Software development Life cycle SDLC which includes Business Requirements Gathering, System Analysis, Design, Development, and Implementation of Data Warehouse.
• Extensive knowledge in health care domain. Worked as onsite lead at Wellpoint Inc and successfully handled a Legacy and an Enterprise data ware house design and production support activities.
• About 7 years of experience in Data Warehouse using Informatica Power Center v 9.1/8.6/8.5 Repository Manager, Mapping Designer, Workflow Manager, Mapplet Designer, Transformation Designer, Warehouse Designer, Star Snowflake Schemas, using ETL tool Informatica on Oracle, Teradata Databases etc .
• Good understanding of relational database management systems like Oracle, TeraData, DB2, and SQL Server and extensively worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems and mainframe Cobol and VSAM files.
• Experience in Teradata, Oracle PL/SQL Stored Procedures, Functions and Triggers and involved in Query Optimization.
• Worked with Dimensional Data warehouses in Star and Snowflake Schemas, Slowly changing dimensions and created slowly growing target mappings, Type1/2/3 dimension mappings.
• Experience in Informatica mapping specification documentation, tuning mappings to increase performance.
• Experience in Job scheduling tools like Control-M, WLM.
• Having experience in leading team and possess excellent communication and interpersonal skills, ability to quickly grasp new concepts, both technical and business related and utilize as needed.
• Strong skills in Requirement gathering and study, Gap Analysis, Scope Definition, Recommendations to Business Process Improvements, Development of Procedures, Forms Documentation, Effort Estimation, Resource Planning, Project Tracking, UAT.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Involved in gathering of business scope and technical requirements and created technical specifications.
• Developed complex mappings and SCD type-I, Type-II and Type III mappings in Informatica to load
• the data from various sources using different transformations like Source Qualifier, Lookup
• connected and unconnected , Expression, Aggregate, Update Strategy, Sequence Generator, Joiner,
• Filter, Rank and Router and SQL transformations. Created complex mapplets for reusable purposes.
• Developed Logical and physical database designs for the transaction system.
• Performed Unit Test, Independing Unit Testing to check the data quality for each task
• implemented for this application.
• Supporting the issues raised by the Front end Developement teams and Testing teams.
• Responsible for developing the WebI reports based on the user requirements.
• Implemented various functionality such as Drill down at report level , Drillup, Alerts etc.
• Effective implementation of Agile Project management methodologies and Kanban Process.

Environment: Informatica Power Center 9.1, Oracle 11g, SQL Server.

Confidential

Senor Informatica Teradata Developer.

Project1: AEDW North east region of blue cross Blue shield

AEDW, Medicare, Capsule and Recon: Blue Cross enterprise data warehouse deals with different kinds of health claims which are categorized as Facility, Professional, FEP. Data is coming from various sources like Oracle, SQL Server, Mainframe etc which will be loaded in to AEDW based on different frequencies as per the requirement. The entire ETL process consists of source systems, staging area, ODS layer, Data warehouse and Data mart.

Responsibilities:

• Extensively involved in gathering client requirement and data Analysis and also created design, mapping documents.
• Involved in design and development complex ETL mappings and stored procedures in an optimized manner.
• Fine-tuned existing Informatica mappings for performance optimization.
• Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system.
• Involved in the Unit testing , System testing and also supported user acceptance testing .
• Worked on bug fixes on existing Informatica Mappings to produce correct output.
• Taken active part in implementation of WLM scheduler for existing informatica jobs and Teradata utilities.
• End to end testing and played major role in upgrading the informatica versions from 8.0 to 8.6 and 8.6 to 9.0.1 and Teradata 12 to 13.

Environment: Informatica Power Center 9.0.1, Oracle 10g, Teradata 13, Oracle, UNIX, Mainframe.

Project2: BI Solutions -EDW Enterprise Data Warehouse

The goal of Enterprise Data Warehouse EDW program is to create a single, authoritative source for analytical reporting. The flow of this project is to getting the data on to the Enterprise Data Warehouse EDW using the Persistent Data Source PDS as the Input. Taking the PDS as input and applying all the business rules and transformations, the data would be loaded onto the Target Data Base, which is standing on Universal Data Base UDB . Loading of data into the EDW is done using the ETL Tool Informatica. Loading of data into EDW process need to be scheduled using WLM.

As part of the EDW, BI solutions is the sub project which is collection of applications used for the Internal Reporting.

Application1: Provider finder

This is an initiative to enhance customer experience by providing search capabilities on providers to consumers and also to encourage insurance customers to visit the web site to make informed decisions on providers. Based on consumer feedback from Foresee surveys and logged customer care issues, WellPoint is enhancing the usability and functionality of the online Provider Finder tool

Responsibilities:

• Worked with business analysts in gathering the requirement and kept huge efforts to get the precise information as we are working with provider data.
• Extensively involved in analyzing the huge data in the data ware house to understand the amount of duplicates, distinct values in order to determine the key column.
• Designed mappings for dimensions and facts.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Look up, filter and Router for developing mappings.
• Created reusable transformations and Mapplet and used with various mappings.
• As part of the standard policy of Wellpoint, Performed Unit Test, System Integration Test and UAT to check the data quality for each task implemented for this application.
• Designed and tested WLM jobs to trigger the informatica and Teradata list files.

Environment: Informatica Power Center 9.01, SQL Server 2008, Teradata, UNIX

Confidential

Responsibilities:

• Involved in gathering of business scope and technical requirements and created technical specifications.
• Developed complex mappings and SCD type-I, Type-II mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup connected and unconnected , Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations. Created complex mapplets for reusable purposes. Developed Logical and physical database designs for the transaction system.
• Worked on Teradata Utilities for Data loads.
• Performed Unit Test, System Integration Test and UAT to check the data quality for each task implemented for this application.
• Designed and tested WLM jobs to trigger the informatica and Teradata list files.

Environment: Informatica Power Center 9.0.1, Informatica Power Exchange, Teradata 12, UNIX.

Confidential

Responsibilities:

• Involved in gathering requirements and created design documents and mapping documents.
• Developed Logical and physical database designs for the transaction system.
• Designed and developed complex ETL mappings making use of transformations like Source
• Qualifier, Expression, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, , Router, Filter, Aggregator and Sequence Generator transformations.
• Developed BTEQ scripts to load data into Teradata tables.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality.
• Worked with production control team on technical/data issues as part of Warranty support.
• Developed and tested WLM jobs to trigger the informatica and Teradata list files.
• Environment: Informatica Power Center 8.6, Informatica Power Exchange, Teradata 12, UNIX.

Confidential

Sr. Informatica Developer

Responsibilities:

• Worked on the Call plan process development which is the most sensitive process which affects the customer database directly.
• Designed and developed related ETL mappings making use of transformations like Source Qualifier, Expression, Joiner, Update Strategy, Lookup, Rank, Router, Filter, Aggregator and Sequence Generator transformations.
• Worked with onsite business coordinator and developed all Adhoc reports using Informatica and developed the automated process of transferring data using FTP in UNIX.
• Worked as the point of contact for the call plan analysis team for all enhancements that has been developed during my tenure.
• Improved the performance of existing informatica mappings, oracle procedures and changed the conventional analysis methods.

Environment: Power Center 8.6, Oracle 10g, SQL, PL SQL, UNIX

Confidential

Oracle Developer

Responsibilities:

• Worked with business team and involved in schema design.
• Developed PL/SQL stored procedures, Functions, database triggers and created packages in billing module to access the database from front end screens.
• Taken part in completion of the Inventory and order management modules.
• Developed both inbound and outbound interfaces using PL/SQL to load data into targeted database and extract the data from the database to flat files.
• Responsible for gathering the requirements of customizations requested by the various clients, testing and delivery of those custom works at client place.
• Developing of Client Specific customizations using Oracle/SQL/PLSQL Server and reports using Crystal Reports
• Loading data into the relocation database using SQL Loader utility and transferred the data by Export / Import Utility.
• Training Co-ordination, Preparation of training materials, End user training.
• Responsible for Data mapping and porting, i.e., If the customer has an existing billing system, We help the customers map the data in the existing billing system to the new billing solution.
• Responsible in assisting various clients to install the patch releases and the product upgrades.
• Successfully imported the data for 25 clients during my tenure.

Environment: GUI-ASP.net, Oracle 10g, Crystal Reports 11.x, IIS and Windows 2000 / XP / 2003 Operating System.

Confidential

Service Engineer Database

Responsibilities:

• Worked as a service engineer database and participated in GSIS product design and implementation.
• Understanding and analyzing the client's requirement and involved in GUI designing of the application.
• Responsible in implementing the migration of previous data to Oracle.
• Participated in the building of business process implementation and designing the database.
• Participated in developing the report module.
• Developed all relevant reports using crystal reports 11 R2.
• Maintaining the Data on time, off time and error rates in the daily operations.
• Maintaining of details of services done on the terminals and usage of logistics, team's details in the database.

Environment: Java, Oracle 10g, Crystal Reports 11.x, Windows server 2003 Operating System.