PROFESSIONAL SUMMARY:

• Total of 19 years of IT experience
• 4 Years’ experience in Master Data Management Solution Architect.
• 8 Years’ experience in Informatica Data Quality V9.0
• 5 Years of experience in Data Director, Business Data Director at the capacity of Tech Lead.
• 2 Years of experience in Service Integration Framework
• 8 Years’ experience in BI, Data Warehouse.
• Technical / functional background and experience with MDM tools and ERP applications.
• Experienced in implementing the Data standards and Data Governance Process
• Experience in integrating Active VOS with IDD and MDM hub tool.
• Worked on Active VOS Designer and executed BPEL process.
• A subject matter expert with business processes and was instrumental in establishing the best practices with Vendor, Customer, item master and Employee domains in Master data management.
• Experienced in Waterfall methodology, Agile and Six Sigma.
• Experienced in base data, data, hierarchy data.
• Excellent data analysis skills to analyze data coming from various sources and Data profiling.
• Coordinating with key member of data source teams and data subscriber teams for data flows, inbound and outbound. 6. Integration testing as and when required by the upstream/downstream systems 7. Customer Profiling.
• Worked on developing the Data Quality Business rules, Validation rules.
• Worked on configuration of Hierarchies and configuring the workflow integration.
• Experienced in defining and developing the Workflow process.
• Hands on experience with MDM Hub configuration.
• Experienced in design the Data Modeling.
• Worked on Workflow configuration.
• Well experienced in establishing the validation rules, Match rules and Merge rules and procedures.
• Have experience in Informatica Data Quality and Data Director.
• Experienced in Metadata Repository Management.
• Experienced in Relational Database Management Systems (RDBMS), designed the Data warehousing schemas STAR, Snow Flake, Hybrid.
• Worked on developing MDM Domains for various applications and domains including Banking, Manufacturing and Pharma.
• Worked on Production Support and had been instrumental in stabilizing the Systems and provided L1 Support for onsite offshore projects Model.
• Proven ability to work in both independent and team environment and having ability to meet tight deadlines and work under pressure.
• Instrumental in developing the Services Integration Framework(SIF) using Java EE7 programming.
• Experienced in SOAP, Restful web services.
• Designed and developed the MDM Hub Security and Administration.
• Designed and developed the Match and Merge rules. Trust framework settings.
• Design and develop the Data Model, Data Flow and worked on developing the Informatica MDM Hub Execution Processes.

TECHNICAL SKILLS:

Enterprise Architecture: TOGAF

Data Modeling: ERWIN, Power Designer.

ERP Applications: SAP R/3 4.6 C.

CRM Application: Sales Force(SFDC)

Master Data Management (MDM): Informatica 9.x,10.2 HF1(MDM Hosted environment)

Master Data Management(MDM): TALEND 5.7.1

BPM Workflow: AVos, Bonita

ETL: Informatica Power center.

Data Quality: Informatica Data QualityBI Report Tools Cognos (Impromptu, Report Studio).

BI Modelling Tool: Framework Manager.

OLAPReport Tools: Power play (Enterprise Server).

OLAP Modelling: Power Play Transformer.

Databases: SQL server 2008 R2, Oracle, DB2 UDB

Operating Systems: MS Windows, AIX, Linux.

Quality Control: QC, HP - ALM, Clear Quest.

Versioning S/W: TFS, MS VSS.

PROFESSIONAL EXPERIENCE:

Confidential, Glenn Mills PA

EMDM Solution Architect/Tech Lead

Responsibilities:

• Worked on the Axalta’s EMDM Solution Architecture.
• Defined and designed the Axalta’s over all MDM Solution that suits the Business requirements using the current state infrastructure and Technology.
• Worked on Technical System requirements development.
• Designed and developed the Corporate wise ERD using CASE Tools.
• Instrumental in defining the Master data attributes from the several Source Systems.
• Worked with Business stake holders in requirements gathering, business rules gathering.
• Worked and documented the User stories for all the Domains.
• Designed and developed the Party Data Model, Material Master Data Model.
• Worked on Data Mapping Workbooks and have developed the ICDs.
• Worked on Data Quality analysis, Data Profiling and Data cleanse rules.
• Worked on MDM HUB Validation rules configuration, HDD and Delta detection.
• Designed and developed the Match rules, Match tuning.
• Designed the match rules (Exact and Fuzzy).
• Designed the MDM HUB Trust Frame work settings.
• Designed and developed the MDM HUB Security frame work, roles developments and user configuration.
• Worked at the capacity of MDM HUB Admin including code migration between the Environments, Performance tuning.
• Worked on the Data Quality methods and procedures using IDQ.
• Designed the BPM Workflow using Informatica Active VOS Designer Tool.
• Worked on IDD Configuration, Cleanse functions.
• Co-ordinated and worked with Informatica B2B(DX) in interface development with SAP R/3.
• Defined the IDD Queries and Active VOS integration.

Technologies: Informatica MDM V10.2 HF1TALEND 5.7.1 IDQ v 9.x Active VOS 9.2.4 MS SQL Server 2012 R2MS SharePoint V10. HP ALM V11.

Confidential, Columbus GA

EMDM Solution Architect/Data Modeler

Responsibilities:

• Worked on the Aflac MDM Solution Architecture for Producer/Broker, Accounts and Named Insured Domains as part of transitioning the Policy Centric Platform to Client Centric Platform.
• Worked with key business stakeholders to interpret business needs and issues and translate them into actionable requirements.
• Developed the MDM validation rules, Merge rules.
• Designed and developed the Match and Merge rules. Trust framework settings.
• Experience in defining the product taxonomies and categorizations.
• Worked with Data modeling and Data Mappings. (Landing, staging and Base Objects).
• Worked on the Data Quality methods and procedures using IDQ.
• Designed the BPM Workflow using Informatica Active VOS Designer Tool.
• Designed the match rules (Exact and Fuzzy) for the Accounts and Named Insured domains.
• Defined the IDD Queries and ActiveVOS integration.

Technologies: 1.Informatica MDM V 9.7.12.Power Center 9.03.IDQ 9.0. 4.Oracle - RDBMS V11.x

Confidential, Philadelphia PA

MDM Solution Architect/Tech Lead

Responsibilities:

• Worked on MDM Tool evaluation and RFP Process for Aramark’s Enterprise Data Management Group
• Worked on Vendor demos and Tool capabilities.
• Worked with Procurement Team on Tool evaluation and cost estimation.
• Worked on Data Quality, data profiling using IDQ.
• Worked on Informatica Data Director and Business Data Director.

Technologies: Informatics MDM V8.0, EBX5 Oracle - RDBMSHP Quality Center 9.0, IBM Rational Clear quest

Enterprise DATA SOLUTIONS

Confidential, Pittsburg,PA

Responsibilities:

• Designed the Data Governance Framework and Data Standards.
• Defined the MDM Day to day process.
• Designed the workflows for Customer Onboarding System.
• Worked on Source System analysis.
• Developed the MDM validation rules, Merge rules.
• Designed and developed the Match and Merge rules. Trust framework settings.
• Experience in defining the product taxonomies and categorizations.
• Worked with Data modeling and Data Mappings. (Landing, staging and Base Objects).
• Worked on the Data Quality methods and procedures using IDQ.
• Designed the match rules (Exact and Fuzzy) .

Confidential, Hopewell - NJ

CRM Data Analytics

Responsibilities:

• Worked on Client Contact Conversation Analysis.
• Designed and developed the Client Attrition reports.
• Heavily involved in Direct Marketing Analytics.
• Designed and developed the E-Newsletter Analysis.
• Worked on Campaign Marketing Dash Boards and Campaign Rules Hierarchy.
• Developed the Client Household Segmentation based on IVR and Client Asset Analysis.
• Developed the Client on boarding process and deepening Analysis.
• Worked on Consumer Referral Process and Analytics.
• Developed the Client Exit Survey Data Analytics.
• Developed the Client Product Enrollment Analysis.
• Instrumental in Design and developing the FAC Data warehouse DataMart.
• Worked on multiple projects and was able to perform multi-tasking.
• Analyzed the business requirements and functional specifications.
• Extracted data from Oracle database and applied business logic to load them into Salesforce application.
• Designed and developed Client attrition analysis.
• Worked on E-Newsletter Analysis.
• Designed and developed the ML EDGE Client EXIT Survey Analysis.
• Designed and developed Client Attrition Metrics and Analysis.
• Worked on UMA Enrollment and MESP Analysis.
• Designed and Developed MFA.

Technologies: MS SQL Server 2005,2008 R2 Siebel CRM V 8.1.1Cognos FM V 10.1 Cognos Report Studio V 10.1

Confidential, Philadelphia -PA

Data Warehouse Designer

Responsibilities:

• Instrumental in upgrading the Data warehouse BI reports that were developed using Impromptu 7.0 to a web based Cognos Report Studio reports.
• Worked on the migration of Transformer Models to a web based Transformer Model.
• Worked on upgrading the Power play repots to Analysis Studio Reports.
• Worked on upgrading the Cognos decision Manager Catalogs to Cognos Data Manager Catalogs.
• Worked on to identify and mapping the source data with target database columns
• Involved in writing the BRD.
• Worked on HLD document.
• Designed and developed the LLD. worked with Excel and specialized in excel formulas

Technologies: Cognos Impromptu V7.0Cognos Transformer V7.0 Power play Enterprise Server 6.6.1 Cognos Report Studio V8.1. Cognos Framework Manger V 8.1

Confidential, Lancaster-PA

SAP BW & Cognos

Responsibilities:

• Worked on Level1 support on an Offshore and Onshore Model Project.
• Efficiently Managed the Production Support issues and instrumental in stabilizing the System by identifying the issue root causes and identified the solution by running the reports like frequency of the same issues.
• Worked on Transformer Data Modeling enhancements.
• Worked on SAS Enterprise Miner.
• Instrumental in supporting the B2B, B2C reports, dealer performance reports.
• Worked on SAS Macros.

Technologies: Cognos Impromptu V6.0Cognos Transformer V6.6.1 Power play Enterprise Server 6.6.1 SAP BW 3.1 C

Confidential, Hagerstown -MD

Cognos Consultant

Responsibilities:

• Designed and developed the Cognos Catalogs.
• Worked on Cognos Impromptu reports, developed IQD files.
• Worked on Transformer Data Modeling.
• Designed and developed the OLAP cubes using Transformer for UNIX i.e. RSSERVER.
• Published the Cubes to Cognos Upfront.
• Worked on DB2 SQL Queries.
• Instrumental in converting the HOLOS Info cubes into Cognos Power Play Cubes.
• Involved in Testing the Reports, OLAP cubes.
• Used Teradata Fast Export utility to export large volumes of data from Teradata tables and views for processing and reporting needs.
• Involved with data analysis using Teradata SQL assist from data source.
• Worked with SSIS to import, export and transform the data between the linked servers.

Technologies: Cognos Impromptu V6.0Cognos Transformer V6.6.1 Power play Enterprise Server 6.6.1