AddThis Social Bookmark Button
Nima Sepassi ( Available )
Irvine, California - 92612 USA
Expertise :Access, SQL, VBA
Status :Citizen
Job Type :
All - W2,1099
Position :Computer and Mathematical

Resume
 
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

Standard Pacific Homes Irvine , California
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

E ! Networks Los Angeles , California

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

Torrance , California E ! Networks Los Angeles , California
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

Nokia Inc Mountain View , California

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

San_Jose State University San_Jose , California

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

Sabbatical Year


July, 2001 -  November, 2001

Universal Pictures Universal City , California
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

L90 Inc Santa Monica , California
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

Reservation Center Inc Agoura Hills , California
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

Learning Tree University Irvine , California
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

iwin.com Westwood , California
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

Alcatel Calabasas , California
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

Washington Mutual Northridge , California
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

Bank of America Pasadena , California
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

WellPoint Blue Cross Westlake , California
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

The Fourth Tier Incorporated El Segundo , California
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

Nissan Motor Corporation Gardena , California The Fourth Tier Incorporated El Segundo , California
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

SmithKline Beecham Clinical Trials Van Nuys , California The Fourth Tier Incorporated El Segundo , California
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

GE Capital ResCom Marina del Rey , California
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

The Procyon Group South Gate , California
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

Pinkerton Security Encino , California
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

Burbank , CA Pinkerton Security Encino , California
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

HP-PC Consulting Playa del Rey , CA
Recreated paradox accounts payable application in Access using VBA for right of way services.
Technologies used : VBA, MS Access


August, 1993 -  October, 1994

North American Communications West City of Commerce , CA
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

Diploma Computer Programming Systems , Computer Learning Center - Los Angeles



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




Quick People Search



People like Nima

Popular skills