Nicholas Ackerman Email & Phone Number

Boise, Idaho, US

Boise, Idaho, US

• Proactively developed automated workflows using advanced queries, Python, and VBA to structure customer data for A/B tests, update Snowflake database tables at scheduled intervals, and distribute project status emails.
• Supported C-Suite leadership by developing a financial incremental analysis process to evaluate the performance of customer segments on a quarterly basis and assist with financial projections for the digital business.
• Experimented using Random Forest machine learning classification and Recency Frequency Monetary Value (RFM) models in Python, to predict customer churn related to poor online order experiences.
• Utilized Python to build test scripts for validating accuracy of structured data from different cloud sources and identify the best fit combinations of data for experimental control groups.

Boise, Idaho, US

• Designed a multi-dimensional, data masking analytics tool in Python, SQL, and VBA to identify a specific audit occurrence in point-of-sale data that could not be located previously due to a lack in processing power
• Experimented with supervised classification machine learning using Python Scikit-Learn to assign predictions to quarterly audit lists and identify potential audit finds
• Developed R scripts to effectively clean/manipulate invoice data, locate lost audit information, and serve as testing platform to perform qualitative and quantitative analysis
• Expanded the use of a VBA software application to improve functionality for auditing/billing processes
• Collaborated extensively with various departments to remediate complex Access database connections from Lawson to Oracle Financial and outline the remediated process to project stakeholders
• Developed tools to automate the reporting process of audit recoveries for the PreAudit department by moving data to cloud (Snowflake) while improving report accuracy and efficiency

• Collaborated within a multi-disciplinary team to design and build a sophisticated machine that produces carbon fiber cylinders for stress testing
• Communicated project scope, schedule, system design specifications, and component level diagrams with Northrop Grumman Space Systems Staff Engineers
• Applied the Agile method to evaluate, microcontroller units, programming languages, and mechanical components to optimize the design
• Mitigated risks by conducting trade studies to select components that could withstand fluctuations in voltage, temperature, and mechanical loads
• Integrated Graphical User Interface (GUI) and configurable Python programs to control stepper motors
• Designed software and conducted hardware tests to verify functionality and accuracy of system components

• Analyzed raw data from the University campus shuttle and Tucson metropolitan transit systems with analytic tools to develop quarterly reports for directors
• Compiled budget information for interdepartmental programs and transit services to assess incoming revenues
• Created user-friendly interfaces by programming Visual Basic Macro-Enabled spreadsheets to automate data collection and minimize errors
• Performed formal requirements validation during development of a real-time pedestrian data analysis tools
• Compiled historical bicycle route data for alternate mode of transportation certifications
• Contributed to a Request for Proposal (RFP) by researching additional transit tracking systems and recommending system/software requirements to aid in future data collection