SUMMARY:

Resourceful and innovative, goal oriented developer with proven ability to design, code, test, install and maintain flexible business applications for analysis and data migration. Exceptional skill for analyzing work flow, identifying priorities and scaling development projects to fit time and budget constraints. Successfully implemented automated tools to streamline business processes, manage costs, implement quality control, improve customer relationship management, launch new business lines and expand existing business while reducing operating costs.

COMPREHENSIVE SKILLS:

• Establish user priorities to maximize return on investment by focusing on high business value functions.
• Analyze work flow processes to streamline business practices and identify unmet needs.
• Revisit all the above as user requirements evolve with implementation of new tools and changing business environment.
• Create sophisticated, easy - to-use data entry forms that in corporate data lookup tables and error checking to minimize errors and insure completeness.
• Embed business knowledge in form and report design to support complex transaction processing, maintain consistency and continuity in work products, and minimize time..
• Use OLE automation to in corporate Outlook, Excel and Word capabilities in Access forms.
• Implement CDO Com interfaces to add Gmail functionality to Access form.
• In corporate Quickbooks SDK to seamlessly create and update Quickbooks transactions from Access forms, eliminating the need to manually update accounting systems.
• Create custom ribbon for Excel and Access applications.
• Create database tables, relationships and queries.
• Design queries to update Access tables from imported data and to export data to external databases.
• Establish data relationships, keys and indexes.
• Automate importing and exporting data between Excel spreadsheet, CSV files and databases.
• Complex formula for summarizing, sorting and analyzing data.
• VBA macros and user forms.
• V-lookups, pivot tables and graphs.
• Seamlessly integrate QuickBooks accounting functions with desktop business applications.
• Update QuickBooks data and external databases using SDK and Excel spreadsheets..
• Install front-end applications on user work stations with shared data in separate back-end database, test multi-user access and use, identify throughput issues, and fine tune performance.
• Instruct users in routine application maintenance such as updating data lookups and system tables.
• Work with management to refine work processes and implement user .
• Advise on best practices for insuring data integrity and security.

SOFTWARE:

• Microsoft Access, Excel and Outlook
• Visual Basic for Applications (VBA)
• Quickbooks Software Developer’s Toolkit (SDK)

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco

Responsibilities:

• Created custom analytical applications integrating Microsoft Excel and Access functionality to support business groups decision making and data tracking.

Confidential, San Francisco, CA

Responsibilities:

• Created custom MS Access/VBA application to import data from various sources, compile into a single reporting database and create reports for distribution to managers at store, market and territory level.
• Use MS Excel files to create reports which are then published as pdf documents.
• Enhanced an existing MS Access reporting application to in corporate currency conversion for distribution to management in US, Japan, China and Mexico.

Confidential, San Diego, CA

Responsibilities:

• Using QuickBooks Software Developer’s Toolkit (SDK) and Microsoft Visual Studio, created console application to create invoices and apply payments and credits in Quickbooks from data files.

Confidential, Foster City, CA

Software Developer

Responsibilities:

• Enhanced existing MS Access database that served as front-end to SQL Server database.
• Created forms to automate importing numerous Excel spreadsheets to SQL Server tables by selecting files in specified folder, and modified existing reports.

Confidential, Redwood City, CA

Software Developer

Responsibilities:

• Created custom MS Access application track client referrals.

Confidential, San Francisco, CA

Software Developer

Responsibilities:

• Modified and enhanced their existing MS Access/VBA Student Registration and Class Management system, created an automated payroll module using teacher class schedules, and provide statistical reports for grant application, annual reports, financial audits and business analysis using MS Access reports and Excel spreadsheets.

Confidential, San Francisco, CA

Software Developer

Responsibilities:

• Designed, developed and provide ongoing maintenance for Confidential.
• This MS Access/VBA application GMail, Word and file command languages to automate all business processes: client contact information and history, contractor management, project management, document storage and retrieval, and invoicing and accounts receivable.
• This application seamlessly integrates Access, Word, Outlook and Gmail to produce custom documents, email documents, upload/download documents to FTP sites, automatically email reminders and notices to contractors, email project progress to clients, create and email invoices to clients and track accounts receivables.

Confidential, Mendocino, CA

Software Developer

Responsibilities:

• Developed custom applications for agricultural exporters in the California Central Valley, Oregon and Washington to track inventory, create export documents and invoice clients.
• These MS Access/VBA applications integrated third-party software to seamlessly connect with commercial truck scales to automatically update inventory records from incoming and outgoing truck loads, and used Outlook and Excel to email export documentation to several parties at once.
• Using Intuit’s QuickBooks Software Developer’s Toolkit, automated most bookkeeping functions to eliminate the need for duplicated efforts: created QuickBook customers, jobs, invoices, received product into inventory, created bills and posted payments to QuickBooks directly from MS Access applications.

Confidential, San Francisco, CA

Software Developer

Responsibilities:

• Designed and developed Confidential. This MS Access/VBA project seamlessly integrates Outlook, Word and QuickBooks to provide contact management, inventory management, invoicing and sales support for this Jackson Square retail art gallery.
• The application is unique in using embedded graphics in records, forms and reports to represent inventory items and produce high quality sales materials.
• It integrates Intuit’s QuickBooks Software Developer’s Toolkit (SDK) to create QuickBooks customers, inventory items and invoices directly from Confidential , eliminating the need to manually enter invoices and payments in two separate applications.
• The application also integrates Word documents with Access reports to produce sales materials and QuickBooks to email high quality graphic materials to clients.

Owner

Confidential, San Francisco, CA

Responsibilities:

• Designed, developed, installed and maintained custom database applications, specializing in tracking and analysis systems deployed as stand-alone desktop systems and PC networks, data migration and data warehousing.
• Also provided on-site employee and telephone support.