Objective
Work in a challenging, motivating and friendly environment which would give opportunities to learn, share knowledge and grow professionally.

Summary

• Oracle Certified Programmer with 5+ years of experience providing Application, Database and Reporting solutions to clients.
• Experience in all phases of Software development Life Cycle (SDLC) with Expertise in Oracle forms and reports, PL/SQL and JAVA.
• Extensively worked on Oracle Forms and Reports versions 4.5, 6i and 10g.
• Four years experience in Oracle Database versions 7.3.2, 8i and 10g, RDBMS and Programming concepts.
• Extensive experience in writing SQL, advanced PL/SQL, stored procedures, triggers, functions, creating tables, indexes, views and Unix shell scripts.
• Gathered Business requirements by interacting with the business users.
• Performed gap analysis and feasibility study for the given requirement.
• Extensively used SQL Tuning to improve performance.
• Knowledge on the Oracle Apps features like OID, SSO, SID, RAD entries.
• Extensive experience using Oracle, Teradata, PL/SQL, Toad, SQL Assistant.
• Hands on experience on Oracle Business Intelligence Tool ( OBIEE ), Business Objects and Crystal Reports.
• Has used Clear Quest and Clear Case – IBM tools for Document Management.
• Conducted and implemented two \'Lean Projects\'.

Education
Bachelor of Engineering in Computer Science & Engineering,

Technical/Business Skills

OBIEE 10.1.3.3.2, 10.1.3.4 / Siebel Analytics and BO

Database :

Oracle 7, 8i and 10g, SQL Server 2005

Operating Systems:

UNIX (Sun Solaris and IBM-AIX), Windows XP/2003

Languages (3G/4G):

PL/SQL, Shell Scripting, D2K (Oracle forms and reports versions 4.5, 6i and 10g), Java, VB .NET 2003, C and C++.

Work History
Company: Confidential July \'08 – Feb \'09
Client: National Grid, UK
Role: Module Lead
Outcome of a \'Lean Project\' conducted to cut down on the manual effort involved by automating the process of creation of Main pipe replacement and Purge and Re-light jobs.

Duties and Responsibilities:

• A Key member of the Lean Study.
• Identify the applications impacted due to automation.
• Come up with a blue print of the automated process.
• Identify the re-useable procedures, functions and triggers.
• Preparation of project delivery documents like ADR, TDR, System Test plan, EOD reports, AHD and PhD\'s.
• Drive the project to meet its goals by coordinating with various teams and conducting brain storm sessions.
• Perform D2K changes ( Version 6i ) to the EWMS application.
• Design the database changes to meet the requirement.
• Co-ordinate and track the project through different phases and report to higher management when required.
• Point of contact for the project for Business and other teams involved like JCAPS and EBMS teams.
• Track the progress of the project by conduction Weekly team meetings.
• Updating the Business by sending across EOD report during testing phase ( ST ) with statistics on the number of test cases carried out, bugs identified and fix. Results of regression testing.
• Come up with the Implementation plan and a dry run with all the team members involved on Fix on Fail environments.
• Scheduling the batches on the ECS ( Electronic Controlling Scheduler )
• Implement the changes by providing Post Implementation support.

Environments: Unix, Oracle forms 6i, PL/SQL, Oracle database versions 7.3.2 and 8i, JCAPS, Clear Case and Clear Quest and Batch Processing.

Company: Confidential Feb \'08 – June \'08
Client: National Grid, UK
Role: Business Analyst and PL/SQL Developer
An Xoserve ( 3rd party to National Grid ) driven project. As part of \'FOMSA\' exit, Xoserve ( earlier part of National Grid ) was not suppose to use National Grid\'s systems by July \'09. In order to facilitate Xoserve with the information required to go ahead with daily business. National Grid was supposed to send across data to Xoserve in an agreed format which would be either accepted or rejected by Xoserve.
The rejects records had to be handled at National Grids end and resent by checking the Error code received. The data send across was required to handle an new / change in load requested by Suppliers.

Duties and Responsibilities:

• Involved in coming up with fields required by Xoserve for National Grids application.
• Come up the interface design to sent across the information to Xoserve in the agreed format and to handle the rejects sent back.
• Identification of scenarios when a rejection could be raised.
• Identify the application level changes, database fields which map to the fields on the application and fields which need to be pre-populated in a format acceptable by Xoserve to avoid rejects.
• Design and build the interface – Extraction interface and Rejection interface.
• Preparation of project delivery documents like ADR, TDR, System Test plan, EOD reports, AHD and PhD\'s.
• Made modifications to the existing National Grid application on Oracle Forms 10g, in addition to developing a new report using Oracle Reports 10g to meet the requirements.
• Use of UTIL_FILE feature of UNIX to populate the data extracted into a flat file with desired extension and extensive use of exception feature of Oracle.
• Creation of tables and procedures to handle the requirements.
• Modification of FTCS script to sent across the flat file to Xoserve.
• Creation and execution of Unit and System test cases to test the interface and the FTCS process.
• Implement the changes to interface by scheduling the batch details on the ECS and deploying the changes to the application on the Application Server ( Both on Production and Contingency Servers )
• Provide Post implementation support and passing on the knowledge to the Application Support.

Environments: Unix, PL/SQL, Shell Scripts, Oracle Forms 10g, batch scheduling and FTCS settings.

Company: Confidential Oct \'07 – Feb \'08
Client: National Grid, UK
Role: Business Analyst and PL/SQL developer
ERP phase - I aimed at providing ERP solutions to a few identified applications as part of release I. Quotations Application was one such application which was identified and moved into the ERP solution. From the day the ERP would go live, all new connections would be raised in the new ERP solution. However for the live jobs / connections created before the date live date, the details of all such live jobs / connections had to sent across to SAP on a regular basis for Supplier billing purpose. The plan was to build an interface which would sent across the details to SAP on a regular basis on an agreed format. JCAPS was used to exchange the information between the two systems.

Duties and Responsibilities:

• Come up with the fields required by SAP for billing purpose based on the method of payment.
• Identify the database fields which need to be sent across.
• Design the interface to send across the data to SAP in a format acceptable by JCAPS and creation of the \' Sales Order Number\' on source system.
• Preparation of project delivery documents.
• Creation of tables and procedures to handle the requirements.
• Provide the inbound and outbound details to the JCAPS team for JCAPS to pick up the flat file created.
• Creation and execution of Unit and System test cases to test the interface developed with the JCAPS team.
• Provided UAT support to Business.
• Implement and provide PIS.

Environments: Unix, PL/SQL, shell scripts, JCAPS and Batch Scheduling.

Company: Confidential Jan \'06 – Feb \'07
Client: National Grid, UK
Role: Oracle developer and tester
Migration of Servers from Sun Solaris to IBM AIX server involving server slicing to reduce server maintenance cost and to migrate the applications involved from 4.5 to 10g. In addition to adding a new interface between Quotation System and STORMS using Pro* C and JAVA.

Duties and Responsibilities:

• Providing inputs for creating the ADR and TDR for the new requirements to be added to the Quotation Systems.
• Make code changes to the impacted code in the Quotation System which is in Oracle Forms 4.5.
• Develop a new report used for reporting purpose to meet the Business requirements.
• Develop the JAVA code which would interact with the third party GB Accelerator tool to fetch the data required using Java Beans.
• Preparation and execution of System test cases.
• Assist the Module Lead in coming up with the Bug report by providing the details of the bug identified along with the screen shots.
• Taken KT from the Team who had make changes to the Application Server ( IBM AIX server ) to meet the new requirements by adding a new security page, addition of new users to Oracle Internet Directory, SSO and RAD creations on Apps Server.
• Provided support during Post Implementation from Offshore.

Environments: Unix IBM AIX servers (App Servers), OC4J instance – forms engine and reports engine, Core JAVA, Pro*C, Oracle forms and reports 4.5 and 10g, PL/SQL, shell scripts.

Company: Confidential Nov \'05 – Jun \'06
Project Title: Project Score Card using the Salvin Pinto Analysis
Role: Developer
Development of a Project Management tool which would facilitate the Project team to asses their current state of the Project using the Salvin Pinto Analysis as Green, Yellow and Amber. The tool was based on Failure Mode Effective Analysis (FMEA ).

Duties and Responsibilities:

• Learn the new Velocity Technology which used the Velocity Template Language.
• Understand the FMEA methodology.
• Understand the methodologies involved in the development of a Project.
• Come up with an E-R diagram and database design.
• Develop the tool by taking the Project Managers inputs.
• Give a presentation on the tool developed to senior management at Novell.