Will Oswald Email & Phone Number

Minneapolis, MN, US

• Designed and configured multiple regulatory riders with calculated rates and automatic revenue forecast adjustments including a renewable energy rider incorporating wind farm rate base, wind farm O&M, PTCs, and PTC.
• Designed and configured Class Cost of Service Studies utilizing cost of service, rate base, and revenue requirement methodologies to perform allocations to all rate classes and functions, allowing for the derivation of.
• Implemented multiple integrated financial models to create planning ledgers with forecasted financial statements and designed reports to provide statistical and earning figures, allowing clients to better understand.
• Modeled optimal regulatory filing periods based on revenue deficiencies and surpluses with client overrides
• Performed revenue forecasts based on client tariff structures including time-of-use tariffs and automatic rate adjustments allowing the client FP&A teams to reduce revenue forecast turnaround time and increase model.
• Implemented Production Tax Credit creation and associated earnings impact based on wind energy production by plant

Atlanta, Georgia

• Managed a 20-person team working with Grady Memorial Hospital to implement an app allowing virtual patient ER registration to decrease overall ER wait times and operating costs
• Provided support, guidance, and tools for the User Research, Analytics, Design, and Development sub-teams to help them gather requirements, conduct interviews, design modules, and develop a model application for Grady.
• Modeled the final application’s effects on wait times and staffing using variable user inputs

Atlanta, Georgia

• Managed a 10-person subteam working to survey patients, interview nurses, and gather data regarding important information for the final product
• Coordinated with Grady leadership to gather data from the hospital database and meetings with nurses and doctors
• Created patient-flow maps to analyze the system for inefficiencies and remove specific activities with our product

Atlanta, Georgia

• Surveyed emergency department patients to gather data that would influence the design of our product
• Designed a potential implementation for recording a patient’s chief complaint that would be easy for patients to understand and would shorten the nurse triage process

Greater Atlanta Area

• Developed 12-month Revenue Management forecasting model to predict occupancy, rate, and revenue per available room based on competitive market trends, and supply & demand analyses using triple exponential smoothing.
• Automated data export processes to the company’s new B.I. system, by eliminating intermediate systems, to transfer data directly from source docs, while improving data accuracy and reducing export cycle time by over 90%
• Created portfolio roll-up reports of key compliance measures for Human Resources and Finance disciplines through aggregation of audit data to compare and benchmark performance of the company’s hotel and restaurant.
• Designed a day-by-day annual market segmentation optimization template for annual business planning purposes
• Analyzed revenue impact from new Hilton hotels, leading to Hilton providing $400,000 in franchise fee relief over 3 years.
• Automated data export processes to the company’s B.I. system, improving accuracy and reducing export cycle time by 90%

Pocatello, Idaho Area

• Implemented a weekly employee productivity report that included personalized employee dashboards with goal tracking andunit averages using Excel and VBA
• Built the infrastructure for a new program to track data center metrics through a dynamic visualized dashboard for Executivesto quickly view PUE, Rack Space, and IT Power Usage for all FBI data centers across the.
• Designed automated SharePoint workflows to perform tasks and inform specific contacts using user inputs

Atlanta, Georgia

• Performed a capitalization analysis of nitrogen generators for the building and the outcomes based on user inputs forspecified variables that affected the renewal of a 5-year $1,500,000 contract with our current liquid.
• Automated the required manipulation of data from the payment system, reducing the cycle time from weeks to minutes
• Analyzed spending trends among the 24 designated spending categories to influence PO purchases and deferrals
• Reported on the current balance for 15 operating projects with current trends and the calculated spending rate

Atlanta, Georgia

• Evaluated the Elections Codes for effectiveness and held weekly feedback meetings to affect the final versions
• Managed the multistage election process for the Executive Board

Atlanta, Georgia

• Simplified the residential policy violation adjudication process through flowchart and diagrams
• Processed the recruitment of 10 Associate Justices from a pool of 25 applicants
• Coordinated and managed the Student Conduct Boards meetings and budget

Atlanta, Georgia

• Elected Finance Chair of my residence hall in my first year to manage $4000 in funds
• Processed receipts from residents to quickly reimburse them for their purchases

Canton, Georgia

• Awarded 4 “Friendliest Cashier of the Week” awards over the course of 10 weeks from positive feedback, improving the locations Overall Satisfaction score
• Improved the Front-End Department’s efficiency through quick and efficient cashiering, becoming the fastest cashier

Canton, Georgia

• Minimized customer dissatisfaction by analyzing and working to quickly move through the cart collection, bagging, and restroom sanitation processes
• Assisted customers with locating essential needs throughout the premises in a kind and friendly manner

Bachelor'S Degree, Major: Business Administration, Concentration: Operations And Supply Chain Management

Activities and Societies: Honors Program

Education record