Dw/mdm Architect, Data Modeler Resume
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