Human Resources Manager
Resume:
San Diego, CA *****
Cell 858-***-****
e-mail: ad65g5@r.postjobfree.com
Ruben A. Dominguez
Objective
Excel/Access/VBA/Database Developer/SQL
Education
UABC (Universidad Autonoma de Baja California)
Bachelor degree in. Physics Science
Major: Computer Science
SKILLS SUMMARY:
Technical Management, Software design and development process.
MS Access, Excel, SQL and Visual Basic for Applications (VBA) Database development, Business Objects, Crystal Reports.
VBA (Creating Macros, Modules, Functions, Procedures).
MS Excel, Macros and Development in VBA.
Expertise in relational database management systems.
Strong Analytical skills and strong Computer Knowledge.
Expertise in Windows 98, 95, 2000, 2010, XP, Windows Vista, Windows 7, Windows 8, Windows 10, Windows 11, MS Office suite of products 97, 2003, 2007, 2010, 2013, 2016, 2019, Office 365, VB for Applications.
Transition from previous MS Office suites to 365.
Excellent interpersonal and communications skills, proactive and responsive.
Strong capacity creating algorithms in modules in VBA, VB, Turbo Pascal, Fortran IV and Fortran 77.
Database architecture, data structures and design patterns.
Bilingual, Spanish
Background Courses:
Calculus Finite Mathematics
Mathematical Analysis
Statistical Analysis
Functions of compiled Variables
Numeric Analysis.
Computer Related Courses:
a) Oracle.
b) FOCUS Programming.
c) Visual Basic 6.0 Programming
d) Adobe PhotoShop
e) Turbo Pascal, C
f) Digital Image Processing
Experience
Jan 2022/Jan 2024 P&G (Remote) Ci, OH
Access/Excel/VBA Developer
Provide 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.
Analyzing and updating 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.
Aug 2022/Feb 2023 SOUND PHYSICIANS (Remote) OH
Excel/Access/VBA Developer
Write 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, configure, 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.
Mar 2022/Present EVEREST (Remote) NJ
Excel/Access/VBA Developer
Building VB prototypes and small-scale applications, along with VBA scripts, in a bid to automate Excel spreadsheets.
Developing, enhancing, and maintaining MS Office applications, and handling both frontend and backend development procedures.
Designing, configuring, developing, and implementing enhancements and production fixes to existing systems.
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 ensure that their configuration is properly handled applying Pivot Tables, INDEX and MATCH functions.
Develop, maintain, and support existing MS Excel VBA applications, and analyze and convert business requirements as needed.
Apr 2021/Dec 2021 SHARP San Diego, CA
Access/Excel/VBA Developer
Upgrade 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.
Creating queries in SQL to create and export reports in Excel and PDF format.
Preparing Legacy data to the migration to new software INOVAARE
Apr 2020/Feb 2021 PCE San Diego, CA
Access/Excel/VBA Developer
Developing an Access database from scratch to create a user interface between different modules of production for:
oBusiness Department
oProduction Department
oQuality 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.
Apr 2019/Mar 2020 LightBridge Hospice San Diego, CA
Financial Analyst - Access/Excel/SQL Developer
Working 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.
Apr 2018/Oct 2018 SHARP Health Plan San Diego, CA
Access/Excel/SQL Analyst Developer
Working 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 at SHARP HEALTH PLAN.
Jan 2015/ Dec 2020 Catholic Diocese Of San Diego San Diego, CA
Access/SQL Developer
Debugging 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.
Design 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.
Mar 2016/ Dec 2021 San Diego Regional Center Orange, CA
Access Developer
Transition 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.
Jan 2015/May 2015 San Diego Regional Center Orange, CA
Access Developer
Debugging and updating current Back End Access database.
Fixing and adding new options to the Front-End MS Access database to create reports, programming in VBA.
Sep 2014/Oct 2014 Victor Valley Transit Orange, CA
Virtual Access Developer
Debugging and updating current Access database.
Developing a Front-End MS Access database where are created all the queries in SQL and creating Modules using VBA to create Functions, Subroutines and Procedures.
Designing and updating the GUI (Graphic User Interface) to improve the User interaction creating reports and data entry.
Jun 2014/Sep 2014 Reid Planning, Inc San Diego, CA
Access/Excel/VBA Developer
Debugging and updating current Excel database to upload to new MS Access Database.
Create a Back End Access Database and develop all the relationships between tables and applying primary keys and indexing fields to optimize data.
Developing a Front-End MS Access database where are created all the queries in SQL and creating Modules using VBA to create Functions, Subroutines and Procedures.
Designing all the GUI (Graphic User Interface) to improve the User interaction creating reports and data entry.
Jan 2013/Nov 2013 SONY San Diego, CA
Excel/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.
Plenty experience in ADO, DAO data access interfaces of accessing data. Using Visual Basic to control the connection, statement builders, and returned data for the user.
Building out Access, VB and Excel Macros to the Database to make changes and alterations. It is for their pricing structure database Develop new projects in Excel and Access according to the user needs in the Sales financial department.
Using Word, Powerpoint and Visio to create reports and flowcharts.
Working with the Sales department team creating new options to gathering data and process for new reports.
Mar 2012/Jun 2012 Carefusion San Diego, CA
Access Developer
Design an Access database drafted to take various information streams coming from manufacturing operations.
This database is written around defect tracking and calculating rolled throughput yield.
A substantial portion of the output of this database is Pareto Charts, Trend Analysis and/or Histograms that help our Engineers turn the data into actionable intelligence to select and prioritize projects and continuous improvement ideas.
This Database is to have our manufacturing personnel (Line Leads, Repair Technicians, Supervisors) input the data into a common “universal” Access database where the Engineers will be able to call up the file and generate outputs and watch for trending.
Create Manual for this project With MS Word and also developing forms as a guide for the users.
Create flowchart using MS Visio application.
Database created using Modules with VBA (Visual Basic for Applications) using ADO and DAO data access interfaces, using SQL queries, macros, and VBA procedures.
Designing forms to get a friendly GUI (Graphic User Interface).
Experience with Excel (Macros and queries using data analysis tools and VBA Modules), Business Objects database structures, exporting data, data processes/flows.
Working closely with the Technicians team following their instructions how the steps process to build a new device, to design the new Tracking database and the Graphic User interface for them.
Jul 2010/Mar 2012 Zobele San Diego, CA
Access Developer/Independent Consultant
Design an Access database to import *.txt, *.csv, *.xls, *.xlsx format files from the information related to International Customs system.
Design a friendly Graphic User Interface, where customer can create custom reports and export to excel format and also creating Charts to include in the report.
Technical support in the process to download the raw data from SAP system and work with Ad Hoc data.
Creating reports with Crystal Reports
SQL, VBA, Access and Excel.
Mar 2007/Jul 2010 MedImpact San Diego, CA
Access and SQL Developer/Software Engineer II
Develop, create, and modify general computer applications software or specialized utility programs. Analyze user needs and develop software solutions. Design software or customize software for client use with the aim of optimizing operational efficiency. May analyze and design databases within an application area, working individually or coordinating database development as part of a team.
Working in the Emergency Needs Team in Formulary Services Government Department.
Collecting, receiving, obtaining data, identifying pertinent information, and preparing clear and concise reports which reflect understandable data analysis results.
Programming in VBA Modules for Access using ADO, DAO, Excel, Macros, SQL.
Experience with Excel, Access, Business Objects database structures, exporting data, data processes/flows; creating databases, tables, Macros and queries using data analysis tools and VBA Modules.
Importing and Exporting ASCII Delimited Text, Comma Separated Format, Excel files.
Creating, Analyzing, debugging and updating Formulary Databases.
Designing GUI (Graphics User Interface) for inside and outside Government Customers for PART D Type
In charge of developing, creating, updating and maintaining internal tools as:
ASCII Generator Tool.
ASCII Comparison Tool.
FRID’s Analyzer Tool.
Formulary Query Tool.
CMS Deletion Tool.
PNAT Tool or CNAT Tool.
2PDF Converter Tool.
PTOC Tool.
PL/SQL development.
STAR TEAM Software.
TOAD software.
Oracle environment, creating own schemas to development, QA and production.
Knowledge in ODBC Databases.
Creating Flowcharts Diagrams for Tool Documentation in VISIO.
Working in the “Emergency Needs Department” we were a team where all the Software Engineers were designing and developing new tools for the customers.
Nov 2004/Mar 2007 SONY Electronics San Diego, CA
Access Developer/Data Analyst
Working in the CS-21 Department tracking and Designing Reports for all SONY items to report to managers using Crystal Reports, Business Objects, SQL, ACCESS, EXCEL, VBA, SQUID and PowerPoint.
Creating PowerPoint presentations and Excel charts in the reports for customers in SONY site in San Diego and Japan.
Debugging and Updating Databases that we have in site to easy handle and downloading raw data to the best way to work with it.
Jul 2004/Nov 2004 LEAP Wireless (TEKSystems) San Diego, CA
Data Analyst/Access and SQL Developer
Managed the conversion of property records from an Access database to the Oracle Property Manager application (over 3000 leases). The conversion required the ability to quickly learn a new data load application, the functional aspects of the PM application, and the fasted way to correct errors that were encountered. After the initial load of the data, I was responsible for on-going corrections to the data. This included creating multiple access queries to compare legacy data to converted data, using the Oracle applications for corrections, and identifying anomalies. I worked closely with the implementation team during this effort. I was retained after the other data conversion people completed their assignments due to my ability to quickly learn and my attention to detail.
Working with Excel, Access, SQL, Data Load Software and Oracle.
Report to management on the progress of the project.
Aug 2003/Jul 2004 SONY Electronics San Diego, CA
Access Developer/Data Analyst
Creating reports for ITD (Information Technology Division) in Excel and Access using Visual Basic for Applications.
Creating Queries based on SQL language and VBA.
Creating Modules based on Visual Basic.
Creating Reports and Documents with VISIO Software.
Import/Transfer Files from Business Objects to PC to work with Access Databases.
Creating Reports in Business Objects.
Updating and Debugging Databases.
Jul 2002/Aug 2003 Union Bank of California San Diego, CA
Closing Assistant/Access and Excel
Creating EXCEL FORMS for Mortgage Consultants in the Loan by Phone Department.
Working with Mainframe software extracting information for Loan Representatives using RUMBA.
Using MS EXCEL AND ACCESS to create databases to keep information updated.
Auditing and Updating Information in Fund Department.
Enter Appraisal, Escrow and Preliminary Reports Information to the System.
Contact this candidate