Available to hire
Hi, I’m Ruben, a developer specializing in Excel, VBA, and Access with a strong focus on automating workflows, data integration, and database design. I enjoy turning messy processes into reliable, repeatable solutions that save time and reduce errors.
I bring experience across healthcare, financial services, education, and professional services, working with SQL Server, SSIS, Visual Studio, and Office solutions to deliver scalable tools for teams.
Experience Level
Language
English
Fluent
Spanish; Castilian
Fluent
Work Experience
Access/Excel/VBA Developer at DELOITTE
August 1, 2025 - October 20, 2025Led development and enhancement of the RAT (Relational Maintenance Tool) in Excel, including VBA debugging, updates, and implementation for improved automation and reliability. Designed and built a new Access database to prepopulate Excel files with Rule Set attributes, streamlining data integrity and reducing manual input. Collaborated in Visual Studio 2019 to create and maintain packages supporting broader automation workflows. Worked directly with SQL Server, creating and refining stored procedures, user-defined functions, and performing hands-on database edits to support evolving business logic. Analyzed and debugged a complex 401K Funding Access database for HR, identifying structural issues and implementing solutions to ensure accurate financial tracking and reporting.
Excel/Access/VBA Developer at EVEREST
January 1, 2022 - PresentBuilding VB prototypes and small-scale applications, along with VBA scripts, in a bid to automate Excel spreadsheets. SSIS used to create queries to Append, Modify or Delete (duplicates). Developing procedures or queries from SQL Server to send data to process or creating reports. Developing, enhancing, and maintaining MS Excel, Access, Word and Power Point Office applications, and handling both frontend and backend development procedures. Creating Sub procedures with VBA PAC (Programmable Automation Controller) from Excel using VBA code to work with different data in different locations where we need to use different IP addresses to connect to a PAC file, bring this information to a spreadsheet in Excel and (Read/Write, From/to) the PAC file. Working directly with underwriters debugging and implementing new strategies for the current raters for this Insurance company. Working with more than 30 different raters for the financial department. Developing and implementing new systems and e
Access/Excel/VBA Developer at P&G
January 1, 2024 - October 20, 2025Provide technical solutions to a wide range of difficult problems. Ensure that solutions are innovative, thorough, practical and consistent with organizational objectives. Developing and building different databases for Oral department. Using Visual Studio to analyze and update Modules in VBA, Procedures and Functions. Creating queries in SQL to create and export reports in Excel and PDF format. Transition from MS 2016 to 365.
Excel/Access/VBA Developer at SOUND PHYSICIANS
February 1, 2023 - October 20, 2025Write VBA code and write excel macros for some projects with their Telemedicine team. Development of 4 projects from scratch, Userforms, Functions, Subroutines in VBA. Creating Macros for the Salesforce LIVE report for the Financial Department. Development from zero in VBA the Excel file for discrepancies in Marketing. Improve and implement the Financial Reports in Excel via VBA for the Doctor’s payroll. Designing, configuring, developing, and implementing enhancements and production fixes to existing Macros, VLookup/HLookup/Pivot Tables, INDEX and MATCH functions. Develop, maintain, and support existing MS Excel VBA applications, and analyze and convert business requirements as needed. Implementing API, Coherent, APIM into raters for a faster response.
Access/Excel/VBA Developer at SHARPS
December 1, 2021 - October 20, 2025Upgrade and Develop new Graphic User Interface and automate reports that are created in Excel manually. Programming new functions and procedures to obtain the solutions to new reports. Developing different reports for the Operations department. Creating Modules in VBA, Procedures and Functions. SSIS create queries in SQL to create and export reports in Excel and PDF format. Preparing Legacy data to the migration to new software INOVA
Access/Excel/VBA Developer at PCE
February 1, 2021 - October 20, 2025Developing an Access database from scratch to create a user interface between different modules of production for: Business Department, Production Department, Quality Assurance Department. Create different Input forms to different modules with their own attributes for restricted access. Developing different reports for each department. Creating Modules in VBA, Procedures and Functions. Creating queries in SQL to create the reports and different search commands.
Financial Analyst - Access/Excel/SQL Developer at LightBridge Hospice
December 1, 2020 - October 20, 2025Working with SQL Server and creating scripts to develop a GUI. Developing an Access database to create APP Productivity Reports and export in Excel and PDF formats and create reports linked to SQL Server tables applying Macros, VLOOKUP/HLOOKUP/Pivot Tables, INDEX and MATCH functions. Create Macros in Excel in VBA and create VBA Programming, SQL queries, Modules, Subroutines, Functions in Access to automate the different tasks and reports sending to CMS. Creating documentation for different procedures about the automation of reports.
Access/SQL Analyst/Developer at SHARP Health Plan
December 1, 2020 - October 20, 2025Working for Network Development and Performance department. Designing and creating Access and Excel tools with Graphic User Interface to analyze data and create reports. Create Macros in Excel in VBA and create VBA Programming, SQL queries, Modules, Subroutines, Functions and GUI in Access for the different tasks. Creation from scratch the Timely Access for DMHC database and GUI to get surveys in ACCESS. Creating algorithms to user’s functions, designing data structures for proper relationships between tables and designing patterns to create user interface. Creation from scratch also for CREDENTIALING, ATTESTATION, NCQA.
Access Developer / Data Analyst at Catholic Diocese Of San Diego
December 1, 2020 - October 20, 2025Debugging and fixing old Access Database to verify if is working correctly as a Back End or redesign a new database but in Office 2016 (current 2007). Developing a New Front-End MS Access in 2016 database, creating all the queries using SQL Scripting, VBA to create Modules with Functions, Subroutines and Procedures. Designing all New GUI (Graphic User Interface) to improve the interaction and understanding of the application. Designing new interaction to create reports and data entry. Creating algorithms to user’s functions, designing data structures for proper relationships between tables and designing patterns to create user interface. Transition of database MS 2000 to MS 2016. Maintain and keep updated the different databases created and developed: OECM, Schools, Missions, Family, Life and Spirituality.
Access Developer at San Diego Regional Center
December 1, 2021 - October 20, 2025Transition MS Access 2007 to MS Access 2013. Fixing and adding new reports and forms to the Front End MS Access database, updating functions and procedures to work in 64bits environment for Windows, updating VBA codes in subroutines. Fixing and Updating Financial reports in Access VBA exporting to Excel files. Creating Functions and Subroutines to automate financial reports. Update Access database to install in SQL server environment.
Excel/Access/VBA Developer at Sony Electronics
November 1, 2004 - October 20, 2025Excel/Access/VBA and SQL Developer. Debugging and updating current Excel database and Macros, using VBA, creating functions and user interface for Sales department. Designing, Debugging and updating current Access database using SQL, Recordsets, in Module VBA and creating queries Access system to get pricing structure in place. Building out Access, VB and Excel Macros to the Database to make changes and alterations. Developing new projects in Excel and Access according to user needs in Sales/Finance.
Data Analyst / Access Developer at Carefusion
March 1, 2012 - October 20, 2025Design an Access database drafted to take various information streams coming from manufacturing operations. Database focused on defect tracking and calculating rolled throughput yield. Output includes Pareto Charts, Trend Analysis and Histograms to support engineering decisions. Engineers call the universal Access database to generate outputs and monitor trends. Create manuals and flowcharts for documentation; develop GUI to provide friendly interaction. Implement VBA modules with ADO/DAO and SQL queries.
Access/Excel/VBA Developer at DELOITTE
August 1, 2025 - October 20, 2025Led development and enhancement of the RAT in Excel, including VBA debugging and automation updates. Designed and built a new Access database to prepopulate Excel files with Rule Set attributes, improving data integrity and reducing manual input. Collaborated in Visual Studio 2019 to create and maintain packages supporting broader automation workflows. Worked with SQL Server to refine stored procedures and user-defined functions, supporting evolving business logic. Analyzed a complex 401K Funding Access database for HR, identifying structural issues and implementing solutions for accurate financial tracking and reporting.
Excel/Access/VBA Developer at EVEREST
March 1, 2022 - PresentBuilt VB prototypes and small-scale applications, plus VBA scripts to automate Excel spreadsheets. Used SSIS to create queries to Append/Modify/Delete duplicates and to streamline data processing. Developed procedures/queries from SQL Server to support processing and reporting. Created and maintained Office applications (Excel/Access/Word/PowerPoint) handling both frontend and backend logic. Implemented PAC (Programmable Automation Controller) integration from Excel using VBA to read/write data across locations, consolidating information in Excel. Collaborated with underwriters to debug and implement new rater strategies and enhanced production workflows, including API/APIM integrations for faster responses.
Access/Excel/VBA Developer at P&G
January 1, 2024 - October 20, 2025Provided technical solutions to a wide range of problems, focusing on automation and data integrity. Built databases for the Oral department, analyzed and updated VBA modules using Visual Studio, and created SQL queries to export reports to Excel and PDF. Managed the transition from MS Office 2016 to 365.
Excel/Access/VBA Developer at SOUND PHYSICIANS
February 1, 2023 - October 20, 2025Wrote VBA code and macros for multiple projects within the Telemedicine team. Developed four projects from scratch (user forms, functions, subroutines) and created macros for Salesforce LIVE reports for the Financial Department. Built an Excel/VBA solution to identify discrepancies in Marketing, and enhanced Financial Reports via VBA. Implemented production fixes and enhancements using VLOOKUP/HLOOKUP, INDEX/MATCH, and Pivot Tables; maintained and supported existing Excel VBA apps; integrated API/Coherent/APIM into raters for faster responses.
Access/Excel/VBA Developer at SHARPSan Diego
December 1, 2021 - October 20, 2025 Upgraded and developed a new graphical user interface and automated reports created in Excel. Implemented new functions/procedures to deliver solutions for Operations. Created various department reports, built VBA modules, and developed SSIS queries to export reports to Excel and PDF. Also prepared legacy data for migration to new software.
Access/Excel/VBA Developer at PCESan Diego
February 1, 2021 - October 20, 2025Developed an Access database from scratch to create a user interface between production modules (Business, Production, Quality Assurance). Created input forms for restricted access and built department-specific reports. Implemented SQL queries for reporting and data retrieval, and created reusable VBA modules.
Financial Analyst - Access/Excel/SQL Developer at LightBridge Hospice
March 1, 2020 - October 20, 2025Worked with SQL Server to develop scripts and GUI. Built an Access database to generate APP Productivity Reports and export to Excel/PDF, with reports linked to SQL Server tables. Created macros, VBA modules, and SQL queries to automate tasks and reports for CMS submissions; documented procedures for automation.
Access/Excel/SQL Analyst Developer at SHARP Health Plan
October 1, 2018 - October 20, 2025Designed and built Access and Excel tools with GUI to analyze data and generate reports. Implemented macros and SQL queries to automate tasks, created front-end interfaces in Access, and developed end-to-end reporting for credentialing, attestation, and NCQA-related processes.
Access/SQL Developer at Catholic Diocese Of San Diego
December 1, 2020 - October 20, 2025Debugged and fixed legacy Access databases, redesigned new front-end in MS Access, and implemented SQL-driven queries. Built new GUI to improve user interaction and automated reporting across multiple databases (OECM, Schools, Missions, Family, Life and Spirituality).
Access Developer at San Diego Regional Center
May 1, 2015 - October 20, 2025Transitioned MS Access 2007 to 2013, fixed and added reports, updated VBA for 64-bit Windows, maintained financial reports in Access, and prepared data for SQL Server deployment. Improved data relationships and reporting interfaces.
Excel/Access/VBA and SQL Developer at SONY
November 1, 2013 - October 20, 2025Debugged and updated Excel databases and macros; created functions and UI in Access; designed and updated SQL-based queries; built data structures for sales pricing and reporting; used VB to control connections and data movement.
Access Developer/Independent Consultant at Zobele
March 1, 2012 - October 20, 2025Designed an Access database to import data from SAP and other sources; built a user-friendly GUI for custom reports; provided technical support for raw data extraction and charting. Created reports and dashboards with SQL, VBA, and Excel integration.
Data Analyst/Access and SQL Developer at LEAP Wireless (TEKSystems)
November 1, 2004 - October 20, 2025Managed data migration of leases from Access to Oracle Property Manager; built queries for data comparison and corrections; partnered with implementation teams to ensure data integrity and effective load processes; produced management reports.
Access Developer/Data Analyst at SONY Electronics
July 1, 2004 - October 20, 2025Created reports for ITD in Excel/Access using VBA and SQL; built modules and queries; produced reports and data flows with documentation and visuals for IT stakeholders.
Closing Assistant/Access and Excel at Union Bank of California
August 1, 2003 - October 20, 2025Created Excel forms for Mortgage Consultants; extracted data from mainframe systems; built Access databases to manage information and maintain up-to-date records.
Access/Excel/VBA Developer at Deloitte
August 1, 2025 - October 20, 2025Led development and enhancement of Relational Maintenance Tool (RAT) in Excel; VBA debugging and updates; designed and built a new Access database to prepopulate Excel files with Rule Set attributes; collaborated in Visual Studio 2019 to create and maintain automation packages; refined SQL Server stored procedures and UDFs; debugged a complex 401K Funding Access database for HR.
Excel/Access/VBA Developer at EVEREST
January 1, 2022 - PresentBuilt VB prototypes and small-scale applications; automated Excel spreadsheets; used SSIS to create queries; configured and maintained MS Excel, Access, Word and PowerPoint; developed PAC automation with Excel VBA to connect to PAC files; integrated Pivot Tables and INDEX/MATCH for reporting; supported underwriters and rater systems; implemented API/Coherent/APIM into raters.
Access/Excel/VBA Developer at P&G
January 1, 2024 - October 20, 2025Provided technical solutions to difficult problems; developed databases for the Oral department; used Visual Studio to analyze and update VBA modules; created SQL queries to export reports to Excel/PDF; transitioned from MS 2016 to Office 365.
Excel/Access/VBA Developer at SOUND PHYSICIANS
February 1, 2023 - October 20, 2025Wrote VBA code and macros for Telemedicine projects; developed multiple projects from scratch (UserForms, functions, subs); created macros for Salesforce LIVE reporting; improved and implemented financial reports in Excel via VBA; implemented VLOOKUP/HLOOKUP/PivotTables and INDEX/MATCH; supported 30+ raters; implemented API/Coherent/APIM integration.
Access/Excel/VBA Developer at SHARPS
December 1, 2021 - October 20, 2025Upgraded and developed new GUI; automated Excel reports; built modules in VBA; created SSIS queries to export to Excel/PDF; prepared legacy data for migration; produced reports for Operations.
Access/Excel/VBA Developer at PCE
February 1, 2021 - October 20, 2025Developed an Access database to serve as a UI between production modules; created input forms; developed reports; built VBA modules.
Financial Analyst - Access/Excel/SQL Developer at LightBridge Hospice
March 1, 2020 - October 20, 2025Developed SQL Server scripts; created an Access database for APP Productivity Reports; exported to Excel and PDF; built VBA macros to automate reporting; documented procedures.
Access/Excel/SQL Analyst/Developer at SHARP Health Plan
October 1, 2018 - October 20, 2025Designed and created Access and Excel tools with GUI to analyze data; built VBA macros; created queries; supported DMHC credentialing; built from scratch Timely Access DB and NCQA credentialing tooling.
Access/SQL Developer at Catholic Diocese Of San Diego
December 1, 2020 - October 20, 2025Debugged and updated legacy Access databases; redesigned front-end in Access 2016; created queries and forms; transitioned to 64-bit environment; documented procedures and reports.
Access Developer at San Diego Regional Center
December 1, 2021 - October 20, 2025Transitioned MS Access 2007 to MS Access 2013; fixed and added reports; updated VBA for 64-bit environment; automated financial reports and SQL integration.
Access Developer at San Diego Regional Center
May 1, 2015 - October 20, 2025Debugged and updated legacy Access database; added new options and reports; worked on front-end automation.
Excel/Access/VBA and SQL Developer at Sony Electronics
August 1, 2003 - October 20, 2025Debugged and updated Excel databases and Access databases; built VBA modules and user interfaces for Sales; created SQL queries and dashboards; produced reports for ITD.
Closing Assistant/Access and Excel at Union Bank of California
August 1, 2003 - October 20, 2025Created Excel forms for Mortgage Consultants; extracted data from mainframe using RUMBA; built Access-based databases for tracking and reporting.
Access and SQL Developer/Software Engineer II at MedImpact
November 1, 2004 - October 20, 2025Developed and modified applications; designed databases; built VBA modules, Excel macros, and SQL queries to support formulary reporting.
Data Analyst/Access and SQL Developer at LEAP Wireless (TEKSystems)
July 1, 2004 - October 20, 2025Managed data conversions; built Access queries and Oracle data loads; supported conversions and reporting.
Access Developer/Data Analyst at Sony Electronics
August 1, 2003 - October 20, 2025Created reports in Excel/Access; built queries using SQL; developed VBA modules; supported sales data analysis.
Access Developer/Data Analyst at Union Bank of California
August 1, 2003 - October 20, 2025Created Excel forms for Mortgage Consultants; data extraction from mainframe; built Access databases.
Access/Excel/VBA Developer at Deloitte
August 1, 2025 - October 20, 2025Led development and enhancement of the RAT (Relational Maintenance Tool) in Excel, including VBA debugging, updates, and implementation for improved automation and reliability. Designed and built a new Access database to prepopulate Excel files with Rule Set attributes, streamlining data integrity and reducing manual input. Collaborated in Visual Studio 2019 to create and maintain packages supporting broader automation workflows. Worked directly with SQL Server, creating and refining stored procedures, and performing hands-on database edits to support evolving business logic. Analyzed and debugged a complex 401K Funding Access database for HR, identifying structural issues and implementing solutions to ensure accurate financial tracking and reporting.
VB Prototypes Developer / Excel/Access/VBA Developer at EVEREST
March 1, 2022 - PresentBuilding VB prototypes and small-scale applications, along with VBA scripts to automate Excel spreadsheets. SSIS used to create queries to Append, Modify or Delete duplicates. Developing procedures or queries from SQL Server to process or export reports. Creating and maintaining MS Excel, Access, Word and Power Point Office applications, handling frontend and backend development. Designing and implementing enhancements and production fixes; creating PAC VBA integrations to read/write data from PAC files and consolidate into Excel. Collaborating with underwriters and 30+ raters to implement updated strategies and improve automation.
Access/Excel/VBA Developer at P&G
January 1, 2024 - October 20, 2025Providing technical solutions to a wide range of problems. Developing and building databases for the Oral department. Using Visual Studio to analyze and update VBA modules, procedures, and functions. Creating SQL queries to export reports to Excel and PDF formats. Transitioning from MS 2016 to 365.
Excel/Access/VBA Developer at SOUND PHYSICIANS
February 1, 2023 - October 20, 2025Developed VBA code and Excel macros for multiple projects with the Telemedicine team. Created four projects from scratch (UserForms, functions, subroutines), built macros for Salesforce Live reports, developed VBA solutions for discrepancies in Marketing Discrepancies, and enhanced Financial Reports in Excel for Doctor payroll. Implemented production fixes and enhancements to existing macros, including VLOOKUP/HLOOKUP, PivotTables, and INDEX/MATCH. Supported 30+ raters and integrated API/Coherent/APIM for faster responses.
Access/Excel/VBA Developer at SHARPS
December 1, 2021 - October 20, 2025Upgraded and developed new Graphical User Interfaces and automated Excel reports. Created new VBA modules and procedures to support reporting needs for Operations. Built SSIS queries to export reports to Excel and PDF. Supported migration efforts for INOVA to new software.
Access/Excel/VBA Developer at PCESan Diego
February 1, 2021 - October 20, 2025Developed an Access database from scratch to create a user interface across production modules (Business, Production, Quality Assurance). Created input forms, reports, and restricted-access forms. Built SQL-based queries to support reporting requirements.
Financial Analyst - Access/Excel/SQL Developer at LightBridge Hospice
December 1, 2020 - October 20, 2025Worked with SQL Server to create a GUI and productivity reports, exported to Excel and PDF. Built Access-based reports linked to SQL Server tables, implemented Macros, VLOOKUP/HLOOKUP/Pivot Tables, and INDEX/MATCH for data analysis. Documented procedures for automation and CMS reporting.
Access/Excel/SQL Analyst/Developer at SHARP Health Plan
October 1, 2018 - October 20, 2025Designed and built Access and Excel tools with GUI to analyze data and generate reports. Created macros, SQL queries, and dashboards; implemented 64-bit compatibility for Windows; contributed to Credentialing/Attestation/NCQA initiatives.
Access/SQL Developer at Catholic Diocese Of San Diego
December 1, 2020 - October 20, 2025Debugged and updated old Access databases, redesigned front-end interfaces in Access 2016, created queries and modules, and designed new GUIs for reports and data entry. Transitioned databases from Access 2000 to 2016; maintained multiple DBs (OECMSchools, Missions, Life/Spirituality).
Access Developer at San Diego Regional Center
December 1, 2021 - October 20, 2025Transitioned MS Access 2007 to MS Access 2013; fixed and added reports and forms; updated VBA for 64-bit environment; refreshed financial reports; prepared SQL Server installation for backend.
Access Developer at San Diego Regional Center
May 1, 2015 - October 20, 2025Debugged and updated the Back End Access database; enhanced front-end options; created reports and automated processes.
Excel/Access/VBA and SQL Developer at SONY Electronics
March 1, 2012 - October 20, 2025Debugged and updated Excel databases and macros; created functions and user interfaces; developed queries in SQL; built pricing structure database and reports; leveraged ADO/DAO data access and VB/Excel integration.
Access Developer/Data Analyst at SONY Electronics
March 1, 2007 - October 20, 2025Created reports for ITD using Excel/Access with VBA; designed SQL-based queries; built modules in Visual Basic; transferred data to Business Objects; updated and debugged databases; produced reports and visuals for management.
Closing Assistant/Access and Excel at Union Bank of California
August 1, 2003 - October 20, 2025Created Excel forms for Mortgage Consultants; extracted data from mainframe using RUMBA; used Excel/Access to manage data; audited and updated fund information; input Appraisal, Escrow, and Preliminary Report data.
Access Developer/Data Analyst at Sony Electronics
July 1, 2004 - October 20, 2025Developed reports in Excel/Access using VBA; created SQL-based queries; built modules and interfaces; supported pricing data integration and dashboard reporting.
Access/Independent Consultant at Zobele
July 1, 2010 - October 20, 2025Designed Access databases to import *.txt, *.csv, *.xls files from international customs; built GUI for reports and charts; provided SAP data download support and ad hoc data tasks; produced Crystal Reports-based outputs.
Access/SQL Developer at MedImpact
July 1, 2010 - October 20, 2025Developed and modified applications in VBA/Access; worked with SQL and data integration for formulary systems; supported Sales and IT teams with data-driven solutions.
Excel/Access/VBA and SQL Developer at Carefusion
June 1, 2012 - October 20, 2025Designed and implemented a tracking database for manufacturing data; built reports (Pareto, Trend Analysis, Histograms) using VBA and SQL. Created workflow GUIs and documentation.
Education
Bachelor's degree at Universidad Autonoma de Baja California (UABC)
January 11, 2030 - October 20, 2025Bachelor degree in Physics Science at Universidad Autonoma de Baja California (UABC)
January 11, 2030 - October 20, 2025Bachelor degree at UABC (Universidad Autonoma de Baja California)
January 11, 2030 - October 20, 2025Bachelor of Science at Universidad Autónoma de Baja California (UABC)
January 11, 2030 - October 20, 2025Qualifications
Industry Experience
Computers & Electronics, Software & Internet, Professional Services, Healthcare, Education, Financial Services, Manufacturing, Government
Experience Level
Hire a Programmer
We have the best programmer experts on Twine. Hire a programmer in San Diego today.