SUMMARY

• Confidential is an Oracle PL/SQL Developer Certified Associate with 8 years of Oracle Development experience including requirement gathering and analysis, modeling, design, administration and maintenance of Oracle Database systems on both UNIX and NT platforms.
• Her broad experience includes Oracle 10g/11g, PROGRESS 4GL, Unix shell scripting, SQL *PLUS, MySQL including database design, development with emphasis on back - end stored procedures, functions, triggers, database performance tuning and scheduling jobs using CRONTAB.
• Confidential has excellent communication and presentation skills from working closely with business and technology teams and has created and presented different documentation of a SDLC project life cycles.
• She has proficient knowledge of Oracle E-Business Suite and has additional skills including Data Modeling, Data Mapping, Table Normalization, Query Optimization and Performance Tuning, Oracle Hints, Explain plans, Bulk collects, bulk binds, TKPROF.

TECHNICAL SKILLS

RDBMS: PROGRESS 4GL, Oracle 10g/11g, Performance Tuning

Database Applications: Microsoft Access

Oracle Financials: E-Business Suite 11i

Programming Languages: Core Java, JDBC, SQL, PL/SQL, Unix shell scripting, HTML, PERL

Operating System: UNIX, RHEL 5.0, Windows Vista, XP, 2003, NT, 7

Data Modeling Tools: VISIO, Rational Rose

Source Safe: PVCS, VSS, WinSCP, MPP, Putty

PROFESSIONAL EXPERIENCE

Confidential, NC

Oracle Pl/Sql Developer

Responsibilities:

• Serves as senior level developer working on multiple concurrent projects to enhance an enterprise collections application serving multiple business units.
• Maintain and support existing software application.
• Performance tuning and PL/ SQL tuning
• Strong experience with batch processes and complex packages, bulk binding and partitioning
• Optimization of existing PL/SQL Code
• Identify and resolve complex application issues and bugs.
• Review and/or write code to enhance and/or extend application.
• Provide subject matter expertise in reviewing, researching and resolving business problems presented in requirements specifications.
• Test new installations and/or software prior to release to minimize failures and impact to business and end users.
• Provide subject matter expertise and business analysis in addressing complex projects and issues.
• Serve as a mentor to junior staff. Oracle DBA knowledge, PL/SQL Developer IDE, Java, PowerBuilder, Perl

Environment: Oracle 11g, PL/SQL Developer, UNIX, Windows XP, Java v1.6, Power builder

Confidential, NJ

Programmer

Responsibilities:

• Worked in Oracle E-Business Suite and implemented Oracle iReceivables for Confidential . This was done to ease the credit card payment system.
• Implemented Oracle Modules on Accounts Receivables.
• Created function and technical specification documentation.
• Responsible for configuration of Oracle iReceivables in development and test environment.
• Tested the application, wrote test case scenarios and did bug fixes.
• Worked in other E-Business Suite, such as, Oracle Bills of material, Payroll, HRMS.
• Involved in configuring up approval levels in Oracle applications.
• Used Oracle E-Business Suite applications for accounts payable/accounts receivable (AP/AR), general ledger, fixed assets, and cash management, supporting data extraction, filtering and validation
• Worked directly with the end users and resolved production issues.

Environment: Oracle 10g, Forms 10, Reports 10g, SQL*Plus, TOAD, SQL*Loader, SQL, PL/SQL Developer, UNIX, Linux, Windows XP.

Confidential, NY

Responsibilities:

• Designed and developed packages for scheduling appointments, inspections and surveys.
• Developed database objects Procedures, Functions, Packages, Collections, Synonyms, Constraints, Indexes and External Tables.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes
• Views in Development and Production environment using PL/SQL and SQL*Plus.
• Performed performance tuning (TKProf, SQL Trace, Oracle Hints and Explain Plan).
• Used the collections and bulk binding for processing billions rows and to improve the performance.
• Data transferred/migrated between two Oracle databases using DB Link.
• Involved in day-to-day database maintenance, Partition tables, Unix Job Scheduling.
• Prepared and ran scripts for creating tables, indexes, etc.
• Prepared Technical Design and Installation Documents.

Environment: Oracle 10g/9i, SQL, PL/SQL Developer, SQL*Loader, Toad, UNIX.

Confidential, NJ

Responsibilities:

• Worked with Oracle databases to manage data for development, training and production environments.
• Wrote PL/SQL Functions and Stored Procedures to provide APIs to front-end developers to manipulate the database.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes
• Views in Development and Production environment using PL/SQL and SQL*Plus.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Used TOAD to run SQL and PL/SQL code to manipulate the databases in all environments.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Loader, Bourne Shell script, TOAD, Oracle Forms 9i, Reports9i. iFast Management Systems, India

Confidential

Responsibilities:

• Worked on the implementation and support for the enhancements being done.
• Communicated directly with the customer and resolved issues when tickets were opened.
• As a part of this activity, needed to analyze, document, code change, test and deploy.
• Solved both Technical issues and Business issues in implementing the features.
• Coordination between the on-site and offshore team for task tracking, planning and defect tracking enhancements and bug fixes.

Environment: PROGRESS 4GL, UNIX

Confidential

Responsibilities:

• Responsible responsibilities include enhancements of existing applications built using PROGRESS 4GL.
• Created transactional and batch processing for different clients with different contract types and funds.
• Involved in the coding and testing of all the modules developed for the project.
• Preparations of detailed unit test cases for the enhancements made and also include various possible cases of testing.
• Used HINTS to tune queries for better performance and also extensive usage of Indexes
• Worked on the implementation and application deployment in production.

Environment: PROGRESS 4GL, UNIX

Confidential

Responsibilities:

• Responsible for analysis and gathering system requirements.
• Used Oracle forms and reports for report generation.
• Created application schema as tables, views and indexes.
• Customized the stored procedures, functions, packages and database triggers in PL/SQL.
• Implemented and tuned the indexes. Handled pre-defined and user-defined exceptions.
• Established JDBC connection using database connection pool.

Environment: Oracle forms and reports, SQL, Unix Shell Scripting, Java.