Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Competent Toast Master
Languages
Timeline
Generic

MICHAEL A. BROOKS

Oracle PL/SQL Developer
Pflugerville,TX

Summary

Experienced in a wide range of Oracle modules, including OE, Manufacturing, BOM, Inventory, Financials, AP, AR, PO General Ledger, Asset Accounting, Purchasing, and Receiving. Skilled in managing and optimizing these areas to drive operational efficiency and financial success. Adept at leveraging Oracle\'s robust capabilities to streamline processes and enhance business performance. Committed to staying up-to-date with industry trends and best practices to deliver exceptional results.

Overview

24
24
years of professional experience
1
1
Certification

Work History

ORACLE PROGRAMMER ANALYST

USPS Contracting through KForce
09.2023 - 10.2024
  • 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, – remote
  • Development of JavaScript applications to process data for USPS
  • Overall System modification
  • VI recapturing data for reprocessing........................
  • Testing design
  • Debugging Java code
  • Creating Database Objects, data partitions, Data warehouse design
  • Hints for SQL optimizing .........................
  • Application Testing, include validation the data load, each process procedure and its result
  • Data refreshing for table data downloads for developing.
  • Enhanced database performance by optimizing SQL queries and implementing indexing strategies.
  • Managed multiple concurrent projects effectively while maintaining attention-to-detail under tight deadlines.
  • Maintained up-to-date knowledge of Oracle technologies and best practices through continued professional development.
  • Supported the integration of disparate systems using APIs or other interfaces, simplifying data exchange between applications.
  • Implemented security measures for sensitive data, ensuring compliance with industry standards and regulations.
  • Troubleshot complex technical issues related to Oracle applications, providing timely resolutions for minimal impact on users'' workflow.
  • Streamlined data processing tasks for increased efficiency by automating PL/SQL scripts.
  • Reduced system downtime and increased reliability by actively monitoring Oracle databases and resolving issues promptly.
  • Participated in code reviews to ensure adherence to coding standards and maintainability of codebase across projects.
  • Analyzed user requirements and designed custom solutions tailored to their specific needs using Oracle tools and technologies.
  • Successfully migrated legacy systems to Oracle platforms, minimizing disruptions to business operations.

SENIOR ORACLE PROGRAMMER ANALYST

CENTENE Contracting, Randstad
10.2022 - 03.2023
  • Remote
  • Development of PL-SQL applications to process data for data mining
  • Data Archiving.........................
  • ERD data dictionary design
  • ETL Oracle Development
  • Creating Database Objects, data partitions, Data warehouse design
  • Hints for SQL optimizing .........................
  • Application Testing, include validation the data load, each process procedure and its result
  • Documentation Analyst Requirements progress of development
  • Data refreshing for table data downloads for developing.
  • Participated in code reviews to ensure adherence to coding standards and maintainability of codebase across projects.
  • Optimized application performance through careful analysis of resource usage, addressing bottlenecks where appropriate.
  • Leveraged advanced features of SQL.
  • Analyzed user requirements and designed custom solutions tailored to their specific needs using Oracle tools and technologies.
  • Enhanced database performance by optimizing SQL queries and implementing indexing strategies.
  • Conducted thorough testing of program functionality, identifying and fixing bugs before deployment.
  • Spearheaded the utilization of agile methodologies within the team, resulting in increased productivity and satisfaction among project stakeholders.

SENIOR ORACLE PROGRAMMER ANALYST

SYNODEX Contracting through LOGIX-TECH SOLUTIONS
01.2022 - 09.2022
  • Development of PL-SQL applications to process data file for data mining
  • Responsible for load of data for report writing cycle from DEV, TEST and PROD
  • AD Hoc reporting purposes to retrieve latest customer data output SQL data status receive
  • Oracle backend Application and frontend processing of and the of detailed report
  • Oracle Application 12C
  • ETL Oracle Development
  • Development/implement regression testing scripts
  • Git Resource control
  • Engineered PL-SQL applications for complex data manipulation and reporting workflows
  • Creating Database Objects, data partitions, Data warehouse design
  • Hints for SQL optimizing .........................
  • Application Testing, include validation the data load, each process procedure and its result
  • Documentation Analyst Requirements progress of development
  • Data refreshing for table data downloads
  • Participated in code reviews to ensure adherence to coding standards and maintainability of codebase across projects.
  • Optimized application performance through careful analysis of resource usage, addressing bottlenecks where appropriate.
  • Leveraged advanced features of SQL.
  • Contributed to the design and implementation of database schemas, ensuring robustness and scalability for future growth.
  • Managed multiple concurrent projects effectively while maintaining attention-to-detail under tight deadlines.
  • Collaborated with technical contributors during application development to resolve application defects.

SENIOR ORACLE PROGRAMMER ANALYST

ZIONS BANK contracting through STRATEGIC SYSTEMS
02.2021 - 10.2021
  • Remote
  • Development of PL-SQL applications to process data file for accounting balancing
  • Responsible load of data for report writing cycle from DEV, TEST and PROD
  • Reporting purposes to send output file to be picked up on the server validating data receive
  • Designed and deployed PL-SQL applications to automate data extraction and manipulation workflows
  • Oracle backend Application and frontend processing of and the of detailed report
  • Oracle Application 12C
  • ETL Oracle Development
  • Oracle Reports
  • Oracle Forms
  • Oracle Workflow & Dual Parelle process procedures
  • Development/implement regression testing scripts
  • Load-balancing processing Oracle (AP) accounts payable
  • Git Resource control
  • Creating Database Objects, data partitions
  • Hints for SQL optimizing .........................
  • 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
  • Participated in code reviews to ensure adherence to coding standards and maintainability of codebase across projects.
  • Optimized application performance through careful analysis of resource usage, addressing bottlenecks where appropriate.
  • Leveraged advanced features of SQL.
  • Analyzed user requirements and designed custom solutions tailored to their specific needs using Oracle tools and technologies.
  • Developed comprehensive documentation for Oracle applications, enabling smooth handover to support teams and endusers.
  • Optimized application performance by developing algorithms and software to monitor and refine technical performance and configuration.
  • Researched information and conducted analysis for software and systems modifications and new projects.
  • Utilized both agile and waterfall methodologies to develop software of varying complexity and business needs.

SENIOR ORACLE PROGRAMMER ANALYST

TEXAS PARKS AND WILDLIFE Contracting, CYNET SYSTEMS
06.2020 - 09.2020
  • 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
  • Load-balancing processing Oracle (AP) accounts payable
  • 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
  • Hints for SQL optimizing and SQL Tuning
  • 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
  • (POET) is used to charge expenses to a project
  • Optimized application performance through careful analysis of resource usage, addressing bottlenecks where appropriate.
  • Leveraged advanced features of SQL.
  • Troubleshot complex technical issues related to Oracle applications, providing timely resolutions for minimal impact on users'' workflow.
  • Analyzed user requirements and designed custom solutions tailored to their specific needs using Oracle tools and technologies.

SENIOR ORACLE PROGRAMMER ANALYST

Army & Air Force Exchange Service, CIGNITI INC
02.2020 - 04.2020
  • 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
  • ETL Oracle Development
  • Hints for SQL optimizing and SQL Tuning
  • 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
  • Leveraged advanced features of SQL.
  • Analyzed user requirements and designed custom solutions tailored to their specific needs using Oracle tools and technologies.
  • Troubleshot complex technical issues related to Oracle applications, providing timely resolutions for minimal impact on users'' workflow.
  • Maintained up-to-date knowledge of Oracle technologies and best practices through continued professional development.

APPLICATION PROGRAMMER

ACTUMPROCESSING of Econosoft Inc
09.2019 - 12.2019
  • 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
  • Python Scrips
  • 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

TEXAS LOTTERY COMMISSION Contracting, ACE TECHNOLOGIES INC
06.2019 - 08.2019
  • 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 Java programming running reports from Lottery Applications
  • Oracle Application 12C
  • Hints for SQL optimizing and SQL Tuning
  • 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
  • Participated in code reviews to ensure adherence to coding standards and maintainability of codebase across projects.
  • Optimized application performance through careful analysis of resource usage, addressing bottlenecks where appropriate.
  • Utilized both agile and waterfall methodologies to develop software of varying complexity and business needs.
  • Mastered multiple frameworks for software development.

SENIOR ORACLE PROGRAMMER ANALYST

RHYAN TECHNOLOGY SERVICES
10.2018 - 12.2018
  • Oracle Application 12C
  • 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
  • Application Testing
  • Documentation for applications

SENIOR ORACLE PROGRAMMER ANALYST

LEIDOS Contracting, NORWIN TECHNOLOGIES INC
03.2017 - 06.2018
  • 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 and SQL Tuning
  • Oracle Application interfaces 12C
  • 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

DELL
08.2015 - 10.2016
  • Computers systems throughout the world
  • Shell Scripting
  • 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
  • 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 and SQL Tuning
  • 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

HASS INC, KForce
02.2015 - 07.2015
  • 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
  • System data problems
  • 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 Oracle Apex
  • Data research reporting with various tools such as Toad, and SQL Developer
  • Business analyst of business Haas system
  • Maximo asset management application in Oracle Apex with remote monitoring

SENIOR ORACLE/ JAVA PROGRAMMER ANALYST

VISITING Through COOPER CONSULTING INC
08.2014 - 01.2015
  • State Government
  • System data problems
  • 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
  • Designed and implemented JavaScript applications to streamline data manipulation and processing tasks for USPS operations
  • Programming with JAVA/JSP/XML, Hibernate, Spring Framework, J2EE, WebLogic
  • Business analyst of THV application system
  • 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

COOPER CONSULTING SERVICES INC
08.2013 - 08.2014
  • Helping Injury Epidemiology Surveillance Program Studies
  • MySQL
  • Oracle Application reports and programming using SQL Plus and PL/SQL
  • Created scripts and HLD & SRR documentation for current deployment of system projects.

SENIOR ORACLE PROGRAMMER ANALYST

VETERANS ADMINISTRATION, COMPLETE PROFESSIONAL SERVICES INC
08.2011 - 07.2013
  • VA Helping all Vets
  • 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 interfaces
  • 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

STAGE STORES INC
03.2008 - 07.2011
  • Stage Stores Inc
  • Has several stores throughout the US selling cloths
  • Toad SQL editor
  • Oracle Application reports and programming using SQL Plus and PL/SQL
  • I created 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 and interfaces
  • Inventory, BOM, Routing WIP Costing OM
  • Data Architect Processed financial data through customized PL-SQL applications, focusing on efficient data manipulation and analysis
  • Materialized Views
  • Korn Shell Scripting
  • Scripting Audit reporting
  • I worked 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
  • Also created reports using Crystal Reports linking Oracle tables to create record groups
  • To query the database
  • 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 lease management
  • 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
  • Authored code fixes and enhancements for inclusion in future code releases and patches.
  • Provided ongoing support for users experiencing issues or requiring assistance with application functionality.
  • Contributed to successful project completion with effective time management and prioritization skills, meeting tight deadlines consistently.
  • Provided technical support and guidance to junior team members, enhancing team skills and cohesion.
  • Streamlined communication between development team and project managers, leading to more effective project oversight.
  • Developed and maintained efficient, error-free code for various software applications, meeting all project deadlines.
  • Spearheaded initiatives to adopt new technologies that positioned company at forefront of innovation in industry.
  • Resolved software bugs and issues promptly, minimizing downtime and maintaining operational efficiency.
  • Collaborated with stakeholders to gather and translate business requirements into technical specifications.

SENIOR ORACLE PROGRAMMER ANALYST

ERCOT INC
04.2006 - 01.2008
  • ERCOT is a global energy company, recognized as a leader in the mediation of energy companies in Texas
  • Data Architect
  • 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

DELL INC
05.2005 - 03.2006
  • Dell is one of the largest computer manufacturing companies in the world
  • QA
  • 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

UBCJ UNION Contracting through Eastridge InfoTech Inc
01.2005 - 05.2005
  • UBCJ Union is one other the United States largest credit union
  • QA
  • 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

DELL INC
05.2004 - 12.2004
  • Dell is one of the largest computer manufacturing companies in the world
  • QA
  • 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

APPLIED ENGINEERING MANAGEMENT Inc
03.2003 - 12.2003
  • AEM is a contracting company for Governmental programming need
  • QA
  • 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

SPRINT Contracted through Techni-Source Inc
11.2002 - 03.2003
  • Phone company icon in telecommunications as needed for all
  • QA
  • 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
  • Oracle RAC environment
  • Using SQL Navigator performed code tuning, Discoverer
  • Maintained forms and reports version control using PVCS
  • Authored application with Oracle 6i forms and reports designing.

PROGRAMMER ANALYST

American Technology Inc
01.2002 - 08.2002
  • Contracting company servicing and has been bought out by IBM as needed for programming
  • QA
  • 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 and DB modification techniques
  • Toad SQL editor, Tableau Reports
  • Oracle RAC environment
  • 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

DELL Contracted through Nims Associates Inc
01.2001 - 06.2001
  • Dell is one of the largest computer manufacturing companies in the world
  • QA
  • 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
  • Maintained report version control with PVCS.
  • Collaborated with stakeholders regarding project capabilities and limitations to deliver optimal functionality.
  • Wrote code for database applications.
  • Used ASP.NET, JavaScript and SQL Server to develop new applications.
  • Identified causes of issues within applications and determined which modifications needed to be made.
  • Mastered multiple frameworks for software development.
  • Analyzed, reviewed and revised programs to increase operating efficiency.

Education

Bachelors of Science - Computer Science Engineering & Software Design

National University
San Diego, CA
1992

Skills

  • 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
  • Oracle SQL Trace and TKProf to do SQL debugging
  • President of Toast Masters Club with strong oral and written communication skills
  • ETL Extraction, Transforming and loading of heavy data loading
  • 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 ,11gR111g, 10g, 9i (RAC)), Web DB, MS Access
  • CERTIFICATES OF COMPLETION
  • ACHIEVEMENTS
  • Oracle Forms, Report and SQL Tuning
  • Oracle Apex Application Server design
  • Java Certificate of Consulting Solutions
  • Access
  • Competent Toast Master

Accomplishments

  • 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 and Tuning
  • 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

Certification

Java Certificate of Consulting Solutions

Competent Toast Master

Had been a member of Toast Master and moved up the ranks to become presidents of my group division

Languages

Spanish
Professional Working

Timeline

ORACLE PROGRAMMER ANALYST

USPS Contracting through KForce
09.2023 - 10.2024

SENIOR ORACLE PROGRAMMER ANALYST

CENTENE Contracting, Randstad
10.2022 - 03.2023

SENIOR ORACLE PROGRAMMER ANALYST

SYNODEX Contracting through LOGIX-TECH SOLUTIONS
01.2022 - 09.2022

SENIOR ORACLE PROGRAMMER ANALYST

ZIONS BANK contracting through STRATEGIC SYSTEMS
02.2021 - 10.2021

SENIOR ORACLE PROGRAMMER ANALYST

TEXAS PARKS AND WILDLIFE Contracting, CYNET SYSTEMS
06.2020 - 09.2020

SENIOR ORACLE PROGRAMMER ANALYST

Army & Air Force Exchange Service, CIGNITI INC
02.2020 - 04.2020

APPLICATION PROGRAMMER

ACTUMPROCESSING of Econosoft Inc
09.2019 - 12.2019

SENIOR ORACLE PROGRAMMER ANALYST

TEXAS LOTTERY COMMISSION Contracting, ACE TECHNOLOGIES INC
06.2019 - 08.2019

SENIOR ORACLE PROGRAMMER ANALYST

RHYAN TECHNOLOGY SERVICES
10.2018 - 12.2018

SENIOR ORACLE PROGRAMMER ANALYST

LEIDOS Contracting, NORWIN TECHNOLOGIES INC
03.2017 - 06.2018

SENIOR ORACLE SOFTWARE DEV ADVISOR

DELL
08.2015 - 10.2016

ORACLE PROGRAMMER ANALYST

HASS INC, KForce
02.2015 - 07.2015

SENIOR ORACLE/ JAVA PROGRAMMER ANALYST

VISITING Through COOPER CONSULTING INC
08.2014 - 01.2015

SENIOR ORACLE PROGRAMMER BUSINESS ANALYST

COOPER CONSULTING SERVICES INC
08.2013 - 08.2014

SENIOR ORACLE PROGRAMMER ANALYST

VETERANS ADMINISTRATION, COMPLETE PROFESSIONAL SERVICES INC
08.2011 - 07.2013

SENIOR ORACLE FINANCIALS PROGRAMMER ANALYST

STAGE STORES INC
03.2008 - 07.2011

SENIOR ORACLE PROGRAMMER ANALYST

ERCOT INC
04.2006 - 01.2008

SENIOR ORACLE PROGRAMMER ANALYST

DELL INC
05.2005 - 03.2006

ORACLE PROGRAMMER ANALYST

UBCJ UNION Contracting through Eastridge InfoTech Inc
01.2005 - 05.2005

SENIOR ORACLE PROGRAMMER ANALYST

DELL INC
05.2004 - 12.2004

ORACLE PROGRAMMER ANALYST

APPLIED ENGINEERING MANAGEMENT Inc
03.2003 - 12.2003

PROGRAMMER ANALYST

SPRINT Contracted through Techni-Source Inc
11.2002 - 03.2003

PROGRAMMER ANALYST

American Technology Inc
01.2002 - 08.2002

APPLICATION DEVELOPER / PROGRAMMER ANALYST

DELL Contracted through Nims Associates Inc
01.2001 - 06.2001

Bachelors of Science - Computer Science Engineering & Software Design

National University

Similar Profiles

CREATE PROFILE
MICHAEL A. BROOKSOracle PL/SQL Developer