2000 - 2002 Technical Development Team Leader
· Team Leader Oracle Financials (General Accounting) Development Team. Developed packages, stored procedures and database triggers to interface between legacy system and Oracle Public Sector Financials Applications. Developed a custom interface between legacy accounting and property tax apportionment systems to Oracle GL. The interface automatically calls journal import if no errors are found during accounting flexfield validations. If errors are found this is reported back to the client using a custom report called directly from the interface process.
· Developed SQR scripts to maintain and manage interfaces between Oracle Applications and PeopleSoft HR/benefits modules. Peoplesoft needed to pass benefits and payroll data to Oracle GL for Accounting and statistical purposes. These SQR scripts are created to select the data, formatted into a flat file and then passed picked up by a custom interface process into Oracle GL Interface tab