SUMMARY

• Create System Documentation for specific subsystems, e.g., Orders Module for Victoria Supreme Court
• Create HTML presentations as mockups of proposed screens
• Design of Web Services for intra - application communications WSDL definition functions
• Senior Support Analyst, resolve technical issues for large-scale Court Case Management application. Uniface 4GL-based application for Oracle and SQL Server databases.
• Design Unit Test procedures for new software Procedural documentation
• Work directly with clients to resolve software-related issues in Court Case Management systems
• Environmental analysis of systems to resolve systems performance issues on database and application servers Database analysis tuning for SQL Server 2005/2008/2012 databases
• Work with tools such as SQL Developer/DBA Studio, trace files, debugger source code to analyze problems and resolve them
• Writing PL/SQL procedures to correct data in customer environments.
• Analysis of Uniface 4GL, Java and .NET class code to assist data tracelog analysis in problem resolution

Work Summary

Confidential

Independent Consultant

• Technical Analyst with Maximus, Inc. predecessor to Constellation Software
• Development of custom programs in Oracle 9i, 10g and SQL Server 2005 environments
• Business process analysis, Software analysis resolution via technical design documents

Confidential

Project Manager

• Oversee the installation, management, user training, software and related hardware purchases for Court Case Management Systems CCMS in Municipal Court. Participated in conversion and integration of legacy case management and accounting systems data into CCMS.
• Represent the court with vendors and outside agencies for all of case management software and related functions work closely with upper management and elected officials.
• Provide strategies, and business process analysis, under direction by elected officials, for new development of software to migrate to paperless court
• Installed and managed Document Imaging, eFiling ePayment applications in support of CCMS
• Supervised technical personnel in all phases of support of CCMS application: desktop support, programming, report writing, helpdesk
• Managed legacy Foxpro Accounting software, until integration into CCMS.

Confidential

Oracle DBA/Developer

• Experienced managing versions 7 and 8i. Performed patch management
• Migrated from version 7 to 8i, laid groundwork to migrate to 10g
• Performance tuning using TOAD, Enterprise Manager, own scripting Automated routine tasks
• Design of databases for archived records, other applications
• Developed internal standards for many DBA processes: performance monitoring, backup/recovery, database troubleshooting
• Automated scripts for Storage management tablespace, table, index growth, extent management, performed data reorganizations
• Automated backup strategies for Oracle user data and archive log management, using Data Protector OmniBack, and system backup software
• Unix shell scripting to support program-generated DML statements
• Developed PL/SQL procedures as add-ons to the CCMS, e.g. eSubpoena electronic subpoena application for police agencies, featuring case updating, extraction, data transmission, and records management at remote sites
• Programs to cleanse data acquired by OCR scanning of documents
• Collections software in conjunction with agency requirements for 1st and 2nd tier collections of A/R's
• Bureau of Motor Vehicles extract transmission processing error corrections
• Data cleansing of parties migrated from case-based to identity-based applications
• Code table maintenance and updates required by statute
• Automation of financial processing
• Calculation of receivables
• Bank reconciliation transmissions and updates import and export into Oracle database, using SQL Loader and scripting
• Accounts receivable payment calculators
• EPay case updating and auto-email to end users
• Improved month-end reporting
• Automated many routine case management functions, based on event-driven tasks
• Experienced with ad hoc reporting, e.g. Crystal Reports, Oracle Reports
• Limited experience with Visual Basic 6- developed eSubpoena application some maintenance of other small applications.

Confidential

Unix Systems Administrator

• HP medium 9000 series RP 0 systems and SAN
• Performed Systems software and OS version upgrades and 11i,
• Systems software administration of SAN Business Copy, LVM, SAM, SendMail, networking, security, Glance performance monitoring, Swinstall, Vi, Perl, Awk, Sed, SSH, FTP
• Experienced scripting in Korn, C, Bourne Posix, Bash shells for system, database, and application software
• Experienced building and security hardening Linux FTP server for use in DMZ to communicate to police agencies

Offering s

Systems Analysis and Programming, with a background in Project management Database Management. PL/SQL for Oracle or SQL Server.

Business Process Analysis, Gap Analysis for Product integration System Design Life Cycles Data Analysis and Transformation, familiarity with Waterfall Agile methodologies of Project Management.

Technical Skills Summary

System Software: Oracle: 7,8i,10g,11g, SQL Server 2005/2008/2012, TOAD, SQL Developer, Enterprise Manager, DBA Studio. DMS2 Unisys . HPUX: SAN Business Copy, LVM, SAM, SendMail, networking, security, Glance performance monitoring, Swinstall, Data Protector OmniBack, SSH, FTP. Shells: Bourne, Korn, C. Linux: Bash.

Operating Systems: Windows Server 2003, 2008 R2, XP, Vista, 7, HPUX v /11 i, Linux RedHat Fedora 13 .

Programming Languages: SQL, PL-SQL, T-SQL, WSDL, Uniface by Compuware, COBOL, HTML, XML, Javascript, Awk, Sed. VB 6.

Hardware: HP9000 series K460 RP8400. Various small desktop platforms