Ryan A. Bacaoco

Ryan A. Bacaoco

About

Detail

Data Analyst
San Diego, California, United States

Contact Ryan regarding: 
work
Full-time jobs
Starting at USD80k/year
Flexible work
Starting at USD42/hour

Timeline


work
Job
school
Education

Résumé


Jobs verified_user 0% verified
  • I
    Program Management Analyst
    Integrits
    Nov 2023 - Mar 2024 (5 months)
    • Updated and revised online computer-based training (CBT) modules for the NAVWAR Shore and Ship Installations via Adobe Captivate in support of NAVWAR 4.2.3 – Policy & Procedures Department. • Extracted and compiled data from datasets given by the Regional Maintenance Center Command Office (RMMCO) to generate views for specific ad-hoc reports for data analysis on metric performance on all Naval Installation Warfare Center (NIWC) in the Pacific and Atlantic regions. • Created metrics and visuals for data analysis on End of the Month shore and ship installation activities for Naval Operations within the Continental United States and abroad. • Attended weekly and daily TEAMS meetings discussing NAVWAR Policies and Procedures in referenc
  • Indus Technologies
    DATA ANALYST
    Indus Technologies
    Nov 2020 - Sep 2023 (2 years 11 months)
    • Provide supporting documentation to various Shore Installation and Modernization team stakeholders showing metrics for product planning, installation readiness, and completion progress. • Extract and compile data and generate views for specific ad-hoc reports from a proprietary repository called SPIDER (SPAWAR Integrated Data Environment and Repository). • Perform data analysis on reported materials, validating metric report intent. • Develop and implement specialized Excel reports and metrics assisting the government contract principals in the creation of new databases supporting shore installation management. • Provide data and Excel reports using VBA and MACROs for complex results requiring immediate analysis by PMW 790 Shore M
  • S
    COMPUTER SYSTEMS ANALYST II
    Strategic Data Systems (CoSolutions, Inc).
    Mar 2019 - May 2020 (1 year 3 months)
    • Supported and developed application and management processes for the Naval Air Command (NAVAIR), METROLOGY AUTOMATED SYSTEM FOR RECALL and REPORTING (MEASURE), utilized by aviation and maintenance community support centers (Calibration centers) worldwide to manage and report their calibration support. • Provided overall User Support and Help Desk services by maintaining and assisting with application development. • Ensured calibration standard operating procedures (SOPs) were current and updated as needed. • Scheduled reports were up-to-date and delivered to the appropriate recipients on a daily, weekly, or monthly basis. • Ensured MEASURE transactional data and inventory data exchanged between the METBENCH Calibration Management
  • E
    Computer Systems Analyst III
    EPSILON Systems
    Sep 2017 - Mar 2019 (1 year 7 months)
    • Ensured the Trial Balance reports, Authorization reports, USSGL Balance reports, and Labor reports generated from the STARS FL system were current and kept up to date. • Assisted finance staff by relocating their computer workstations to different office locations within the finance department area. • Resolved software-related issues (i.e., Excel or PDF) such as updates to existing Incoming Financial Documents or Access Database dashboard issues. • Created new financial reports for the Southwest Regional Maintenance Center (SWRMC) Finance Department to eliminate manual updates to spreadsheets and have them automated using Microsoft Access and Microsoft Excel 2016 VBA and Macros. • Performed backups to the Microsoft Access Database
  • Leidos
    JR. PROGRAMMER / ANALYST
    Leidos
    Jul 2016 - Sep 2017 (1 year 3 months)
    • Assisted Enterprise Architect and Sr. Software Developer with software-related projects. • Created, updated, and added new SQL Tables to the NHRC-Server as a test bed for new software development projects. • Imported and exported large datasets into the SQL Database. • Updated and modified forms for the Main Switchboard and Trouble Ticket Switchboard. • Tasked to the Workstation Inventory project to update and modify records in the SQL Database of all NHRC PCs and Laptop devices, including updating personal information and current location of all NHRC Employees. • Debugged SQL Database Objects for FPS and DHAPP Central with the use of SQL queries and commands for any data management manipulation. • Monitored the daily u
Education verified_user 0% verified
  • Florida Institute of Technology
    Master's Degree in Database Administration
    Florida Institute of Technology
    Sep 2016 - Oct 2018 (2 years 2 months)
  • P
    Bachelor's degree in Information Technology
    Purdue University Global Online
    Aug 2008 - May 2016 (7 years 10 months)
Projects (professional or personal) verified_user 0% verified
  • U
    Updated Calibration
    Management System (MCMS) and the MEASURE Operation Control Center (MOCC) Oracle database system is accurate and up to date, which involved using SQL Queries and Functions from an Oracle Relational Database embedded in a CITRIX environment. Any issues with the query, import function, or export function I would troubleshoot resolving myself by running the statement in a test environment, ensure the tables still existed, the conditions that were set wasn't missing any texts or required punctuations. And if tests failed after running the query multiple times, I would work with the Sr. Database Developer to seek a resolution. data by importing large datasets from MCMS to the Naval Air Command, Oracle Database System called MEASURE, while extract