SUMMARY:

• 8+ years of experience in software development, maintenance, testing and troubleshooting on Master Data Management (MDM), Metadata management, ETL/DWH applications, data quality, data integration and Oracle database environment in various Verticals such as Pharmaceutical, Health Care Insurance, Retail, Telecom, and Banking industries.
• Involved in various stages of Software Development Life Cycles (SDLC) including requirements analysis, design, development, testing and implementation.
• Designed, Installed, Configured core Informatica/Siperian MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD &Data Modeling.
• Experience in several facets of MDM implementations   including Data Profiling, metadata acquisition, data migration , validation, reject processing and pre - landing processing.
• Experience in defining and configuring landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
• Implemented Hierarchy Manager Module in addition to Match/Merge/Unmerge to depict various hierarchies.
• Experienced in the identification of user requirements, System Design, writing Program specifications, Coding, Implementation and Testing of EIM Systems.
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional modeling (Star Schema, Snow Flake Schema, FACT & Dimension Tables) OLTP and OLAP.
• Experience in Informatica Power Center tools such as Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Experienced in Data Integration from multiple sources like Relational tables, flat files, MS Excel & XML files.
• Extensive experience in developing complex mappings using packaged transformations like Router, Connected and Unconnected lookups, Joiner etc.
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1 and type2.
• Used Debugger in Informatica Power Center Designer to check the errors in mapping.
• Experience in writing complex SQL queries and PL/SQL, including the use of stored procedures, functions and triggers , Views, Indexes, Joins, Sub-Queriesand Packages to implement business rules and validations.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team

TECHNICAL SKILLS:

Data Warehousing:  Informatica 8.6.1/8.1/7.1/6/5.1.1/1.75 , Data Stage 8.x, Ab initioReporting Tools Cognos 8.0 Suite, Business Object XI 3.1, Crystal Reports, SSAS, SSRS, MicroStrategy 8.x

Data Modeling:  Star-Schema Modeling, Snowflake-Schema Modeling, Fact and Dimension tables, Pivot Tables, Erwin

Testing Tools:  HP Quality Center, Rational Tools

RDBMS:  Oracle 10g/9i/8i/7.x, MS SQL Server 2005/2008, UDB DB2, Sybase, Teradata V2R6, MS, Access 2008

Programming:  UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL*Plus, PL/SQL, TOAD, C++

Web Technologies:  JavaScript, HTML 4.0, and DHTML, .NET, Java, J2EE, XML, XSD, XSLT

Environment:  UNIX, MVS, IBM AIX 4.2/4.3, Hyperion, Win 3.x/95/98, NT 4.0

Databases:  Oracle 10g/9i/8i, MS SQL Server … DB2, Teradata V2R6 , Netezza NPS 8050

Defect Tracking Tools:  TFS, Bugzilla, JIRA

PROFESSIONAL EXPERIENCE:

Confidential, Canonsburg, PA

Informatica MDM Developer

Responsibilities:

• Integrated Customer data from different sources eg. (IMS, SFDC, NCPDP ETC...)to create a Customer Master Data to get best version of truth as golden record
• Successfully completed the Hub configuration phase to deployment of the project.
• Defined standard interfaces, Data Profile, metadata acquisition, data migration, validation, pre-landing processing and Reference Entities
• Analyzed customer/product data residing in various source systems and defined these source systems in Hub
• Defined the landing tables, staging tables, and configured base objects
• Defined foreign-key relationships, lookups, query groups and queries
• Designed & developed multiple cleansing and standardization scenarios using source to target mappings in IDQ to get the data cleansed and standardized
• Developing and reviewing configuration documentation and design documentation as well as analyzing functional specifications and user requirement documents
• Created reusable transformations and Mapplets and used them in complex mappings to maintain the reference data from different sources
• Created Web services in IDQ for reference data to be accessed by different downstream source system

Environment: Informatica Multidomain MDM 9.7.1, Informatica Power Center 9.5.1, Informatica Data Quality 9.5.1, Weblogic, Oracle 11g, SQL Developer, Service Now, MTC, Documentum

Confidential, Quincy, MA

Informatica MDM Business Analyst/ Lead Developer

Responsibilities:

• Involved in complete life cycle of MDM implementations on Informatica MDM 9.7.1 and MDM 9.5.1 for POC.
• Provided assistance to team members for gathering requirements, writing technical designs, build and unit test, coordination of testing and peer reviews
• Analyzing the need and fitment for MDM Hub in the typical enterprise application ecosystem of company
• Integrated Customer data from different sources to create a Customer Master Data to get best version of truth as golden record
• Helped in ETL process to load data into landing tables of MDM Hub using Informatica 9.6.1
• Successfully completed the Hub configuration phase to deployment of the project
• Defined standard interfaces, Data Profile, metadata acquisition, data migration, validation, match rules tuning, reject processing, pre-landing processing and Reference Entities
• Analyzed customer/product data residing in various source systems and defined these source systems in Hub
• Defined the landing tables, staging tables, and configured base objects
• Defined foreign-key relationships, lookups, query groups and queries
• Designed & developed multiple cleansing and standardization scenarios using source to target mappings & Address Doctor and also configured decay characteristics for trust enabled columns and set validation rules accordingly
• Implemented Match/Merge/Unmerge to depict BEST VERSION within Customer’s (customer/Party) entity.
• Involved in Batch job error debug and handling, Batch jobs design, Batch Group design, Release Management, schema exports and imports using metadata manager
• Conducted data Steward Team workshops helped in documentation and reporting.
• Help in mentoring team member on various aspects of project, software processes and methodology
• Closely works with the reporting team to ensure that correct data is presented in the reports.

Environment: Informatica Multidomain MDM 9.7.1, SIF Services, Informatica Power Center 9.6, Informatica Power Exchange 9.6,Weblogic, Oracle 11g, SQL Developer

Informatica Multidomain MDM 9.6.1, Informatica Power Center 9.5, Weblogic, Oracle 10g, SQL Developer, Address Doctor, SIF, Toad, SQL*Loader, Windows Server 2003, Erwin, RRC

Address Doctor, IDQ, DDM, SIF, Toad, SQL*Loader, Erwin, OBIEE, RRC/RTC.

Confidential, Wilmington, DE

Informatica MDM Business Analyst/ Lead Developer

Responsibilities:

• Involved in complete life cycle of MDM implementations on Informatica MDM 9.5.1 from Siperian XU SP2.
• Provided assistance to team members for gathering requirements, writing technical designs, build and unit test, coordination of testing and peer reviews .
• Helped in ETL process to load data into landing tables of MDM Hub using Informatica 9.1.
• Successfully completed the Hub configuration phase to deployment of the project.
• Defined standard interfaces, Data Profile, metadata acquisition, data migration, validation, match rules tuning, reject processing, pre-landing processing and Reference Entities.
• Analyzed customer/product data residing in various source systems such as (CMS, MedPro, IMS, SAP, SAPVEN, TS, LVW etc..) and defined these source systems in Hub.
• Designed & developed multiple cleansing and standardization scenarios using source to target mappings &Trillium.
• Reconfiguring trust settings, updating existing queries and packagesas well as writing new custom queries and packages, modifying existingCleanse Functions and cleanse lists as well as developing new ones.
• Implemented Hierarchy Manager Module in addition to Match/Merge/Unmerge to depict various hierarchies within Customer’s (customer/Party) and Product entity.
• Involved in Batch job error debug and handling, Batch jobs design, Batch Group design, schema exports and imports using metadata manager.
• Involved with Data Steward Teamfor designing, documenting and training.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.
• Performing ORS validation and promoting changes using SiperianMetadata Manager as well as error handling through manipulation ofbackground Siperian metadata tables.
• Responsible for such Informatica configuration tasks, settinguser access and Security Access Manager Configuration.
• Experienced on Mercury Quality Center for Application testing
• Working closely with Project Manager & Architect providing supportto all the middleware related fields
• Always in synchronize with Testers, Developers & DBA admins to makesure Environment in GREEN
• Developing and reviewing configuration documentation and designdocumentation as well as analyzing functional specifications and userrequirement documents

Environment: Informatica Multidomain MDM 9.5.1, Informatica Power Center 9.1,JBoss, Oracle 10g, SQL Developer, Trilliium, SIF, Toad, SQL*Loader, Windows Server 2003, Erwin, MQC .

Confidential

Informatica MDM Analyst/ Developer

Responsibilities:

• Involved in complete life cycle of MDM implementations on Informatica MDM 9.1.0
• Provided assistance to team members for gathering requirements, writing technical designs, build and unit test, coordination of testing and peer reviews
• Analyzing the need and fitment for MDM Hub in the typical enterprise application ecosystem of company
• Integrated Customer data from different sources to create a Customer Master Data to get best version of truth as golden record
• Responsible for GAP Analysis to help identify current and proposed structure of MDM system
• Helped inETL process to load data intolanding tables of MDM Hub using Informatica 9.1
• Successfully completed the Hub configuration phase to deployment of the project
• Defined standard interfaces, Data Profile, metadata acquisition, data migration, validation, match rules tuning, reject processing, pre-landing processing and Reference Entities
• Analyzed customer/product data residing in various source systems such as(CRM,LEGACYand DNB) and defined these source systems in Hub
• Defined the landing tables, staging tables, and configured base objects
• Defined foreign-key relationships, lookups, query groups and queries
• Designed & developed multiple cleansing and standardization scenarios using source to target mappings&Address Doctor and also configured decay characteristics for trust enabled columns and set validation rules accordingly
• Implemented Hierarchy Manager Module in addition toMatch/Merge/Unmerge to depict various hierarchies within Customer’s(customer/Party) and Product entity
• Involved in Batch job error debug and handling, Batch jobs design, Batch Group design, Release Management, schema exports and imports using metadata manager
• Involved with data Steward Team for designing, documenting and configuring IDD
• Implemented IDD for Customer and Product centric Hub schemas internally to validate functionality and performance for IDD
• Help in mentoring team member on various aspects of project, software processes and methodology
• Closely worked with the reporting team to ensure that correct data is presented in the reports

Environment: Informatica MultidomainMDM 9.1, Informatica Power Center 9.1,JBoss, Oracle 10g, SQL Developer, Address Doctor,IDD,SIF, Toad, SQL*Loader, Windows Server 2003, Erwin