SUMMARY:

• 11 years of IT industry experience with wide range of skill set, roles and responsibilities in Consulting and Architechure.
• Strong Exposure in Data Warehouse concepts like Star schema & Snow - flake schema. Experience in implementing Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements using Informatica Power Center.
• Expertise in Master Data Management concepts, Methodologies and building MDM solutions.
• Successfully performed leadership, techno-functional, development, and support roles focusing on MDM and Informatica Powercenter.
• Extensive experience in providing technical leadership for the team on Informatica Powercent er, Informatica MDM (Siperian), IDD (Informatica Data Director), IDQ (Informatica Data Quality), Address Doctor and Identity Matching.
• Hands on experience on handling huge volume of data and performance tuning. Successfully worked in global delivery models working with offshore & onsite teams
• Experience working on multiple domains - Health care, BFSI (Banking, Financial Services and Insurance),Telecom and Retail.
• Performed Business Request analysis,creating Business request response,Data Profiling,Source system analysis,data modeling,Trust/Match strategy design,MDM performance/load count monitoring, UAT,3rd party issue resolution,SIF API implementation

TECHNICAL SKILLS:

Databases: Oracle 11g,DB2, IMS DB

Languages: SQL, PL/SQL, UNIX, COBOL,JAVA

Operating System: Windows server 2012/2008 R2, Win-7/XP.

Tools: SQL Developer, MS-Visio,Control-M

ETL Tools: Informatica PowerCenter 8.x/ 9.x IDQ 9.5,MDM 9.7.1,Informatica Data Director(IDD)

PROFESSIONAL EXPERIENCE:

Confidential

Senior Developer/Analyst Informatica IDQ

• Florida Blue is the oldest and largest health plan insurer in the state of Florida as it transitions into a health solutions company.Florida Blue and its family of subsidiaries serve more than 15.8 million people in 16 states.In its primary health business, Florida Blue serves more than 4.3 million members, which represents a 30 percent share of the overall Florida health insurance market.Projects:-
• Providing Good Architectural design and created solutions for the customers to showcase the functionality of Informatica Master Data Management (MDM) and other products integrated with the MDM hub.
• Data Profiling and Data Quality Analysis of the data given by customer to find out anomalies in the data and highlighting the effectiveness of the Informatica Products.
• Built several reusable components on IDQ using Parsers, Standardizers and Reference tables which can be applied directly to standardize and enrich Address information.

Confidential

Technical Lead /Architect

• Providing Good Architectural design and created solutions for the customers to showcase the functionality of Informatica Master Data Management (MDM) and other products integrated with the MDM hub.
• Understood business requirements and data and created MDM data models and IDD configuration for domains as per the requirements provided by customers with their data.
• Designed and configured MDM hub and IDD. Created Staging, Landing tables, Mappings and data flow to the Base object tables, Match& Merge, Trust settings, Complex hierarchies & workflow for Informatica MDM.
• Data Profiling and Data Quality Analysis of the data given by customer to find out anomalies in the data and highlighting the effectiveness of the Informatica Products.
• Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.
• Used Address Doctor extensively for Address validation of Providers from different legacy Source Systems. Built several reusable components on IDQ using Parsers, Standardizers and Reference tables which can be applied directly to standardize and enrich Address information.
• Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems.
• Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Used Hierarchies tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
• Worked on performance tuning of the complex transformations, mappings, sessions and SQL queries to achieve faster data loads to the data warehouse.
• Implementing the Business Change Requests (BCR) at the client side.
• Analyze the various project requirements and transferring the knowledge to offshore team.
• Ensuring that the team has the required technical expertise to execute the project. This involves the identification of key technical areas related to the project and conducting training sessions to plug any gaps.
• Clarifying the issues of the offshore team members and helping them in the proper execution of the project.
• Worked on real time implementation using SIF
• Worked on hub customization and user exits.

Environment: Informatica Multidomain MDM 9.7.1, JBoss 5.1, DB2, Address Doctor 5, IDD, Informatica Data Quality 9.5.1 Hotfix 3, Informatica power center 9.6.1.

Confidential

Project Lead

• Designing and Developing programs based on clients requirement
• Profile the Data from the current Source systems and identify Data Quality rules for cleansing and standardization.
• Working with the DQ Architect in understanding the current state of Data
• Worked on performance tuning of the complex transformations, mappings, sessions and SQL queries to achieve faster data loads to the data warehouse.
• Provided support for Onsite coordinator,acted as quality gate for the offshore deliverables
• Communicate with the client regarding project progress, meet delivery milestones, and resolve issues related to delivery of projects.

Environment: Informatica power center 9.6.1,Informatica Data Quality 9.5.1 Hotfix 3

Confidential

Senior Developer/Team Lead

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Centre,DB2,Mainframe

Confidential

Developer

• Involved in analyzing functional specifications provided by data architect and involved in creating technical specification documents for all the mappings. Involved in developing logical and physical data models that captures current state/future state data elements and data flows using Erwin.
• Involved in converting data marts from logical design to physical design and involved in defining data types, constraints, indexes, generating schema in the database.
• Involved in creating automated scripts and defining storage parameters for the objects in the database.
• Involved in defining various facts and dimensions in the data mart to include fact less facts, aggregate and summary facts.
• Involved in reviewing source system and proposed data acquisition strategy.
• 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.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Created synonyms for copies of time dimensions, used the sequence generator transformation type to create sequences for generalized dimension keys, stored procedure transformation type for encoding and decoding functions and Lookup transformation to identify slowly changing dimensions.
• Fine-tuned existing Informatica maps for performance optimization.
• Worked on Informatica Designer tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer and Server Manager to create and monitor sessions and batches.
• Involved in the development of Informatica mappings and also tuned for better performance.
• 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.

Confidential

Developer

• Gathered business requirements from Business Analyst.
• Supporting Mainframe tasks in both source and target side.
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.
• Designed and developed Informatica ETL mappings to extract master and transactional data from heterogeneous data feeds and load
• Installed and Configured the Informatica Client tools.
• Worked on loading of data from several flat files to XML Targets.
• Designed the procedures for getting the data from all systems to Data Warehousing system.
• Created the environment for Staging area, loading the Staging area with data from multiple sources.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Created UNIX shell scripts for Informatica ETL tool to automate sessions.
• Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.

Environment: Informatica Power centre,DB2,COBOL,JCL