Versatile data analyst with experience designing predictive models, interactive applications, and automated dashboards. Skilled in Python, SQL, Excel, and data visualization, with expertise in data cleaning, preprocessing, and feature engineering to transform complex datasets into actionable insights and optimize business operations. Proven ability to deliver data-driven solutions that boost efficiency and drive informed decisions.
Work Experience
Cindy’s Accounting To-Go March 2023 – Present
IT Consultant — Bradford, PA
Built dynamic Excel amortization schedules and financial models, automating calculations across multiple sheets and enabling accurate, actionable financial reporting, reducing manual calculation time by approximately 80%.
Designed recurring reports and trackers to consolidate financial data, streamline monthly reporting, and support management decision-making, cutting reporting time by roughly 30%.
Troubleshot and resolved software and system issues, applying scripting solutions when appropriate to improve reliability, reduce downtime, and increase operational efficiency by an estimated 20%.
American Refining Group April 2019 – November 2019
Environmental Professional — Bradford, PA
Designed and implemented automated Excel dashboards and workflows, integrating and cleaning datasets from multiple sources, reducing manual reporting effort by approximately 25% and improving data accuracy by around 10%.
Managed monitoring programs and led EPA compliance reporting, including GHG emissions, wastewater, and air quality, consistently meeting all deadlines with 100% on-time submissions.
Collaborated with teams to interpret data, provide actionable insights, and implement process improvements, enhancing operational efficiency by approximately 20% and reducing chemical usage.
Developed a predictive RandomForestClassifier model (89% accuracy) to identify high-risk heart disease patients, providing actionable insights for risk stratification, clinical decision-making, and measurable business impact.
Performed data cleaning, preprocessing, and feature engineering using pandas and ColumnTransformer to optimize model performance.
Built a deployment-ready interactive predictive application and dashboard in Jupyter using ipywidgets, enabling dynamic exploration of patient risk metrics and visualizations of model outputs.
Demonstrated end-to-end ML pipeline skills, including data integration, model evaluation, visualization, and application development.
Package Delivery Optimization System
Skills Used: Python, OOP, Data Structures, Algorithms, CSV, Version Control
Designed and implemented a delivery optimization application using a greedy nearest-neighbor algorithm, reducing simulated delivery times by ~40%.
Engineered a dynamic distance matrix and automated CSV integration to handle variable routes and large datasets. Applied object-oriented programming principles to create scalable, modular application logic.
Delivered end-to-end data solutions, including data processing, algorithm design, performance evaluation, and interactive visualization of routing metrics.
Certifications, Tools & Skills
Certifications: Microsoft Certified Azure Administrator Associate (AZ-104), ITIL v3 Foundation, Linux Essentials