SUMMARY:

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

TECHNICAL SKILLS:

SOFTWARE: Net Beans & Eclipse, Word, Excel, Power-Point. OE, Oracle Forms, Reports & Apex, Oracle Web logic, MS tools, Toad, SQL, Nav, PL-SQL Dev.

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

PROFESSIONAL EXPERIENCE:

ORACLE PROGRAMMER ANALYST    

Confidential, Austin, TX

•    Application testing and programming using SQL Plus and PL/SQL.        
•    Created SRS and SDS documentation for current deployment of their system.
•    Working with Oracle 11i designing for PL, SQL scripts and packages for overall system usage.
•    Data research reporting with various tools such as Toad, and SQL Develo
•    Business analyst of business Haas system

SENIOR ORACLE/ JAVA PROGRAMMER ANALYST

Confidential, Austin, Texas

• 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, Hibernate, Spring Framework, J2EE
• 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

SENIOR ORACLE PROGRAMMER BUSINESS ANALYST 

Confidential

• 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, Richmond, Virginia

• Oracle Application reports and programming using SQL Plus and PL/SQL 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
• 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, Houston, TX

• Oracle Application reports and programming using SQL Plus and PL/SQL, 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, Taylor, TX

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

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

Confidential,  Las Vegas, NV

• 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, Austin, TX

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