Primary Skills
Oracle 11i(ERP/CRM) 11.5.10,Oracle 10g,Developer 6i,Developer Suite 9i/10g,Designer 6i,Discoverer 4i,workflow 2.6,TOAD,SQL,PL/SQL,Unix

Location
US-CA-San Jose (will consider relocating)

Professional Summary:
• Over Ten years of experience in Oracle RDBMS and Oracle Applications :
Implementation, Interfaces Design, Customizing the modules, Data Conversion from legacy systems into Oracle Applications and Application Software Development in Oracle
• Extensive knowledge in all phases of Software Development Life Cycle, systems development methodologies and Oracle Applications Implementation Life Cycle.
• Can effectively work as an individual contributor or a team member.
• Expertise in Functional and Technical aspects of Oracle applications11i manufacturing (OM), CRM (Install Base, Service Contracts, TCA/HZ).
Areas of Focus:
Functional / Consulting
• Translating business requirements to technical specifications (FDD/TDD), Fit/Gap Analysis
• Data Conversion/Mapping - Preparing conversion/mapping documents (CV) and Data Cleansing
• Interfaces/Extensions - Preparing Customization/Extension documents (MD)
• Project Deliverables- Design Specifications, Plans, Strategies and Implementation Procedures like AIM (BP, BR, TE etc),Post Production support.

Technical
• Analysis and Design -- Process Modeling, Data Modeling/logical database design (ERWIN), Data Analysis/Mining, and Module Design.
• Development of Oracle CRM/ERP Applications-- (RCE/RICE/RICEW) Reports, Interfaces, Customizations, Extensions, Conversion, tuning, PL/SQL API, Workflow customization, ETL/DSS/OLAP.
• Good Working Knowledge in System Administration, Data Synchronization (FNDLOAD) and AOL (profiles, menus, Concurrent Programs, responsibilities, valuesets etc).
• Design and Development of database objects -- tables, materialized views, triggers, procedures, functions and Packages.
• Knowledge of Jdeveloper 10g

Tools and Methodologies:
Software: Oracle 11i (11.5.10.2), Forms/Reports 6i,Developer Suite 9i (Forms 9i, Reports 9i), Designer 9i, Oracle BI, Discoverer 10g, PL/SQL, ERWIN, SQL*Loader, Export/Import, SQL*Plus, TOAD, SQL Navigator, Oracle AQ, APEX, PVCS, Kintana .
Databases: Oracle 9i/10g/11g
Platforms: Windows XP, UNIX (Sun Solaris, Sco-Unix, HP-Unix, AIX, Linux)
Industries: Financials, Manufacturing, Insurance .


Professional Experience:
Confidential,San Jose, CA October \'06 to Till Date
Environments : Oracle 11i( Service Contracts, Install Base)
Interface Tools : SQL+, PL/ SQL, Reports 6i
Involved in design and development of Interfaces/extensions for Quoting, TCA, INV, Customer Online and CRM Foundation with extensive usage of PL/SQL, Business Events, HTML DB and Workflow.

Responsibilities include:
• Worked on Service Contracts and Install base conversions involving data import from different legacy source systems into Oracle 11i.
• Migrated reports from Reports 6i to BI Publisher
• Involved in customer data mapping, data conversions from legacy to Service Contracts (OKS) and Installbase (CSI).
• Prepared Technical (TDD), Functional documents (FDD), Unit Test Case, and Unit Test review documents.
• Created Inbound Interfaces to update AR, Install base and service contracts with validation of Business rules
• Developed Custom Forms (Property Appraisal etc) and custom reports using Developer 6i
• Developed test plan and test cases for Change Requests (CR), supported system testing to ensure success.
• Migrated all the existing custom.pll work to Forms Personalization.
• Prepared BR30, BR100 (DFF mapping), MD30, MD50 and MD70 documents
• Involved in data cleansing of customer data from legacy to TCA tables.
Oracle CRM Implementation: Being a member of production support group, I managed Application Security, Concurrent Programs, Reports and Profile Options, I also created and automated Migration Interface Management program to upload data from legacy system into Oracle Applications using shell script, SQL, PL/SQL packages, procedures, functions and triggers.
Responsibilities include:
• Loading data from legacy systems to OSO, OMO, Telesales, HRMS and TCA tables through Concurrent Programs
• Customized Sales Methodology Workflow as per customer\'s requirement
• Modifying Migration Interface Management
• Dealing with Data Quality, Data Presentation and Data Massaging
• Developed, tested and implemented the configurable components (SIT, EIT etc) of the HR modules.
• Defined grades, grade rates, pay scales, scale rates and related grades to progression points. Wrote elements, input values, and links and activated predefined elements.
• Handling CR(Change Requests) by modifying PL/SQL APIs,Java, jsp files
• Fixing Tickets(provided quick analysis and resolution for production issues),Preparing TARs for out of box functionality bugs
• Preparing back out procedures, Tuning customizations
• Preparing test scripts, test plans
• Preparing set-up document and post implementation support.
• Worked on CRM foundation and TCA to set up resources and sales groups
• Database Schema design for Sales Methodology using Oracle Designer 6i and Forms 6i
• Prepared high-level design and detail-level design documents .
• Developed asynchronous Business workflows for Sales Methodology using Oracle Workflow 2.6
• Release Management - Building consolidated patches, Minipacks, Install/Testing these patches On Test, Maintenance and Development Environments internally by using AD utilities.
• Created SQL scripts for Data Migration.
• Developed Business workflows for Email Center and 1-1 Fulfillment using Oracle Workflow 2.5.
• PL/SQL APIs for Structured inbound Email Workflow
• Involved in Unit testing and integration testing during internal implementation of 11.5.4 and 11.5.6 versions.

Confidential,San Jose ,CA April 2006 – September 2006
Environment : Oracle 11.5.10 Order Management, Inventory ,Shipping
Interface Tools : SQL+, PL/ SQL, Reports 6i
Role : Technical Consultant

• Involved in the upgradation of Oracle Apps 10.7 to 11i .The project involves Data migration, developing custom applications, Production Support, manage tickets and resolving customer issues according to the severity level. Preparing and completing the new Enhancement Requests (CR) according to the user requirements.

Responsibilities include:

• Designed and developed various reports in Oracle Shipping and Order Management modules(Pick slip, Pack Slip etc) based on client\'s requirements.
• Registered Forms and Reports in AOL and Sys admin for respective modules.
• Interacted with end users and implemented their requirements into the program specifications.
• Performed data conversion using SQL*Loader and PL/SQL to load data into the Interface tables in Oracle Applications.
• Prepared the installation document for the implementation of these reports.
• Developed several reports in 6i and SQL PLUS and registered in AOL.
• Performed data translation, transformation or manipulation before moving the data to the production tables.
• Prepared the technical design document for the above reports .
• Version controlling is done using CVS.
• Deployment through Kintana .

Confidential,India January 2004-April 2006
Interface Tools: SQL+, PL/ SQL, Reports 6i/9i, Forms 6i/9i
Domain : Insurance
Role : Team Lead/Programmer

Responsibilities include :

• Involved in the design and development ,testing of delivering the modules.
• Understand the functional documents and come up with technical solutions.
• Lead a team
• Provided technical solutions.
• Enhancement in some of the modules like Bank Reconciliation Master forms like employee master, Let-out property master, Deposit master, Transaction forms like Cheque Printing, Bulk Processing (Pay Batch) , TDS Certificate Generation & Printing , Cheque Dishonor, TA, LTA, Claim Payments/Receipts , Pay slip Generation Process, Monthly Process
• Developed Back end procedures, functions and packages, triggers using SQL, PL/SQL
• Used Bulk Collect, Ref cursors
• Support to the team members in resolving the issues .
• Support to the client
• Generated various GL Oracle Reports in 9i .
• Developed reports using backend packages.

Confidential,November 2000-January 2004
Interface Tools: SQL+, PL/ SQL, Reports 2.5/6i, Forms 2.5/6i
Role : Developer /Programmer/Data Modeller

Involved in the analysis ,testing ,development ,testing and deployment of the projects .The project were developed in Oracle 7.3 with forms 4.5/reports 2.5 .Involved in the migration of the modules from
Oracle 7.3 to Oracle 9i environment with Forms 4.5 /Reports 2.5 to Forms 6i/Reports 6i.
Responsibilities include:

• Developed various forms and transaction reports in Forms/4.5/6i and Reports 2.5/6i
• Performed user requirement analysis and developed data models with ERWIN.
• Database tables, triggers, form level triggers, procedures, functions and packages were created and prepared.
• Various screens were designed as per the standard templates with forms 4.5/6i.
• Tuned SQL queries using explain plan/hints for improving performance of the system.
• Applications were tuned using Explain Plan and SQL Trace.
• Optimized the application database by encapsulating procedures and functions in a package.
• Tested modules and fixed bugs.
• Created unit test and integrity test plans and test cases, executed test cases and documented the test results.
• Prepared user documentation.