SUMMARY:

• 12+ years of IT experience in Software Design, Development, Analysis, Testing and Implementation of business applications for Manufacturing, Financial and Utilities verticals.
• Installation and Configuration of Informatica MDM Hub 9.7.x/10.x, Cleanse and Match Server, Informatica Power Center.
• Creating Landing, Staging and Base Tables and defining Foreign Key relationships, Lookups in the Hub.
• Developing the Mappings to move the data loaded from Landing to Stage by using various cleanse functions.
• Working with Hierarchy Manager to develop to Hierarchies as per the business needs.
• Defining Static and Dynamic Lookups for Displaying the Data on the Hierarchies.
• Creating IDD application as per the business needs by creating the subject area and subject area groups.
• Developing Put and Display packages for both Hierarchy Manager and IDD Application.
• Defining the Match and Merge Rules in the MDM Hub by creating Path components, Columns and rules.
• Running the Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Process.
• Data Processing experience in designing and implementing Data Mart applications using ETL tool Informatica Power Center 9.1/8.6.1 and Informatica Power Exchange 9.x.
• Adept at understanding business processes / requirements and implementing them through mappings and transformations.
• Involved in Database design, entity relationship modeling and dimensional modeling using Star and Snowflake schemas.
• Extensively worked with mappings using different transformations like Filter, Joiner, Router, Source Qualifier, Expression, Union, Update Strategy, Unconnected / Connected Lookup, Aggregator and SCD Type - 1,2&3.
• Experience in tuning Mappings and Sessions for better Performance.
• Experience in loading various data sources like Oracle, SQL Server, ERP’s, DB2 and Flat Files into Data marts.
• Skilled professional experience in developing test plans, test cases, test procedures and execution of application using both Manual, Automated-testing tools.
• Dimensional modeling.
• Experience in writing Stored Procedures, Functions, and Packages etc using PL/SQL.
• Support and Maintenance of existing data warehouse and Informatica Servers through Informatica Administration console.
• Worked on Informatica Administration Tool to maintain Informatica Servers, repositories, integration services.
• Upgrading Informatica Power Center applications and applying hotfixes.
• Developing Functional and Technical Specifications and provide User Training.

TECHNICAL SKILLS:

EIM Tools: Informatica MDM 9.x, 10.x, IDD

ETL: Informatica Power Center 9.5/9.1/8.6.1 , Informatica Data Quality/Analyst 9.5/9.1, Informatica Power Exchange 9.1

Operating Systems: UNIX (Solaris 8, Linux 9), Windows XP/2000/NT/98.

App Servers: JBoss EAP 6.1/6.2

Languages: C, C++, SQL, PL/SQL.

Databases: Oracle 11g/10g, MS SQL Server 2000/2005/2008/2012 , Teradata

PROFESSIONAL EXPERIENCE:

Confidential, TX

Informatica MDM Lead Consultant

Environment: Informatica MDM Multi-domain 10.2, JBoss EAP 6.4, Oracle, Rundeck Scheduler

Responsibilities:

• Created Low Level Technical Design document for MDM/IDD configuration during the design phase
• Worked on staging and loading process using the batch viewer for initial and adhoc loads
• Configured Match paths, Match Columns and Match rules (Exact and Fuzzy) in the Match/Merge and cascading unmerge Process
• Extensively worked on very complex process of Assets Match-Merge process
• Developed 3 different IDD applications for different business teams with different requirements
• Worked on Adhoc Unmerge/batch delete requests by business users
• Configured hierarchies and relationships for Assets, Customers, Entities, Financial Entities and product domains
• Created roles and assigned users for different IDD applications and business units.
• Customized the IDD application UI as per business requirements
• Worked on Informatica MDM Administration issues, environmental issues and migration activities in production and non-production environments
• Performed Unit Testing, worked with Quality team on System Testing
• Created MDM query’s and packages for IDD application.
• Worked on MDM/IDD tasks in Agile sprint cycles
• Created Assets Entity 360 application using Informatica’s advanced Entity 360 framework
• Worked on Custom user exits for Hub and IDD

Confidential, MA

Informatica MDM Lead Consultant

Environment: Informatica MDM Multi-domain 9.7.1, Informatica MDM Multi-domain 10.1, WebSphere, Oracle

Responsibilities:

• Worked with business analysts and customer on requirements for MDM data model, trust/validation, match merge rules and IDD configuration
• Worked on MDM Logical, Conceptual and physical data models using EA Sparx data modeler tool
• Created Low level Technical Design document for MDM/IDD configuration during the design phase
• Worked on End-to-End MDM Hub configuration for data loading from Landing to Base tables and match-Merge for all parent and child tables
• Worked on Match paths, Match Columns and Match rules (Exact and Fuzzy) in the Match and Merge Process
• Worked on Security Access Manager (SAM) for creating roles and assigning users.
• Configured Hierarchies and relationships as per the business requirements
• Configured the whole BSC IDD application with all Subject Area Groups, Subject Areas and Subject Area childs and grand childs
• Customized the IDD application UI as per business requirements
• Configured business process workflows to manage data for Data stewards and Data Managers for managing MDM Data in IDD using ActiveVOS
• Worked on most of Informatica MDM Administration issues, environmental issues andmigration activities in production and non-production environments
• Performed Unit Testing, worked with Quality team on System Testing
• Created MDM query’s and stored procedures for IDD application.
• Worked on all major Informatica MDM environmental issues in Production and Non-Production environments.

Confidential, NJ

Informatica MDM Lead Consultant

Environment: Informatica MDM Multi-domain 9.7.1, Informatica MDM Multi-domain 10.1, JBoss EAP 6.1, JBoss EAP 6.2, SQL Server, ASG-Zena Scheduler

Responsibilities:

• Installed Informatica MDM 10.1 in SQL Server in Lab environment.
• Installed Informatica ActiveVOS as part of MDM 10.1 installation in Lab environment
• Worked on all MDM Admin activities like creating data sources, creating users, creating roles, promoting the code to all non-Production environments, applying hot fixes/patches to the environment in all non-Production environments
• Working with business on requirements for MDM data model and match merge rules.
• Working with business on requirements for IDD
• Configured the Automation process for Land, Stage and Load Process (Batch Group Process)
• Configured JMS Queues for MDM and JBoss Messaging
• Configured Hermes JMS for Queue management for Queues in JBoss JMS
• Configured ORS specific and regular SIF services
• Automated MDM deployments through Metadata commands
• Automated daily backups of MDM metadata
• Working on Match paths, Match Columns and Match rules (Exact and Fuzzy) in the Match and Merge Process
• Worked on Security Access Manager (SAM) for creating roles and assigning users.
• Working on IDD application to search Devices by creating subject area groups, subject areas, subject area child
• Working on manual merge tasks for Data stewards and managers for managing manual merge tasks
• Created MDM query’s and stored procedures for IDD application.
• Work on all administration issues in Production and Non-Production environments.
• Work on Repository manager to migrate the code between Dev to QA or QA to Prod environments.

Confidential

Informatica MDM Lead Consultant

Environment: Informatica MDM Multi-domain 9.7.1, JBoss EAP 6.1, Informatica Power center 9.1, SQL Server, Redwood Scheduler

Responsibilities:

• Installed Informatica MDM 9.7.1 in SQL Server in Sand Box environment.
• Applied hotfix 2,3 for Informatica MDM 9.7.1 in SQL environment
• Worked with business team for new requirements and enhancements to existing requirements.
• Worked on all MDM Admin activities like creating data sources, creating users, creating roles, promoting the code to all non-Production environments, applying hot fixes/patches to the environment in all non-Production environments
• Defined and developed the ETL process to load the data into the landing tables during the land process using Informatica Power Center
• Configured the Automation process for Land, Stage and Load Process (Batch Group Process)
• Completed manual landing, staging and loading process using the batch viewer
• Developed the Match paths, Match Columns and Match rules (Exact and Fuzzy) in the Match and Merge Process
• Worked on Security Access Manager (SAM) for creating roles and assigning users.
• Created and Implemented IDD application to search Devices by creating subject area groups, subject areas, subject area child
• Created manual merge tasks for Data stewards and managers for managing manual merge tasks
• Created MDM query’s and stored procedures for IDD application.
• Worked on all production issues in MDM and IDD.
• Worked on all administration issues in Production and Non-Production environments.
• Worked on Repository manager to migrate the code between Dev to QA or QA to Prod environments.

Confidential, NC

Informatica MDM Lead Consultant

Environment: Informatica MDM Multi-domain 9.7.1, 10.x, JBoss EAP 6.2, Informatica Power center 9.1,Informatica Data Quality/Analyst 9.1, Oracle 11g, SQL Server, Erwin, DIS Scheduler

Responsibilities:

• Involved in the business requirements sessions with business for all project requirements.
• Involved in data modeling sessions for creating the model along with data modelers to align the model with project requirements
• Configured Address Doctor in Informatica Data quality tool and standardized the address data coming from source systems
• Installed Informatica MDM 9.7.0 in Oracle environment in all Non-Production environments.
• Applied hotfix 1 for Informatica MDM 9.7.1 in Oracle environment
• Upgraded Informatica MDM 10 in Oracle environment in all Non-Production environments.
• Worked on all MDM Admin activities like creating data sources, creating users, creating roles, promoting the code to all non-Production environments, applying hot fixes/patches to the environment in all non-Production environments
• Created the landing tables, base tables and staging tables as per the enterprise data model.
• Defined and developed the ETL process to load the data into the landing tables during the land process using Informatica Power Center and Informatica Data Quality tools
• Configured the Foreign Key Relationships among the Base Objects and define the lookups for the staging tables
• Created MDM landing to stage mappings as per the project requirements
• Configured the Automation process for Land, Stage and Load Process (Batch Group Process)
• Completed manual landing, staging and loading process using the batch viewer
• Used Metadata manager to Import and Export of Metadata and Promote Incremental changes between environments from development to QA/LDQA.
• Worked closely with the Business in gathering the Match rules and created the Match rule document
• Developed the Match paths, Match Columns and Match rules (Exact and Fuzzy) in the Match and Merge Process
• Worked Security Access Manager (SAM) for creating roles and assigning users.
• Created and Implemented IDD application to search Customer and Security by creating subject area groups, subject areas, subject area child
• Created manual merge tasks for Data stewards and managers for managing manual merge tasks
• Created MDM query’s and stored procedures for IDD application.

Confidential

Informatica MDM Lead Consultant

Environment: Informatica MDM Multi-domain9.5, JBoss, Informatica Power center/Analyst 9.1, Oracle 11g, SQL Server, Linux, Trillium data quality, Microsoft Project, Erwin, Autosys

Responsibilities:

• Involved in the brain storming sessions for deciding the data model with Solution and Data Architect
• Created, redesigned and worked on physical data model and helped for logical data model extension using Erwin
• Configured Address Doctor by doing the changes in the Config files on the hub server
• Created the landing tables, base tables and staging tables as per the data model
• Defined and developed the ETL process to load the data into the landing tables during the land process
• Configured the Foreign Key Relationships among the Base Objects and define the lookups for the staging tables
• Configured the Automation process for Land, Stage and Load Process (Batch Process)
• Developed mappings using various cleanse and address doctor functions
• Did manual landing, staging and loading process using the batch viewer
• Used Metadata manager to Import and Export of Metadata and Promote Incremental changes between environments from development to testing phase
• Worked closely with the Business in gathering the Match rules and created the Match rule document
• Developed the Match paths, Match Columns and Match rules (Exact and Fuzzy) in the Match and Merge Process
• Ran the Match and Merge set up and fine tuned the Match rules
• Worked on Hierarchy manager for hierarchical relationships between design objects using entities and hierarchies
• Worked Security Access Manager (SAM) for creating roles and assigning users.
• Created and Implemented IDD application to search Dealer by creating subject area groups, subject areas, subject area child.
• Created MDM stored procedures and batch groups for MDM hub.

Informatica Consultant

Environment: Informatica Power Center 8.6.1,9.1 as ETL Tool, Informatica Power Exchange 8.6.1,9.1 as CDC tool and Sql Server 2008 as Database. Front Range ITSM for defect tracking

Responsibilities:

• Responsible for monitoring the entire Power Exchange groups on Mainframes and in Informatica Power Center.
• Responsible for maintenance of Power exchange Restart tokens in all Informatica Environments.
• Development of new features and implement Change data capture CDC and maintenance of code.
• Responsible for End-to End Testing for newly developed features.
• Resolving incidents based on Service Level Agreements(SLA’s)
• Distributing the work between offshore team members and tracking the development progress.
• Doing Data certification and resolving the data mismatches.
• Responsible for moving the repositories to other boxes during database upgrades.
• Responsible for monitoring all the Informatica regions such as AIT, UAT and Prod Support and Production.
• Scheduling the newly developed workflows and clearing the disk space in Informatica server.
• Responsible for New Installations/Upgrades for the Informatica Power Center and Informatica Power Exchange.
• Responsible for all administration tasks for Informatica Power Center and Informatica Power Exchange.

Confidential

Informatica Power Center Developer

Environment: Informatica Power Center 8.6.1, Oracle 10g, UNIX Shell Scripting, SQL Navigator

Responsibilities:

• Analyzing the Source System.
• Designing approach.
• Development of the Informatica Mappings.
• Development of the Informatica Sessions/Workflows.
• Development of the SQL queries to pull the data from Source.
• Development of the small shell scripts required for Informatica Objects.
• Development of the Database objects like Tables/views.etc.
• Scheduling the Informatica Workflows.
• Monitoring and Supporting the Informatica workflows

Confidential

Informatica Power Center Developer

Environment: Informatica Power Center 8.6.1, Oracle 10g, UNIX Shell Scripting, Toad 8.6, Remedy Action Request System, Control M, DataAllegro, Teradata.

Responsibilities:

• Analyzed business requirements, and worked closely with the DA's involved to domain and sources to target data mapping document.
• Worked with DA's on logical and physical model designs of both Base and Package layers.
• Re-designed the mappings existed for MPG DATA-Marketing Programs Global program in such a way that they can be used for this program for the daily loads in Teradata.
• Package layer is being implemented using Teradata macros and Informatica. As the volumes for the daily loads being 20-30 mil records approximately tuned the queries in such a way that the performance will be good.
• Worked with DBA to set up development, test, stage and production environments in Teradata.
• Performed unit testing and documented the results.
• Worked closely with QA team during the testing phase and fixed bugs that were reported
• Developed and Scheduled Control M jobs for the daily load invoked Informatica workflows & sessions associated with the mappings, SQL scripts to drop & recreate the indexes on source and target tables, Unix Script to create / update the parameter file, check source / target database connectivity, delete tag files etc.
• Prepared code migration document and worked with release team in migrating the code from Development to UAT, Production Servers.

Confidential

Informatica Power Center Developer

Environment: Informatica Power Center 8.6.1, Oracle 10g, UNIX Shell Scripting, Toad 8.6, Remedy Action Request System, Control M, DataAllegro.

Responsibilities:

• Analyzed business requirements, and worked closely with the DA's involved to domain and sources to target data mapping document.
• Worked with DA's on logical and physical model designs.
• Worked as point of contact from Off-shore.
• Worked closely with On-site team.
• Learnt the EBI2.0 architecture and implemented it for different data sources like SavedCart, Gems, MyAccount and Clickstream.
• Coordinated with different teams to update the reusable objects in the Global Shared folders.
• Worked on removing the major bottlenecks faced while working on the SK tables.
• Optimized the Informatica session by using partitioning and SQL queries for load the huge data volumes.
• Created the lrf file structures and scripts for different target tables.
• Worked with DBA to set up development, test, stage and production environments.
• Developed complex mappings using transformations such as the Source qualifier, Aggregator,
• Expression, Lookups, Router, Sequence Generator, Update Strategy, and Xml Generator.
• Performed unit testing and documented the results.
• Worked closely with QA team during the testing phase and fixed bugs that were reported
• Developed and Scheduled Control M jobs for the daily load invoked Informatica workflows & sessions associated with the mappings, SQL scripts to drop & recreate the indexes on source and target tables, Unix Script to create / update the parameter file, check source / target database connectivity, delete tag files etc.
• Prepared code migration document and worked with release team in migrating the code from Development to UAT, Production Servers.
• Reviewed code, design and test plans as appropriate throughout project lifecycle to assure IT compliance.
• Involved in the Software Change and Configuration Management process by checking in all versions of the Informatica objects and all releases of various documents in Serena PVCS change manager to keep track of the changes in the development, test and production environment.