We provide IT Staff Augmentation Services!

Mdm Architect Resume

Waukegan, IL

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

SKILL:

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

EXPERIENCE:

MDM Architect

Confidential, Waukegan, IL

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, Summit, NJ

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.

MDM Lead

Confidential, New York, NY

Responsibilities:

  • Worked in Metadata configuration using MDM HUB console, developed landing, staging, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries, cleanse functions, batch groups and packages.
  • Worked closely with the Business Team to gather requirements/testing for the Match rules identifying columns and setting Match Rules Sets as per project needs and configuration.
  • Developed User Exits for implementing custom business rules in MDM HUB.
  • Defined System Trust and Validation rules for the base object columns.
  • Worked on IDQ parsing, IDQ Standardization, matching, IDQ web services
  • Imported the mappings developed in data quality (IDQ) to Informatica designer
  • Identified and eliminated duplicates in datasets thorough IDQ components
  • Worked on MDM user exit such as Pre-load, Post-load, Pre-merge and Post-merge to validate using business requirement.
  • Identifying, preparing, and conducting unit test cases and fixing defects based on results.
  • Worked in debugging, error handling and performance tuning of sources, targets, mappings and sessions with the help of error logs generated by Informatica HUB and Cleanse server.
  • Perform MDM data analysis and investigate master data related issues.
  • Analyze data primarily for name & address cleansing and matching of customer data using Trillium for different business groups.
  • Automated inbound catalog data content workflow for processing to QA and production environments.
  • Scheduled the load processes in AutoSys and setup mail communication using Unix / Infa server manager.
  • Consolidate the test results and provide periodic status update to business and highlight / recommend any changes in design based on challenges faced.

Environment: Informatica MDM 10.1, Informatica IDQ 10, Oracle, Clear Case Repository, AQT, Soap UI, StarTeam, DB2, Java, Shell Script.

Informatica MDM and Java Developer

Confidential, New York, NY

Responsibilities:

  • Worked in preparing low-level design document (LLD)
  • Involved in setting up Development, QA and Production environment.
  • End to End Informatica MDM implementations, which design, develop, test, deploy, migrate, and maintain applications in Informatica MDM 10.1 environment.
  • Worked on CMX UE (User Exit) module and migrate to Informatica MDM 10.1 using SIF API - Java User Exit
  • Involved in Informatica Hub migration - Data Mappings (Landing and Staging), Defining configuring landing tables, staging tables, base objects lookups, query groups, packages, validation rules, Match and Merge rules and customizing / configuring Informatica data director (IDD) applications and Entity 360.
  • Worked on load jobs for moving data from Staging tables to base object tables. Base object tables more like BO tables, xref tables history tables etc.
  • Created IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, export and import master data from flat file.
  • Worked in debugging, error handling and performance tuning of sources, targets, mappings and sessions with the help of error logs generated by Informatica HUB and Cleanse server.
  • Define and configure Informatica Active VOS workflow processes of MDM data approval using IDD application.
  • Perform functional testing, system testing, and regression testing and defect reporting.
  • Involved in post-production support and maintenance activities.

Environment: Informatica MDM 9.7, Informatica MDM 10.1, Informatica ActiveVOS, Rational Application Developer, Oracle, AQT, Soap UI, StarTeam, Shell Script.

Informatica MDM Developer

Confidential, Atlanta, GA

Responsibilities:

  • Performed business analysis, requirement gathering and design functional, technical specifications.
  • Worked in preparing Low-level Design Document (LLD)
  • Analyzing the raw data and comparing with business standard.
  • Defined the landing tables, staging tables, and configured base objects
  • Created Queries and Packages to view the data in IDD, Data Manager or Merge Manager and Lookup tables configured in IDD applications.
  • Defined foreign-key relationships, lookups, query groups, Packages and queries
  • Defining Trust Score Validation Rules Match rules and Merge settings.
  • Developed the IDD application building Hierarchies as per the business needs.
  • Raised tickets with Informatica global Support team for product version related workarounds and version upgrades.
  • Assist development/application teams in scheduling Informatica jobs through Control-M script.
  • Involved in the development of SQL, PL/SQL packages, stored procedures and data base views.
  • Provide accurate work estimates and work to deliver on time, escalating proactively to project manager when deliver dates are potentially at risk.
  • Performed functional testing, system testing, regression testing, and review and prioritize defects.

Environment: Informatica MDM 9.7.1, DB2, JBoss, Shell Script, SVN Repository, Putty, WinSCP, Soap UI

Informatica MDM Developer

Confidential, Bentonville, AR

Responsibilities:

  • Involved in SCRUM process of Agile methodology in Requirement gathering, Design, Analysis and development through sprint cycles.
  • Handled Sprint estimation and Scrum task.
  • Experience working on Informatica MDM to design, develop, test and review & optimize Informatica MDM (Siperian).
  • Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation
  • Involved in the development of SQL, PL/SQL packages, stored procedures and data base views.
  • Work with Quality assurance teams in developing comprehensive test plans to validate the end to end integration of applications and to smoke test the newly rolled out features in internal and client environments.

Environment: Informatica MDM 9.5, Oracle, WebSphere 6.0, Shell Script, SVN Repository, WinSCP, Putty

Senior J2EE Developer

Confidential, San Ramon, CA

Responsibilities:

  • Requirement analysis, component architecture preparation, design solutions and reviews.
  • Developed the persistence layer (DAO) and the presentation layer (controllers) and used J2EE design patterns like Model View Controller, Data Access Object, and Factory etc.
  • Implemented application using JSF, Spring MVC, and Hibernate.
  • Worked on documentation activity using external API and auto-generated docs with custom CSS as per corporate website standard.
  • Used JUnit Testing Framework for performing Unit Testing.
  • Deploy application in WebSphere application server in Development, QA and Production environment and handled module integration.
  • Used JIRA to assign, track, report and audit the issues in the application
  • Defining and implementing the Configuration Management and defect tracking practices.
  • Mentoring and building technical expertise in the team.

Environment: Eclipse 3.0, Java, JSF, DOJO, jQuery, JavaScript, Spring MVC, Hibernate, Oracle, Toad, Web Sphere 6.0, Mongo DB, Maven, GIT Repository, JIRA, WinSCP.

Senior J2EE Developer

Confidential, San Ramon, CA

Responsibilities:

  • Requirement analysis, component architecture preparation, design solutions and reviews.
  • Create System Requirement and Functional Specifications, which includes use cases, Activity/Class diagrams, and process flow diagrams.
  • Involved in the development of the presentation tier using struts framework, action classes, dispatch action, struts tiles, and validation framework.
  • Involved in the presentation tier design as well as the services layer, and prepared the class diagrams, sequence diagrams for the Billing application enhancements.
  • Performed functional testing, system testing, regression testing and user acceptance testing, defect reporting and prioritize defects.

Environment: Java, Servlet, JSP, Struts 1.2, Java Script, CSS, Shell Script, Oracle, Maven, Eclipse 2.0, Subversion Repository, Putty, Tandem UI

Senior J2EE Developer

Confidential, San Ramon, CA

Responsibilities:

  • Worked on the presentation layer, services layer using JSF, Rich Faces, jQuery, DOJO and handled module integration with Virtual Machine monitoring.
  • Prepared the technical design document for both presentation tier, as well as a middle layer.
  • Followed all the coding standards and implemented the java design patterns.
  • Extensively used hibernate in data access layer to access and update information in the database.
  • Defining and implementing the Configuration Management and defect tracking practices.
  • Interacting with business and get the functional clarifications and attend the status calls to discuss the issues and future implementations.
  • Perform functional testing, system testing, and regression testing and user acceptance testing, defect reporting and prioritize defects.

Environment: Eclipse, Java, JSF, DOJO, jQuery, JavaScript, Spring MVC, Hibernate, Oracle, Toad, Web Sphere 6.0, Mongo DB, Maven, GIT Repository, JIRA, WinSCP.

J2EE Developer

Confidential, San Jose, CA

Responsibilities:

  • Requirement gathering and analysis for the applications enhancements.
  • Interact with clients, go through Pseudo code to understand requirements.
  • Implemented major concepts of the application using Core Java, Servlet, JSP, JDBC, Java Beans, EJB and XML.
  • Developed the Web Based Rich Internet Application (RIA) using Adobe Flex.
  • Extensively used Adobe Flex for UI development.
  • Worked on JSON and XML.
  • Used Log4J to capture the log that includes runtime exceptions.
  • Unit testing with Junit for improving the software quality.
  • Used Maven for project build process.
  • Worked on UNIX shell scripting to execute BIRT report in Tomcat Server.
  • Writing SQL query and stored procedure using Toad UI tool.
  • Used JUnit Testing Framework for performing Unit Testing.

Environment: Java, Servlets, JSP, Adobe flex, ActionScript, MXML, XML, Maven, Eclipse, BIRT Reporting Tool, Adobe Flex 3.0, IBM Tivoli TADDM API, Oracle, Tomcat 5.5 Server, Putty, Rational Clear Case, WinSCP

J2EE Developer

Confidential

Responsibilities:

  • Requirement gathering and analysis for the applications enhancements by interacting with the Confidential business user.
  • Involved in the designing, developing, testing and implementation of J2EE based web-based applications for the project.
  • Involved in coding and development of real estate owner guideline module.
  • Involved in AJAX implementation.
  • Wrote client-side dynamic validation using JavaScript.
  • Worked on bug fixing for customer enquiry and quotation module.
  • Worked on SQL query, stored procedures using SQL Server tool.
  • Developed unit test cases for various modules and common utilities for all the modules.

Environment: Java, Servlet, JSP, CSS, HTML, JavaScript, DAO Pattern, Restful-Web services, JUnit, LOG4J, Eclipse, Rational Application Developer, MS SQL Server, WebSphere 5.0 Portal, Vignette Application Portal (VAP7.2), Microsoft VSS 7.0

J2EE Developer

Confidential

Responsibilities:

  • Involved in requirement study by interacting with Cyclops business user.
  • Involved in the designing, developing, testing and implementation of J2EE based web-based applications for the project.
  • Involved in the development of the user interfaces using HTML, JSP, JavaScript, CSS, and Ajax.
  • Developed web-based UI using Struts 1.2, Ajax, and JavaScript.
  • Worked on SQL Server to develop data base stored procedures as per the client’s requirement.
  • Implemented DAO design pattern in data access layer.
  • Performed functional testing, system testing, and regression testing.

Environment: Java, JSP, CSS, JavaScript, Struts 1.2, Spring JDBC, Ajax, EJB, Net Beans 5.5, IBM Rational Development Tool, TOAD, Microsoft VSS, Dream Weaver, Toad, WebSphere 6.0

J2EE Developer

Confidential

Responsibilities:

  • Interact with onsite coordinator on regular basis to gather application requirements and enhancements.
  • Worked closely with testing and Business Analyst team to ensure application development meets with the user expectations.
  • Implemented UI layer using JSP, CSS and JavaScript.
  • Implemented the Project structure based on Struts MVC framework.
  • Coding standard creation as per application development team guidance and industry standard.
  • Creating the unit test cases in Junit.
  • Worked on SQL queries and stored procedures to fetch and populate data into user interface.
  • Involved in performance and load testing of the application using TCS' eLab facility.
  • Received appreciation award from Customer for delivering project “on time”.

Environment: Java, Servlet, JSP, CSS, JavaScript, DAO Pattern, JUnit, WebLogic Application Server 8.1, Struts Framework, Net Beans 5.0, Oracle, PL/SQL Developer, Win CVS, Win Merge 5.2

Hire Now