SUMMARY:

• Oracle PLSQL 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.
• Excellent communications and presentations skills to work closely with business and technology team.
• Created and presented different documentation of a SDLC project life cycle.
• Excellent command on Oracle 9i/10g/11g, PROGRESS 4GL, Unix shell scripting, SQL PLUS, MYSQL including database design, development with emphasis on back end stored procedures, functions, triggers.
• Proficient knowledge in Oracle E-buisness suite.
• Skilled in Data Modeling, Data Mapping, Table Normalization, Query Optimization and Performance Tuning.
• Knowledge of PL SQL Programming using packages, procedures, functions, Object Types, Collections, Cursors, Dynamic SQL, Bulk Collect, Materialized Views and SQL Loader. Sound knowledge in tuning SQL statements. Oracle Import/Export Utilities and SQL Loader
• Extensive experience in Shell scripting and scheduling the job using CRONTAB.
• Experience in tuning of complex SQL statements using Oracle Hints, Explain plans, Bulk collects, bulk binds, TKPROF.
• Pro-active team player with good experience on various project tasks and activities, including resource planning, project status tracking, communication of project progress and issues.
• Knowledge of Banking and Financial domain.

Technical Expertise:

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

Oracle Pl/Sql Developer

Responsiblities:

• 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

Programmer

Responsiblities:

• Worked in Oracle E-Business Suite and implemented Oracle iReceivables for Stryker Spine. 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

Responsiblities:

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

Responsiblities:

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