Technologies: Azure, AWS, GCP, Snowflake, DBT, Fivetran, Airflow, PowerBILanguages: SQL, Python• Responsible for designing end-to-end solutions including ingestion, data pipelines, data modeling and BI development. Implemented data solutions across a variety of cloud technology stacks for a number of clients and industries. • Managed all aspects of projects including junior employee workload, maintaining client relationships, delivering projects within scope, employee feedback reviews and organizing future projects and implementations.• Directly managed a client relationship across two years which resulted in seven project phases totaling $1.3M in revenue.• Developed a low cost, fully deployable orchestration solution utilizing Python, AWS Lambda and AWS Step Functions to ingest data into Snowflake and orchestrate ETL for data warehouse.• Built an Azure data solution to load on-prem data from a DB2 instance into Snowflake using Data Factory, Azure Functions and other Azure Services.• Designed data models for storing data and tracking change history, including data vault.• Wrote an agile deployment solution in Python and Azure DevOps for deploying Azure Services, SQL DDL and scripts to a Production environment.• Designed custom data solution for ingesting UPS data into Snowflake by REST API, modeling it into a Data Warehouse, and securing it by user with Row Level Security.• Designed a custom connector framework for Fivetran data sources using Python and Google Cloud Functions.• Created Interactive PowerBI dashboards to allow clients to view their data in real time.• Monitored Referential Integrity of an EDW using Airflow DAGS.

Technologies: SQL Server, SSIS, SSAS, ExcelRedesigned, facilitated, and developed various data pipelines using SQL Server and SSIS. Created and supported new internal tools and analytics to help drive business decisions. Served as a POC for troubleshooting various issues across our SSAS cube and the company’s ETL pipeline.• Created, tested, and implemented complex SQL queries, views and sprocs including ETL Transform steps, reporting datasets, and SQL-based rules used to identify coding anomalies and missing charges on electronic institutional healthcare claims (837Is).• Developed and redesigned a data warehouse and SSAS cube utilized as the source of truth to track the monetary performance of Waystar’s Charge Integrity platform that amounts to millions of dollars.• Designed and supported internal tools that drive Waystar’s Charge Integrity product through SQL and SSIS development.• Owned internally utilized SSIS packages, including a utility to load hospital contract information that determines Waystar’s financial opportunity by patient.• Reviewed, vetted, and prioritized defect and enhancement requests submitted through Salesforce, leveraging my in-depth technical and functional understanding of the Waystar products.

Technologies: SQL Server, PowerBI, ExcelLed the retrieval, aggregation, validation, and analysis of performance metrics across multiple lines of business and functions. Supported business decisions through the creation of analytical tools, including volume pattern analysis, FTE need estimation, cost models and business value metrics. • Created and administrated a SQL Server database which consolidated data across multiple lines of business, which housed all data for the team’s reporting and analytics.• Developed analytical tools using arrival patterns and average handle times to determine FTE (full time equivalent) need per hour for each day of the week. Conducted volume analysis to ensure that staffing could handle peak volumes, as well as that all backlogs that arrived during non-business hours.• Developed interactive excel dashboards for leadership to look at performance metrics such as SLA targets, query rates, and highlight issues across various functions.• Reduced time spent per month on executive reports from 12hr/month to ~3hr/month by creating templates tied to queries which can simply be refreshed each week that new data is appended, rather than manually datamining and combining data.• Lead multiple process improvement initiatives, including the creation of a document which tracks and assigns audits based on weekly volume, reducing time/week of the original process by 75% and providing a dynamically changing way of auditing work completed.

Led initiatives in automation, process improvement, and tool creation to support the finance and enterprise portfolio teams. Created an enterprise database tool for the finance team that saved hours of work each month when calculating third party costs for month end processing. Resulted in an accuracy level within .5%, significantly exceeding goal of <= 5%. Designed tool that assisted in balancing end of month, automating the process by pointing out discrepancies. Drove planning, process improvement, and implementation of changes to the Enterprise Product Catalog (EPC) processes, streamlining intake requests, and data entry processes. Streamlined implementation of enterprise pricing changes, clarifying process and streamlining antiquated steps.