Download PDF

JOHN HENRY

A Data Warehouse Professional with extensive experience working with business intelligence and data warehouse technologies, along with 10+ years of experience in sales analysis and forecasting. Demonstrates a passion for data quality and process improvement. Highly effective leader with an ability to work across all levels of an organization while also achieving the recognition for developing high performing teams both on-shore and off-shore.

Work experience

Manager, Data Warehouse, Information Technologies

20122018
AMERICAN GREETINGS, CLEVELAND, OH

Managed daily activities of on-shore and off-shore data warehouse teams with a focus on improving data quality and system availability. Managed both data warehouse and non-data warehouse projects as assigned.

Managed a staff of 8 that maintained data warehouse applications, data quality and business support.

Developed department workload budgets for discretionary and non-discretionary work.

Reduced non-discretionary spend for the data warehouse team by 75% through improved processes.

Created off-shore staffing model to supplement support of corporate data warehouse and reduce overall maintenance cost through working with CIO to hire 3 additional staff, onboarding, training and professional development.

Managed a project to convert over 700 ETL maps to a new ETL package(BODS).

Led project to implement EDI for Amazon to automate and streamline order process and reduce overhead cost.

Helped develop bandwidth analysis reports for CIO identifying opportunities to decrease bandwidth at certain sites.

Managed project to migrate Cognos 7(client-based) to Cognos 10(web-based). 

  - Rationalized under-utilized cubes and combined Sales and POS cubes reducing objects maintained and ongoing maintenance costs. 

  - Reviewed usage and identified opportunities to reduce the number of standard reports and maintenance costs. 

  - Analyzed number of user licenses and reduced costs by reclaiming underutilized licenses.

  - Recommended reduction in Cognos 7 footprint resulting in~ $80K savings. 

  - Developed Gatekeeper/Power User role to share some data warehouse support with the business.

  - Managed organizational change management process ensuring business was on board with Cognos migration.

Assisted the* Lift and Shift* project to move data warehouse from DB2 to Teradata. Assisted in overhaul of the Order to Call(OTC) process.

  - Recommended model design changes reducing effort by~ 200 hours.

  - Developed interactive Cognos reports for Regional Sales Vice Presidents. 

  - Developed and implemented testing approach. 

  - Helped move OTC reports to Teradata, reducing DB2 licenses by~ $39K.

Managed project to improve how scanned dollars were applied to Dollar General, Dollar Tree and Walmart POS improving accuracy of sales reporting and reducing maintenance costs.

Assisted project teams in ERP implementation including rearranging staff allocation to free up resources, transitioning

Participated as member of Change Advisory Board to review / approve all significant changes to corporate systems.

Managed monthly Cognos license reconciliation process to ensure licenses were utilized and within contract terms.

Project Lead, Data Warehouse, Information Technologies|

20052012
AMERICAN GREETINGS, CLEVELAND, OH

Managed User Focus team, a subset of data warehouse team. Focus was to maintain and improve data quality and enable users to leverage data warehouse for business decisions. Responsible for partnering with corporate departments to identify opportunities to improve and expand use of data warehouse. Managed staff of 5 Business Analysts.

Implemented robust communication process to inform users of technical or data issues.

Held educational sessions for business users on advanced reporting features including geographic reporting, building dashboards, and automating report scheduling and distribution.

Initiated user group meetings as a forum to share information and best practice reporting techniques.

Managed project reducing time and effort to correct POS data, resulting in 75% improvement.

Led project to create operational profile for data warehouse to streamline support and maintenance.

Managed project to install Query Patroller, which provided insight to use and performance of data warehouse.

Worked with Business Analysts to develop a career progression roadmap with expected deliverables for success.

Assisted in the integration from Category Management into IT department.

Established a* Report Factory* to create standardized reports for Sales and Marketing Divisions for metrics, talent acquisition and communications with key stakeholders.

Developed a POS data quality scorecard resulting in improved insight and visibility to senior management.

Implemented both reactive and proactive data quality checks in data warehouse.

Led project to develop reporting for Informatica and Cognos processes reducing batch cycle and improving SLA.

Developed automated alerts to identify long-running queries and send e-mail notices for improved troubleshooting.

Led IT efforts to realign entire Field Service Organization.

Assisted in analysis of royalty payments to non-SBT accounts to identify opportunities to change payment methods. Developed and implemented a POS Onboarding process to standardize data quality for new POS retailers.

Served as SME on project to automatically calculate seasonal returns that significantly reduced hours worked by Merchandising staff to manually create return documents.

Assisted in merger of Recycled Paper Greetings(RPG) and Papyrus Greetings companies by integrating processes to use corporate data warehouse.

  - Presented and demonstrated data warehouse capabilities for RPG senior management.

  - Developed off-site support and transition plan for CIO.

  - Assisted in closing decision support gaps by meeting with Sales and Marketing management in Chicago.

  - Developed training plan and held supplemental workshops in Chicago to help integrate RPG associates.

Helped develop scenarios and test / analyze results in the Teradata POC (proof-of-concept) project.

Worked on SAP prequel project to integrate Finance SAP data into data warehouse.

Developed Order-to-Call (OTC) reports for Field Sales Organization to manage order to call ratios.

Category Manager, Business Intelligence

20032005
AMERICAN GREETINGS, CLEVELAND, OH

Category Manager, Business Intelligence| Responsible for development, distribution, and maintenance of store door forecast for U.S. Greeting Card Division. Managed analysis and redistribution of workloads for Field Sales associates. Served as business lead to reshape Sales/POS analytics through development and use of corporate data warehouse. Handled Category Management for independent channel. Managed staff of 4 Information Specialists.

Supported independent channel managing category with space-to-sales, YOY and competitive reporting and analysis.

Participated in development of corporate data warehouse improving accessibility of sales and finance information.

  - Led implementation of phase 3 and 4 of data warehouse project to convert existing data and reports.

  - Helped shape business and reporting requirements as process area representative(PAR) for project.

  - Led cross-functional teams to develop business metadata definitions for all measures and dimensions.

  - Helped develop BI tool requirements and organized vendor demonstrations and training for Cognos. 

  - Coordinated issue resolution related to data quality, usability and accessibility.

Developed Strategic Data Management Department to support business users.

  - Created corporate intranet site to support users with FAQs, metadata, data training documentation, etc.

  - Developed communication strategy using e-mail, intranet, newsletters, etc.

  - Developed position of Online Analytical Processing Specialist / Report Administrator supporting Cognos.

  - Created position of Data Stewards to monitor and maintain data quality and communicate issues.

  - Initiated position of Data Enabler to assist end-users with questions and identify enhancement opportunities.

Overhauled Sales Forecasting process improving alignment with Account Profitability revenue plans.

Implemented a stratified forecast plan based on POS trends provided by Management Sciences Department.

Identified need and developed a separate monthly forecast spread for our SBT (scan-based trading) accounts to accommodate the lag between shipments and scanned sales.

Collaborated on the use of supplemental UPC data for Walmart that provided design-level detail to product analysis.

Supervisor, Sales Information, Sales Support

20002003
AMERICAN GREETINGS, CLEVELAND, OH

Promoted to manage development, distribution, and maintenance of store door forecast for U.S. Greeting Card Division. Responsible for review and analysis of territory, district and region workloads while recommending redistribution of those workloads. Supervised staff of 4 Sales Information Specialists.

Automated process to develop and distribute sales forecasts using mainframe FOCUS, reducing time and effort to produce forecasts by over 50%.

Converted paper-based sales reports to electronic versions, which significantly reduced report distribution time.

Implemented new GIS software to streamline process of realigning territory workloads by over 75%.

Collaborated on Gibson merger team integrating sales support processes with existing processes including category mapping, sales structure integration, and requirements gathering.

Assumed role for developing annual business reviews for 300+ chains and created standard template and Visual Basic code for creation and distribution to sales account executives.

Ensured smooth transition and validation of sales reporting during Y2K by developing and implementing test plans.

Researched and recommended additional GIS tools to streamline territory workloads (TerrAlign and MapMarker).

Implemented TerrAlign to realign Field Sales Division which incorporated Carlton and Gibson Sales Organizations.

Helped integrate Carlton Canada Sales Support by developing service level agreements (SLAs) between Carlton Canada and Business Intelligence, resolved issues, conducted training, and traveled to provide additional support.

Special Projects Analyst, Sales Analysis

19922000
AMERICAN GREETINGS, CLEVELAND, OH

Promoted to role for development, distribution, and maintenance of store door forecast for U.S. Greeting Card Division. Responsible for review and analysis of territory, district and region workloads and recommending redistribution of workloads.

Developed and maintained territory workloads for 500+ territories using Geographic Information System (GIS).

Participated on Rbase to Access Conversion team through coaching, training and communication ensuring database conversion was error-free and reduced downtime.

Developed, distributed and maintained sales forecasts for 30,000+ store doors.

Assisted other departments by creation of ad-hoc sales reports and providing analysis resulting in improved competitive advantage, store linear footage, and forecasting & budgeting.

Introduced the use of BPI (buying power index) and leveraged demographic data to fine-tune store door forecasts.

Partnered with Technical Training Department to develop and teach an Excel macro class to the Sales Division.

Developed the process to spread Walmart sales goals based on the store’s prototype to improve accuracy.

Sales Analyst, Sales Analysis

19911992
AMERICAN GREETINGS, CLEVELAND, OH

Sales Budget Analyst, Sales Support

19901991
AMERICAN GREETINGS, CLEVELAND, OH

Customer Service Representative, Retailer Financial Support

19891990
AMERICAN GREETINGS, CLEVELAND, OH

Education

Bachelor of Science - Business Administration

Dyke College

Masters Certificate in Project Management

George Washington University

Skills

Data Warehouse Management
Business Intelligence Applications
Forecasting and Analysis
Process Improvement
Project Management
Budget Development
IT Service Management
Microsoft Office
Visual Basic for Applications
SQL
Graphical Information Systems