Summary
Overview
Work History
Education
Skills
Timeline
Generic

Chris Malone

Royal Oak,MI

Summary

Senior Data Analyst and Analytics developer with over 20 years of successful experience focusing on Cognos and Microsoft toolsets. Recognized consistently for performance excellence and contributions to success in the automotive, banking, education, and financial services industries. Strengths in business intelligence, database tools, data analysis, technical training and project management.

Overview

19
19
years of professional experience

Work History

Senior BI Platform Engineer

General Motors
01.2023 - Current

Platform Administrator, General Motors

  • Platform Maintenance and Support: Oversee daily operations for IBM Cognos 11.2.4 and Power BI Cloud, including server and software maintenance, user onboarding, and issue resolution to ensure seamless platform performance. Successfully reduced report errors by over 50%.
  • Cloud Migration Leadership: Spearhead the migration from IBM Cognos 11.2.4 on-premises to IBM Cognos 12 on Cloud Pak for Data on Azure RedHat OpenShift, ensuring a smooth transition and minimal disruption.
  • Optimization and Audits: Conduct regular audits to identify and implement opportunities for platform cleanup and optimization, enhancing overall efficiency and performance. Over the last 12 months, optimized or removed over 10,000 reports and over 100 metadata models (Framework Manager).
  • Community Engagement and Training: Facilitate IBM Cognos and Power BI office hours, delivering tutorials, demos, and best practices discussions to empower and support the user community. Currently supporting over 6,000 members through training sessions and guidance.

Senior Data Analyst

General Motors
08.2021 - 01.2023
  • One of four members volunteering to run Power BI user group and office hours for over 2,900 members. Over 50 recognitions received from March 2022 to March 2023
  • Document, audit and tune over 10 Power BI reports for better user experience and developer ownership.
  • Curate and manage 7 Adobe based datasets using Python, Hadoop SQL, and Autosys data tools for Power BI report consumption.
  • Create and manage internal operational reporting for Dynatrace, Emplifi and Autosys ETL tracking.
  • Develop and maintain 3 Power BI and 2 Cognos dealer billing and marketing program reports pulling from 5 Greenplum and 5 Hadoop database tables.
  • Create over 5 proof of concept models to showcase Power BI cloud and Dremio to senior leadership for customer lifetime value project.
  • Create and present training content to over 10 project team members to ramp skills

Lead Power BI and Cognos Developer

General Motors
06.2018 - 08.2021
  • Defined and documented development best practices for 12 Power BI employee and contract developers.
  • January 2019, asked to be one of four members volunteering to run Power BI user group and office hours for over 2,900 members.
    First person at company to obtain Microsoft Power BI certification.
  • Trained and mentored 6 junior developers to focus on best practice, reusable objects, clean SQL queries and troubleshooting.
  • Created standardized reporting templates to reduce development time down by up to 2 hours per report.
  • Within 2 weeks, fixed and deployed a 2 year failed external facing reporting project to track website information.
  • Delivered no less than one proof of concept model every 2 weeks to different business users in order to gain reporting space.
  • Converted 5 Tableau and 7 Cognos reports to Power BI report server, saving the company on multiple platform licensing and maintenance.
  • Worked as a knowledge expert to help IT rebuild Cognos Metadata models for Leads reporting.

IBM Cognos TM1 Developer

Jones Lang LaSalle
10.2016 - 06.2018
  • Defined and documented TFS project process and IBM TM1 development guides for 6 developers and 3 business analysts.
  • Defined and maintained plug and play reusable code and templates, resulting in 20% development time reductions.
  • Delivered over 20 property management forecast and reporting models in 2018, compared to 12 in 2017.
  • Monthly proof of concept show and tell to enhance reporting and reduce delivery time.
  • Lead developer troubleshooting and best practice meetings.

IBM Cognos BI and Planning Consultant

Creative (Lighthouse) Computing
05.2014 - 09.2016
  • Delivered over 30 IBM Cognos BI, Enterprise Planning, TM1, SPSS, and Power Play developer and end-user training through IBM and Learnquest training partner.
  • Converted over 15 reports from Cognos Enterprise Planning to IBM TM1 forecasting and reporting tool, reducing development and reporting activities by almost 50%.
  • Designed and delivered 4 Cognos metadata models utilizing Microsoft SQL and Oracle database queries.
  • Delivered over 40 proof of concept models 5 stakeholders during 2 year development phase.
  • Delivered one of IBM's first business intelligence Cloud implementations in North America.
  • Key customers: Boston College, Ringling College, and Element Financial.

IBM Cognos BI and Planning Consultant

Ironside Group
01.2013 - 04.2014
  • Delivered over 10 IBM Business Intelligence and IBM TM1 onsite and virtual training through IBM or Iron-side consulting directly.
  • Analyzed and documented customer financial models.
  • Designed and build Cognos Framework Manager packages from SQL Server, Oracle and DB2 data sources.
  • Designed and built various Business Intelligence reporting and forecasting models for external and internal clients.
  • Designed and built system security for models.
  • Managed or participated in customer product life cycle.
  • Delivered presales and proof of concept modeling for sales calls.
  • Key customers: Comerica Bank and BBVA Compass.

IBM Cognos BI and Planning Consultant

Newcomp Analytics
06.2006 - 12.2012
  • Delivered over 50 IBM Cognos BI, Enterprise Planning, TM1, SPSS, and Power Play to developer and end-user trainings directly through IBM.
  • Designed and implemented 10 year build, ship, and sale planning and forecasting model by different date granularity for Volkswagen Group of America.
  • Converted over 20 reports from Cognos Enterprise Planning to IBM TM1 planning for Regina Healthcare reducing in 25% reduction in maintenance time.
  • Converted over 25 Excel workbooks to IBM TM1 planning models for Manilla Healthcare in Alaska. This *one year activity resulted in over 100% time reduction in on going maintenance.
  • Designed and developed TM1 short term planning and reporting models for Canadian Pension Plan Investment Board, which manages over 21 million Canadian's retirement money.

Education

Bachelor of Science - Finance

Michigan State University
East Lansing, MI
1996

Skills

  • Power Platform - Power BI, Power Apps, and Power Automate
  • IBM Cognos Analytics Report Studio v8-v11
  • IBM TM1 (OLAP Modeling Tool) v9-v11
  • Database works: DataBricks, SQL, Oracle, DB2, Hadoop, Greenplum and Postgres
  • Certified PMP,
  • Change Management Tools - Jira and TFS
  • Technical Content Developer and Trainer
  • Business Analysis

Timeline

Senior BI Platform Engineer

General Motors
01.2023 - Current

Senior Data Analyst

General Motors
08.2021 - 01.2023

Lead Power BI and Cognos Developer

General Motors
06.2018 - 08.2021

IBM Cognos TM1 Developer

Jones Lang LaSalle
10.2016 - 06.2018

IBM Cognos BI and Planning Consultant

Creative (Lighthouse) Computing
05.2014 - 09.2016

IBM Cognos BI and Planning Consultant

Ironside Group
01.2013 - 04.2014

IBM Cognos BI and Planning Consultant

Newcomp Analytics
06.2006 - 12.2012

Bachelor of Science - Finance

Michigan State University
Chris Malone