Project Invoice Creation application and Timekeeper Reporting Application
Organization STRASBURGER & PRICE, L.L.P., Dallas, Texas
Project Type Off-site/On-Site Consultant and project development
Duration Mar 1998 – Dec 2001
Platform/OS Windows NT 4.0, Windows 95/98
Position Access and SQL Server Developer and System Analyst
Software SQL Server 6.5, Access 97/VBA
Description Invoice creation application creates EDI invoices for GM and Bristol-Myers, Nissan Motors, Travellers, and Legalguard. It imports data from JAVELAN application then based on client specific requirement it creates text invoice which complies with EDI specifications.

Timekeeper Reporting Applications imports timekeeper data from SQL Server base JAVELAN application with ODBC links and creates reports by division (Business, general, product and specialty litigation, Health Law etc.), and timekeeper types.
 
Key Features 
  • Update Client and Timekeeper data
  • Import Invoice, Expense and timekeeper info from Javelan
  • Create invoice
  • Create invoice text file
  • Reporting
My Tasks 
  • Design printable invoice application for Llyod’s. The application produces current, annual, and total invoice amount reports and summaries for management and the client.
  • Designed forms, reports, queries, macros, and modules for Invoice Creation application that imports invoice data for different clients (GM, Nissan Motors, Travelers, Bristol Myers, Legalguard, Liberty Mutual, Columbia) and create invoice reports or text files for EDI communication.
  • Designed an Access Invoice application for Hartford that imports data from JAVELAN into an access database.
  • Designed forms, reports, queries, macros, and modules for Timekeeper reporting application. Create interface to copy client and matter data into Carpe Diem, which is DOS-based timekeeper application, for synchronization purposes.