| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLE PHONE NUMBER AVAILABLEEducation: Master of Science - Computer Information SystemsGeorgia Southwestern State University: Americus, Georgia Street Address
Bachelor of Arts - EnglishUniversity of Georgia: Athens, Georgia Street Address
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 applicationsOver 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 MediMediaOver 10 years experience with manufacturing and distribution systems25 years of experience as an Oracle Consultant for industry leaders (ESPN, Turner Network Broadcasting, Motorola, Symantec, Micron)Business systems analysisExperience with Object-Oriented, Object-Relational and Relational Data ModelsExpert performance tuning skills (TKProf, Explain Plan, Query Rewrite, Application Design)Database modeling, design and developmentExcellent oral and written communication skillsReferences:Patty Mitchell Sai Siva RamSenior Personnel Analyst Oracle Developer SupervisorLong Beach Unified School District Guthy-RenkerLong Beach, California Santa Monica, CaliforniaPHONE NUMBER AVAILABLE PHONE NUMBER AVAILABLEWork History:Contract Consultant, Change HealthcareChicago, IllinoisAugust 2022 August 2020Performed 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 DistrictLong Beach, CaliforniaSeptember 2019 March 2020Main 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, MarylandSeptember 2018 June 2019Main duties include resolving service requests for ACGIs 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 Golfers 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, ArizonaApril 2018 June 2018Main 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, ArizonaJanuary 2016 April 2018Main 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, CaliforniaJanuary 2015 November 2015Main 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, IdahoMay 2013 December 2014Modified 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, ArizonaAugust 2011 August 2013Designed 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, ArizonaJanuary 2011 August 2011Designed 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, IndianaJune 2010 August 2010Created 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, PennsylvaniaSeptember 2009 April 2010Responsible 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, ArizonaJune 2009 September 2009Created 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, TennesseeFebruary 2009 May 2009Responsible 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, OregonDecember 2007 December 2008Responsible 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, ArizonaApril 2007 June 2007Responsible 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, ArizonaApril 2006 November 2006Responsible 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, NevadaOctober 2005 February 2006Responsible 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, MexicoAugust 2005 September 2005Assisted 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 documentsContract Consultant, Pennsylvania Department of Environmental Quality Harrisburg, PennsylvaniaMay 2005 July 2005Modified 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, TennesseeDecember 2004 May 2005Tools 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, ArizonaOctober 2004 December 2004Addressed 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, ArizonaMay 2004 September 2004Assisted 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, TennesseeDecember 2003 May 2004Assisted 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, ArizonaAugust 2003 November 2003Performed 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, ArizonaMay 2002 July 2003Responsible 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, GeorgiaOctober 2001 - April 2002Responsible 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, ConnecticutFebruary 2001 - August 2001Responsible 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, GeorgiaOctober 2000 - January 2001Developed 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, ArizonaAugust 2000 - October 2000Responsible 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, OregonMay 2000 - July 2000Responsible for developing and implementing server-side stored procedures, packages and triggers in PL/SQL to serve as an Application Program Interface (API) for Symantecs website.Contract Consultant, Organic San Francisco, CaliforniaDecember 1999 - April 2000Responsible 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, ArizonaMay 1999 - December 2000Duties 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, GeorgiaJuly 1998 - April 1999Member 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, GeorgiaOctober 1996 - June 1998Responsible 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. |
