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.