SUMMARY:

• More than 12 years of IT experience including Solution Architect/Functional Consultant/Technical Consultant/Team lead/migration lead/Project lead experience in Oracle Financials/Supply Chain Management/Distribution domain.
• Senior Techno - Functional Consultant having extensive experience in implementing Oracle Applications E-Business Suite solutions for large global enterprises like Confidential, Confidential, Cisco etc. I have worked on End to End Implementations, Upgrades, Roll outs and Post Implementation support, Stabilization as well.
• Extensively involved in Global Rollout of Oracle Financials Application for Confidential, Connecticut, USA.
• Extensively involved in Global Data migration, implementation, Conversion, Development, Upgrade, Enhancement and Support roles for Confidential .
• Extensively involved in Implementation, Development, and Upgrade for Confidential, Confidential USA.
• Experience in Interface Integration and Data migration Strategy.
• Strong co-ordination, communication and inter-personal skills
• Experienced in full life cycle / SDLC processes, implementation, development and post implementation support methodologies like (AIM, Six Sigma)
• Experience in various Techno-Functional Roles in Oracle Financials and Oracle Supply Chain 11i/R12.
• Worked extensively on Order to Cash (O2C) and Procure to Pay (P2P) Cycles.
• Completed three end-to-end Implementations of Oracle 11i, Oracle R12 in Multi-Org instances.
• Good knowledge of Financial Modules like Account Receivable (AR), General Ledger (GL), Account Payables (AP), Cash Management (CM), Fixed Assets (FA), I-Expenses, I-Procurement, Project Accounting (PA), Oracle Trade Management (OTM) and Oracle Lease Management (OLFM) modules.
• Expertise in Distribution Modules like Order Management, Purchasing, Advance pricing, BOM, Shipping and Inventory.
• Thorough understanding of Application Object Library modules like System Administrator, Workflow Administration, Oracle Alerts.
• Proficient in Contract Core, Service Contract, Install base, product information management (PIM), Advance supply chain planning, Oracle transport management (OTM), Oracle Cost Management, i-Supplier, Application Desktop Integrator (ADI), Oracle Payments.
• Extensively worked on Business Requirements Gathering, Solution design, Business Mapping, configuration, set-ups, Building RICE components (Reports, Interface, Conversion, and Extensions), Discoverer Reports, and Workflows.
• Proficient in Creating User Requirement Specification, Functional Requirement Specification and Business Process Flows.
• Good knowledge in developing and writing Test Plans, Test Cases and Test Scripts using manual testing tool HP Quality Center to perform User Acceptance Testing (UAT).
• Enhancement and Support, which involved giving Production support by interacting with user for, trouble tickets and establishing the process to be followed.
• Demonstrated ability to facilitate system review, data analysis, Conducting CRP, SIT & UAT and situation assessment.
• Strong focus on implementing Quality Assurance Processes
• Certified Green Belt in Six Sigma
• Experience with the Software Development Life Cycle (SDLC) process - performing detailed analysis, collecting requirements, technical specifications, development and unit testing, integration and production installation and support.
• Proficiency in interacting with various stakeholders and collaborating with them for mission critical projects.
• Experience in Design, Development, Customization and Implementation of business applications using Oracle Applications, SQL, PL/SQL, Oracle 10g/9i/8i/7.x, forms6i, reports6i, Discoverer 4i/10g, Workflow 4.5.
• Strong conceptual knowledge on business processes in Inbound and Outbound Logistics.
• Experience in creating Procedures, APIs, Packages, Functions, Triggers views, collections (nested tables and arrays), records, sequences, Materialized views, Constraints and other database objects using SQL and PL/SQL.
• Strong analytical, diagnostic and problem solving abilities.
• Exposure to oracle AIM methodology.
• Experience in converting oracle reports into stylish PDF format using XML publisher.
• Familiarity in developing Project related design documents like MD70, MD50, MD120, BR100, CV40, TE40 and TE20.
• Experience of full-cycle Oracle implementations, Project transition, Support, Global roll-outs, version upgrade and offshore support projects.
• Oracle Lease and Finance management (OLFM) lead for -Oracle R12 Implementation Project for Confidential, Connecticut, USA.
• Solution Architect/Functional consultant for -Oracle 11i Production Support Project for Confidential, Milwaukee, USA.
• Business system Analyst for - Oracle 11i/R12 project for Confidential (A Google Company),Sunnyvale, California, USA
• Technical/Functional consultant for - Oracle R12 upgrade project for Confidential Inc, San Jose, California, USA
• Technical/Functional consultant for - Oracle R12 Implementation project for Confidential, Confidential, California, USA
• DC Migration lead for - Oracle 11i data center migration project for Carnival Cruises, Doral, Florida, USA
• Technical/Functional consultant for - Oracle 11i Support project for Princess Cruises, Valencia, California, USA
• Technical/Functional consultant for - Oracle 11i Support/Implementation/Upgrade/Enhancement project for General Electric, Connecticut, USA

TECHNICAL SKILLS:

Oracle Apps: Financial Domain - Accounts Payable (AP), General Ledger (GL), Cash Management (CM),iExpense, Accounts Receivable (AR), Oracle Lease Management (OLFM), Oracle Trade management (OTM), Fixed Asset (FA), Contract Core, Sales Contract, I-Supplier, Oracle Payments and Project Accounting (PA).

Supply Chain Domain: Order Management (OM), Inventory (INV), Advance Pricing (QP), Oracle Purchasing (PO), Install base, product information management (PIM), Advance supply chain planning (ASCP), Oracle transport management (OTM), Oracle Cost Management

Software: Oracle E-Business Suite 11.5.10.2/12.1.3, Oracle Database 10g, PL/SQL, Reports 6i, XML,Publisher, Discoverer 4i/10g, Workflow builder.

Tools: TOAD, Data Loader, SQL Loader and Unix shell scripts.

PROFESSIONAL EXPERIENCE:

Confidential,Shelton,CT

Oracle Apps Techno Functional Consultant (Tower Lead)

• Communicating with Business users for understanding of the requirements.
• Involved as a Functional Analyst in end to end process from quote creation to contract creation in OLFM (Oracle Lease Management). Opportunity gets created in SFDC (Salesforce) and then based on opportunity details we create Quote in Sterling CPQ and then covert these quotes to Orders in SAP and send Contract information from SAP to oracle and then based on Contract information we create contract in OLFM and then Book (activate) contract in OLFM.
• Involved in End to End Life cycles of lease like Application to Booking, Invoice to Receipt, Inquiry to resolution, Quote to termination, Asset return to disposal and period to close.
• Salesforce.com (SFDC) integration with CPQ and CPQ integration with SAP and SAP integration with Oracle EBS OLFM.
• Involved in Contract Booking/Activation/AR Billing.
• Involved in Contract Rebook/Termination/Asset Return/Asset Depreciation.
• Involved in billing process to generate AR invoice.
• Acquiring and transferring knowledge of business processes to other members in the team.
• Analyzed major APIs and interface tables in Inventory, Purchasing and Shipping areas and made use of them to integrate oracle with the 3PL WMS system. (Ex: PICK Confirm and Ship Confirm API, Receipt and Inventory Interface tables, Items and Custom interfaces etc.)
• Co-ordination with the team ensuring proper and timely interactions
• Oversee and perform designing coding and testing of program deliverables.
• Interaction with offshore team for project related activities
• Regular client interaction regarding the status of the project
• Involved in Order to cash cycle.
• Involved in below business processes as per business requirements and created business scenarios on below business processes.
• Create quotes for lease contracts
• Contract Booking/Activation in OLFM
• Request set to generate AR invoice
• Lockbox process
• Create Vendor Program Agreements
• Revise Contracts
• Provide Quotes and Terminate Contracts
• Process Asset returns
• Use Lease Accounting features of OLM
• Credit memo/Credits generation
• Transfer and assumption
• Involved in Asset-based finance process on below key business flows.
• Opportunity to Quote
• Credit to Booking
• Invoice to Receipt
• Quote to Termination
• Period Open to Period Close

Environment: Oracle database 10g, Oracle E-Business suite R12 (12.2.3), SQL developer, PL/SQL

Confidential,Milwaukee,WI

Oracle Apps Techno Functional Consultant (Solution Architect)

• Communicating with Business users for understanding of the requirements/issues.
• Analysis and issue resolution for Service contracts/ Service procurement /OM/PO/AP/HR/PA/GL/AR/Shipping/BOM functional/technical production issues involving - Service Contracts, Receiving, Shipping, Costing, Invoicing, Billing, Interfaces and Integrations.
• Implemented functionality on the Inventory, Purchasing, WMS and Shipping.
• Involved as a Functional Analyst in working with the issues raised during from contract creation to booking in Contract Booking system (CBS). Contract creation happens at CBS and then flows to Oracle and also issues related to costing (Contract Cost). Contract flows to Oracle (OM) as order.
• Involved in Contract Booking/Activation/Costing/AR Billing/AP Invoicing.
• Involved in Pay on receipt process.
• Involved in complete Asset Procurement Cycle from Oracle Payables to Oracle Assets including Accounting Flows
• Setting up of buyer less procurement process for frequently procured items through the internal catalog for iProcurement requisitions. Set up of ASL's for iProcurement-requisitioned items with release generation method "Release using Create" enabling auto generation of Blanket Releases, Standard Purchase Orders against the Blanket Agreements and Catalog Quotations
• Created category sets, category codes, default category sets for the various items in Inventory application
• Worked extensively on Return Material Authorization (RMA) transactions in Order Management.
• Created Purchasing Hierarchies, Approval Limits, Approval Assignments for the various positions in Purchasing application
• Worked on Internal Requisitions, Internal Sales Orders, and Drop Shipment process in Purchasing, Order Management applications.
• Troubleshooting and fixing the PO Approval issues, Stuck Purchase Orders from the Workflow utilizing the standard scripts from Oracle
• Involved in complete Asset Procurement Cycle from Oracle Purchasing to Oracle Assets including Accounting Flows
• Involved in Fixed asset (FA) retirement process
• Involved with issues related to Supplier Cost not flowing to Projects (PA).
• Involved in budget baseline issues in PA.
• Involved in transfer Inventory Cost to Projects
• Carrying Month Close activities as defined by the Business Users
• Involved in accounting issues.
• Support analyst for INV/PO/PA/AP/OM/HR/BOM/Shipping. Resolved production issues and provided day-to-day support changing the business needs.
• Involved in approval of Project (PA) based requisitions through AME.
• Worked and fixed issues received during PA to GL transfer on revenue, labor cost, burden cost.
• Billing process to generate AR invoice and involved in project AP invoicing process.
• Debugging SQL queries and PL/SQL packages, procedures, triggers, and functions.
• Developing workarounds.
• Fixed issues with project costing and project billing
• Calls with the client and oracle regarding the data fixes and solutions.
• Acquiring and transferring knowledge of business processes to other members in the team.
• Participate in the meetings with the Client along with the Functional Trackers.
• Purchase order Inbound EDI Interface (850/Orders).
• Support several Interfaces between Oracle apps and other legacy systems.
• Worked on Support Tools like Remedy, Jira, SVN, and Hudson.
• Co-ordination with the team ensuring proper and timely interactions
• Oversee and perform designing coding and testing of program deliverables.
• Ensure on time delivery.
• Development, Code Reviews & Testing of the project by reviewing code and maintain uniform Quality Standards along with the documentations.
• Interaction with offshore team for issue clarifications and other project related activities
• Analysis of the specification provided (both front-end &backend).
• Involved in the Production-Support and Enhancement as part of their ERP solution. The area of this project is building efficiency.
• Handled issues related to OM, PO, AP, PA, AR, BOM, FA and GL modules including issues related to Interfaces.
• Coding in pl/sql, sql.
• Code / break fix after analyzing the issue with high-level functional point of view.
• Regular client interaction regarding the status of the project
• Involved in Purchase Requisition process and Approval hierarchy to manage Items purchases in the Organization.
• Involved in fixing the issues with Order to cash and Procure to pay (Costing/Billing/Shipping).
• Drop ship Functionality ( Order to Cash) was setup to enable the OM team to ship the goods directly to Customers from Supplier warehouse.
• Internal Sales Order/Internal Requisition ( Order to Cash) process was configured to establish a simplified Intercompany sales across operating Units
• RMA and Approval Management functionality ( Order to Cash) setup reduced the process time in Customer Returns management
• Worked on AME ( Approval Management ) with customization in seeded workflow

Environment: Oracle database 10g, Oracle E-Business suite 11.5.10, Reports 6i, TOAD, SQL * Loader, PL/SQL, Data Loader and Unix shell scripting.

Confidential,Sunnyvale,CA

Oracle Business system Analyst (Project Lead)

• Involved in gathering Functional Requirements, Business Requirements and Design Documents.
• Involved as a Functional/Technical Analyst for check printing solution using bottom line technologies. Using Bottom line we format the file as per the client requirement and generates check print to check printer. Worked on pay base configuration and printer configuration in pay base for check print solution.
• Involved as a Technical/Functional Analyst with AP/AR/GL/OM/INV Interface issues.
• Worked on the development of outbound interfaces on GL/AP/AR/FA/OM/INV. Worked on security profile setup to fix the issue with interfaces.
• Configured/Setup printers in network as well in oracle for check printing process.
• Attend Meetings and discussion with Client for improvements in project.
• Discussions with User to explain the various modules.
• Purchase order Inbound EDI Interface (850/Orders).
• As a functional consultant, I am responsible for implementing and resolving any issues on functional aspect in the Oracle Applications Modules such as GL/AP/AR/OM/FA/INV/CM/Procurement.
• Regular interaction with the customers who are basically our Corporate Finance team to know the issues faced by them while using Oracle Applications and suggesting process improvements/solution for the same.

Environment: Oracle 9i database, Oracle E-Business suite 11.5.10/12.2.3 GL, AP, AR, OM, FA, INV, CM, Reports 6i, UNIX, SQL * Loader, PL/SQL, Work Flow Builder, Pay base (Bottom Line technology).

Confidential,San Jose,CA

Oracle Apps Techno Functional (Onsite Lead)

• Involved in gathering Functional Requirements, Business Requirements and Design Documents.
• Involved in EDI 823 lockbox interface with banks
• Involved in EDI 820 lockbox interface with banks
• Involved as a Functional Analyst for establishing the Individual Benchmarks and Baselines for Oracle Applications R12 (12.1.3), Legacy, SFDC, Originations, ERP Modules GL, AP, AR, FA and OLFM (Oracle lease management) & and Finance etc. From Quote creation in SFDC to deal (Contract creation) in OLFM.
• Involved in End to End Life cycles of lease like Application to Booking, Invoice to Receipt, Inquiry to resolution, Quote to termination, Asset return to disposal and period to close.
• Transaction Source Setup (OKL Contracts).
• Salesforce.com (SFDC) integration with OLFM.
• Worked on process to convert quotes from within SFDC to EBS contracts.
• Worked with business users on Oracle pricing functionality
• Worked with Salesforce analysts to design customer-facing documents - quote pending approval, approved quotation, etc.
• Performed end to end testing during SIT in areas of Terminations, Billing and Service.
• Created defects using HPQC and helped technical team in defect resolution testing and unit testing.
• Involved with late interest fees and rollover fees and worked with business on business scenarios and tested the same with business during CRP and UAT.
• Involved in below business processes as per business requirements and created business scenarios on below business processes.
• Create quotes for lease contracts
• Create credit lines and limits
• Author lease contracts
• Contract Booking/Activation in OLFM
• Request set to generate AR invoice
• Request set to generate AP invoice
• Lockbox process
• Direct debit process
• Create funding requests and generate invoices
• Generate billing, payments and disbursements
• Create Vendor Program Agreements
• Revise Contracts
• Provide Quotes and Terminate Contracts
• Process Asset returns
• Use Lease Accounting features of OLM
• Use Oracle Lease Center late interest fees, rollover fees and pass-through fees
• Involved in Asset-based finance process on below key business flows.
• Opportunity to Quote
• Credit to Booking
• Invoice to Receipt
• Quote to Termination
• Period Open to Period Close
• Inquiry to Resolution
• Involved in CRP and UAT testing's.
• Involved in monitoring the data flow from using SQL queries and stored procedures to extract the data from the database.
• Attend Meetings and discussion with Client for improvements in project
• Oversee 4 off-site analysts.
• Supervise development of SQL-queries/procedures for database and backend testing.
• Analyzed application, system, and security errors. Escalated issues to developers and verified fixes.
• Designed test plans and defined cases for functional, integration system, and user acceptance testing.
• Attended weekly defect report meetings and presented progress updates.
• Interacted with developers, system engineers, and testing teams to identify applications defects

Environment: Oracle 9i database, Oracle E-Business suite R12 12.1.3 OLFM, AP, AR, CM, OM, Reports 6i, UNIX, SQL * Loader, PL/SQL, Work Flow Builder.

Confidential, CA

Oracle Apps Techno Functional Consultant

• Responsible for gathering Business Requirements, creation of Technical Design Documents and user Documents.
• Study of current business processes, future business flows and identification of gaps and workarounds in order to provide an integrated Procure to Pay business flow to meet the business needs of the company
• Workflow Development ( Order to Cash): Worked extensively on development of Inventory account generator workflow. Was involved in interaction with functional consultant and business users and customized standard workflow as per client requirement.
• Interface/Reports Development: Developed Key master interface program to import keys from key master system to Oracle with required validations.
• Implemented and enhanced procure to pay process.
• Drop ship Functionality ( Order to Cash) was setup to enable the OM team to ship the goods directly to Customers from Supplier warehouse.
• Internal Sales Order/Internal Requisition ( Order to Cash) process was configured to establish a simplified Intercompany sales across operating Units
• RMA and Approval Management functionality ( Order to Cash) setup reduced the process time in Customer Returns management
• Worked on AME ( Approval Management ) with customization in seeded workflow
• Designed and developed reports using combination of Report 6i and XML publisher for modules like Order management, Inventory.
• Developed reports in Discoverer 10g and created various business areas, user views, custom folders and joins for reporting. Created Workbooks based on the Custom Folders with multiple parameters and calculations using Discoverer Plus and Discoverer Desktop.
• Developed around 30 reports in Discoverer from scratch for Order Management, Account Receivable, Items, Inventory, trade management and collections.
• Created several Requests and Request Set to attach the PL/SQL procedures, SQL*Loader routine and Reports with Application.
• Assisted in design of various conversions/customizations from legacy system to Oracle Accounts Payable and Oracle Purchasing and General Ledger.
• Imported data from legacy system to Oracle Payables tables using SQL*Loader and validate them using PL/SQL procedures.
• Responsible to track the development of all the RICE components with the team on daily basis
• Requirement gathering from functional/client implementation team
• Interaction with users on specific BRs and CRs.
• Resolving of technical / functional issues at client place and communicating/coordinating on the issues with the offshore team.
• Involved with late interest fees and balance forward billing process and worked with business on business scenarios and tested the same with business during CRP and UAT.
• Technical analysis of existing business process flow based on the functional designs.
• Preparation of technical design document MD070, technical process/data flow chart.
• Rich experience in registration of Forms, Reports, and PLSQL programs.
• Conducted meetings with Super users/SME’s to gather requirements for Procure to pay and Order to Cash cycles and documented.
• Understanding the current Business process and preparation of As-Is documentation.
• Designing of To-Be process and Identification of Gaps.
• Setup Configuration - BR100 Preparation & Mapping of Business Process
• Conducting CRP 1 Testing and CRP 2 Testing to super users.
• Conducting UAT - End to End Integration testing
• Performing out the Production Setups.
• Post production support
• Functional Business Support, and resolving day-to-day critical issues.

Environment: Oracle 10g database, Oracle E-Business suite R12 12.1.3 OM, PO, CM, AR, GL, AP, INV, OTM, Reports 6i, PL/SQL, workflow Builder.