EXPERIENCE SUMMARY:

• Accomplished data warehouse consultant with over 12 years of experience in domains like retail, marketing, insurance, pharmacy, manufacturing and oil & gas.
• My recent technical experience are dedicated to master data management, data quality, data governance, data mapping, data migration, dimensional modeling, data architecture, business intelligence, ETL and product development.
• I have mostly worked with fortune 500 companies and delivered their large scale IT projects.
• Working with these companies have given me great exposure & opportunity to learn their best practices and a chance to contribute to their complex business needs with innovative solutions.
• I am well versed with all aspects of software development life cycle spanning from requirements to deployment, imparting user training, facilitating JAD - Sessions, conducting workshops, organizing UAT, change management, issue management and continuous support involving multiple-skilled teams and senior decision takers with hands-on business implementation, relationship building, financial targets, political undertakings and people management.
• At project level, I have used BABOK methodology to perform business analysis and requirement gathering. Additionally I have fair amount of experience as product manager using agile development methodology. Most recently I have managed dual responsibility as MDM Analyst/Architect and Data Architect.
• At enterprise level, helped the organization with BPM activities by charting road maps, planning, scheduling, work & effort breakdown, organizational change management, managing RFI/RFP processes including financial/contract terms negotiations. I have been very actively involved in performing data capability & tool assessment for various enterprise wide projects and involved in leading the selection of tools for the enterprise.

TECHNICAL SKILLS MATRIX:

Requirement Documentation: Product Backlog (build User Stories), Business Requirement Document(BRD), System Requirement Document(SRD), Functional Requirement Document(FRD), Source to Target Mapping, Use Case Scenarios, Dimensional Bus Matrix.

BI Reports: Hands-on: Business Objects, Micro-Strategy (BIAP), Exposure-on: OBIEE, COGNOS, QlikView and SAS EG.

ETL Informatica (Exposure): MDM & Data Quality, Oracle MDM, Teradata MDM, SAP Match Transform Tool, Dun & Bradstreet, KLADR, YLM-IG Data Processing.

Profiling Tools: OEDQ, Information Stewards (SAP), Trillium Discovery.

Data Modelling: ER Diagram, Class Diagram, Conceptual Data Model, Enterprise Data Model, Logical Data Model

Documentation Repository: HP ALM (Previously QC), JIRA, Rational Requisite-Pro, SharePoint

Metadata: Adaptive Metadata Manager

BPM: Requirement Strategy Matrix (RSM), Process Flow Document, SIPOC, SWOT, Rule-Xpress(by Rule Arts), Training Manual, Process & Problem Solving Diagrams(DFD, Decision Tree, Functional Decomposition, Org Chart, Flow Chart, Activity, Fishbone, Use Case, Sequence, State Machine)

Database/Access Tool: Oracle, Teradata, SQL Server, Toad, Oracle SQL Developer, Teradata SQL Assistant, DB2

Methodology: Agile/Scrum, Water Fall, BABOK

Special Software: VM-Ware, BMC Remedy, MS-Visio, Erwin.

Operating System: Windows, Unix, Mainframe(PST Terminal)

PROJECT EXPERIENCE & IMPLEMENTATION SUMMARY:

Confidential, Burlington, MA

Tools: SAP MDM, SAP Match Transform, Data Quality, IG Data Processing, Oracle Exadata, Oracle SQL Developer, JIRA, Cognos.

Responsibilities:

• Involved with Customer Data Append Processing for ODS & DWH:
• Email & Phone append
• Reverse email & Reverse Phone append
• Demographic & Ethnic Append
• Geo-Capture Append
• NCOA Processing
• Change of address & email processing
• Customer Matching & Consolidation Rules
• Mail/Email/Phone preference centre

Confidential, Somers, NY

Tools: SAP Match Transform, Teradata MDM, Teradata, Teradata SQL Assistant, SharePointMajor Deliverables: Functional Design Document, Integration Document, Business Process Document, Source to Target Mapping, Business Rules, Data Quality Rules, Customer & Vendors Matching Rules, Survivorship & Trust Framework Golden Master.

MDM Business System Analyst

Responsibilities:

• Siebel CRM would also like to leverage MDM’s capability to maintain the authentic and complete data for a customer.
• Once a customer has been created in Siebel, it would be sent to CDH for customer validation and enrichment
• Data quality being foundational to BI Analytics, a systemic approach to assess and improve quality of underlying data was a key to success of the analytics program. This project outlines Data Quality Framework spanning across systems already integrated to MDM & OBI EE

Confidential

Business Analyst - Enterprise & MDM Analyst

Responsibilities:

• Requirement Strategy Document, BRD, SRD, Source Data Analysis, Source to Target Mapping, Business Rules, MDM Mapping, OBIEE Reports and Dashboards, Qlickview Reports and Dashboard, Use Case Document.

Tools: Apache OFBiz Platform, MYSQL, Java, Bugzilla

Product Manager

Confidential

Responsibilities:

• Project Charter, Assumptions, Risk, Migration Strategy, Requirement Strategy, Testing Strategy, Product Backlog

Confidential

Business Analyst - Consultant

Responsibilities:

• Confidential wanted to cross sell Geek Squad services to other retail online stores.
• Once the customer shops for any electronic product from these websites, he will get the option to configure the services of Geek Squad at bundled rates.
• Scope of Work, Requirement Strategy, Estimation

Tools: Microsoft Office, TCS Estimation Tools

Confidential, San Antonio, TX

Business System Analyst (Business Manager)

Tools: Business Object, SAS EG, Ms Office, SharePoint, DB2, Mainframe

Responsibilities:

• Requirement Strategy Matrix, SIPOC, Dimensional Bus-Matrix, Data Analysis, Source to Target Mapping, Metadata Mappings, Glossary, Business Rules, Production Data Validations

Confidential, Warren, NJ

Tools: MS-Excel, Oracle, Visual Studio for Office, Moody’s Risk Analyst, SharePoint

Business System Analyst

Responsibilities:

• BRD, SRD, Data Analysis, Source to Target Mapping, Glossary, Process Document, Training Manual, Use Case Document, Production Data Validation.