Matthew McCarter
Oklahoma City,OK
Summary
Results-driven analyst with a proven track record in enhancing report comprehension and presentation. Detail-oriented with a knack for excelling in fast-paced environments. Strong communication skills to engage with executive leadership and foster internal business relationships.
Overview
21
21
years of professional experience
Work History
Data Analyst
Northrop Grumman
10.2024 - Current
- Produced monthly reports using advanced Excel spreadsheet functions.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Utilized data visualization tools to effectively communicate business insights.
- Used statistical methods to analyze data and generate useful business reports.
- Generated standard and custom reports to provide insights into business performance.
- Developed and implemented data governance policies and procedures.
- Developed customized reports, summarizing and presenting data in visually appealing format.
Data Analyst
Tinker Air Force Base
12.2019 - 07.2024
- Collect and maintain evidence needed by financial auditors to examine IT and financial controls
- Assisted in conducting qualitative and quantitative analyses to assess and enhance supply chain management processes, data, and systems
- Researched and prepared presentations for Flight Directors regarding proficiency, policies, and internal operating inefficiencies
- In charge of daily Execution and Prioritization of Repairs Support System (EXPRESS) report
- Designed, built and maintain Excel projects, including for other departments, this assists with analysis, and reporting
- VBA skills utilized during these processes
- Reverse engineered previous Access projects, this assists with metrics, data gathering, data storage
- Built multiple slicers, pivot tables, and charts for reporting to multiple departments, assists with data gathering, data storage and organizing
- Data mining and data analysis for multiple departments in the Air Force
- Collaborate with clients troubleshoot problems and evaluate improvement opportunities to implement in system and process changes
- Designed robust, scalable, and secure web-based applications to ensure the continuity of all processes and client satisfaction
- Used the Python language to develop web-based data retrieval systems
- Created and maintained SQL databases for supply side and transportation records for the Air Force.
Project Manager/Business Analyst
SONIC CORPORATE
09.2014 - 11.2018
- Overseeing all ordering, installation and testing of technology equipment inside Sonic stores nationwide
- In charge of 3 to 4 million dollar projects
- Responsible for monitoring and auditing Project Managers
- Capturing and analyzing all related data, metrics relating to new store roll-outs
- Worked with outside vendors to integrate their data and communications with the Sonic brand
- Utilized SQL, data warehousing programs, Tableau, and other dashboard/visualization toolsets
- Point person in creating queries, handle all software related data analysis/reports
- Designed and built database for project to retain all data points that are used for empirical analysis
- Hybrid position composed of both Business Analyst and Application Analyst responsibilities
- Analyzes the business needs of stakeholders, using business analysis tools to help identify options for improving business systems and processes
- Conducted current state analysis of systems and procedures, gathers initial requirements, identifies scope and objectives for system changes and documents workflow
- Created custom reporting using VBA for Excel for my department and several directors
- Performed analysis and presented results using SQL, MS Access, Excel, and Visual Basic scripts
- Collaborated with project managers, legal counsel, and other team members to gather data for projects
- Assisted with benefits analysis and recommends system design modifications to promote additional utilization or improve performance, productivity, or cost savings
- Developed, analyzed, and compared cost of purchase, implementation, development or enhancements to current systems and methods
- Worked with project team detailing implementation tasks, functional and integration testing, training, conversion schedules, documentation, and user training
- Assisted with determining project budgets, hardware requirements, and resource requirements for user departments and IT staff
- Developed plans or scripts for functional, system, integration, volume, parallel, stress testing and actively participates in testing efforts
- Developed and maintained systems documentation, policies and procedures to support new functionality and processes
- Provided mentorship, guidance, and training to Business Analysts and End Users.
Ultrasound Technician
RADIOLOGY CONSULTANTS
05.2010 - 09.2012
- Responsible for performing all vascular studies
- In charge of supply management
- In charge of all IT related functions pertaining to the clinic
- Liaison for all sales, and supply representatives
- Excelled in creative thinking and problem solving
- Worked independently and unsupervised.
Data Control Specialist
AMERICAN INFOSOURCE
02.2007 - 09.2008
- Automating the data acquisition and analysis of importing bankruptcy records
- Oversaw all network traffic, automation and insured all data was transferred properly and on time.
Materials Planner
CIRCOR ENERGY PRODUCTS
05.2004 - 09.2006
- Keeping production flowing smoothly with the needed parts and materials
- This is a multimillion dollar company which had just transitioned to a just-in-time process
- Ensured an efficient supply chain was met consistently
- Handle release of orders of materials and tracking of work orders.
Education
Bachelor of Arts - Economics
UNIVERSITY OF CENTRAL OKLAHOMA
University Of Central Oklahoma05-2015
Liberal Studies, B.A. - undefined
UNIVERSITY OF OKLAHOMA
Skills
- Secret Clearance
- Last adjudicated Mar 2020
- HTML/CSS
- Microsoft Access
- Microsoft Excel
- Microsoft OneNote
- Microsoft Outlook
- Microsoft PowerPoint
- Microsoft Publisher
- Microsoft Word
- VBA for Excel
- OneDrive for Business
- POS Systems
- Process Integration
- Program Implementation
- Project Management
- Python
- SQL
- System Integration Testing
- Systems Analysis
Timeline
Data Analyst
Northrop Grumman
10.2024 - Current
Data Analyst
Tinker Air Force Base
12.2019 - 07.2024
Project Manager/Business Analyst
SONIC CORPORATE
09.2014 - 11.2018
Ultrasound Technician
RADIOLOGY CONSULTANTS
05.2010 - 09.2012
Data Control Specialist
AMERICAN INFOSOURCE
02.2007 - 09.2008
Materials Planner
CIRCOR ENERGY PRODUCTS
05.2004 - 09.2006
Liberal Studies, B.A. - undefined
UNIVERSITY OF OKLAHOMA
Bachelor of Arts - Economics
UNIVERSITY OF CENTRAL OKLAHOMA
Similar Profiles
Allisyn GeorgeAllisyn George
Illustrator III at NORTHROP GRUMMANIllustrator III at NORTHROP GRUMMAN
Alexis TinajeroAlexis Tinajero
Precision Electromechanical Assembler at Northrop GrummanPrecision Electromechanical Assembler at Northrop Grumman
Angel JuradoAngel Jurado
Level 2 Painter at Northrop GrummanLevel 2 Painter at Northrop Grumman
Christopher SuadiChristopher Suadi
Aircraft Structures Mechanic at Northrop Grumman CorporationAircraft Structures Mechanic at Northrop Grumman Corporation
Kaylynn NormandKaylynn Normand
Phlebotomist-PSR II at Diagnostic Laboratories of OklahomaPhlebotomist-PSR II at Diagnostic Laboratories of Oklahoma