SHAUN MARPLE
Data Engineer
East Hampton,CT
Summary
Dynamic Data Engineer devoted to maintaining reliable computer systems for uninterrupted workflows. Delivers up-to-date methods to increase database stability and lower likelihood of data corruption. Offers detailed training and reference materials to teach best practices for system navigation and minor troubleshooting. Provides high level of detail in development processes so that management will know how the process is going and if any blockers arise, so they can be addressed and agile sprints will continue to move forward.
Overview
18
18
years of professional experience
14
14
years of post-secondary education
Work History
Data Engineer & IT Project Manager
Pratt & Whitney
East Hartford, CT
05.2018 - Current
- Designed, tested, collaborated, and deployed code via CI/CD pipelines over bi-weekly sprints.
- API development using AWS SAM.
- Project Management on the 2020-2021 streamlined version of the F135 Sustainment Affordability Model SDLC.
- Automation with Python, SQL, VBA.
- Data modeling using Python and QLIK.
- Wrote ETL scripts on complex Excel documents, databases, and non-server based platforms using Python and SQL.
- Designed Data Marts in Oracle and PostgreSQL for pipelined ETL data and dashboard development in QLIK.
- Data validation between Hadoop and Oracle databases using SQL, Ambari, and HIVE.
- Authored clear and concise work step instructions for technologies delivered.
- Developed polished visualizations to share results of data analyses in QLIK and Python.
Data Engineer, Data Analyst, and Project Manager
Pratt & Whitney, Universal Staffing
East Hartford, CT
10.2016 - 05.2018
- Leveraged Python to wade through large amounts of unstructured data.
- Extracted data from thousands of folders and zip files from various formats, including XML, Hexadecimal, log files, zip files, and databases.
- Built reports, using Python, VBA, and advanced Excel formula logic.
- Designed, developed, and implemented new data interim tools, complete with SOW documentation, to speed up Data Mining and troubleshooting ALIS.
- Redesigned and reprogramed old Access databases using VBA and SQL.
- Wrote programs in Python, VBA, and Advanced Excel Logic Ad Hoc for brute force analyses when time is of the essence.
- Managed projects that implemented additional interim tools.
- Developed tables, views and materialized views using SQL.
- Transformed project data requirements into project data models.
- Updated organizational systems and subsystems to improve and streamline data collection.
- Designed and developed schema data models.
Senior Data Analyst, Statistician
Duracell Research and Development
Bethel, CT
08.2014 - 10.2016
- Statistical modeling, data mining, automation with SAS JMP, Python, and R.
- Data cleansing, processing, and validation using SAS JMP and VBA.
- Agile database design, development, and implementation using Access, SQL, and VBA.
- Wrote ETL scripts to pull data from multiple sources using VBA.
- Created tools to compare competitive metrics across brands
- Developed automated data analysis reporting tools for multi-categorical analysis.
- Prepared statistical performance reports and wrote custom programs for multiple personnel across R&D.
- Worked on cross-functional teams to maximize report development
- Leveraged text, charts and graphs to communicate findings in understandable format.
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
- Developed integrated spreadsheet and database templates for accumulating, formatting and organizing program data and presented findings to management.
- Created and automated data visualizations to present insights and tell compelling stories.
- Conducted quality checks on data sources to check for inconsistencies and perform data cleaning activities.
- Developed data tables and databases to create relation between tables to allow efficient data retrieval.
- Manipulated, transformed and analyzed data by reviewing computer reports, printouts and performance indicators.
- Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
Machine Operator
Carlyle Johnson Machine Company
Bolton, CT
11.2008 - 01.2012
- Tool Setter and Quality Assurance, Raw Material Receiving and Distribution.
- Followed tooling instructions and product specifications to determine and implement operational sequences.
- Calibrated, tested, and adjusted machine settings or controls in preparation for production operations.
- Assessed equipment after each production run and performed preventive maintenance to keep machines running smoothly.
Combat Engineer, Specialist
CT/VA Army National Guard
01.1999 - 01.2007
Education
Master of Science - Computer Information Systems
Boston University
Boston, MA 01.2019 - 01.2021
Bachelor of Arts - Mathematics, Statistics
Central Connecticut State University
New Britain, CT 01.2011 - 01.2013
Associate of Arts - General Studies
Manchester Community College
01.2000 - 01.2010
Skills
TSQL
Python
PySpark
Microsoft Excel, Access, PowerPoint
JavaScript
SAS JMP, SAS JSL
QLIK Sense
R
HTML
CSS
VBA
HIVE
Scala
Google DataProc
PLSQL
Machine Learning
Accomplishments
- Performance Award 2020
- Performance Award 2019
- Designed, developed, and implemented a database that kept up-to-date information for brand metrics performances, chemistries, and outliers for Duracell R & D. This type of cleaned data storage wasn't available initially. After the need was identified, the development began. The database went global in just under a year. 2016
Timeline
Master of Science - Computer Information Systems
Boston University
01.2019 - 01.2021
Data Engineer & IT Project Manager
Pratt & Whitney
05.2018 - Current
Data Engineer, Data Analyst, and Project Manager
Pratt & Whitney, Universal Staffing
10.2016 - 05.2018
Senior Data Analyst, Statistician
Duracell Research and Development
08.2014 - 10.2016
Bachelor of Arts - Mathematics, Statistics
Central Connecticut State University
01.2011 - 01.2013
Machine Operator
Carlyle Johnson Machine Company
11.2008 - 01.2012
Associate of Arts - General Studies
Manchester Community College
01.2000 - 01.2010
Combat Engineer, Specialist
CT/VA Army National Guard
01.1999 - 01.2007