Data Engineer Science
Resume:
CANDIDATE SUMMARY
SNAPSHOT:
** ***** ********* & BI
8+ years Python
8+ years ETL
EXPERTISE:
DB’s: HANA, Oracle, SQL
ETL: BODS, SLT
Code: Python 2.7/3.5, SQL
Visualization: Tableau, Power BI, BOBJ
CERTIFICATIONS:
Applied Data Science
Scrum Alliance Scrum Master
Epic Caboodle
SAP HANA Associate 1.0
SAP HANA Associate 2.0
SAP Data Services 4.2
Snowflake Data warehousing
INDUSTRIES:
Healthcare
Oil and Gas
Patient Diagnostics
Manufacturing
Aerospace
EDUCATION:
Northern Kentucky University
MS Business Informatics
BS Business Administration
Dartmouth
Python for Applied Data Science
CAREER OVERVIEW
Senior Data Engineer with 12 years’ experience in SQL, Python, and ETL. Master’s degree in Business Informatics with seven post graduate certifications. Demonstratable experience along diverse business lines in both ERP and Non-ERP systems.
Provides subject matter expertise working with Business Users to elicit requirements. Drives technical solutions with consideration to an organization's architectural standards. Seeking the next challenge and growth opportunity both technically and interpersonally.
WORK EXPERIENCE
Data Engineer GE Aerospace (Gravity) Nov 2024 – May 2024
Python creds.sql & creds.bin for Redshift Query of Config DQ
Python func to cleanse & harmonize Saffron data
Regex patterns to extract engine models, part numbers, part serial numbers, module serial numbers, and serial id numbers from Service Bulletin XMLs
Regex patterns for serial number ranges “through, and up, begins with”
Python validation script to reconcile regex patterns
Mapped DMRO Application EWT/IST tables to Redshift
Scheduled table loads from Redshift to S3 Buckets
Batch ssh file for Bastion Redshift login with dbeaver
Familiar with Databricks delta live tables
Sr. Data Engineer Illumina (Via Tech) Nov 2023 – Mar 2024
Six-month remote contract, tasked to HANA enhancements and designing Functional Python scripts for reconciling Snowflake & SAP databases
Pandas, hdbcli, and snowflake.connector libraries
Table & View Definitions and Data reconciliation
Data Architect Deloitte (Solomon Page) Jan 2023 – Jun 2023
Six-month contract at Deloitte tasked with building the OGC Leadership Dashboard with Python and SQL backend infrastructure.
Python scripts for Invoices & Matters API, Graph API, & SEC RSS feeds
Normalizing JSON and nested data structures into csv flat files
BODS ETL job to pick up csv and load to HANA XSA
HANA XSA CDS views & tables and XSA calculation views
HANA XSA Scalar Function for Date lookups and Input Parameters
Analytical Privileges for view and row level access
Python f string formatting, list comprehension, exception handling, input parameters, conditional blocks
Data Engineer Reliance Corp July 2021 – Jan 2023
Lead Engineer driving delivery of data flows & ingestion of data models, while monitoring accuracy and quality. Translating functional and technical requirements into technical solutions.
Enhancements to BODS Data Flows, Workflows, Query Transforms
Transport routes and synced environments with Schema Mapping
Development of GL Star Schema for self-service reporting
Automated HANA XS Classic XSJS jobs and Stored Procedures
Configured SLT prod env to testing env to enable proper SDLC.
Sr IT Technical Specialist LabCorp Diagnostics Sept 2020 – April 2021
Full-time employment focused on the Covid-19 DataMart.
HANA Dimensional DataMart Models for Covid19 Tableau Dashboards
Native HANA Data Pipeline: A native SQL stored procedure which dynamically queries and replicates Production data down to Testing Environments through a virtual table connection. Scheduling in XS Classic
SRS Turn Around Time de normalized table; A native SQL stored procedure to transform and materialize a 3rd normalized table of 300M records for optimal query performance.
Pixel DataMart incorporation into HANA sidecar. (Kit Return Rate, Kits mailed, Kits Sent)
Certificate in Applied Data Science - Dartmouth June 2020 – Dec 2020
Six-month course on Python Data Science, emphasis on matplotlib, pandas, seaborn, scikit-learn. Gained experience with linear & logistic regression, A/B testing, k-means clustering, naïve bayes, and k-nearest neighbors. Final project analyzed the value proposition of the cryptocurrency Litecoin.
Sr. Data Engineer ExxonMobil (DISYS) Mar 2019 –June 2020
As a HANA SME for ExxonMobil supported the Data Sci & Measures team before joining as technical lead for XTO. I translated complex business requirements into actionable results withing Agile Framework.
●Database development expertise with Native HANA & SQL Server
●Master data views for Measures Team for MM, PM, QM modules including delta enablement
●Tableau Self-Service Dashboard Design and Visualization with live data connection
●SDI/SDA Virtual Table connections to Microsoft SQL Server for Cold Storage integration
●SLT ETL Replication of ECC Table
●Key deliverables: Income Statement OPEX RDC & Production Reserves Reporting
●Cutover and Gap Analysis of OLTP to OLAP S/4 CDS Views to HANA Side Car
●Stored Procedures, Flow Graphs, Triggers, Containers/Synonyms, and Table Function
●Proficiency in writing & reengineering advanced T-SQL, PL-SQL, SQL Script
Data Modeler BCM Feb 2016 –Mar 2019
HANA Lead at BCM. Implemented data warehouse architecture, standards, and development practices as well as ticketing and documentation duties. Implemented Meaningful Use reporting to meet EHR requirements set forth by Federal government. Developed the Daily Activity report for Providers on Design Studio. Designed the Baylor/Saint Lukes Hospitalist Report for Provider Utilization. Analytical Privileges for Providers, Admins, & Executives. A Python pipeline for Qgenda Room Scheduling from Rest API. Successfully implemented Caboodle and scheduled the jobs in Administrator. Connected Cogito and Slicer Dicer.
Software Engineer TCS July 2014-Feb 2016
As a member of TCS SAP CoE, achieved HANA certification in 2014, trained on BW, and the BOBJ suite. Demoed capabilities to clients, performed PoC assignments, and worked on two projects for Nielsen and CVS Caremark with regard to SLT and Native HANA
Contact this candidate