Business Intelligence Subject Matter
Resume:
Keith S. Theodore
Home: 610-***-****
Cell: 610-***-****
Kutztown, PA 19530
******@***.***
PROFESSIONAL SUMMARY
Experienced SAS programmer/analyst with proven ability to efficiently and accurately write and apply custom solutions to a wide range of statistical challenges. Able to use advanced problem-solving skills to work independently and adapt to rapidly-changing requirements, with an emphasis on efficiency and accuracy. Proven track record of maintaining subject matter expertise through training, speaking at conferences, and playing active roles in software users’ groups. Demonstrated ability for knowledge sharing with co-workers and professional colleagues. Strong design, manufacturing, quality, maintenance, reliability and healthcare experience.
EDUCATION
Penn State University, Fogelsville, PA 1979
Mechanical Technology
Allentown College (DeSales University), Coopersburg, PA 1990
Computer Science – Various courses in multiple programming languages, Data and File Structures and Statistics.
Digital Equipment Corporation Expert System Training Program (Artificial Intelligence).-Graduated 1989
Dale Carnegie Institute – Graduate 1986. Also served as Graduate Assistant.
SAS Institute
SAS Training at Cary, NC campus
Exploratory analysis for large complex problems
Predictive modeling using SAS Enterprise Miner
SAS Warranty Analysis Training
Querying and reporting using SAS Enterprise Guide
Mining textual data using SAS Text Miner for version 9
Advanced Predictive Modeling using SAS Enterprise Miner 5.1
Getting started with SAS Output Delivery System
Advanced SAS Output Delivery System
SAS Macro Language
Data Integration Studio
Business Intelligence with SAS
JMP Software Data Exploration.
ANOVA, Regression and Logistic Regression.
Visual Analytics
SAS Studio and Enterprise Guide.
Viya
SAS/SQL
Keith S. Theodore Page 2
Page 3
EXPERIENCE
Holman ARI, Mount Laurel, NJ 2022-2025
Analyst II Maintenance Analyst
Utilized Tableau, SAP Business Objects 4.3 and Power BI for analysis and visualization of data.
Penske Truck Leasing, Reading, PA 2020-2021
Associate 24-7 Call Center Maintenance Analyst
DataQuest, Harrisburg, PA (Contractor)
Reporting Engineer Capitol Blue 2019-2020
Developed apps for maintenance and reliability using R and R Studio. 2017-2019
SAS Institute, Inc. Cary, NC 2011-2017
Reliability Solutions Architect/Consultant Professional Services Division
Prototyped and demonstrated reliability solutions using JMP and SAS software (9.4 and Viya) to OEM and large fleets.
SAS Energy Forecasting.
Achievements:
• Forecasted parts usage based on reliability rates to optimize cost and inventory.
• Involvement with all phases of manufacturing solutions (Asset Performance Analytics, Failure Quality Analytics,
Part Quality Analytics, Event Stream Processing) and implementation.
• Deployed Asset Performance Analytics (Sensors/Faults/Repairs) with IoT data to predict optimal maintenance
intervals and predict repairs before faults or failures occur.
Highmark Medicare Services, Camp Hill, PA 2009-2011
Highmark is a licensed Medicare administrator for the CMM and the GAO.
Decision Support Consultant-Informatics
Reported to the Director of Medicare Analytics.
Specialized in fraud detection.
Used statistical methods such as Six Sigma and regression analysis to identify aberrant billing behaviors.
Achievements:
• Developed, implemented and maintained flu and vaccine reporting system using SAS.
• Created reports that met all requirements for the American Disabilities Act.
MACK TRUCKS, INC./VOLVO TRUCKS NORTH AMERICA, Allentown, PA 1977-2009
Senior Systems Programmer/Analyst
Developed, implemented and maintained a reliability information system using SAS, along with an extensive report library of Key Performance Indicators for many areas of the corporation. SAS development included Macro, Graph, QC, SQL, Stats and ODS to produce 147 reports generating nearly 2,500 pages of information.
Achievements:
Led a multi-national team to implement a group tool for measuring vehicle warranty information for engineering, manufacturing, sales and marketing that was customized for each discipline.
Created methods to support reporting for regulatory compliance to the EPA for emissions and the National Highway Traffic Safety Administration (NHTSA) for TREAD Act.
Established a reporting method and system for benchmarking our products vs. our competitors’ using SAS. Supported marketing Strengths, Threats, Opportunities, Weaknesses (S.T.O.W.) analysis.
Established and organized an internal SAS users’ group to provide other SAS users a forum for learning more about the software and its capabilities so that they could implement better and more effective processes.Improved accuracy of warranty claim coding from less than 50% to more than 90% by implementing a text-mining application using SAS Enterprise Miner and SAS Text Miner. The application instantly yielded efficiencies in reacting to problems without the need to manually read claims before action could be taken.
Keith S. Theodore Page 3
MACK TRUCKS, INC./VOLVO TRUCKS NORTH AMERICA (continued)
Quality/Reliability Engineer 1990-1994
Performed extensive quality audits and process audits for Mack/Volvo at manufacturing facilities in Pennsylvania, Maryland, South Carolina and Virginia.
Achievements:
• Created a Reliability Information System on the mainframe to direct engineering and manufacturing efforts based on quantitative and qualitative measures. The KPIs from this system are used for FMEA, MTTF, Weibull, and Root Cause analysis and additional testing.
• Developed a robust data warehouse of product, warranty, configuration and manufacturing that
became a significant resource for the organization.
Spearheaded an effort to reduce the cycle time by 95S% in updating business spreadsheets by utilizing the SAS Add-
in for Microsoft Office, SAS Web Report Studio and RStudio
Expert System Solutions Developer 1988-1990
Developed an expert system solution to the business problem of vehicle configuration using both forward and backward chaining object-oriented programming(AI).
Engineering Supervisor 1986-1988
Supervised up to nine designers and worked closely with engineers and manufacturing to deliver field problem solutions. Expedited component and engineering specifications and updates through corporate logistics. Worked extensively with build options and BOM and ECN.
Achievements:
• Used Basic programming language to determine the number of forgings to deal with Ackerman
error steering complaints.
• Built a dBaseIII application for tracking designers’ hours on projects and PTO time.
Designer/Draftsman 1977-1986
Designed numerous components and systems for new vehicle development and to comply with new emissions and safety requirements. Used GD&T to improve the manufacturing of vehicles and components.
PAPERS
“Ubiquitous Scoring of 1000+ Warranty Codes using Predictive Rules Derived from Text”, co-authored with Barry deVille (SAS). Publication presented at SAS Global Forum Orlando, FL 2007 and Midwest SAS users group Detroit, MI 2007.
Contact this candidate