Resume

Sign in

Oracle Analyst

Location:
Pflugerville, TX
Posted:
January 06, 2020

Contact this candidate

Resume:

MICHAEL A. BROOKS

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

PL/SQL Developer

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.

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

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 (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

APPLICATION PROGRAMMER SEP 2019 – DEC 2019

ACTUMPROCESSING Austin, Texas

Starting development of PERL application for deployment of code to their system

from DEV, TEST and PROD.

Starting development of JSON processing

Java programming reading files and producing reports of processes paid out in excel

XMind System analyzing and documentation

Oracle Database R18

Application Testing

SENIOR ORACLE PROGRAMMER ANALYST JUN 2019 – AUG-2019

TEXAS LOTTERY COMMISSION Contracting through NEOS TECHNOLOGIES INC Austin, Texas

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

from DEV, TEST and PROD.

Jasper Reporting.

Java programming running reports from Lottery Applications

Oracle Application R12

Application Testing

Documentation for applications

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 R12

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

SQL Loader

Creating stored procedures and functions

Oracle Application R12

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

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

Materialized Views

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

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

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 programming

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.

APPLICATION DEVELOPER / PROGRAMMER ANALYST Sep 2000 – Dec 2000

COREMETRIC INC Austin, TX

Coremetric is a company for help website maximize

Maintained a Web analyst application, and programmed with SQL Plus and PL/SQL.

Oracle 8i version used with standard and advanced features. Authored dynamic PL/SQL

and did efficient SQL tuning.

Wrote coded so that terabytes of data would process in little time. Also I preformed

database partitioning.

Authored testing and scripting that would test every aspect of the data being displayed

in forms to verify that the data was correct data. If the data wasn't correct the code

would pass back the error validation code.

Maintained report version control with PVCS.

QA and Data transformation and data replication database.

APPLICATION DEVELOPER / PROGRAMMER ANALYST Sep 1996 – Sep 2000

FISHER-ROSEMOUNT SYSTEMS INC Austin, TX

FRSI is a company for help device controls measurements.

Developed reports with Oracle reports designer 2000 with SQL Plus and PL/SQL,

Discoverer, BI Micro Strategy, and Noetix Views.

Developed Korn Shell scripts that initialed Oracle Jobs.

Worked with Oracle 10.7 modules OE, Manufacturing, WIP, BOM, Inventory, and

Financials in report development. I performed code gap analyst for manufacturing

equipment tracking to provide immense savings of time and money. Also I worked with

Financials, Accounts Payable, Accounts Receivable, General Ledger, Asset Accounting,

Inventory, BOM, Routing WIP Costing OM and Shipping

Purchasing and receiving modules, writing gap requirements and coding for taxation.

Also worked with Vertex and did implementation with Pro C.

In addition, provided functional analysis operations in conjunction with programming

needs in relation to all of the Oracle modules.

Maintained Oracle reports and managed detailed documentation of the software being

development. In addition, I worked with QA to ensure compliance with the systems

business rule validation, Writing Oracle Reports with SQL, Noetix views in regards to

configuration BI

Converting COBOL system to Oracle Web DB to provide Web Expense reports and agent

client data searches.

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 Web DB design and Oracle Application Server design

Front Page Internet design

Access

Competent Toast Master



Contact this candidate