|
Project |
Consulting Management Application (CMA) |
| Organization |
DBA CONCEPT Consulting Inc.
, W. Los Angeles, California |
|
Project Type |
On-site Consultant and project development |
|
Duration |
Mar 1998 – Present |
|
Platform/OS |
Windows Server NT 4.0/2003, Windows 2000/XP/Vista |
|
Position |
Access/ASP/XML/SQL Server Developer and Business Process
Analyst |
|
Software |
SQL Server 2000, Access 2000/XP, Front Page, Visual Interdev,
ASP, VB, IIS 5.0 |
|
Description |
It is a complete Consulting information system for managing
small and medium size home base consulting business.
Consulting Management Application is a complete Consulting
information system which gives easy project entry, billing, account receivable and
payable, time card, commission, bank activities, client balance management, Invoice
creation and management reporting. |
 |
|
Key Features |
- Clients, Contacts, Employees, and Assets Data Entry
- Billing and Invoice Creation
- Account Payable and receivable
- Time Card Entry and reporting
- Commission Calculation
- Management Reporting
- Budgeting
- Bank Activities
- Security
- Prospects Follow-ups
- Payroll and Tax Reports (W-2, W-4, MISC-1099)
- Income Statement, Balance Sheet, Cash Flow, General
Ledger
- Ratio/Risk Analysis
- Daily Issues and Tasks
- Project Entry
- Commission Calculation
- Reporting
|
|
My Tasks |
- Design forms, reports, views, stored procedures, tables,
macros and web pages.
- Analyze client,
project, A/P, A/R, contact, payroll, tax filling, bank activity and cash flow, invoice
and time card info processes and create backend database objects and front-end interfaces.
- Create interface
for sending data into Excel file for Balance Sheet, Income statement, and statement
of Cash Flow.
- Create reports
for sales, payments, expenses, invoices, taxes (W-2, 1099 etc) and mailing lists.
- Create
www.conceptconsulting.com Internet site that connects to back-end SQL Server database
for real-time project status, contacts, time card entry, reports generation and
feedback info.
- Rewrote CMA with
Cool:Plex 3.5 for demonstration purpose.
- Reengineered
client side CMA with ASP code and created an Intranet site for data entry, update
and reporting functions.
- Update Internet
and Intranet site by using XML and SQL Server 2000.
- Create SQL Server
tasks for database maintenance.
|