Samuel Morley
Senior Reporting Analyst
Cohoes,NY
Summary
Disciplined professional bringing 5 years of big data experience. Well-versed in developing and executing effective queries, analyses, visualizations, and database management techniques to measure performance and increase efficiency.
Overview
5
5
years of professional experience
4
4
years of post-secondary education
Work History
Senior Reporting Analyst
Healthy Alliance
01.2024 - Current
- Managed implementation of multiple high-impact healthcare reporting needs, from requirements gathering through deployment and post-launch support stages.
- Utilized Azure Environment and SQL Server to develop database architectural strategies to address business requirements, such as transformation techniques to reduce data loss and table creation for ease of reporting and analytics.
- Fine-tuned SQL query performance and optimized database structures for faster, more accurate data retrieval and reporting, in some cases increasing query speed by several minutes.
- Managed guidelines for calculations for metrics and analysis.
- Collaborated with cross-functional teams to gather data requirements and optimize reporting outputs.
- Trained team members on best practices for effective reporting, analysis, database structures, and database management.
Reporting Analyst
Healthy Alliance
12.2021 - 12.2023
- Used SQL to query, profile, validate, analyze, and evaluate data across multiple databases.
- Designed and developed ongoing and ad-hoc reports with Power Bi and Excel for internal and external users.
- Supported quality control processes by identifying data discrepancies and opportunities for improved data quality and reporting.
- Assisted with file ingestion using Azure Environment, loading and transforming files from over 100 sources.
Research and Development Engineer Technician
Taconic
10.2020 - 11.2021
- Automated validation and cleansing processes of outdated databases, resolving weighting issues that skewed results by up to 10%.
- Optimized existing formulations and processes to improve product performance and safety while reducing costs.
Education
Bachelor's Degree - Mathematics
SUNY College At Oswego
Oswego, NY 08.2016 - 05.2020
Skills
SQL
R
Python
Microsoft Power Bi
Microsoft Suite (Excel, etc)
Microsoft Azure Data Factory
ETL Process
Database Management
Statistical Analysis
Timeline
Senior Reporting Analyst
Healthy Alliance
01.2024 - Current
Reporting Analyst
Healthy Alliance
12.2021 - 12.2023
Research and Development Engineer Technician
Taconic
10.2020 - 11.2021
Bachelor's Degree - Mathematics
SUNY College At Oswego
08.2016 - 05.2020
Similar Profiles
Sherri M. HareSherri M. Hare
Performance Consultant at Healthy AlliancePerformance Consultant at Healthy Alliance
Gotti ValdezGotti Valdez
System Administrator at Healthy AllianceSystem Administrator at Healthy Alliance
ALEXIS C. BOGGUSALEXIS C. BOGGUS
Administrative Assistant Intermediate at Medicine | Regional Alliance for Healthy SchoolsAdministrative Assistant Intermediate at Medicine | Regional Alliance for Healthy Schools
John McGarryJohn McGarry
Lifeguard at Highland ClubLifeguard at Highland Club
CHRISTINA VELINOVCHRISTINA VELINOV
Assistant District Manager at Jackson Hewitt Tax ServiceAssistant District Manager at Jackson Hewitt Tax Service