Erick T. Bran Jr.

• In my current role as a Data Analyst Trainee at IT Expert Systems, I have designed and deployed interactive Power BI dashboards that track KPIs, uncover trends, and drive operational improvements. My projects include:
• NextGen Job Analytics Dashboard: Delivered insights into skills demand, salary trends, and workforce planning through dynamic filtering, KPI scorecards, and mapping visualizations.
• Airbnb Analytics Dashboard: Analyzed price trends, occupancy rates, and top neighborhoods to highlight seasonal demand patterns and profitability drivers.
• Education & Spending Dashboard: Consolidated and cleaned multi-source datasets to uncover enrollment and budget allocation trends.
• Before transitioning into analytics, I served over a decade in the U.S. Air Force, where I led teams of 60+, managed $445M in assets, and implemented reporting solutions that saved thousands of man-hours and millions of dollars. That background honed my ability to thrive in high-pressure, detail-driven environments — qualities I bring to every BI project I take on.

· Directed a 4-member development team to build a VBA-powered Excel system tracking the training progression of 450 personnel across 12 agencies; reduced manual input by 42 minutes/day, saving 12.5 workdays per year. Submitted to Airmen Powered by Innovation (API)

· Commanded 62 personnel across 5 work centers, executing 8K maintenance actions and 24K dispatches for 445 aerospace ground equipment (AGE) assets, directly supporting local and global flight operations

· Delivered fleet-leading readiness with a 94.3% FMC rate and 1.3% maintenance rate for aerospace ground equipment supporting flight operations; exceeded performance benchmarks and ensured sustained sortie output

· Created and deployed an Organizational Planning Board to streamline weekly task delegation and ownership, improving accountability and internal communication

· Led GPS integration and field test for asset tracking, recovering 47K man-hours and saving $2M annually: enhanced sustainment logistics visibility and reduced downtime through real-time equipment monitoring

· Partnered with a small business to pilot eco-friendly biofuel in AGE maintenance operations; results secured a $300K contract award to scale sustainable sustainment procedures Air Force–wide

· Guided end-to-end compliance reform for hazardous materials and safety protocols, mentoring 9 personnel and achieving zero discrepancies during a Washington State inspection: enhanced sustainment safety standards and regulatory alignment across maintenance operations

· Collaborated with cross-functional teams and key stakeholders to analyze sustainment performance data, identify root causes of system degraders, and implement proactive strategies that increased uptime and improved fleet readiness

· Built and managed an advanced Asset Tracking System using VBA, formulas, Pivot Tables, and data validation tools in Excel to oversee $15M+ in mission-critical equipment; ensured configuration accuracy, audit compliance, and zero discrepancies during federal inspections. Contributed to the 2019 Team of the Year Award

· Engineered advanced Excel-based performance tracking program using Power Query, Macros, Pivot Tables, formulas, and dynamic speedometer charts to visualize AGE asset readiness, streamline preventive maintenance, and optimize resource allocation

· Trained and supervised 7 instructors; delivered technical training to 700+ military and international students annually

· Managed $4M in training equipment and oversaw lesson development

· Appointed as Information Awareness Officer to validate and manage domestic and international student packages for secure network access

· Modernized the Asset Tracking Program by creating an Excel GUI and scripting automation using VBA

· Implemented LEAN process improvements that streamlined workflows and reduced waste across teams

· Designed and implemented an automated equipment status tracking system using Excel (VBA, Power Query, formulas, conditional formatting, and dashboards) to provide real-time fleet visibility; performed ongoing data analysis to monitor trends, improve accuracy, and reduce manual tracking, saving 520 man-hours annually.

· Appointed Equipment Custodian for five high-value accounts, overseeing mission-critical asset compliance, readiness, and lifecycle management; conducted asset utilization analysis to support decision-making and ensure audit-ready accuracy.

· Led and executed 100+ equipment inspections, achieving zero QA deficiencies across 20+ evaluations; earned QA Honor Roll and maintained a 96% pass rate, reinforcing sustainment excellence.

· Oversaw preparation for the 2011 Unit Compliance Inspection, inspecting 500+ assets to meet DoD regulations; efforts ensured operational certification and audit readiness.

· Contributed to unit-level excellence that earned the first-ever Best Unit Award, reflecting mission-wide performance improvement and readiness culture.

· While deployed, designed an Excel-based tool for Rush Medical Hospital to extract and transform Access report data into 30+ automated medication dosage charts; recognized with a STEP promotion for innovation and impact.

· Planned and led the reconstruction of a deployed maintenance shop, establishing three major sections including a hazardous materials program, tool accountability system, and an equipment status tracker; recognized as a Superior Performer by the Inspector General.

· Oversaw 93 aircraft (U-2, RQ-4, MC-12, T-38) valued at $3B across 3 shifts and 9 personnel; coordinated scheduling, inspections, and deployments

· Utilized IMDS to access, modify, and analyze aircraft data, including flight hours, inspection schedules, operational status, and global location tracking (home station/deployed); provided secure, real-time insights for senior leadership briefings. Leveraged advanced Excel tools (VBA, Pivot Tables, formulas) to build utilization models, track rates, and align aircraft performance with operational KPIs.

· Created automated aircraft maintenance report system/database utilizing MS Excel/VBA. Streamlined data processing / cut 416 man-hours/year.

· Automated the Data Analysis Section’s deficiency program using VBA and complex formulas, reducing 50 man-hours weekly

· Streamlined Senior Leadership briefings by centralizing multi-agency data sharing; analyzed info flow and created a unified hub to enable real-time fleet status updates and enhance operational visibility.

· Awarded 'Maintenance Professional of the Year' and 'Supervisor of the Year' for leadership excellence