SUMMARY

• Tech Lead with 15 years of IT experience in analysis, design, development, integration, maintenance, production support and testing of various Client/Server Systems, Web Applications, Data Integration Systems and Data Warehousing
• Expertise in Business/Client interaction and gathering business/functional requirement analysis thereby interpreting the same in technical language
• Strong functional and technical experience in Data Management tool like Informatica MDM versions 9.7, 10.1, 10.2, 10.3, Informatica IDQ 10, 10.1, Informatica ActiveVOS
• Deploying and hosting an application on Cloud Environment (AWS). Deploying on EC2/ECS instance, AWS Console, S3 Buckets, IAM Roles, Monitoring logs in Cloud Watch.
• Extensive experience in data profiling, developing and delivering data quality solutions and laying out data governance strategies using Informatica AXON.
• Expertise in Java and J2EE technologies such as Servlet, JSP, Struts, EJB, JMS, Spring JDBC, Hibernate and REST based webservices and XML/XQuery/XSLT/JSON
• Proficient in development of enterprise business solutions using Apache Tomcat, BEA WebLogic, JBoss and IBM WebSphere
• Proficient in development of Informatica Master Data Management User Exit, Cleanse API, Validation Rule HUB Configuration and Entity 360
• Extensively worked with design and configuration of landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages
• Proficient in customizing bulk data processing through Informatica MDM and publishing the golden data to downstream application such as SAP - HANA and IBM Planning Analytics
• Experience with SOAP and REST based webservices request to MDM service using SOAP UI tool
• Worked on Informatica upgradation projects across the versions 9.7, 10.1 and 10.2.x
• Expert in implementation of continual service improvement using additional scripting tools such as AutoSys and Shell Script
• Experience in UI development, creating layouts using Business Entity Framework
• Experience in configuring the MDM File Import process and External Calls development using Business Entity Services and configure Elastic Search
• Developed database objects like Stored Procedures, View, Dynamic SQL using SQL and PL/SQL
• Experience in integration of various data sources with Relational Databases like Oracle, DB2, Teradata and MS SQL Server
• Actively involved in production support. Implemented fixes/solutions to the issues/tickets raised by the user community
• Extensively worked with Version Control Systems like CVS, SVN (Subversion), IBM Rational Clear Case and GIT
• Self-motivated and possess excellent critical thinking ability, good interpersonal and communication skills

TECHNICAL SKILLS

Operating Systems: Windows XP, Windows 7, Windows 10 and Linux Red Hat

Data Warehousing Tools: Informatica MDM, Entity 360, Informatica IDQ, ETL, Informatica AXON, Active VOS

Databases: Oracle 10g, 11g, DB2, Sybase, Teradata, My SQL, SQL Server, MS Access

Development Technologies: Core Java, J2EE, JSP, Servlet, JMS, JNDI, Struts, Ant, UML, Spring MVC, Spring JDBC, XML, Java Beans, EJB, Hibernate

Web Presentation: JSP, JSF, Servlet, JavaScript, HTML, CSS, XML, XSLT

Web/Application Servers: Tomcat 6.x, WebLogic 11, 12c R2, JBoss 7.0, WebSphere 6.x/7.x

Development Tools: Eclipse, IBM Rational Developer, Adobe Flex IDE, Soap UI

PROFESSIONAL EXPERIENCE

MDM Architect

Confidential

Responsibilities:

• Functioned as primary point-of-contact and technical lead, responsible for design and architecture of MDM system while adhering to requirements and focus.
• Prepared High and low-level design documents of Aspire MDM data flow architecture.
• Designed and developed MDM ORS and data models in the Oracle 11g hosted in Amazon EC2 instance
• Worked with Informatica MDM 10.3 version on Business Entity Framework - Entity 360
• Strong experience in designing and developing mappings to extract data from different sources including flat files, RDBMS tables
• Configured new source systems, relationships and lookups for Base Objects, Reference BO and Provisioning tool.
• Defined System Trust and Validation rules for the base object columns, Hub Match and Merge rules Batch jobs and Batch groups.
• Created Queries Query Groups and packages in MDM Hub Console and setup Entity 360
• Created Queries and Packages to view the data in IDD, Data Manager or Merge Manager and Lookup tables configured in IDD applications.
• Worked with SIF API to interact with real time applications and Wrote web services client to invoke web services using SIF framework
• Create and manage governance of change requests to MDM components and policies using Informatica AXON
• Develop, promote, and enforce data governance standards and policies to business user
• Worked on JIL scripts for job scheduling, dependency management and notification processes using CA Workload Automation AE and WCC (AutoSys) Tool for monitoring and execution of MDM jobs.
• Raised tickets with Informatica global Support team for product version related workarounds and version upgrades.
• Worked on defect reporting, review and prioritize defects. Worked in performance tuning, monitoring, and scheduling jobs using MDM batch group. Responsible for providing necessary technical support to the team members.
• Implementing new requirements and CR’s (change requests) using ServiceNow after performing impact analysis of various channels and end systems.

Environment: Informatica MDM 10.3, Informatica Power Center 10.2, Informatica ActiveVOS, Oracle, Toad, Eclipse, AutoSys, Soap UI, Putty, WinSCP, ServiceNow, CVS.

MDM Lead

Confidential

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the MDM (Mastering data) on the business.
• Closely worked with other IT team members business partners data stewards’ stakeholders steering committee members and executive sponsors for all MDM and data governance related activities.
• Preparing POCs (Proof of Concepts) to determine whether a requirement can achieve through “Informatica Platform Staging” within MDM to integrate with IDQ (Developer Tool) which enables directly stage/cleanse data using IDQ mappings to MDM’s Stage tables bypassing Landing tables
• Developed business rules for cleansing/validating/standardization of data using Informatica IDQ
• Worked on Data Profiling, Scorecard, Web Service configuration using Informatica IDQ
• Configured new source systems, relationships and lookups for Base Objects and Reference BO
• Worked on creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation. Running all the MDM processes like Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes
• Created Queries and Packages to view the data in IDD, Data Manager or Merge Manager and Lookup tables configured in IDD applications.
• Raised tickets with Informatica global Support team for product version related workarounds and version upgrades.
• Implemented IDQ function as operation mappings and deploy them as web service and Informatica MDM Hub acts as a Web service client application that consumes IDQ’s web services
• Worked on managing ActiveVOS Central and setup Identify Service on ActiveVOS Console
• Worked on data unmerge activity using Execute Batch Unmerge SIF API (Java) to unmerge HCOs records as per business requirement
• Help document the technical details and clarify questions with COE
• Experience on defect tracking and prioritize defects using JIRA application.
• Involved in preproduction activity and production deployment activities through ITSM process.

Environment: Informatica MDM 10.2, Informatica IDQ 10.1, Informatica ActiveVOS, Core Java, SIF API, JIRA, Soap UI, CVS Repository, DB2, Shell Script.