Resume

Sign in

ETL and SQL Developer

Location:
Richmond, VA
Posted:
December 02, 2019

Contact this candidate

Resume:

Douglas Allen Mundy

Mechanicsville, VA – 804-***-**** – adazci@r.postjobfree.com

Software Engineering ~ IT Management ~ Business Analysis

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.

Have strong competency in writing stored procedures, functions, database triggers and packages using SQL, PL/SQL and T-SQL.

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.

ETL and Data Warehouse design and development for very large databases (1 TB plus).

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 in Agile environment that can determine requirements, analyze problems, make important early observations, and present feasible alternative solutions to stakeholders, managers, users and technical staff.

Experienced in creating tablespaces, tables, indices, views and other database objects. Managed users, privileges and roles.

Versed in writing Kornshell, JavaScript, and BASH scripts.

Twenty years of SQL and PL/SQL, and five years of T-SQL coding.

Six years of experience in Oracle Forms and Oracle Reports.

Six years of experience as an ETL Developer using Microsoft SSIS, Informatica, and Oracle Warehouse Builder.

Accomplishments

Letter of Commendation for seamless major system upgrades in the Richmond, Virginia Police Department by Chief of Police Jerry Oliver and several memos of commendation from other former supervisors.

Planned the implementation of a bridging system for the Richmond Police Department including major analysis and programming.

Composed a request for proposal, along with a full requirements analysis, regarding a ten-million-dollar IT project for the Richmond Police Department.

Formulated a new automated system for Richmond Social Services to do real-time checks on welfare services.

Developed programming for client-server model used at the Virginia Department of Social Services Automated Program to Enforcement Child Support contract.

Provided technical guidance to the U.S. Navy RADIAC program and also to the U.S. Department of Education as a team leader for the Pell Grant Disbursement System, including maintenance, coding and extensive FIPS compliant documentation.

Career Progression

Database Consultant 07/2019 – 11/2019

Bank of America Richmond, Virginia

At the Bank of America Operations Command Center, I increased the amount and scope of automated incident remediation scripts, using BMC Atrium Orchestrator. The XML scripts handled database and application alert events coming through IBM NetCool, for Oracle, Sybase and SQL Server platforms. Also created and coordinated projects with engineers located in Singapore, India, Charlotte, and New York. Used Jira to facilitate daily Agile team work.

My contracting firm was Data, Inc.

Database Consultant 05/2019 – 06/2019

Perspecta, Inc Mechanicsville, Virginia

Performed SQL Web coding enhancements to the Public Employees Benefit Board (PEBB) system via remote VPN connection for the state of Oregon. Used Toad for Oracle and Visual Studio 2019, Azure DevOps Git Repository Version 16.1 and Microsoft .NET Framework version 4.7.

Database Consultant 07/2017 – 01/2019

Virginia Department of Transportation Richmond, Virginia

In support of GIS data integration for the Virginia Department of Transportation Planning Division: 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. Completed other ad hoc data and DB object compare requests. Used MS Visual Studio Professional 2017 to also maintain source code.

Lead Database Developer 03/2017 – 07/2017

Connexions Loyalty, Inc. Richmond, Virginia

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 10/2016 – 03/2017

Magellan Medicaid Administration, Inc. Richmond, Virginia

Translated complex SAS and T-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. Did ETL with Microsoft SSIS 2016 for some MS SQL data. Used Jira to facilitate daily Agile team work.

Database Consultant 02/2016 – 08/2016

ChildFund International Richmond, Virginia

Performed Oracle PL/SQL and T-SQL tuning of migration scripts and used SSIS to load Oracle and SQL Server data to staging tables for an enterprise migration to a SalesForce platform via Informatica Cloud. Verified throughput with various test queries.

Oracle Consultant 12/2015 – 02/2016

Dfuse Technologies, Inc. Ashburn, Virginia

Performed Oracle PL/SQL and functional setup testing of various packages for a large AWS Cloud migration and data warehouse project. The client was the US Department of Transportation.

SQL Performance Engineer 01/2015 – 12/2015

Capital One Bank, Inc. Richmond, Virginia

Performed Oracle PL/SQL analysis, design, and coding of ETL procedures for the Basel II Risk Calculator IT project at at both their West Creek and McLean locations. Worked closely on an Agile Scrum team 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 with Version One.

Oracle Consultant 10/2014 – 11/2014

American Home Patient, Inc. Brentwood, Tennessee

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

Senior Programmer Analyst 10/2011 – 10/2014

McKesson, Inc. Richmond, Virginia

Performed Oracle and SQL Server analysis, Unix Shell scripting, PL/SQL, T-SQL coding and iterative testing for various Data Warehouse projects for the McKesson Medical Surgical subsidiary of this Fortune 14 company. Developed ETL mappings with SSIS 2012, and Oracle Warehouse Builder, versions 10.2 and 11G. Also developed with IBM 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. Also used SSMS, SSIS, SSRS 2012 for MS SQL ETL and data reporting.

Oracle Developer 07/2011 – 10/2011

Virginia Department of Social Services Richmond, Virginia

Performed Oracle PL/SQL analysis, coding, and UNIX shell scripting for a major data warehousing project (Adapt) using Oracle Warehouse Builder for the Virginia Department of Social Services.

Oracle Developer 06/2009 – 06/2011

Mantech International Fort Lee, Virginia

Performed Oracle PL/SQL analysis, coding, Pro-COBOL, Oracle database tuning, PERL scripting, and UNIX shell scripting for the SAVES accounting system for Defense Commissary Agency of the U.S. Defense Department. 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.

Database Consultant 05/2008 - 04/2009

Dominion Energy Richmond, Virginia

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 Energy, a Fortune 500 company with operations in 12 states. This application was a major component for increased company-wide retail sales.

Database Consultant 02/2007 - 05/2008

Virginia Department of Health. Richmond, Virginia

Analyzed, designed, coded and tested Oracle Web applications, Oracle Forms, Oracle Reports, and various database objects for the WIC program. Projects included the WIC Retail Store Management System (allowing all Virginia retail stores direct access to the WIC 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.

IS Consultant 02/2006 - 01/2007

Universal Leaf, Inc. Richmond, Virginia

Programming with Oracle Reports 9i, I created and maintained over 50 sales and proforma invoices for the Purchase Sales Inventory system for Universal Leaf, 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 SSIS for some MS SQL Server 2005 tables. Used PVCS for module management.

Database Consultant 06/2004 - 11/2005

Virginia Department of Social Services Richmond, Virginia

Performed PL/SQL, JavaScript, and T-SQL coding to supply data for a high profileweb site for the Licensing section of the Virginia Department of Social Services. Programmed and documented integrated letter and certificate creation procedures for the LicenseEase application. Used TOAD, MS Word field merge, and F-Secure SSH File Transfer.

IS Consultant 08/2002 - 12/2003

Virginia Department of Health Richmond, Virginia

Interviewed managers and users, and designed, coded and tested Oracle Forms, Oracle Reports, and various database objects (Certification, Medical, Financial Management, etc.) for the WIC program. Coded SQL scripts and UNIX shellscripts to process nightly bank WIC payment files. Also used SQL Navigator, PVCS, and Mercury Test Director and CRON.

Systems Analyst 09/1996 - 07/2002

City of Richmond Richmond, Virginia

Completed major analyses and programming for a Y2K bridge system for the Police Department using Oracle Forms and Oracle Reports. This major effort was on time and successful, despite some last-minute personnel turnover on my team. Acting project leader for ten months after the first project leader was terminated. The system processed over a half million incidents per year, was instrumental in reducing the workload of the police and provided more immediate and accurate crime data.

Interviewed all sections of the police department in preparation for Y2K and documented forty different detailed data workflows. This effort had never been done before and was commended by the police. The workflows were later added to the police academy curriculum.

Completed a requirements analysis, plan and logical model for a data consolidation of several police data systems.

Used FTP file transfers with custom PL/SQL code and Oracle Transparent Gateway with SQL *Loader to reformat and pull data to Oracle tables from the following source systems:

A Data General 2000 system that housed these Business Basic subsystems: 911 (CAD), Warrants, Accident Reports, Pawnshop, and Fingerprint.

"PRISM", an IBM CSP/DB2 hybrid mainframe system which contained Incident, Arrest, Juvenile Violation, Stolen Vehicle, and Property table data.

PC-based dBaseIV programs/tables of Criminal Intelligence, Personnel, Mugshot, and Off Duty Employment data.

Central Address data (city-wide) on DB2 mainframe tables.

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 07/1994 - 09/1996

Virginia Department of Social Services Richmond, Virginia

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

Information Systems Consultant 11/1993 – 06/1994

First Health Services Corporation Richmond, Virginia

Provided analysis and programming support at, Richmond, Virginia. This included coding the first production MVS JCL for a new claims processing system for the New York City Early Intervention Program.

Senior Programmer Analyst 10/1991 - 10/1993

Virginia Farm Bureau Richmond, Virginia

Analyzed user needs, wrote IS project specifications and testing procedures for Accounting, Claims, Marketing and Underwriting departments. The programs were COBOL on an IBM VSE mainframe, using Power JCL.

Systems Analyst 04/1989 - 09/1991

Institute of Modern Procedures Alexandria, Virginia

Maintained and enhanced various inventory and cost analysis systems in contractual support of the Radiation Detection, Indication and Computation Equipment Program (RADIAC) for the U.S. Navy. The program language was FoxBase+.

Provided technical guidance to U.S. government management, programmers and users in support of the Pell Grant Central Disbursement System for the U.S. Department of Education.

Prepared technical specifications, testing procedures and implementation schedules.

Evaluated programming, documentation and overall progress for each task. I served as acting project leader from 10/90 to 6/91 for this $3 million per year contract when the original project leader resigned.

Programmer 01/1985 - 03/1989

Institute of Modern Procedures Alexandria, Virginia

Provided COBOL coding and maintenance for the Pell Grant Central Disbursement System. Several subsystems performed data entry, data query, data file cross editing, and report generation (over 50 different reports).

Wrote programs that uploaded student demographic input data from an HP OCR scanner to a Wang VS100 miniframe several times a day that was received from over 6,000 schools.

Added programs to create standard label tapes to upload formatted data to an IBM mainframe nightly.

Added features that included tracking electronically transmitted data and floppy disk submissions from schools.

Wrote and carefully maintained FIPS documentation for 12 subsystems: flowcharts, data dictionaries, file/program cross reference charts, data entry user guides for each subsystem, operations guides (including recovery procedures), report summaries and distribution lists, and testing documents.

Programmer 11/1980 - 09/1981

National Life and Accident Insurance Company Nashville, Tennessee

Provided programming support to meet the compensation and benefit requirements for over six thousand field agents, using COBOL, TSO, Panvalet on an IBM MVS mainframe.

Data Entry Clerk 01/1979 - 01/1980

Vanderbilt University Hospital Nashville, Tennessee

Provided data entry for a Spectra 2000 hospital system.

Technology Proficiencies

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

Databases: SQL Server 2012. Oracle 8, 9i, 10G, 11G, and 12C.

Operating Systems/Software: MS Visual Studio 2019, SSIS 2008/2012, Microsoft SSMS 2008/2012, Linux; Windows 10, SQL Developer 4.1, TOAD for Oracle 12 (and previous DB versions), OBIEE 11.1, PL/SQL Developer 10.0, MS Excel 2016, HP Application Lifecycle Manager, REST Web Services, Oracle BI Publisher 10.1, Microsoft Visual Studio Professional 2019, Microsoft Power BI 2016, Talend, Microsoft .NET Framework version 4.7, Informatica 9.5, Atlassian Fisheye 3.7, Eclipse Neon, Jenkins, DBMS_SCHEDULER, Version One Ultimate Edition 15.2, MS Sharepoint 2016, Oracle Warehouse Builder 11G, Oracle Designer, AWS EC2 Cloud Console, Oracle Forms 10.1 and Oracle Reports 6i; SQL Developer 3.2, PGP, IBM InfoSphere DataStage 9.1, Oracle E-Business Suite R12, SQL Navigator 4.5, ODBC, QMF, Expediter, File-Aid, Lotus, MS Access, PuTTY SSH, Filezilla 3.8.1, MS Word 2016, MS Powerpoint 2016, MS Outlook 2016, BMC Remedy 2011, Mercury Quality Center 2008, Visio 2013, JIRA, BMC Truesight Atrium Orchestrator 8,2, Oracle Sun OS 5.10 (SPARC Solaris), Oracle APEX.

Versioning Tools: Azure DevOps Git Repository version 16.1,Tortoise Subversion 1.9.5, PVCS, HP ALM, Compuserve Harvest, CA-LIBRARIAN.

Education

Udemy: Microsoft Server 2012 Certification Training

Certified ScrumMaster (#000194104) April 2012

Certified by Oracle for SQL 9i, October 2010

Oracle University: Advanced Oracle database courses

Golden Gate University (Fort Myer, VA branch): MBA program in Information Systems (partially completed)

Park University (Fort Myer, VA branch): Accounting courses

Vanderbilt University: Bachelor of Arts in Political Science and Business Administration

Military Service

Administrative Specialist 10/1982 - 10/1984

Third U.S. Infantry (The Old Guard) Fort Myer, VA

Performed staff finance and operations duties for The Old Guard of the U.S. Army, the official ceremonial escort to the President. Awarded the Army Achievement Medal and Good Conduct Medal.



Contact this candidate