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 as an ETL Developer.
• Versed in writing Kornshell and BASH scripts.
• Assisted in defining development and deployment best practices for web services infrastructure.

TECHNOLOGY PROFICIENCIES:

Operating Systems / Software: Oracle Sun OS 5.10 (SPARC Solaris); Linux; Windows 7/10, SQL Developer 4.1, TOAD for Oracle 12 (and previous DB versions), OBIEE 11.1, PL/SQL Developer 10.0, JMS 2.0, ERwin R3.0, REST Web Services, Oracle BI Publisher 10.1, Microsoft Visual Studio Professional 2017 version 15.6, Microsoft Power BI 2016, Tableau, Talend, Apache Spark 2.4, Microsoft .NET Framework version 4.6, 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 EC2 Cloud Console, Microsoft SSMS 2008/2012, Oracle Forms 10.1 and Oracle Reports 6i; SQL Developer 3.2, PGP, IBM InfoSphere DataStage 9.1, SFTP, Oracle E-Business Suite R12, SQL Navigator 4.5, ODBC, QMF, Expediter, File-Aid, Lotus, SCADA system, 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, JIRA.

Languages: PL/SQL 11.0, SQL 2011, Kornshell, BASH, T-SQL, Python 3, C#, Java 8, Angular 7, 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. GitHub,Tortoise Subversion 1.9.5, PVCS, Compuserve Harvest, CA-LIBRARIAN. ServiceNow, AWS EC2, AWS Snowflake and Redshift.

CAREER PROGRESSION:

Database 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 Prime, NonPrime and Local Pontis Traffic, which matched Final Projection Data with Table Road Segment data. Created Python 3 scripts to check for accuracy.
• Completed other ad hoc data and DB object compare requests.
• Used Toad for Oracle and MS Visual Studio Professional 2017 to maintain source code.
• The contracting firm was Confidential .

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.

SQL Consultant

Confidential, Richmond, Virginia

Responsibilities:

• Translated complex SAS and MS Access 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.
• Created and deployed interactive dashboards with Tableau, that had dynamic pie, bar and line charts, showing funding and admin expenses, revenue/expense trends, for various mission locations.

Oracle Consultant

Confidential, Ashburn, Virginia

Responsibilities:

• Performed Oracle PL/SQL and functional setup testing of various packages for a large AWS Cloud migration and data warehouse 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 West Creek and McLean locations.
• Worked closely with data modelers and quality assurance testing.
• Monitored implementation to pre-production and production environments.
• Created test matrices to verify output. Developed dimension and fact tables for a data warehouse.
• 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

Senior Programmer Analyst

Confidential, Richmond, Virginia

Responsibilities:

• Performed Oracle analysis, Unix Shell scripting, PL/SQL coding and iterative testing for various Data Warehouse projects for the Confidential Medical Surgical subsidiary of this Fortune 14 company.
• Developed ETL mappings in tandem with Confidential mirrors using Oracle Warehouse Builder, versions 10.2 and 11G.
• Also developed with IBM Datastage 9.1.2.
• Used ERwin data modeler R3.0 for data modeling. Provided overall 24/7 production support and troubleshooting for the Business Intelligence section. Instrumental in integrating all data from newly acquired Confidential.
• Used Oracle BI Publishing for BI reports.

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 of the 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 Dominion Resources, a Fortune 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 program.
• 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.