Daniel Jumpeter
ad5upp@r.postjobfree.com 602-***-****
Education: Master of Science - Computer Information Systems
Georgia Southwestern State University: Americus, Georgia 1996
Bachelor of Arts - English
University of Georgia: Athens, Georgia 1992
Varsity Track Scholarship, UGa Scholar-Athlete of the Year (1989)
SEC Academic Honor Roll (1990 & 1991)
Highlights of Qualifications:
●Over 25 experience creating and validating mission critical applications
●Over 10 years experience with GxP practices for industry leaders including BloodSystems Inc., Accredo Health, McKesson Health, Wolters-Kluwer, Arizona State Depart of Health Services, Maricopa County Health Department and MediMedia
●Over 10 years experience with manufacturing and distribution systems
●25 years of experience as an Oracle Consultant for industry leaders (ESPN, Turner Network Broadcasting, Motorola, Symantec, Micron)
●Business systems analysis
●Experience with Object-Oriented, Object-Relational and Relational Data Models
●Expert performance tuning skills (TKProf, Explain Plan, Query Rewrite, Application Design)
●Database modeling, design and development
●Excellent oral and written communication skills
References:
Patty Mitchell Sai Siva Ram
Senior Personnel Analyst Oracle Developer Supervisor
Long Beach Unified School District Guthy-Renker
Long Beach, California Santa Monica, California
Work History:
Contract Consultant, Change Healthcare
Chicago, Illinois
August 2022 – August 2020
Performed maintenance and new development on proprietary fraud prevention software. Performed daily maintenance on Oracle Forms and stored procedures using PL/SQL. Performed production of ad-hoc reports based upon requirements provided by the business analysts.
Contract Consultant, Long Beach Unified School District
Long Beach, California
September 2019 – March 2020
Main duties included assisting with an upgrade from Oracle Forms 11g to 12c. Performed daily maintenance on existing proprietary Human Resources software, adding enhancements as requested, redesigned several aspects of the application for performance and maintenance reasons. Assisted HR team with analysis and design of new application features. Also performed ETL functions with PL/SQL code.
Contract Consultant, ACGI Software Columbia, Maryland
September 2018 – June 2019
Main duties include resolving service requests for ACGI’s proprietary software. ACGI is a premier company in the Association Management Software industry, providing software solutions for large and medium-sized association organizations. Clients include the PGA (Professional Golfer’s Association), The American Association of Neurological Surgeons and the BMW Enthusiasts Association. Proprietary software was built with PL/SQL rendering HTML via calls to Oracle HTP package, Apex pages, Javascript and J-Query.
Contract Consultant, Arizona Dept. of Environmental Quality Phoenix, Arizona
April 2018 – June 2018
Main duties included design and development of Oracle database tables, functions, procedures, and packages. Also created VBA script for use in an Excel spreadsheet to consolidate data from multiple worksheets, perform data manipulation, and perform import into Oracle database via ODBC driver from Excel.
Contract Consultant, CNA National Insurance Scottsdale, Arizona
January 2016 – April 2018
Main duties included maintenance and enhancement of existing Oracle Forms and Reports. Assisted in database design and development for new requirements. Performed business analysis and application changes required for new insurance products as well as changes to the existing systems to meet new regulatory requirements.
Contract Consultant, Guthy-Renker Santa Monica, California
January 2015 – November 2015
Main duties included performance enhancement and script generation to assist with a data migration project. Helped to improve performance of data loading processes by enabling and utilizing parallel processes, BULK COLLECT procedures, indexing enhancements, pipelined functions and improved SQL queries.
Contract Consultant, Micron Technology Boise, Idaho
May 2013 – December 2014
Modified custom application to collect and store database auditing information from over 200 databases worldwide. Generated custom code to clean up massive amounts of stored data preventing automated jobs from completing. Designed and implemented Korn shell scripts to enable modification to database objects on Oracle databases worldwide. Designed and developed new archiving strategy for audit purposes.
Contract Consultant, Arizona Department of Health Services Phoenix, Arizona
August 2011 – August 2013
Designed and developed new custom application to import files containing information submitted by third-party mental health organizations and Native American Tribal groups regarding the assessment and treatment provided to mental health patients who qualify for Medicare and state assistance in Arizona. Utilized external tables, bulk processing, and object-relational design to improve processing performance.
Contract Consultant, McKesson Health Scottsdale, Arizona
January 2011 – August 2011
Designed and developed new custom application to import files containing information about physicians and other health care practitioners eligible to prescribe Class II Narcotics. Data files sent to McKesson from a 3rd-party vendor on a monthly basis are then processed through a matching algorithm to the current dataset and transformed for load into production tables. Created Oracle Directory and External Tables for use in the loading process.
Contract Consultant, Indiana Department of Corrections Indianapolis, Indiana
June 2010 – August 2010
Created new custom application to enable DOC staff to maintain data regarding prisoner early release programs. Custom code written in PL/SQL included server-side packages, procedures, and triggers as well as code embedded in Forms 10g modules. Created new data tables and model for the application. Performed investigation, analysis, design and coding for the new application. Also performed data-loading of existing data into the new tables.
Contract Consultant MediMedia USA, Inc. Yardley, Pennsylvania
September 2009 – April 2010
Responsible for maintenance and enhancements to an existing Oracle Forms 10g application. Maintained Oracle Forms (approximately 2 dozen) and server-side PL/SQL stored packages. Created custom code and improved performance of existing code in both Forms and stored packages.
Contract Consultant, Wolters-Kluwer, Inc. Phoenix, Arizona
June 2009 – September 2009
Created custom code to assist with loading and maintenance of historical patient, pharmacy and hospital data into a new data warehouse. Designed and created custom code to automatically create and maintain partitions for partitioned data tables during automated file loads. Created custom PL/SQL scripts to retrieve and transform data from historical databases and load into newly designed data warehouse tables via SQL*Loader utility.
Contract Consultant, Sedgwick CMS Memphis, Tennessee
February 2009 – May 2009
Responsible for creation, validation, and maintenance of reports for Sedgwick CMS, a workers’ compensation process provider. Created PL/SQL packages to retrieve and group data for reports; formatted reports using Crystal reports. Provided analysis and advice on performance improvements. Worked with data architects to determine table structures for maximum performance. Prepared and executed test scripts for unit, component, integration, and quality assurance testing.
Contract Consultant, Standard Insurance Portland, Oregon
December 2007 – December 2008
Responsible for maintenance of existing UNIX Korn shell scripts and PL/SQL packages and procedures to facilitate data transformation and loading. Designed, developed and maintained applications to create datafiles used to update client accounts. Updated all process documents involved with new data load requirements. Analyzed and created tables and load processes to increase performance and efficiency via PL/SQL for data retrieval. Assisted with ad-hoc assignments as necessary, including migration of an MS Access database to Oracle. Prepared and executed test scripts for unit, component, integration, and quality assurance testing.
Contract Consultant, US Airways, Inc. Phoenix, Arizona
April 2007 – June 2007
Responsible for maintenance of existing UNIX Korn shell scripts and PL/SQL packages and procedures to facilitate data transformation and loading into the US Airways data warehouse structure via SQL*Loader utility. Updated all process documents involved with new data load requirements. Analyzed and created tables and load processes to increase performance and efficiency via PL/SQL for data retrieval. Prepared and executed test scripts for unit, component, integration, and quality assurance testing.
Contract Consultant, Phelps-Dodge, Inc. Phoenix, Arizona
April 2006 – November 2006
Responsible for maintenance of existing custom financial application processing orders for copper and molybdenum sales for Phelps-Dodge, a leading mining organization. Utilized Oracle Forms and Reports as well as SQR and PL/SQL to maintain and enhance client application.
Contract Consultant, United Brotherhood of Carpenters and Joiners Las Vegas, Nevada
October 2005 – February 2006
Responsible for all aspects of Reporting for the Carpenters Union, including requirements gathering, analysis, design and development. Addressed multiple issues in existing reports and modified existing structures for performance and correct reporting purposes. Designed and developed custom PL/SQL packages stored in the database for generating report output. Assisted with data extraction routines necessary for populating newly created databases.
Contract Consultant, 4thSource, Inc. Merida, Mexico
August 2005 – September 2005
Assisted with development outsourced to Mexico from Accredo Health Systems. Made custom modifications to existing application used for the health care industry. Performed system analysis and created both functional and technical specifications documents
Contract Consultant, Pennsylvania Department of Environmental Quality Harrisburg, Pennsylvania
May 2005 – July 2005
Modified custom Oracle Forms application for an upgrade from 6i to 10g. Consolidated stand-alone custom code into database packages and procedures. Performed analysis on existing forms and created recommendations for improvement documentation. Performed QA testing and assisted with migration of forms from development to production environments.
Contract Consultant, Accredo Health Systems Memphis, Tennessee
December 2004 – May 2005
Tools utilized – Oracle Developer 2000, Oracle Forms 9i, Oracle 9iDS, Oracle 9iAS, PL/SQL, Oracle Reports, Rational ClearCase Designed and developed custom PL/SQL procedures for data extract responsible for reporting on client activity. Improved efficiency of existing SQL statements by analyzing with explain plan and restructuring procedures to utilize object-oriented techniques, nested tables, bulk bind and bulk collect utilities.
Contract Consultant, Maricopa County Health Department Phoenix, Arizona
October 2004 – December 2004
Addressed performance issues by restructuring forms and SQL statements to improve efficiency. Implemented custom error handling package for handling all exceptions encountered anywhere within Oracle program units. Created libraries for centralizing common program units.
Contract Consultant, Arizona Department of Revenue Phoenix, Arizona
May 2004 – September 2004
Assisted in business requirements gathering and analysis for new and existing modules within the system. Responsible for design and development of Oracle Forms and Reports enhancements to existing proprietary software solution for tracking and distribution of all revenues paid to the State of Arizona.
Contract Consultant, Accredo Health Systems Memphis, Tennessee
December 2003 – May 2004
Assisted with migration from Oracle Forms 5.0 and 6i to Oracle 9iDS platform. Performed modification and maintenance with Oracle Forms 9i, Oracle 9iAS, and Oracle Reports 9i.
Contract Consultant, Affiliated Computer Services (ACS) Phoenix, Arizona
August 2003 – November 2003
Performed system analysis and redesign of existing Oracle Developer 2000 Forms application used to track motor fuel shipments by various states to optimize performance with Oracle Forms 9i and Oracle 9iAS. Created object-oriented model to enhance performance and ease code maintenance.
Contract Consultant, Arizona State Retirement System Phoenix, Arizona
May 2002 – July 2003
Responsible for design and development of multiple systems used by the State of Arizona for tracking all facets of retirement and pension data for state and municipal employees. Acted as head of joint application design meetings for investigation and creation of business rules pertaining to all business units.
Contract Consultant, NAC International, Inc. Atlanta, Georgia
October 2001 - April 2002
Responsible for design and development of multiple systems used by the U. S. Department of Energy for tracking nuclear materials including reports, data validation routines, and data import/load routines. Data validation methods developed as stored PL/SQL packages and procedures.
Contract Consultant, ESPN, Inc. Bristol, Connecticut
February 2001 - August 2001
Responsible for performing detailed design and development of a new system to be used by 12 ABC television affiliates located across the country for maintenance of advertising orders. Developed server-side custom database packages, stored procedures, and triggers in PL/SQL. Responsible for data modeling, design and implementation of database table structures. Developed in depth documentation and process flow diagrams.
Contract Consultant, Lend Lease, Inc. Atlanta, Georgia
October 2000 - January 2001
Developed and implemented stored PL/SQL procedures and database triggers designed to customize Oracle Financials General Ledger Application module to meet specific customer needs.
Contract Consultant, Bloodsystems, Inc. Phoenix, Arizona
August 2000 - October 2000
Responsible for performing in-depth analysis and documentation of processes for the second-largest blood banking operation in the United States. Designed, developed and implemented customized forms and reports with Oracle Forms 4.5 and Reports 2.5 to be used in conjunction with Oracle Financials Application Human Resources module.
Contract Consultant, Symantec Eugene, Oregon
May 2000 - July 2000
Responsible for developing and implementing server-side stored procedures, packages and triggers in PL/SQL to serve as an Application Program Interface (API) for Symantec’s website.
Contract Consultant, Organic San Francisco, California
December 1999 - April 2000
Responsible for developing and implementing server-side stored procedures, packages and triggers in PL/SQL for applications maintaining customer and order information for large e-commerce websites.
Contract Consultant, Motorola Phoenix, Arizona
May 1999 - December 2000
Duties included creation and maintenance of UNIX shell scripts, maintaining forecasting software known as RDP, and creating PL/SQL stored packages to increase efficiency. All development performed on an Oracle 7 RDBMS.
Contract Consultant, Turner Network Broadcasting Atlanta, Georgia
July 1998 - April 1999
Member of a team creating a custom-built invoicing application responsible for over 1 billion dollars worth of revenue annually. Duties include application analysis, architecture design, and application development using PL/SQL packages and stored procedures with an Oracle 7.x server.
Programmer/Analyst, Union Camp Corporation Savannah, Georgia
October 1996 - June 1998
Responsible for implementation and maintenance of an automated machine scheduling system, including installation and configuration of all Oracle and application software, for a large international manufacturing corporation.