Warehouse Engineer Data Architect

Taylor Russell

Senior Analytics Consultant

**** *. **** ****** ***, Houston, TX 77030

CANDIDATE SUMMARY

CAREER OVERVIEW

SNAPSHOT:

~10 years Analytics & BI

9+ years Database modelling

8+ years Front End

7+ years Python

6+ years ETL

EXPERTISE:

RDMS: HANA, Oracle, SQL Serv

ETL: BODS, SLT

Languages: Python 2.7/3.5, SQL

Front End: Tableau, Power BI, BOBJ

CERTIFICATIONS:

Applied Data Science

Scrum Alliance Scrum Master

Epic Caboodle

SAP HANA App. Associate 142

SAP HANA App. Associate SPS6

SAP Data Services 4.2

Snowflake Data warehousing

INDUSTRIES:

Healthcare

Oil and Gas

Patient Diagnostics

Manufacturing

EDUCATION:

Northern Kentucky University

MS Business Informatics

BS Business Administration

Dartmouth

Applied Data Science

Experienced Data Warehouse Engineer with 10+ years’ experience building end to end analytic solutions across ERP & non-ERP systems, along with diverse business lines.

Provides subject matter expertise, while working with Business Users and Analysts to elicit requirements and drive technical solutions which align to an organization's architectural standards.

Proven expertise in Data Engineering, ETL, and Python. Master’s degree in Business Informatics, Dartmouth Certificate in Data Science with Python.

Seeking the next challenge and growth opportunity to make a positive impact, utilizing my strong interpersonal and communication skills.

References and GitHub available upon request

Work Experience

Deloitte, Cincinnati (Jan 2023 - present)

Data Architect

Six-month contract at Deloitte tasked with building the OGC Leadership Dashboard with Python and SQL backend infrastructure.

13 Python Functions for Counsel Link Rest API for Invoices and Matters

Python scripts for Graph API email data

Encryption and masking of Rest API Access Key

Python functions to ingest SEC RSS feed

Regression Testing scripts for new enhancements and integrations

Normalizing JSON and nested data structures into csv flat files

BODS ETL job to pick up csv and load to HANA

HANA CDS tables and calculation views

HANA Scalar Function for Date lookups and Input Parameters

Database security for view and row level access

Python f string formatting, list comprehension, exception handling, input parameters, conditional blocks

Reliance Worldwide Corporation, Remote (July 2021 – Jan 2023)

BODS/HANA Developer

Primary data engineering resource driving development, delivery, and operations of our data warehousing and reporting. Orchestrating data flows and data ingestion for data models, while monitoring accuracy and data quality of continuous development and integration efforts.

Translating complex functional and technical requirements for TrueCommerce Netalogue into backend SQL Server T-SQL views of ECC data for ecommerce B2B site (Orders, Addresses, Customers, Products)

within an agile methodology and presenting technical information to executive leadership

Enhancements for existing BODS Data Flows, Work Flows, Query Transforms for Open Orders, Sales Orders, and Purchase Orders

Participated in Architectural discussions for upcoming migration of ECC to S/4 cutover with mindset towards Datawarehouse implications and gap analysis, as-is and to-be states.

HANA XSA Web IDE implementation & migration; Execution of XSA Migration Assistant, GitHub accounts, and development of User Provided Services and Roles for remote schema access, Synonyms, grants, roles, & resource configuration

Conducted rapid prototyping and harmonizing of new vendor acquisitions to deliver insights to finance leadership while conforming to set enterprise standards (Daily Sales reports)

On-going support/enhancements of BODS ETL/ELT Jobs and Work Flows & reverse engineering in favor of real-time SLT trigger-based replication and native SQL modelling

Bug fixes and enhancements to existing Data Flows and Data Pipelines to enable proper change data capture servicing Universe models (Sales Orders, Billing Orders, Delivery)

Accounted for schema discrepancies between Development and Production environments with Schema Mapping and Synonyms, to enable transport routes and proper Software Development Lifecycle

Development of a Finance General Ledger Star Schema for End-User self-service reporting

Automated execution and scheduling of HANA XS Classic native jobs and Stored Procedures

SLT real-time ETL, configuration and mapping of ECC production systems to testing environments to enable internal validation and performance checks as well as End-User validation

LabCorp Diagnostics, Remote (Sept 2020 – April 2021)

Sr IT Technical Specialist

Sr HANA resource focused on Covid19 DataMart. Designed a custom procedure with virtual connections to sync environments for better quality testing.

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 done in XSC with XS Javascript file

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)

Independent Study

Fast-paced six-month course with entrance exam. Focusing on matplotlib, pandas, seaborn, scikit-learn, gained experience with linear and 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. Independent assignment seeking undervalued Real Estate properties using the Zillow API.

EXXONMOBIL Woodlands, TX (Mar 2019 –June 2020)

HANA SME - Data Sci & Analytics

As a consultant for DISYS I worked on-site for ExxonMobil supporting the Data Sci & Analytics team. I worked for the Measures team before joining as technical lead for newly acquired XTO. Work ended from Covid 19.

●Azure Cloud Data Factory linked service to HANA Data Models and Data Science efforts

●Database development expertise with Native HANA & SQL Server

●Collaborative self-starter with multiple teams and translating complex business requirements into actionable and scalable Developments within an Agile Framework

●Integration and familiarity with version control within Git/GitHub and CI/CD

●S4/HANA Master data views for Measures Team of SAP Modules MM, PM, QM including delta enablement features for Slowly Changing Dimensions

●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, SQLScript

BCM Houston, TX (Feb 2016 –Mar 2019)

HANA Data Modeler

BCM HANA lead for three business segments: clinical, research, and academic. Maintained cohesive data warehouse architecture, naming conventions, and development practices as well as CDM and PDM documentation.

●Meaningful User reporting to meet EHR requirements set forth by Federal government

●Provider Daily Activity mobile dashboard on Design Studio.

●BSLMC Hospitalist report for Provider and Room utilization.

●Missing Charges Financial Reporting

●Dynamic Analytic Privileges for Clinical Departments, Providers, Executives

●Python Metadata Cleansing Application for Dicom Sanitization

●Python pipeline for Qgenda Room Utilization and Scheduling from Rest API

TSC Milford, OH (July 2014-Feb 2016)

Software Engineer

Worked in various roles for three clients as a member of SAP CoE Solutions with TCS. Achieved HANA certification in 2014, trained on BW, and the BOBJ suite. Demoed capabilities to clients, performed PoC assignments, as billed for several projects.

CVS Caremark, Phoenix AZ – TCS (2015 – 2016)

●SLT Testing Scenarios for delta tracking, cluster table & table cluster joins, Field Based rules for select values, and Event-Based rules for time intervals

●SLT Event Based BoL and BoR Rules for Rolling 3 month replication of FAGLFLEXA using ABAP Include

●SLT Field Based Rule to filter replication of select data for FPLTC

●Full Hana Implementation for Retail and PBM reporting

●Implement of FICO and Predictive Rapid Deployment Solution models

●Native HANA Report Models using Attribute, Analytical, & Calculation with MM, SD, FI tables & Modules

●Temporal joins from Fiscal Calendar static tables

●Scripted calculated views with filtered input parameters at the Calc Engine Level

●Documentation of conceptual and physical data models and ER Diagrams using Erwin

●Modeling cutover via Delivery Units

●Report consolidation fit-gap analysis with Quality Assurance regression testing

●Worked on Xcelsius to design a PoC Dashboard displaying Complications by Hospital

●US map and special component with mouse over functionality for State Selection

●Incorporated a dynamic corresponding Bar Chart that produced Complications by Occurrence

●Dynamic Visibility to allow the user to switch from a state level view to a pie chart at the National Level

●Lumira Crosstab & Bar Chart Visualizations with filter functionality for State, Hospital, & Ownership Sectors

Nielsen – TCS, Cincinnati OH (2015)

●Full project lifecycle - data provisioning, Native HANA Modeling, & Webi FrontEnd for four reports

●Native HANA Level Hierarchies - Product, Location, and Retailer for Webi Report

●Universe Design in IDT (Connection, Data Foundation, & Business Layers

Contact this candidate