Andrea Dietrich Email & Phone Number

Coatesville, Pa, Us

Hershey, Pennsylvania, Us

Hershey, Pennsylvania, Us

Hershey, Pennsylvania, Us

- Lead on delivering ERP Trade Promotion Management transformation through gathering requirements, identifying data sources, designing data models, and coordinating development efforts through an agile methodology. The effort spanned a year and allowed the business to see key insights across point of sale, baseline, and movement. Providing a full picture for strategic commercial planning. - Engineered the company’s first custom and scalable trade promotions post event tool over a 5-month period. Coordinated cross-functionally with stakeholders to scope, identify and ingest new sources, design complex models, and coordinate development efforts. The effort spanned coordination and knowledge across the BI landscapes including SAP, Teradata, Data Lake, RStudio, and BODs. Allowing the business to make strategic decisions across top customer's promotions. - Structured and coordinated the first Power BI workshop day for the company with over 100 analytical community members in attendance. - Pioneered the first proof of concept for building end to end Azure Cloud Resources. Enabling a base model for future projects, establish governance, and create a center of excellence for the self-service cloud ecosystem. - Participated in an agile project to develop and deliver data for the e-commerce business within the BW landscape. Providing essential insights into the growing financials and strategy.

Hershey, Pennsylvania, Us

- Co-led the transition to retail sales provider IRi through designing and developing executive reports. Lead sessions with the executive stakeholders to develop impactful KPIs and reports. - Established and delivered on a big data solution to ingest and model a space allocation data solution. Spanned multiple retailer data sets resulting in a 5 million plus ad-hoc record analysis. - Managed relationships with the data science community to gather requirements and bring in innovative data and technology. - Led sessions to design and deliver a Consumer Complaints Tableau dashboard that directly reduced cost through sunsetting the legacy system while improving insights for the Quality Assurance business.

Hershey, Pennsylvania, Us

Interning as an Applications Analyst on the BI team, I received the opportunity to work on valuable solutions and impacting projects for several business partners. I gained a deeper business insight into The Hershey Company, and also became skilled in a cutting edge analytical tool, Tableau.

Bloomsburg, Pa, Us

Research Assistant for a Bloomsburg University Information and Technology Management Professor. The project includes the development of procedures and tools to support the development of ITM and Masters of Accountancy majors.

Summer employment for 2014. Served and Prepared food for residents.