Zachary Norman

Zachary Norman

Reporting Analyst, Financial Planning & Analysis · Four Hands Furniture

Greater Seattle Area, TX

In My Own Words

Experienced analyst specializing in Power BI, DAX, SQL, and KNIME. Proven ability to analyze data, automate manual processes, identify trends, and develop meaningful dashboards.

Work Experience

Data Analyst

Four Hands Furniture

2022 – Present

* Designing Power BI reports and dashboards for multiple different business segments * Automating manual reporting using Knime * Creating DAX and SQL queries for reporting and ad hoc research * Thoroughly documenting projects in Confluence and Jira * Presenting findings, callouts, and reports to senior executives as well as immediate supervisors * Developing process improvements to prevent gaps and ensure accurate data collection. * Developed interim QMS using Airtable. * Utilizing Excel for ad hoc reporting: Pivot Tables, Power Query, VLOOKUP, GETPIVOTDATA * Ensuring proper data collection and documentation methods * Trained Junior Data Analyst in basic reporting and documentation standards/requirements * Participated in all phases of UAT Testing of new WMS. * Collaborating with business-unit leaders to identify and prioritize problems.

Junior Quality Analyst

Four Hands Furniture

2021 – 2022

* Developed and maintained quality assurance procedure documentation. * Collaborated with management to provide training on improved processes and assisted with creation and maintenance of quality training. * Developed training materials, SOPs and work instructions to supplement new team member on boarding. * Created Airtable process and Power BI dashboard that tracked discrepant material and helped reduce monthly discrepant material by 40% * Enhanced processes to ensure there were no gaps in data collection. * Compiled data and findings into Excel reports and PowerPoint presentations for company executives * Managed supplier corrective action reports and worked closely with overseas teams. * Prepared forecasts and identified trends in Power BI and Excel * Gained experience creating Power BI reports pulling data from Excel.

Quality Assurance Coordinator

Four Hands Furniture

2020 – 2021

* Managed inbound inspection and project teams - 2 Leads and 8 inspectors. * Documented labor hours and budget expenses for projects * Assessed, monitored, and reported on work progression. * Prioritized needs and delegated assignments to handle multiple projects simultaneously. * Compiled findings to present to company executives. * Performed follow-up evaluations to determine efficiency of corrective actions implemented by vendors. * Managed claims/chargebacks to carriers and vendors * Worked closely with overseas teams for root causes and corrective actions on product issues.

Education

Associates in Marketing

Austin Community College

2021 – 2023

Phi Theta Kappa Honors Society Austin Community College Honor Society National Society of Collegiate Scholars

Interests

ClimbingHikingWeightliftingFly FishingTrail RunningBouldering

Skills

Big DataProject ManagementReportingDAXKnimePower BISQLSystem TestingExcel

Industries

BikeGolfDiveCreative AgenciesFashionFishingLifestyleMoto & PowersportsMusicOutdoorRunSkateSnowStreetwearSurfSwimTechTriathlonWakeYogaHealth & FitnessOther