Served as DBA in an Oracle and SQL server environment. Over twenty years experience in application/DB development and maintenance. Very proficient in designing packages, procedure and triggers in PL/SQL Experience with moving Supply Chain application/data to Oracle Cloud. Heavy experience with SQL Server, Oracle and Data Warehousing. Designed/coded JAVA J2EE applications for commercial/government agencies. Designed, developed and upgraded Oracle apps in Oracle APEX. Full life cycle development utilizing agile software development and SCRUM. Excellent team player and communicator, exceptional analytical ability.

SKILLS

• Languages / Tools: • Oracle Procurement Cloud, C#, • ASP.Net, JAVA, J2EE, XML, Visual

Studio 2015, Web Services,

Windows Services, SQL, ODI 12c

LIMS(COTS), HTML, DHTML, ASP,

JSP, JCL, CICS, COBOL II, VBScript,

Apache Tomcat, Visual Studio 2015,

TSO/ISPF, Oracle Primavera P6, BI Publisher,

JMeter, SoapUI, Test Complete, Enterprise

Manager and Management

Studio,PL/SQL, Power BI report server,

Oracle Forms and Reports, VI editor,

IIS6/7, Angular JS, Microsoft DAX

• Databases/Tools: ODI(Oracle Data • Integrator,

TOAD, SQL Loader,

Oracle Enterprise Server, Enterprise

Manager 12c, Oracle e-Business

Suite, SQL 2005, SQL 2008, PL/SQL,

MS SQL Server 6.5, 7.0,2016, Oracle

9i,10g,11g, 12c, SQLPLUS

Architecture Service Oriented •

Architecture, Enterprise Architecture

Integration

Business Process Management

EXPERIENCE

Data Warehouse/ETL SQL Developer November 2015 - November 2023 UCOR Oak Ridge, Tennessee

• Created SSIS packages to migrate data from various data sources to data warehouse

• Successfully extracted transformed and loaded data into data warehouse

• Created, Scheduled Generated and optimized ETL jobs

• Created Updated Stored Procedures, Triggers and Functions, Views and Indexes with extensive use of T-SQL.

• Created and deployed customized reports in SSRS to numerous customers (Finance, Project Controls, Procurement)

• Utilized SSMA to migrate data from Oracle to SQL Server databases

• Creating standards and designing patterns on data movement, data access, data integration, and other areas in the data warehouse

• Desigen SQL SSIS Packages in Business Intelligence Development (BIDS) to extract data from various data sources for further Data Analysis and Reporting by using multiple transformation provided by SSIS (Data conversion, Conditional Split, Bulk insert merge, and Union all)

• Expert in cleansing data for data consistency, single system or multiple systems

• Debugged unexpected SQL results, deadlock issues

• Heavy experience in Enterprise Data Warehousing including Data Modeling, Data Architecture, Data Integration and Business Intelligence.

• Work with business customers to define analysis requirements

• Supported Oracle EBS Finance modules (General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Cost).

• Designed DW tables, scripts, ETL maps and ODI extracts. ODI 12c

• Worked closely with Project Controls install, upgrade and supported Primavera P6. Grew very familiar with Line of Balance reporting services.

Oracle DBA/Systems Engineer December 2013 - November 2015 Savannah River Nuclear Solutions Aiken, South Carolina

• Previously developed Java services to capture data from medical instruments output to insert into Oracle tables

• Also, worked with medical systems, creating tables, writing triggers, performing database design

• I was responsible for implementing and the creation and tuning of data aggregation mechanisms

• Supported medical staff by calibrating medical equipment and ensuring all instruments are collecting data at all times

• Also maintaining Java applications while converting some applications to .Net.

• Responsible for designing, developing, and testing of the ETL strategy to populate the data from various source systems (SQL Server & Oracle) feeds using ODI and Change Data Capture.

• Utilized Power BI (Power Pivot/View) to design multiple score cards and dashboards to display information required by different departments and upper management.

Software Engineer July 2012 - May 2013

TeamHealth Knoxvillle, Tennessee

• I was part of a systems engineering team maintaining healthcare systems and workflow document systems

• Served as SharePoint administrator and developer, wrote several web services and windows services in C# in accordance with customers requirements

• Improved operations by conducting systems analysis

• Prepared and installed solutions by determining and designing system specifications, standards, and programming

• Provided object-oriented design, analysis, programming, and implementation for web applications with the .NET Framework (2.0 - 4.0) using both Web Forms and MVC2

• Also converted 40 Crystal Reports to SSRS using SQL Server Report builder. Senior Software Engineer July 2009 - June 2012

Savannah River Nuclear Solutions Aiken, South Carolina

• Served as a Team Lead of a large engineering group

• I was also tasked with writing code in VB .Net to interface with lab instruments to replace older applications utilizing Visual Studio 2010 and IIS 6

• The new application minimizes the number of operations that the technician has to perform to upload data from the instrument to LIMS(COTS product)

• Also, I enhanced the BEIDMS report in LIMS to satisfy the customers needs, which included making calculation conversions in several PL/SQL packages/triggers while converting Oracle Reports and Forms in an Oracle environment Senior Systems Analyst June 2007 - June 2009

IT Solutions, Inc Columbia, SC

• Budget and Control Board Office of the, Maintaining KOMAND accounting/billing system, assisted in upgrade of KOMAND system utilizing JCL, COBOL, TSO and CA7 on the mainframe

• In this role I acted as Project Manager managing several projects at once Systems Analyst II March 2006 - April 2007

Department of Health Columbia, South Carolina

• Developed, designed and tested VB .Net applications with a SQL 2000 backend

• Wrote stored procedures, views and SQL

• Met with users, gathered requirements and analyzed workflows for Medicaid applications

• Also maintained VB6 application that was deployed statewide through IIS4 and served as help desk for county. Senior System Analyst April 2005 - December 2005

Blue Cross Blue Shield Columbia, South Carolina

• Developed and tested new processes for an Imaging and Workflow Management Systems group utilizing JAVA, J2EE, XML, STRUTS, SERVLETS, AIX and Oracle for customers nationwide

• I developed new processes that allow scanned documents to flow thru workflow servers and writing reporting software to meet customers needs in the insurance industry using Model View Controller environment. Consultant April 1999 - April 2005

Technology Solutions Inc Columbia, SC

• Wrote system applications in Java, XML and JSP utilizing Eclipse 2.21 and Apache Tomcat along with Workbench and SilverStream Server for coding and deployment in a J2EE environment

• Also utilizing SQL Server DTS in Enterprise manager

• Previously engaged with a State Government Agency converting applications to Java thru J2EE eXtend Workbench in order for users to reach converted web enabled applications thru the portal

• I also wrote and tested Medicaid financial tracking system using VB 6 and Access 2000 to track financial fraud utilizing SQL Server to build the databases and assisted in the building and testing of a Human Resources application with stored procedures, utilized SQL Server to build the databases as well

• Recently, developed an application in Java with a SQL backend utilizing T-SQL and maintained archived data, backing up and restoring the database as well as monitoring and optimization for performance of the databases

• I was engaged with a system testing team, testing a large system for recent policy changes, online and batch

• I previously was a member with a data warehouse team responsible for designing the hardware architecture and purchasing software for the agency as well as designing and coding a problem reporting system in VB with Crystal Reports and creating databases using DB2/UDB version 6

• This problem resolution reporting system was originally written in VB utilizing SQL Server and then later in DB2 UDB

• Also created primary database storage structures (tablespaces) after his design work of the application Consultant Engineer January 1998 - January 1999

Dean Information Services Lexington, SC

• For a Y2K test team at a large manufacturing company in SC

• My responsibilities included data aging, file comparisons, analysis, coding and testing of EDI/POS applications for Y2K compliance in DB2, CICS, and ADHOC programming

• In this role, I utilized MVS/JCL, COBOL, Fileaid and Ager2000, also aided in the coding of an inventory system utilizing VB and SQL. Assistant Key Account Supervisor January 1997 - January 1998 Southern Anesthesia Lexington, SC

• While at Southern Anesthesia, Involved in the distribution of large amounts of medical supplies to various health care providers in the area and was responsible for the maintenance of the ADP system that monitored the inventory and shipments of supplies. Consultant January 1996 - January 1997

AMR Services Columbia, South Carolina

• I was employed in the I.T Deparyment

• Division of AMR Services and was responsible for updating and installing airline control programs on the SABER ACP/TPF system. US Marine Corps Quantico, VA January 1988 - January 1995

• Coded, tested, and installed Budget and Control programs in COBOL in an IBM DOS/VSE environment

• I took a two year leave of absence to pursue other interests

• Upon re-entering the Marine Corps, I attended the USMC Auto Mechanic School and then returned to my former position where he was needed in the Data Processing section.

Cert in .Net January 2006

Cert in JAVA and J2EE January 2002

AS - Computer Technology January 1997

Aiken Technical College, Aiken, SC

BS - Computer Science January 1993

Georgetown University, Washington DC

Cert, Computer Applications January 1989

Computer Science School, USMC, VA

Contact this candidate