PROFILE

• MS Access Developer/Database Systems Analyst, with extensive experience in database design and software customization. Competent in SQL query, VBA, customer relations management programs, marketing database analysis, and accounting. Expert in providing creative solutions, optimum efficiency, and automation for the full spectrum of corporate marketing, sales, and client management.
• Advanced accounting, financial, and sales analysis experience. Excellent analytical and mathematical skills.
• Exceptionally motivated, dynamic and dedicated, with grace and a great sense of humor.

WORK EXPERIENCE

Senior Consultant, Confidential

MS Access Developer / Database Systems Analyst, Confidential

• Utilized MS Access to design, manipulate, link, and customize database features and programs to fit diverse client needs, including sales, marketing, client management, and accounting/finance.

1. Developed programs to produce tables, SQL queries, forms VBA , macros, reports, and various functions within MS Access, and linked data to SQL Server, SharePoint, Oracle, Paradox, Fox Pro, dBASE, Excel, Outlook, Exchange, Texts files, and HTML files.

2. Produced a variety of complex reports for use by the full spectrum of company employees.

3. Designed, managed, split, merged, and converted databases.

4. Utilized VBA in appropriate projects.

5. Evaluated programs to detect logic and syntax errors, and made modifications accordingly.

6. Expert consultant in client relations management, using ACT, MOM, Telescript, Peachtree, and other programs.

7. Customized databases and programs to increase efficiency and profitability.

8. Developed training procedures for employees, including step-by-step computerized processes. Documented procedures, allowing others to work with the database in the future.

Routine Responsibilities

a. MS Access Developer/Programmer/Consultant.

b. Mail Order Management MOM Administrator.

c. ACT Program Business to Business Sales Administrator.

d. TeleScript Program Residential Sales and Business Administrator.

e. Process and control of orders/promotions/invoices/returns.

f. Account receivable statements, collections, update customer information .

g. Generate regular and ad-hoc reports.

h. Data integrity and validation.

i. Manage outbound and inbound sales promotions and projects using TeleScript.

j. Manage collection calls and generate reports from MS Access I created de program .

k. Network Windows Server 2003 users maintenance.

l. Generate Big Mailer order files, invoices, and labels.

• m. Update and maintain programs.
• n. Update contacts and customers data through NCOA.

Selected Projects

• Residential Customers, B2B, and Fundraising Departments
• Purpose: Customize database features to create detailed reports in support of sales, management, marketing, accounting, and collections functions. Clean up database and fix errors. Enhance control of customer auto-renewal and product inventory processes.
• Technology: MS Access, MS Excel, ODBC to MOM
• Accomplishment: a Facilitated business evaluation and decision-making ability, b Increased customer service
• efficiency and overall sales, c Increased auto-renewal sales by 10 , d Reduced AR balance and prevented
• customer attrition.

Relations Organizer

• Purpose: Automate customer and vendor relations for Graphics Department. Produce comprehensive activity reports.
• Technology: MS Access
• Accomplishment: a Increased efficiency and profitability, b Enhanced
• systematic communication with customers and vendors.

Annual Customer Mailer

• Purpose: Automate the process of preparing orders and shipment of products.
• Technology: MS Access, ODBC to Res-MOM Fox Pro
• Accomplishment: a Dramatically decreased order preparation and shipment time,
• b Increased accuracy and prevented customer complaints.

E-Marketing

• Purpose: Create unified system of e-marketing and integrate the company website with the internal database.
• Technology MS Access, MS Excel
• Accomplishment: a Created new sales and increased profits, b Increased the number of active customers, c Automated electronic payment system.

President/Consultant, Confidential

Selected Projects

Confidential

Accounting Systems Design

• Purpose: New accounting systems design.
• Technology: PeachTree advanced , MS Access, MS Excel.
• Accomplishment: Systematized service and product accounting procedures.

1.Marketing Systems Design

• Purpose: Create B2B marketing and client management system.
• Technology: ACT, MS Access, MS Excel
• Accomplishment: Facilitated sales for multiple users and increased profits.

Confidential

Accounting Systems Design

• Purpose: New accounting systems design.
• Technology: PeachTree advanced , MS Access, MS Excel
• Accomplishment: Systematized factory product accounting.

Confidential

Baha'i Local Membership BLM

• Purpose: Identify and organize member characteristics, including talents, skills, education and training, and
• participation in community activities. Apply CRM principles to documenting community member
• relations.
• Technology: MS Access, MS Excel
• Accomplishment: Facilitated the full spectrum of membership and community human resource management.

IT and Accounting Consultant, Confidential

a. Consultant to over 440 small-medium member businesses with diverse information technology and

accounting needs.

b. Developed and computerized customer management systems for Chamber of Commerce.

c. Customized accounting software QuickBooks Pro, Peachtree, and Figaro for corporate clients.

Chief Financial Officer and Treasurer, Confidential

a. Designed computerized accounting system and managed the financial affairs of the NSA.

b. Computerized the full spectrum of the NSA activities, including creation of a national membership database

to organize member characteristics, talents, skills, education and training, and participation in community

activities.