Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic

Ella Stern

Summary

Enterprise Analyst at Patrick Industries, Inc., with expertise in leveraging Power BI, SSMS, and ETL procedures to optimize data management and reporting accuracy. Proven track record in reducing data variance to within 1% and creating insightful dashboards for cross-functional teams. Strong analytical skills with a keen attention to detail, demonstrated in managing and analyzing large datasets. Adept in data protection and security, with a focus on problem-solving, effective communication, and leadership in both independent and collaborative projects.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Enterprise Analyst

Patrick Industries, Inc.
Elkhart, IN
01.2023 - Current
  • Developed and maintained a master customer database with over 450,000 rows, including 40,000+ unique customers, and a vendor database with 50,000 rows, optimizing data management for Power BI reporting and other internal systems
  • Utilized SQL Server Management Studio (SSMS) and Python to create and implement ETL procedures from scratch, extracting and integrating data from multiple ERPs across key business areas including sales, inventory, items, sales orders, and purchase orders, improving data accuracy, reporting efficiency, and overall analysis
  • Led validation projects in SSMS, aligning sales data to achieve a variance within 1% from the Profit & Loss (P&L) reports
  • Designed and deployed multiple Power BI dashboards, aggregating data from various ERP systems, and providing key insights to over 300 managers, accountants, and analysts
  • Managed security protocols for Power BI, SSMS, and other internal tools, ensuring data protection and compliance
  • Served as System Admin for Blackline, managing the tracking and reconciliation of P&L data, ensuring accurate financial close processes and compliance across financial reporting systems

Agronomy Assistant

Lennard Ag Company
Howe, IN
05.2022 - 12.2022
  • Conducted soil analysis, field scouting, and yield digging to assess growth conditions and report findings to senior management for decision-making
  • Managed soil sample logistics, including packaging, shipping, and tracking to ensure timely deliveries for analysis
  • Utilized Excel and Word to update and maintain workbooks, dispatches, Standard Operating Procedures (SOPs), and data for white papers
  • Performed multitasking duties in the Quality Control lab, including truck scaling, managing fry samples, coordinating with truckers, and overseeing the trucking schedule

Sales Representative

Vector Marketing Corporation
Granger, IN
06.2021 - 05.2022
  • Promoted Cutco products through virtual and in-person consultations, providing customers with personalized recommendations to meet their needs
  • Managed flexible schedules and conducted outreach to arrange virtual appointments, fostering client relationships and achieving sales goals
  • Effectively resolved customer concerns, demonstrating strong communication skills to convey product value and maintain customer satisfaction

Stable Manager & Riding Instructor

Bittersweet Pet Resort & Stables
Niles, MI
06.2017 - 02.2021
  • Led horsemanship training and organized trail rides for groups of up to four participants, ensuring a safe and enjoyable experience while tailoring sessions to individual needs.
  • Designed and facilitated a children's summer horse camp, managing schedules, activities, and feedback to enhance customer satisfaction and service quality.
  • Oversaw daily horse stall cleaning and maintenance, ensuring a clean, safe environment for the animals, while continuously improving services based on customer feedback.

Education

Bachelor of Science - Business Organizational Management

Purdue University Global
West Lafayette, IN

Skills

  • Power BI
  • Alteryx
  • Power Automate
  • SSMS
  • Python
  • SQL
  • Excel
  • Alteryx Designer Core
  • Blackline
  • OneStream
  • AX Dynamics

Certification

  • Alteryx Designer Core Certification
  • Alteryx Foundational Micro-Credential
  • SQL for Data Science

Timeline

Enterprise Analyst

Patrick Industries, Inc.
01.2023 - Current

Agronomy Assistant

Lennard Ag Company
05.2022 - 12.2022

Sales Representative

Vector Marketing Corporation
06.2021 - 05.2022

Stable Manager & Riding Instructor

Bittersweet Pet Resort & Stables
06.2017 - 02.2021

Bachelor of Science - Business Organizational Management

Purdue University Global

Similar Profiles

CREATE PROFILE
Ella Stern