Summary





Over 10 years of programming/consulting experience, Client/Server, database, application and reports development with extensive experience in Access, VBA and SQL.


Employment

July, 2007 -  September, 2007

Developed Access database for mortgage custom fields not provided with vendor database on Sql Server backend. Created tabbed forms with a number of VBA functions with ADO to import Excel worksheets based on user input through an open file dialog box. Form included subform with amortization data representing a one-to-many relationship. Form was based on complex Query using over 10 tables. Created report called from form to build SQL statements based on user s selection of multiselect listbox and date range from pop calendar forms. Created export functionality for GL data in VBA using DAO. Added and modified fields on custom table on backend Sql Server.
Technologies used : VBA, ADO, DAO, SQL, Access, Sql Server

April, 2007 -  June, 2007

Developed Access database to report show right licenses imported from Excel Sheets using VBA. Created form with multi-select controls and date range to build SQL condition calling reports using VBA. Created data entry form with dropdown combo boxes. Automated manual processes on existing Access Sales Revenue accounting system reducing user s need to reference Excel worksheets.
Technologies used used : VBA, SQL, ADO, MS Access

January, 2007 -  March, 2007
Toyota Motor Sales

Developed Access database from Toyota survey system which evaluates dealer performance. Created tables to store information on survey, evaluation and financial sales data for analysis. Created queries with modified fields to link with dealer data. Wrote VBA to import Excel files directly into Access. Created reports to show dealer standing from customer survey data.
Technologies used : VBA, SQL, MS Access

December, 2005 -  January, 2006

Developed parallel Access database from general ledger accounting system. Imported SAP reports into Access tables qualifying and modifying data for reconciliation. Created queries to cross reference data. Created queries to qualify exemptions. Created queries to separate out contract number and line item. Wrote VBA to clean text files before importing into Access.
Technologies used : VBA, MS Access

May, 2005 -  May, 2005

As developer added lookup feature to membership tracking database in Access. Created SQL statements for select function in VBA.
Technologies used : VBA, Access, SQL

November, 2001 -  April, 2005

July, 2001 -  November, 2001

Constructed SQL and Access reports to check for accuracy in accounting data. Repaired film and television show data both using VBA and manually. Analyzed data for redundancy and accuracy via cross checks from 1 internal and 2 internet databases to prepare data migration of accounting system to a client/server environment. Tested data fixes before going live. Assisted team members with SQL statements and Access reports.
Technologies used : VBA, Access, SQL

September, 2000 -  June, 2001

Made functional changes to Visual Basic accounting software. Added fields, updating views and managing users on Sql Server accounting database server. Maintained access between Sql accounting and Oracle Ad tracking databases.
Technologies used : Visual Basic, Sql Server, Oracle

July, 2000 -  August, 2000

As developer made changes to user interface and functionality on thin client Call Center software in Visual Basic. Changed table structures and modifying queries on Access Call Center database server. Installed Visual Basic client interface on users machines.
Technologies used : Access, Visual Basic

May, 2000 -  June, 2000

As instructor taught introduction class on Oracle and PL/SQL covering table creating and updating, triggers, stored procedure, views, manual table populating and system tables.
Technologies used : Oracle, PL/SQL

February, 2000 -  March, 2000

Developed simplified internal raffle drawing by coding to eliminate redundant ASP pages. Using Sql tools to track winners, prizes and raffles. Involved in setting up MS-Access queries to track winnings for prize team. Created SQL statements to track cheaters with multiple accounts, fake accounts or fake iBuddies by cross referencing accounts with identical passwords, suspiciously similar login names and indistinguishable IP addresses.
Technologies used : Access, ASP, MS SQL

November, 1999 -  February, 2000

As developer migrated daily sales data, new leads, into Oracle Database on weekly basis via Access. Modified table structures and relationships in Oracle database. Maintained Oracle reports for business development. Maintained TCL code in Scopus. Maintained Access mail merge applications using VBA.
Technologies used : VBA, Access, TCL, Oracle

April, 1999 -  October, 1999

Developed reports for Levy Tracking System in Access. Created MS-Excel sheets to replace REO Property look-up system from Oracle database in Unix. Migrated data into Access Subpoena Tracking System from acquired bank. Tracked performance issues and bugs for Access2 to Access97 Levy Tracking System.
Technologies used : Excel, Access 2/97 Unix

March, 1999 -  March, 1999

Developed form to modify related account data on Tax Payment Management system in Access. Added error trapping function throughout Tax Payment Management system in Access. Created Access app to import flat files with tax payment account data and output flat files.
Technologies used : Access, VBA, SQL

June, 1998 -  January, 1999

As developer created SQR reports to track insurance trends and display current policy statistics. Installed PeopleSoft on workstations. Created panels and panel groups adding menu items for reports, using People tools. Wrote SQL statements to check for duplicates on Sybase Database. Made minor modifications to the PeopleSoft Interface. Maintained Access reports for parallel testing of Payroll system to ensure data accuracy. Helped new users learn to utilize PeopleSoft features.
Technologies used : Access, Sybase, SQL SQR, Peoplesoft

November, 1997 -  June, 1998
Field Consultant

Developed Visual Basic apps in conjunction with Scopus CRM. Maintained stored procedures, triggers and tables on Oracle and Sybase databases. Modified VBA code in Access reports to incorporate database changes. Created tables, indices and views to replicate new Oracle database for migration to new version of Scopus.
Technologies used : VBA, Access, Sybase, Oracle

August, 1997 -  November, 1997
Developer

Developed Access report applications for pricing analysis of re-marketed cars. Automated data extracting, reporting and analysis function in Access using VBA. Extracting re-marketing data from Sybase Database.
Technologies used : VBA, Access, Sybase

April, 1997 -  July, 1997
Developer

Automated data manipulation processes in Access and VBA. Developed Access applications, using VBA, to process clinical trial data for outside clients in SAS and customized formats.
Technologies used : VBA, Access, SAS

September, 1996 -  February, 1997

Developed Visual Basic applications to sort flat files containing phone numbers. Maintained phone line and pager activation/deactivation reports and end-of-month and end-of-year financial reports in Access and VBA. Performed data cleanup in Sql of addresses and phone numbers. Performed data updates on Sybase-SQL for category/sub category tables.
Technologies used : VBA, Access, Sql, Sybase

February, 1996 -  September, 1996

Maintained VB cargo tracking applications using FoxPro as backend database. QA of Windows based cargo tracking, customer setup and security applications. Developed batch COBOL applications with embedded SQL to populate standard cargo carrier Agent Codes tables and Vessel Codes tables.
Technologies used : VB, FoxPro, COBOL, SQL, Windows, Unix

November, 1995 -  February, 1996
Help Desk Technician

Answered phone calls pertaining to computer problems. Guided users/callers through maintenance of local UNIX systems. Involved in setting up and deleting new user logins on UNIX system. Guiding users through setting up SQL scripts to run custom queries on database.
Technologies used : SQL Script, UNIX

February, 1995 -  August, 1995
Entertainment Partner

Developed Windows union association reporting applications in C. Maintaining existing customer account tracking applications. Cleaned up data files on UNIX.
Technologies used : C, UNIX

October, 1994 -  February, 1995

Recreated paradox accounts payable application in Access using VBA for right of way services.
Technologies used : VBA, MS Access

August, 1993 -  October, 1994

Developed COBOL address sorting and grouping batch applications on IBM Mainframe in MVT/JCL environment. Developed Group1 batch applications for letter creating, address correcting and USPS carrier route sorting on IBM Mainframe.
Technologies used : COBOL, JCL, MVT, IBM Mainframe

Education

Skills

Software Languages : VBA, Visual Basic, ASP, SQL, PL/SQL, SQR, C, TCL, HTML, COBOL Databases : Access, Oracle, MS SQL-Server, Sybase and Informix Operating Systems : Windows XP, UNIX, Linux. Foreign Languages : Spanish, Persian, some French.



Miscellaneous

Projects : Libertarian Party of California Panorama City, California February 2009 volunteer
Developed Access database using VBA to separate Excel worksheets imported member information on both national and state levels by county and exporting them back into Excel.
Technologies used : VBA, SQL, MS Access