Business Analyst Program Manager

John Crossley Chicago, IL *****

Phone: 773-***-**** Email: *************@*****.***

Summary

Detail-oriented and data-driven and supply chain professional with a strong analytical mindset with 15+ Years of experience within Healthcare/Foods industries.

Proficient in breaking down complex problems, identifying patterns, and deriving actionable insights. Adept at using data analysis tools and methodologies to drive informed decision-making and optimize processes.

Created Domo/Power BI Dashboards for KPI metrics.

Advance level expertise of Microsoft Excel, Access, Power BI, PowerPoint, SQL, VBA, SAP ECC, MDG, Visio will allow me to be an asset to your organization.

Skills

Power BI, IBM Cognos, Domo, Domo Workbench, Microsoft Excel VBA, SAP/ECCMDG, SIS CManage System, Enterprise Data Warehouse, Prism, (DiscovererPlus 10g), Smartsheet, Outlook 2003, Microsoft Access 2.0 - 2003+, Microsoft Word &Excel 5.0 – 2003+, Lotus 123, Paradox, 5.0-8.0, SQL Language, PC Focus, ParadoxObject Pal Language, Windows 10, NT Workstations 4.0, Novell Net Ware 5.0, Word

Perfect 5.0 - 8.0, Visio 5.0

Education

M.B.A. in Business Administration

Loyola University Chicago - Chicago, IL

September 2021 to May 2023

B.A. in English Communications

East-West University - Chicago, IL

September 1989 to June 1993

Professional Experience

Abbott Molecular Diagnostics Operational Excellence-Des Plaines, IL Feb 2021 to Aug 2024

Operations Business Analyst

Drive SAP Master Data Governance activities to ensure data integrity.

Ensure system integration of legal controls to facilitate regulatory requirements.

Developed and implemented risk mitigation strategies to maintain operating efficiency.

Worked closely with Finance to implement strategies to facility key financial goal

Developed KPI’s to analyze and track YOY growth strategies.

Create and present Executive Summary Reports on KPI’s to leadership.

Developed Sales and Purchasing Metrics to facilitate key sales initiatives.

Developed requirements for Customer Order Fill Rate (COFR) analysis/metrics

Developed requirements for Overall Equipment Efficiency (OEE) analysis/metrics.

Developed requirements for Overall Resource Efficiency (ORE) analysis/metrics.

Developed requirements for Key Performance Indicators (KPI’s).

Create Domo/Power BI Dashboards for KPI metrics.

Drive and implement analytics for RFP’s & RFI’s.

Automate reporting requirements in Excel using VBA to report against key initiatives.

Perform all duties delegated by Supervisor.

US FOODS-Rosemont, IL 2006 to Oct 2020

Vendor Program Manager

Prepare and present Executive Summary reports to senior leadership.

Conduct data analysis to identify and inform R&D opportunities.

Conduct National Category Reviews with key suppliers to identify growth areas.

Develop and implement Category Growth Strategies to support key company initiatives.

Perform Price Adjustment Analysis to identify opportunities to improve margins.

Drive and implement RFPs with suppliers to obtain a favorable costing structure.

Perform Sku Rationalization/Assortment Analysis to drive down cost and identity margin opportunities.

Negotiate, prepare, and manage Vendor Program Agreements.

Business liaison for Category Management team and NSIS, VSC, IT, and Legal.

Business liaison between Finance and Category Management/Procurement.

Manage and work with Vendors/key Supplier Partners (800+ Suppliers) to facilitate daily SCM operations.

Identify and drive exclusive branding opportunities with key Supplier Partners.

Blue Cross and Blue Shield of Illinois- Chicago, IL 1997 to 2006

Credentialing Data Analyst

Administer HMO's and Blue Choice's credentialing database.

Analyze physician's credentials using Excel, Access, SQL modules, and ETL’s.

Perform data analysis for HMO/Blue Choice Networks (Microsoft Access).

Provide database support to staff of 34 users.

Install and test software/hardware.

Prepare ad hoc reports for Supervisor/Manager (Microsoft Access/Excel).

Draft departmental data entry and data maintenance guidelines, policies and procedures.

Plan and implement data cleansing strategies for ERP database conversion.

Oversee and Maintain 34 computers (Compaq/IBM's) with NT 4.0 workstation.

Develop departmental Access/Paradox database user application guidelines and procedures.

Perform all duties delegated by Supervisor.

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate