Documented workflows and developed Knowledge Base articles for Power BI reporting, enhancing team understanding and efficiencyDesigned Power BI reports to ensure business continuity during the transition between procurement systems across multiple business unitsMigrated Excel and source system reporting into streamlined Power BI reports, improving data accessibility and accuracyCollaborated with Senior Leadership to gather requirements for Power BI reports, providing timelines and updates on project progress and delays

Developed a comprehensive Data Strategy for Corporate Services during the transition between procurement systems, ensuring a smooth migrationMentored multiple employees on the technical use of Power BI, fostering a culture of learning and enhancing team capabilitiesServed as the Subject Matter Expert for Power BI within Corporate Procurement, conducting training sessions to elevate team proficiencyStreamlined Power BI reports by eliminating unnecessary complexities, resulting in improved usability and clarityIdentified data discrepancies in core SQL tables, addressing data integrity issues to ensure reliable reportingCreated new Power BI reports that provided key KPIs to Senior Leadership, facilitating informed decision-making

Monitored hosting data in the Data Warehouse to ensure data integrity with source systems, implementing timely corrections as necessaryTrained and coordinated associates' activities to align with departmental goals, enhancing team productivity and performanceCollaborated with key stakeholders on timeline, scope, and resource planning for data analytics reports and projects, ensuring alignment and clarityPlayed a pivotal role in the organizational transition from DOMO to Power BI, including designing custom SQL for Power BI datasets to optimize performanceProvided comprehensive data field mapping of core business systems for the data warehouse, facilitating seamless integrationTransformed large unstructured datasets from various sources into searchable databases for use in Power BI, improving data accessibilityContributed to process improvements in the Post-Incident Review operation, enhancing efficiency and outcomesMonitored trends in Plexus Cloud client growth, utilization, and operational data from 2020 onward, supporting strategic decision-makingDelivered comprehensive reports to all levels of Hosting Management, supporting various organizational initiatives and decision-makingContributed to the Salesforce Center of Excellence team, driving best practices and improvements in data managementExtracted and cleaned data from ServiceNow and Salesforce to enhance Plexus Cloud reporting accuracy and effectiveness

Converted over 20 reports from DOMO to Power BI, facilitating a smoother transition and enhanced reporting capabilitiesSupported reporting requirements for Information Security, Finance, Enterprise Architecture, and Infrastructure Teams within Plexus Cloud, ensuring alignment with organizational needsAssessed end-user requirements, translating customer needs into actionable technical specifications for reporting solutions

Managed the Sedgwick Client Letter process, coordinating with attorneys to address missing letters and enhancing liability-reducing signature verification effortsVerified and reported on asset return status, ensuring compliance with corporate policies and procedures

Gathered Business Intelligence, Reporting, and Analytics requirements from stakeholders, utilizing SQL to identify trends and relationships, and translating findings into actionable risk management strategies from diverse data setsEmployed DAX to build calculated fields and measures in PowerPivot data models, enhancing data analysis capabilitiesUpdated existing SQL processes, enabling Apria to discontinue the use of eight Access databases, streamlining data managementCreated and documented custom SQL queries to extract data and generate reports, improving reporting accuracy and efficiencyDeveloped a Meal/Rest Break Audit report, facilitating compliance with Federal and State regulations and improving adherence tracking

Project Lead on FSO Ticketing Tool, responsible for gathering and documenting requirements and creating enhancements to the FSO Ticketing ToolDeveloped multi-customer Ticket Forecast statistical models for the Field Service Organization based on these requirements and achieved a 3% variance of actuals vs forecasted tickets, which allowed for substantially improved quarterly resource planning and overhead reductionReduced weekly market level forecasted volume vs. actual volume variance from 62% to 23%Devised a monthly ‘balanced scorecard’ to distribute to FSO VP and Ericsson Global teamsMaintained and delivered scorecards, dashboards, and trended data, as well as a weekly ‘state of the business’ report and several quarterly resource planning estimates to ensure key metrics were available to the VP and various Leadership Teams within EricssonLed a Metric Enhancement Project to add, remove and update metrics on FSO DashboardDeveloped and distributed ad-hoc report requests using Excel and SQL for various internal and external groups

Performed research and analysis for cellular network capacity to determine if the company was meeting contractual obligations with the clientLed a team of area managers in creating an internal tool that would assist in completion of daily technician tasks. Work included Break-Fix activities, preventive maintenance activities, and upgrades to clients’ cellular networkWorked closely with various teams across the company to identify and solve business challenges utilizing large structured, semi-structured, and unstructured data in a distributed processing environmentProvided historical trending analysis to determine the state of current operations, anticipate the state of future operations, and recommend operational improvements Completed various one-off and short-term reporting projects for a variety of functions