Summary
Overview
Work History
Education
Skills
Software
Timeline
Generic

John Mask

Data Analyst
Lutherville Timonium,MD

Summary

Talented professional considered knowledgeable leader and dedicated problem solver. Brings over twenty years of valuable expertise to forward company objectives. Attentive to detail with experience in coordinating projects, programs and improvements.

Overview

14
14
years of professional experience
5
5
years of post-secondary education

Work History

Material Planning Coordinator IV

BAE Systems
York, PA
10.2021 - Current
  • Provides support to the material planning and control function
  • Performed monthly audit of inventory
  • Prepares and monitors material requisitions and material schedules with production schedules
  • Maintained engineering specifications and production schedules within purchasing, warehouse, and production areas
  • Implemented extraction, transformation, and loading process to perform data extraction and merging to create data sets for reports and dashboards
  • Developed methods, techniques, and evaluation criteria for creating reports
  • Researched new ways to improve the efficiency of material planning and control functions
  • Schedule automated reports and dashboards to meet business requirements
  • Perform analysis and reconciliation of data used in dashboards
    Developed and tested different system and methods for reporting data
  • Developed and maintain professional and effective relationships with internal and external customers
  • Managed filing systems for electronic and hard copy documents to keep organized records.

Material Planning Coordinator III (Contractor)

BAE Systems
York, PA
07.2020 - 10.2021
  • Work with users to identify requirements and develop strategies to analyze data
  • Perform analyses from a wide range of requests using data in different formats and from various platforms
  • Strategize with end users to create new procedures and optimize existing queries
  • Create high performance data integration solutions to connect to multiple data sources
  • Used various statistical methods to analyze data and generate useful business reports

Technical Professional 1 Database Analyst

Wood Environment & Infrastructure Solutions
Beltsville, MD
01.2007 - 07.2018
  • Tested software to ensure compatibility with current systems through analyses of data output
  • Ran queries in SQL and Access databases
  • Strong ability to multitask and follow escalation procedures
  • Collaborated with client to develop automated system to perform inventory of computer hardware
  • Performed retrieval and analyses on 10,000 lane miles of pavement conditions data, GPS data, and images; which were used for budgetary decisions and asset management
  • Designed, recorded, and executed Visual Basic macros to process GPS data
  • Conducted formal presentations in the use of specific technologies to technical and non-technical audiences
  • Analyzed data by using Excel condition formulas, VLOOKUP, Pivot Tables and Pivot Charts
  • Demonstrated outstanding customer services skills, consistently receiving high ratings on client satisfaction surveys
  • Cleaned and verified the integrity of data used for analyses
  • Used various statistical methods to analyze data and generate useful business reports.

Education

Bachelor of Science - Computer Science

University of Maryland Global Campus
Adelphi Maryland
08.2013 - 12.2016

Master of Science - Accounting And Finance Management

University of Maryland Global Campus
Adelphi, Md
05.2021 - 05.2023

Skills

Computer Programming

undefined

Software

R

Oracle

Python

Dax

Matlab

VBA

Tableau

Power Bi

SQL

Excel (Pivot tables and charts)

Timeline

Material Planning Coordinator IV

BAE Systems
10.2021 - Current

Master of Science - Accounting And Finance Management

University of Maryland Global Campus
05.2021 - 05.2023

Material Planning Coordinator III (Contractor)

BAE Systems
07.2020 - 10.2021

Bachelor of Science - Computer Science

University of Maryland Global Campus
08.2013 - 12.2016

Technical Professional 1 Database Analyst

Wood Environment & Infrastructure Solutions
01.2007 - 07.2018
John MaskData Analyst