SUMMARY:

• SeniorTechno - FunctionalConsultant/Solution Architect/Business Analyst with overall 15 Years of IT experience including 13 years of Oracle EBS 11i/R12 implementation, upgrade and support experience.
• Strong experience asFunctionalConsultant/Lead inOracleApplications implementation, customization, design, enhancement and upgrade ofOracleApplications R12/11i Supply Chain modules (Order Management, Shipping Execution, Pricing, Inventory, Purchasing, iProcurement, iSupplier, Receiving, BOM, WIP), CRM (Install Base, Service Contracts, Subscriptions, Warranty) and also AR, AP, GL, FA, EBS Tax

WORK EXPERIENCE:

Sr. Principal Consultant

Confidential, Sunnyvale CA

Responsibilities:

• Worked as Techno-functional lead consultant to support the existing oracle EBS OTC Processes.
• Design of functional solutions for all the enhancements as part of Month End Close (MEC) project
• Design and development of oracle EBS Forms/SQL/PLSQL objects and reports for Aurora project.
• Design and development of recast reports using oracle SQL/PLSQL for quarter end close activities
• Worked using Agile project methodologies.

Environment: OracleApplications R12.1.3 - Oracle Service Contracts OKS, AR, GL, INV, Oracle 11g/12c SQL, PL/SQL, SFDC, TOAD 9.7,ITG (Kintana), Jira for ticket tracking system, Tortoise SVN for version control

Sr. Consultant

Confidential, Seattle WA

Responsibilities:

• Worked as Supply Chain FunctionalLead during my engagement with this esteem client to build GPT (Global Performance Tool) as part of OracleApplications R12(12.2.4) implementation
• Responsibilities include requirement gathering, gap analysis, application design, configuration, test scripts generation, writing guides and technical support
• Responsible for creatingfunctionalspecification docs for Interfaces, conversions and reports.
• Interacting with users to understand requirements and configureoracleapplications accordingly. Also responsible for designing conversions and custom programs
• Responsible for setting up Order management, Shipping, and Inventory Modules and design interface programs to facilitate transactions between oracle and 3PL tools
• Designed and developed GL transactions automation using data from 3PL.
• Worked with users to resolve the issues pertaining to period end closing
• Responsible for user, support for users through CRP and UAT and production support.

Environment: Oracle ApplicationsR12.2.4 - Oracle INV, SYSADMIN, AOL, HRMS, BOM, WIP, OM, PO, AR, AP, ASCP, OPM, BRM, WMS, Oracle 10g/11g SQL, PL/SQL, TOAD 9.7,ITG (Kintana), Oracle UPK and MS Tools Supply Chain

Solution Architect

Confidential

Responsibilities:

• Panasonic Avionics Corporation (PAC) designs, engineers, manufactures, sells and installs customized in-flight entertainment and communications solutions to airlines worldwide. PAC implementedOracleApplications R12 to integrated Supply Chain and finance system
• Responsibilities include requirement gathering, gap analysis, application design, configuration, test scripts generation and writing guides and createdfunctionalspecification documents for Interfaces and reports
• Responsible for interacting with users to understand requirements and configureoracleapplications accordingly. Also responsible for designing conversions and custom programs
• Setup of DFF’s, inventory organizations, shipping networks in oracle inventory, pricelists, modifiers, price breaks in oracle advance pricing.
• Partnered with business users for gathering requirements, analyze, design and test of below customization/enhancement projects;
• Interface program to update inventory item attributes for different inventory organizations
• Interface program to update ‘Latest Acceptable Date’ on sales order lines in oracle order management (OM)
• Interface program to Apply credit check hold on all the customer orders
• Restricting drop-ship order (in OM) details update on related purchase orders (in PO)
• ENCORE Item import interface
• Processing requisitions and purchase orders using iProcurement
• Responsible for user and support for users through CRP and UAT sessions, designing enhancement and customization of ASCP objects and production support activities.
• Environment:OracleApplications 12.1.3 (Order Management, Shipping Execution, Purchasing, Inventory, BOM, WIP, iProcurement, ASCP)Sr. Solution ArchitectWarner Bros. - Burbank, CA Aug ’12 - Jul ’13
• Responsibilities include requirement gathering, gap analysis, application design, configuration, test scripts generation and writing guides
• Responsible for creatingfunctionalspecification documents for Interfaces and reports
• Analysis of under lying architecture of WB contract process cycle from creation to invoicing (billing) customers
• Led and managed a small team of technical developers along with design and build new business process solutions, interaction and coordination with WB cross functional teams and business users on production issues/fixes (Remedy tickets) on daily basis. Testing of end-to-end business process flows after deployment of fixes
• Designed integration process flows between Licensing application (LMSI), B2B (SQL Server), Oracle Custom Module (OCM) and Oracle AR/GL, stored procedures in MS SQL Server to check contract health before amendment to new contract. Testing of custom programs developed using PLSQL and reports in TEST/UAT environments
• Also responsible for user and support for users through CRP and UAT sessions and production support.

Environment: Oracle Applications11i/R12 - Oracle AR, GL, SYSADMIN, AOL, Oracle 10g/11g SQL, PL/SQL, TOAD 9.7,Quality Central 11.0.0, BMC Remedy 7.6, MS Tools, SQL Server 2005Supply Chain

Functional Consultant

Confidential

Responsibilities:

• Responsibilities include requirement gathering, gap analysis, application design, configuration, test scripts generation and writing guides
• Responsible for creatingfunctionalspecification documents for conversions and reports
• Responsible for project activities like placement of manual orders using HTTP Test Tool, tracking of web services of Order processing using Xi Admin, verify the working of BPEL services which are part of order processing from different sources, PO setups for items utilized in Drop-Ship order processing, configuration inventory items, inventory organizations, sub-inventories and shipping networks for IR/ISO and Setup of transaction types in oracle order management
• Functional testing of test cases for O2C and P2P cycles and iProcurement, tracking of O2C and P2P test case results using Silk Central Application, logging defects for failed test cases, taking care of RFCs and SRs using My Oracle Support (MOS) for Oracle on Demand team
• Development of ad-hoc SQL scripts and testing custom PLSQL programs, user manuals, CEMLI documents for third party applications for OOD implementation including SYSADMIN and AOL activities.
• Responsible for user and support for users through CRP and UAT sessions and production support

Environment: Oracle Applications11i - AR, GL, AP, OM, INV, PO, SYSADMIN, iProcurement, UNIX Shell Scripting, Oracle 10g SQL, PL/SQL, TOAD 9.7,BPEL 10g, Seibel 8.0, BRM, PIM, Xi Admin 1.0, HTTP Test Tool 5.1.1, Silk Central 11.0.0, BMC Remedy 7.6, MS Tools

FunctionalLead

Confidential, Mountain View CA

Responsibilities:

• Project scope included data conversions, interfaces, personalization and reports.
• Involved in Setup update in modules OKS, OM, INV, AR according to the new business process.
• Setup of new pricelists, modifiers, qualifiers and price breaks in advance pricing
• End-to-End testing and verification of service contracts import from legacy system
• Tested end-to-end processes of SHS migrations between Oracle Sales Orders, Oracle Service Contracts and verification of billing information/data in AR
• Setup of required lookups to process sales orders, service contracts to Oracle EBS from legacy system responsible to coordinate with cross functional teams and integration teams to process the orders and service contracts seamlessly into Oracle EBS
• Worked on gathering business requirements and gap analysis. Preparedfunctionalspecification documents for conversions, reports and customizations
• Gathered data conversions requirements. Planned and implemented data conversion methodology and programs to bring Suppliers, customers, Items, Item Categories, and service contracts interfaces and conversions from legacy system intoOracleapplication
• Provided user and support for users through CRP and UAT sessions
• Created TE-040 document to provide test scenarios and steps that needs to be tested in CRP/UAT
• Responsible for post Go-live production support and enhancements
• Analyzing and understanding of underlying architecture processing revenue recognitions using REVPRO application tool.
• Development of Materialized views, views to extract the data from OE and OKS of oracle EBS, PLSQL programs required for business data processing and interfacing to Oracle GL of Oracle EBS, customization of Pre and Post data processing programs, built of SQL queries to build REVPRO dash board reports
• Exposure to Boomi (Cloud Computing) Technology to build integrating process between NetSuite and Oracle EBS
• Responsible for SYSADMIN activities like Defining of Executable, Concurrent Programs, Value Set, and customization of UIs (user interfaces) and reports using Oracle APEX and documentation of technical design and set up documents

Techno-Functional Consultant

Confidential, San Jose CA

Responsibilities:

• Functional on Oracle Incentive Compensation (OIC) module, analysis of existing business process flow.
• Implementation of AMS product hierarchy, end-to-end testing of AMS product hierarchy and Integrated Services Routers (ISR)plan elements, Setup of lookup codes and DFFs, development of technical design (MD070) and review of TD with project team to for approval, development and Customization of PLSQL programs to which helps to attach ISR plan elements to existing goal sheetsof an ISR eligible agents
• Enhancement of Goal Proration programs, customization of Reports to display ISR plan elements information, creation of KINTANA packages for migrating AOL objects, XML publisher reports and PLSQL objects to different environments and BONUS tool support

Lead Consultant

Confidential

Responsibilities:

• Functional/ Technical analysis of existing business process flow, worked on CUSTOM.pll in order to in corporate new radioactive license program functionality, processing of AR receipts using Auto-lock box functionality available in AR, developed conversion programs for Items and Service Contracts using Oracle PL/SQL and Standard APIs.
• Development of reports using XML/OBIEE Publisher, PLSQL programs and development/personalization of OAF pages using JDeveloper 9i, documentation of MD070, MD120 and migration of code to different instances using KINTANA
• Responsible for managing the RICE development team atoffshore and delivery, gathering client requirements, provide estimates for all technical components, including preparation of dataconversion strategyfrom legacy to oracle databaseas per the client standards and participated in negotiation of project estimates
• Design development for conversion ofAR Invoices,INVItemsand Item Costsinterface programs and development and update of functional/technicaldesign and migration documents(MD070s and MD120s, CV060s, TE020)

Senior Consultant

Confidential, Seattle WA

Responsibilities:

• Contributed as a tech lead for development team at onsite/offshore
• Responsible to track the development of all the RICE components with the team on daily basis, requirement gathering from functional/client implementation team along with interaction with users on specificBRsand CRs.
• Responsible to negotiate development estimates for CRs, resolving of technical / functional issues, fast analysis of existing business process flows, including design and development of technical specifications, conversion/Interface PLSQL programs for Items, Item Costs, BOMs and POsincluding SQL and XML publisher reports and documentation of functional, technical designs and migration documents (MD050, MD070 and MD120)

Senior Consultant

Confidential

Responsibilities:

• Responsible for development ofAP - AR Netting Interface, de-activation of Parties and Customer Accounts in AR/TCA, day-to-day status track of projectRICE componentswithoffshoredevelopment team, development of customerinterfaceusing Oracle standard TCA APIs including DQM rules and customization of existing interfaces which interfaces with AR, Projects and iSeries (legacy instance).
• Development of BPEL Processes to integratewithlegacy systems to Oracle using BPEL Process Manager andOracle JDeveloper9i, MD070s and MD120s
• Responsible for development and delivery of RICEFW componentsatoffshore team, managed around 35 technical resources, review of functional designs (MD050s) and documentation of High level Technical designs (MD070s)
• Development of conversions/interface PLSQL programs -Barter Tax interface, conversion of service contracts, custom QAvalidationrules of service contracts, code review and migration
• Documentation of technical designs - MD070s and installation scripts and test scenarios/cases forall technical components based on functional designs

Senior Lead Consultant

Confidential, Seattle WA

Responsibilities:

• Responsible for analysis/development of functionality integrating Oracle Order Management and Service Contracts, designedand developedtheOM-SC integration businessprocess flows, validating dependencies of Service contracts with pre-existing modules.
• Responsible to provide technical object development estimates, development/delivery of integration and OKS conversion programs
• Developed data extraction programs using UTL FILE packages, end-to-end functional testing ofOM-SC-ARintegration process, development of BR100, functional designs (MD050), technical (MD070) designs, installation (MD120)and testing documents
• Responsible for production support activities (production issue tickets)