Resume for Michael E. Zuckerman, CSM
Business Intelligence/Data Warehouse Manager
Deeply experienced and accomplished Senior-level IT professional with 30 plus years of extensive Fortune 100/500 client IT experience delivering Financial, Telecommunications, Manufacturing and Business Intelligence & Data Warehousing computer solutions. A self-starter with reputation for high quality deliverables, expertise in data and solutions architecture and a heavy focus on client satisfaction. Proven ability to scope projects as well as translate user’s priority business needs into technical requirements and technology solutions. Excellent analytical, client service, innovation, and management skills and strong ability to communicate information across multi-disciplinary teams. Expert in resolving client-facing data issues, and executing critical strategic initiatives within corporate business environments. Agile Scrum Master Certified and over 6 years of Agile/Waterfall Project Manager experience in EDW/Big Data environments.
Areas Of Expertise
Big Data Cloud/On-Premise
Enterprise Business Intelligence
Software Development Lifecycle
Advanced SQL & BI Tools
Business Intelligence Analysis
BI/DW, Data Governance
Business Intelligence Reporting
Agile/Scrum Master Certified
Employee Training, Mentoring
Intercontinental Hotels Group, Atlanta, GA 1/2017 – 12/2017
Senior BI Manager/Technical Advisor (contract)
Successfully managing multiple Global Reservations System applications Projects in an Agile/Waterfall environment from Inception thru Implementation in multi-team/cross-functional environment. These projects are part of IHG replacing their legacy Hotel Reservations System across their entire global hotel chain portfolio.
Project Charters, Project Plans/Schedules/Budgets/Tracking, Resources, Solution Architecture Design, Risk, Change, Project Scope, Project team meetings, Project Status to Leadership. Project Descriptions:
oGRS V2 R8 Low-Level Design, Products & Attributes, Reservations Data models, Operational & Analytical data requirements ($1.1m)
Solution Architecture design reviews, Data Model Architecture design/reviews
oGRS V2 SLA Reporting multi-data source, data integration, Google Cloud/On-premise, Hadoop/Teradata data ingestion and Reports/Dashboards project ($850K)
Data Model/Architecture, Software Solution Architecture reviews in Big Data Ingestion Hadoop/Hive, Teradata EDW environments
Six data sources ingestion via REST API, SFTP file servers for SLA Reporting
oGRS V2 R8 Data Architecture solution/design in Google Cloud/Hadoop/Teradata data environment
Data Model/Architecture, Software Solution Architecture reviews in Big Data Ingestion Inspection Framework, Hadoop/Hive, Teradata EDW
COCA-COLA, Atlanta, GA 2/2016 – 5/2016
Senior BI/DW Project/Program Manager (contract)
Business Intelligence Program/Project Manager working on 2016 Coke Freestyle Analytics Roadmap. Sr. Agile Project Manager on multiple projects managing resources for Discovery Q1 Release Microstrategy Dashboards/Reports enhancements from Requirements through Implementation, assist with Discovery MSTR and Splunk/Redshift DB technical support, AWS.
Successfully managed and delivered two Q1 Releases 1.0, 1.1. Implementations of the Discovery Microstrategy Dashboards/Reports enhancements to approximately 300 users.
Agile Project Management and Planning. Daily/Weekly status for multiple projects re: 2016 Analytics Discovery Roadmap to CCFS ecosystem cross-functional teams of thirty resources.
Organize and lead Analytics project related meetings including Global IT Monthly Steering Committee
Create/manage CCFS Analytics Master Project Plan, overall budget $2.5 million.
Create/Maintain CCFS Project Milestone records in Salesforce.com cloud application
Note: Position filled internally by Coke resource waiting to finish project and transfer to Discovery Analytics team…
AMERICAN DENTAL PARTNERS, Boston, MA 3/2015 – 12/2015
Senior BI/DW Manager/Sr. Technical Advisor (contract)
Business Intelligence (BI) tool evaluation and implementation for new Enterprise Business Intelligence Data Warehouse project covering full SDLC (requirements through implementation) for billion dollar client and a project budget of ~$1M.
Evaluated leading BI Software solutions IBM Cognos BI, SAP Business Objects BI and six software consulting vendors to architect and implement ADP’s first Enterprise Business Intelligence Data Warehouse focused on Denovo/TM1 reporting. TM1 Reports and cube conversion and automation, data cleansing, enhance departmental BI for enterprise.
Conducted meetings with software principals and consulting vendors to review proposals, business requirements and technical specifications. Created multiple SWOT Analysis presentations for the ADP Executive Leadership team for final decision. Established Data Governance/MDM solutions approach in SQL Server DQM/Jira Confluence tools.
Successfully assembled/presented SWOT Analysis/Architecture Overview and presented to Executive leadership to drive decision for BI/DW Software platform and consulting team. Reviewed vendor proposals and made final recommendation for IBM Cognos and QueBit consulting (chosen by Executive Sponsor). Prepared initial Agile/Waterfall project plans and managed projects from inception Project Phase I kick-off through Implementation Phase on-time/on budget.
Successfully managed End-to-End project Consulting team from requirements, design, development, testing, documentation and implemented ADP’s first ever foundational Business Intelligence Enterprise Data Warehouse in a IBM Cognos10 and MS SQL Server environment with 300 users integrated with existing TM1 system. ADP is a billion dollar Dental Practices services provider. Successfully Created/Managed/Delivered the company’s Enterprise Data Warehouse and Data Governance Roadmap for Executive.leadership and user data foundation for the BI/DW.
Intercontinental Hotels Group, Atlanta, GA 11/2014 – 1/2015
Senior BI Manager/Technical Architect (contract)
Business Intelligence (BI) tool evaluation project for Project Portfolio Management data reporting project. Modeled project financials/metrics data and dashboards in Tableau 10, QlikSense and SiSense for the IHG Executive Leadership team.
Successfully managed/modeled Data Export/Import from Smart Sheet project portfolio data sources.
Completed Analysis/Modeling/Preparation and Dashboard prototyping in multiple tools (Excel, QlikSense, Tableau, SiSense) from Requirements through Proof-of-Concept Dashboards and hand-off to Tableau consultants.
Axiall Corp, Atlanta, GA 03/2013 – 10/2014
Senior BI/DW Project/Program Manager/Technical Architect (contract)
Contract BI/DW Sr. Program/Project Manager/Sr.BI Architect Sr. BI PM responsible for managing/delivering seven (7) BI EDW Data Integration Projects plus a major Global Trade Compliance BI/EDW Phase I & II Project, Chemical Sales Consolidated Reporting JDE, ROSS, SAP ERP data, Electronic Health & Safety history data projects. SQL Server 2012, IBM DataStage ETL.
Successfully captured all business/technical Requirements BI technical design/architecture designs/reviews.
Created/Managed all (7) MS Project Plans (Agile/Waterfall), managed project issues and task tracking (Power Steering), Daily/Weekly project status, Communication of Requirements and Status with Business/Technical staff, Technical Issues resolution, and meeting planning/leading. Managed a team (3) ETL IBM DATASTAGE resources and (2) IBM Cognos reports developers and (1) Business Analyst per project requirements on SQL Server 2012. Delivered all strategic projects on-time, on-budget.
AT&T, Atlanta, GA 07/2011 – 03/2013
Senior BI/DW Project Manager/Technical Architect (contract)
Senior Technical Project/Program Manager and Sr. Solutions/Data Architect Data Strategy Team engaged with Data Governance Metadata Management (MDM) program (AT&T), Informatica PowerCenter SE 8x, Golden Gate,, iLOG, ActiveVOS (Workflow Mgmt.), CA-Repository, IBM Infosphere v8.5/7, IBM Netezza, Teradata 12x/13 over CIM – Customer Info Management System), Oracle 11g environments (AT&T), Oracle Data Relationship Mgmt. (DRM11.1.2).
Senior Solutions/Data Architect/Manager "One" AT&T in Alliance Big Data Governance for eCDW (Enterprise Consolidated Data Warehouse) program: DPLR Data Profile Lineage Repository projects (Phase I, II) Technical and Operational Metadata (technical, operational, reporting/audit/compliance, data quality) project to link eCDW business metadata using IBM's Information Workbench.
Executed special project for Data Strategy Team analysis of Teradata tables/data analysis. Created project impact checklist for use by DS team.
Achieved CIM (Customer Information Management) System in-depth analysis for Data Strategy Director/Team initiative to gauge project impacts to CIM and successfully delivered critical Impact Checklist for the Program Management Office (Front Door) evaluation.
Successfully gathered requirements and created Solution Approach/High-Level Design for Data Governance project working with eight cross-functional teams to deliver IBM Infosphere MDM/Netezza DW.
Created/Managed/Delivered Solution Approach and Design for ActiveVOS Oracle DRM (Hierarchy Management) Workflow Integration project.
Chick-Fil-A Restaurant Corp, Atlanta, GA 10/2010 – 06/2011
Senior BI/DW Architect/PM (contract)
Developed/converted SAP Business Objects XI and Oracle OBIEE 10 BI Publisher sales/financial performance reports for Corp HQ Atlanta, GA Manage/Develop automated Menu Price updating project in Genio ETL tool on team of 3 developers, 1 PM. Key Skills: SAP Data Integrator Netweaver /Oracle 10g/11g, Genio ETL design/development, Oracle OBIEE, BI Publisher (complex SQL), Business Objects. Base Camp Agile Project Management
Successfully converted/delivered 27 key Business Objects XI Restaurant KPI/Location Financial Comparison reports (complex SQL queries ranking/percentiles, 100 pg. data templates, report bursting) into Oracle BI Publisher/Oracle Answers ad hoc reports 10g for web deployment on company portal. Analysis/design/develop subset of above for Mobile sales reports in BO XI and BI Publisher.
Successfully Managed/developed ETL project to automate restaurant Menu pricing changes previously taking 1-2 weeks to accomplish manually execution in minutes via automated process.
COMPUTER INTELLIGENCE, INC., Atlanta, GA 04/2009 – 09/2010
Invented and patented design for ergonomic wrist rest product for laptop/desktop computers. Provided new product creation, design, manufacturing and sales and marketing.
Successfully invented new ergonomic computer accessory product successfully selling on Amazon.com. Developed business and marketing plans, sales calls to retailers including C-level execs and positioned product for automated on-line sales and fulfillment on Amazon.com.
Northrop Grumman, Reston, VA 08/08 - 04/09
Project Manager/Lead BI/DW Reports Architect (contract)
- DoD Secret Level security clearance (2009)
Responsibilities: Project: Data Warehouse Architect/Developer/Project Manager for design, development and implementation of PeopleSoft Global HR Data Warehouse application for DIMHRS - Defense Integrated Military Human Resources System (Team size approx... 12 people). Project Manager for Actuate and Cognos8 cubes/reports (2 developers), Ascential Datastage ETL changes (3 developers), and PeopleSoft Application Designer over DB2/UDB AIX Data Warehouse for Army & Air Force. Worked with cross-functional teams to identify/update functional specs and related design documents for Army/Air Force DIHMRS systems.
Accomplishments: Successfully managed the Design, Development, Testing, Delivery of strategic Army/Air Force Cognos8.2 cubes and Actuate reports integrated with PeopleSoft Global HR. strategic Cognos8 core cubes/reports using Framework Manager. Project/Program planning for Cognos 7.3 to Cognos8.4 migration. Advocated creation of Data Governance office/control of largest PeopleSoft HR system in the world for DoD branches of military. Worked and communicated with high level officers and C-management. Researched numerous Data Governance approaches/white papers: TDWI, HP BI Master Plan, DataFlux, Talend, Trillium, Informatica, IBM, Teradata).
Accenture LLP, Atlanta, travel 07/06 - 10/07
Technical Solutions Architect/Project Lead
Responsibilities: Sr. Consultant/Technical Solutions Architect/Project Lead for AON Insurance Project: Business Intelligence application outsourcing engagement of Actuate enterprise reporting system for AON Insurance (Atlanta/Winston-Salem, NC) utilizing Actuate 8 iserver, ActivePortal, DataMart, VB .NET, C#, IIS, Reporting Services, PeopleSoft 8.8 working directly with a CIO and VP to successfully knowledge transition and outsource their system to Accenture on-shore/off-shore resources. Data Conversion Design Lead Architect for CalPERS project in Sacramento, California CALPers Pension Resumption System (PRS) Oracle 10g project. Worked with cross-functional teams to design Logical/Physical models for new Oracles PRS database and design, develop ETL procedures for DB load utilizing PL/SQL in Oracle SQL Developer. Analyze demographic legacy data, develop design, troubleshoot for data cleansing/consolidation strategy, staging data and ETL loading to final PRS Db. Accomplishments: Transitioned AON Insurance Data Warehouse/e.Reporting system from Winston-Salem, NC to Atlanta. Project Lead responsibility for Datamart/ Actuate7 /VB .NET/Peoplesoft8/reports and client exit criteria, completing testing prior to taking over application support in Atlanta. Managed 3 contract reporting resources as well as transition knowledge training to offshore Manila resources team for Datamart/Actuate support. Managed Full life-cycle development, production support and interfacing with senior level management. Developed all reporting knowledge transition documentation and cross-trained Manila offshore resources on the application. Solved major data and reporting issues left open previously by internal staff. Managed year-over-year Actuate e.reporting folder re-deployment. Mentored new-hire employees at Business Intelligence boot camp held in Dallas, Texas teaching consultants high level overview of Accenture Business Consulting concepts, project methodologies and Business Intelligence practices. Presented SWOT analysis for Endeca and Netezza fast search tools for BI Consulting Group of 400 consultants. Successfully completed legacy Data Conversion and Metadata control technical and ETL PL/SQL design/development/test for critical multi-million dollar Accenture-CALPers Pension Resumption System (PRS) project.
Home Depot SSC Atlanta, GA 10/2005 - 6/2006
Lead Architect (contract)
Responsibilities: Sr. Reports Architect/PM working on a complex Actuate reporting project at for Callidus Bonus Calc re-engineering project. Full SDLC - working with cross-functional teams to gather Functional Requirements, Create Design, Develop, Test, Document and Implement Actuate7 reports to meet Enterprise Incentive Management Bonus Calculation Project needs utilizing TrueComp, DataMart, Actuate e.Reporting tool. Work with Ab Initio Lead Developer to design IBM DB2 tables and remedy performance issues in order to satisfy acceptable Service Level Agreements.
Accomplishments: Successfully managed, designed, developed and implemented new complex Actuate Bonus Recalculation reports to replace legacy spreadsheet application on-time and on-budget. Worked with cross-functional teams to gather requirements and create functional and detailed designs.
Callidus Software Inc. 10/2004 - 10/2005
Sr. Lead Reporting Architect
Responsibilities: Sr. Technical Reporting Consultant Actuate 7 e.Reports Developer working on Reporting projects at multiple client sites including Telus Canada, Citizens Bank, Cingular Wireless, and Nokia. Full SDLC - Functional Requirements, Detailed Design, Develop, Enhance, Document, Test, and Implement reports and ETL procedures to meet various clients’ needs utilizing TrueComp/Datamart, Oracle 9i, PL/SQL.
Accomplishments: Delivered major improvements in critical, complex reports/ETL changes for Nokia. Designed, Developed and Delivered successful Telus Callidus reporting implementation. Accomplished TrueComp 4x Certification, Actuate 7 Certification
Accenture LLP, Atlanta, GA 11/2000- 10/2004
Implementation Project Manager/Architect
Responsibilities: Design/Developed software development management process. Supervise contract reporting programmers. Responsible for TrueComp-Actuate Data Mapping tables, Informatica ETL design/coding, Configuration Management: Implementation planning, Harvest code repository, Table mapping, scripting/updates, Production support/troubleshooting, requirements gathering with customer, design, construct, test and implement Actuate reports. Previous production support/enhancements on Financial Asset Management, Front End/Rules Maintenance system utilizing HP-UX, PeopleSoft/People tools/People code, SQR programming, Oracle 7.3.4, Microfocus COBOL/SQL/Rdb, korn shell scripts, IBM-MVS DB2, TSO, Autosys scheduler. Application DBA for Financial Front End/RM - user security, triggers, snapshots, table refreshes/unloads, data purging/maintenance. Oracle Financials application DBA, PL/SQL design/code/test/implementation.
Accomplishments: successfully managed and delivered Actuate releases in very fast moving, complex environment working with cross-functional teams consisting of Compensation, Integration and Reporting. Multiple successful projects delivered on Bellsouth FFE team managing software enhancements, ETL & Reporting, releases and new development across multiple teams.
Education & Certifications
Master of Business Administration Coursework, University of North Carolina-Charlotte, Charlotte, NC
Bachelor of Business Administration, Business Marketing, The University of Texas at Austin, Austin, TX
Data Processing Certificate, with Distinction, Texas Institute, Dallas, Texas
Scrum Master Certified (2014), PM Certified(2004), Microstrategy9 Certified, Cognos8 Certified, Actuate7 Certified, Oracle Certified Professional