SUMMARY

• Five plus yearsof experience in the stages of software development life cycle implementation (SDLC) including gathering user and business requirements from client personal and management.
• Experience in Oracle (SQL & PL/SQL), Developer/2000(Oracle Forms, Oracle Reports).
• Solid Experience in writing SQL queries, Stored Procedures, Functions, Packages, Database Triggers, Exception Handlers, Cursors, PL/SQL records and tables.
• Good knowledge in using Views, Synonyms, Cursors, Indexes, Sequences, JOINS and Sub-Queries.
• Familiarity with SQL *Loader, Oracle import/export facility, dump files, and enabling/disabling constraints along with TOAD as well as SQL*Plus.
• Involved in Query Level Performance Tuning using Explain Plans and SQL utilities to pin point time consuming SQLs and tuned them by creating indexes and forcing specific execution plans.
• Involved in deploying Oracle Forms 6i and Oracle Reports 6i on the Web Using Oracle Application Server 9i (Oracle Forms Server, Oracle Reports Server).
• Very good experience in developing Complex Forms, LOVs, Editors, Record Groups, Object Groups, Visual Attributes, Alerts, Menus, Reports, Libraries and customizing them according to the requirements.
• Experience as Oracle Applications(E-Business Suite) Developer - Financial, Inventory, Purchasing, Order Management modules.
• Developed skeletons & templates forms & reports routines to provide standard functionality, consistent behavior and standard look - and - feel for the End Users.
• Involved in using Utilities like SQL * Loader, Import/Export.
• Exposure on Workflow, Discoverer.
• Sharp in learning and comprehending new systems and methods.
• Strong analytical, diagnostic and troubleshooting skills and ability to work in a fast-paced and team-oriented environment.

SKILLS

• Operating Systems: Windows 95/98/2000/NT/XP, UNIX
• Databases: Oracle 10g/9i/8i/7x, SQL *PLUS, MS ACCESS.
• Languages: PL/SQL, C, C++, JAVA (Basic)
• Packages: VB 6, MS Office
• Tools: Oracle Reports, Oracle Forms, SQL*LOADER, TOAD, Discoverer Plus
• Web Technologies: HTML
• ERP: Oracle Applications11.0.5 (INV, OE, AP, AR, GL)

EDUCATION

Masters in Information Systems

EXPERIENCE

Client: Confidential, MO Apr 2008 - Present
Oracle Developer
Confidential, is a holding company established to support regional seed businesses with capital, genetics and technology investments. These investments will allow the operating companies of ASI to more directly connect their customers and providing great services to their customers and building the value of their brands.

Responsibilities:

• Performed modifications for the existing SQL and PL/SQL code according to the requirement
• Developed Formsand Reports according to user requirements
• Interacted with users for forms and reports related problems
• Assisted in generating SQL scripts for performing back end testing
• Modified the Forms and Reports for new functionality
• Involved in writing procedures, functions and packages using PL/SQL
• Wrote SQL, PL/SQL scripts and built some complex queries using SQL and wrote stored procedures using PL/SQL
• Assisted in using Cursors, REF Cursors, Composite data type and Collections in writing the backend PL/SQL code
• Resolved production issues and Developed existing Application Enhancements
• Involved in the design, development and testing of the PL/SQL stored procedures, packages and triggers
• Wrote Data fix up SQL queries for production data
• Used PVCS tracker for defect management
• Assisted in using SQL*Loader to load data from Excel file into temporary table and developed PL/SQL program to load data from temporary table into database Tables

Environment: UNIX, Windows 2000, Test Director, PVCS Tracker, Oracle, SQL, PL/SQL, SQL Plus,
TOAD, Oracle Forms, Oracle Reports.

Confidential, Chicago, IL Nov 2007 - Apr 2008
Oracle Applications Developer

Involved in the Oracle Order Entry process and Inventory Management for a Manufacturing Application . Responsibilities: Created tables, stored procedures, advanced queries, triggers, views, indexes, and functions using SQL *PLUS, PL/SQL Created a SQL *Loader script for Item import and loaded the flat files into oracle tables using SQL *Loader Developed and customized Reports and Forms Registration of Concurrent programs implemented PL/SQL method for calling concurrent programs, defining value sets and parameters for customer. Involved in system administration functions such as creation of users, creation of responsibilities, defining value sets, managing concurrent manager, creation of concurrent programs and executables, registering applications Environment: Oracle Manufacturing 11.5.0(Order Entry (OE), Oracle Inventory (INV), SQL*Plus, UNIX & Windows NT

Client: Confidential, VA Oct 2006 - Nov 2007
Oracle Developer
Global Order Processing Lifecycle Delivery is an order processing and management system for Equant's multinational telecommunication business. GOLD allows the users to process different types of orders for both internal and external users. It is a multi-tiered architecture system with HTML at the presentation tier, J2SE on the Web logic application server for the business logic and Oracle for the data tier.

Responsibilities:

Involved in developing Forms for data load and generated various reports using Oracle Forms and Reports Involved in development, maintenance of Packages, Stored Procedures, Functions and Triggers Involved in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables Analyzed the performance of the SQL queries and created the scripts for indexes Wrote SQLqueries to developed test data for use during test execution Created SQL Loader Scriptsto load data to database Involved in developing packages, stored procedures, functionsand database Triggers Created scripts for collection of statistics, reorganization of tables and indexes, and created indexes to enhance performance for data access Wrote test cases and developed SQL queries for testing the application

Environment: UNIX, Windows 2000, Test Director, CVS, Oracle 9i, SQL, PL/SQL, SQL Plus, Oracle Forms, Oracle Reports.

Client: Confidential, Hyderabad, India Aug 2005 - Sep 2006
Oracle Developer
The project demanded expertise and support in areas of Oracle PL/SQL, Implementation of Oracle Forms and Reports, for the client. There was a thorough involvement in the project right from, creating the Blue Print for the voting procedures and gathering the requirements from the client, to implementation and finally maintenance.

Responsibilities:

• Involved in gathering the functional requirements through various meetings with technical as well as functional team members and going through the requirement documentation of the enterprise and preparing the documentation accordingly
• Involved in the documentation of Functional Specifications with a thorough understanding of Voting policies and regulations
• Designed the University's first ever Online Election model
• Created various custom forms and reports using Oracle
• Developed stored procedures, advanced queries, triggers, views, indexes for the Election database by using SQL*PLUS and PL/SQL.
• Configured securities and accesses to the related databases and database servers

Environment: Oracle 8x, Oracle Forms / Reports 6i, Toad, PL/SQL

Client: Confidential, India May 2004 - Aug 2005
Oracle Developer
Contributed as an effective team member in the design and development of financial management system.Modified and implemented logical and physical models of the company on Finance and Accounts.

Responsibilities:

• Involved in database design and creation. Created triggers and PL/SQL procedures
• Responsible for backup and recovery, tuning and security. Responsibilities include implementation of security of data according to client\'s requirements by creating views
• Generated triggers for data integrity
• Involved in the development of technical and functional specifications
• Responsible for Installation of Oracle 8.0 and Oracle Products, Configuration and tuning of the system, backup and recovery, monitoring system performance
• Developed SQL Database scripts for tables, views, indexes, triggers, sequences and synonyms
• Create control files and loading data via SQL Loader
• Handled security issues concerning creating and administering roles, object and system privileges to users, user account creation and maintaining
• Providing functional inputs and database application design inputs to the programmers
• Giving Adhoc reports to business management team.
• Involved in Query Level Performance tuning using Explain Plans

Environment: Oracle 8.0, PL/SQL, SQL*PLUS, SQL*Loader, UNIX, Windows NT

Trainin

• Oracle Applications 11i, Influx Software solutions, Chicago, IL
• JAVA Basic, NIIT , Hyderabad , India

REFERENCES:

• Available on request