Zachary Smith

• Automated manual reporting processes and designed a suite of tools to support products by developing robust scripts with Power Query, VBA, DAX and SQL.
• Worked with customers across Naval Shipyards to design business tools and visualization-based reports & interactive dashboards via Power BI and Tableau.
• Analyzed business process requirements and engaged with key stakeholders to develop methodology for new metics, KPIs, business tools, and analyses.
• Modified & scheduled queries to extract AIM data and completed weekly, daily and ad-hoc data requests received by SMPG.
• Identified data sources, defined data collection methods and determined appropriate analysis techniques.
• Facilitated graphics-based presentations, demos, and briefs to leadership and working groups. Built visualizations that enabled users to quickly interpret results from complex analyses.
• Provided ad hoc analysis of shipyard performance data and generated graphical presentations for high level Navy and congressional briefings.
• Audited internal data and processes to validate ETL process and data accuracy.
• Provided technical support for existing reports, dashboards or other tools.

• Directly supported SMPG leadership to conduct a strategic review and develop a Core Competency Model for each division of SMPG.
• Created dynamic Employee Survey that had over 2,000 total questions.
• Developed an HR database and schema for SMPG leadership.
• Analyzed data to identify patterns or trends.
• Facilitated meetings across divisions and with leadership
• Developed process maps, flowcharts, and diagrams to supplement user manuals, process specifications, quick reference guides, troubleshooting procedures and other related materials.
• Created presentations to showcase strategy results, insights, and recommendations and facilitated meetings with divisions & leadership.
• Documented existing process flows and identified gaps in the current system.

• Designed an IT Database & User interface tool to track assigned government assets for SMPG's facility manager.
• Supported SMPG's Operations Division's strategic analysis initiative during the summer of 2020.
• Designed and implemented strategy to gather customer feedback from several sources including surveys and division wide meetings to identify strengths, weaknesses, opportunities, and threats each division was facing.
• Created presentations to showcase strategy results, insights, and recommendations.
• Presented findings to management and executive leadership with action items
• Identified key metrics to measure the success of initiatives and campaigns.

Dean of Students: Office Manager Assistant (2017-2020)
The Dean of Student’s Office oversees Old Dominion’s Student Engagement and Enrollment Services, including all Student Affairs and Support Services.

• Extensive use of Microsoft office, including graphics-based reports
• Created an Information system to collect and analyze data on office calls and aid in the revision of the office assistant job design and training materials.
• Managed and ensured security of sensitive PPI data
• Designed and managed inventory tracking system.
• Managed Calendars for employees and conference rooms
• ROAR Award: Recognized for outstanding work and behaviors that support the mission, goals, and values of the Old Dominion University community