Oracle Developer
Resume:
[pic]
VEENA
(**************@*****.***
Summary
. Over 5.5 years of experience in complete software development life cycle
with emphasis on analysis, design, application development, testing,
implementation and support.
. Extensive experience in Oracle database design and developing Stored
Procedures, Packages, Triggers, Oracle forms 6i and Oracle Reports 6i.
. Extensively used SQL*LOADER to load data from flat files to database
tables.
. Proficient in Oracle Tools and Utilities such as Oracle Developer and
TOAD.
. Worked on Oracle Daybreak tool to customize loan origination, servicing
and collection.
. Highly experienced to provide Client Support on Production System.
. Experienced in tuning SQL queries using Hints, application tuning using
Explain Plan, creating Indexes and caching sequences.
. Expert in Dynamic SQL, Collections, Bulk Binds, Bulk Collects and
Autonomous Transactions and Exception handling.
. Strong database programming experience in developing Interface/Conversion
Programs using Packages, Procedures, Functions and Database Triggers in
PL/SQL.
. Trained in oracle applications including GL, AP, AR and HRMS.
. Good knowledge in Oracle Workflows, Oracle Reports and XML Publisher.
. Used Visual Source Safe and PVCS for version control. Tracker for SCR
tracking and follow up.
. Experienced in developing test cases to meet the system objectives and
involved in System and Integration Test Plan.
. Excellent oral and written communication skills, analytical and
interpersonal skills.
. Good team spirit and organized working habits with a willingness to learn
new concepts and ability to work individually or work as part of a team.
. Conducted training for end-users and created User Manual documents.
Educational Qualification and Training:
. Bachelors in Information Technology.
. Oracle PL/SQL Developer Certified Associate (OCA).
. Trained in Oracle Workflows.
. Trained in Oracle Apps (GL, AP and AR).
Technical Skills:
Programming Languages : SQL, PL/SQL, C, C++, Shell script, Java 2.0, COBOL
Internet Technologies : HTML, JavaScript, XML
Oracle Tools : SQL * Loader, TOAD, Oracle Developer, Daybreak, Reports
6i, Forms 6i.
Databases : ORACLE, MYSQL, MS-Access.
Operating Systems : MS-DOS, Windows XP/ 2000/NT 4.0/98/95, UNIX.
Others : Visual Source Safe, PVCS, Tracker.
Professional Experience
Hyundai Motors Finance Company, Irvine CA Jan 09 - Till
date.
Role: Oracle Developer
Environment: Oracle 9i, SQL*PLUS, PL/SQL, TOAD, Oracle SQL Developer,
Oracle forms and Reports 6i.
Responsibilities:
. Responsible for gathering requirements, design, development and
implementation of Decision Engine and Pricing Engine projects.
. Worked on Oracle Daybreak tool in automating all aspects of financing
from loan origination, servicing and collection.
. Extensively worked on Oracle Daybreak interface with Blaze to fetch the
appropriate pricing string, pricing edits and promotion features for
Pricing Engine project.
. Developed an interface program to create an xml file that blaze would
process and also to interpret output xml from blaze and populate the
daybreak staging tables. Used DBMS_XMLPARSER and XMLELEMENT to code the
interface.
. Worked on Systematic payment reversal project. Converted lockbox files
received from Bank one and WU into daybreak compatible format. Worked out
logic to identify return records and process their payment reversal.
. Studied the dependencies between DAYBREAK and LEASEPAK and worked towards
removing the dependencies in case of Disaster Recovery Management.
. Worked on performance tuning using indexes and well structured queries.
Coordinated with DBA in running statistics to come up with a better query
that fine tuned the performance.
. Developed PL/SQL packages, Procedures, Functions and Triggers.
. Developed forms and reports. Worked extensively on Loan Origination form.
. Customized a very complex loan origination form to add the re-scoring and
re-pricing functionality.
. Modified loan servicing forms to identify the CSP accounts and flag them
as special accounts.
. Involved in Unit testing, bug fixing, project meetings, code review and
UAT.
. Provided Production support and worked for enhancement and maintenance
tickets.
Car Quest Technologies, Raleigh North Carolina Dec 07
- Dec 08.
Role: Oracle Developer
Environment: Oracle 9i, SQL*PLUS, PL/SQL, TOAD, Oracle SQL Developer,
Oracle forms and Reports 6i.
CARQUEST Auto Parts is the premier supplier of replacement products,
accessories and equipment for virtually all makes of automobiles, as well
as light and heavy-duty trucks, off-road equipment, buses, recreational
vehicles and agricultural equipment.
Responsibilities:
. Involved in design, development, testing and implementation for various
projects in the Finance Management (FM) department.
. Involved in projects that required closely working with the oracle
applications team enabling me to learn concepts in oracle applications
tool, from both functional and technical perspective.
. Extensively used SQL*LOADER and Stored procedures to load data from flat
files to update the application database.
. Created shell scripts using powerful commands like GREP, AWK, and CUT
etc. Used shell scripts to split files, FTP and monitor background jobs.
. Responsible for developing the new reports Using Oracle Reports and XML
Publisher.
. Developed PL/SQL packages and developed forms and reports. Used LOV,
Alerts and triggers to meet business requirements.
. Testing and Debugging of stored procedures using TOAD.
. Documentation of all the modules for user level and system level
maintenance.
. Involved in performance tuning of various database queries using explain
plan. Reviewed test plan and test cases.
. Troubleshooting and fixing the problems during the Testing cycle. Used
debugging option in TOAD to resolve bugs.
. Implemented Oracle workflows to track the timesheets of the employees and
send notifications to employees with incomplete timesheets.
. Provided Production support and worked for enhancement and maintenance
tickets.
TATA Consultancy
Jan05 -Oct 07
Role: Systems Engineer
Environment: Oracle 8i, UNIX, VSS, PL/SQL Developer
Project Black water aims at divestment of four of NG Transco's distribution
networks to private or independent network operators. The sold networks'
data would be extracted into formatted flat files and delivered to
respective buyers for setting up their own systems.
Responsibilities:
. Involved in the development of technical documents by coordinating with
the onsite team.
. Involved in the design of approach of Data Migration.
. Developed the business reconciliation checks using SQL queries.
. Studied the system named EWMS (Emergency system) which stored all the
data related to the emergency cases.
. Development of PL/SQL Code based on the approved Technical
Specifications.
. Involved in all the Trial and Live Data Migrations.
. Developed shell scripts split huge data files and do various other
integrity checks.
. Coordinating with the Onsite team in resolving the issues.
. Carried out the Data Migration process successfully.
. Involved in training PL/SQL and UNIX.
Contact this candidate