Developer Data

Cell 858-***-****

***** ***** ***** **** 858-***-****

San Diego, CA 92126 e-mail:

acdu3k@r.postjobfree.com

Ruben A. Dominguez

Objective

Access/Excel/VBA/SQL Developer/Software Engineer

UABC (Universidad Autonoma de Baja California)

Education

Bachelor degree in. Physics Science

Major: Computer Science

SKILLS SUMMARY:

Technical Management, Software design and development process.

Expertise in Windows 98, 95, 2000, XP, Windows Vista, Windows 7,

Windows 8,MS Office suite of products 97, 2003, 2007, 2010, 2013 VB

for Applications.

MS Access, SQL and Visual Basic for Applications Database

development, Business Objects, Crystal Reports.

MS Excel, Macros and Development.

MS VISIO 2003, 2007, 2010

Expertise in relational database management systems.

Strong Computer Knowledge, strong analytical skills.

Excellent interpersonal and communications skills, proactive and

responsive.

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

g) Java

Experience Jan 2013/Nov 2013 SONY San Diego, CA

Excel, Access and SQL Developer

Debugging and update 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 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 CALIFORNIASan 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