Professional Summary

• 11 years of total IT experience and 8 years of strong Master Data Management MDM and Data Governance DG experience in architecting/designing/developing MDM applications using Master Data Management MDM Server also Known as Websphere Customer Center WCC, Informatica MDM, Collaboration Server/MDM Server for PIM AKA Websphere Product Center WPC, Java/J2EE, ESB, IBM MQ series, IBM WMB, Spring, Struts, Struts Portlets, ANT, JavaScript, AJAX, JSF, HTML, XML, XSLT, JSTL, Hibernate, Oracle, DB2, SOA, Mainframes, Web Services, Savvion, UML.
• 8 years of strong MDM working experience with IBM MDM Server/Websphere Customer Center WCC v5.5, 6.0, 6.5, 7.0, 8.0, 9.0, 10.0 technologies for different industry leading clients: Confidential, Confidential, SAFEWAY, WellPoint, Physicians Mutual Insurance Company PMIC and AIG companies. Worked on all versions of WCC/MDM Server starting from v5.5 to v10.0 since .
• Worked on all the domains of IBM MDM Server Party/Account/Location/Product .
• Worked on IBM MDM Collaboration Server IBM MDMServer for PIM v11.0, v10.0, v9.0, v6.0 technology for industry leading clients 'MRC Global', 'Lowes Inc', 'Polycom Inc'.
• Worked on Informatica MDM v9.0.1, Siperian XU Siperian MDM technology for industry leading clients 'Astrazeneca' and 'Polycom Inc'.
• 7 years of strong Data Governance experience on all the components of data governance.
• Strong MDM Architect/Lead/Developer experience. Very closely worked with various C - level teams CIO, CTO, CDO, CGO, etc as part of various project initiations, providing suggestions, architectural reviews, SCCB meetings.
• Well versed in SDLC Software Development Life Cycle, object oriented programming, Analysis and Design. Worked with industry verticals like Insurance, Pharmaceuticals, Retail, Banking, Automobile, and Telecom.
• Experienced in RUP, OOAD using UML, developing Use Case Diagrams, Class Diagrams, Sequence Diagrams, Micro Designing using Rational Software Architect RSA tool.
• Solid experience with IBM WebSphere Application Server WAS v5.0 v6.0, v6.1, v7.0, Weblogic Application Server v10.3, IBM WebSphere Portal Server WPS v5.1 Apache Tomcat Web Server v4.
• Worked on IDEs Rational Software Architect RSA v8.0, Rational Application Developer RAD v7.5, 7.0, 6.5, 6.0, Websphere Studio Application Developer WSAD 5.0, Eclipse.
• Worked on Informatica Powercenter 8.1.1/9.0.1, Informatica Data Quality IDQ 9.0.1, Informatica Address Doctor.
• Worked on tools IBM Rational Portfolio Manager RPM v6.1, IBM Rational ClearQuest v 2003.06.13, IBM Rational Team Concert RTC, Test Director/Quality center, Unicenter Service Desk USD, CA-7, Autosys, Control-M, Exporter, Notification Manager, XML Test Tool and Endevor, Platinum, etc
• Extensive experience in working with databases like Oracle, DB2 and MySQL with thorough knowledge and experience in PL/SQL, SQL statements, Stored Procedures, Triggers, Functions, Packages, etc
• Experience in object oriented programming with RDBMS. Good experience with data modeling tools such as Datastudio Developer Erwin data modeler.
• Proficient in Relational DBMS. Well versed in schema design and logical and physical design of database. Ability to adapt to variegated environments.
• Worked on Clear Case, PVCS, Current Version System CVS, Subversion and Harvest version control tools.

IT SKILL SUMMARY:

• Core skills: IBM MDM Server/WebSphere Customer Center WCC v5.5, v6.0, v6.5, v7.0, v8.0, v9.0, v10.0, IBM MDM Collaboration Server/MDM Server for PIM/Websphere Product Center WPC v6.0, v9.0, v10.0, v11.0, Informatica MDM v9.0, Siperian XU, Java/J2EE, UML, Oracle, DB2, RSA, RAD, WSAD, WebSphere Application Server WAS, Weblogic Application Server.
• Languages Tools: IBM MDM Server/Websphere Customer Center WCC, Informatica MDM, IBM MDM Collaboration Server/Websphere Product Center WPC, Java, J2EE, UML, WebServices, Mainframes, PL/SQL, SQL, Log4j, Rational Portfolio Manager RPM v6.1, ClearQuest v 2003.06.13, TestDirector, UniCenter Service Desk USD, CA-7, Autosys, Exporter, Notification Manager, XML Test Tool, Endevor, Platinum, DataStudio Developer, Infoman and Erwin Data Modeler
• Databases: DB2 v9.7, v9.5, v8.1, Oracle 10g, 9i/8i, MySQL.
• Operating Systems: Windows 98/2000/XP/NT/VISTA/7, UNIX, Sun Solaris, AIX, zLinux
• IDE: Rational Software Architect RSA v8.0, v7.0, Rational Application Developer RAD v7.5, 7.0, 6.5, 6.0, Websphere Studio Application Developer WSAD 5.0, Eclipse.
• Application Servers: IBM WebSphere Application Server v7.0, v6.1, v6.0, v5.0, Oracle Weblogic v10.3
• Portal Servers: IBM WebSphere Portal Server v5.1.
• Web Servers: Apache Tomcat 4.
• Code Formatting S/Ws: Jalopy, JTest.
• Unit Testing S/Ws: Junit.
• Version Control Tools: PVCS, ClearCase, Harvest, Current Version System CVS, Subversion1.2, Power.
• Processes: IBM's QMS Quality Management System .
• Scheduling Agents: Autosys, CA-7, Control-M, Cybermation.

PROJECT PROFILE:

Confidential

Role: Senior MDM Solution Architect

Environment: IBM MDM Server v11.0, DB2 v10.1, Informatica, Websphere Application Server, Sharepoint.

Confidential

Role: Senior Architect

Environment: IBM MDM Collaboration Server v11.0, DB2 v10.1, Information Server Data stage Quality Stage, Websphere Application Server v8.5, Sharepoint.

Project Description:

Confidential Red Man Corporation Confidential has undertaken an initiative to deploy a Master Data Management and Cleansing Confidential solution for the Item domain. MRC's current Item Master data is incomplete and inconsistent. This is a result of the their current ERP system called SIMS, which currently allow users to enter data into free form fields without controls such as drop down list constraints, or data definitions. No specific rules/processes are enforced by technology and certain practices such as data purging not governed at the appropriate level. The Item Master data solution enables the following capabilities to MRC

• Drives Ecommerce project
• Robust and efficient Item/Part search capabilities
• Preventing Part duplicates
• Automated Item information governance
• Minimize pain points in SIMS

Responsibilities:

• Being the Enterprise Solution Architect, responsible for the complete MDM solution implementation.
• Worked with various C-Level persons such as CIO, CTO, CDO, CGO as part of understanding MDM requirements, suggesting the MDM product to be purchased, Data Governance initiations, Data analysis of various source systems etc
• Analyze MDM business requirements and lay out the Enterprise Architecture.
• Design Develop the Data Model Categories, Hierarchies, Specs, Lookup table's creation, etc
• Educated the clients on MDM concepts, PIM concepts and data governance concepts. Initiated and started the Data Governance council.
• Design develop the workflows. Guide the Clients Team members on implementing the Best Practices.
• Responsible for Data profiling and designing and developing Data Governance policies.
• Design develop the Initial Load processes and resolve the load errors
• Responsible for resolving the development/code migration issues. Responsible for raising the PMRs. Applying Fix packs.
• Responsible for maintaining MDM offshore team work allocation/code review/resolve the doubts raised .
• Responsible for the Technical Specs documentation.
• Responsible for the performance tuning of the work product.
• Responsible for the Code Migration design code migrations.
• Handled load issues such as slow load rate/Environment failures, etc
• Identified many bugs in the product and raised several PMRs with IBM and worked with IBM to resolve the PMRs.
• Applied several product fix packs.

Confidential

Role: Architect/Tech Lead/SME

Environment: Informatica MDM v9.0.1 IBM MDM Collaboration Server v9.0, Informatica Power Center 8.1.1/9.0.1, Informatica Data Quality 9.0.1, Informatica Address Doctor, Weblogic Application Server, Oracle 11g.

Project Description:

Confidential is used to maintain the 360 degrees view of the customers. It maintains the unique business name and location combination. Life-cycle of customer creation process determines who the owner of the customer is in the particular step of the customer creation process. Customer has many roles at Polycom, such as sold-to, bill-to, service agent, re-seller etc There are 2 types of customer, End-User and Partner origination of each is different.

Responsibilities:

• Analyzing MDM business requirement
• Design and Develop Informatica MDM data model, tables creation, mappings, trust calculations, cleanse functions, packages, delta detection, match/merge rules, etc to form the Golden record providing the 360 degrees view of the customer.
• Performance tuning and peer code review of the MDM code.
• Coordinating code migrations with Informatica Administrators in deploying MDM objects from Development to QA and Production Environment.
• Worked with various C-Level Teams such as CIO, CTO, CDO, CGO as part of Data Governance initiations, Data capture from various source systems etc
• Working with Informatica Corporation support team to resolve critical issues.
• Responsible for preparing the technical documentation to support on-going production activities and any future enhancements
• Responsible for documenting issues/defects and explaining the root cause for the issues/defects, and explaining to the Change Control Board CCB about the root cause and getting approval fix.
• Responsible for the performance tuning of the work product.
• Responsible for the code modifications in the Informatica workflows.
• Responsible for setting up the Data Governance including Data Standards, Data Cleansing rules, etc in the Address Doctor.
• Responsible for the Data analysis of different source systems e.g.: DNB, ELOQUA, IDD, POS, PSFT, PSO, SBL, SFDC, SSO, etc .
• Worked closely with DNB on data related issues incorrect DUNS NUM, etc

Confidential

Role: Architect/Tech Lead/SME

Environment: Master Data Management MDM Server v10.0 Features used: Additions, Extensions, Searches, Composites, Configuring Smart Inquiries, Suspect Duplicate Processing SDP - Evergreen Real-Time, Deterministic Matching, Probabilistic Matching PME, Behavioral extensions, Aliasing transactions, Batch Processing, Configuring and using error Handling and Logging, Web services, Java/J2EE JDBC, EJB, ZLinux, WebSphere Application Server WAS, Pitney Bowes PB, XML, Websphere ESB, Datastage, DB2, Rational Software Architect RSA, PVCS, Erwin Data modeler, DSUI, BAUI.

Project Description:

Confidential project will enable Chartis Insurance Company to recover from this competitive disadvantage vis- -vis other competitors and take a leading position with a concomitant beneficial effect on loss ratio and overall profitability.GES MDM program will enable Chartis to maintain Location Master attributes in a centralized repository. It will also make available the location data in a way that can be consumed by other users/applications by providing re-usable business services on SOA.

Responsibilities:

• Primarily architected and designed the custom domain named Location Master for MDM project.
• Designed and developed the data model for custom MDM domain using ERWIN data modeler.
• Guided the client and the team implementing MDM solution highly efficient using the best practices. Participated in requirements gathering and analysis and thoroughly interacted with Client in realizing requirements.
• Initiated and leaded the implementation of Data Governance.
• Worked on all the components of Data Governance such as Data Definitions, rules, data stewardship, Goals, Governance Metrics, etc
• Worked with various C-Level Teams such as CIO, CTO, CDO, CGO as part of architectural reviews and Data Governance initiations, cross Line of Business LOB data sharing initiations, etc
• Responsible for the data profiling and gathered the business elements and data for the Code tables discussing with business and various vendors and teams.
• Designed the Data Stewardship UI architecture.
• Responsible for the installation of the product on various environments.
• Successfully implemented the Suspect Duplicate Processing using the OOB Probabilistic Matching Engine PME .
• Responsible for writing the external JRules.
• Designed/developed Additions, Extensions, Searches, Composites and Webservices.
• Responsible for the installation of MDM Server on various environments ex: DEV, QA, Model, etc .
• Responsible for the integration of MDM application with various downstream applications.
• Initiated/proposed the client with the various features to be implemented in project in the enterprise level ex: The Data Governance process and Location Master User Interface UI which could be implemented for better quality of data .
• Responsible for the release management activities raising release requests, helping the middleware team with the build process to be implemented, etc
• Responsible preparing abstract designs and presenting them in the Architectural Review Board ARB for MDM server modules and presenting the demos to the client on the services developed.
• As a technical lead responsible for the preparation and review of HLD, LLD, code.
• Attending customer calls regularly and resolving the issues on priority.
• Coordinated with the offshore team for the deliverables and performed code reviews.
• Responsible for clarifying/assisting the technical doubts of the team members related to MDM Server and allocating work, reviewing the tasks, etc

Confidential

Role: Architect/Tech Lead/SME

Vendor: MODIS

Environment: Master Data Management MDM Server v9.0.2, WebSphere Customer Center WCC v7.0.1 Features used: Additions, Extensions, Searches, Composites, Configuring Smart Inquiries, Suspect duplicate processing Evergreen Real-Time, Behavioral extensions, Aliasing transactions, Batch Processing, Configuring and using error Handling and Logging, Customizing groups, Setting Rules of Visibility, Web services, Java, J2EE JDBC, EJB, AIX, WebSphere Application Server WAS, Service Oriented Architecture SOA, XML, Websphere MQ, Datastage, Qualitystage, Oracle, Rational Application Developer RAD, Design Patterns, Clear Case, eRoom, Quality Center, Cybermation and Erwin Data/Process modeler, DSUI, JUnit.

Project Description:

Confidential is to create and implement a single repository for Customer Information which will enable a better understanding of customers providing 360 degrees view. CIM will provide the new Confidential database for enterprise-wide use as a central database to eventually replace COGEN-which is a mainframe application and this foundation will enable a future full view about the customer.

Responsibilities:

• Primarily involved in upgrading the product from the current version of IBM Websphere Customer Center v7.0.1 to IBM Infosphere Master Data Management MDM server v9.0.2.
• Participated in requirements gathering and analysis and thoroughly interacted with Client in realizing requirements.
• Installed configured different environments i.e. DEV, QA, SIT, etc with the Infosphere Master Data Management MDM Server v9.0.2 s/w.
• Migrated the Data from the existing environments WCC v7.0.1 to the new environments MDM Server v9.0.2 .
• Designed/Developed Additions, Extensions, Searches, Composites, Suspect Duplicate Processing SDP Both Evergreen Real-Time, Webservices. Discussed with business on the existing SDP rules to support both the online and evergreen process.
• Implemented the Probabilistic Matching in Quality Stage.
• Initiated the Data Governance processes. Assisted the DataStewards team for the data validation. Customized the Data Stewareship User Interface DSUI for the custom searches developed.
• Responsible for the identification of Data Definitions and gathering the data for look-up/reference tables. Guided the team to in corporate Data Standards.
• Worked with various C-Level Teams such as CIO, CTO, CDO, CGO as part of architectural reviews and Data Governance initiations, etc
• Responsible for writing the external JRules.
• Developed Junits using MDM Server webservices for UNIT testing.
• Responsible for Micro Macro designing using UML for WCC to MDM upgrade project. Preparing abstract designs and presenting them in the Architectural Review Board ARB for MDM server modules.
• Integrated the environments with the other interfacing applications ETL, Payment Management, etc
• As part of the upgrade, designed new core modules such as Customer View user interface application to the existing project to create a complete MDM to provide the 360 degrees view of the customer.
• Responsible for the Data Integration like providing different levels of data specifications such as to the DB team, ETL Team, WCC Team, Testing Team and integrating all of them.
• Responsible for setup of the local environments for the team members using Rational Application Developer RAD v7.5, Master Data Management Server MDM Server, Development environment setup tool DEST for the Team Members.
• Coordinated and managed an effective integration of applications. Managed Timely and Successful delivery of hot fixes and Patch releases.
• Attending customer calls regularly and resolving the issues on priority.
• Guided the team on the MDM Server upgrade. Educated the team on WCC and MDM Server and the differences between them.
• Coordinated with the team for the deliverables and performed code reviews.
• Responsible for clarifying/assisting the technical doubts of the team members and allocating work, reviewing the tasks.

Confidential

Role: Team Lead

Environment: Informatica Siperian XU, Java, J2EE, AIX, Service Oriented Architecture SOA, WebServices, Informatica, Oracle, SQL Developer, Eclipse, Share Point, Quality Center, Erwin Data/Process modeler, Autosys, Business Objects, Oracle Weblogic Application Server v10.3, Trillium, SOAP UI.

Project Description:

The Confidential Aggregate Spend Implementation Program will provide both business process and technology components to allow Confidential to comply with external requirements imposed by state and federal government agencies. The new or improved capabilities will enable the capture and disclosure of numerous types of spends associated with activities where Confidential engages with Healthcare Organizations HCOs and Healthcare Providers HCPs .

Responsibilities:

• Primarily involved in Initiate/Plan, Analysis and Application Development using emerging s/w Master Data Management MDM Siperian and Service Oriented Architecture SOA .
• Produced the project estimates, timelines and resource planning to the client.
• Proposed and produced the architectural design to be implemented in the Customer Master during the analysis phase of the project to resolve the existing issues in Touchstone.
• Responsible for the Data analysis of different source systems e.g.: Medpro, SAP, Impact, SFA, SAPVEN, Webservices, etc .
• Responsible for the Data Governance principles, rules, standards.
• Siperian development includes Creation of Source, Landing Tables, Staging Tables, Mappings, Trust/Delta Detection, Cleanse function, Base Object, Match Rules, Packages, etc
• Responsible for analyzing the bugs, code debugging and Bug fixing as part of development to meet the Service Level Agreements SLA .
• Responsible for setup of Eclipse Siperian, setting up the project environment in UNIX for the team members.
• Responsible for preparing technical specifications for the project and reviewing the team member's docs.
• Prepared project specific technical documents Design Documents, Workbook, etc .
• Coordinated with the Onshore/Offshore team for the deliverables and performed code reviews. Responsible for clarifying/assisting the technical doubts of the team members and allocating work, reviewing the tasks.

Confidential

Role: Senior Application Programmer

Environment: Master Data Management MDM - WebSphere Customer Center WCC v7.0 Additions, Extensions, Searches, Composites, Configuring Smart Inquiries, Duplicate suspect processing, Aliasing transactions, Batch Processing, Configuring and using error Handling and Logging, Customizing groups, Setting Rules of Visibility, Web services , Java, J2EE JDBC, EJB, Spring, AIX, WebSphere Application Server WAS V6.1, Service Oriented Architecture SOA, Quality Stage, Data Stage, XML, IBM MQ Series, INFORMATICA, DB2, Rational Application Developer RAD, Design Patterns, Clear Case, Share Point, Quality Center.

Project Description:

Confidential is to build the enterprise-wide backend system This Consumer Hub would contain the enterprise-wide customer data, and will use Duplicate Suspect Processing techniques to obtain a golden copy for the data. This hub will also replace the current old source systems to be the source of truth. The Objective for the Wave 2 of the system development was threefold

• To integrate Initiate Matching engine and a Enterprise Data Warehouse for Shared Sourcing purposes
• Expose business services for Existing Data loaded in the hub.
• Continue Data Loading with Business Logic
• Providing services which are built using the spring framework and Web Services to the other applications.

Responsibilities:

• Primarily involved in Application Development using emerging s/w Master Data Management MDM - WebSphere Customer Center WCC and Service Oriented Architecture SOA for WellPoint, Inc. Consumer Hub.
• Designed/Developed Additions, Extensions, Searches, Composites/Business Proxies for the Individual Transactions. Worked on the WCC Duplicate Suspect processing.
• Responsible for loading the data in all the Test Environments DEV, SIT, UAT, REGRESSION, BFX, etc
• Responsible for analyzing the bugs, code debugging and Bug fixing as part of development to meet the Service Level Agreements SLA .
• Responsible for setup of Rational Application Developer RAD WebSphere Customer Center WCC, creating users and profiles in Rational Application Developer RAD and setting up the project environment in UNIX for the Team Members.
• Integrated with Initiate Probabilistic Matching PME .
• Responsible for the analysis of rejected records as part of batch load and on-line services.
• As part of Data Governance, Responsible for the data profiling of source systems to better understand the data. Extensively worked on Data Stewardship user interface DSUI . Implemented the Data Cleansing and Data Standards.
• Coordinated and managed an effective integration of applications. Managed Timely and Successful delivery of hot fixes and Patch releases.
• Attending customer calls regularly and resolving the issues on priority.
• Participated in discussions on thorough test case coverage in compliance with functionality specifications.
• Coordinated with the Onshore/Offshore team for the deliverables and performed code reviews. Effectively participated in design reviews.

Confidential

Role: Team Lead

Environment: Master Data Management MDM Server v8.0 Additions, Extensions, Searches, Configuring Smart Inquiries, Duplicate suspect processing, Composite transactions, Aliasing transactions, Batch Processing, Configuring and using error Handling and Logging, Customizing groups, Setting Rules of Visibility, Web services, Java, J2EE JDBC, EJB, JMS, AIX, WebSphere Application Server WAS