MICHAEL A. BROOKS

**** ******** ***** ************, ** 78660 adhvec@r.postjobfree.com 512-***-****

Oracle Database Developer (PL/SQL)

SUMMARY OF QUALIFICATIONS

Major areas of Oracle: OE, Manufacturing, BOM, Inventory, Financials, AP, AR, PO

General Ledger, Asset Accounting, Purchasing and Receiving modules.

Oracle HRMS, Oracle SQL Loader and extensive use of DB SQL Performance Tuning.

Oracle EBS Development, Oracle Forms and Reports and Crystal Reports

Developing Oracle Triggers, Functions, Procedures, Packages and Data warehousing.

Programming: Skilled disciplines of OOD programming with strong debugging skills.

Strong designs, modules optimization and system performance optimization skills.

OOD for Java, Implementation of Java application with Oracle, and MS SQL Server backend.

Lead engineer of department, competent self-starter and a team player.

Ability to troubleshoot technical problems around data transformation and storage in a 3-tier

Web/DB

Determination to make a transition to include Java based programming in secure

applications.

I’ve obtained confidential clearances for work in government jobs

President of Toast Masters Club with strong oral and written communication skills.

Testing business application

SPECIALIZED SKILLS

PLATFORMS AND TOOLS

SOFTWARE: Net Beans & Eclipse, Word, Excel, Power-Point. OE, Oracle Forms, Reports & Apex, Oracle BI Reporting, SAS Reports, Oracle Web logic, VM, MS tools, Toad, SQL, Nav., PL-SQL Dev. SQL Tuning, VI editor, Pro C, MS-C/C++, Visual Basic, Perl, Java, SQL Plus, Unix, Apache Tomcat, NetBeans, Eclipse, Jira work management

LANGUAGES: PL/SQL, Pro C, MS-C/C++, Visual Basic, Perl, Java, SQL Plus, COBOL

Operating Systems: UNIX shell Scripting, Windows NT, DOS, NOVEL, Oracle WebLogic

DATABASES: Oracle RDBMS (Oracle version, R2, 12c, 11i, 10g,11gR1.11g, 10g, 9i (RAC)), Web DB, MS Access,

ACHIEVEMENTS

Conversion of old Oracle 6 form to 11i packaged for an application.

Wrote major company applications through entire application cycle for commissions, employee

evaluations, and Store Price Validation, etc.

Conversion of Main Frame Commission system to Oracle platform, leading 3-person team.

Creating a testing application in Oracle packages for an application.

Conversion of a DB1 database system, to Oracle 5 and that to Oracle 7 implementation.

Converting VAX system to Oracle Web DB

Created a Customer Management Interface for travel reservation application software

Programmed Oracle SQL parser

Dashboard frontend with Oracle Apex

Programmed software for the Texas State Health Department's WIC program.

Converted Basic 7 DOS programs and converted them into one MS Visual C++ program

modules.

PROFESSIONAL EXPERIENCE

SENIOR ORACLE PROGRAMMER ANALYST JUN 2020 – SEP-2020

TEXAS PARKS AND WILDLIFE Contracting through CYNET SYSTEMS Sterling, VA

Development of two PL-SQL applications to process data file for accounting balancing

Responsible of the full development cycle from DEV, TEST and PROD.

Reporting purposes to send output file to be picked up on the server validating data

receive.

Oracle backend Application for accounting showing a break of departmental allocation of

Monies allocated and used in the field. One of a summery and the of detailed report.

Oracle Application 12C

Application Testing, include validation the data load, each process procedure and its result

Jira Bug logging, status tool to monitor progress of development and success and hiccups

Created requirements documentation for my assigned PL-SQL applications

SENIOR ORACLE PROGRAMMER ANALYST FEB 2020 – APR 2020

Army & Air Force Exchange Service (AAFES) Contracting through CIGNITI INC Dallas, Texas

Development of PL-SQL application for scrubbing data loaded into to their system

from DEV, TEST and PROD.

Application I created was to clean data that had been imported from an earlier version of

Oracle 3 database.

This Oracle project was to covert Oracle 3 Forms and Reports to an Apex application.

Forms development for Oracle Apex programming running ASAP application

Oracle Application 12C

The Oracle database consisted of 10 terabyte of data working source

Jira Bug logging, status tool and in addition there was a daily scrum meeting to share

goings-on for the day and accomplishments and hindrances.

App. Testing was meticulous, since it dealt with different database on several servers

Documentation for application was for the deployment and execution of the application

APPLICATION PROGRAMMER SEP 2019 – DEC 2019

ACTUMPROCESSING Austin, Texas

I Created a java programming reading files and producing reports of processes paid out in

excel in an Eclipse editor

Starting for deployment of code to their system

from DEV, TEST and PROD.

Starting development of JSON DB process for processing banking financial from and to

vendors

Used XMind application to detail the Actum System of code for production of the overall

system analyzing suggesting upgrades and documentation

Oracle Database R18 working with the latest greatest bells and whistles of Oracle tools

Application Testing loading files for validating reported monies from vendors

Development of PERL application basically maintaining and updating existing Perl scripting

for debugging errors

SENIOR ORACLE PROGRAMMER ANALYST JUN 2019 – AUG-2019

TEXAS LOTTERY COMMISSION Contracting through NEOS TECHNOLOGIES INC Austin, Texas

Development of PL-SQL application for cataloging the taxes that were applicable to

various counties in Texas with the Bingo game throughout the code to their system

from DEV, TEST and PROD.

Created Jasper Reporting using the details from this application in the reports and also in

their Java programming running reports from Lottery Applications

Oracle Application 12C

Application Testing the different values for each of the appropriate taxes base on value,

date times and quarters

Jira Bug logging, status tool I kept daily update of my progress.

Documentation for applications was provided for creating this application to specifications

Use Eclipse editor to deploy updates to the existing code

Daily had scrum meets were held to update management to accomplishments and goals

SENIOR ORACLE PROGRAMMER ANALYST Oct 2018 – Dec 2018

RHYAN TECHNOLOGY SERVICES Austin, Texas

Development of PL-SQL application for deployment of code to their system

from DEV, TEST and PROD.

Converting mainframe COBOL applications into PL-SQL for financial applications.

Shell Scripting

Oracle Application 12C

Application Testing

Documentation for applications

SENIOR ORACLE PROGRAMMER ANALYST Mar 2017 – Jun 2018

LEIDOS Contracting through NORWIN TECHNOLOGIES INC. San Antonio, Texas

Work with All Services of the armed forces.

Maintenance of application systems testing and programming using Oracle SQL Plus and

PL/SQL with code optimizing

Created version control documentation for upgraded deployment of code to their system

from DEV, TEST and PROD.

Data research reporting with various tools such as Toad, and SQL Dev for detail analysis

for Oracle reports and forms

Shell Scripting

Terabyte of data working source

SQL Loader

Jira Bug logging, status tool

Creating stored procedures and functions

Oracle Application 12C

Hints for SQL optimizing

Application maintenance,

Application testing creating test environments to validate the delivered solution.

System analyst of Armed Forces system

Version Release and, implementation documentation

Forms and PL-SQL objects maintenance

SENIOR ORACLE SOFTWARE DEV ADVISOR Aug 2015 – Oct 2016

DELL Round Rock, TX

Computers systems throughout the world.

Oracle Application programming using SQL Plus and PL/SQL. I create scripts and HLD & SRS documentation for current deployment of their system Oracle reports.

Processing and development for SODS systems

Oracle Golden Gate processing

Monthly system deployment

Maintain system data problems

Assisting in problem resolving for SDR

Resolving critical issues that come up with customer data processing

DB monitoring with QAD tool

Hints for SQL optimizing

Terabyte of data working source

Jira Bug logging, status tool

MySQL, XML data loading and processing

Familiar with Agile process.

Working with TSF2 tool to load defects and update software

ETL Informatica Development

ORACLE PROGRAMMER ANALYST Feb 2015 – Jul 2015

HASS INC. Contract through KForce Austin, TX

HASS is one of the largest computer chemical sale and treatment companies in the world.

Application testing and programming using SQL Plus and PL/SQL.

Created SRS and SDS documentation for current deployment of their system.

I worked with Oracle 11i using PL-SQL scripts and packages for overall system usage.

Hints for SQL optimizing

Data research reporting with various tools such as Toad, and SQL Developer.

Business analyst of business Haas system

Oracle Apex

SENIOR ORACLE/ JAVA PROGRAMMER ANALYST Aug 2014 – Jan 2015

DEPARTMENT OF TEXAS HOME VISITING Through COOPER CONSULTING INC. Austin, TX

State Government

THV Application enhancement with Oracle back end creating java functionality and

creating Oracle tables for warehouse development and report writing and programming

using SQL Plus.

MySQL

Programming with JAVA/JSP/XML, Hibernate, Spring Framework, J2EE, WebLogic

Business analyst of THV application system

Application programming using SQL Plus and PL/SQL.

Creating SRS Documents

Developing with SQL Developer and Eclipse IDE’s

System testing with end-to-end from analysis

SENIOR ORACLE PROGRAMMER BUSINESS ANALYST Aug 2013 – Aug 2014

TEXAS DEPARTMENT OF HEALTH Contracting through COOPER CONSULTING SERVICES INC.

Senior Oracle Programmer Analyst

TX Helping Injury Epidemiology Surveillance Program Studies.

Oracle Application reports and programming using SQL Plus and PL/SQL. Created scripts

and HLD & SRR documentation for current deployment of system projects.

Creating SAP Business Objects dynamic metrics for SAS reporting

Created Denormalized Oracle tables for views for Oracle Back-End for Maven

Application.

Mapped Denormalized tables based on Maven system using NTDB, EMS, LTAC and

NEMSIS.

Data Dictionaries by product codes. SAS

Wrote and created J-Reports based on Maven System tables, Denormalized tables, and

Oracle SQL code.

Formalized 9 and 10 ICD Codes for Maven Application.

Application Testing and Quality assurance

Hints for SQL optimizing

Maven

Materialized Views

Terabyte of data working source

Created Oracle Data Storage for Maven Users

SRS and SRS Release Documentation

Business analyst for DSHS system

MAVEN Application maintenance

SENIOR ORACLE PROGRAMMER ANALYST Aug 2011 – Jul 2013

VETERANS ADMINISTRATION through COMPLETE PROFESSIONAL SERVICES INC.

VA Helping all Vets. Richmond, VA

Oracle Application reports and programming using SQL Plus and PL/SQL. I

created scripts and HLD & SRR documentation for current deployment of system projects.

Oracle Application forms

Toad SQL editor

Pro C maintenance.

Assisted on Java Application using Servlets web application on library system

Editing Servlets, Java Beans Maven accessing Oracle Database

Java Programming Development, working with Eclipse, and J2EE,

Tomcat Web Services

Studied all of the following in depth, Java, Servlets, Patterns, JSP’s, JSF, Spring, Hibernate, HTML, Oracle 10G RAC, PL/SQL, Java 1.5+, NetBeans, Eclipse

Clear Case Version Control, Clear Quest Record control, SVN

Oracle 10g forms

Application Testing

Terabyte of data working source

Business analyst of VA system

ETL Informatica Development

SRS and SRS Release Documentation

Unix Cron Jobs maintenance

Writing Oracle Reports with SQL

Interviewing applicants for a Oracle Forms position

SRR detailed documentation of the software being development and deployment

SENIOR ORACLE FINANCIALS PROGRAMMER ANALYST Mar 2008 – Jul 2011

STAGE STORES INC. Houston, TX

Stage Stores Inc. has several stores throughout the US selling cloths.

Oracle Application reports and programming using SQL Plus and PL/SQL. I

create scripts and HLD & SRS documentation for current deployment of their system Oracle WebLogic.

Oracle Apex Application Design web-based application, and J-Developer converting Oracle forms and Reports

Oracle EBS Modules Development

Inventory, BOM, Routing WIP Costing OM

Data Architect

Materialized Views

Korn Shell Scripting

Scripting Audit reporting

I work with Oracle APPs 11i, and perform additional functionality for reports and other responsibilities. Shell Scripting

Oracle 10g forms, Oracle EBS

Business analyst of Financial system

Hints for SQL optimizing

Processing Updates of Financials

Insured Applications were designed on Stage Stores standards based on ISO specifications

I created major projects in Oracle PL_SQL, and two with Apex, Java 1.5+, Java Servlets, and leading 4-person team assigning task to complete the project

Creates dimensional and hierarchy’s fact tables and ERD. Determine the attributes for each dimension tables. Get users to verify the data model.

Data piping from different UNIX boxes for application usage for commission application and reporting

Converting Financials applications to Oracle 11i financials application Commissions Application.

Property, rentals and taxes session tracing

Writing Oracle matrix reports with SQL and managed detailed documentation of the software being development.

OE application development and maintenance

Assisted in companywide enhancements to improve overall sales by them changing name of companies they bought out in particular locations with their companies.

Erwin data modeling application systems

SENIOR ORACLE PROGRAMMER ANALYST Apr 2006 – Jan 2008

ERCOT INC. Contracting through Spherion Taylor, TX

ERCOT is a global energy company, recognized as a leader in the mediation of energy companies in Texas.

Application testing and programming using SQL Plus and PL/SQL.

I did Business analyst of Electric Grid system

I created QTP test scripts and SDS documentation for current deployment.

Worked with Oracle 9i designing for PL-SQL scripts and packages for system usage.

Data research reporting and improving existing test planes and writing new ones.

Development of leading edge real–time monitoring application for market behavior.

Lodestar program processing

QA

Hints for SQL optimizing

QC documenting testing processing heights

QTP and Quality Center applications for writing test scripting.

SENIOR ORACLE PROGRAMMER ANALYST May 2005 - Mar 2006

DELL INC. Contract through Bridge360 Austin, TX

Dell is one of the largest computer manufacturing companies in the world.

Application testing and programming using SQL Plus and PL/SQL.

Created SRS and SDS documentation for current deployment of their system.

Worked with Oracle 9i designing for PL-SQL scripts and packages for overall system

usage.

Data research reporting with various tools such as BI.

Business analyst of business manufacturing system

QTP and Quality Center applications for test scripting.

ORACLE PROGRAMMER ANALYST Jan 2005 – May 2005

UBCJ UNION Contracting through Eastridge InfoTech Inc. Las Vegas, NV

UBCJ Union is one other the United States largest credit union.

Application programming using SQL Plus and PL/SQL.

Designing Union dues financial application system with Oracle 10g advanced features

Created SRS and SDS documentation for current deployment of their system.

Oracle 9i for the design for PL-SQL scripts and packages for overall system usage.

Tableau Data research reporting.

Materialized Views

Hints for SQL optimizing

Perl in UNIX shell scripting to create application alert notification.

SENIOR ORACLE PROGRAMMER ANALYST May 2004 - Dec 2004

DELL INC. Contract through NTS Austin, TX

Dell is one of the largest computer manufacturing companies in the world.

Application programming using SQL Plus and PL/SQL and Data research reporting.

Designing LDR manufacturing for on time delivery system with Oracle 10g advanced

features.

Created SRS and SDS documentation for current deployment of their system.

Oracle 9i for the design for PL-SQL scripts and packages for overall system usage.

Continental deployment of the of system Oracle application.

UNIX shell scripting to create application alert notification.

ORACLE PROGRAMMER ANALYST Mar 2003 – Dec 2003

APPLIED ENGINEERING MANAGEMENT Inc. San Antonio, TX

AEM is a contracting company for Governmental programming need.

Application programming using SQL Plus and PL/SQL.

In addition, provided functional analysis operations, conjunction with HR needs.

Discoverer Application and Java programming with Oracle database back-end.

Completed an application with Oracle 9i for the design of a SQL parser.

Instrumental in creating MS Access scripts.

Instrumental in SQL scripts to implement in HTML web application.

Reverse engineering of Air Force's Oracle HRMS modifications, and created SRS doc’s

for current deployment of their system. I authored PL/SQL scripts.

PROGRAMMER ANALYST Nov 2002 – Mar 2003

SPRINT Contracted through Techni-Source Inc. Kansas City, KS

Phone company icon in telecommunications as needed for all.

Application programming using SQL Plus and PL/SQL, and writing UNIX Shell scripting.

Responsible for the maintenance development of CIRAS systems using Oracle 6i forms.

In addition, provided functional operations in conjunction with programming needs.

Responsible for Pro C and SQL trouble shooting maintenance of CIRAS systems.

Authored application with Oracle 6i forms and reports designing.

Using SQL Navigator performed code tuning, Discoverer.

Maintained forms and reports version control using PVCS.

PROGRAMMER ANALYST Jan 2002 – Aug 2002

SECTOR 7 Contracted through American Technology Inc. Austin, TX

Contracting company servicing and has been bought out by IBM as needed for programming.

Application programming SQL Plus and PL/SQL. Coding in fashion in terms of scalability.

Whereby with the used of dynamic PL/SQL and passing in parameters of code, tables

produced desired results.

Toad SQL editor, Tableau Reports

Developed adhered use of programming techniques and design standards of relational

databases, data entry forms, Security schemes and end reporting.

Responsible for full life-cycle development of business systems from concept through

implementation including design, coding, and testing, documenting, training new hire

resources for development on the business-related systems.

Authored application with Oracle 6i and 9i forms and reports designing.

Rewriting a COBOL Main frame application into an Oracle PL-SQL package to run in

Oracle Apps.

Installation of Oracle Database.

Normalizing table structures and optimizing SQL and PL-SQL code.

APPLICATION DEVELOPER / PROGRAMMER ANALYST Jan 2001 – Jun 2001

DELL Contracted through Nims Associates Inc. Austin, TX

Dell is one of the largest computer manufacturing companies in the world.

Developed a Material Requisition System (MRS) for a Glovia Inventory Movement

Interface, an application programming with SQL Plus and PL/SQL to monitor material

request and distribution. This process would use the SQL-Loader to load data. Any

transactions that issue material based upon inventory committed, on-hand, and

reserved would update tables tracking inventory and updated transaction tables.

Authored UNIX Shell Scripting to give system administrators a call when problems

occurred in the data being processed with their application, so initiation of scripts

processed to restart automation once the data problems were fixed.

Created triggers to handle much of the tracking on the back-end, performing validations

to insured business rule essentials.

Worked with Oracle 9i performing database maintenance, Backup and Recovery to

ensure safety of data integrity.

Corrected timing discrepancies, adjusting where data coming into the Glovia System

was too fast and needed to fix by regulating timing waits in the SQL Plus and PL/SQL to

code.

Synchronization of data by writing scripts to import and distributed databases data from

Glovia to Brio.

QA and Maintained report version control with PVCS.

EDUCATION

Bachelors of Science in Computer Science

Engineering & Software Design at National University – 1992 San Diego, CA.

CERTIFICATES OF COMPLETION

ACHIEVEMENTS

Oracle Forms, Report and SQL Tuning

Oracle Apex Application Server design

Java Certificate of Consulting Solutions

Access

Competent Toast Master

Contact this candidate