SUMMARY

• Seven + years of experience in various phases of Software Development life cycle, including Designing, Development and Testing as a Developer and Software Engineer
• Expertise in Oracle PL/SQL, Oracle FORMS & REPORTS
• Expertise in using Oracle 8i/9i/ 10g/11g databases.
• Proficient in Oracle Tools and Utilities such as TOAD, PL - SQL Developer.
• Proficient working experience with SQL, PL/SQL, Stored Procedures, Functions, Packages, DB Triggers, Indexes etc.
• Involved in creating scripts for Creates, Alters and Data Modifications.
• Extensive experience in using SQL*Loader.
• Experience in FORMS and REPORTS Customization
• Development of PO interfaces using PL-SQL.
• Experience in Oracle Apps Financial Domain (PO, AR, AP, GL, System Admin, P2P cycle) .
• Defining Concurrent Programs, Executables in Oracle Apps
• Registering Form and reports in Oracle Apps.
• Experience in Unix Shell scripting and JAVA Script
• Experience in Data modelling.
• SQL Performance Tuning.
• Knowledge in ETL Processes.
• Experience in Technical Documentation.
• Experience in interacting with Business users.
• Strong analytical, diagnostic and troubleshooting skills and ability to work in a fast-paced and team-oriented environment with excellent communication and interpersonal skills.

TECHNICAL SKILLS

Software Development: SQL, PL/SQL, FORMS, REPORTS, C, C++, Java, SQL*Loader, TOAD, SQL Developer, SQL Navigator, Oracle Apps modules (PO, AR, AP, System Administrator)

Databases: Oracle 10g/9i/8i

Operating System: UNIX, Windows XP, NT/2000/98/95

Other Tools: Putty, FTP tools, Automation tools like Selenium, Test inventory tools like Quality Centre, ZIRA, TESTLINK

PROFESSIONAL EXPERIENCE

Sr. Oracle PL/SQL Developer

Confidential, Dallas, TX

Responsibilities:

• Analysis of the specifications provided by the clients.
• Developing PO Interface using packages, procedures, Triggers.
• Project on Oracle Apps(Financial Domain).
• Worked on Stored Procedures, Functions, Packages, Triggers, Cursors, Views, Materialized views.
• Database Design
• Worked on P2P cycle
• Developing the Customer order forms.
• Data loading with SQL* Loader
• Used Version Control tools like Perforce
• Designed procedures for complex reports using Pl-SQL procedures and functions.
• Customisation of reports and forms.
• SQL Query Tuning.
• Designed Unix shell scripts for job processing.
• Production Support( Bug fixing)
• Worked on data modelling
• Worked on Oracle IDS

Environment: Oracle11g, Oracle 11i,PL-SQL,SLQ Plus, Forms, Reports, Windows 98/2000/XP,TOAD

Sr. Oracle PL/SQL Developer

Confidential, Seattle, Washington

Responsibilities:

• Requirement Analysis
• Developing of PO interface using packages, procedures, triggers, cursors etc.
• Project on Oracle Apps(Financial Domain).
• Worked on P2P cycle
• Forms and reports customisation
• Used Toad to run SQL and PL/SQL code to manipulate the databases.
• Involved in creating packages/procedures/functions/, SQL scripts to facilitate the functionality for various modules.
• SQL Query Tuning.
• Implement Oracle Jobs to run the packages at specific time intervals.
• Implemented User Docs for the application.
• Involved in providing customer support for the users
• Developed Complex SQL queries using various joins and developed various dynamic SQL’s
• Planned version control of production source code using Perforce
• Project in Healthcare domain

Environment: Oracle 10g, SQL plus, Forms, Reports, UNIX, Windows 98/2000/XP, Toad.

Oracle PL/SQL Developer

Confidential, Dayton, OH

Responsibilities:

• Used Toad to run SQL and PL/SQL code to manipulate the databases.
• Creation of database objects like Tables, Views, Materialized views, Procedures, Packages using Oracle tools using SQL, PL/SQL.
• SQL Query Tuning.
• Performed unit testing for the PL/SQL functions and forms.
• Designed the front end interface for the users, using Forms.
• Designed the flow and coded underlying stored procedures to support the customized functionality of the forms.
• Development of Customer Reports and Forms.
• Developed validation Procedures to validate data before posting the data into Table.
• Involved in meetings with client to freeze the requirement and to begin with development.
• Strictly adhered to coding standard and naming conversion of objects.
• Fixing bugs & Developing change requests.
• Interacted with Project Leads and Technical Leads for Change Request Process.
• Worked on tuning the SQL Queries for better performance.

Environment: Oracle 9i, SQL plus, Forms, Reports, UNIX, Windows 98/2000/XP, Toad.

Oracle PL/SQL Developer

Confidential

Responsibilities:

• Performed design, coding, implementation and support.
• Wrote Stored Procedure, Package and Triggers for back end validations
• Forms and Reports Customization
• Wrote Procedures using Oracle supplied Packages
• Measuring and reporting product list using Excel, PL/SQL scripts.
• Wrote complex SQL queries using joins and correlated sub queries
• Development of Forms and reports for Information Data Management System module
• Technical Design and development
• Interacting with the client for more clarity on the requirements if required.
• HLD/Customer Visible Documentation
• SQL Query Tuning.
• Worked on surveillance.

Environment: Oracle 9i, SQL plus, Forms, Reports, UNIX, Windows 2000/XP, Toad, Proprietary database, Proprietary language called PROTEL similar to JAVA.,PL-SQL code browsing tool MENTOR