Summary
Overview
Work History
Education
Skills
Certification
Volunteer Experience
Timeline
Generic

CAROLYN A. MENDEZ

SAN ANTONIO

Summary

Accomplished Senior Data Analyst with a proven track record at Frost Bank and military enhancing data-driven decision-making and operational efficiency through expert use of Tableau, Power BI, and SQL. Spearheaded cross-functional tea ms to achieve a 97% fix rate in critical systems, demonstrating exceptional project management and analytical skills.

Overview

17
17
years of professional experience
1
1
Certification

Work History

Senior Data Analyst

Frost Bank
San Antonio
03.2023 - 08.2024
  • Presented metric dashboards using tableau and SQL queries from big data warehouse
  • Key personnel in quarterly budget planning and scrum projects to ensure bank was in-compliance and customers and investors were satisfied based on their needs
  • Managed and controlled backlogs using JIRA and other software such as teams, confluence, and Mural to collaborate with other teams

Project Manager

ISS
San Antonio
08.2022 - 12.2022
  • Led medium to large complex cross-functional projects and programs end-to-end using a formal ISS Global process
  • Managed the project scoping, initiation, budgeting, scheduling, implementation, and close out
  • Ensured all functions were on schedule, escalated, and resolved issues on 52 sites
  • Completed various projects in a timely manner and created high-level dashboard using Power Business Intelligence software for the management and stakeholders

Regional Maintenance Information System Manager/Senior Data Analyst

United States Air Force
Bossier City
11.2017 - 06.2022
  • Oversaw duties and responsibilities for 12 Air Force installations with over 31,000 personnel assigned, completed root cause analysis, quantitative, and regression analysis to identify and resolve major weapon system defects, garnering a 97% fix rate
  • Created procedures and work schedule during COVID-19 crisis for 12 personnel and coordinated plans with 5 additional cross-functional teams to ensure proper hygiene and safety instructions were set in place, resulting in an alternate work location
  • Audited aircraft utilization, modification, and work order data for 400 bomber aircraft and 500 Missiles worth $114 billion, identified negative trends and fixes, extracted, and presented critical data collection and reports to stakeholders using Power BI and SQL queries
  • Championed Maintenance Information Systems (MIS) by updating, reviewing, and upgrading two data systems after securing $812 million in funding for 75 program models
  • Managed and completed weapon system special studies by securing $7.9 million for nuclear upgrades and risk mitigation that identified 27 nuclear readiness deficiencies
  • Acted as the Principal Advisor to Director of Logistics, presented critical reports to 4-star general, Air Staff, and congressional leaders for B-52, B-2, B-1, E-4, and UH-1 aircraft
  • Wrote policies and procedures for Data Analyst career field across 9 Air Force bases and 3 Air Force Headquarters by designing database, using data modeling, and building report templates that served as major analysis tool for all analysts
  • Examined 4,000 records and reconciled 9 weapon systems that led to 1,200 data corrections for three Intercontinental Ballistic Missile bases, resulting in vehicle and equipment modernization
  • Collaborated with Lockheed Martin for missiles maintenance workshop that identified 27 action items, supporting development plan for $43.5 billion project
  • Managed site visit for 3 bases on network bandwidth issues and coordinated with 6 agencies that resolved 5 types of connectivity issues, reduced high-level priority to a lower level, ensuring 100% Air Force compliance
  • Tackled Integrated Maintenance Data System migration, advocated for 11 units, and mitigated 200+ maintenance information system capability gaps that reduced aircraft maintenance backlog from 5,000 to 0 in Air Force Global Strike Command
  • Championed Power Business Intelligence dashboards, briefed 24 meetings and completed 4 projects, resulting in 22 procedure upgrades and data mining effort by 75%
  • Compiled B-52, B-1, B-2 aircraft data and analyzed 5,700 sorties and 29,700 flight hours that led to critical decision-making in command’s logistic department
  • Strengthened maintenance information system security program, certified 14 accounts and 40 appointment letters, and granted access to 132 personnel, securing system from unauthorized access
  • Led 56 system managers and coordinated with 6 agencies and Program Management Office to facilitate defect resolutions that fixed 1,300 major system defects
  • Orchestrated possession code changes for Dyess and guided 10 aircraft transfers and code changes that maximized data reporting accuracy by 100%
  • Identified 32 missing database work unit codes and coordinated repairs between 4 agencies to correct mismatching codes between two maintenance systems that fixed errors in less than 24 hours
  • Analyzed 2 years of B-1 historical data and identified 818 main landing gear issues across B-1 fleet that led to errors fixed by engaging with system engineers
  • Examined B-52 job standard code listings, scrubbed 422 job inspections for aircraft availability development that resulted in headquarters leadership approval on job standard listing validation
  • Single Maintenance Information System Action Officer and partnered with Air Force Material Command on 65 matrix capabilities that aided data migration of 80 weapon systems

Manager, Maintenance Management Analyst

Travis Air Force Base
Fairfield
04.2014 - 10.2017
  • Analyzed maintenance system and key performance indicators and 334 million pounds of fuel to support 8,000 flight sorties and 39,000 flight hours, awarded Organizational Unit award
  • Overhauled C-5 pitch trim historical data, identified major findings which prompted to a fleet-wide one-time inspection and organizational improvement that saved $12 million worth of assets from obsolescence
  • Led 184 reports for maintenance briefings, presented 48 performance metrics to identify positive and negative trends that validated and corrected over 2,000 status hours, key to #1 Air Force Sijan unit award
  • Managed fleet health data visualization dashboard and accurate reporting, supported first transatlantic Air Force, and Marine F-35 fleet which led to the First Cuba visit of the President of the United States in 90 years
  • Team Lead to aircraft mishap investigation and audited 5-year history on 1,000 maintenance actions that identified 3 major contributing factors to aircraft incident
  • Scrutinized aircraft parts that needed repairs worth $22 million, increasing fix rate key performance indicator
  • Led largest team in Air Mobility Command and oversaw 58 aircraft with 16 key performance indicators to support 6,800 missions and 36,000 flying hours
  • Created 6 automated reports and slashed print queue and processing time that saved 80 man-hours monthly
  • Managed Health of the Fleet briefings for 33 key metrics, advised group leadership on negative trends, resulting an increase on 8-hour fix rate metric by 9%, awarded section’s Maintenance Operations Unit Team of the first quarter
  • Organized Wing Aircraft Repair Program and audited 1,000 deferred maintenance that was worth $22 million for repairs, increasing aircraft fix rate above the standard
  • Led 2-yr KC-10 Total Non-Mission Capable Supply study, examined 51,000 flying hours, and identified off-station issue, resulting in reduction of Non-Mission Capable time by 8%
  • Expert Point of Contact for Maintenance Information System, liaised with higher headquarters to instruct 312 personnel, and provided 37 courses to 6 units, enhancing system knowledge and proficiency by 15%
  • Authored Wing and Group Air Force Outstanding Unit Award package and partnered with base agencies that finalized group packages in less than 12 hours
  • Created combined Pilot Reported Discrepancy and Cannibalization reports and automated 720 forms that saved 1,400 man-hours per year and reduced cannibalization rate by 19%
  • Implemented KC-10 paperless A-Check inspection process for 31 personnel that made it a seamless transition with zero work stoppage, saving $6,600 per year
  • Analyzed 2,600 missions and 12,600 flying hours that drove decision making to support missions during Operation Enduring Freedom and Operation Inherent Resolved and Egypt
  • Conducted maintenance Continuous Process Improvement initiative and created automated man-hour report that replaced manual tracking and saved 1,200 of man-hours per year
  • Designed leadership Continuous Process Improvement Dashboard and aligned 6 organizations with objectives and goals that helped defined capabilities and strategic perspective
  • Organized 16 command-level key performance indicators, delivered 24 Health of the Fleet briefings to stakeholders that led to an increase on mission capable rate to 89.5% in Dec 2014 and the highest rate in 8 years

Operations Supervisor, Database Management/Data Analyst

Royal Air Force Mildenhall
Bury St Edmunds
01.2008 - 03.2014
  • Hosted Air National Guard Analyst visit, improved partnership, data mining, and enhanced KC-135 fleet health performance by 100% in Alabama Air National Guard
  • Completed 53 no-notice inspections and major briefings, resulted in zero mishap in organization for over 500 personnel, and achieved 'Outstanding' award on annual Safety inspection
  • Administered two information systems for 15 KC-135 valued at $795 million, identified system errors and automated audit process that saved 600 work hours per year towards aircraft maintenance process improvement
  • Managed Data Integrity, coordinated with three cross-functional teams, and analyzed 117 maintenance discrepancies that reduced 41% data error rate and improved on-time rate by 94%
  • Self-taught Monarch Software Program models that eliminated timely manual data manipulation, increasing organization productivity by 75%
  • Pivotal to Air Force Excellent rating for annual inspection
  • Analyzed depot process, audited 9,000 records, compiled aircraft analysis that aided engineers and contractors with heavy maintenance scheduling and prevented from $13.2 million documentation of errors
  • Led KC-135 Window study and investigated window change trend on 3 contributing factors that led to Air Mobility Command logistics crosstalk on major findings
  • Analyzed 5-year Auxiliary Pneumatic Unit Mean Time Between Failure and calculated every single rate that were used to calculate utilization rate, validation of bench stock supply levels was on target
  • Examined Operation Unified Protector mission hurdle and pinpointed excessive 401 man-hours and 120 aircraft cannibalizations due to foreign customs delays impact
  • Pulled KC-135 avionics history and validated 10,000 jobs that enabled engineer to isolate cause and stopped major failures on aircraft A4830
  • Orchestrated Squadron Safety SharePoint page and created section’s inspection log that enabled single source document and saved 364 man-hours annually
  • Discovered A0306 symbol document error and prevented major Wing inspection findings that contributed to Maintenance Group Excellent rating
  • Managed Squadron Safety program and created 63 Form 55 and 10 job safety training guidelines in less than 45 days for 6 units that led to Wing Safety Program outstanding rating for 3 years in a row
  • Developed commitment and aircraft availability tracker, presented to Wing Commander with optimum operation tempo plan, and provided critical analysis to United States of the Air Force in Europe regarding fleet updates
  • Inspected 352 Space Operation Group and found and corrected 7 discrepancies and 2 repeated discrepancies that contributed to Maintenance Group Unit Inspection with excellent rating
  • Database watchdog and identified major command personnel program issue that drove data correction in less than 16 hours
  • Analyzed 9,000 files, identified 1,200 of mismatched flying hours between wing and United States Air Force in Europe that prevented $13.2 million of documentation errors
  • Troubleshot information system data error and liaised with Air Mobility Command programmers that enabled accurate data documentation for KC-135 fleet by 100%
  • Managed group delayed discrepancy program and monitored 400 maintenance actions weekly, cutting maintenance backlog by 3.3%
  • Audited maintenance group data documentation and automated archaic audit process, saving 600 man-hours per year to aircraft maintenance

Education

Bachelor of Science - Accounting

Bellevue University
NE

Maintenance Production Management -

Community College of the Air Force
AL

Associates Degree - Accounting

Metropolitan Community College
NE

Master of Science - Finance

University of Texas
TX

Skills

  • Data Analytics/Findings
  • Microsoft Office Suite products
  • Work with a cross-functional team
  • Key Performance Indicator
  • Database Management System
  • Financial analysis and reporting
  • Big Data
  • Project/Program Management
  • Tableau and Power BI
  • SQL and JIRA

Certification

  • Google Data Analytics Professional Certificate, TX, 06/01/22
  • Texas Real Estate Agent, 11/01/21
  • United States Air Force Senior Non-Commissioned Officer Academy, Gunter, AL, 05/01/18
  • Anti-Terrorism Training, Level 1, CA, 01/01/17
  • Community College of the Air Force, Professional Manager Certification, AL, 06/01/16
  • Senior Leadership Course, Online Learning, 01/01/15
  • Joint Senior Leadership Professional Military Education, CA, 01/01/15
  • Mid-Tier Leadership Academy, Germany, 01/01/13
  • Mission Generation Course, United Kingdom, 01/01/13
  • Junior Leadership School, NE, 01/01/05
  • United States Air Force Honor Guard Protocols, Honors, and Ceremonies, NE, 01/01/04
  • Military Technical School, TX, 01/01/02
  • Basic Military School, TX, 01/01/02

Volunteer Experience

  • Prepared 600 military and civilian tax forms that saved taxpayers $100,000 in filing fees and recovered $842,000 in refunds.
  • Completed one year commitment to Offutt Base Honor Guard, performed 47 ceremonies and traveled 4,100 miles to honor their dedication and sacrifices of active duty, reserve, guard, veterans, and family members of veterans.
  • Led 25 personnel during civic leaders visit, organized cleanup, showcased Air Mobility Command strategic capabilities, praised and coined by Wing Commander.
  • Active Royal Air Force Mildenhall Team 5/6 member, contributed 6 hours for July 4th booth and Red Cross gift wrap, raised $1,400 for the unit.
  • Volunteered for 2 Joan Mann Sports Day benefits, raised $10,000 during the event that supported 350 disabled athletes.
  • Energetic Maintenance Operations Squadron Morale Club Vice President, organized and led 8 events, and raised $2,600 for the unit’s morale.
  • Organization Government Purchase Card Approving Officer, managed $150,000 annual budget and audited $110,000 in transactions that led to 3 Division Outstanding ratings for three years in a row.
  • Wing Top 3 Treasurer, led 4 events and 6 meetings, and recognized 2 airman of the month awards that raised $14,000, raised $14,000 to improve morale and quality of life base wide.
  • Completed Professional Manager Certification, selected as Wing Senior Non Commissioned Officer panel that mentored 49 members on Air Force changes.
  • Managed $7,800 computer hardware equipment, conducted annual inspection, and identified 6 computers to be replaced which led to 100% asset accountability.
  • Completed 30-hours Real Estate fundamentals course and scored 100% resulted in earning license in 2 months.
  • Hand-picked career field expert, utilized in-depth knowledge to develop thorough skill knowledge test for 60 eligible airman.
  • Maintenance Air Force Assistance Fund Office and led 7 workers and collected $5,000 with 46 donations, resulting in #1 to achieve group’s goal and crushed by 214%.
  • Wing Family Fun Festival lead, managed 88 personnel and 10 events that led to a success event with 700 attendees.

Timeline

Senior Data Analyst

Frost Bank
03.2023 - 08.2024

Project Manager

ISS
08.2022 - 12.2022

Regional Maintenance Information System Manager/Senior Data Analyst

United States Air Force
11.2017 - 06.2022

Manager, Maintenance Management Analyst

Travis Air Force Base
04.2014 - 10.2017

Operations Supervisor, Database Management/Data Analyst

Royal Air Force Mildenhall
01.2008 - 03.2014

Bachelor of Science - Accounting

Bellevue University

Maintenance Production Management -

Community College of the Air Force

Associates Degree - Accounting

Metropolitan Community College

Master of Science - Finance

University of Texas

Similar Profiles

CREATE PROFILE
CAROLYN A. MENDEZ