We provide IT Staff Augmentation Services!

Dw/mdm Architect, Data Modeler Resume

5.00/5 (Submit Your Rating)

EXECUTIVE PROFILE:

  • Technical Architect and Initiative Lead with proven track record in delivering projects on time and on budget.
  • Respected for depth, focus and insight; offers significant expertise driving development and execution of implementation plans for multi - platform warehouses, MDM solutions and data governance programs across industry verticals.
  • Over 15 Years of Experience Architecting, Implementing & Optimizing Best-in-Class MDM/DW Solutions
  • Building Teams, Strategies & Platforms to Derive Maximum Business Value Through BI & Analytics in the Enterprise
  • Vertical exposure spans Life Sciences Media & Entertainment Retail and Consumer Products Banking Insurance
  • Data Warehousing Master Data Management Data Governance & Strategy Data Modeling Analytics Enterprise Architecture Post deployment ITIL Service Strategies Six Sigma Zachman Framework Process Improvement Agile/Waterfall/Iterative SDLC Business/IT Transformation Presentations Negotiations Vendor Management On/Offshore Management Leading Technical Teams Technical Documentations

CAREER HISTORY:

Confidential

DW/MDM Architect, Data Modeler

Responsibilities:

  • Led a team of 5 individuals onshore and offshore to optimization activities for the DW and MDM initiatives resulting in 50% efficiency and enabling the EDW team to achieve their delivery SLA’s
  • Successfully supported two product launches that met business reporting requirements and standardized the data integration process for future product releases and M&A activities
  • Conducted workshops with business and created Conceptual, Logical and Physical data model
  • Led and Architected closed loop marketing MDM Solution, with special focus on Data Quality and Data Security
  • Trusted Advisor of EDW/BI Director for all key strategic decisions, with focus on Technological Risk Management
  • Conducted an RFP process for MDM tool selection. Supplied Request for Proposal document to vendors
  • Coordinated with CIO, Eisai senior IT leadership, Director of EDW/BI and Innovation, senior business stakeholders and internal IT team

Technologies/Skills: Oracle, Erwin, OWB, ControlM and MicroStrategy, SOA, Process analysis, ETL spec /Mapping document, Coordination with BI, CRM teams and external vendors for data integration and consumption.

Program Lead / Principal Consultant

Confidential

Responsibilities:

  • Led development and consulting team of 8 individuals onshore and offshore; responsible for resource management, allocation and project delivery
  • Data Modeling and Process Modeling which improved sales force effectiveness KPIs via highly successful product master MDM implementation which was rolled out to 75 countries/affiliates producing saving of 20% in the overall budget
  • Created a standardized data integrations framework into DW and MDM from different ERP application like Oracle Financials, SAP, Veeva (SalesForce) etc.
  • Served as subject matter expert, architect and program manager for all MDM and EDW architectural initiatives
  • Spearheaded the data governance program for the Sales and Planning division
  • Established and socialized framework for effective project delivery in Agile/Scrum environment; set forth project governance and best practices to foster workforce efficiency and client satisfaction
  • Coordinated with Director of EDW and senior business stakeholders

Technologies/Skills: Oracle, Informatica, Autosys, BO and QlikView. Logical and Physical Data modeling, Process analysis

Lead Principal Consultant and Implementation Manager

Confidential

Responsibilities:

  • Identified need for DW initiative to address huge discrepancy between written and delivered sales.
  • Architected DW and MDM enterprise level solution, using KPIs to identify contributing factors for void sales, relative sales volumes and associated delivery latency.
  • Led team of 15 consultants onshore and offshore and 3 employees in delivering MDM and DW solution with in budget and schedule providing 100% visibility to decision makers
  • MDM initiative was to design of Customer mastering process to provide 360 degree view of customer, to be used in targeted Marketing and sales initiatives.
  • Data integrations with in house ERP application and coordination with ERP and BI teams for data consumption.
  • Conducted an RFP process for visual analytical tool selection.
  • Coordinated with: CIO, CTO, CFO and senior business stakeholders and internal IT. Sold Confidential product suite to Confidential in collaboration with Confidential Sales team

Technologies/Skills: Oracle, Informatica, Cognos, TM1, Spotfire. Logical and Physical Data modeling, Process analysis, SOA

Internal Product design / Partner Channel Lead / Account Manager

Confidential

Responsibilities:

  • Designed Architected and Managed a team of 15 developers (offshore) to produce a SaaS solution on AWS
  • Created partner relationship with major industry
  • Managed portfolio of 5 accounts while generating revenue.

Confidential

Application Manager (MDM)

Responsibilities:

  • Led a seven-person team using an on/offshore model in design/development/deployment of MDM / Salesforce asset management platform;
  • Delivered project three months ahead of initially proposed schedule resulting in detection of preferred Advertisers and Agencies.
  • Designed seamless, single-source analysis of media assets across the entire media asset universe gaining an operational efficiency gained 70%
  • Spearheaded the data governance program and led an RFP process for data governance tool selection.
  • Implementation of entire asset library via syndication channels resulted in the monetization and growth of syndication business generating over $20 million in the first 2 quarters
  • Coordinated with CIO, CTO, CFO, Senior VP of Production and Technical Operations and President of Marketing

Technologies/Skills: Oracle, Teradata, SyncSort, Informatica, BO and Tablaue. Logical and Physical Data modeling, Process analysis

Confidential

Principal Consultant, Confidential Practice Lead

Responsibilities:

  • Led Confidential practice, by recruiting talent, created a culture of accountability and performance to deliver highly effective, scalable data solutions leading to revenue growth of $1.5 mil
  • Designed and implemented prepaid credit fraud detection analytics for TD Bank, built out the customer dimension with robust KPIs for monitoring daily transactions.
  • Designed an MDM solution to maintain branch and employee hierarchies and association to manage mortgage broker sales force effectiveness.
  • Coordinated with VP of EDW, President (Residential Lending) and SVP of HR

Technologies/Skills: Oracle, DataStage, BO. Logical and Physical Data modeling, Process analysis

Confidential

Senior Consultant/Consultant/Support Analyst

Responsibilities:

  • Part of the team that devised information architecture and product taxonomy for Confidential ’s LATAM data consolidation, an 8-month effort that informed Nielsen data usage, market trend forecasting models, project prioritization and competitive strategy
  • Part of the team that implemented metrics on incident management for BP (to fulfil government legislation)
  • Part of the team that designed and implemented Product hierarchies for Ethicon Endo Surgery
  • Partnered with underwriting and senior client management teams to develop a risk management solution for Confidential ’s life insurance division.
  • Led and Implemented Product and Broker hierarchies and KPIs were based on Broker commission and Product margin for GAFRI.
  • Spearheaded project design and execution for data harmonization at Labatt’s in the midst of the Interbrew acquisition, which required integration and normalization of PeopleSoft, Oracle and SAP data into a unified record.
  • Coordinated with Director of BI and Digital technologies and Director of HR and client side SMEs
  • Created the US Confidential support group that catered to all US based clients, resulting in 100% client satisfaction levels

We'd love your feedback!