SUMMARY

• More than 8 years of experience in Oracle 11g/10g/9i/8i, SQL, PL/SQL as an Oracle Developer.
• Excellent skill in Triggers, Stored Procedures and Standard Packages.
• Extensive experience using SQL, PL/SQL, Oracle Reports.
• Strong skill set in using developer tools such as Oracle Forms 9i/6i, Reports 9i/6i.
• Developed several custom reports using Oracle Reports 6i/9i and Oracle Discoverer 4i/9i/10g
• Extensive working knowledge in database objects like creating tables, views, indexes, sequences, primary key, foreign keys and constraints.
• Proficient in Oracle Tools and Utilities such as SQL Loader, TOAD, Putty.
• Experience with Software Development Life Cycle SDLC process, performing detailed analysis, collecting requirements, coding and unit testing, integration and system testing.
• Experience in interacting with Business/Technology groups and analyzing business needs.
• Excellent Interpersonal Skills which helped me to share a good report with co-workers and the management.
• Innovative professional with proven ability to identify, analyze, and solve problems to increase customer satisfaction through expertise knowledge in database programming using PL/SQL Collections, Cursors, Records, Ref Cursors, Bulk Processes, Merge, Exceptions handling, Autonomous transactions, and Standard DBMS Packages of Oracle Database, Utilities and analytic functions.

Excellent client handling skills and proven experience.

• Worked on 24 7 environments to provide necessary support.
• Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases.
• Working Knowledge on Unix Shell Scripting.
• In addition to excellent technical abilities possesses strong oral and written communications skills, analytical and interpersonal skills.
• An innovative, forward-thinking, proactive, respected professional who has accomplished significant achievements in business intelligence, ETL, data warehousing, analysis, problem-solving, training, negotiating, cost-reduction, research and development.

TECHNICAL SKILLS

• Operating Systems: Windows, UNIX, Linux, Hp UX 11/10.x, MS DOS
• Databases: Oracle 8/9.x/10g/11g, Sybase, Teradata, MS SQL Server 2000, MS Access
• Front End Tools: Visual Basic 6.0, Power Builder, Forms and Reports 6i
• Other Tools: SQL Loader, TOAD, PL/SQL Developer, Export/Import Utility, SQL Navigator, Visio 2000, ERWIN, DB Artisan
• Programming Languages: PL/SQL, SQL, ASP, JSP, VB, Java
• Scripting Languages: Unix Shell Scripting, HTML/DHTML,
• Reporting Tools: Crystal Reports 8/9/10, PL/SQL Reports using Web Tool kit

EXPERIENCE

confidential

Oracle Developer

Environment: Oracle 11i/10g, , Sql Developer, TOAD, UNIX, Visual Source Safe, Vantive, MS Office Products Word, Visio, Power Point , Oracle Reports10g, Oracle Forms 10g.

• Maintained front end application by working on Oracle Forms, by working with various form triggers, LOVs, list and Record groups.
• Created and maintained reports using Oracle Reports. Working with Report Triggers, different types of columns and Parameters.
• Involved in designing and creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes, Materialized Views and Collections.
• Worked with global teams involving Business Users, Business Analyst, and Project Managers.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Creation of database objects like Tables, Views, Procedures using Oracle tools like SQL Plus, SQL Developer and Toad.
• Developed various complex queries to generate various reports based on the requirements.
• Attend Business requirement meeting and assist Business Analyst in writing BRD, Prepare Tech Specs for the Project and assist QA with testing.
• Promote code in different environments working with prod control team. Executes Unit and SIT testing.
• Worked on SQL Tuning by query optimization - tracing the query explain plan and use SQL Trace and TKPROF to monitor and improve performance and using Analytical functions and optimizer Hints.
• Created batch job in regular maintenance, email notification and production support to load the data using shell scripts and PL/SQL.
• While in Development site, wrote/review packages, procedures, functions etc as per the requirement
• Created/Reviewed the install scripts for the deployment of the application.
• Performed performance tuning by using Application Tracing Tools like SQL Trace and TKPROF, EXPLAIN PLAN and by using Optimizer hints and Indexes.
• Complete project design review with Development Team Lead.
• Notify Quality Assurance Team Leader, Developer Team Leader and IT Director for any development environment conflicts.
• Experience in using dynamic sql,oracle partitioning and using hints for performance tuning
• Import data from Excel spreadsheets to Oracle tables. Export data from Oracle tables to Excel spreadsheets. Export Crystal Reports to Excel spreadsheets.

confidential

Oracle Developer

Environment- Oracle 11g, Reports 10g, Form 10g, SQL LOADER, Windows XP, Putty, PL/SQL, SQL PLUS, TOAD 9.6

Responsibilities:

• Analyzed specifications to suggest the right solutions based on client requirements.
• Involved with design, development testing and production phases of the SDLC.
• Created PL SQL procedure, queries for Daily reports, Monthly reports, etc.
• Developed and customized complex PL/SQL procedures based on client requirement.
• Loaded sales data into the database using SQL LOADER.
• Tuned procedures to improve overall system performance.
• Created tables, views, procedures, triggers, sequences and functions and executed them using TOAD.
• Improved system performance by creating indexes.
• Modified reports as per client requirement.
• Handled production issues related to sales force reports.
• Used external tables to manipulate data obtained daily before loading them into the tables.
• Created and modified various reports using Oracles Reports Builder.
• Coordinated with the Quality Assurance/Testing team members to perform user acceptance testing UAT .
• Developed Materialized views and Ref Cursors for reporting purpose.
• Developed back end interfaces using PL/SQL stored packages, procedures, functions, Collections, Object types and Triggers.
• Coordinated with DBA in creating and managing tables, indexes, db links and privileges.
• Extracted, transformed, cleansed, and loaded ETL data from their legacy Access system to Oracle and Permit Plan / Advantage.

confidential

Oracle Developer

Environment - Oracle 10g, Reports 6i, SQL LOADER, Windows XP, UNIX, PL/SQL, SQL PLUS, TOAD 9.6/10.5, Putty and Form 6i

Responsibilities:

• Customized various Forms 10g and Reports 10g to make them user friendly based on the business requirements of the clients receivables and payables.
• Created Custom PL/SQL procedures, functions and packages.
• Created and modified different Views as per requirement.
• Developed scripts to create tables, views, procedures, triggers and functions and executed them using SQL Developer and Toad.
• Created custom forms and reports using Toad.
• Created indexes to improve the system performance.
• Worked extensively on SQL queries to generate custom reports on a regular basis.
• Developed Reports to extract the Annual sales information.
• Created Unix batch Jobs to perform regular updates to database tables to keep in sync with the data coming from other sources.
• Improved the performance of the system by tuning queries.
• Created database object using Putty, SQL plus and executed them using Toad.

Confidential

PL/SQL Developer

Environment - Oracle 10g, Oracle Discoverer 4i/10g, PL/SQL, Forms 10g, Reports 10g, TOAD, SQL Plus, Windows 2000 Professional

Responsibilities:

• Customized and developed Oracle Forms and Reports using Oracle Forms 9i and Reports 9i
• Evaluated the feasibility of the requirements by analyzing the source systems.
• Helped to prepare BRS Business Requirement Specifications document that gives the detailed information about the requirements.
• Prepared program specifications for PL/SQL Procedures and Functions.
• Involved in database development by creating PL/SQL Functions, Procedures, Triggers, Packages and views.
• Involved in Unit testing and integrated system testing.
• Performed the data migration using SQL loader scripts for importing legacy systems data into AR interface tables.
• Developed new reports and customized existing according to the requirements.
• Developed and worked extensively on SQL Loader for data transfers. Involved in user documentation and training to end-users for effective usage of developed packages.

Confidential

Oracle Developer

Environment - Oracle 8i, UNIX, PL/SQL, SQL Plus, Oracle SQL Developer 2000 Oracle Forms 4.5, Oracle Reports 2.5

Responsibilities:

• Developed numerous programs using PL/SQL and many packages to do the validations as per requirements.
• Developed Control scripts and loaded existing data using SQL Loader.
• Developed Forms /Reports using Forms 4.5 and Reports 2.5 and solved Numerous Problems in Reports.
• Developed stored procedures using PL/SQL to update payment info into Bills.
• Developed Database Triggers to enforce security.

Confidential

Oracle Developer

Environment - Oracle 8i, SQL, PL/SQL, Forms 6i, Reports 6i, UNIX.

Responsibilities:

• Developed front end forms using Forms 6i.
• Used PL/SQL Procedures, Packages and DB Triggers, created reports using reports 6i and
• developed Billing and Policy exhibit reports using Reports 6i.
• Developed reports using Reports 6i to upload information to the policy Accounting system as well as custom reports for internal use .
• Conducted Unit and Functionality Testing of the above modules.
• Performed the documentation of the modules and reports generated.
• Implemented shell scripts for scheduling batch jobs and diagnostics.