Andrew Rittle
Huntersville,NC
Summary
Experienced and enthusiastic data engineering consultant with track record of success across a wide range of industries. Possesses exceptional interpersonal, problem-solving and analytical skills to provide advice, expertise and servant leadership to client organizations improving business performance and operations. Passionate about leveraging the latest technology trends to design and develop exciting and effective products.
Overview
12
12
years of professional experience
Work History
Data and Analytics Consultant
CapTech
02.2019 - Current
- Assisted in development of Azure Enterprise Data Warehouse for major Oil and Gas Company
- Implemented Azure Durable Function to extract data from external data via API calls
- Migrated various tables and views from Azure SQL Server to Azure Snowflake
- Designed predictive analytics prototype for large manufacturing company that estimated fulfillment times for all their products to help give customers accurate delivery dates on orders
- Lead design effort of tableau-driven dashboard that monitored near real-time banking data
- Utilized agile methodology framework in all projects
Independent Data Engineer Contractor
BI Solutions, Inc
06.2021 - Current
- Lead the design and implementation effort to build PowerBI Reports for a mid-size staffing agency
- Architected a star-schema-driven EDW model for a government servicing agency, including a data ingestion framework
- Created a python script to dynamically convert a JSON document to relational format
BI Integration Developer
Penn State Health
08.2018 - 02.2019
- Assisted in the implementation of the Oracle Healthcare Foundation (OHF) Data Warehouse
- Trained co workers in the transition from IBM Data Stage to Informatica PowerCenter as the main ETL tool
- Designed and debugged multiple Informatica ETL workflows
Data Warehouse Developer Consultant
BI Solutions, Inc
06.2012 - 08.2018
- Lead the design effort on the back-end architecture of Enterprise Data Warehouse for U.S Navy to support reporting of Maritime Supply Metrics, Demand, Forecasting
- Employed knowledge of data transformations (ETL) to ingest large scale volumes of data from disparate sources using Informatica PowerCenter
- Communicated with customers throughout project development lifecycle to ensure expectations and requirements were met in timely fashion
Education
Bachelor of Science - Computer Engineering
Pennsylvania State University
University Park, PA05.2012
Skills
- SQL Architecture (Azure SQL Server/Synapse, Snowflake, Oracle)
- Programming (PL/SQL, T-SQL, Python)
- ETL Tools: Azure Data Factory, Informatica
- Star-Schema Database Architecture/Design
- Azure DevOps: Pipelines, Releases, CI/CD
- Predictive Analytics
- Data Analysis
- Unix Scripting
- MongoDB Certified (2020)
Timeline
Independent Data Engineer Contractor
BI Solutions, Inc
06.2021 - Current
Data and Analytics Consultant
CapTech
02.2019 - Current
BI Integration Developer
Penn State Health
08.2018 - 02.2019
Data Warehouse Developer Consultant
BI Solutions, Inc
06.2012 - 08.2018
Bachelor of Science - Computer Engineering
Pennsylvania State University
Similar Profiles
Lisa JacksonLisa Jackson
Senior Manager of Change Acceleration at CapTechSenior Manager of Change Acceleration at CapTech
Emmanuel Onwulata D.Sc.Emmanuel Onwulata D.Sc.
Adjunct Instructor at Capitol Technology University, CAPTECHAdjunct Instructor at Capitol Technology University, CAPTECH
John Grosso IVJohn Grosso IV
Salesman at Cosmos GraniteSalesman at Cosmos Granite