GALE GAMBOA

Detail-oriented Staff Business Architect with 8+ years of experience in driving cross-functional process and systems improvement projects, adept at translating complex business needs into actionable insights and measurable metrics. Expert in collaborating with business stakeholders to identify and define process or systems improvements, including documenting as-is and to-be business processes. Proven ability to develop use-cases and business requirements for system changes, facilitating training and roll-out of process or tool changes, and ensuring business acceptance for implemented solutions that enhance efficiency and transparency. My commitment to actionable, pragmatic solutions and ensuring projects get done aligns perfectly with your team's objectives. ID: 46025

• TS, SCI, 1998-2011
• Secret, 2011-2023
• Favorable Adjudication/CE T5R, 03/2019

• SlateMaker 2.0, Redesigned and modernized a RDBMS for executive slating and succession planning, creating a faster, network-connected repository that enhanced accessibility, visibility, and performance., Reduced data entry errors rates by >99% through the development of standardized user-friendly database interface forms., Innovated the development of a searchable candidate repository integrated with Active Directory and Single Sign-On (SSO) protocols, enhancing data governance and ensuring compliance with PII regulations for over 500 executive slate candidates., Eliminated previously used practice of separate locally kept 40+ spreadsheets used as slating templates cutting consolidation of disparate files and ensuring data configuration management integrity., Facilitated User Acceptance Testing (UAT) and user training sessions for customized tool, ensuring 100% functionality., 24/7 visibility of all other users' inputs with instantaneous metrics and data visualization via ODBC to Tableau, SharePoint and MS Access., Engineered and implemented a cutting-edge governance framework by integrating automatic DEI tracking into candidate slating processes, ensuring data accuracy and accountability; increased diversity hires by 40% and improved compliance monitoring efficiency by 50%.
• Position Management Tool, Designed and developed an efficient cloud-based position management application for 30+ Workforce Planning Focals and BDS Engineering Site Consolidation Team, ensuring efficiency and improving HR service quality during a major site consolidation initiative., Successfully deployed a high-performance multi-user application by implementing a split database architecture, leveraging a custom-built MS Access front-end interface and a cloud-hosted SQL Server back-end, adhering to 100% of project timelines and budget constraints., Real-time visibility and instantaneous status reporting of 3000+ employees and position movement over four US locations.
• Return to Service tracking for Commercial Airplane Group, Designed 'Good To Go' Tracking reporting capability supporting the labor/personnel Return to Service forecasting initiative using Microsoft Excel automation tools., Created Pivot Tables, Vlookup macros and Power Query solution to automate consolidation, cleaning, and transformation of tracking data from multiple Excel spreadsheets submitted daily by HR Business Partners, saving >200 man-hours weekly., Secured 100% quality data configuration management and version control.