SUMMARY

• 6.5 years of rich and varied experience in field of Oracle Apps(11i and R12) implementation and support projects
• Worked on multiple implementation covering Requirement Analysis, Setups, Functional Specification for Customizations, Testing, User Training and Post Implementation support
• Experience in Oracle EBS and its implementation like Up - gradation, Offshore support, Enhancements, Integration, Problem Solving, Trouble Shooting and Training
• Good Techno Functional experience in Inventory(complete Setup and Planning), HRMS, Advanced Pricing, TCA(Trading Community Architecture),GL, AP, AR, Purchasing and FA
• Strong working noledge of Oracle application Object Library (AOL) and System Administration (SYSADMIN).
• Extensive working experience in developing PL/SQL Package, Data Modeling, Database Triggers, Forms and Reports, Workflow Builder, XML Publisher/BI Publisher, Discoverer Reports, Performance Tuning and Form Personalization and OAF Personalization.
• Experienced in developing batch programs by using PL/SQL and Unix shell scripts and in using Export, Import and SQL*Loader Utilities for loading data from flat files into Oracle tables
• Tuned SQL queries using EXPLAIN PLAN, optimizer Hints and TKPROF utility, Indexes leading to significant improvement in system response time and efficiency.
• Used bulk binding techniques like BULK-COLLECT and FORALL
• Worked in Query tuning, Oracle Scheduler, Profiler, Explain plan and TKPROF.
• Development experience of ETL processes using custom PL/SQL.
• Strongworking noledgeof Microsoft Excel Database analysis tools, Data Validation,FTPutilities.
• Experienced in using the Ref-Cursors, PL/SQL Tables, Materialized Views, Table partitioning, Arrays, Indexes and Dynamic SQL's.
• Working Experience in Oracle Job Scheduling and Monitoring and Oracle Alerts
• Knowledge of JAVA and OAF.
• Working experience of Unit testing and UAT testing.
• Working noledge of preparing BRD, FDD, UAT, TechnicalDesign Document.
• Possess good analytical skills, Quick learner and is a great team player
• Knowledge of SDLC phases.
• Experience of leading team.

TECHNICAL SKILLS:

Application Technology: Oracle Applications R11i, R12, Inventory (INV) setup, HRMS, Purchase Order (PO)Order Management (OM - Order to Cash), SLA, Accounts Payable (AP)Accounts Receivable (AR),General Ledger (GL), Procure to Pay (P2P),HRMS

Database: Oracle 9i/10g

Reporting Tools: Oracle Reports 6i, Oracle Forms 6i/10g

Languages: SQL, PL/SQL,JAVA, Unix Shell Scripting

Tools: TOAD, SQL * Plus, SQL * Loader, XML Publisher/BI Publisher, Discoverer, SVNWorkflow builder

Office Tools: MS Word, Excel, Power Point, Visio

Operating System: Microsoft Windows

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Technology Analyst

Responsibilities:

• Extensively work experience on Oracle SQL, PL/SQL, SQL*Plus
• Form and OAF Personalization, Package creation and Performance Tuning
• Restructuring sql queries of views particularly where clauses and joins. Used explain plan, sql tracing and tkprof to examine access path and other activity generated by sql. Gather tables stats and applied optimizer hints as needed.
• Developing simple to complex sql queries based on users’ requirements. Utilizing Oracle’s Analytical functions.
• Extensively used dynamic sql and utilized bulk collections and direct path load to speed up certain data load process. Used Oracle specific feature such as ref cursor and analytic functions.
• Developed Custom report to display specific customer and customer account data using XML Publisher 10g as per the client’s template.
• Developed simplified innovative solutions for complex business process to eliminate waste in resource
• Written PL/SQL Stored Procedures, Functions and Packages to implement business rules into the application
• Created Setup documentation for Inventory.
• HRMS (Employee, Jobs, Position) data Setup.
• Created Periodic Alert when invoice get stuck.
• AME Approval Setup for Invoice.
• Define Price list and Define Advance Price Modifier (Advanced Pricing) to issue coupon or discount on particular item or category.

Confidential

Technology Analyst (Techno-Functional)

Environment: Oracle Applications Release 12.1.3 (AP, GL, AR, FA), PL/SQL, TOAD and XML/BI Publisher

Responsibilities:

• Extensively work experience on Oracle SQL, PL/SQL, SQL*Plus
• Developed many complex FA XML Publisher Reports
• Developed a complex custom XML/BI Publisher report on Fixed Asset Depreciation and also performed Unit testing and UAT testing, Data setup
• Customized a XML/BI Publisher Report to add company logo.
• Worked on Form Personalization, Package creation and Performance Tuning
• Form personalization on Invoice Form to disable DFF and in distribution window to mandate few DFF fields based on some condition and to show proper restriction message for both general and PO matched screen, Unit testing and data setup.
• Developed complex Pl/SQL packages on AP,AR module.
• Month end Activities on (AP,AR,GL)
• Worked on Procure-to-Pay (P2P) cycle for creation of requisitions, purchase orders and receipts. Created invoices in AP and finally posted the Payments into GL.
• Responsible in creating new suppliers.
• Developed Interface program for Customer data Migration.
• Developed UNIX shell scripts to perform a nightly refresh of the test system from Production instance.
• Developed custom supplier conversion program for doing supplier conversion in r12 from flat file to staging table and post validation staging table to interface tables. Also test the full flow of conversion and interface of supplier data.
• Developed Sales by Customer Ship-To Location report dat shows the sales information with corresponding order number, invoice number, Item number, and PO and customer ship-to location
• Written PL/SQL Stored Procedures, Functions and Packages to implement business rules into the application
• Created Setup documentation for FA
• Develop a tool using UNIX Shell scripts and Pl/Sql which will read the inventory set up data from data files and will insert data to the staging tables and post Validation will insert into Inventory base table. The tool was accepted at project level as well as organization level.
• Writing Unix Shell scripts for Inbound out bound programs.
• Involved in technical design, development and support for ‘Order to Cash’ and ‘Procure to Pay’ processes.
• Developed packages to validate and to load data from the staging table to interface tables related to Procure to Pay.
• Functional documentation for Configurations (Setups), User Training Documents and Customization Documents
• Engaged in Requirement gathering (BR-100), Solution Design (Process Documents), ‘UAT’
• Interaction with several other dependent teams for getting the data and the required info to get things going.
• Mentored my team as senior team member and took bottom up responsibility to build up a good repository for noledge documents and reusable documents which helped on timely delivery of the deliverables
• Customized OAF pages including Personalization’s and Extensions.

Confidential

Technology Analyst (PL/SQL Developer)

Environment: Oracle Applications Release 12.1.3 (INV, OM, PO, AP), Forms 10g and TOAD

Responsibilities:

• Worked on AP Custom Form using Oracle Form 10g
• Set up Training on Forms.
• Worked on Oracle SQL, PL/SQL, SQL*Plus (Package creation and Modification)
• Performed system-admin activities like creation, maintenance or users, creating responsibilities, menu maintenance and creation of requests.
• Worked on couple of performance tuning projects. Worked on query analysis, data gathering and analysis and work towards the solution of the performance issue.
• Responsible for analysis and reviewing of design document, test case document.
• Migrated several forms and reports from 6i to 10g
• Experience with complete Order to Cash cycle (Quoting, Order Management, Inventory, Advanced Pricing, Shipping Execution, Account Receivables, Account Payables and General Ledger) and Procure to pay cycle.

Confidential

Technology Analyst (PL/SQL Developer)

Environment: Oracle Applications Release 11.5.10 (PO, WIP, INV, BOM), Forms 6i, Repot 6i, PL/SQL, SQL * Loader and TOAD

Responsibilities:

• Worked on Oracle SQL, PL/SQL, SQL*Plus (Package creation and Modification)
• Worked on different types of temp tables, Advanced pl/sql, Exception handling.
• Responsibilities also include providing production support for all issues - standard and custom
• Timely communication with the end-user to understand their issues and fix it as per severity
• Performed system-admin activities like creation, maintenance or users, creating responsibilities, menu maintenance and creation of requests
• Interact with the on-site team for technical design and integration testing with detailed design documents and unit test plan
• Worked on Job Scheduling and Monitoring, Creating Alerts, Performance Tuning, Form Personalization.
• Month end setup.
• Developed Order Close or Cancel report
• Developed Interface of Sales Orders Import in OM after actively participating in the preparation of the conversion mapping documents.
• Developed a custom Form to Approve the Purchase Orders in Bulk. Also user can see all the related reference document details on clicking the Detail button. We have used folder functionality.
• KIT setup for Sales Order transactions.
• Full ATO process setup and testing
• Developed custom reports as per requirement using Oracle Reports 6i
• Used SQL*Loader for loading the data into the staging table, developed PL/SQL packages to validate and load into the interface tables
• Developed packages to validate and to load data from the staging table to interface tables Created setup document for Inventory, WIP and BOM.
• Set up training on Form Personalization, Oracle Apps and Pl/SQL
• Responsible for analysis and reviewing of design document, test case document.

Confidential

Senior System Engineer (PL/SQL Developer)

Environment: Oracle Applications Release 11.5.10.2 (INV and Customized modules), PL/SQL, SQL * Loader and TOAD

Responsibilities:

• Extensively worked on Oracle SQL, PL/SQL, SQL*Plus (Package creation and Modification)
• Worked on Inventory Setup
• Used SQL *Loader tool to transfer the data from Flat Files to the tables
• Responsibilities also include providing production support for all issues - standard and custom
• Took bottom up responsibility for offshore team.
• Developed Simplified innovative solutions for complex business process to eliminate waste in resources
• Extensively worked on Performance Tuning.
• Extensively used dynamic sql and utilized bulk collections and direct path load to speed up certain data load process. Used Oracle specific feature such as ref cursor and analytic functions

Confidential

Software Engineer (PL/SQL Developer)

Responsibilities:

• Extensively worked Developing Complex forms in WIP, WMS using Oracle Forms 6i.
• Worked on folder functionality in form.
• Developed Reports using Discoverer Tool
• Developed many Packages in BOM, WIP,PO and WMS
• Developed custom reports as per requirement using Oracle Reports 6i
• Extensively worked on Oracle SQL, PL/SQL, SQL*Plus (Package creation and Modification)
• Interact with the on-site team for technical design and integration testing with detailed design documents and unit test plan