Sandy Ward Email & Phone Number

Virginia, United States

• Develop and analyze business performance reports (e.g. for claims data, provider data, utilization data) and provide notes and areas of concern dealing with performance deviations and anomalies.• Create, publish, update and maintain dashboards and reports (daily and ad hoc) in systems such as Power BI, SSRS, Power Pivot, SAS and some Python• Navigate business issues and determine the best way to develop appropriate diagnostic and tracking data that will translate business requirements into usable decision support tools.

Newport News, Va

• Gathered pricing quotes from various sources for Industrial customers via phone and email• Build Excel matrix database for Lead Generation Team to track a lead from the starting point to a contract/agreement win or loss for the team

Newport News, Va

• Liaison between Ferguson associates and IT professionals that assesses specific needs and requests for information • Built customized COGNOS reports and queries based on the needs of the business• Researched IT service tickets from Version One in order to prioritize importance and time management with the development teams and the business• Coordinated and facilitated meetings to gather project requirements and translate needs to technical team • Wrote user stories to translate and present business needs to the technical team during bi-monthly Sprint meetings

Newport News, Va

• Created and maintained monthly sales and gross profit tracking reports averaging upwards of $30M in Sales and 22% Profit• Assessed specific needs of branch/customer requests for information and (when necessary) buildcustomized COGNOS reports and queries based on their needs• Managed pricing files, contract deadlines and rebate accruals and payments• Created Key Performance Indicator graphs based on specific customer needs and contracted requirements• Updated and managed the Industrial Pipeline page to ensure data is accurate and available for all Industrial users

Newport News, Va

• Created and maintained spreadsheets for four Regional Recruiters covering the US • Organized and executed logistics for recruiting material for all campus events • Built and maintained inventory databases using Excel• Prioritized and allocated all costs and monetary resources of the recruiting budget • Researched shipping and receiving for time sensitive materials and documents• Researched event dates for future semesters

Newport News, Va

• Created and maintained files for approved location expansions approved by the Finance Committee Meetings each month• Update the Master Project Listing with current status information about ongoing projects • Established project files with Landlord Contributions• Determined monthly cost and depreciation for projects being presented to the Finance Committee• Generated the Finance Committee Agenda each month

Newport News, Va

• Printed daily vendor reports• Determined payment information and if a W9 is needed for taxation purposes and collected the Federal Tax ID numbers for verification on the IRS website• Made remittance address changes for all Junior Associates• Performed daily data entry and maintained vendor files • Created and maintained Excel databases for Integrated branches • Trained new associates as needed