SUMMARY

• Having 13+ years of experience as a Techno - Functional Consultant in EBS / Oracle Apps R12 / 11i - SCM (Order Management, Shipping, Inventory, and Purchasing), Financials (Accounts Receivables, Accounts Payables, General Ledger and Fixed Assets), Manufacturing (BOM, WIP) and CRM (Install Base, Service Contract & Depot Repair).
• Extensive experience in New Implementation projects, Oracle Apps Rollouts & Well-versed with all teh phases of Software Development Life Cycle (SDLC).
• Extensive Experience in Oracle Forms, Oracle Reports, XML reports, Discoverer reports using Oracle Forms 6i/ 9i, Oracle Report builder 6i / 9i, XML Publisher, Discoverer tool & Oracle 10g/11g technologies.
• Experience in 11i To R12 Upgrade process.
• Extensive experience on working on Business requirements analysis, review, definition and documentation.
• Experience in using Data Warehouse Administration Console (DAC) to schedule teh Informatica jobs and metadata management.
• Extensive experience in RevPro Recognition process.
• Expertise in design, development, and implementation of Business Intelligence applications including Business Analysis, Dimensional Modeling, Repository Management (RPD), Extraction Transformation and Load (ETL).
• Well experience in System Impact Analysis, Design, Systems Architectural Design, Interfaces Process Design, Functional Flow Design, Data Process Flow Designs & presentations.
• Experience in Business Process mappings for Integration project with interdependent modules and teams.
• Experience in Oracle Workflow processes & methodologies.
• Experience in designing and implementingOracle AlertsandLookups.
• Experience in Unix Shell scripting & Python scripting.
• Proven experience in project and team leading with extensive organizational and interpersonal skills. Equally comfortable working independently as well as in a team environment.
• Experience in oracle query tuning methods & tips for improving teh system performance.
• Excellent communicator with strong information analysis and continuous learning skills.
• Excellent troubleshooting, de-bugging and problem-solving skills.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, C, C++

ERP: Oracle Applications R12 / 11i (11.5.9 and 11.5.10)

DBMS: Oracle 8i/9i /10g / 11g

GUI: Oracle Forms 6i / 9i / 10g, OA Framework

Reporting Tools: Oracle Reports 6i / 9i / 10gand XML publisher, REVPRO 2.4/3.0 (ASC606)

Design/CASE Tools: MS Project

Operating Systems: Win 2003/XP/2000/NT/ 7, MS DOS

Others: Workflow, VSS, PVCS

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

Techno-Functional Consultant

Responsibilities:

• Preparing Technical Specification Documents as per teh business requirements.
• Preparation of MD50 & MD70 documents as per business requirements in Order Management (OM), Accounts Receivables (AR), General Ledger (GL), Install Base (IB) & Service Contracts (SC) modules.
• Involved in system gap analysis per teh requirements.
• Involved in development of Forms & Reports in OM, AR, IB & SC modules, modification of teh reports for teh column additions / deletions.
• Involved in 11i To R12 Upgrade E2E process.
• Involved in R12 table level changes for existing Objects like Reports, Programs in 11i.
• Involved in object changes related to R12 Version and creation of new logic and assignment.
• Identification of objects for R12 changes and modification to teh required reports, programs and removal of unwanted programs.
• Involved in R12 MOAC changes to AR reports for teh access to teh users to run teh required programs from single responsibility.
• Tuning of AR reports and sql programs to produce teh program outputs in a shorter way to biz for smooth month end process.
• R12 AR RX program parameter definition changes from SOB to Ledger level and Org wise data accuracy.
• DevelopedSQL scriptsin AR to create temporary tables and developedSQL*Loadercontrol files to load teh legacy data into teh temporary tables.
• Developed variousCustom reports, Customized existing reports(PO Purchase Order and Releases Detail Report, Purchase Requisition Status Report) according to teh functional specifications usingReports 6i and XML publisher.
• Modification of existing AR Lookups for teh new orgs added / decommissioned.
• Creation of new Triggers, Packages, Procedures, Functions, Concurrent Programs, Alerts, Request Sets using PL/SQL technologies.
• UsedFNDLOADto migrate Concurrent Programs, Lookups, Value sets, Request Groups & Data Definitions in Various Instances in AR Module.
• Involved in integration / modification of AR Reports, Personalization's & programs for Verizon IBX's acquired.
• Revenue Recognition process using REVPRO 2.4/3.0
• OM and AR Integration with REVPRO 2.4/3.0.
• Involved in changes related to 605 to ASC606 and modifications to teh existing programs for 606 compatibility.
• Involved in Water fall report layout changes for column additions and addition to teh new org's requirements criteria.
• Involved in Termination lines changes and subsequent program changes in Event collection and Contingencies release level.
• Involved in Summarize Data program performance tuning for teh long time running and glitches when running with Month end bill run process.
• Expert in designing and implementing for Data Warehouse.
• Hands on experience in ETL (Extraction, Transformation, and Loading) processes using Informatica Power Center 8.6/8.1/7.1/6.1.
• Expertise in design, development, and implementation of Business Intelligence applications including Business Analysis, Dimensional Modelling, Repository Management (RPD), Extraction Transformation and Load (ETL).
• Extensively used ETL processes to load data from flat files into teh target database by applying business logic on transformation mapping for inserting and updating records when loaded.
• Involved in new Sql reports / changes to teh existing reports for Business adhoc requests.
• Co-ordination & Interaction with different application stakeholders, cross functional teams per teh new requirements, changes and acceptance.
• Resolving teh Performance issues related Pl/Sql Packages, Procedures & Functions.
• SQL queries Tuning using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization.
• Developed 5 Day Reminder Notice program in AR for sending Email Notification to customers when payment due is 5 days for all regions - AMER, EMEA, APAC with respective to their language specifications.
• Implemented several custom logics for FormPersonalization in AR Transaction form.
• Involved in new scripts and modifications using python.
• Involved SQL Loader process for loading teh data from flat files for America, Europe & APAC regions for data validation needed by biz on a periodical intervals.
• Identifying teh data issues & fixing for teh existing programs in OM & AR modules raised by global users.
• Extensively involved inSQL tuning, troubleshooting, debuggingand fixing teh code and made teh changes according to teh new business requirements.
• Designed and developed customUSER APPROVAL WORKFLOWto meet teh client application’s user creation and maintenance per teh business requirement.
• DevelopedOrderStatusSummaryReport to provide teh status of orders in teh system for given time period.
• Involved in Monthly invoicing process and mid-month charges verification.
• Carry out Solution review, Design flows, testing, fixing of bugs, etc.
• Involved in new Materialized view creation and it’s maintenance for refreshing concurrent programs & monitoring teh data updates periodically.
• Involved in teh data extraction programs creation in IB & SC modules for identifying teh corrupted data and bugs in teh existing process for streamlining teh system behavior.
• Involved in SQL scripts creation and data extracts on a regular basis.
• Supporting QA, UAT and BAT Test Cycles.

Environment: Oracle Applications R12, Forms 9i, Reports 9i, HP-UX, Oracle 10g, REVPRO 2.4/3.0 (ASC606)

Confidential, San Jose, CA

Technical Consultant

Responsibilities:

• Preparation of MD50 & MD 70 documents as per business requirements.
• Identification of impacts on other modules per dis new / enhancement process implementation.
• Analyze Design and Develop new software and enhancement modules per teh business requirements in Order Management, Purchasing and Account Payables modules.
• Developed validation packages to Load data tointerface tables(OE HEADERS IFACE ALL, OE LINES IFACE ALL, OE CUSTOMER INFO IFACE ALL).
• Worked onAuto Invoice Interface Programto validate and load credit memos, debit memos and invoices from legacy system.
• Experience incustomizing oracle workflowssuch as teh PO approval process, Order/Line Flow to send user notifications based on teh business requirement.
• Validatedthe data and populated thePayablesinterface table through aConcurrentprogram which in turnsubmitsa standardPayablesInterface program in AP.
• Developed various crucial financial analysis reports (for all modules) forAP/OM/PO usingOracle Discoverer 10g.
• Involved in Form personalization in OM, PO modules.
• Co-ordination & Interaction with different application stakeholders, cross functional teams per teh new requirement changes and acceptance.
• Design and development database Tables, Triggers, Database Triggers, Cursors, Procedures, Stored Procedures and Functions.
• Development of Oracle Forms, Oracle Reports, XML Publisher and Discoverer reports in purchasing modules.
• Involved in Adaptive planning process which includes programs development certain reports and running through SOA process.
• Involved in oracle workflow process changes and impact analysis to teh existing system.
• Involved in Production support issues raised by business.
• Supporting QA, UAT and BAT Test Cycles.

Environment: Oracle Applications R12, Forms 9i, Reports 9i HP-UX, Oracle 10g / 11g

Confidential

Technical Consultant

Responsibilities:

• Preparing Technical specification documents as per teh functional requirements in teh OM, PO, AP modules.
• Analyze Design and Develop new software and enhancement modules per teh business requirements.
• Design and development database Tables, Triggers, Database Triggers, Cursors, Procedures, Stored Procedures, Functions, Forms, and Reports.
• Involved in new, changed and completed sales orders import from legacy system to oracle usingorder import (order management open interface).
• Involved in development and enhancement to teh concurrent programs and report in Accounts Receivable, Install Base & Service Contracts modules.
• Involved inCustomer Conversionsto load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables usingTCA APIs.
• Developed variousRDF reports, Customized existing reportsin PO module - PO Purchase Order and Releases Detail Report, Purchase Requisition Status Report according to teh functional specifications usingReports 6i /9i.
• Carry out Design review and code review, testing, fixing of bugs etc.
• Changes to teh existing workflow processes.
• Involved in understanding different servers data process & flows used across Confidential for teh data received.
• Co-ordination &Interaction with different application stakeholders, cross functional teams per teh issues raised.
• Managing and supporting teh Cross vendor teams/tracks for resolving teh inter-dependency issues in teh day-day activities.
• Supporting in Month End (ME) and Quarter End (QE), Year End (YE) closing activities.
• Involved in DU jobs performance, enabling / disabling activities & analysis for teh job aborting causes.
• Resolving Production support issues / bugs raised by teh business with-in a stipulated timeframes.
• Supporting teh issues related to teh data mismatches / discrepancy from teh cross flow streams on a priority basis.

Environment: Oracle Applications R12, Forms 9i, Reports 9i, HP-UX, Oracle 10g / 11g

Confidential, Sunnyvale, CA

Technical Consultant

Responsibilities:

• Preparing Technical& Functional Specification Documents as per teh business requirements.
• Involved in analysis, requirement gathering and design using MD70 documents.
• Involved in system analysis per teh requirements.
• Impact analysis in Order Management - SFDC integration for teh gap and solution as per teh business requirements.
• Involved in development of reports in Order Management (OM), Purchasing (PO), Accounts Payables (AP), Accounts Receivables (AR), Install Base (IB) & Service Contracts (SC) modules.
• Involved in Adaptive planning process which includes programs development certain reports and running through SOA process.
• Involved in Depot repair process for service depot repair functions, Repair Order creation, status monitoring, receiving, and shipping of teh products repaired.
• Involved in Orders track activities on customer or vendor items returned to service depot repair, for repair, upgrade.
• Development of discoverer, XML Publisher reports & Interfaces per teh requirement in OM, PO modules.
• Involved in new / updating teh oracle workflow processes.
• Creation of new Triggers, Packages, Procedures, Functions, Concurrent Programs, Forms, reports, Alerts, Request Sets, Notifications setup.
• Tax data verification & uploading process on a monthly basis.
• Resolving Production support issues / bugs raised by teh business.
• Resolving teh issues related to teh Customer billing invoices on a priority basis.

Environment: Oracle Applications R12, Forms 9i, Reports 9i, HP-UX, Oracle 10g

Confidential, San Jose, CA

IT Analyst

Responsibilities:

• Preparing Functional Specification Documents as per teh business requirements.
• Impact analysis on OTC / QTC areas in Order Management, Receivables for teh gap and solution as per teh business requirements.
• Involved in impact analysis discussions on Oracle Trading Community Architecture (TCA) for teh scopes impacted.
• Analyzing and identifying teh impacts at Order Management side for dis new process implementation.
• Involved in analysis, requirement gathering and design using MD70 documents.
• Involved in Post analysis for teh functional mappings.
• Creation of new Triggers, Packages, Procedures, Functions, Concurrent Programs, Forms,
• Reports, Interfaces as per teh requirement.
• Unit Testing & Test Cycle support.

Environment: Oracle Applications 11i, Forms 6i, Reports 6i, HP-UX, Oracle 9i/10g

Confidential

IT Analyst

Responsibilities:

• Preparing Functional Specification Documents as per teh business requirements.
• Involved in gap analysis for teh business requirements and identification of teh custom
• Identifying impacts to GL & AR Modules for teh new introduction tool Revenue Accounting Engine (RAE).
• Analyzing and identifying teh impacts on other modules for dis new process implementation.
• Impact analysis on Oracle Trading Community Architecture (TCA) discussions for teh dis new application introduction.
• Involved in system impact analysis per teh business requirements.
• Creation of new Triggers, Packages, Procedures, Functions, Concurrent Programs, Forms, Reports, Interfaces as per teh requirement.
• Test Cycle support.

Environment: Oracle Applications 11i, Forms 6i, Reports 6i, HP-UX, Oracle 9i/10g

Confidential

IT Analyst

Responsibilities:

• Preparing Functional Specification Documents (FSD) as per teh BRD requirements.
• Identifying impacts to GL Modules for teh new operating unit Confidential -UKH.
• Impact analysis on OTC areas in Receivables for teh gap and solution as per teh business requirements.
• Involved Oracle Trading Community Architecture (TCA) analysis discussions for teh new UKH operating unit introduction.
• Analyzing and identifying teh impacts on other modules for dis Confidential -UKH operating unit.
• Involved in analysis, requirement gathering and design using MD70 documents.
• Creation of new Triggers, Packages, Procedures, Functions, Concurrent Programs, Forms, Reports, Interfaces as per teh requirement.
• Tracking teh issues in teh PROPEL tool for teh new enhancements required for teh business.

Environment: Oracle Applications 11i, Forms 6i, Reports 6i, HP-UX, Oracle 9i/10g

Confidential

IT Analyst

Responsibilities:

• Conduct Impact analysis in teh POC fast track in AR module
• Providing solutions to teh analyzed products & service line track
• Changes required to teh AR modules related issues.
• Preparing teh functional specifications as per teh BRD provided.

Environment: Oracle Applications 11i, Forms 6i, Reports 6i, HP-UX, Oracle 9i/10g