ZAREH GASPARIAN

*** *. ****** ******

GLENDALE, CALIFORNIA 91202

818-***-****

acdnf7@r.postjobfree.com

OBJECTIVE

Microsoft Excel/VBA, Access Programming Position.

EXPERIENCE

Modern Engine

VBA Developer February 2013 – Present

Using Microsoft Excel with Microsoft Access back end; created inventory

and invoicing application. The program is used for inventory control of three

auto parts locations. Very strong use of ADO and SQL queries.

NACA Logistics (Kforce)

VBA Developer July 2012 – September 2012

Studied the functionalities of some existing tariff rate templates and

made revisions for better functionality and performance.

Created new Import/Export tariff rate templates to be used by corresponding clients.

Capital Group (eTeam/InfoSys)

VBA Specialist May 2012 – June 2012

Three weeks project. Worked on converting a set of 8 Microsoft Excel

and 2 Access 2003 files to Microsoft Office 2010 format.

This was to provide CG with the information on the effort required for

them to convert their remaining many Office 2003 files

Fox Entertainment (VallySoft)

VBA Developer December 2011 – March 2012

Tax Amortization Automation. Testing several methods for uploading

financial data into PeopleSoft. Automated the process of converting

Excel spreadsheets into text files. Modified an existing Microsoft Access

database to store information regarding the progress of the project.

PIMCO (Tentek)

Excel VBA Developer September 2008 – November 2011

Created reports using data from tables located in various databases.

Extensive use of advanced ADO and SQL queries.

Modified VBA codes in MS Excel to be compatible with MS Excel

versions 2003 – 2010.

Created MS Access tables for historical data storage.

Obj100

The Walt Disney Company (Modis)

Excel VBA Developer August 2006 – July 2008

Created Return Reserve reports based on downloaded data from SAP. (These reports originally 285 Meg – reduced to 7

Meg). Created Balance Sheet analysis

report for Budget-Variance analysis.

Created MS Access Database from scratch to consolidate scattered data from two other SQL Databases and created

time sensitive reports.

Ownit Mortgage Solutions (Global Software Solutions)

Excel VBA Developer June 2005 – July 2006

Designed tables in Access and created Excel Add-In to upload rates and related information into Access database.

Used ADO to retrieve data from SQL Server and created numerous reports in Excel (Secondary Marketing). Modified

an existing Access database for Secondary Marketing, adding more functionality. Advanced use of Excel Object

Model and SQL Statements.

Texas Instruments (Volt)

Excel VBA Developer May 2004 – June 2005

Developed Excel templates for test results collection reporting and analysis.

Created a COM object in VB for automated test results entry into a shared

Excel workbook.

Developed Excel templates to incorporate test procedures, requirements and

specification.

Created Excel Add-In to migrate all test results and specification into Oracle

Database (used ADO, SQL Statements).

Fred Sands Professionals

Programmer-Business Applications November 2002 – December 2003

Developed a customized and user friendly application using MS Access

and MS Excel, for income and expense analysis and reporting. The program

is also used for accounts reconciliation.

Bank of America (Yoh IT)

Excel VBA Developer April 2002 – September 2002

Design, modification, documentation and recommendation involving

numerous projects. Highly advanced operation and usage of Microsoft

Excel/VBA, Access and Word.

21st Century Insurance Company (Career Strategies)

Financial Reporting (Excel Expert) August 2001 – September 2001

Incorporated information from numerous Budget Models into a financial

Obj100

report prepared in Excel.

Independent Contracts

Worked for clients in LA area July 2000 – July 2001

Manufacturing Company

-

Created Excel templates for profit and expense analysis for a custom cabinet

manufacturing company. Created invoicing application in MS Access 2000.

- Real Estate Company

Developed a fully customized and user friendly MS Access Application for

agent commissions calculation and reporting (customized menus and toolbars).

Created Excel VB Application for loan calculation and analysis.

- Healthcare Company

Developed MS Access 2000 Database Application to retrieve data from

SQL database file for monthly variance analysis and special reports

production. This application would export queried data to an Excel

workbook for analysis and reconciliation of certain accounts.

On this project I used VBA codes (especially ADO and SQL statements) in

Access and Excel.

SunAmerica Financial

Excel VBA Programmer January 1999 – July 2000

(Independent Contractor)

Developed an upgradable program for monthly yields calculation

for Variable Annuity Accounting Department. This program was in

Excel involving User Interfaces and VBA code to create customized

Reports.

Assisted Financial Reporting Department to enhance monthly

reporting process for off site subsidiaries (Access VBA).

Assisted Budgeting Department on annual budget reporting process.

Modified programs in VBA for creating monthly reports.

Modified variety of programs in VB., Excel and Access.

SKILLS

Exceptional Mathematical and Analytical skills

Expert in Microsoft Excel 2003 - 2010, and Access 2003 - 2010

Expert in SQL statements and ADO.

EDUCATION

Microsoft Certified Professional

(Designing Desktop Applications with Microsoft Visual Basic 6.0)

California State University, Los Angeles

Obj100

Bachelor of Science, Civil Engineering, 1992

Obj100

Contact this candidate