SUMMARY OF QUALIFICATIONS

• Major areas of Oracle: OE, Manufacturing, BOM, Inventory, Financials, AP, AR, PO General Ledger, Asset Accounting, Purchasing and Receiving modules.
• Oracle Discoverer, Oracle SQL Loader and extensive use of DB SQL Performance Tuning.
• 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 include Java based programming in secure application.
• 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 Web logic, MS tools
• LANGUAGES: PL/SQL, Pro C, MS-C/C , Visual Basic, Perl, Java, SQL Plus,
• Operating Systems: UNIX, Windows NT, DOS, NOVEL
• DATABASES: Oracle 11g, 10g, 9i RAC , Web DB, MS Access

ACHIEVEMENTS

• Conversion of old Oracle 6 form to 11g 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 packaged 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
• 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 / JAVA PROGRAMMER ANALYST Confidential

• 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.
• Programming with JAVA/JSP/XML
• Business analyst of THV application system
• Application programming using SQL Plus and PL/SQL.
• Creating SRS Documents
• Developing in SQL Developer and Eclipse IDE's
• System Testing

Confidential

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

• 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
• 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
• SRS and SRS Release Documentation
• Unix Cron Jobs maintenance
• Writing Oracle Reports with SQL
• Interviewing applicant for a Oracle Forms position
• SRR detailed documentation of the software being development and deployment
• Have a Veterans Administration security MBI clearance

SENIOR ORACLE FINANCIALS PROGRAMMER ANALYST Confidential

• 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 reports.
• Oracle Apex Application Design web based application, and J-Developer converting Oracle forms
• I work with Oracle APPs 11i, and perform additional functionality for reports and other responsibilities.
• Oracle 10g forms, EBS
• Business analyst of Financial system
• 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 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.

SENIOR ORACLE PROGRAMMER ANALYST Confidential

• 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 of their system.
• Worked with Oracle 9i designing for PL-SQL scripts and packages for overall 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
• Tibco data transfer
• QC documenting testing processing heights
• QTP and Quality Center applications for writing test scripting.

SENIOR ORACLE PROGRAMMER ANALYST Confidential

• 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
• Tandem SQLCI scripting.
• QTP and Quality Center applications for test scripting.

ORACLE PROGRAMMER ANALYST Confidential

• UBCJ Union is one other the Confidential 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.
• Data research reporting.
• Perl in UNIX shell scripting to create application alert notification.

SENIOR ORACLE PROGRAMMER ANALYST Confidential

• Dell is one of the largest computer manufacturing companies in the world.
• Application programming using SQL Plus and PL/SQL.
• 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.
• Data research reporting.
• Continental deployment of the of system Oracle application.
• UNIX shell scripting to create application alert notification.

ORACLE PROGRAMMER ANALYST Confidential

• 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 documentation for current deployment of their system. I authored PL/SQL scripts.

PROGRAMMER ANALYST Confidential

• Phone company icon in telecommunications as needed for all.
• Application programming using SQL Plus and PL/SQL, and also 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

• 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.
• 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 Main frame application into an Oracle Web enabled Application.
• Normalizing table structures and optimizing SQL and PL-SQL code.

APPLICATION DEVELOPER / PROGRAMMER ANALYST Confidential

• 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 insure safety of data integrity.
• Corrected timing discrepancies, adjusting where data coming into the Glovia System was to 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 Confidential

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

• FRSI is a company for help device controls measurements.
• Developed reports with Oracle reports designer 2000 with SQL Plus and PL/SQL, Discoverer, and Noetix Views.
• 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, 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 system's business rule validation, Writing Oracle Reports with SQL, Noetix views in regards to configuration BI
• Converting VAX system to Oracle Web DB to provide Web Expense reports and agent client data searches.