Developer Project
Resume:
ZAREH GASPARIAN
GLENDALE, CALIFORNIA 91202
*****.*********@*****.***
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