Brandon Laughlin, Ms Email & Phone Number

Fort Belvoir, Va, Us

As a GS-1501-14 in the Defense Logistics Agency’s Workforce Planning & Analytics (J12) division, I serve as a subject-matter expert (SME) in HR analytics – working closely with our strategic workforce planning, manpower requirements, and culture branches. I facilitate cross-functional collaboration and coordinate data-driven projects with non-technical users, ensuring alignment with agency goals and effective communication with stakeholders. I regularly leverage programming languages such as Python and SQL to automate repetitive, manual HR processes as well as process large amounts of data from various sources. In this position, I also design, develop, and deploy a variety of strategic dashboards that effectively display key performance indicators (KPIs) and insights that are used by senior leadership to influence agency business decisions.Skills:• Demonstrated expertise in Python programming and utilizing libraries within restricted environments such as DoD and DLA• Skilled in data analysis, including streamlining practices, leveraging data insights from various sources, and developing strategic dashboards for senior leadership• Ability to automate HR processes related to manpower and workforce planning, leading to significant time savings and increased data accuracy• Experienced in developing customized dashboards using tools like Qlik Sense and PowerBI, focusing on key metrics and KPIs crucial for informed decision-making• Experienced in developing customized algorithms for use in data-driven decision making and strategic planning initiatives

Washington, Dc, Us

As a GS-1515-13 in the US Coast Guard’s Workforce Planning & HR Analytics (CG-1B2) division, I served as a subject-matter expert (SME) in HR workforce planning and analytics - specifically diversity and inclusion (D&I) efforts. I utilized advanced analytical techniques and tools to collect, analyze, and interpret HR data related to the civilian workforce, identifying trends, patterns, and insights that informed workforce planning strategies and decision-making. I regularly created and maintained data models that captured the composition and demographics of their civilian workforce, designing algorithms, statistical models, and simulation tools to forecast workforce needs, evaluate staffing requirements, and support succession planning initiatives. Working closely with HR professionals, management personnel, and other stakeholders, I regularly identified areas for improvement and recommend data-driven solutions to optimize workforce utilization, recruitment, retention, and training efforts. I also leveraged programming languages and automation tools to streamline data collection, analysis, and reporting processes, including developing scripts, algorithms, and applications that automated repetitive tasks and enhanced the efficiency of workforce planning operations.Skills:• Strong data modeling and query optimization skills, enhancing efficiency and accuracy of HR data• Experience in developing APIs and integrating external data sources for workforce analysis• Advanced proficiency in data visualization tools and techniques for effective communication of insights• Knowledge of Python and SQL for automation, data manipulation, and visualization purposes• Subject-matter expertise in civilian workforce planning, diversity, and inclusion• Strong leadership and team management skills, demonstrated through leading contractor teams and working collaboratively with military and data teams

Washington, Dc, Us

Duties:As a volunteer OGC PowerBI Engineer, I was responsible for providing the American Red Cross Office of General Counsel (OGC) with services, solutions, and training to leverage legal data and reporting functions using Microsoft PowerAutomate and Microsoft PowerBI. Using data analytics to help empower the organization to make data-driven decisions, I trained OGC internal teams to design, build, and implement advanced automated reporting functions. I also assisted with evaluating and cleaning existing datasets for optimizing data visualizations and analysis. Accomplishments:• Developed and implemented a new labor and employment tool that identified $500K+ in settlement costs, categorizes claim types by location, and allows senior leadership to identify areas of concern to focus attention on• Successfully designed and applied an automated process for capturing and recording external conflict of interest data for thousands of employees, volunteers, and board members annually; utilizes Microsoft Forms, PowerAutomate, SharePoint, Excel, and PowerBI• Developed a new automated process for OGC’s Investigations, Compliance, and Ethics division that reduced the amount of manual labor required for their quarterly concern hotline reporting by 320+ man-hours annually• Developed and implemented a new tool that automatically processes the extract, transform, and load (ETL) activity for diversity data on outside counsel hires; provides decision support to senior leadership that allows for identification of deficiencies compared to industry standards• Provided a briefing over “The Importance of Data Analytics” to 20+ senior and executive American Red Cross leaders discussing organizational strategies for further implementing data analytics

Washington, Dc, Us

Accomplishments:• Developed and implemented a new tool within the DoD PowerBI platform as the integrated solution for providing up-to-date business intelligence regarding costs of AFSC partnerships. Prior to the development of this tool, sustainment center FM had no feasible options for analyzing partnership data. This tool now allows senior leadership at AFSC/FM, ALC/FM,SCOW/FM, SCMW/FM, and ABW/FM to evaluate partnership workload and create reports which can ultimately support leadership in recovering hundreds of thousand of dollars in lost potential revenue over the next few years• Effectively communicated cross-organizationally with 86 different individuals (representing 48 different organizations) to successfully create a new process that automatically extract and combine data from multiple Legacy systems throughout the sustainment center• Networked with individuals throughout the Army, Navy, SAF/FM, 448th SCWM, Ops Research branches in AFMC, A1,and A5, as well as other AF commands and organizations to identify and implement new data analytic capabilities for both our directorate and sustainment center - enhancing our directorate's effectiveness and readiness in supporting our warfighters• Pursued professional development training that has allowed the opportunity to enhance problem solving solving, communication, and leadership skills through real-world experience. Proven that my professional development training provides a significant return on investment to my organization, as can be seen with the development of the PowerBI True Cost of Partnership (TCP) tool (based on information gained while attending the Professional Financial Manager's Course)

Washington, Dc, Us

Accomplishments:• Amply skilled to devise complex algorithms and active lookup to simulate effect of a proposed compensation package to recruit and retain science and engineering candidates; vetted by three cost divisions – solid - high fidelity estimate for decision support to AFSC/EN SES• Hand selected AFSC/FM pathfinder to stand-up data science and analytic capabilities in FM; by networking learned of free tools and software; focus groups I initiated with FM division found prospective value-adding initiatives• Knowledgeable and reliable to respond to four-star general information need; compiled all O&S costs for the B-52 (1999 through 2020) from AFTOC and answered questions posed by the Wall Street Journal to Global Strike Commander• Guest lecturer for the Premier College Intern Program, personally crafting a briefing about cost estimating from my internship experience; with only days of notice after PCIP forced to virtual mode because of COVID, skillfully brought practical knowledge to new-to-the-AF interns• Winner of the 2020 AFSC Home & Staff Rookie of the Year award• Selected as a 2021 AFMC FM Rising Star

Washington, Dc, Us

Accomplishments:• Independently prepared 4 program office estimates over $300M in scope – exceeding expectations for a second year Palace Acquire intern• Proved value of CIP purchase based on inability of current blade rotor inspection to meet turn-around time due to increased workload as well as saving $1.3M in future overtime• Beta-tested a TDY estimating factor model; proved that we could save 3 days workload in an estimate with 70 forecast trips to 14 locations – validating the model and enabling wider distribution through AFLCMC• Lead Analyst for AFLCMC/HBDH program – identified potential propriety of funding concern in software, whether R&D or Investment; program office accepted concerns, elevating issue and avoiding propriety of funds issues• Lead Analyst for ALCM program; identified an omitted cost, avoiding a shortfall in installation costs• Analysis revealed that a Computer Tomography scanner could generate $16.6M in labor efficiently over the life of the equipment• Winner of AFSC/FM Quarterly Award of Excellence for GS-09 – GS-12 for outstanding financial management services for FY20 1st quarter

Washington, Dc, Us

Spotted disconnects in program CARD – program office changes didn’t match requirements documents; saved program from developing un-executable plan

Edmond, Ok, Us

• Ensured University compliance with state and federal statutes• Provided professional development training to University cardholders• Analyzed extensive amounts of data and compiled detailed audit reports• Audited approximately four-hundred cardholder statements each month

Edmond, Ok, Us

• Suggested organizational budget improvements that increased efficiency• Analyzed financial information to ensure all operations were within budget• Performed various duties using Oracle Fusion Middleware (Banner) software• Presented annual budgets to college deans, department chairs, and committees

Edmond, Ok, Us

During my tenure as the Speaker of the House for the University of Central Oklahoma Student Association (UCOSA), I was responsible for serving a student body of approximately 16,428 undergraduate and graduate students. I oversaw an approximately $2 million budget, authored and sponsored over fifty legislative bills, and managed the activities of seven congressional committees comprising over fifty elected congressional senators. In this position, I regularly acted as the bridge between students and university administration, playing a pivotal role in shaping university policies that directly impacted the student body.Accomplishments:• Demonstrated exceptional leadership qualities throughout my tenure as Speaker of the House, providing clear direction and fostering a culture of teamwork within the UCO Student Association• Successfully managed an extensive budget of approximately two million dollars, meticulously overseeing financial allocations and ensuring optimal resource utilization for the benefit of the student body• Drove the development and authored legislation that had a significant impact on university policies, resulting in tangible, positive changes within the institution• Acted as a conduit between students and university administration, establishing open and productive channels of communication; ensured that student concerns were heard and addressed, ultimately enhancing the student experience• Expertly managed the activities of seven congressional committees, skillfully coordinating the efforts of over fifty senators; this involved setting strategic goals, delegating responsibilities, and ensuring committee objectives were met efficiently

Columbus, Ohio, Us

• Assisted customers with purchases• Prepared marketing twice a month for significant floor set changes• Processed approximately one-hundred boxes of freight, three nights a week

• Resolved customer conflicts• Managed the tasks of over thirty associates• Balanced approximately fifteen registers each night

Master Of Science - Ms, Business Analytics

Bachelor Of Science - Bs, Accounting

Bachelor Of Business Administration - Bba, Business Law

Bachelor Of Business Administration - Bba, Business Administration And Management, General

Squadron Officer School, Military And Strategic Leadership

Professional Financial Management Course (Pfmc), Financial Management