SUMMARY

• Around 6 years of strong experience in analysis, design, development and deploying Business solutions using Oracle Technologies, which includes 4+ years in Oracle Applications.
• Extensive experience in developing applications using tools like oracle Forms 6i, Oracle Reports 6i and Oracle database 10g/9i/8i, on Windows/Unix Environments.
• Adept at all stages of project lifecycle, from business requirements and technical definitions to development, testing, user acceptance testing (UAT), production support, and completion.
• Excellent skills in analyzing user requirements. Imparting design and ensuring the functionality.
• Experience with the following Oracle development tools like SQL Navigator or Toad, Oracle Workflow Builder, Oracle Reports, and Oracle Forms, Discoverer Reports, Interfaces, Conversions.
• Technical knowledge and experience with the following Oracle Modules:Order Management, Accounts Payables, Purchasing, Inventory, General Ledger, Accounts Receivable, Service Contracts, System Administration and Application Developer.
• Experience with Order to Cash and Procure to Pay cycles.
• Hands on experience on writing UNIX shell scripts.
• Experience in Importing Information into Oracle Apps from Legacy Systems.
• Strong Coding and Designing Experience in Oracle PL/SQL & SQL.
• Extensive experience in Oracle Back-end (server-side) PL/SQL Development i.e. Packages, Stored Procedures, Functions & Triggers using SQL Developer and Toad as development tools.
• Extensive experience in Creating and maintained Database Objects like Tables, Views, Materialized views, Indexes, Constraints, Sequence, Synonyms and Database Link.
• Extensive experience in Performance Tuning of SQL queries & Views using Explain Plan, SQL Trace & TKPROF utilities.
• A track record of maintaining and improving job skills through training, self-research and self-study
• Excellent communication, presentation and interpersonal skills.
• Ability to work individually as well as in a team with excellent problem solving and trouble-shooting capabilities.

WORKING PROFILE

• Worked for Confidential,Chennai as Oracle APPS Technical Consultant between March 2005 to February 2009.
• Worked for Confidential,Hyderabad as a Senior Oracle Developer between May 2003 and February 2005.

ACADEMIC PROFILE
M.Sc. Computer Science

CERTIFICATION
Oracle Certified Associate (OCA)

TECHNICAL SKILLS
& ERP : Oracle Apps 11.5.9(OM, PO, INV, AR, AP, GL)
& CRM : OKS
& RDBMS : Oracle 10g/9i/8i
& Front-end Tools : Forms 6i
& Reporting Tools : Reports 6i, Discoverer Reports
& Tools : SQL* Loader, TOAD, Workflow
& Languages : SQL, PL/SQL, C, C++, Visual Basic 6.0, Java
& Packages : MS-Office
& Operating Systems : MS-DOS, UNIX, Windows 2000, 2003 Servers, Windows 98, XP, and Vista

CAREER PROFILE

PROJECT #1: APOLLO
Client : Confidential,Australia
Duration : March 2007 – February 2009
Project Type : Supporting and Enhancement
Role : Oracle Apps Technical Consultant
Environment : Oracle Applications 11.5.9, Oracle9i, SQL, PL/SQL, Forms 6i,
Reports 6i, TOAD, UNIX, Workflow, Discoverer Reports, Alerts.
Description: This is the maintenance and support project, where the enhancements and customizations are taken care of by HTC, Offshore. The objective of the Apollo project is the effective business transformation of Canon to an efficient customer-focused organization, and includes the implementation of an integrated enterprise system.

Responsibilities:

• Prepared the Designed documents based on the Functional need of the clients.
• Handling the tasks right from freezing the requirements from the client, design, documentation, coding and UAT, that involves preparation of installation scripts.
• Involved in tuning of Discoverer Reports for better performance.
• Involved in creation of Concurrent programs and Value sets.
• Involved in Order to Cash and Procure to Pay cycles.
• Customized the RDF Reports like EDI Invoices Report, Meter Reading Exception report, Exception report for credit limit changes at customer level, a custom report which will generate the unfulfilled orders and automatically sends an email to the customers,
• Developed and customized various Discoverer reports like Sales Order Returns Download Report, Shipped Sales Report, Daily Sales Results Report etc.,
• Developed complex pl/sql packages like scheduling the sales orders automatically on the daily basis.
• Customized the different workflows like Quote Approval Workflow, PO Requisition Workflow, OM Order Line Workflow.
• Developed Alerts like Alert for Service Request Closed (Event Alert), Istore Alert Notification (Periodic Alert).

PROJECT #2: WDC (Western Digital Corporation)
Client : Confidential,Malaysia
Duration : March 2005 – February 2007
Project Type : Implementation
Role : Oracle Application Developer
Environment : Oracle Applications 11.5.9, SQL, PL/SQL, SQL Loader, TOAD, Reports 6i, Discoverer 4i, Interfaces, Alerts.
Description : Confidential,is world’s second largest hard disk manufacturing company having corporate office in US and factories in Thailand and Malaysia. This project involves the implementation of Oracle applications for the SCM and Financial modules.

Responsibilities:

• Preparing technical specifications and design using AIM methodology based on the functional specifications.
• Developing various interfaces, customizations and reports.
• Performing unit testing of the developed component in development and test instances.
• Preparing the installation scripts for the migration from the development to the production environment
• Providing support to the onsite team till the development goes live.
• Developed Conversions like Open PO Conversion, Onhand Qty Conversion, Material Transaction Interface, Item Conversion.
• Developed Interfaces like Journal Import Interface, Customer Interface.
• Developed Alert for Period opening (Event Alert).
• Customized the Move Order Pick Slip Report.

PROJECT #3: SRMT Development
Client : Confidential,
Duration : November 2004 – February 2005
Role : Senior Oracle Developer
Environment : Oracle9i, SQL, PL/SQL, Forms 6i, Reports 6i
Description: This project will have three modules called Marketing, Inventory and Production Planning and Control. This is the customized solution for the SRMT to meet their requirements. The current system of marketing module is responsible for selling the company’s finished products. The Marketing module includes the functions like production slip, order registration, order allotment, pack note generation, invoice, receipts, indents, credit notes and debit notes etc.
PPC module includes the main functions like conversion of marketing indent to production indent, generating production plan, work in process, batch creations, capturing production/inspection details, shift responsibilities and machine details etc.

Responsibilities:

• Extensively used PL/SQL tables, cursors and exception handling.
• Developed SQL scripts for data validation on User Entry screens.
• Prepared standard documents for the application based on ISO.
• Knowledge sharing sessions to the new team members.
• Used Forms 6i for creating forms to do data entry and various utilities.
• Enforced database integrity using primary keys and foreign keys.
• Prepared Impact analysis for change requests received from client.
• Tuning of SQL Statements using EXPLAIN PLAN, SQL-TRACE and TKPROF
  

PROJECT #4: VESSEL PERFORMANCE MONITORING SYSTEM
Client : Confidential,Mumbai
Duration : July 2004 – October 2004
Role : Senior Oracle Developer
Environment : Forms6i, Reports6i, Oracle9i, SQL* Loader, SQL, PL/SQL, Unix
Description: Confidential,Is a Premier Shipping And Offshore Service Provider From India. It is a Public Limited Company Engaged in the Shipping Business with interest in Marine Logistics Construction & Supply of Offshore Support Vessels. This system measures the performance of their own vessels so that the life and the productivity of the vessels can be increased.

Responsibilities:

• Created various Forms for entry screens and Reports using Forms 6i and Reports 6i.
• Developed many reports using Reports 6i to show audit related information.
• Prepared technical specification based on the functional specification.
• Developed Oracle Stored Procedures, Database triggers for automated data updates.
• Developed Unix shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
• Developed SQL scripts for data validation on User Entry screens.

PROJECT #5: TELE-GULF DIRECTORY MANAGEMENT SYSTEM
Client : Confidential,Bahrain
Duration : February 2004 – June 2004
Role : Oracle Developer
Environment : Oracle9i, PL/SQL, Forms 6i, Reports 6i, TOAD
Description: The system maintains the details of the different directories published by the Tele-Gulf Department. Sequence of event starting from entry of free listings till contract details and ends with invoice generation for each contact. All the entries are stored in a file (in ASCII format) and transferred to another system called QUARK Express, which is used for pagination of the input file, and the result is used for printing the directories.

Responsibilities:

• Customization of Existing Reports
• Development of New Reports
• Responsible for designing, developing, specification of test plans.
• Done effective requirement gathering for creating new reports.
• Developed materialized views for reporting purpose in Oracle 9i
• Developed PL/SQL Libraries, Packages, Sub Programs and Triggers
• Preparation of Technical Design Documents
• Used PLSQL Records, Collections (Nested Tables and Varrays) in complex backend packages.

PROJECT #6: MULTIQUEST BILLING PLATFORM (MQBP)
Client : Confidential,NY.
Duration : August 2003 -January 2004
Role : Oracle Developer
Environment : SQL, PL/SQL, SQL* Loader, Forms6i, Reports6i, Oracle8i.
Description: Confidential, is one of the US\'s largest insurers. The company\'s flagship insurance subsidiary is Metropolitan Life Insurance Company. MQBP application is developed for process of data related to insurance business of MetLife. It has three different schemes of insurance of individuals like Term Life Insurance, Universal Life Insurance and Variable Life Insurance where in the life insurance policy is tied up to the performance of the financial markets.

Responsibilities:

• Developed SQL scripts for data validation on User Entry screens.
• Developed control files using SQL* Loader for data transfers.
• Prepared Impact analysis for change requests received from client.
• Documented Tech Specs for the proposed data base design
• Conducted PL/SQL training session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning.
• Preparation of Unit Test Plans.
• Developed control files using SQL* Loader for data transfers.
• Created complex analytical reports using inline view, lexical parameters with Oracle Report 6i.
• Developed Oracle Stored Procedures, Database triggers for automated data updates.

PROJECT #7: AUTOMATION OF R.P.GUPTA MARKETING SERVICES
Client : Confidential,.
Duration : May 2003 –July 2003
Role : Oracle Developer
Environment : SQL, PL/SQL, Forms6i, Reports6i, Oracle8i.
Description: This system takes care of all the activities like party name details, Item details, Stock details, Payment details, Receipt details, brokerage item details, delivery item details and confirmation details and generate reports like account list, brokerage bill print, item list and user list etc.

Responsibilities:

• Created PL/SQL functions to facilitate business functions and calculations
• Writing scripts to create tables and views
• Developing PL/SQL procedures, packages, triggers, functions
• Developed and customized various forms and Reports using Oracle Forms / Reports 6i
• Worked on development design documents like functional documents and technical documents
• Preparation of Unit Test Plans.