We provide IT Staff Augmentation Services!

Oracle Consultant Resume

SUMMARY:

  • Extensive experience as a software developer and system analyst. Last twenty years working with Oracle, Microsoft, and other technologies, in diverse projects, in all phases of the Systems Development Life Cycle.
  • Experienced and effective in tuning of complex SQL code using a wide range of techniques.
  • Huge run times reduced by as much as 96 percent.
  • Solid experience setting up field level, functional, and overall throughput test plans and matrices, as well as setting up dedicated, multi - tenancy test environments. This included hostile type test scenarios.
  • Team player and leader that can determine requirements, analyze problems, make important early observations, and present feasible alternative solutions to stakeholders, managers, users and technical staff.
  • Have strong competency in writing stored procedures, functions, database triggers and packages using SQL, PL/SQL and T-SQL.
  • Experienced in creating tablespaces, tables, indices, views and other database objects. Managed users, privileges and roles.
  • ETL and Data Warehouse design and development.
  • Versed in writing Kornshell and BASH scripts.
  • Six years of experience in both Oracle Forms and Oracle Reports.
  • Six years of experience as an ETL Developer.

TECHNOLOGY PROFICIENCIES:

Operating Systems / Software: Oracle Sun OS 5.10 (SPARC Solaris); Linux; Windows 7/10, SQL Developer 4.1, TOAD for Oracle Base 12 (and previous versions), PL/SQL Developer 10.0, Informatica 9.5, HP Project and Portfolio Mgt Center, Atlassian Fisheye 3.7, Oracle Apex 5.0, Eclipse Neon, Jenkins, DBMS SCHEDULER, Version One Ultimate Edition 15.2, MS Visual Studio, SSIS 2008/2012, MS Sharepoint 2016, Oracle Warehouse Builder 11G, Oracle Designer, AWS Cloud Console, Microsoft SSMS 2008/2012, Oracle Forms 10.1 and Oracle Reports 6i; SQL Developer 3.2, PGP, Confidential InfoSphere DataStage 9.1, SFTP, Oracle E-Business Suite R12, SQL Navigator 4.5, ODBC, QMF, Expediter, File-Aid, Lotus, MS Access, PuTTY SSH, Filezilla 3.8.1, MS Excel 2010, MS Word 2010, MS Powerpoint 2010, MS Outlook 2010, BMC Remedy 2011, Mercury Quality Center 2008, Visio 2013.

Languages: PL/SQL 11.0, SQL 2011, Kornshell, BASH, T-SQL, Java 8, vi editor commands, Java Script 1.6, MongoDB 3.0, SQL*PLUS 9.0, HTML5, CSS, XML, OAS htp, CRON, ProCOBOL, DB2, COBOL, MVS JCL, CICS, CA-Ideal, FoxBase+.

Databases: Oracle 8, 9i, 10G, 11G Release 2, 12C, MongoDB 3.0, MySQL, SQL Server 2012, Tortoise Subversion 1.9.5, PVCS, Compuserve Harvest, CA-LIBRARIAN.

CAREER PROGRESSION:

Oracle Consultant

Confidential, Richmond, Virginia

Responsibilities:

  • Created detailed procedures that synchronize verified GIS spatial data with existing Table Road Segment data, with calculated field updates, 'copy' segments, 'split' segments, deletes, and newly added segments.
  • Created materialized views, tables and procedures in Oracle 12C, for the RNS and SHIPS database schemas for Confidential, which matched Final Projection Data with Table Road Segment data.
  • Completed other ad hoc data and DB object compare requests.

Lead Database Developer

Confidential, Richmond, Virginia

Responsibilities:

  • Modified and tested Oracle packages for clients in support of various incentive and rewards programs.
  • Enhanced existing SQL statements for extracting data and automatic report delivery.
  • Some Perl scripting also. Clients included Wells Fargo and Branch Banking and Trust.
  • Used Jenkins, Subversion and Toad.

SQL Consultant

Confidential, Richmond, Virginia

Responsibilities:

  • Translated complex SAS and MS SQL scripts into more powerful Oracle PL/SQL functions, procedures, and providing test results in support of Medical Claims Quality Assurance Testing. Set up database multi-tenancy to supply a central testing environment.

Oracle Consultant

Confidential, Richmond, Virginia

Responsibilities:

  • Performed Oracle PL/SQL tuning of migration scripts and views that load Oracle data to staging tables for an enterprise migration to a SalesForce platform via Informatica Cloud.
  • Verified throughput with various test queries.

Oracle Consultant

Confidential, Ashburn, Virginia

Responsibilities:

  • Performed Oracle PL/SQL and functional setup testing of various packages for a large AWS Cloud migration project.

SQL Performance Engineer

Confidential, Richmond, Virginia

Responsibilities:

  • Performed Oracle PL/SQL analysis, design, and coding of ETL procedures for the Basel II Risk Calculator IT project at Confidential at both their Confidential and Confidential locations.
  • Worked closely with data modelers and quality assurance testing.
  • Monitored implementation to pre-production and production environments.
  • Created test matrices to verify output. Maintained Scrum story and Change Order grids.

Oracle Consultant

Confidential, Brentwood, Tennessee

Responsibilities:

  • Performed Oracle PL/SQL coding of packages and Oracle object Types to interface with various Java front end Customer Confidential applications for Confidential.

Senior Programmer Analyst

Confidential, Richmond, Virginia

Responsibilities:

  • Performed Oracle analysis, Unix Shell scripting, PL/SQL coding and iterative testing for Information Warehouse projects for the Confidential Medical Surgical subsidiary of this Confidential 14 company.
  • Developed ETL mappings in tandem with Confidential mirrors using Oracle Warehouse Builder, versions 10.2 and 11G.
  • Also developed with Confidential Datastage 9.1.2.
  • Provided overall 24/7 production support and troubleshooting for the Business Intelligence section.
  • Instrumental in integrating all data from newly acquired Zee Medical Company.

Oracle Developer

Confidential, Richmond, Virginia

Responsibilities:

  • Performed Oracle PL/SQL analysis, coding, and UNIX shell scripting for a major data warehousing project (Adapt) using Oracle Warehouse Builder for the Confidential .

Oracle Developer

Confidential, Fort Lee, Virginia

Responsibilities:

  • Performed Oracle PL/SQL analysis, coding, Pro-COBOL, Oracle database tuning, PERL scripting, and UNIX shell scripting for the SAVES accounting system for Confidential.
  • Projects included enhancing the supplier payment program so it will intercept invoice payments for the IRS, if they are delinquent on taxes, and other reconciliation type report runs.
  • Profoundly worked with high-performance PL/SQL features such as REF Cursor, Composite Data Type such as Records, Collections, Bulk Collect, Autonomous Transactions.

Oracle Consultant

Confidential, Richmond, Virginia

Responsibilities:

  • Performed PL/SQL analysis and coding to create Oracle packages and procedures using Toad, UNIX shell, Cognos, Harvest and Lotus software tools in support of a major telemarketing application for service, products and commodities for Confidential , a Confidential 500 company with operations in 12 states.
  • This application was a major component for increased company-wide retail sales.

Oracle Consultant

Confidential, Richmond, Virginia

Responsibilities:

  • Analyzed, designed, coded and tested Oracle Web applications, Oracle Forms, Oracle Reports, and various database objects for the Confidential Confidential program.
  • Projects included the Confidential Retail Store Management System (allowing all Virginia retail stores direct access to the Confidential intranet) and developing SQL packages for a Medicaid Billing extract subsystem.
  • Also developed Client Certification, Vendor Mgt, and Financial Mgt areas.
  • Used SQL Navigator, PVCS, Mercury Quality Center and CRON.

Oracle Consultant

Confidential, Richmond, Virginia

Responsibilities:

  • Programming with Oracle Reports 9i, I created and maintained over 50 sales and proforma invoices for the Purchase Sales Inventory system for Confidential, Inc.
  • Analyzed formulae from large Excel spreadsheets to create Oracle report modules that perform the same task.
  • Also programmed with Forms 9i and PL/SQL scripts in TOAD.
  • Used PVCS for module management.

Oracle Consultant

Confidential, Richmond, Virginia

Responsibilities:

  • Performed PL/SQL coding to supply data for a high profile web site for the Licensing section of the Confidential .
  • Programmed and documented integrated letter and certificate creation procedures for the Confidential application.
  • Used TOAD, MS Word field merge, and F-Secure SSH File Transfer.

Oracle Consultant

Confidential, Richmond, Virginia

Responsibilities:

  • Interviewed managers and users, and designed, coded and tested Oracle Forms, Oracle Reports, and various database objects for the Confidential Confidential program.
  • Coded SQL scripts and UNIX shellscripts to process nightly bank Confidential payment files.
  • Also used SQL Navigator, PVCS, and Mercury Test Director and CRON.

Systems Analyst

Confidential, Richmond, Virginia

Responsibilities:

  • Participated in a full requirements analysis and wrote the core section of an RFP for contractual bidding for a larger ten million dollar police system to eventually replace the in-house bridge system.
  • Wrote the core section of an RFP to install laptop computers in the police cruisers.
  • Proposed, designed, and coded a police Daily Activity system that captured data from the 911 center, eliminating police on-site paperwork and providing drill-down displays of each officer's activity and hardcopy activity reports.
  • Also did enhancements on this system based on user feedback, to add more drill-down screens and speed up Oracle report run times.
  • Used Oracle Forms 4.5 and Oracle Reports 2.5.
  • Conducted periodic demo sessions for the police and IS management on the new systems to keep them informed of progress. Some DB2 program maintenance was also needed on my part to keep the legacy PRISM system going until December of 1999.
  • Designed and coded an automated welfare real time checks system for city Social Services in COBOL.
  • Using Oracle Designer and SQL Plus 8.0, developed a new datamart for the Citizen Requests department as part of a larger city data warehouse initiative as follows:
  • Interviewed the managers and business analysts to explain its benefits and determine their requirements for decision-support data and wrote a vision document. Recorded the business questions that the data warehouse must answer. Defined the overall technical architecture and performance requirements.
  • Specified a preliminary project plan with detailed steps and time lines. Assigned resources, staff roles, and responsibilities.
  • Interviewed the DBA and other individuals who had knowledge of the source system data and structures. Analyzed the data to identify quality problems and areas of loading complexity. Located areas where data was missing, to determine whether the source data can support the users' business requirements. Recorded detailed metadata about the sources, data quality, and business rules.
  • Created a dimensional server model diagram in Oracle Designer by separating the ERD for the current system into its discrete business processes. Designed the Data Definition Layout (DDL) for a permanent dimensional structure.
  • Developed transformation logic for mapping source data into the target data warehouse schema.
  • Designed the end-user query environment, including any required routine reports. Verified the design in an iterative process with managers, analysts, and the DBA.

Senior Technical Consultant

Confidential, Richmond, Virginia

Responsibilities:

  • Provided IMS, VSAM, and CICS programming development in a client-server environment for the Automated Program to Enforce Child Support ( Confidential ) at the Confidential .

Information Systems Consultant

Confidential, Richmond, Virginia

Responsibilities:

  • Provided analysis and programming support.
  • This included coding the first production MVS JCL for a new claims processing system.

Hire Now