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.
|