Adam Olsen
Sparks
Summary
Results-focused data professional equipped for impactful contributions. Expertise in designing, building, and optimizing complex data pipelines and ETL processes. Strong in SQL, Python, and cloud platforms, ensuring seamless data integration and robust data solutions. Known for excelling in collaborative environments, adapting swiftly to evolving needs, and driving team success.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Sr Principal Data Engineer
Northrop Grumman
06.2022 - Current
- Developed ETL pipeline from DOORS utilizing DXL, SSIS and Tableau/Tableau Server to generate metrics for Systems Engineers that led to cost savings over10k per quarter
- Built ETL pipeline utilizing SSIS, Python and Jenkins and created dashboards utilizing SAP S4 and JIRA data to provide insight of projects and global supply chain metrics visualized in Tableau to lower supply chain costs by over 20k per year
- Utilized complex SQL queries via linked servers, Alteryx and Denodo to develop ETL pipeline for staffing data and generate metrics used for contract awards fees and are presented to the government customer monthly
- Managed large-scale projects from inception to completion, ensuring adherence to budget constraints and timeline requirements.
- Implemented data-driven decision-making processes to enhance overall business performance and profitability.
Principal Data Scientist
Northrop Grumman
06.2020 - 02.2022
- Analyzed and processed large volumes of SAP data to support decision-making for government contracts, utilizing data cleaning, transformation, and advanced analytics techniques to provide actionable insights and optimize operational efficiency
- Created interactive dashboards to support data-driven decision-making.
- Conducted deep-dive data analysis with Python, improving accuracy and reliability of data by 25%.
- Developed data visualizations with Tableau for clear, impactful reporting.
Modeling/Simulation Engineer
Northrop Grumman
04.2019 - 06.2020
- Created mod/sim analysis for multiple satellite programs using C#, Python, AFSIM, STK which led to award wins for multiple programs
- Evaluated emerging technologies in the field of simulations to stay ahead of industry trends and maintain a competitive edge.
- Managed resources effectively, ensuring timely completion of projects without compromising quality or exceeding budgets.
- Automated repetitive tasks through scripting, increasing efficiency and reducing human error.
- Developed custom simulation tools for enhanced analysis capabilities and streamlined workflows.
MATLAB Engineer
DHPC Technologies
06.2018 - 04.2019
- Assisted in development of new logging structures for data utilizing JSON files which increased productivity by over10%
- Improved system performance by analyzing and optimizing engineering processes.
- Designed custom analysis scripts using programming languages like Python or MATLAB when commercial software was insufficient for specific project needs.
HHC Commander,422d Expeditionary Signal Battalion-Enhanced
Nevada Army National Guard
12.2013 - 04.2023
- Managed100+ Soldiers Training and Administrative actions resulting in100% training completed and administrative compliance
- Worked effectively in fast-paced environments.
- Mentored junior officers and enlisted personnel, contributing to their professional growth and career progression.
- Served as an ambassador for the organization during community outreach events, strengthening relationships with local stakeholders and enhancing public understanding of military missions.
- Balanced competing priorities effectively while managing multiple projects simultaneously under tight deadlines.
TDL Analyst
Future Technologies Inc.
06.2017 - 06.2018
- Provide tactical data link technical systems engineering services and test support as required by the prime contractor in support of all AEGIS baseline development efforts resulting in100% mission success
Communication Engineer
AECOM
11.2015 - 08.2016
- Lead Engineer involved in the design, development and testing of specialized telecommunications equipment and systems worth over1MM dollars for the Fallon Tactical Training Range (TOPGUN)
- Optimized signal transmission by utilizing cutting-edge technology in the design of antenna systems.
- Collaborated with cross-functional teams to ensure seamless integration of communication systems in large-scale projects.
Education
Master of Business and Science - Analytics and Data Science
Rutgers University
New Brunswick, NJ06.2019
B.S. - Physics
University of Nevada, Reno
Reno, NV05.2015
Skills
- Tableau
- Alteryx
- Tableau Prep
- Tableau Server Admin
- Python
- SQL
- R
- SSIS
- Denodo
- Project Management
- Communication
- Databricks
- Snowflake
- Azure
- SSBI w/ CI Poly
- Python programming
- SQL databases
- Statistical analysis
- ETL development
- Data warehousing
- Data pipeline design
- Data modeling
Certification
- Agile Project Management, CALTECH AUG2021
Timeline
Sr Principal Data Engineer
Northrop Grumman
06.2022 - Current
Principal Data Scientist
Northrop Grumman
06.2020 - 02.2022
Modeling/Simulation Engineer
Northrop Grumman
04.2019 - 06.2020
MATLAB Engineer
DHPC Technologies
06.2018 - 04.2019
TDL Analyst
Future Technologies Inc.
06.2017 - 06.2018
Communication Engineer
AECOM
11.2015 - 08.2016
HHC Commander,422d Expeditionary Signal Battalion-Enhanced
Nevada Army National Guard
12.2013 - 04.2023
Master of Business and Science - Analytics and Data Science
Rutgers University
B.S. - Physics
University of Nevada, Reno