Sales Management
Resume:
Michelle D. Guilbeault
San Francisco CA 94118
acpf6j@r.postjobfree.com
SUMMARY
Resourceful and innovative, goal oriented developer with proven ability to
design, code, test, install and maintain flexible business applications for
data migration, warehousing and analysis. 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.
SOFTWARE
Microsoft Access 2007, 2010, 2013, 2015 Microsoft Excel 2007, 2010,
2013, 2015
Visual Basic for Applications (VBA) Microsoft Office Automation
Quickbooks Software Developer's Toolkit (SDK) Microsoft Visual
Studio
SQL (Structured Query Language), HTML, XML Crystal Reports
COMPREHENSIVE SKILL SET
USER REQUIREMENTS GATHERING
. Employ iterative approach central to the Agile development methodology
to define user needs by meeting with all individuals who use the
application, application data and work products.
. 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.
INTERFACE DESIGN
. Create sophisticated, easy-to-use data entry forms that incorporate
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 training time.
. Design simple table-based reports as well as complex multi-tiered,
drill down analytical reports driven by SQL queries.
. Use OLE automation to incorporate Outlook, Excel and Word capabilities
in Access forms.
. Implement CDO Com interfaces to add Gmail functionality to Access
form.
. Incorporate Quickbooks SDK to seamlessly create and update Quickbooks
transactions from Access forms, eliminating the need to manually
update accounting systems.
. Organize complex applications through use of intuitive menus (and
Access 2007 ribbons) based on business functions and work processes.
DATABASE DESIGN
. Create database tables, relationships and queries.
. Design queries to update Access tables from imported data and to
export data to external databases.
. Link front-end applications to one or many ODBC databases.
QUICKBOOKS INTEGRATION
. Seamlessly integrate QuickBooks accounting functions with desktop
business applications.
. Update QuickBooks data and external databases using SDK and Excel
spreadsheets..
IMPLEMENTATION
. 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
training.
. Advise on best practices for insuring data integrity and security.
PROFESSIONAL EXPERIENCE
Consultant, database application developer 2005 - Present
Working primarily with small businesses, used Agile development methodology
and the automation capabilities of Microsoft Office suite and QuickBooks
Software Developer's Toolkit to design, implement and continually
adapt/upgrade high value-added business applications. Clients include high-
volume service and retail clients.
Community Music Center of San Francisco, San Francisco, CA 2014 -
Present
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.
Tigerfish Transcription, San Francisco, CA 2005- Present
Designed, developed and provide ongoing maintenance for TOPS (Tigerfish
Order, Production, & Sales Application). 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.
Fred Darland and Associates, Mendocino, CA 2012 -2014
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
(SDK), 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.
Sarah Stocking Vintage Posters, San Francisco, CA 2005 -2014
Designed and developed SAMS (Sarah Stocking Asset Management System). 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 SAMS,
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, Future Edge, Inc., San Francsico, CA 1984 - 1998
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 training and telephone support. Major clients
included Pacific Bell, Pacific Gas and Electric, Miller Freeman, Inc. and
Matson Navigation.
Damon Raike and Company, Commercial Real Estate Brokers, San Francisco, CA
1979 - 1983
Created spreadsheets to summarized detailed rental cash flows from
commercial properties for discounted cash flow analysis to support
investment sales department, and developed easy-to-use templates for sales
staff use.
Steven Roulac Company, Real Estate Consulting, San Francisco, CA 1983-
1984
Developed and maintained complex analytical spreadsheets and data models.
ADDITIONAL BUSINESS EXPERIENCE
Vintage Poster Art, San Francisco, CA. 1998 - 2005
Owned and managed retail art gallery that specialized in vintage European
advertising posters with on-site custom framing workshop and web site.
Responsible for all aspects of gallery management: sales, inventory
acquisition, marketing, human resources, accounts receivable and payable,
bank reconciliation and payroll.
EDUCATION AND SKILLS
B. A. Economics and Development Studies, University of California, Berkley,
California
DESIGN/DEVELOPMENT PROJECTS BY INDUSTRY
NON PROFIT
? Working with the Community Music Center of San Francisco, modified and
enhanced their existing MS Access/VBA operations management system to
automate payroll and create statistical reports for grant application,
annual reports, financial audits and business analysis.
AGRICULTURAL EXPORT
? Working with Fred Darland and Associates, 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 (SDK), automated most bookkeeping functions to
eliminate the need for duplicated efforts: created customers, jobs,
invoices, received product into inventory, created bills and posted
payments to QuickBooks directly from MS Access applications.
RETAIL
? Designed and developed SAMS (Sarah Stocking Asset Management System)
for Sarah Stocking Antique Posters in San Francisco. This MS
Access/VBA project seamlessly integrated Outlook, Word and QuickBooks
to provide contact management, inventory management, invoicing and
sales support for this Jackson Square antique poster retail 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 SAMS, 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.
BUSINESS SERVICES
? Designed and developed TOPS (Tigerfish Order, Production, & Sales
Application) for Tigerfish Transcription Services in San Francisco.
This MS Access/VBA application integrated Outlook (later replaced with
Gmail), Word and file command languages to automate all Tigerfish's
business processes: client contact information and history, contractor
management, project management, document storage and retrieval, and
invoicing and accounts receivable. This application seamlessly
integrated 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.
TELECOMMUNICATIONS
? Working with the Pacific Bell - Industry Markets Division
reconciliation team responsible for redistributing assest between
Pacific Bell and AT&T per the court ordered breakup of the AT&T system,
developed database and spreadsheet tools identify assets to relocate,
quantify the financial adjustments required, manage administrative
processes to transfer assets, and create reports and graphs for
management teams and executives of both companies. Data generated by
this application provided the basis for a financial settlement between
Pacific Bell and AT&T which ended the legal transistion phase and
provided the basis for ongoing systems in both companies to complete
the transfer of assets.
? As a product of the original reconciliation project, designed and
developed TABS (Tracking and Analysis of Billing Systems) to support
billing systems reconciliation projects for Pacific Bell - Industry
Markets Division. This PC system includes data entry and validation,
reporting, analysis and trending modules and has been adapted for use
by both Special and Switched Access reconciliation groups.
? Designed and developed TABS (Tracking and Analysis of Billing Systems)
to support billing systems reconciliation projects for Pacific Bell -
Industry Markets Division. This PC system includes data entry and
validation, reporting, analysis and trending modules and has been
adapted for use by both Special and Switched Access reconciliation
groups.
? Designed and developed an automated file transmission and order
processing system for ATL Communications, an outsourcing special and
technical services company for long distance carriers. This system
allows ATL to receive orders via modem, process the orders,
automatically fax reports, and return completed orders via modem.
PUBLISHING
Developed several accounting and tracking applications for Miller Freeman,
Inc., a member of the United Newspapers Group.
MARS - Miscellaneous Revenue Accounts Receivable System:, a data
entry system for billing information. Generates invoices and produces
general ledger and aging reports.
CCS - Commissions Calculation System, calculates commissions due
sales people based on data downloaded from mainframe billing system.
MOE - Medical Order Entry System, a client-server order entry system
for a unit that publishes medical newsletters distributed to clinics
worldwide. Includes contracts, ordering, and accounting modules.
HRBF - Human Resources Head Count Budgeting and Forecasting System, a
budgeting and forecasting system for employee salary and incentives.
This system is used by the Human Resources department and department
managers.
RATS - Return Accounts Tracking System, tracks accounts referred to
collection agencies. Includes numerous financial and management
reports.
ENVIRONMENTAL SERVICES
? Developed the Environmental Inspections Tracking System for Pacific Gas
and Electric - Environmental Services Department to track and analyze
department's inspection findings.
Also developed the Agency Inspections Tracking System to track and
environmental inspections initiated by local, state and federal
government agencies.
? Developed the Hazardous Materials Inventory Database for Pacific Gas
andElectric - Power Generation Division to track existence and quantity
of hazardous materials in powerplants. When PG&E sold off power plants
in in1998 this application was adapted for more general use and sold to
purchases of power plants by PG&.
? Developed the Health and Environmental Inspections Tracking System for
US West, Inc. to track and analyze health and safety as well as
environmental inspections for US West facilities and constructions
sites.
? Developed trending and analytical reports for ERM - West, Inc., an
environmental consulting firm. Worked with teams of hydrologists and
testing labs to develop tracking and reporting applications and
procedures for ongoing consulting engagements.
Also developed a windows-based reporting system for the accounting
department that downloads data from their general ledger system into a
PC database, calculates employee benefits, produces numerous
pre-defined reports, and allows ad hoc reporting.
SHIPPING
? Designed and developed SBR (Sales Booking Reports), a marketing support
system for Matson Navigation Company. This LAN-based system produces
management and analysis reports from mainframe data for marketing
managers in headquarters and eight ports on the West Coast and Hawaii.
Also developed DTS (Document Tracking System), a corporate shipping
document tracking system.
ADVERTISING/PUBLIC RELATIONS
? Developed the Demographic Data Ordering Application for NameFinders
Lists, Inc., a direct mail marketing company. This application
calculates the number of names to order from demographic service firms
in various categories (zip code, age, family income) according to
criteria entered by users. The application is designed to accommodate
selection criteria for businesses ranging from retail chains to
banking.
Also developed several-special purpose response analysis applications
used by NameFinders to manage large accounts.
? Developed a Media Tracking and Invoicing Application for Douglass,
Rosewater & Brown, an advertising and public relations company. This
application tracks magazine and newspaper advertising projects,
schedules placement of ads, invoices, and tracks vendor payments.
Also developed a corporate contacts database.
PHARMACEUTICALS
? Developed a physician call tracking system for the Merck Scientific
Study Center in Hungary for Merck & Co., a multi-national
pharmaceutical company. This application is also being used by Merck's
marketing office in Moscow.
Contact this candidate