Work Preference
Summary
Overview
Work History
Education
Skills
Timeline
Generic
Roberto Morgan
Open To Work

Roberto Morgan

Chino,CA

Work Preference

Job Search Status

Open to work
Desired start date: Flexible

Desired Job Title

VBA ProgrammerExcel AutomationVBScript Programmer

Work Type

Full TimePart TimeContract WorkGig WorkConsultingVolunteerSeasonal Work

Location Preference

RemoteOn-SiteHybrid
Location: Chino, CA
Open to relocation: No

Salary Range

$70/hr - $1000/hr

Summary

Accomplished & 25+ years Experienced VBA/Macros Programmer/Analyst with a background in organization performance. Background in multiple frameworks; expert at leading initiatives to optimize systems. Proven success in engaging and managing highly skilled technical teams to design and deploy innovative application solutions, tools and processes across operations. Proficient in Spanish.

Overview

26
26
years of professional experience

Work History

VBA Programmer

AECOM
Los Angeles, CA
05.2014 - Current
  • Development of VBA Macros to automated PMO Module to: Update & Track of Expenditures and Commitments for Metrolink Projects.
  • Created VBScript utilities to manage and log data import/export tasks between Oracle databases and local Excel workbooks to ensure traceability and audit readiness.
  • Utilized VBScript to handle cross-application tasks (e.g., launching Excel, initiating data pull from Oracle, zipping reports) to reduce manual coordination effort.
  • Automated Creation Reports, Dashboards, and summarize/detailed user-interface in Excel Linking Information from Oracle Database and Primavera P6 Schedules, CVS files and user Workbooks for Monthly/review meetings.
  • Extract Information from Oracle Server 11i and Oracle Serve R12 and create automated reports for/to Agencies: Metropolitan Transportation Authority (MTA), Orange County Transportation Authority (OCTA).
  • Accomplished: Implementing VBA/Macros to automate download and processing of information, old process was improved to: Reduce time to create Monthly reports & dashboard from 1 week to 2 hours.
  • Developed VBScript to automate the execution of Excel VBA macros via Windows Task Scheduler, enabling unattended generation of monthly reports and dashboards.
  • Used VBScript to create file monitoring and data staging routines that validated and moved Oracle-exported CSV files to designated directories for downstream processing by Excel VBA macros.
  • Implemented VBScript logic to launch Excel instances in headless mode for batch processing of cash-flow reports across multiple user workbooks.
  • Automated email distribution of finalized dashboards and reports using VBScript integrated with Outlook, streamlining communication with MTA and OCTA stakeholders.
  • Reduce personnel required to create Monthly reports & dashboards from 3 to 1.
  • Information automatically updated every day to keep it to date instead of only once a month.
  • (Contractor, 20hrs to 30hrs/Week) Assigned to Southern California Railroad Authority – SCRRA-PMO Department.
  • Automation and Development of VBA Macros for Cash-Flow Module: Development of multi-user interface for Project Manager to enter data to estimate Expenditures for active Metrolink projects.
  • Reports Creation summarizing Cash-flow data and verification of streamlined values in Projects.
  • Accomplished: Implementing VBA/Macros to automate download and processing of information, old process was improved to: Creation of a new friendly user interface to entry data, reducing unnecessary keystrokes and optimizing navigation interface.
  • Reduce the time to create cash-flow reports from 1 week to 1 hour.

VBA/VBScript/Macros Programmer

ONLINE Freelance
01.2010 - Current
  • Automating & Development VBA/Macros for a range of different customers and requirements.
  • Purchase order for a Rental Property company in Australia.
  • Track & Control of AC & Air Extractors on major retails (Walmart, Petco, Ulta, Etc.) for a company in Ohio.
  • Create Report from data downloaded from an ecommerce site.
  • Automatically add information to a webpage.
  • Control of a house purchase order for a construction company in Oregon.
  • Track of reviews & updates on resumes for a company in San Diego.
  • Track of School Gym Equipment that need to be repaired for a company in Canada.
  • Download data from Audio & Video conference Server company to create invoices to customers.
  • Development of Module to Tract & send emails to customers based on status of customer.
  • Development of Module to create dashboard to summarize workload for teachers.
  • Development of Invoices Summary and Bank reconciliation for a Pet Food Company in Australia.
  • Development of scoring wine contest for 6 nations.
  • Development of functions and updates for a software company in Texas.
  • And many more small/medium Projects.

VBA Programmer

K&B Engineer
Corona, CA
02.2024 - 12.2025
  • Automation of Order Module & Control of Production Orders with Weekly Estimate Order Production.

VBA/VBScript Programmer

NATIONAL DATA & SURVEYING SERVICES
Los Angeles, CA
02.2020 - 12.2023
  • Development of Modules to process, Report and Dashboards creation of Traffic Data Collected.
  • Extrapolation of data to fill gaps in data collected.
  • Automated Upload of videos files from Technician on field to Main Server.
  • Interactive Dashboard to visualize Street Data collected and how Traffic moves from one Direction to Another.
  • Automation of Payroll Data Entry on nation Wide Offices to HQ Office to be processed by Payroll Supervisor.
  • Automation of Payroll file to be exported Paychex & BBSI.

VBA Programmer

MELROSE MAC
Los Angeles, CA
06.2021 - 06.2023
  • Development of Accounting Reports in VBA from data extracted from PIM System.
  • Commissions.
  • Sales Summary.
  • Sales Reconciliation.
  • Rebates.
  • Weekly/Monthly Information to send to APPLE.

VBA Programmer

SPECTRA USA
Chino, CA
01.2019 - 04.2020
  • Development of Product Control Module in VBA to keep track of Fabric Raw material from Yarn, Knit & Dye to be assigned to a Production Order to supply a customer order.

Software Developer

ADIR INTERNATIONAL, LLC (DBA: La Curacao)
Los Angeles, CA
02.2000 - 04.2012
  • Designed wired networking software, application development tools, data management applications and enterprise business applications with VB6, VBA/Macros, Clipper and xHarbour.
  • Coded in xHarbour, Visual Basic, VBA, HTML, COM, and Win32 API frameworks with Advantage Database and Access databases.
  • Tracked and ensured resolution of software bugs.

VBA Programmer

LOUIS VUITTON
Irwindale, CA
01.2024
  • Automation of Order Module & Control of Production Orders with Weekly Estimate Order Production.

IT Manager

OPERADORA OCEANICA INTERNACIONAL
Mazatlán, Mexico
  • Managed and established technologies for networking, security, software development, and technical support for the IT department.
  • Oversaw budget and recruiting efforts.
  • Development of System using several Visual Version: VB3, VB4, VB5, VB6 and VBA/Macros.

IT Supervisor

DELOITTE TOUCHE TOHMATSU
Mazatlán, Mexico
  • Analysis & Development of application using Clipper 5.2.
  • Support Auditors, extracting information from companies ‘system to be processed by Auditors software.

Education

Bachelor of Science - Informatics

CALIFORNIA UNIVERSITY FCE
Los Angeles, CA

Skills

  • VBA/Macros
  • Data Accessing
  • Data Importing
  • Data Exporting
  • Microsoft Access
  • Microsoft SQL
  • Oracle MySQL
  • Primavera P6
  • Oracle Database
  • Web Data Extraction
  • TXT/CSV/XML Data Handling
  • Excel File Formats
  • API Development
  • COM Development
  • Automated Reports
  • Dashboards
  • User-Forms Development
  • Relational Databases
  • Scripting
  • Data Modeling
  • Performance Tuning
  • Data Format Conversion
  • VBScript
  • VBNET
  • Microsoft Visual Basic
  • Clipper/xHarbour
  • FoxBASE
  • Cobol
  • Pivot Tables
  • Conditional Formatting
  • Charts/Graphs
  • Complex Formulas
  • Dashboard Creation
  • Data Source Linking
  • SQL
  • Import/Export
  • Excel Ribbon Customization
  • User Friendly Interface Creation
  • Add-Ins Development
  • Class Modules
  • Process Automation
  • Interactive Dashboards
  • Enterprise System Integration
  • Business Problem Solving
  • Emerging Technologies Adoption
  • Data automation
  • Report generation
  • Dashboard creation
  • VBA programming
  • Database management
  • Process optimization
  • System integration
  • User interface design
  • Attention to detail
  • Problem solving
  • Team collaboration
  • Interface design and implementation
  • Software development
  • Database design
  • API integration
  • Application debugging
  • Relational databases
  • System design
  • Scripting languages

Timeline

VBA Programmer

K&B Engineer
02.2024 - 12.2025

VBA Programmer

LOUIS VUITTON
01.2024

VBA Programmer

MELROSE MAC
06.2021 - 06.2023

VBA/VBScript Programmer

NATIONAL DATA & SURVEYING SERVICES
02.2020 - 12.2023

VBA Programmer

SPECTRA USA
01.2019 - 04.2020

VBA Programmer

AECOM
05.2014 - Current

VBA/VBScript/Macros Programmer

ONLINE Freelance
01.2010 - Current

Software Developer

ADIR INTERNATIONAL, LLC (DBA: La Curacao)
02.2000 - 04.2012

IT Manager

OPERADORA OCEANICA INTERNACIONAL

IT Supervisor

DELOITTE TOUCHE TOHMATSU

Bachelor of Science - Informatics

CALIFORNIA UNIVERSITY FCE

Similar Profiles

CREATE PROFILE
Roberto Morgan