Joel Correll Email & Phone Number

Camp Hill, Pa, Us

Camp Hill, Pa, Us

Hershey, Pennsylvania, Us

Summary of Work:Modernized the Reporting Center of Excellence by transitioning from manual to fully automated report development and administration. This involved standardization, skill development, and new software implementation.Scope of Work:• Establish global, cross-functional IS partnerships and introduced new stakeholders, allowing for the automation of enterprise-wide reports, saving FTE and dollars in cost avoidance and potential earnings.• Support the automation of reporting solutions (Power BI and SAP SAC) for various business units including finance, commercial sales, commercial retail, supply chain, and order-to-cash.• Act as the primary business sponsor and lead for new software implementation, including governance, execution, and final deliverables for tools like Informatica, SAP Datasphere, and Collibra.• Align with organizational data, analytics, and reporting strategic initiatives, transitioning existing solutions from Oracle and Hadoop to Snowflake.• Manag a global team across Mexico, India, Hershey, PA, and remote locations in the US.

Hershey, Pennsylvania, Us

Lead the S4 reporting and analytics transformation team. Work with OCM, IS, and workstream leads to prioritize and drive solutions, training, and sustainability for a successful US S4 ERP transformation. This includes ramp up, go live, ramp down, HyperCare, PI planning, and standards/project management governance.

Hershey, Pennsylvania, Us

Transformed the Global Product Portfolio from manual Excel-based tasks into a modernized analytics function by integrating programming languages, data modeling, advanced analytics, and report automation. Implemented standardized reports and dashboards, centralizing and connecting various data sources to provide previously unattainable solutions.• Modernized analytics function with programming, data modeling, and automation• Implementd 30+ standardized reports and Power BI dashboards for global teams• Provided insights into product discontinuations, portfolio metrics, and project impacts• Centralized data models connected diverse data sources via Power Automate and Alteryx

Harrisburg, Pennsylvania, Us

Developed and improved over 500 SAS programs, transforming manual processes into efficient macro-based systems. This included creating programs and models for the Pennsylvania Grant Program, and producing comprehensive summaries and reports for key stakeholders.• Led the development of projection and forecasting models• Created annual reports and report suites for Executive staff, Board of Directors, and Legislators. • Acted as primary programmer, analyst, and writer in delivering the PASG outcomes analysis.• Served as the lead analyst for SAS and SAS/STAT programs, delivering data-driven metrics and insights

Arlington, Va, Us

Provided contractor support for the Department of Defense (DOD) and Defense Logistics Agency (DLA).Responsible for Economic Ordering Quantity (EOQ) forecast modeling and logistical/transportation needs for direct military support.Developed EOQ models using Base SAS.Supported BRAC (base realignment and closure) analytics.

Certificate, Ai & Business

Master Of Arts - Ma, Economics

Bachelor Of Science - Bs, Economics