RITCHIE DECOMA

***** ******* *********, *** ****, Ca 92585

Cell: 714-***-**** adl12y@r.postjobfree.com

EDUCATION: California State University, Fullerton

Major: Computer Science – specializing in Information Systems

Bachelors in Computer Science Expected in 12/2022

Orange Coast College, Costa Mesa, California Graduated: A.A. degree in Computer Science 1992

●2 years T-SQL scripting

●20 years VBA programming

●12 years warehouse

●20 years MS Access

●7 years data-transfer

●15 years report writing

●30 years MS Excel

●13 years LAN

●3 years of File Maker Pro 3.0

●2 years Oracle

●12 years SQL Server

●12 years SSMS

●3 years HTML/ ASP/vb-scripting

●2 years TOAD

●14 years of computer consulting

●5 years Agile Methodology.

Related Classes: Visual Basic C++, UNIX, Turbo C, Visual Basic for Applications, Computer Information Systems, Microsystems Development, Turbo Pascal, Quick BASIC, BASIC

EXPERIENCE:

Fully Integrated Solutions, Huntington Beach, California 3/2019 to Present

Computer Consultant & Database Programmer

●Created MS SQL databases with tables and stored-procedures

●Used MS Access databases that linked to MS SQL with forms and reports geared towards the client’s needs

●Clean and move old data

●Setup new computers to network.

PBF Oil Refinery/Glen Prosen Inc., Torrance, California 10/2018 to 2/2019

Database Programmer

●Took an outdated MS Access database, migrated it the recent version of Access, and updated it by altering the code to specifications

●Created VBA code to process MS Excel Sheets so it could take in the data and put it into the MS Access database

●Added additional functions so information from Excel sheets could be processed easier for the user

●Added code to a report so it would automatically switch links to backend databases, gather the info, and export to Excel

Fully Integrated Solutions, Huntington Beach, California 11/2016 to 9/2018

Computer Consultant & Database Programmer

●Created MS SQL databases with tables and stored-procedures

●Used MS Access databases that linked to MS SQL with forms and reports geared towards the client’s needs

●Invented procedures, within Excel worksheets, that linked up to Oracle databases allowing the transfer and altercations of the required data being transferred.

●Setup the local area network within the office

●Made recommendations to the client on what would help speed up his computer system and help get the tasks done in less time.

Hyundai (CONTRACT), Newport Beach, California 1/2015 to 10/2016

Computer Consultant & Database Programmer

Translated and migrated the information and VBA to be utilized by Oracle through the use of SQL.

Added new features to existing MS Excel files (e.g. added buttons with newly created VBA code)

●In TOAD, created and made improvements to Oracle-procedures through the use of SQL.

●Created Oracle procedures allowing the transformation of data-transfer to happen correctly.

●In VBA code, created ODBC connections to existing Oracle database to allow transfer of data from the MS Excel sheets.

●Improved the speed of slower running MS Excel files from hour or more to a couple of minutes by making alterations to the VBA code.

●Used VLOOKUP, HLOOKUP, and other complex functions in MS Excel

●In the programming I accomplished, I used the Agile-methodology; therefore, checking with the client as the case progressed.

Anamar Windows (CONTRACT), Montebello, California 5/2010 to 12/2014

Computer Consultant & Database Programmer

●Integrated Stored Procedures in SQL 2005/2012 to increase the transfer-speed of data to MS Access and enable MS Excel to access and change that same data in the future.

●Between the office-employees and the owner, I discussed the hardware requirements of the computers the company would need for the front office and the server utilizing the database [e.g. such as the speed of the CPU’s, how much memory, using cable connections vs wireless-LAN’s, and why firewalls were needed], and what type of database, the cost of the database, and the software could (and should) be used for future growth.

●Recommended and installed software (e.g. such as anti-viruses, security and backup software) to help keep the company running without any interruptions.

● Set up their server with the SQL 2005/2012 database, and the client’s computers with the ODBC-connections to enable MS Access to make changes to the database through its forms and the VBA code running behind the scenes.

●Added password security through MS SQL 2005/2012 to ensure only the employees and management could access the data.

●Linked MS Access 2003 to SQL 2005/2012 to accommodate for possibility they would need to move to the full-version of SQL in the future for the greater amounts of data.

●Through MS Access and MS SQL 2005/2012, I produced the required forms and reports for the front office (e.g. such as forms/reports for quotes and new orders of windows to be put in for their new clients), and forms for the warehouse (e.g. showing what windows had to be made and to check off each of the windows after being completed.)

●Programmed MS Access to interact with barcode-scanning software to create barcode-stickers for the windows, enabling them to scan and to record the date and time [down to the second], and what has been finished; thereafter, sending email to both the client and the company as soon as the order was completed.

●Working together with the client, I created the necessary math formulas to calculate the dimensions of the current and new windows produced in the warehouse.

●Much of the upgrades and improvements was done through SSMS [SQL Server Management Studio] – such as queries, tables, and stored procedures

●To ensure the client was satisfy with the result, I used the Agile-methodology.

United Vinyl (CONTRACT), Pico Rivera, California 9/2006 to 4/2010

Computer Consultant & Database Programmer

●Discussed the current network setup (clients and server) for the database and the future requirements of network to keep the data running quickly and constant throughout the LAN.

●After trouble-shooting the slowing and lost-connections in their wireless-network in the warehouse, I explained a wired-network would be safer and quicker.

●Added password security to ensure no unauthorized changes could be made by anyone outside the business.

●Explained to the owner why antivirus and security was needed for their network.

●Working together with network specialist, I setup the LAN-lines and network settings for the best network speed for their database.

●Transferred data, from a program utilizing MS Access as the backend, to SQL Express; and creating the forms and reports through MS Access using that as the front-end for current and future needs.

●Programmed MS Access to interact with barcode-scanning software to scan barcodes and record what has been finished and when [date and time].

●Migrated from MS Access to SQL Express, then later to MS SQL

●Used SSMS [SQL Server Management Studio], to add necessary queries, stored procedures, and tables.

K.I.S.M.I.F., Los Alamitos, California 2/1999 to 8/2006

Computer Programmer

●Through the utilization of ASP [HTML AND vb-scripting], I created web pages to show only what the US-branch should see and only the data the Mexico-branch should see.

●After asking what the client’s needs where, I created new database(s) and installed LAN’s for clients

●From the previous/new databases, I created new forms, reports, and the required Visual-Basic Programs under Access 97/2000 [aka VBA]

●Installing hard drives, memory, modems, Windows 98/ 2000 and Windows NT for clients’ computers

●Configured computers (e.g. adding more memory or changing motherboards and CPU’s), to make them run more efficiently

●Used Microsoft Studio in projects involving ASP, HTML, and vb/java scripting.

LARRY KLEIMAN AND ASSOCIATES, Los Alamitos, California 4/1994 to 12/1998

Office Assistant - Clerical, Organizational, and Computer-Related Skills

●Transferred client database to a more updated program

●Added specialized forms and custom macros, designed new database reports, installed network card and configured it to the current Windows 95 network

●Recovered damaged database files and responsible for periodic backups

COMPUTER SKILLS:

Software: MS Access 97/2000/2003/2010/2012, MS SQL 2005/2007/2008 R2/ 2010, MS Excel 2003/2010/2012, TOAD, FileMaker Pro 3.0, Database III+, & FrontPage

Operating Systems: MS-DOS (batch and configuration files), Windows 2000/XP/2007/VISTA/7/8, OS X, and UNIX

Languages: Visual Basic, VBA, C++, Turbo C, ASP, Pascal, Quick Basic, and Basic

Contact this candidate