Hunter Smith

Automated manual monthly reporting by building dynamic Power BI and Paginated Reports, saving hours of manual work while supporting 40+ clients and thousands of metering points
Built scalable data pipelines in Microsoft Fabric to ingest and upsert high-volume utility time series data from APIs, enabling real-time performance tracking and fault analytics
Designed robust data models using SQL, Power Query, and DAX
Integrated hierarchical folder structures
Implemented cumulative aggregations
Implemented date window logic
Implemented incremental refresh for scalable, multi-year reporting

Automated manual monthly reporting by building dynamic Power BI and Paginated Reports, saving hours of manual work while supporting 40+ clients and thousands of metering points, Built scalable data pipelines in Microsoft Fabric to ingest and upsert high-volume utility time series data from APIs, enabling real-time performance tracking and fault analytics, Designed robust data models using SQL, Power Query, and DAX, integrating hierarchical folder structures and implementing cumulative aggregations, date window logic, and incremental refresh for scalable, multi-year reporting

Accurately entered, analyzed, and quality checked a variety of utility data from a dozen clients totaling hundreds of accounts resulting in thousands of dollars in cost savings for clients
Used MySQL to update, edit, and delete data from the company database as needed, ensuring data accuracy and reliability
Regularly worked as a team member
Managed weekly updates on up to 10 projects at a time
Reported weekly updates on up to 10 projects at a time

Accurately entered, analyzed, and quality checked a variety of utility data from a dozen clients totaling hundreds of accounts resulting in thousands of dollars in cost savings for clients, Used MySQL to update, edit, and delete data from the company database as needed, ensuring data accuracy and reliability, Regularly worked as a team member, managing and reporting weekly updates on up to 10 projects at a time

Researched and developed new packing specifications for 300+ unique bio process containers demonstrating critical thinking skills
Transferred data efficiently for 300+ SKUs from Excel to Oracle and MasterControl software programs, facilitating smooth transition between programs
Collaborated with 9-member team
Reported project data to manager weekly contributing to team cohesion

Researched and developed new packing specifications for 300+ unique bio-process containers demonstrating critical thinking skills, Transferred data efficiently for 300+ SKUs from Excel to Oracle and MasterControl software programs, facilitating smooth transition between programs, Collaborated with 9-member team and reported project data to manager weekly contributing to team cohesion

Participated in weekly service projects that lasted 2-4 hours, contributing to the betterment of the community
Developed and delivered trainings to 20-30 volunteers, equipping them with the knowledge and skills necessary to carry out their responsibilities effectively and confidently
Averaged 70+ hours work a week teaching life skills to people of all backgrounds, demonstrating a strong work ethic