Stefanie Scheffe Email & Phone Number

Developed automated / workflow systems by utilizing power automate for tracking marketing, support requests, rental agreements, product usage, and insurance verification resulting in creation of comprehensive metrics and efficient processes. Collect data from multiple platforms by utilizing PowerBI to implement relational databases into company reporting. Prepare custom dashboards for operations, marketing, billing, providers, and invoice details. Cultivate expertise in Power BI to pull all data together while serving as data analyst. Compile and manage documentation for metrics, reports, and processes. ● Reduced reporting errors and conducted quality control checks to ensure accurate data.● Improved operational efficiency by delivering exceptional training to staff on new process.● Increased reporting frequency / efficiency and decreased time to generate/refresh reports from 3 hours to 20 minutes.

Phoenix, Arizona Area

Ensured structural compliance and data integrity by creating and testing delimited, fixed length, XML, and 834 files. Liaised with carriers and clients to assure EDI files structuring as per carrier specifications and client requirements. Established and maintained department SharePoint housing all file structure documents, customer notes, and SFTP information. Monitored all EDI projects, delivered high-level department overviews, and coordinated individual project progress by creating EDI department in collaboration with stakeholders. Administered all data exports, delivered better information, and ensured visibility of project progress by optimizing open enrollment process through development of ticketing / workflow system. Prepared yearly Open Enrollment EDI files, census files, and several other exports by conducting audits.● Ensured best EDI experience for client by improving client and vendor communication.● Maintained and troubleshoot data exports to ensure on-time delivery of exports / within error limit of less than 5%.

Oklahoma City Metropolitan Area

Compiled automated reports and dashboards from multiple systems displaying production volumes, equipment, revenue, and cost data. Facilitated senior management by generating and maintaining Earnings Call, Capital Committee, and various other ad hoc Supply Chain reports. Provided exceptional assistance to category manager in conducting pricing forecasts and evaluating supply or demand issues. Created Access database for Category Managers to enter project savings and designed reporting dashboard in excel to generate real-time custom reports. Drafted contracts, amendments, and proposal evaluations for supporting category management operations● Deliver excellent training to supply chain staff on financial tools, SAP, and Access database.● Resolved oil, gas, and water issues by coordinating with Accounting, Information Technology, and SCADA teams.