SUMMARY

• 10+ years of total experience in Information Technology Industry, expertise in developing Business Intelligence and Data Warehousing applications and Master Data Management process, especially using ETL Informatica PowerCenter, IDQ and Informatica MDM.
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as Install, Design, Development, Testing, Deployment, Maintenance and Production Support for DWBI technologies on various platforms like UNIX and Windows.
• 4+ Years of experiencing in configuring maintenance, testing and troubleshooting on Informatica Master Data Management 10.1/9.7.1/9.5.1/9.1 (MDM) and Informatica Data Quality 10.1/9.5.1.
• Good knowledge of Hadoop ecosystems, HDFS, Big Data along with the Hive’s analytical functions.
• Implemented Proof of concepts on Hadoop stack and different bigdata analytic tools, migration from different databases (i.e. Teradata, Oracle, MySQL) to Hadoop.
• Experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups, query groups, queries and packages.
• Experience in configuring Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management.
• Experience in testing user exits and configuring Message queues as per business requirement.
• Experience in integrating external business application with Informatica MDM hub using Batch processes, and the SIF.
• Experience working with ORACLE, SQL Server, My SQL databases & writing complex queries.
• Experience in development, configuration and management of Informatica objects and also working on design reviews and code reviews.
• Exposure in HTML, XML and also working in SOAP, REST Web services.
• Familiar with JBoss , Web Logic, Web Sphere application server.
• Experience in deploying and testing web services (JAR,EAR files) in WEBSPHERE
• Good working experience with Agile Software Development Methodology.
• Extensive ETL experience using Informatica Power center client tools (Designer, workflow manager, workflow monitor and server manager).
• Experienced in UNIX work environment, file transfers (FTP, SFTP), job scheduling and error handling.
• Hands on experience on UNIX shell scripts for Informatica pre-& post session operations.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Experience in support and knowledge transfer to the production team.
• Extensive functional and technical exposure. Experience working on high-visibility projects.
• Assign work and provide technical oversight to onshore and offshore developers.

TECHNICAL SKILLS

EIM Tools: Informatica MDM Multi-Domain, IDD, SIF

ETL Tools: Informatica Power Center 10.x/9.x/ 8.x/7.x, Informatica DQ, Informatica B2B DX, DT, DTA, Talend RTX 4.1

Data Warehousing: Informatica Power Center 9x/8x/7x/6x, Informatica Power Exchange 7.x/8.x, Repository Manager, Designer, Workflow Manager, workflow Monitor.

Databases: Oracle 11g/10g/9i/8i, SQL Server 2008, Teradata V2R5 MS Access, MS-Excel.

RDBMS Load Tools: Toad, SQL Developer, SQL Loader, SQL plus.

Design/Application Tools: Star-Schema Modeling, Snowflakes Modeling, Fact and dimension tables, Erwin, Toad, SQL Navigator, Clear case, Control-M, Maestro, Microsoft Visio.

Programming Skills: SQL, PL/SQL, UNIX shell scripting.

Data Modeling Tools: MS - Visio, Erwin

Operating Systems: UNIX, Windows 98/2000/2007/ XP/NT, UNIX (Solaris, AIX).

PROFESSIONAL EXPERIENCE

Confidential, Andover, MA

Informatica MDM Lead/Sr Software Engineer

Responsibilities:

• Need to work primarily on complete MDM Development building the solution from the scratch and delivering to the business and need to focus on Data Analysis on the design map Analysis, developing the solutions for Enterprise data warehouse (EDW), Master Data Management (MDM), Data Quality, Data Migration.
• Need to work on Installation and configuration of Informatica MDM Hub Console, Hub Server (Master Reference Manager, HM, AM), Cleanse Match Server, Cleanse Adaptor, IDD (Informatica Data Director) and SIF (Services Integration Framework).
• Need to show expertise in strategizing and defining MDM Road Map, planning, requirements gathering, design and configuration, Technical design document for MDM HUB, Data Quality and ETL.
• Need to work on configuring Hierarchies tool for 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.
• Need to have highly proficient in Configuring HUB for Landing, Stage and load Process, Match and Merge rules, Trust and validation, Hierarchies, MDM Mappings, cleanse functions, queries and packages, JMS messages, Trigger Setup, Batch Groups, reject data reprocessing, SIF and knowledge of User Exits.
• Need to Help business to understand the Match rules configuration and match/merge rules in a way how we defined the Match and Merge Rules in the MDM Hub by creating Match Path components, Match Strategy, Population and Match columns and rules and also Fine tuning the match rules.
• Need to extensively use IDQ for functional analysis, Profiling and for development activities and invoking IDQ as Mapplets for massive data profiling using IDQ (Analyst Tool) prior to data staging.
• Need to create landing tables, base tables, staging tables according to the data model and number of source system.
• Utilized SOAP UI to call SIF API requests for Data Clean up services/ Data Put services/ Data retrieval services / testing the cleanse functions services.

Environment: Informatica MDM MDE 10.3, IDD, JBOSS 6.4, SQL Server, Java Eclipse IDE, IDQ, Batch Scripts, Resource Kit.

Confidential, PA

Informatica IDD/MDM Tech Lead

Responsibilities:

• Need to involve in planning and design review meetings with technical leads and project managers.
• Need to participate in the BRDs Sessions, giving insightful perspective of the MDM Hub and its environment for Item Master and Provider domains.
• Need to create IDD application to support the ongoing business needs to feed the data into the hub.
• Need to Customize/configure IDD application for the respective domains and also need to create and define the subject areas according to the business requirement.
• Customizing/configuring the IDD application and Subject Areas, Subject Area Groups.
• Deploy and test IDD application, cleanse functions, utilizing timeline, export and import master data.
• Creating Users for testing the IDD application in all the environments and providing the required access to the users.
• Need to determine schedules, review technical problems, and assign tasks and resources.
• Provide technical leadership to MDM team on design and implementation for respective domains.
• Need to analyze the rejections and build a process to handle those rejections. This requires a clear business requirement from the business on how to handle the data rejections.
• Need to Implement Post Landing, Pre-Staging, Save Handler User Exits using Eclipse Mars and integrated those user exits with MDM Hub Console using User Object Registry module.
• High level review of SAM discussed use of Roles, creation of users and assignment of user to Role.

Environment: Informatica MDM MDE 10.2 IDD, JBOSS 6.2 Oracle 11g SQL/PLSQL, Toad, Oracle SQL Developer, Visio, Windows XP, Remedy Change Management, Control M, UNIX Shell Scripting, Informatics, Business Objects, VPN, Putty, SVN, Erwin.

Confidential, Wilmington, MA

Sr Informatica MDM Developer

Responsibilities:

• Involved in gathering business requirements for the HUB configuration.
• Worked closely with ETL data architect for performing land batch process to populate data from external source systems to landing tables in hub.
• Configured the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages, query groups and custom functions.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• 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.
• Scheduling and supporting HUB data base weekly backups.
• Used Metadata manager to validate ORS and promote the objects between environments.

Environment: Informatica MDM MDE 10.1.1, IDD, JBOSS 6.2 Oracle 10g SQL/PLSQL, Toad, Oracle SQL Developer, Visio, Windows XP, Remedy Change Management, Control M, UNIX Shell Scripting, Informatics, Business Objects, VPN, Putty, SVN, Erwin.

Confidential, Rocky Hill, CT

Sr Informatica MDM Consultant

Responsibilities:

• Participate in the BRDs Sessions, giving insightful perspective of the MDM Hub and its environment for Item Master and Provider domains.
• Conduct MDM technical interviews with candidates for MDM positions for the project.
• Participate in planning and design review meetings with technical leads and project managers to determine schedules, review technical problems, and assign tasks and resources in Provider Domain.
• Provided technical leadership to MDM team on design and implementation for Item Master and Provider Domains.
• Participate in Requirements Analysis, Gap-Fit each MDM requirement as well as provide high level of estimate for the level of effort required to meet each requirement.
• Designing and developing data cleansing and standardization using the cleanse functions in Informatica MDM.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
• Customized/configured IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, export and import master data.
• Apply Hotfixes to MDM servers and supported for server maintenance.
• Created Users, Roles and User Groups to grant required access.
• Taking care about administration tasks like creating MDM ORS, migrating objects between environments and servers maintenances.
• Taking care about ETL and MDM jobs which are running daily, weekly, monthly and quarterly basis.
• Problem solving, data issues and reject resolutions for MDM process.
• Created user exists for task assignment and HDD implementation.

Environment: Informatica MDM MDE 10.1.1, IDD, ActiveVOS, Informatica PowerCenter 10.1/9.5.1, JBOSS 6.2, IDQ 10.1/9.5.1, SalesForce.Com(SFDC),SQL Server 2012, Batch Scripts, Resource Kit, WinSCP, HL7, Windows Server 2012, Address Doctor 5.

Confidential, Hoboken, NJ

Informatica MDM Consultant

Responsibilities:

• Formulated data governance rules and master data requirements and also implemented data architecture guidelines and MDM quality standards.
• Designed and developed service level agreements for MDM processes and participated in requirements analysis and designing of MDM projects.
• Prepared and maintained MDM blueprints and technical processes and provided assistance in designing of MDM application systems with MDM tools.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Took ownership for populating and validating lookup tables associated to data model.
• Defined Match rules in Match and Merge settings of the base table by creating Match Path Components , Match Columns and Rule sets .
• Created IDD application to support the ongoing business needs to feed the data into the hub.
• Created roles, users for roles, and assigned privileges to roles using Security Access Manager.
• Involved in performance tuning and query optimization.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Used Debugger to fix the defects/ errors and data issues.
• Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Monitored and improved query performance by creating views, indexes, hints and sub queries
• Extensively involved in enhancing and managing Unix Shell Scripts.
• Developed workflow dependency in Informatica using Event Wait Task, Command Wait.

Environment: Informatica Power Center 9.5, Informatica MDM 10.0, HF2, 10.1, IDD, WebSphere, Jboss, Trillium, TFS, Oracle 11i, SQL Server 2008, MS Access 2010, FLINK, SQL*Loader, UNIX, Winscp, Putty, Erwin 7.2, SQL, PL/SQL.

Confidential, Bluebell, PA

Informatica MDM Consultant

Responsibilities:

• Working with business analysts to gather business requirements and implementing the same into a functional data warehouse design.
• Prepared Business Requirement Documents (BRD’s) referring to the Functional Requirements provided by System Users that described the scope of work for technical team to develop prototype and overall system.
• Involved in greater insights which are made possible by combining data from multiple payers and increasing the number of claims to detect new patterns and establish correlations with strong statistical validity.
• Combining data from multiple payers and creating a consistent provider identifier across those claims streams can highlight problems that might not be obvious from just one health plan.
• Worked on various Healthcare payers, including the Centers for Medicaid and Medicare Services (CMS), are banking on informed, engaged consumers to play an increasingly important role in driving down healthcare costs.
• Worked on an Agile SDLC model to deploy our product and customer data.
• Worked towards data modeling, baseline the data model to accommodate all business specific requirements and configured Informatica MDM Hub Server, Lookup Adapter, Cleanse Server, Cleanse Adaptor and Resource Kit.
• Deployed new MDM Hub for portals in conjunction with user interface on IDD application.
• Worked on integrating Hierarchies created in MDM Hub Console and IDD.
• High level review of SAM - discussed use of Roles, creation of users and assignment of user to Role
• Implemented Search feature, Add/Update feature and Task Assignment feature in IDD for Admin user.
• Implemented Post Landing, Pre-Staging, Save Handler User Exits using Eclipse Mars and integrated those user exits with MDM Hub Console using User Object Registry module.
• Used ActiveVos Business process management model to deploy and manage process applications that combine system and human tasks.
• Using ActiveVos to create BPMN2.0 compliant process models that seamlessly integrate people, processes and systems for increasing the efficiency and visibility.
• Worked on production issues like bug fixing, bottlenecks, data validation and report errors.
• Scheduled Informatica jobs through Control M as per the business requirement.

Environment: Informatica MDM 10.1, Informatica Multi Domain Edition MDM 9.7.1 HF3, IDQ, IDD, SIF, Address Doctor5,ActiveVos, Informatica Power Center 9.6.1, Informatica B2B Data Exchange 8.6, Informatica B2B Data Transformation Studio 8.6, Cognos8.x, Control-M, Oracle 11g, PL/SQL, Visio, TOAD, SQL*Plus, Java, JBoss Application Server, XML, Windows, Winscp, UNIX, Putty, Business Objects Xi3.1.

Confidential, KOP, PA

Informatica MDM Consultant

Responsibilities:

• Profiled the data using Informatica Analyst tool to analyze source data (Departments, party and address) coming from Legacy systems and performed Data Quality Audit.
• Configured and installed Informatica MDM Hub server, cleanse, resource kit, and Address Doctor.
• Analyzed the source systems for erroneous, duplicative, and integrity issues related to the data.
• Planned, created and executed SSIS packages to integrate data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.
• Extracted data from Salesforce.com(SFDC),Oracle, excel, data files using Informatica ETL mappings/SQL PLSQL scripts.
• Deployed new MDM Hub for portals in conjunction with user interface on IDD application.
• Worked on integrating Hierarchies created in MDM Hub Console and IDD.
• Configured Entity Objects, Entity Types, Hierarchy and Relationship Types for Contract, Product, and Party Hierarchical view in IDD.
• Configured Supply Chain IDD Application for use by Data Stewards.
• Configured Queries and Packages for all the domains for use in IDD.
• Configured Subject Area Groups for Supplier, Manufacture, Product and Contract.
• Configured Roles for Read Only, Approver and IDD specialist for respective domains.
• High level review of SAM - discussed use of Roles, creation of users and assignment of user to Role
• Performed land process to load data into landing tables of MDM Hub using external batch processing for initial data load in hub store.
• Designed and built ETL mappings and workflows to load data from different sources Oracle, SQL Server and fixed width as well as Delimited Flat files.
• Modified reports and Talend ETL jobs based on the feedback from QA testers and Users in development and staging environments.
• Developed stored procedure to automate the testing process to ease QA efforts and also reduced the test timelines for data comparison on 5000 tables.
• Worked on advanced concepts like concurrent running of the workflow, session level partitioning techniques and pushdown optimization.
• Scheduled workflows using PMCMD and UNIX Shell scripts using Cron Tab for daily and monthly loads.

Environment: Informatica Multi-domain MDM 9.7.1, Address Doctor, IDD,SIF,Informatica Power Center 9.6.1, Control-M, Informatica B2B Data Exchange 8.6,, Informatica B2B Data Transformation Studio 8.6, Cognos8.x,Talend 4.1, SQL Developer, Java, Oracle 10g, Toad 10.6, WS02,SQL Server, Windows XP, UNIX, Putty & Winscp.