SUMMARY

• More than 13 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 Commercial Finance, Confidential, Cisco etc. I have worked on End to End Implementations, Upgrades, Roll outs and Post Implementation support, Stabilization as well.
• Extensively involved in Implementation of Oracle Financials for Confidential
• 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
• 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, OUM, Six Sigma)
• Experience in various Techno-Functional Roles in Oracle Financials and Oracle Supply Chain 11i/R12.
• Worked extensively on Order to Cash (O2C), Procure to Pay (P2P), PTD, QTO, QTC and RTR (Record to Report) 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), Service Contract 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 Install base, product information management (PIM), Advance supply chain planning, OPM, 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).
• Demonstrated ability to facilitate system review, data analysis, Conducting CRP, SIT & UAT and situation assessment.
• 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.

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, Fixed Asset (FA), Contract Core, Service Contract, Field Service, 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, Enterprise asset management (EAM), OPM (Oracle Process Manufacturing)

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, Oracle application framework (OAF), Noetix Views, Markview

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

PROFESSIONAL EXPERIENCE

Confidential, Shelton, CT

Oracle Apps Techno Functional Consultant (Tower Lead)

Responsibilities:

• 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 inContract Booking/Activation/AR Billing.
• Involved inContract Rebook/Termination/Asset Return/Asset Depreciation.
• Involved in billing process to generate AR invoice.
• Regular client interaction regarding the status of the project
• Created shell script to migrate objects from DEV to QA and PRD.
• Worked on month end period close issues related to accounting, revenue recognition
• Involved in month Close activities as defined by the Business Users
• Involved in month end issues with GL, AP, AR, CM and FA.
• Business process analysis and Gap analysis.
• Worked with Oracle in fixing the long running Create accounting jobs for FA and AR.
• Worked with Oracle in fixing Create accounting issues faced during month end and year end close.
• Worked with Oracle in fixing Creating accounting errors.
• Customized OAF web page (Lease workbench) as per business requirement.
• Customized OAF web page (Customer workbench) as per business requirement.
• 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 OLFM
• 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)

Responsibilities:

• Communicating with Business users for understanding of the requirements/issues.
• Analysis and issue resolution for Service contracts/Service procurement/Field Service/OM/PO/AP/PA/GL AR/Shipping functional/technical production issues involving - Service Contracts, Receiving, Shipping, Costing, Invoicing, Billing, Interfaces and Integrations.
• Involved inContract Booking/Activation/Costing/AR Billing/AP Invoicing.
• Involved in Pay on receipt process (Procure to Pay).
• 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.
• Worked on Internal Requisitions, Internal Sales Orders, and Drop Shipment process in Purchasing, Order Management applications.
• Custom P2P(Procure to pay) Process: The process of procuring material from the organization, process picks the PO’s which have AP invoice option defined in DFF and create Requisitions and creates against the Supplier.
• 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
• Support analyst for INV/PO/PA/AP/OM/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.
• Prepared MD.050 and MD.070 document and code for 6i reports for Service contract and field service
• Involved in Intercompany shipping and Intercompany invoicing process.
• Purchase order Inbound EDI Interface (850/Orders).
• 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

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)

Responsibilities:

• 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)

Responsibilities:

• 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 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.
• 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.
• Worked on Lockbox and Direct debit process.

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, Redwood Shores, CA

Responsibilities:

• Responsible for gathering Business Requirements, creation of Technical Design Documents and user Documents.
• Workflow Development (Order to Cash): Worked extensively on development of Inventory account generator workflow (Intercompany shipping and invoicing). 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.
• Worked as Oracle functional specialist in the implementation of procure to pay cycle of Oracle R12 and involved in setting up intercompany 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
• Involved in Intercompany shipping transaction setup and Intercompany shipping and Intercompany invoicing process.
• 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, enterprise asset management and collections.
• Tracked cost of assets thought an organization using EAM.
• Assisted in design of various conversions/customizations from legacy system to Oracle Accounts Payable and Oracle Purchasing and General Ledger.
• 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.
• 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

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.

Confidential, Doral, FL

Responsibilities:

• Main key responsibilities involved in taking knowledge transition from Carnival Application SME’s about existing business processes and custom components.
• Conducted knowledge transition interviews, validate gap analysis, develop end-to-end business process flow diagrams (using Visio).
• Prepared the knowledge transition documents and involved in Knowledge Acquisition (KA) playback presentation to relevant SME’s. Responsible for taking signoff on the presentation from each Operating Company leads.
• Analyzed company policy, standards, and procedures, and drove policy changes with senior management.
• Transferred knowledge and system functional design to offshore technical team required for ADM support.
• Interacted with business users to perform change request analysis, define intended system behavior and document requirements to communicate change to management and technical team.
• Developed test scripts, communicated/guided business users/.stakeholders, test application and proactively resolve issues through effective cross-functional interactions.
• Customized CGFS HAL General Ledger by Account with Purchase Order as per user requirement.
• Customized the CGFS INV Approval Report as per business requirement.
• Worked and resolved the issue with check printing in Account payables as business was unable to print checks with proper style and signature was not appearing after once we migrated to Linux instance from IBM AIX instance. Worked with DBA team and did the necessary changes in printer driver arguments to resolve the issue.

Environment: Oracle 10g database, Oracle E-Business suite 11.5.10 PO, CM, AR, GL, AP, Reports 6i, PL/SQL, workflow Builder, Markview, Noetix Views.

Confidential Capital, CT

Responsibilities:

• Development of New Custom Program (Mexican Tax Revaluation Program): The program that will be developed to automate the calculation and posting of Mexican Tax Revaluation adjustments.
• GEAST Consistency Extract Program: GEAST Consistency Extract, for extracting PDP entries from the General Ledger from base tables to flat file using UTL FILE package. GEAST is required to provide PDP, Option and Capitalized Interest data from the GL to Confidential Corporate, as part of the Consistency project.
• X-charge Change Request (Cross Charge Change): The x-charge tool now tells me we have a payable balance on the 130% and a receivable balance on the 320% and function uplift perc added to get the uplift percentage values for corresponding cost center.
• DFF & Value Sets: Created DFF and Value sets for above program as per the requirement.
• Mailer Program: Wrote GEAST Extract Mailer Program to identify business users that extract has been generated on server.
• Process Improvement of in CXAO Interface ( Confidential Interface Engine).
• Workflow: Worked on I-expenses module based on workflow and worked on the issues and enhancements which we received from the business. Worked on issues like Journal approver not found, Users from business was not running programs from proper responsibility the journal went into error. Worked on the issue in which there were no approval limits for particular user. In I expenses we worked on issues on which there were no managers for a employee, we need to setup manager for an employee.
• Involved in creation of Master Lease Agreements.
• Involved in creation of quotes for lease contracts and credit lines.
• Resolved issues faced during process of asset returns and disposal of returned assets.
• Resolved issues related to accounting during Period Open to close process in PA/GL/AR/AP.
• Involved in setting up Project Costing module - expenditure category, revenue category, auto accounting, non-labor resource / cost rate, labor multiplier, rate schedule.
• Integrated projects with many other modules like Account Receivables (AR), Account Payable (AP), Purchasing (PO), Order Management (OM), Oracle Purchasing (PO) and General Ledger (GL).
• Worked on costing, i.e. capturing cost, distribute cost and cost budget etc.
• Prepared integrated test cases for each setup and End User training material on the Project Accounting module.
• Training in Oracle application framework at Confidential Commercial Finance.
• Helped to create funding requests and handled issues which came across during generation of invoices.
• Handled issues related to billing, payments and disbursements.
• Helped client/user to revise/restructure the contract.
• Involved in complete Asset Procurement Cycle from Oracle Purchasing to Oracle Assets including Accounting Flows
• Involved in Fixed asset (FA) retirement process
• Involved in creation of termination quotes and helped client/user to terminate the contracts.
• Customized Trial Balance - Detail report as GECFA Trial Balance - Detail. Confidential Commercial Finance was needed correct CDR information and account in GECFA Trial Balance - Detail report which shows incorrect CDR information and account. The accounts were truncated in Existing Reports. Developed a new program GECFA Trial Balance - Detail for same.
• Aging Trial Balance Report:
• Confidential Commercial Finance is needed to get the ATB report for unpaid invoices for all the Europe countries and it will be By Stage, status and Collector. Existing Reports were: GEFS EU ATB By Stage, status and Collector (Excel format) and GEFS EU ATB By Stage, status and Collector (Period Adjusted)
• Customized Vat Tax Register report as per user requirement.
• Customized the GEFS EU Billing & Receipt Report.
• Customized the GEFS IT Purchase Vat Register
• Discoverer Reports: Developed Various Report of GL, AP and PO Module in discoverer.
• Customized Confidential Cost Centre Matrix Form and added two fields (Initial IME and Target IME) in form then migrated .fmx executable file to $AU TOP on forms server of client and added above fields mapping table.
• Customized Sales Order Form.
• Created BSLA Security form GEASTDISCOSEC.fmb and register to Apps.
• Worked on UTL PACKAGE and SQL*LOADER for the interfaces and conversions.
• Assisting business users in creating new reports and modifying existing reports in Discoverer.
• Preparation of setup documents for GL, AP, AR, PA and CM Module.
• Providing consultation during acceptance testing and release of the product into the production environment
• Developed the Inbound interfaces for Oracle GL, AP and FA using PL/SQL and Unix Shell Scripting.
• Setup and Configured GL, AR, AP, PA, PO, OM, Shipping, CM
• Developed the Outbound interfaces and Extraction scripts for Oracle GL, AP and FA using PL/SQL and Unix Shell Scripting.
• Fixed issues with project costing and project billing
• 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 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

Environment: Oracle 9i database, Oracle E-Business suite 11.5.10 GL, AR, AP, PO, CM, PA, FA, procurement, Reports 6i, Forms 6i, UNIX, SQL * Loader, PL/SQL, Workflow Builder.

Confidential, CT

Responsibilities:

• Developed new Interfaces to enable the loading of data of new Businesses acquired by EEF or FLEET into GL or modify the existing interface to accommodate the time-to-time changes in data format.
• Worked in Oracle Applications 11i Product Support team and was responsible for troubleshooting issues reported by customers. The work related issues of TCS corporate office employees dealt with. Mainly the solution was provided to the user using (PL/SQL Developer) to retrieve data from database as well as Analysis, Design, Development, Testing activities for new enhancements.
• Implementation and Integration of FLEET Europe, Japan and Production movement of all the Concurrent programs, Scripts and database objects.
• Automated the Daily and Period Currency Rates upload process into Oracle GL by extract the exchange rates from the Confidential Treasury web-site.
• Developed the Outbound interfaces and Extraction scripts for Oracle GL, AP, AR, PO and FA using PL/SQL and Unix Shell Scripting.
• Developed Custom reports, custom concurrent request program and Extracts of GL, AP, AR, PO and FA for EEF/FLEET which needs to be sent to the Third party Systems.
• Interacting with Business Users, analyzing change requests, impact analysis, and implementation of the same
• Involved in fixing lockbox and CM issues.
• Extensively worked on Auto Invoice and Auto Lock Box process and troubleshooting the process on production environment.
• Developed Custom reports, custom concurrent request program and Extracts of GL, AP, AR, PO and FA for EEF/FLEET which needs to be sent to the Third party Systems.
• Developed the Inbound interfaces for Oracle GL, AP, FA using PL/SQL.
• Handed cases raised by end users on daily basis involving problems in the areas of accessing to the application, request for having a new or additional access, technical problems like mapping errors and performance issues, incorrect data in reports, delay in process etc.
• Customized the Invoice Aging Report to display only not paid Invoices with invoice status should be approved.
• Customized Invoice History Report by adding few more details related to Bank (Bank Name, Branch Name and Account Number).
• Developed PO Report, in order to get vendor wise cancel details.
• Customized the sales Order Form using Personalization. It should not raise sales order on weekends or public holidays.
• Customized PO Form using Personalization. Whenever user enters data on Sunday, Form should get Exit.

Environment: Oracle 9i database, Oracle E-Business suite 11.5.9 GL, AR, AP, FA, PO, CM, Service procurement, Reports 6i, Forms 6i, UNIX, SQL * Loader, PL/SQL, Workflow Builder.