SUMMARY

• Sixteen (17+) years of Software Development Life Cycle experience in System Analysis, Design, Development, Implementation, Maintenance, and Testing in various Client/Server and OLTP/OLAP Applications.
• Fourteen (15+) Years of solid ETL (Extract Transform Load) Data Warehouse experience using Informatica PowerCenter 9.6.1/9.5.1/8.6.1/8.1/8.0/7.1.4/7.1.3 , Mapplets,Re - usable Transformations, Shortcuts, Performance Tuning, Error Handling, Production Support, Informatica Power Exchange for SAP/Siebel/Oracle and Informatica MDM Tool.
• Five (5+) Years of experience in MDM Informatica Tool and given proven solution to generate the gloden records on Customer/Product/Employee data.
• Expertise in Enterprise Data Integration.
• Has implemented CDC- Power exchange on Oracle 10g/11g tables for Real time mode and batch mode.
• Has implemented Informatica SAP power exchange to integrate the SAP data in
• Data integration using the ABAP program,
• IDoc integration using ALE method
• Data integration using BAPI/RFC functions.
• Installed and configured various Informatica tools on the linux environment.
• Has Remarkable experience as a Informatica Powercenter/IDQ/MDM administrator.
• Expertise in Informatica Performance Tuning and Error Handling.
• Expertise in handling HFM/Oracle GL/SAP R3 Data /Hyperion Data/IMS RxData/Xponent /GSK Data / provider and Member Data/Employee HR data & MDM Concepts.
• Experienced in developing Test Plans, Test Strategies and Test Cases for Data Warehousing projects ensuring the data meets the business requirements
• Solid experience in Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling, Dimension Data Modeling using Erwin, Microsoft Visio.
• Nine Plus (9+) years experience in Relational Databases like Oracle 11g/10g,MS SQL Server 2008/ 2000/7.0/6.5 , DB2 UDB 8.0/7.0/6.0, MS Access 7.0/2000, IMS Data, SQL, PL/SQL, SQL*Plus, Sun Solaris, Linux, UNIX, Stored Procedures, Functions, Oracle Performance Tuning, Indexes, Functions, and Packages.
• Has done POC on other Informatica Products like B2B Data Transformation, Metadata Manager, Data Quality, Data Explorer, and Data Validation Option
• Worked on Informatica Real time implementation using MQ and Web Services and Power Exchange.
• Strong knowledge on integrating HR data like Employee/Compensation/Onetime payment/Leave of Absence/Global Mobility/Contract contingent worker data into Workday cloud application.
• Excellent Interpersonal Skills with the ability to work independently and with the Team.

TECHNICAL SKILLS

ETL Tools: Informatica MDM 9.7.1, Informatica PowerCenter 9.6.1, Informatica B2B DT, Informatica-Web services, Informatica- MQ Series, Informatica - PowerExchange 9.5 for oracle EBS, SAP, Informatica IDQ, Informatica MDM Data Director 9.7.1,informatica DVO, Informatica ILM.

Data Modeling/others: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions, UML and MDM Concepts.

Databases: Netezza 4.0 /Oracle 11g/10g/9i/8i, T-SQL, MS SQL Server 2000/7.0/6.5 , Sybase SQL Server 12.0/11.x, MS Access 7.0/2000, SQL, PL/SQL, SAP, window azure database

Job Scheduling: Informatica Scheduler, Control M,UC4, TIDAL, Tivoli-IBM Scheduler, CA-Autosys

Environment: Unix /Window/Share Point 2010

Tools: / Others: MS-Word, MS-Excel, MS- PowerPoint, MS-Outlook,MS-Visio. MS-ProjectWin SQL 7.5 / Toad for Oracle 8.6.1/SQL developer/Business Objects XI R2

PROFESSIONAL EXPERIENCE

Confidential, NJ

IDQ/MDM Lead and ETL Architect

Responsibilities:

• Working on various data profiling activities using Informatica Analyst and Informatica Data quality in the requirement and the data analyses phase for Fin regulatory reporting and Fed Remediation reporting projects.
• Working with Data modeler to create the data model to accommodate the incoming exception data.
• Established complete Data Quality applications for the business and technology users across the entire full development life-cycle for IHC project.
• Implemented best standards/guidelines/Best practices and naming standards for IDQ/Powercenter/MDM environments.
• Worked on Complex quality rule and index design, development and implementation patterns with cleanse, parse, standardization, validation, scorecard, exception on IDQ
• Integrated IDQ with Powercenter for Automation purpose
• Created multiple scorecards to the business on the various reports on incoming data on various source systems.
• Providing on-going support for data questions to the outbound systems.
• Sole person working with unstructured global customer data for the Global Business Unit.
• Being part of Data Governance team defined the rules for MDM standardization on KDE
• Working on Informatica Metadata manager to create data linage and business impacts on the Key Data Elements (KDE) used for various reports.
• Provided profiling, cleansing and validation reports in preparation for a data migration project
• Extensively created and used Informatica IDQ - reusable components for data standardization of the party MDM project
• Managing team of 15 for project deliverables including offshore and nearshore.
• Automated the jobs using JIL scripts in Autosys.
• Working on creating landing/staging and Base objects on hub store for party model in MDM

Environment: Informatica MDM Data Director 9.7.1, Informatica 9.7.1, Informatica Power Center 9.6.1, Informatica MDM 9.7.1, Informatica Power Exchange 9.6.1, Informatica IDQ 9.6.1, Powercenter Data Analyzer 9.6.1, Informatica MM 9.7.1, Tidal, HPQC, Autosys schedulers

Confidential, Iselin, NJ

MDM /ETL Architect

Responsibilities:

• Worked with infrastructure team and installed Informatica suits in DEV/UAT/PROD environments.
• Created Informatica Best standards on the naming convention and architectural standards to load the data into MDM.
• Involved in various data profiling activities using Informatica Analyst and Informatica IDQ in the data analyses phase for Product and customer domains.
• Worked with Data modeler to create the data model to accommodate the incoming data.
• Extensively created and used Informatica IDQ - reusable components for data cleansing/consolidate/fuzzy logic for customer addresses for standardization.
• Efficiently handled coordinated onsite/offshore model
• Implemented power exchange connectivity from informatica to oracle EBS databases.
• Implemented incremental data loads to capture only the incremental on the full volume flat files
• Involved in various performance tuning activities on the Informatica and database side.
• Has written various shell script program to automate the batch process on daily and intra-daily mode.
• Created TRD/HLD/LLD documents pertaining to project requirements.
• Worked with Business and Data Governance team to identify the Reference data for the project automation.
• Extensively used all the transformations to achieve the business requirements in the mapping using informatica designer. working with different Vendors of offshore and onsite model to deliver the requirements in time.
• Managing the team size of 10-15 for the development efforts and deliverables.
• Created ETL mappings/sessions/workflows with various transformation utilizing Informatica web services, powercenter and powerexchange to extract/transfer data to external applications on demand and batch mode.
• Has done the POC on the data cleansing rules in informatica - IDQ.
• Worked with SQA team for the project deliverables to meet functional, Technical testing.
• Worked with reporting team get the correct sales reports for CEO decisions.
• Configured and installed Informatica MDM Hub server, cleanse Server, resource kit, Address Doctor in Development, QA, Pre - Prod and Prod Environments.
• Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust Rules in MDM Tool.
• Involved in implementing the Landing Process of loading the customer/product Data Set into Informatica MDM from various source systems using Informatica Powercenter and IDQ.
• Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• Configured Address Doctor which can cleanse whole world address Data and enhanced by making some modifications during installation
• 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 based on business needs.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Involved in creating, monitoring, modifying, & communicating the project plan with other team members.
• Performed match/merge and ran match rules to check the TEMPeffectiveness of MDM process on data.
• Created Unit Test Case document for MDM and ETL and various data Cleansing activities.
• Extensively used IDD to Create new products and new customer information for incremental data and trouble scooted the issue related with IDD.
• Created and implemented the design the publish data from MDM to downstream system in batch mode.

Environment: WebLogic Server 10.3.6.0, Informatica MDM Data Director 9.7.1, Informatica 9.7.1, Informatica Power Center 9.5.1, Informatica MDM 9.7.1, Informatica Power Exchange 9.5.1, Informatica IDQ 9.5.1, Powercenter Data Analyzer 9.5.1, Oracle 10g /11g, Flat Files, UNIX Shell Scripting, Windows XP, Informatica Scheduler, Tidal, HPQC, Window Azure Cloud, Informatica DVO. Informatica ILM.

Confidential, New Brunswick, NJ

Solution Architect & Sr. MDM/ETL developer

Responsibilities:

• Take lead architecture role in dealing with clients, program managers and IT team.
• Implemented the ER data model supporting the client solutions in efficient way for HR data.
• Has done the data profiling and identified the data anomalies and made sure the data model recommended will handle the data using informatica analyst and informatica IDQ.
• Efficiently designed and implemented the Exception handling in the design.
• Has created various transformation in the mapping to achieve the business requirement.
• Has implemented the best ETL standard and the implementation standards in the code.
• Has implemented the complete automation on handling incremental and full set of data from extracting the data to feed the data to downstream system.
• Translate business requirements into detailed architectures and designs
• Document all technical requirements and design technical solutions utilizing enterprise architecture standards including documenting all solution components and configurations
• Implement architectural designs while building solid relationships with stakeholders at all levels
• Work with functional analysts, developers and development managers to ensure that all solutions are deployed within agreed timelines and supported after delivery
• Identify where exceptions to the enterprise architecture standards are required including ETL implementation and naming standards and Database implementation.
• Has 100% hands on experience on Informatica 9.1 and Informatica IDQ for ETL Loads
• Being a part of the development team, given the solution for performance tuning on the ETL code and data base like creating indexes, database portioning like range and virtual partitions and session portioning in informatica to handle the data in parallel.
• Has written the oracle store procedure to construct the org chart starting from level 1 employee to CEO with various functionality inbuilt.
• Mentor junior developers.
• Has halped BI team for their various reporting needs.
• Efficiently handled the defects management using HPQC and Mercury, Clear quest tools.

Environment: Informatica Power Center 9.1, Informatica MDM 9.1, Informatica PowerExchange RT 9.1, Informatica Web services 9.1, Informatica IDQ, Powercenter Data Analyzer, Oracle 10g /11g, Flat Files, UNIX Shell Scripting, Windows XP, Informatica Scheduler, Tidal, HPQC, Workday Cloud.

Confidential, NJ, Newark

ETL Delivery Lead/Architect/Sr. MDM/Informatica Developer

Responsibilities:

• Worked with infrastructure team and created ETL infrastructure for a new health care data warehouse.
• Has successfully implemented the data integration from various source into Integrated data store.
• Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust in MDM Tool.
• Involved in implementing the Land Process of loading the Provider/Member Data Set into Informatica MDM from various source systems.
• Has involved E2E implementation of Master data management and extracted the data from base tables to feed data into EDW Reporting requirements.
• Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups
• Implemented CDC Power Exchange Real time to extract data from oracle 10g/11g Tables using Informatica Power Exchange 9.01
• Extensively worked on ETL performance tuning like Push down optimization, Session portioning, Database portioning and various look up caches and sql overrides.
• Was involved in Code Review / Functional reviews for the code developed by the team members.
• Implemented Audit Balance Control (ABC) for each session to make sure no data was dropped from source to target during the process.
• Implemented the Re-start ability functionality in the code to ease production support process.
• Has done the Data profiling to make sure the data anomalies are handled in the Target Data model.
• Handled Error handling for Business data rejection successfully using re-usable mapplets.
• Used Control - M /Tivoli/Tidal to schedule the jobs to run in Batch mode and on demand mode and event trigger mode.
• Successfully coordinated migration process from DEV to Upper environments (SIT/UAT/PROD).
• Used Static/Dynamic Deployment groups for migration process.
• Worked on performance tuning on new and existing informatica and database components to meet the Business Requirements of delivering the data as per the SLA.
• Was involved in the project Requirement gathering, Initial Analysis, Complete design, development, testing.
• Created TRD/HLD/LLD documents pertaining to project requirements.
• Worked with Business and Data Governance team to identify the Reference data for the project automation.
• Extensively used all the transformations to achieve the business requirements in the mapping using informatica designer.
• Being a client, working with different Vendors of offshore and onsite model to deliver the requirements in time
• Managing the team size of 15-25 for the development efforts and deliverables.
• Created ETL mappings/sessions/workflows with various transformation utilizing Informatica web services, powercenter and powerexchange to extract/transfer data to external applications on demand and batch mode.
• Has done the POC on the data cleansing rules in informatica - IDQ.
• Worked with SQA team for the project deliverables to meet functional, Technical testing.

Environment: Informatica Power Center 9.1, Informatica PowerExchange RT 9.1, Informatica Web services 9.1, Informatica IDQ, Powercenter Data Analyzer, Oracle 10g /11g, Flat Files, UNIX Shell Scripting, Windows XP, Informatica Scheduler, Control M/Tivoli, Mercury Data Quality and IBM-Clear Quest. Lotus notes