Work Experience

• Data Integration Engineer, 

  Oct, 2024 - Present

  • Analyzed complex Excel-based Profit and Loss (P&L) statements for a new soybean and canola processing facility, focusing on EBITDA and profitability metrics for both inputs and outputs.

  • Gathered business requirements, identified data sources, and documented data pipelines, leveraging Workday Prism Analytics for seamless integration.

  • Modernized P&L workflows by transitioning manual Excel processes to automated solutions, utilizing Workday Worksheets with real-time data updates.

  • Developed and optimized inbound data pipelines in Workday Prism Analytics, integrating external data sources directly into the Workday platform.

  • Designed intuitive and actionable reporting solutions using Workday's advanced reporting tools to deliver streamlined insights.

  • Applied strong problem-solving skills to improve processes, enhance accuracy, and increase visibility into operational profitability.

• Workday Custom Report and Prism Analytics Developer, 

  Feb, 2023 - Oct, 20241 year 8 months

  • Led the development of a multi-source data pipeline integrating Epic EMR, Kronos, Axiom, and Workday data, improving workforce productivity tracking for 1600+ cost centers and processing over 42 million labor hours.

  • Engineered data pipelines that unified diverse systems into a single reliable source, enhancing reporting accuracy and empowering leadership with actionable insights.

  • Managed the migration of over 12 million rows of legacy data into a unified Workday Prism Analytics data source, simplifying data access and reporting across departments.

  • Developed over 100 advanced matrix and composite reports across payroll, HCM, and recruiting functional areas.

  • Created detailed reports at the cost center and employee levels for payroll earnings and deductions by type.

  • Generated quarterly job application, new hire, and termination count reports for Vizient reporting.

  • Built a dashboard tracking employee turnover trends, including terminations by type, year, and reason, as well as attrition rates by location.

  • Designed metrics for months of continuous service at termination and terminations within 1, 3, 6, 12, and 18 months of hire.

  • Collaborated closely with cross-functional teams ensuring the development of custom reports, dashboards, and KPIs that met the business needs of non-technical stakeholders.

• Sr. Workday Report Developer, 

  Feb, 2021 - Feb, 20232 years

  • Executed the deployment of Workday HCM data reporting for Highland Hospital benefiting approximately 5000 employees and prepared for expansion to the entire University employing around 35000 individuals.

  • Partnered with Huron consultants to guarantee data consistency during the transition from the legacy system to Workday, interpreting and meeting technical requirements for more than 40 key reports in HCM and Payroll functional areas.

  • Deployed W-2 and W-2C data extraction for all Highland Hospital workers via Prism Analytics supporting employment data validation with the Social Security Administration.

  • Customized BIRT paycheck layout using Workday Studio for over 4000 Highland Hospital workers with users executing the solution over 5000 times in the first six months from go-live.

  • Designed BIRT supplier payment checks to bank acceptance criteria specifications using Workday Studio, enabling electronic vendor payments through the Workday application.

  • Developed a Workday financial dashboard to monitor and manage over $64 million in grant award funding.

• SQL Reporting Analyst, 

  Jan, 2020 - Nov, 202010 months

  • Devised an on-demand solution for database migration, identifying discrepancies between server instances with SQL object definitions and hash algorithms.

  • Upgraded and maintained SSIS ETL workflows ensuring seamless data integration into the SQL reporting environment.

  • Managed SQL queries and procedures for the Facets insurance claim submission application providing reliable data reporting.

  • Encouraged and enacted process improvements leading to considerable time savings and increased team productivity.

• Data Analyst / SQL Developer, 

  May, 2016 - Jan, 20203 years 8 months

  • Prevented loss of $1.6 million in unused state aid through strategic data analysis and reallocation of provider surplus and deficits.

  • Processed daily billing for the Health Homes of Upstate NY (HHUNY) network with SSIS workflows, adjusting workflows as needed for governmental reporting changes.

  • Engineered a data pipeline using SQL and Alteryx enabling near real-time tracking for over $35M in budget data from over 40 providers across 100+ programs.

  • Built and deployed interactive Tableau dashboards, refreshing data with daily workflow execution.

  • Developed a GUI application in Microsoft Access with a SQL Server back end utilizing VBA as the middle layer to support the 'Gap In Care' initiative.

  • Interpreted and structured reports to meet evolving governmental requirements aiding over 40 healthcare organizations in adapting to changing data environments.

• Research Analyst / Java Programmer, 

  Jan, 2016 - May, 20164 months

  • Engineered a scalable Java application analyzing vehicle usage viability, processing 82,000+ trip records across 13,000+ households to inform sustainable transportation policy

  • Designed object-oriented data pipeline integrating household surveys, vehicle data, and trip segments, with robust validation for data integrity and pattern analysis

  • Developed statistical models comparing charging strategies (slow vs. fast charging), demonstrating 85% of trips could be completed with 40-mile range EVs

  • Implemented custom algorithms to identify and analyze complex travel patterns including multi-stop journeys, vehicle sharing, and varied charging scenarios

Projects Experience

• Spring Boot Web Application

  - Present

  Created REST API endpoints for managing employee and compensation data using Spring Boot and MongoDB.

  • Created a ReportingStructure type to calculate the total number of direct and indirect reports for an employee using a recursive approach.

• Automated Resume Pipeline

  - Present

  Created git-based automated resume deployment system

  • Built version-controlled resume system using JSON for structured data and git for change tracking and history management

  • Implemented GitHub Actions workflow to automatically sync repository updates to Gist, enabling continuous deployment to JSONResume.org

  • Leveraged GitHub's infrastructure for secure secret management and automated file synchronization

  • Standardized resume updates through programmatic JSON manipulation, eliminating manual formatting overhead

Skills

Education

Certificates