Derek Ramsay Email & Phone Number

Plano, Texas, United States

Dallas, Texas, United States

• Leading the digital transformation effort for the operations organization across three Texas factories
• Working with management to establish KPIs and implement robust data solutions that provide current and pastperformance including a performance/efficiency dashboard that will be used across the business unit
• Engaging various stakeholders to understand business requirements and create tailored analytics solutions
• Developing multiple end-to-end solutions for various operations stakeholders; pulling data from SAP sources, creating ETL procedures, and building Tableau dashboards for analyst to executive level management
• Supporting the transition from disparate-patchworked solutions to a centralized datalake and content-hub thathosts both custom web solutions and existing BI dashboards

St Louis, Missouri, United States

• Supported a variety of clients across multiple domains, including supply chain, corporate services, and e-commerce
• Successfully project managed the development of a comprehensive and fully automated BI solution for Board of Directors/C-suite executives utilizing ETL procedures in Python and Tableau
• Developed production and ad-hoc dashboards for the Boeing Supply Chain organization to help support 737 Return to Service, COVID supplier response, and defense part shortage problems
• Implemented a custom and fully automated data-fed solution, built on a Postgres database and Python ‘Dash’ frontend, for the telemetry team, which allowed for near-real-time and historical analysis of satellite data
• Designed and deployed BI solutions for the e-commerce team, providing technical solutions to help expand capabilities and measure performance of various channels & campaigns using Adobe Analytics, Tableau, and SQL

Dallas/Fort Worth Area

• Conducted statistical & risk management, sensitivity, life-cycle cost, cost performance, and business case analyses
• Led database administration and internal tech support for the performance and decision analytics modeling team
• Managed the modeling efforts for multiple performance based contracts, establishing KPIs, benchmarks, and risk negation
• Trained eight people on our team of twelve helping to create a knowledgeable and prepared team capable of addressing the challenges of the F-35 program using a variety of standard and niche software packages
• Streamlined the modeling team’s primary toolset, using Python & pandas, which reduced modeling time from several weeks to a few hours; introduced data visualization methods and processes to improve data comprehension.
• Coordinated annualized contract modeling totaling 400MM, which is the primary input for the fleet’s annual procured spares

Fort Worth, TX

• Baselined and maintained projects totaling 30 aircraft and 450 MM
• Manufacturing lead in Integrated Baseline Review of 400 MM project
• Provided manufacturing project status and forecast completion dates
• Analyzed, calculated, and time phased project’s manufacturing estimate to completion
• Examined program metrics, manufacturing efficiencies, manpower distribution, and cost/schedule variance

College Station, Texas, United States

• Project lead on five member team that developed a scheduling tool for the Texas A&M Industrial Engineering Department
• Built an all inclusive tool that used a binary integer algorithm to determine a feasible schedule based on professor preferences
• Oversaw comprehensive project for full project life cycle

Fort Worth, TX

Gained valuable insight into an advanced project management system; developing, maintaining, and completing risk assessments on project and program level schedules

College Station, TX