Resume of

JAMES KOSHENINA

***** **** *** ** *** 1403

Houston, TX 77084

ad4wt1@r.postjobfree.com

303-***-****

PROFESSIONAL SUMMARY:

Oracle Certified Professional (OCP) Developer with 38 years of Oracle experience, which includes Oracle 12c, Oracle Reports, 33 years PL/SQL programming (Ref Cursors, Dynamic SQL, Database Triggers, Packages, Procedures, Functions), Custom Oracle web application development/conversion, and Oracle Financials 11i. Security clearance.

TECHNICAL SKILLS - EXPERTISE:

Software: Oracle 12c(12.2.1.3),11g,10g, 9i, 6i, 6.0, 5.0, 4.5, 4.0, 3.0, 2.3, 1.0; Oracle Reports 12c,11g, 10g, 9i, 6i, 6.0, 5.0, 3.0, 2.5; Oracle DBMS version 12.2,11.2, 9.6, 9i, 8i, 8.0, 7.3, 6.0, 5.0, 4.0; Microsoft Teams, Cherwell Services Manager, SQL*Developer 21.2.1; Azure DevOps, PVCS; TOAD; Erwin

Operating Systems: 38 years UNIX (Vi Editor, Shell Scripts).

PROFESSIONAL EXPERIENCE:

Senior Oracle Programmer consultant, working for Florida Department of Agriculture in Tallahassee, FL from August 2021 to March 2024.

Updated the AIMS application to remove Stop 1 Approval step. This involved updating the form tab programming code for the ship to & mail to off the form.

Updated the AIMS application to prompt purchasing agents to send PDF documents via email directly to vendors. Added new hold buttons, developed new email forms and developed new reports which informed the purchasing agents of whom documents were sent to at what time with what attachments to the vendor.

Created an inventory application which would identify which Oracle Forms/Reports/Packages/Objects reference Chart Of Account information. This provides an information reference to know what code will need to be updated to conform to Florida Palm COA information. check written to vendors. Developed a new Oracle package to perform this.

Updating the AIMS application to automate the Warrant Indexing process which eliminates staff from manually entering a voucher number in for every purchase order.

Senior Oracle Programmer consultant, working for Florida Lottery in Tallahassee, FL from October 2013 to August 2021.

Automated the Auto Reconciliation Records from Sun Trust Bank into Oracle Fortune Tables using Oracle Packaged Procedures and batch processes firing shell scripts.

Automated creation of records for Pick Games, Powerball, Jackpot Triple Play, and Mega Millions using Oracle External Tables, Oracle Packaged Procedures and Korn Shell scripts on UNIX servers.

Developed a Department of Lottery Graphics and Support Services Request System from scratch using Oracle Forms. Developed an Oracle Badge Access Form and Employee Information Update Form for security. Developed table creation scripts, primary keys, foreign keys, indexes, sequences, triggers, functions, procedures, package and grant scripts. Developed Oracle batch processes which execute UNIX shell scripts each day.

Developed the Administrative Oracle Forms, reports, and database level triggers. Incorporated menu and form level security. Defined all Admin, User, and Browser roles.

Customized the Oracle Event Management System (EMS), the Customer Service Tracking System (CSTS), Lottery Identification System (LIDS), and GETIT System.

Led multiple hands on training classes for lottery employees on how to use the Request System, Support Services, and Employee Information Update Form. Embedded a online users guide into the menus.

Converted all 24 Lottery applications from 10g to 11g R2 including all Forms, Reports, Menus, Libraries, etc. Installed WebLogic Server on local machines.

Instructor of a PL/SQL class for Florida Lottery developers.

Senior Oracle Programmer consultant, working for Hargray Communications in Hilton Head, SC from May 2013 to October 2013.

Performed extensive break fixes in HES Oracle Forms/Reports area. Fixed financial fixes for customers in DNP 60 day remove cycle, cc override fee bug, to freeze the DNP removal reason from being changed, and export report fixes.

Added additional parameters to include in reports generated from HES.

Modified Oracle Packages/Procedures/Forms to accommodate a new customer created in HES. The 2 fields are an alternate phone and email address with a manager override available to the Oracle Form.

Senior Oracle Programmer consultant, On contract to NAVAIR in Jacksonville, Florida from August 2008 to March 2013.

Worked on changes to Navy applications including PSA & MPT Pro using Oracle WebLogic Forms & Reports 11g. Modified PL/SQL Packages, Procedures, Functions, triggers, views.

Installed WebLogic 11.1.1.6 on my machine & converted Oracle Forms/Reports 10g to Oracle WebLogic 11.1.1.6 forms on a Windows 7 64 bit machine.

Using Oracle WebLogic Forms & Reports 11g, developed the NAVAIR Depot Maintenance Project ID JON Cross Reference System.

Developed the Create ERP Project, Modify Project, and Query Project Forms. Developed an ERP batch error report and query project report.

Definitions of these forms & reports came from Use Cases. The project used the waterfall project life cycle development methodology.

Modified the PSA QMGR Form adding additional tab pages to display the rauto_queue detail information.

Modified Oracle Packages to accommodate new requirements for client.

Senior Oracle Programmer consultant, On contract to RXAMERICA in Salt Lake City, Utah from May to August 2008.

Worked on automating ETL processes for the PCS File extractor and Response processors for RxAmerica.

Wrote PL/SQL packages & shell scripts to load flat files into staging tables for processing.

Developed a trigger code generator to prevent character data from entering numeric fields within 39 tables.

Senior Oracle Programmer consultant, On contract to EDS in Washington, D.C. from September 2007 to May 2008.

Provide support to the Immigration Customs Enforcement (ICE) NForce application, which tracks immigrants illegally crossing borders into the US.

Performed production support by fixing multiple defects within the custom application.

Performance tuned Packaged Procedures to identify how SQL statements could be rearranged to enable them to run faster.

Developed PL/SQL packages and procedures to enhance the application.

Developed an area of the NForce application called GEO Spatial. This included identifying where illegal immigrants have been captured in the US, by inserting the information into NForce’s Oracle 10g forms by latitude and longitude.

Senior Oracle Programmer consultant, On contract to Lockheed Martin in Denver, CO from July 2006 to September 2007.

Developed an Oracle Financials 11i custom bankruptcy application to track all case, debtor, and collection agency information. This application is comprised of a single tabular form, stacked canvases, 4 reports, and 5 packaged procedures. This application also includes advanced query techniques embedded as well as record creation procedures and calls to the Case Recoupment Main Entry form.

Updated PL/SQL Packages to reflect new Oracle instances being added to production, test and QA environments 6i to 10g.

Modified packages to add and consolidate accounts for end of the year close programs.

Modified the Oracle Financials 11i TMA CR Main Entry Form to turn on and off item permissions to various blocks within the form and reinstate them based on the Action Officer Data.

Developed two new general ledger and account payable aging matrix reports to track invoices past due. Two functions were developed to calculate totals for Invoices by appropriation and limit.

Other Positions:

Oracle Corporation, Litton Guidance & Control, Raytheon, ICE/Dept of Homeland Security),Perrigo, Amgen, Allergan, Southern Air Transport, Warner Bros., Countrywide Home mortgage loans, New Mexico Dept of Public Safety, LPL Financials

TECHNICAL TRAINING:

Oracle Certified Professional in SQL, PL/SQL, Oracle Forms, Oracle Reports

Systems Design and Analysis using Oracle9i and Oracle9i Developer Suite

Oracle9i Database Administration

Administering Oracle9i Application Server

PL/SQL Program Units 9i (Adv. PL/SQL) 2001 class

PL/SQL Training (3 days instructor-led class, beginning and advanced levels)

Case Relational Systems Design (3 day instructor-led class)

Extended Relational Analysis (3 day instructor-led class)

Oracle Version 6 Architecture and Administration (3 day instructor-led class)

Oracle Version 6 Performance Tuning (2 day instructor-led class)

Oracle Version 5 to 6 DBA Migration (2 day instructor-led class)

SQL*Forms version 3.0 Foundation and Advanced Training (5 day instructor-led class)

Oracle Database Administration version 5.1 (3 day instructor-led class)

SQL*Forms 2.3 training (3 day instructor-led class)

Oracle Developer/2000 Training

Oracle Forms 5.0 & Reports 3.0 new features (3 day instructor-led class)

Oracle Web Application Server: Develop Web-Based Applications (4 day instructor-led class)

SQL*Forms 4.5 Foundation Training (4 day instructor-led class)

Oracle Clinical

Oracle AOL (Application Object Libraries) GUI Standards (10 day instructor-led class)

Advanced Oracle Forms 4.5

EDUCATION:

San Jacinto College, Laporte, TX, 1983 - Completed courses toward a degree in Computer Science

Texas A&M University in College Station TX, 1987 - Completed courses toward a degree in Computer Science

Barrios Technology in Houston,TX - Completed summer internship from June 1984 to August 1984. Was asked to continue working full time at Barrios Technology in August 1984.

Contact this candidate