Advising on University curriculum to help prepare students for carers in data science

- Designed and oversaw implementation of Data Warehouse with more than 10 billion rows of data- Instructed team of 20 analysts on usage of dbt (data build too)- Selected hardware/software stack to meet analysis needs. Up to 4000% faster query performance.- Technologies used: Docker, Clickhouse, Dagster, dbt, Airbyte- Automated 30+ reports saving 1.6 FTEs- Trained other Data Engineers on best practices, making them effective contributors.

-Developed ETL scripts to obtain and combine data into useful data sets-Used python to parse log files in order to create a data lineage map. This decreased development time and change analysis for new work.-Created custom json parsing API in Python using FastAPI to facilitate processing of 2.5 Million claims per day.-Created custom Flask backed Qlik Sense Testing Framework to increase deployment/development velocity-Created custom data testing framework to ensure data quality in pipeline using python-Increased the accuracy of estimates to customers as Scrum Master-Conducted research into alternative BI solutions to meet current and future business needs.-Tools/frameworks: Git, SQL, Python, PowerShell, Qlik Sense

-Implemented process changes to save 5000 hr/year ($173,000/year) for loan processing team-Streamlining loan process-Reducing Data Duplication-Creating Dashboard Solutions-Using Machine Learning to Identify Loan Risk

-Maintained QlikView, Business Objects, and Tableau Servers.-Developed process using SharePoint that eliminated 82+ hours of work per week saving Zions $225,000 per year in perpetuity.-Developed Tableau Dashboards for reporting purposes-Created Business Objects universe using IDT (Information Design Tool)-Managed Business Objects environment with 7000+ users-Performed on call duties for all BI platforms-Recovered Business Objects platform in disaster recovery practice-Upgraded Business Objects platform from 4.0 to 4.1 SP3 Patch 4-Reduced QlikView server memory usage by pragmatically restarting services. -Analyzed Business Objects metadata to identify 24,000 reports that should be cleaned up. Reduced storage by 50%

While Deployed: Managed the ground support equipment for a fleet of Apache Helicopters in Afghanistan. Managed $4+ Million in inventory.Also recorded and managed work hours for an entire company. Repaired Hydraulic & Pneumatic systems.Oversaw readiness of all ground support equipment for the fleet. Ensured efficient operations by monitoring and ensuring that repairs are done in a timely manner.Worked 78hr weeksManaged production & control operations for Apache fleet of 21 aircraft.

Modeled capacity for a $12 Million dollar process within 1% accuracy.Searched out bottlenecks of the process and created a model that is capable of predicting capacity when a new product is entered into the product mix.

Instructed future customers on the benefits of security on a case by case basisProactively searched for potential clients

Researched and updated online inventory product lines which resulted in increased knowledge and understandingof our customers

Door to door sales.

Increased customer satisfaction by always greeting with a smile and treating customers with respectEmpathized with customers which helped to understand and resolve concernsLearned about Banking system operations of Zion's Bank