Systems Analyst
Core Education & Consulting ServicesJun, 1995 - Aug, 20005 yr 2 months
Converted Georgia Department of Education's School Nutrition, QBE and CPI systems to Oracle 8i using Pro-C, Visual C++, PL/SQL, VisualBasic 6.0/.NET, Active Server Pages (ASP-classical initially, introduced ASP.NET/VC++ at final-stage), Crystal Reports 6.0, ActiveReports, HTML, VBScript, JavaScript, AJAX designing and coding of web-based data maintenance program interface modules (using Oracle-inbuilt HTML directives HTF/HTP to generate page-code including embedded JavaScript) using PL/SQL, Pro-C; modelled (through ERWIN; setup tables and views for specific reporting and data storage requirements within these systems (including some multi-schema, calculated fields, crosstabs), setup and deployed VisualBasic DLL's (accessed through ASP calls) interfacting with Crystal Reports 6.0 or ActiveReports to implement web- accessible reports using Internet Information Server (IIS) met with end-client to analyse requirements for conversion of school data from flat-file/legacy systems to relational-type database as well as reporting needs Modified table-structure of FedEx' FLS (FedEx Logistical Systems) database (Sybase 10.0) to eliminate unneeded mutually-exclusive fields, modified FLS accessing program (Powerbuilder 4.0 on Windows 3.1) to use modified structure, administered its AIX server backing up both server and database; changed backup strategy to go to RAID device instead of tape-drive.