Andrew Fritz Email & Phone Number

Washington, Dc, Us

I help to provide the resources and information our HR community needs to support their functions, while also creating new data products to better inform and distribute HR metrics throughout our organization. |Notable Career Highlights at Northrop Grumman|Transformed and consolidated outdated Tableau workbooks inherited by outgoing team into more elegant solutions that ran 50% faster and leveraged data visualization best practices to present the information more effectively. Working with the Lead Reporting Analyst, participated in stakeholder engagement, and requirement gathering of current HR reporting activities of the entire company for migration into a new HR Information System. Lead reporting activities for the Core Human Capital Management portion (headcount, personal information, etc.) for the HRIS migration project.Responsible for company-wide headcount reporting that is used for accounting, licensing, and facilities management. Present report creation and review process to auditors to comply with SOX requirements.Respond to ad-hoc data requests from the HR community, as well as from the Executive Leadership Team and CEO.

Falls Church, Virginia

Washington D.C. Metro Area

Lead the development of Business Intelligence and Analysis reporting for the largest client base in the company, from developing data ingest plans for millions of rows of data into our Data Warehouse, to report creation and management with Tableau Desktop and Server.|Notable Career Highlights at FrontStream|Inherited an at-risk project to deliver client-facing reporting on our Client Management Web Application, and in four months turned the project around to successfully deliver a Minimally Viable Product (MVP).Took command of Business Analysis process, evaluated historical Voice-of-Consumer (VOC) documentation, and defined accurate business and technical requirements that aligned with project goals.Used Data Warehouse development best practices to revise an outdated table schema, which made data discovery easier and improved query performance by a factor of two.Leveraging Tableau to craft and curate visualizations used for our embedded client data reporting service.

Washington D.C. Metro Area

Responsible for the data quality and delivery of consumer-response and point of sale (POS) data, providing operational oversight and final approval for weekly, monthly, and quarterly data. Perform data quality checks and analysis on over 3,500 buyer transactions and 5 million unit transactions every week, using descriptive statistics for trend and outlier analysis. Review and approve application of population projection factors and unit/dollar benchmarking factors to point-of-sale data at the retailer level. |Notable Career Highlights at NPD |Maintained a 100% “on-time and correct” client delivery score for the past two years.Executed a complete data and system review for process integration into a Hadoop ecosystem.Migrated 17 years of acquired entertainment POS data into our company’s data management system. Developed data DQ procedure to review POS data pre-data close-out to maintain client delivery schedule.Drafted technical documents for use in the development of transforming end-user developed analysis fields into more stable and faster to process hard-coded fields.

Washington D.C. Metro Area

|Notable projects and Accomplishments|U.S. Department of Agriculture, Nutrition Assistance in Farmers Market StudyDeployed and implemented information management systems which collected data from over 4,700 participants. Conducted data merging, cleaning, and quality control procedures by programming data object rules into a database management system.Performed data harmonization between two distinct data sources to create a master data delivery file.Coordinated training and technical materials for a staff of five in survey collection and issue resolution.U.S. Department of Education, International Assessment of Adult Competencies (PIAAC)Spearheaded and managed main field office which served as the command center for four national regions, serving five field managers and over 75 data collectors throughout the U.S. Reviewed and applied international and U.S. occupation coding standards for over 5,000 unique rows of data using Microsoft Access. Supervised a team of five to build data collector on-boarding supply packages, check-in returned surveys, and respond to four Field Supervisor's supply requests.Collaborated with Statistical team in subdividing 50+ geographical areas to improve population sampling.Assisted the Geographical Information Systems department in the creation of over 500 large and small maps that were used in updating U.S. census information for study sampling.

Master'S Degree, Industrial/Organizational Psychology, 4.0/4.0 Gpa

Practicum on designing organizational structures for non-profit organizations, as well as developing job descriptions and training.

B.A., Psychology, 3.85/4.0

Activities and Societies: Phi Kappa Phi, Psi Chi, Psychology Student Association, Society for Industrial and Organizational Psychology.