Oracle Forms Developer Resume
3.00/5 (Submit Your Rating)
SUMMARY
- Broad - based background in Oracle and database management with hands-on skills in successful implementation of core enterprise software applications.
- Comprehensively understands and analyzes complex software requirements. Identifies software deficiencies and potential opportunities for process improvement.
- Designs and develops innovative solutions for increasing reliability and improving productivity.
- Highly productive team player recognized for positive attitude, flexibility and working well under pressure.
- Continuously focuses on best practices for coding techniques, testing habits, performance tuning and problem resolution that contribute to achieving targeted benchmarks.
TECHNICAL SKILLS
Languages: SQL and PL / SQL, Microsoft SQL
Tools: Oracle 11.x, SQL*Plus, Toad, SQL Developer, Forms 6i, Reports 6i and Graphics 2.5Oracle Fusion Middleware 11g
OS: Linux / Unix & Windows 2000 / XP
PROFESSIONAL EXPERIENCE
Confidential
Oracle Forms Developer
Responsibilities:
- Developing and modifying existing PL/SQL packages and functions.
- Modifying the existing forms and menu forms in 11g to check if the Location, Zone and Aisle are maintainable as per the requirement.
Confidential
Systems Analyst / Programmer III
Responsibilities:
- Completed several successful major projects by utilizing expertise in Oracle forms, reports and PL / SQL stored procedures development.
- Developed Microsoft SQL scripts that exported data from 2 different applications enabling scripts to be imported it into newer application, re-written using Click software. Data helps in testing pilot project in new software.
- Trained and provided knowledge transfer support to 2 onshore / offshore personnel for supporting PowerVision application that enabled trainees to function without supervision.
- Added new multi-tab form that enhanced PowerPro margin analysis tools by 1) showing all jobs for proposal; 2) exhibiting default finance and manual override modifiers for selected proposal; 3) providing product cost, SAP expense and override information; and 4) giving option of modifying override cost.
- Added new functionality to existing forms that validated and performed various checks to allow items to be substituted for components of a blend.
- Created PL / SQL procedures that helped DBA administer and sync mobile and production databases for PowerVision, such as filtering and retrieving active jobs accrual reports from laptop / production databases used by accounts department to track revenue.
- Utilized order fulfill interface (OFI) to integrate the PowerVision application with BHI US Pressure Pumping SAP implementation for order fulfillment.
- Created core forms, reports and PL / SQL procedures and used Web methods that kept data in PowerVision and SAP synchronized. This enabled finance part of PowerVision to reside in SAP without impact to users.
- Developed PL / SQL procedures that updated sales orders created in SAP to PowerVision through periodic batch processing enabling users to view generated sales order numbers in systematic way for jobs that did not use form.
- Created ability to process invoices and perform credit / customer checks before sending jobs to be invoiced in SAP. Enhancement allowed user to verify information prior to invoicing.
- Designed and developed sophisticated scheduling program that generated user-preferred weekly or monthly dates with choice to include or exclude certain weekends and holidays for periodic truck treatment.
- Created daily job route generation PL/SQL program that informed driver about wells to be treated, frequency of treatments, products to be used and generated future treatment dates.
- Increased efficiency by creating job location reports for hardcopy that were given to drivers.
- Led design, development and implementation of TestDirector / Winrunner testing package for PowerVision that programmers used to test and debug PowerVision application forms and PL / SQL code.
- Created major forms, reports and database procedures for chemical services, completion fluids and coiled tubing services that users utilized to educate and convince customers for desired information /or data requirements.
- Produced functional and technical specifications to develop utility application in PowerVision that allowed exporting select group of file parameters to be imported into DIMS. Provided template for customer to view usage of products.
- Created graphing forms to help that assisted accounts department in showing overall revenue in presentations.