SUMMARY:

• 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.
• 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 applications 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.

TECHNICAL SKILLS:

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, Tableau

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 (12r, 11i, 10g, 9i (RAC)), Web DB, MS AccessS

PROFESSIONAL EXPERIENCE:

SENIOR ORACLE PROGRAMMER ANALYST

Confidential, Austin, Texas

Responsibilities:

• 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

Confidential, San Antonio, Texas

Responsibilities:

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

Confidential, Round Rock, TX

Responsibilities:

• 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

Confidential, Austin, TX

Responsibilities:

• 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

SENIOR ORACLE/ JAVA PROGRAMMER ANALYST

Confidential, Austin, TX

Responsibilities:

• 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

Confidential

Responsibilities:

• TX Helping Injury Epidemiology Surveillance Program Studies.
• Oracle Application reports and programming using SQL Plus and PL/SQL. Createdscripts andHLD & SRRdocumentation for current deployment of systemprojects.
• Creating SAP Business Objects dynamic metrics for SAS reporting
• 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

Confidential

Responsibilities:

• 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

Confidential, Houston, TX

Responsibilities:

• 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
• 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 Confidential 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 hierarchies 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

Confidential, Taylor, TX

Responsibilities:

• Confidential 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

Confidential , Austin, TX

Responsibilities:

• Confidential 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

Confidential, Las Vegas, NV

Responsibilities:

• 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

Confidential, Austin, TX

Responsibilities:

• Confidential 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

Confidential, San Antonio, TX

Responsibilities:

• 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 Confidential 's Oracle HRMS modifications, and created SRS doc’s for current deployment of their system. I authored PL/SQL scripts.

PROGRAMMER ANALYST

Confidential, Kansas City, KS

Responsibilities:

• 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

Confidential, Austin, TX

Responsibilities:

• Contracting company servicing and Confidential 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, 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

Confidential, Austin, TX

Responsibilities:

• Confidential 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 ccurred 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 insure 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
• QA and Maintained report version control with PVCS.

APPLICATION DEVELOPER / PROGRAMMER ANALYST

Confidential, Austin, TX

Responsibilities:

• 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

Confidential , Austin, TX

Responsibilities:

• FRSI is a company for help device controls measurements.
• Developed reports with Oracle reports designer 2000 with SQL Plus and PL/SQLDiscoverer, 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 AccountingPurchasing 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.