Erick T. Bran Jr. adx5aq@r.postjobfree.com • 773-***-****

LinkedIn • Chicago, IL

Business Analyst Profile

Accomplished Air Force Veteran with an active Secret Service Clearance. Effective leader who excels at using proven methods and cutting-edge technology to cut costs, streamline operations and increase productivity successfully. Demonstrated ability to maintain a high level of accuracy in the review and entry of data. Assertive and enthusiastic, with extensive knowledge of process optimization and an unsurpassed work ethic. Areas of Expertise

● Project Management

● Data Analysis

● Visual Basic Application

● MS Excel/Access

● SQL, VSAM, JCL, COBOL,

XML

● Team Leadership

● Business Intelligence

● Customer Account Analysis

● Strategic Planning

Accomplishments

● Developed an MS Excel macro to extract MS Access reports, updated over 30 charts, and converted raw data to enable illustrations.

● Recipient of multiple awards throughout career for the display of exemplary work performance.

● Created a robust excel spreadsheet that tracked deployed equipment and designed a report that streamlined data processing which decreased 416 man-hours per year.

● Synthesized data to design reports and polished presentations, highlighted findings, and made recommendations for improvement.

● Compiled data from 4 different excel spreadsheets and incorporated it into one source document for the training program, this simplified reporting to Sr. Leadership which displayed an overview of individuals overdue in meeting training requirements.

Career Experience

United States Air Force, Spokane, WA 2019 – 2021

Operations Manager

Led a team of 62 across 5 work centers through 8k scheduled/unscheduled maintenance actions and 24K dispatches of 445 aerospace ground equipment (AGE) assess to support global operations.

● Provided data-based solutions to remove 42 minutes of data processing a day, estimated savings of 8.5 man-hours a week and 12.5 days a year.

● Performed analysis of technical and functional specifications to implement GPS tracking and field test, which led to a savings of $2M annually and 47k reclaimed man-hours.

● Collaborated with a small business to initiate new corrections and improvements to test eco-friendly biofuel used in maintenance equipment, the project awarded $300k to employ procedures and deeper insights.

● Validated data and action plans and revamped hazardous material program resulted in zero discrepancies during the inspection process.

Page 1 2

● Tracked, documented, and increased efficiencies through 3K spot checks, led to 2K repairs that supported 10 aircraft inspections, returned 9K hours due to early completion. United States Air Force, Wichita, KS 2015 – 2019

Training Instructor Supervisor

Oversaw of team of 7 instructors. Utilized effective teaching methodologies and tools and facilitated instructional training for 700+ military members and international students annually. Established clear learning objectives, identified needs, and supplied recommendations on programs and activities. Created PowerPoint presentations, prepared educational materials, and administered testing to identify areas of improvement.

● Developed impactful visuals and dashboards to familiarize 10 Major Command (MAJCOM) on the specific curriculum requirements needed in the future, served as a subject matter expert (SME) for the 2018 Stratification Conference.

● Provided analytical and administrative support on equipment accounts and safety practices for 5 agencies.

● Directed the key initiatives for a $1.5M Meteorology and Calibration program, managed reporting and any discrepancies pertaining to a $4M equipment account. United States Air Force, Marysville, CA 2009 – 2015 Technical Supervisor

Presided over 3 shifts and 27 employees that supported the scheduled and unscheduled maintenance on 530 aerospace ground equipment (AGE) assets valued at $22M. Dispatched equipment for maintenance activities and aircraft flying operations, coordinated scheduled inspections, and any other testing required.

● Administered over 100 technical equipment inspections, resulting in 20+ zero deficiencies with a passing rate of 96%.

● Utilized MS Excel to build out a reporting tool that tracked equipment status.

● Effected 520-man hours per year by orchestrating an equipment database that produced real-time status results automatically.

Education

Bachelor of Science, Computer Operations Technology Southwestern College, KS

Associate of Science, Instruction of Military Science Community College of Air Force

Associate of Science, Aerospace Ground Equipment Technology Community College of Air Force

Page 2 2

Contact this candidate