EXPERIENCE SUMMARY:

• Informatica Certified in MDM Hub with more than 10 years of IT experience in:
• Software Development Life Cycle (SDLC) analysis, design, development, testing, maintenance and quality assurance with implementation of end - to-end MDM and Data warehousing solution with extensive knowledge of MDM and DWH architecture. Architecture and Development Expertise:
• Expertise in different architecture of MDM and Data warehouse solutions with implementation knowledge and hands on experience in MDM/ETL tools like Informatica MDM, IDQ, PowerCenter.
• Team Lead experience to provide end-to-end MDM Solution as per the business needs, managed team and helped with technical solutions for on-time deliverable.
• Defined roadmap for the project implementation, Designing Party Data Model, setting up environments (Dev/TST/PROD), conducting demo and provided trainings.
• Good understanding of MDM requirements from the business in achieving the BVT (Best Version of Truth) Record and publish to the downstream applications.
• Extensive experience on Designing and developing MDM solutions. Configuring MDM objects like Base Objects, Match & Merge Rules, IDD Screens, Search/Display Queries/Packages, SIF APIs, System/Applications Health Checks, Infrastructure Upgrades and Testing/Validations.
• Development experience to work with different UIs (IDD or custom UI) to help end users to understand the master data for data stewardship and data governance.
• Experienced in integrating IDQ with MDM for staging MDM data and creating rules/mapplets for better cleansing. Developed IDQ mappings, web service calls and used SIF APIs to perform various operations.
• Good understanding of SIF and REST calls for MDM solution and experienced in IDD/HUB user exits, custom actions save and merge handlers and integration services for publishing the Master Data.
• Enterprise Data warehousing/MDM Testing - Data Integration, preparation and execution of test strategy, test plans and UAT, test scripts and performing regression testing for any business requirement for performance tuning and data validation
• Extensive experience on MDM Admin role/responsibilities and worked on Installation and Configuration and maintenance of all the Database instances, Informatica MDM Hub, Cleanse Match Server (Process Server), Import/export of ORS, Upgrading Master and User Specific ORS in different MDM versions and capability to apply any Hot Fixes and EBF.
• Administrative experience with installation of Informatica products like MDM, PowerCenter, CDC, IDQ fresh install and upgrades, creating repository, users and assigning privileges, migration and troubleshooting for any Hardware/software issues.
• Expertise on designing and implementing admin SOPs for security model, backup, disaster recovery for Informatica products and provide documentation for troubleshooting and diagnostic support.
• Scheduling ETL/MDM jobs for data loads, Match&Merge, monitoring systems performance, including on-going optimization and tuning of Informatica implementation.
• Experience with different application servers like WebLogic, jBoss, tomcat etc and configuring new data source, JMS queues, application deployments and managing servers like linux and windows environment.
• Extensive experience on Informatica DEV/QA/Pre-Prod and Production platform high availability, Performance monitoring and tuning using in Unix/Linux based environment and utilizing Incidents/outage management with SNOW, JIRA, V1 etc.
• Excellent skills and experience using the different web skills such as XML, HTML, XHTML, CSS, JQuery, Adobe Dreamweaver CS5, Photoshop, CMS like SiteCore and Joomla for web design and development.
• Trained on Data warehousing, Informatica MDM v9.x/10.x, IDQ, PowerCenter, Reltio and Java Integration tools.

TECHNICAL SKILLS:

EIM Tools: Informatica MDM 9.5, 9.7 and 10.x (several HFs/EBFs), Informatica Power Center v9.6.1/10.x, IDQ 9.x,10.x

Product Platforms: Informatica MDM v9.x/v10.x, Tomcat, WebLogic v10.3/12c, Jboss

Tools: / Software: Putty, Toad, SVN,COS, SNOW, HP ALM, JIRA, SNOW, SOAP UI, Eclipse, WinScp and UltraEdit, CMS, Adobe DreamweaverCS5, HTML5, CSS3, JQuery and ASP.net

Language: C++, Java, SOAP, SQL

Databases: MS Access, SQL Server 2005, Oracle 11g/10g/12c, Oracle EBS R12.

Technical Expertise: Informatica MDM Tool v9.x/10.x, Agile Methodology, MDM Concepts Data Cleansing and Matching, Data Warehousing Concepts, BI/DW Tools, CSS, Java Scripting, HTML, Advanced excel, SharePoint and Documentam, Unix, Linux

Operating Systems: Linux, Vista, Windows XP, Windows 2003, Apple OS x and iOS.

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Sr. MDM Developer

Responsibilities:

• As Senior developer, involved with Hub Design for CDER Informatics Platform.
• Completed Development and testing of Integrity Master Data Management capability.
• Worked closely with the Business Team to implement Hub/IDD changes for Application/Submission domain.
• Successfully completed UAT and deliver of end to end solution for Application/Submission domain.

Confidential

Informatica Sr. MDM Developer

Responsibilities:

• Worked closely with the Business Team to gather requirements/testing for the Match rules in identifying columns and setting Match Rules Sets as per project needs and configuration.
• Configured new source systems, relationships and lookups for Base Objects and Reference BO.
• Implemented various cleanse functions and set-up External Match process along with Match Tuning.
• Running all the MDM processes like Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes.
• Created IDD Applications and configured Task Assignment dashboard.
• Created and documented the secure resources, Users, Roles and assigned privileges to roles using MDM Hub Security Access Manager for Development, QA, Pre-prod and Prod environment.
• Provide weekly status updates on progress, status, and issues

Tools: Informatica MDM 10.1, IDD, Eclipse, SOAP UI, jboss, Oracle 12g, UNIX, Putty, WinSCP, SVN

Confidential, New York

Project Lead - Informatica MDM/IPC/IDQ Admin

Responsibilities:

• Communicated effectively among the various projects teams involving Application Support Team, Network, Database Teams, Storage and Unix teams.
• Proactively meeting with Business and technical team to meet the compliance and naming conventions.
• Played a key role for Infrastructure Support :
• Responsible to manage Development, QA and Production environments.
• Responsible to upgrade from current version to next version.
• Troubleshoot and Resolve and Infrastructure issues.
• Worked on multiple servers Prod, Non-Prod environments for the existing MDM/IPC/IDQ to make sure that code is sync in all the environments.
• Extensive experience in Outages Handling:
• Password Changes.
• Patch installation (Hot Fixes /EBF)
• Bouncing Activities or Restarting the Services.
• Network Changes
• Perform disaster recovery on all Informatica IPC/IDQ and MDM servers doing failover and failback.
• Performed major role as Infrastructure admin in Development and Production support projects Environment Monitoring:
• Constantly keeping eye on whether the infrastructure is readily available, keep monitoring the readiness in the environment.
• System level parameter checks CPU spike, Memory utilization, Number of parallel loads (sessions) running on each node.
• Monitoring the loads (workflows/BatchGroups) whether the loads are scheduled accordingly.
• Recovery or Re-start servers/services in case of any failures.
• Identifying the tardiness in loading process in case of any sessions are in hung status.
• Working with Informatica professional services (IPS) for any Product bug or issues.
• Daily support for MDM/IPC/IDQ application users for any error, data issues and performance, setting up access roles and privileges for IDD/IPC users and created SOP for enabling Audit.
• Involved in Installing and building new MDM/IPC/IDQ environments with the latest version and delivering on time.
• Performed infrastructure upgrade activities: Recently, Migrated from windows to Linux in IPC 9.6.1.
• Worked on multiple servers Prod, Non-Prod environments for the existing MDM/IPC/IDQ upgrade to the latest version and enabled Audit to fulfil secured environment needs.
• Monitoring JBOSS/IPC/IDQ servers performing Health Check, Disk/memory utilization to gather information for new server build requirement and troubleshooting any performance issues.
• Created Informatica Audit Reports for IPC for all the users at folder level/ Repository level access for SOX.
• Performed Deployment and migration activities for MDM/IPC in all the environments and Restarting servers as required for all the MDM/IPC and IDQ applications.

Tools: Informatica MDM V9.7.1HF6, 10.2, IDD, Jboss 6.2, Oracle 12c, UNIX, Putty, WinSCP, SVN, ServiceNow.

Confidential, Houston

IT Development Lead / Business Systems Analysts

Responsibilities:

• Translate high-level architecture and process flows into technical development items (SOAP web service integration, real time integration, message bus integration, enterprise application integration).
• Worked with Informatica Admin (MDM/ETL) activities including security, code promotion, config changes and issue debug.
• Actively gather business requirement and user needs to understand the Real Time processing needs for Web Service calls for this Integration.
• Proactively meeting with Business and Global technical team to gather information and distributing tasks to MDM and Java team for web service calls.
• Provide weekly status updates on progress, status, and issues

Tools: Informatica MDM 10.0, IDD, Eclipse, SOAP UI, Web Logic v10.3, Web Logic Admin Console, Oracle 11g, UNIX, Putty, WinSCP, SVN.

Confidential, Chicago

Informatica MDM Tech Lead

Responsibilities:

• Actively involved in gathering business requirements from the business users in understanding the Real Time processing needs and user exits.
• Worked closely with the Business Team to gather requirements/testing for the Match rules in identifying columns and setting Match Rules Sets as per project needs.
• Involved in process of identifying and configuring the Match paths, Match Columns and Match rules for Exact and Fuzzy Match and Merge Process.
• Involved in various discussion of requirement and defining External Match process.
• Supported MDM application and Production environment for IDD Applications for any data quality issue or to improve the performance of MDM applications.
• Created and documented the secure resources, Users, Roles and assigned privileges to roles using MDM Hub Security Access Manager for Development, QA, Pre-prod and Prod environment.
• Worked closely with Informatica to solve various defects. Issues such as null key match, issue with parsing foreign character while using Population file, sequence generation, data source issues.
• Worked with other supporting teams such as SOA integration team to verify a record created or updated in database is reflected in all downstream systems
• Write User Exits for validation errors and messages for save operation in IDD
• Provide weekly status updates on progress, status, and issues.

Tools: Informatica MDM 9.1, IDD, Eclipse, SOAP UI, Web Logic v10.3, Web Logic Admin Console, Oracle 11g, UNIX, Putty, WinSCP, SVN.

Confidential

Informatica MDM Hub Developer

Responsibilities:

• Worked on gathering the business requirements and finalizing the different scenarios for finished and non-finished goods for Functional Requirement documents for MDM Testing.
• Performed testing for various MDM Project application such as IDD/BDD, Java real time UI, Address and Key felids Validation user exits.
• MDM Hub Configuration for Different Source Systems, Trust, Landing, Staging, Base Object creation and unit testing.
• Created and documented the secure resources, roles, users for roles, and assigned privileges to roles using Security Access Manager in Development, QA, Pre-prod and Prod environment.
• Performed various code base line and code migration in different environments.
• Created System Design Document, Test Cases and SOPs for the data entry team.

Tools: Informatica MDM v9.1/v9.5, Web Logic, Web Logic Admin, Oracle 11g, UNIX, Putty, WinSCP, SVN and ESMS.

Confidential

Java Developer

Responsibilities:

• Involved in Knowledge Transition with T- Systems and Daimler at Germany
• Application documentation and Development Environment setup configuration
• Communication with the Client and Onsite team whenever required.
• Development of Java application, Web Sites/Pages using Java, SOAP and web technologies.
• Involves in defect analysis and providing the solution within time limit
• Project Planning and Tracking, Configuration Management (SVN tool), Code Reviews, troubleshooting & Defect prevention,
• Monitoring development activities, delivering & implementing the project as per scheduled milestones

Tools: JAVA, Srtuts1.2, XUL, Swing, DB2, J2EE (JSP and Servlets), Java Scripting and Client supplied Tools, Archiva repository, Artifactory repository.

Confidential

Software Developer

Responsibilities:

• Coordinated with clients/BD teams to understand the change requests and enhancements requirements for web pages and mobile pages.
• Developed many Web Sites/Pages using Java/web technologies.
• Fulfilled all the new requirements of clients after go live for better customer satisfaction as giving support.
• Interacting with the client for system study, requirements gathering, estimation, analysis and scoping.
• Providing estimation and level of efforts for Development, Unit testing and Integration testing.
• Daily monitoring for various web applications and Fix/Modify as per clients requirements.
• Support and maintenance for current running Java Applications, web sites/pages.