Professional Experience Summary

For 5 years, Kit Forshee managed an outstanding team of data modelers/data engineers/data architects/.NET developers for Progress Rail, A Caterpillar Company. Using Profisee, our enterprise master data management application, we have provided solutions integrating with six (6) different ERP instances (SAP, Infor LN, MS D365, Dynamics AX) globally, along with other applications (Salesforce.com, Active Directory, PeopleSoft, Sage, K2, Orion, MS SCCM, custom applications) to centralize master data for maintenance to enable clean and accurate reporting via Cognos BI, IBM Cognos TM1, MS Power BI, and MS Excel.

We have developed integrations using Microsoft Visual Studio SQL Server Integration Services (SSIS) to migrate data to/from MS SQL and Oracle databases, as well as proprietary databases and flat files. We have automated everything to extract, transform, and load (ETL) on various frequencies using Windows Batch Files executed by Windows Task Scheduler.

We have developed custom workflows to facilitate real-time notifications, approvals, and bi-directional synchronization of data.

Kit also developed an IBM Cognos TM1 model bringing in inventory data (items, on-hand quantities, demand, historical consumption) from all 6 ERP instances in order to provide weekly global reporting to buyers/planners/material managers to reduce excess inventory, saving 10s of millions of dollars over 5 years.

Skills History

For 7 years, from 2011-2018, Kit was a Managing Consultant for Profisee. He has focused 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)
• 22 Years: IBM Cognos TM1 (Installing/configuring, developing models with cubes, dimensions, attributes, rules, TurboIntegrator (TI) processes, and TM1Web)
• 21 Years: SQL (Microsoft SQL, IBM DB2, and Oracle)
• 11 Years: Microsoft SQL Master Data Services (MDS)
• 11 Years: Profisee Master Data Management
• 3 Years: Microsoft Power BI

Employment History

• May 2018 - Present: Progress Rail, A Caterpillar Company (Business Intelligence Manager)
• February 2002 - December 2012: Cumulus Media (99X/Q100 Atlanta)
• 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 implementing an enterprise-wide global Master Data Management solution for Ernst & Young.
• Built master data management proof-of-concept solutions for Fortune 1000 clients.
• Conducted Master Data Services and Profisee training for many Fortune 1000 companies.
• 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.
• Developed an Extraction, Transformation, & Loading (ETL) tool that collects and allocates billions of dollars of marketing expenses to over 300 brands and beverage products from various systems and data structures for The Coca-Cola Company. This data was then manipulated to load monthly during the closing process into SAP BPC for forecasting and planning.
• 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.
• Kit designed and developed a corporate online general ledger querying system using HTML, Javascript, VBScript, Active Server Pages (ASP), Microsoft SQL, and IBM DB2 for SunTrust Bank (now Truist). This system was in use for almost 20 years with little modification.