Randy Darnowsky

Experience

• 

  Naval Air Systems Command (NAVAIR)

  Jul 2011 - Feb 2017

  Industrial Engineer

  Data analysis and programming in R language and VBA, database analysis in MS Access, MS SQL Server and IBM Cognos, enterprise architecture and DoDAF, stochastic discrete-event simulation with ExtendSimGraduated Navy Acquisition Development Program (NADP); DAU DAWIA training Level II• Performed rigorous data analysis and trend-analysis of Navy depot core logistics using a combination of SAP Business Object software and SQL programming in MS Access, performed statistical data analysis using Minitab & MATLAB, developed macros in VBA programming language to automate ETL processes and analyzed data downloaded from IBM Cognos and MS SQL Server • Analyzed AutoCAD facility layouts, validated statistical models of warehouse capacity and maintenance cycle-time, compute data-series trends and forecasting models from time-interval data, used MS Project to perform Earned Value Management (EVM) and derive optimal schedules with maximum expected throughput and minimal turn-around-times (TAT’s) with respect to cost and resource constraints• Designed enterprise architecture models per Navy system engineering processes using IBM Jazz software, verified Department of Defense Architecture Framework (DoDAF) models in XML language using the combination of IBM Rational Architect, SPARX Enterprise Architecture and NoMagic’s MagicDraw, and wrote a user instruction manual for applying DoDAF and EA for the Naval Aviation (NAVAIR) department of DON• Analyzed the Level of Repair Analysis (LORA) process for the RQ-21 Blackjack/STUAS unmanned system, provided logistics support, modeled process improvement concepts using MS Visio and ExtendSim simulation software and reversed-engineered the COMPASS program using "black-box" systems engineering and linear programming optimization with Excel VBA macros and an open-source library called “lp_solve”• Recognized for invention “PAX-186” for rigorous algorithms for performing the LORA process using the COMPASS software and improving the software Show less

• 

  Brand Energy & Infrastructure Services

  Jun 2017 - Dec 2017

  Quality Engineer

  Facilitated and recorded QC/QA checks for quality of construction services and installation of industrial insulation• Provided weekly updates of the progress of completing quality inspections of industrial insulation in support of Kiewit Construction services and Dominion Energy’s expansion of the Cove Point LNG plant• Tallied a variety of metrics in Excel spreadsheets to track the progress of various construction services at Cove Point in the turnover efforts between Brand, Kiewit Construction and Dominion Energy • Utilized and reviewed project files in Autodesk NAVISWORKS to validate construction documents and track completion status of construction services • Utilized Microsoft SharePoint to gather and distribute documents to analyze Requests for Information (RFI) to validate and verify the accuracy of construction processes based on industrial insulation ASTM standards and isometric drawings developed by IHIK design engineering Show less

• 

  Integrated Electrical Technologies Corporation (IET Corporation)

  May 2018 - May 2018

  Business Process Engineer Consultant (1099 Contractor)

  Hired by IET Corporation as an independent, 1099 contractor in order to provide consultation and in-house support in the role of business improvement and related engineering support.Due to the nature of the organization as a specialized construction company, I was asked to produce an Excel-based scheduling application for better understanding the needs of the business, scheduling priorities of laborers and artisan craft personnel and assisting with the organization of arranging daily and monthly assignments of resources (i.e. people) with project work.Daily tasks involved the following:1) Engagement and interaction with Program Managers in order to solicit a better understanding of the organization's needs2) Computer programming in Visual Basic Applications (VBA) in Microsoft Excel3) Organizing an Excel-based product by inputting Excel formulas, designing data validation procedures, rearranging the layout of graphs and tables, and responsible for developing VBA code for ActiveX control-formsIn addition, I was solely responsible for developing and creating a brand-new Excel-based application as part of delivering customized solutions and recommendations for demonstrating an efficient process for assigning staffed employees Show less

• 

  Broaddus & Associates

  Dec 2018 - Jul 2019

  Data Analyst

  Worked with Deloitte in support of the Department of Veteran affairs for providing data trends, data analysis and metric reports regarding the project health of major construction projects for the efforts of delivering healthcare facilities for US veterans; utilized Tableau, VBA for Excel, Python, Microsoft SQL Server, Microsoft InfoPath and Microsoft SharePoint 2016• Supported the Department of Veteran Affairs (VA) with data trends, data analysis and metric reports regarding the project health of major construction projects for the efforts of delivering healthcare facilities for US veterans • Reviewed and presented dashboard reporting of the cost, schedule and scope for construction project contracts in acquisition, design and construction stages • Analyzed project health status data through a combination of using Microsoft SQL Server for database management, Tableau Desktop for developing dashboard charts and Tableau Online for publishing dashboards • Improved the delivery of data reports using Visual Basics Applications (VBA) and Python programming language for automating data collection processes, developed SQL scripts with Microsoft SQL Server for querying cost and schedule data, and created Microsoft InfoPath forms for standardizing the collection of qualitative information Show less

• 

  KIHOMAC

  Jul 2019 - Feb 2021

  Senior Industrial Engineer

  Senior Industrial Engineer and Lead Modeling and Simulation Engineer for Naval Aviation logistics. Responsible for development and design of discrete-event simulation modeling using Matlab and Simulink and building analysis tools. Performed project management tasks and mentored junior engineers and analysts.• Supported the Department of Navy with discrete-event modeling and simulation in MATLAB and Simulink to improve the logistics and production capacity of aviation equipment• Technical team leader for modeling and simulation efforts while managing and actively participating in software development efforts in MATLAB and Simulink and presenting the status of modeling and simulation development to the client• Guided entry-level engineers on methodologies for implementing discrete-event simulation and data analysis in MATLAB• Developed queries in Microsoft SQL Server Management Studio and MATLAB code for using large datasets Show less

• 

  Abat North America

  Feb 2021 - Sept 2021

  Data Analyst

  Data analyst and consultant for Mercedes-Benz (MBUSI)‘s Finance and Controlling department. Responsible for data reports using Excel, Access, Hyperion and MS Power BI• Supported the Finance and Central Controlling department of MBUSI by performing Extract-Transform-Load (ETL) of production and personnel data• Reported the plant’s Hours Per Vehicle (HPV) into monthly KPI reports for upper management using MS Access, MS Excel, and MS Power BI• Used SAP for managing the efficient administration of purchase orders and invoices for financial cost-center controllers Show less

• 

  Daifuku Intralogistics America

  Sept 2021 - Nov 2022

  Senior Simulation Engineer

  • Developed simulation models of the control logic, equipment layout and system proof-of-concept for installing automation equipment using JavaScript programming language in Sym3 software and reading AutoCAD layouts• Tested and analyzed simulation models of automation equipment for pre-sales proposals and post-sales analysis• Cleansed and analyzed sensitive data using MS SQL and Excel for importing into simulation projects• Presented simulation analysis and experiment results to senior management and engineering teams Show less

• 

  GXO Logistics, Inc.

  Nov 2022 - now

  Senior Industrial Automation Engineer

  • Developing pricing models for warehouse design solutions by identifying facility requirements, labor activity levels and necessary material handling, IT, and automation equipment• Analyzing inventory, storage and order data using MS Power BI for determining warehouse design requirements• Preparing engineering calculations and documents for presenting the solution to potential clients• Performing data analysis and analyzing requirements for developing detailed designs and implementing solutions Show less