Professional Experience Summary

Kit Forshee is currently an independent contractor specializing in IBM Cognos TM1 solutions.

For 5 years, Kit Forshee managed an outstanding team of data modelers/data architects/data engineers/developers for Progress Rail, A Caterpillar Company.

Among many other projects, he developed a TM1 model that integrated with 6 different ERP instances globally (SAP, Info LN, AX, D365) to bring all inventory demand and on-hand quantities to assist buyers/planners/material managers in reducing global inventory levels by millions of dollars per month. He developed a Cognos BI report that was automatically emailed weekly to all buyers/planners/material managers globally that showed each location, that respecive locations excess inventory and the top 3 locations with demand for that material. He also developed a Cognos BI report that was automatically emailed weekly to all buyers/planners/material managers globally that showed each location, that respecive locations demand for materials and the top 3 locations with excess/obsolete material.

Skills History

For 5 years, from 2018-2023, Kit was a Business Intelligence Manager developing and maintaining IBM Cognos TM1 models to produce actionable reporting to aid in the reduction of excess and obsolete inventory for Progress Rail, A Caterpillar Company.

For 11 years, from 2007-2018, Kit was a Managing Consultant focusing his strong technical and accounting skills and experience on assisting clients in developing solutions using IBM Cognos TM1.

• 25 Years: Web Development (HTML, Active Server Pages (ASP), VBScript, and JavaScript)
• 23 Years: IBM Cognos TM1 (Installing/configuring, developing models with cubes, dimensions, attributes, rules, TurboIntegrator (TI) processes, and TM1Web)
• 22 Years: SQL (Microsoft SQL, IBM DB2, and Oracle)
• 12 Years: Microsoft SQL Master Data Services (MDS)
• 12 Years: Profisee Master Data Management
• 3 Years: Microsoft Power BI

Timeline

• May 2018 - Present: Progress Rail, A Caterpillar Company (Business Intelligence Manager)
• November 2011 - May 2018 Profisee (MDM & TM1 Managing Consultant)
• April 2011 - November 2011: Ernst & Young (Performance Improvement Manager/TM1 Consultant)
• November 2008 - April 2011: ISA Consulting (TM1 Consultant)
• March 2007 - November 2008: TNT Technologies (TM1, SAP BPC, Tagetik CPM Consultant)
• May 1999 - March 2007: SunTrust Bank (Financial Analyst)

Engagement Experience

• Aided in the facilitation of the forecast model in TM1 Lowes.
• Developed and assisted in the implementation of a TM1 model to disseminate mapping data for multiple ERP systems for a subsidiary of Caterpillar.
• Developed a TM1 model used for sales, operating expenses, and inventory demand planning for Eagle Rock Distributing Company.
• Developed and assisted in the implementation of an operating expense model, a capital expenditures model, a revenue model, and a position control workforce planning model with salary savings analysis reporting utilizing TM1 for Millersville University in Pennsylvania with multiple bargaining units.
• Assisted in migrating from Oracle general ledger system to SAP for EMD Serono, a Merck KGaA company, using TM1 to supplement reporting needs out of SAP.
• Developed a TM1 Foreign Exchange model for Simulia Dassault Systemes, an engineering simulation software computer aided engineering (CAE) vendor.
• Assisted in developing several TM1 reporting models with drill-through capabilities using SAP as a data source via Cognos Data Manager for Axcan Pharma, a large privately-held, specialty pharmaceutical company.
• Proctored several TM1 workshops in major cities along the eastern coast of the United States in early 2009.
• Presented the new features of TM1 9.4 live at the 2009 IBM Cognos Forum.
• Developed a TM1 planning and forecasting model for MetLife Insurance Company. Developed processes to load data from legacy budgeting and planning tool (Khalix) into TM1 for analysis. Developed templates and reports for users to analyze and input data monthly.
• Assisted in implementing budgeting, forecasting, and reporting solutions using Tagetik CPM for Menarini Group, the first Italian pharmaceutical company in Europe on site in Paris, France and Lucca, Italy.
• Assisted with maintenance, support and development of TM1 models and reporting for SunTrust Bank (now Truist) for eight years.