• Designed and implemented a Python script within Matillion to automate the download and processing of Excel spreadsheets from Google emails into Amazon S3 buckets. After that, the data was transformed and loaded into the Amazon Redshift data warehouse, improving data accessibility and analysis. This process achieved an 80% reduction in weekly manual processing time, freeing up employee resources for higher-value activities.• Slashed data processing costs by 30%, through optimization of Python scripts, Matillion jobs, and Amazon Redshift view logic. Implemented advanced query optimization techniques, streamlined data pipelines, and meticulously refactored code, transforming 30-minute processes into lightning-fast 30-second operations.• Empowered new data analyst with the skills and knowledge needed to thrive in their role. Provided intensive training in Tableau dashboard development, maintenance, and SQL query optimization, leading to increased efficiency and productivity.

Data Modeling- Created several data marts combining data from our organization's EMR system, our ERP systems, dozens of vendors, government, and many other data sources. Some of the benefits of these solutions are: • The supply chain team can accurately see millions of dollars of provider usage statistics for the first time. • The supply chain team and medical providers can dynamically analyze supply costs variation when comparing varied vendor purchasing contracts. • Nursing leadership can accurately see vital blood usage, medical trauma data, and staffing levels across the system.- Modeled data marts, designed and developed ETL packages using Microsoft SSIS, and coordinated with business intelligence, supply chain analysts, finance analysts, nursing analysts, machine learning developers, and many other stakeholders to roll out these solutions successfully.ETL Development- Designed, developed, and implemented hundreds of SSIS data extraction packages from multiple data source systems and data source types. These extracts serviced: • Governmental regulatory and compliance solutions • Finance solutions • Supply Chain solutions • Pharmacy solutions • Medical research solutions • Emergency COVID response solutions • Executive leadership solutionsLeadership- Led training sessions for data warehousing, business intelligence developers, and business intelligence analyst staff. Some of the subjects of these training sessions are: • SQL Query optimization • Index usage • Data warehouse/data mart design- Acting lead on several major data warehousing projects including: • Multi-year ERP upgrade • Supply chain modernization • Implementation of cloud-based data warehousing tools

• Researched, developed, and implemented a data solution for blood management which will save the hospital hundreds of thousands of dollars. This involved creating a data mart using SSIS as an ETL platform. I also designed an analytic cube which is used by the dashboard that I created.• Led training sessions for dozens of staff members detailing how to use SSIS and SSMS. Worked one on one with multiple staff members to train them on how to create their own data marts and ETL packages using SSIS.• Automated numerous manual data movement processes and converted multiple batch file based operations to SSIS packages. This has saved the organization thousands of hours over the years and also cut process failures by over 90%.

Advanced data competencies and knowledge of entire organization by:• Originated visualization strategy for entire management structure. This involved vertical alignment of dashboards across all levels of management. Designed and implemented metrics, reports and other visualizations in support of this goal. Used iterative development techniques in concert with upper management feedback to produce the highest quality products.• Researched and developed clinic’s SAP licensing strategy. Reduced costs to organization by 25% through removal of unneeded licenses. As a side effect of this research, found that the clinic needed to upgrade in order to avoid end of life deadlines. Coordinated entire upgrade process for SAP products within clinic.• Performed business process modeling, data standardization sessions and other data governance work as data architect backup.• Supplied SSIS instruction and SQL code reviews for fellow data and financial analysts. This resulted in the financial analyst team’s implementation of a financial transaction data mart. This is providing the CFO with a much more granular look at costs and earnings then was possible before.

Designed and implemented entire Business Intelligence strategy for $300M+ company which produced the following:• Conceived and implemented customer segmentation reports providing visibility into underserved customers which led to over $300K in increased sales in the first two months after implementation.• Developed shipping reports that saved the company over $1M during contract negotiations with vendors.• Automated dozens of tasks which is saving the company thousands of man hours a year.• Developed and deployed customized dashboards which are enabling the CEO, CFO and several VPs to immediately see how their areas of responsibility are performing. This information used to take days or even weeks to be produced.• Wrote dozens of complex ad-hoc queries required for situational reports.• Trained end-users on new processes implemented alongside new reports which greatly increased acceptance of necessary changes.

• Developed hundreds of reports within production environments using complex selection criteria in Lotus Notes. The selection criteria for these reports included nested IF/AND/ELSE statements which frequently ran to hundreds of lines of code. These reports sorted and arranged thousands of database entries for staff members across the nation. • Designed and implemented the equivalent of SQL views, stored procedures, data types, variables, queries, indexes, tables, user defined functions, aggregate functions, nested queries, and triggers within Lotus Notes applications.• Primary designer that led a team of programmers in designing, developing, deploying and maintaining multiple databases used by thousands of staff. • Developed user acceptance testing protocols and time tables for national roll out of several Lotus Notes applications. Acted as project manager while recruiting and leading 20 – 100 UAT team members across the nation. • Created and managed security roles and access levels across high volume of production databases. This involved creating, deleting, and modifying hundreds of user accounts across the organization and assigning them security roles determining access to restricted parts of applications.