SUMMARY

• Over 24 years of Techno - Functional IT Consultant experience developing Banking & Financial Services, Health Care, Retail, Child Welfare, Telecom applications using Informatica Master Data Management, Informatica Power Center, Informatica Power Exchange, SIF API Framework, TIBCO MDM, ESB, SOA and Java technologies.
• Extensive technical expertise on MDM, CRM and Data-warehousing related applications.
• Experience in databases - Oracle 11g, DB2 UDB, MS SQL Server 7.0, MySQL, Sybase.
• Experience in all SDLC stages - Requirement, Design, Implementation, Integration Testing, Deployment and Post Production Support.
• Knowledge of HL7 Standards and TCL programming.
• Self-starter, self-managing with strong initiative and team player qualities.
• Willingness and capable to adapt and learn new technologies.
• Experience leading, mentoring and managing onsite and offshore teams through the design, build and implementation phases of system deployments.
• Strong critical thinking and analysis skills and exceptionally strong documentation skills.
• Responsible, conscientious, organized, self-motivated and able to work with limited supervision.
• Team player - friendly, communicative, open, honest, thoughtful, committed and work cooperatively with others.

TECHNICAL SKILLS

Specialties: Informatica MDM 10.3, Informatica Power Center, Informatica Data Quality, TIBCO MDM (CIM) 8.3, TIBCO BusinessWorks

SOA and Integration: SIF API Framework, SOA, ESB, JMS, Web Services (SOAP/REST), IBM MQ, RabbitMQ, Apache MQ

Languages: Java 1.7, C/C++/C#, XML, UML, SQL, CORBA IDL, ASP, JavaScript, JQuery, VBScript.

Distributed Computing: J2EE, Struts 2, Hibernate 3, Spring 2.0, EJB, WebLogic 9.2, WebSphere 6.1 CORBA (VisiBroker), JDBC.

RDBMS: Oracle 11g, MS SQL Server 2012, DB2, MySQL, Sybase.

Operating Systems: UNIX, Linux 2.4, Windows NT/2K, Solaris and DOS.

SCM Tools: Maven, Jenkins, Tortoise SVN, Mercurial, Git, TFS, Clear Case, CVS, Visual SourceSafe

Internet Tools: Netscape Composer, Visual Interdev, Microsoft FrontPage 2000.

IDEs: Informatica MDM Workbench, Informatica Power Center 9.6.1, Informatica Data Quality 9.6.1, TIBCO MDM Studio, TIBCO Designer, Eclipse 4.6.2, WebLogic Workshop 9.2, IntelliJ IDEA, Oracle JDeveloper 11g, Websphere Studio Application Developer.

Design Tools: Rational Rose, BizAgi, Visio.

PROFESSIONAL EXPERIENCE

Confidential

MDM Technology Lead

Responsibilities:

• Design, configure, develop, test and implement Master Data Management solution (Customer (Party) Domain) using MDM 10.3, Oracle 11g, JMS, MQ, JBoss Application Server in Agile methodology
• Built the data model using ER Studio and in Informatica MDM Hub. Configured relationships, lookups, mappings in MDM Hub.
• Created and configured custom cleanse rules, match and merge rules, trust. queries, packages and batch job groups
• Worked with ETL and IDQ developers to cleanse and standardize data before moving it into the MDM Hub and to export data from MDM Hub to the downstream systems in batch mode. Used Address Doctor for standardizing address data.
• Configured ActiveVOS workflows to enable tasks to MDM data stewards to review/accept new records and merge potentially duplicate records
• Developed Business Integration services (BES) using e360, Provisioning Tool, Business Entity Services (BES), data views, Subject Area Groups and Subject Areas.
• Defined rules for standard REST API/SIF/Message Queue based integration for Search-before-create, bi-directional sync. Worked with java developers to build integration services from downstream systems to MDM and vice-versa.
• Developed scripts for scheduling the MDM ongoing load jobs, match and merge jobs. Worked with ETL developers to generate various reports such as KDE report, Audit report, Data Anamoly report, Address Standardization report.
• Defined and implemented role based access security for the MDM Hub and UI.
• Mentored and lead onsite and offshore teams.

Environment: Informatica Master Data Management 10.3, Informatica MDM Hub Console, Informatica IDD, Provisioning tool, JMS, MQ, ActiveVOS, IDQ, Informatica Power Center, Informatica Analyst, Java 1.8, WSDL, SOAP UI, Rest APIs, Eclipse IDE, JBoss, Oracle 11g, SharePoint, ER Studio, HP Quality Center, Log4J.

Confidential, Orville, OH

Informatica MDM Consultant

Responsibilities:

• Design, configure, develop, test and implement Master Data Management solution (EDI Trade Partner and Item Domains) using Informatica MDM 10.1 HF 2, Java, Oracle 11g, Oracle WebLogic Application Server, SOA.
• Architected and developed the MDM solution to integrate a variety of downstream systems using SIF API framework and Service Oriented Architecture (SOA).
• Worked closely with business and data steward team to get a good understanding of the data and to capture business requirements.
• Built the data model, configured mappings, cleanse rules, match and merge rules, trust configuration, queries and packages, batch groups in the MDM Hub.
• Developed and implemented Security model for the MDM solution
• Worked closely with the ETL team to develop the integration processes using Informatica Power Center, Informatica Power Exchange and SIF APIs for real-time integration of the MDM application with downstream systems
• Developed IDD User Exits to implement custom business rules. Configured workflows using ActiveVOS.
• Involved in the complete Software development life cycle (SDLC) of the project.
• Created BRD, TDD, and User training documents.

Environment: Informatica Master Data Management 10.1 HF 2, Informatica MDM Hub, Informatica IDD, SIF API Framework, ActiveVOS, Eclipse IDE, Java 1.8, JDK 1.8, SOAPUI 5.3.0, JMS, ESB, Oracle 11g, PL/SQL, Oracle WebLogic Application Server

Confidential, NY

Informatica MDM Developer

Responsibilities:

• Design, configure, develop, test and implement Master Data Management solution (Customer (Member) and Provider Domains) using Informatica MDM 10.1, Java, Oracle 11g, WebLogic Application Server, SOA in Agile methodology.
• Designed and developed the MDM solution to integrate various source systems using ESB in a Service Oriented Architecture (SOA).
• Developed IDD User Exits for custom business rules. Configured task notification workflows using ActiveVOS.
• Developed MDM Hub Match and Merge rules, trust configuration, Batch groups, Queries and packages in MDM Hub Console.
• Coordinated effectively between onsite and offshore teams for optimum utilization of the resources and time.
• Involved in the full SDLC of the project.
• Created configuration and design documents and analyzed functional specifications and user requirement documents.

Environment: Informatica Master Data Management 10.1, Informatica MDM Hub, Informatica IDD, ActiveVOS, SIF APIs, Eclipse IDE, Oracle 11g, PL/SQL, WebLogic Application Server, Log4J, Linux 2.4, JDK 1.8, SOAPUI 5.3.0, ESB, Mercurial, Pega Management Framework (PMF).

Confidential

Informatica MDM Developer / Solution Architect

Responsibilities:

• Design, configure, develop, test and implement Master Data Management solution (Customer (Party) Domain) using MDM 9.6.1, Java, Oracle 11g, MQ, JMS, IBM WebSphere Application Server.
• Build the data model according to the business needs by interacting with the data architect
• Configured Informatica Data Director (IDD) by creating subject areas, subject area groups.
• Performed data cleansing and transformations/standardization using Informatica Data Quality and Informatica Power Center
• Developed rules for cleansing/validating/standardization of data using regular expressions, pattern matching and reference tables. Defined System Trust and Validation rules for the base object columns
• Developed User Exits for implementing custom business rules.
• Developed MDM Hub Match and Merge rules, Batch jobs and Batch groups.
• Created Queries and packages in MDM Hub Console.
• Developed and reviewed configuration documentation and design documentation as well as analyzed functional specifications and user requirement documents.
• Mentored and lead onsite and offshore teams.

Environment: Informatica Master Data Management 9.6.1/9.1, Informatica MDM Hub, Informatica IDD, Informatica MDM Workbench, Informatica Data Quality, Informatica Power Center, Eclipse IDE, WebSphere Application Server v7.0, Oracle 11g, PL SQL, Oracle JDeveloper, SVN, Log4J, Tomcat, Linux 2.4, HP Quality Center.

Confidential, New York, NY

Informatica MDM Consultant / Solution Architect

Responsibilities:

• Design, develop, test and implement the Master Data Management solution using Informatica Master Data Management, Java, DB2, IBM WebSphere App. Server 7.0.
• Perform data cleansing and transformations using ETL (Informatica Power Center and Informatica Data Quality
• Design and configure rules for cleansing/validating/standardization of data.
• Provided technical decision support for the system and business analysts.
• Coordinated between onsite and offshore teams effectively for best utilization of the resources and time.

Environment: Informatica Master Data Management, Informatica Data Quality, Informatica Power Center, SOAP Web Services, WebSphere Application Server v7.0, DB2, SQL, Linux 2.4, Tortoise SVN, HP Quality Center.

Confidential

TIBCO MDM Developer (Lead) / Solution Architect

Responsibilities:

• Design, develop, test and implement the MDM solution (Item domain) using TIBCO CIM, TIBCO BW, Java, DB2. Responsible for implementing, maintaining master data hubs and applications/processes in support of Kroger’s Master Data Management effort.
• Designed and developed workflows using Business Studio for data governance and maintaining the data quality in the MDM system using Tibco BW, WebServices, SOAP and integrated with the CIM application.
• Perform data cleansing and transformations using ETL (Informatica Power Center and Informatica Data Quality
• Design and configure rules for cleansing/validating/standardization of data.
• Wrote Cron jobs and used with TIBCO FileWatcher utility for auto scheduling of various jobs to import and/or export, synchronization.
• Leading, mentoring and managing onsite and offshore teams.

Environment: TIBCO CIM 8.2/8.1, Informatica Data Quality, Informatica Power Center, TIBCO BW, EMS, JMS, TIBCO Hawk, TIBCO Administrator, XML/XSLT, SOAP Web Services, WebSphere Application Server v6.0, DB2, SQL, Eclipse IDE, Linux 2.4, Tortoise SVN, HP Quality Center.

Confidential, Plano, TX

Sr. MDM Developer

Responsibilities:

• Design, development, testing and implementation of the Customer and Store domains of MDM using TIBCO CIM, TIBCO BW, Java, Oracle.
• Responsible for designing, developing, implementing, maintaining master data hubs and applications/processes in support of Rent-A-Center’s Master Data Management effort.
• Developed the Email system for sending email notifications based on certain triggers in the application like entering the Store Number, setting the Actual Opening Date using Tibco BW, WebServices.
• Performed data cleansing and transformations using ETL (Informatica Power Center and Informatica Data Quality
• Used JDBC, Web Services for developing the necessary interfaces to extract data from external systems into the stage tables for import into the CIM application.
• Wrote Cron jobs for scheduling nightly data import into the MDM system and data export using TIBCO FileWatcher utility.
• Developed CIM workflows and rulebases to use with the MDM system.
• Leading, mentoring and managing onsite and offshore teams.

Environment: TIBCO CIM 8.1, TIBCO BW, Informatica Data Quality, Informatica Power Center, EMS, TIBCO Hawk, TIBCO Administrator, XML/XSLT, SOAP Web Services, WebSphere Application Server v6.0, Oracle 11g, SQL, Eclipse IDE, Linux 2.4, Tortoise SVN, HP Quality Center.