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.