OBJECTIVE:

• To work in an environment that offers good exposure and enhances my expertise as a Techno - Functional consultant in Oracle Financials, Supply Chain, CRM and OLFM modules.

SUMMARY:

• 12 years strong Techno-functional expertise in EBS R12/11i in the following Apps modules:
• Oracle Financials - Receivables (AR), Payables (AP), Fixed Assets (FA), Project Accounting (PA), General Ledger (GL), Cash Management (CE), Treasury (XTR), iExpense, iSupplier
• Oracle Leasing (OLFM) - Leasing (OLM), Receivables (AR), Payables (AP), Fixed Assets (FA), General Ledger (GL), Purchasing (PO), Inventory (INV), Sub-Ledger Accounting (SLA)
• Oracle Manufacturing & Supply Chain - Inventory (INV), Order Management (OM), Purchasing (PO), Bills of Material (BOM)
• Oracle CRM - Service Contracts (OKS), Core Contracts (OKC), Field Service(CSF), Install Base (CSI)
• Oracle HRMS - Human Resource, Payroll
• PeopleSoft HCM 9.0/9.2 - ELM, HR, Benefits, Talent Management, Recruiting
• Shared - TCA (Customer, Vendor, Bank Model), SYSADMIN, User management (UMX), EDI Gateway, Alerts (ALR), Application Developer, Application Object Library (AOL)
• Extensive experience as a technical architect/integration analyst in analysis, design, development, test implement, documentation of the RICE (Reports, Interfaces, Conversions, Extensions), CEMLI Extensions using various available technologies like XML Publisher/BI Publisher, Oracle Workflow, SQL, PL/SQL, Oracle Forms(6i/9i), Oracle Reports(6i/9i/10g), SQL*Reports, Shell Scripting, Oracle 10g/9i/8i, SQL Loader.
• Experienced in 24/7 Production Support Projects as Level2 and Level3 Support Analyst, which also included handling Enhancement requests across versions of the Oracle Applications R12 & 11i.
• Experience working with the Global Blended Delivery Model, as I worked as an Onsite Lead and coordinator collecting requirements and rendering the deliverables.
• Worked extensively on AIM methodology, Functional Documents (MD50 and CV40), Technical Documents (MD70 and CV60), Testing Documents (TE20) and Installation Documents (MD120) to prepare the documents with respect to Conversions, Interfaces or Custom Applications or Extensions Development.
• Well versed with the Data Models (Open Interface Tables, Base Tables) and other data structures (Views, Procedures, Packages, Functions, APIs) of each of the Modules in Oracle Applications with respect to different Business Process flows. Techno-functional expertise in the Order to Cash (OTC / O2C) and Procure to Pay (P2P) business process cycles.
• Extensive experience with Performance Tuning of Custom Applications involving SQL Tuning using Explain Plan, Trace & TKPROF, Indexing, Join Conditions.
• Executing changes in the Production environment following strict documentation policies (freeze exceptions etc.) using various Change Management Tools and maintain Code versions using established change control tools like Share Point, WINCVS, CVS, PVCS.
• Have been part of Month End Closing/Quarter End/Year End closure activities.

TECHNICAL SKILLS:

APPLICATIONS: Oracle Financials R12/11i, Supply Chain R12/11i, Manufacturing R12/11i, CRM R12/11i, Configurator, Workflow, Oracle 8i/9i/10g, Forms 6i, Reports 6i, Discoverer 4i, XML/BI Publisher, Web logic, Vertex, PeopleSoft 9.0/9.2, Zuora

OPERATING SYSTEMS: UNIX, HP UNIX 11.0, SUN Solaris, AIX, Windows 95/98/2000/XP, MS-DOS

LANGUAGES: Shell script programming, PL/SQL

RDBMS / DBMS: Oracle 7.x/8i/9i/10g, DB2, MS Access

SOFTWARE: Forms 4.5/6i, Reports 2.5/6i, XML/BI Publisher, PL/SQL, SQL*plus, External Tables, SQL*loader, TOAD, PL/SQL Developer, SQL Developer, Workflow Builder, Discoverer 3i/4i, Explain Plan, Metalink, AIM Methodology

VERSION CONTROL: SourceSafe, SharePoint, PVCS, CM Synergy, WinCVS and CVS

PROFESSIONAL EXPERIENCE:

Confidential, Wayne PA

Responsibilities:

• Confidential collaborates with equipment manufacturers, dealers and distributors to help businesses obtain and use the assets they need to contribute meaningfully to the world. Confidential helps the partners use their assets in a way that creates mutual success.
• Assisted with the Fit/Gap Analysis as the client is in the process of upgrading their 11i system into R12.
• As part of the R12 Solution, identified the RICEWF objects for the various OLFM processes.
• Gathered requirements for the various business processes within OLFM
• Inventory Accounting - Confidential needs an automated ability to move the Actual Inventory Value of returned assets into an Inventory Natural Account after termination of the original contract.
• Termination Quote Enhancements
• Billing Groups - Consolidate multiple AR Invoices into a single Consolidated Invoice based on grouping parameters, create and maintain Billing Group, Add or remove Contracts or Assets to Billing Group
• Invoice Messages
• Contract Rebooking - The business need is to maintain a formal process for rebooking a Lease agreement with CTA using Oracle Lease Management (OLM) and Loan Path application. This gap addresses the need to layout a process of rebooking CTA deals in Oracle Lease Management for further back office processing.
• Advance Monies - Advanced monies solution will allow the user to create advance monies

Confidential, New York City, NY

Responsibilities:

• Developed a brand new Pegasus item interface. Pegasus is an external system where
• Confidential uses Oracle for Purchase orders. PO’s from GHX come into Oracle. Once the PO is created, using the custom Oracle workflow process, depending on the approval path - the PO gets approved or rejected after confirmation from OTPS, their budgeting system. If the PO is rejected for any reason, it is corrected again & once submitted, it again follows the workflow process of approvals. If the approver is not available, it can be sent to the next higher approver authority in the chain. This would reduce the manual process of forwarding the emails to the authorized PO approver etc. Their PO approval process so far is a manual one.
• Implemented the PO auto approval project, wherein certain purchase orders for a particular expense code, threshold limit and PO type, get automatically approved in Oracle using the custom workflow process.
• Also extended the PO auto-approval process to min-max items, wherein PO’s up to a certain dollar limit are automatically approved and don’t wait for the relevant approver to approve it. This in turn reduced a lot of manual hours for the user team, and also ensured the PO delivery much faster to the vendor.
• Designed the finally close process for Small balance PO’s and fiscal year end PO’s. As they use 2 systems Oracle & OTPS, every quarter and during the year end, a bulk of PO’s have to be finally closed first in Oracle and then in OTPS.
• Worked on PeopleSoft HCM 9.0 to 9.2 upgrade project. Developed material using Oracle User Productivity Kit (UPK). The modules upgraded were Portal, ELM, HR, Benefits, and Recruiting & Talent Management. Also provided instructional led classroom to users during SIT & UAT.

Confidential, Teaneck, NJ

Responsibilities:

• Issue downloading budget templates, whereby when a user specifies a company number, the system is giving more than asked for. Also, an issue with the budget template not sorting by company code. Both these issues are known Oracle R12 bugs. Oracle gave a patch, which after applied, resolved both the above.
• Projects show invoice distribution lines with quantity 0, but with non zero burdened cost.
• Before upgrade to R12, having the 10% threshold on PO lines, AP would change amounts on the lines during the matching process. Apparently in R12, due to its structural differences with lines & distributions, it is creating a variance line to accommodate those changes. Whenever the amount on the PO line is adjusted during matching, the system creates a line to explain that difference (only after the invoice has been validated). In R12, for cases like these, PA can use the burden cost instead of the quantity.
• AP and GL allow entry of invoices against expired project and task. Users should get an error message right after entering an invoice line against an expired project. User now gets a warning message during the invoice match process, allowing them to either proceed with expenditure item dates that go Confidential project end dates or stop the matching process.
• Foreign currency transactions for Mexico set of Books. Issue with language transaction on the check - instead of printing Dolores for USD currency, it is printing Pesos MXN. Supplier site, bank & Check run template set Confidential along with a customization fulfilled the enhancement.
• A custom Cash management program replaces the one cash receipt statement line for 2 accounts 6240 and 4436, for the individual cash receipts recorded in Oracle so they can reconcile the cash receipts based on cash receipt number. During the month of Jan-14 the program hasn't been doing what it supposed to do. So, AR users had to reconcile the Oracle activity against the one statement line which is a very time consuming process. Since we need to identify the cash receipts that make up the daily deposit by running Oracle reports and then manually reconciling them in cash management.
• Assisted in the reconciliation of their Fixed Asset Tax books. Client uses BNA (Bureau of National Affairs) for the fixed asset tax books. The assets in Oracle are maintained manually and through an excel spreadsheet into BNA.
• Supported R12 Financials in various modules.
• Worked on R12 Foreign currency check printing with language translation in AP.
• Fixed Assets Tax Books reconciliation between Oracle & BNA.
• Explored the usage of Asset group functionality in the Fixed Assets module.
• Dealt with AP-PA interface issues with expired projects, adjusted distributions showing 0 quantities in PA.
• Supported the Confidential interface while applying receipts in Cash management.
• Involved in the AP, AR, PA and GL month end closes.

Confidential, Milford, CT

Responsibilities:

• Neopost leases postal equipments like meter rental etc. to both government and private clients. Customer invoices are currently sent through print machine, and for some
• Government customers, these invoices are entered into their portal. The project is now to send these invoices electronically to the customers using Electronic Data Interchange (EDI)/Ecommerce Gateway. This saves a lot of time and money for Neopost, and also aids in faster invoice payment from the customer. Setup the new EDI customers etc.
• Working on the Customer & Accounting Integration project to/from Zuora into Oracle. This will involve AR customer setup and update, as well as importing journal entries into Oracle GL for revenue recognition etc.
• Working on a custom sales order form which is zoomed from standard order entry form.
• Worked on the Lease Order Enhancement project where Neo Dealer Lease orders are dealt with. Integrating data between ERP and OLM systems, order progression, drop ship order flow, requisition and PO creation etc. are being covered as part of this project.
• Actively involved in various customizations of the order-to-cash cycle.
• Professional Zuora to understand various subscription application functionalities.
• Implemented the EDI project where AR invoices are being sent electronically to the customers. This ensured faster invoice delivery to customers, resulting in faster payments.
• Worked on 11i Enhancements in the Order management & Leasing areas.

Confidential, Goshen, NY

Business Analyst

Responsibilities:

• Supported Invoice Validation, invoice accounting, workflow approval processes.
• Customized Oracle Payroll Check Print & Payroll Deposit Advice reports. The reports have been customized to use a custom template that generates a PDF output file of the checks. It also has been customized to reprint the checks for specific checks, in case there is a printer jam etc.
• Worked on the analysis, design and development on 1099 forms. Applied the Oracle upgrade patch for this year. Customized AP to have the Invoice Distributions Type 1099 value to be the Misc code from the GL account, rather than the default from the supplier in case the account misc code is different from the supplier’s. Also designed and implemented merging of all 1099 files from different sources in the county into Oracle. Then used the Oracle seeded 1099 program to print the forms for submission to IRS.
• Involved in the EEO design where all the position titles in HR have been changed.
• Actively participated in the Budget encumbrance issues, for the change orders to a PO in a prior year. When there is a change order to a prior year’s PO, it takes the budget out of the current year as opposed to the prior year even though the period is still open.
• Worked on the timekeeper interface from an external system into Oracle. The county has various sources for maintaining the employee’s time e.g. Smartlinx. Designed and developed the interface between smartlinx and oracle, where time for employees is bought into the Oracle system.

Confidential, Ramsey, NJ

Responsibilities:

• Worked on the R12 Financials upgrade project. Client was on 11.5.10, now on R12. Analyze the R12 design, and modify the custom pieces suiting that design for R12. A techno-functional role right from the functional setups to doing technical design of the custom pieces as required.
• Involved in the customization of Positive Pay Report in Accounts Payables.
• Supported issues related to these expenses, not getting paid properly in iExpense.
• Customized Positive Pay & Payment Register accordingly to the client specifications.
• Analyzed and customized 11i Fixed Asset custom reports, so they are compatible in R12.

Confidential, Milwaukee, WI

Systems Analyst

Responsibilities:

• Worked extensively in AP dealing with the supplier maintenance, Bank accounts, exchange rates & tax set up, Employee expense interface, EDI Bank payments, and AP-GL reconciliation.
• Worked on Project Accounting Billing (PJB) & Costing modules. Provided the month end support for PA period close. Designed and developed the Revenue accrual process.
• Supported the custom interface from where invoices are created in AR from PA.
• Worked on the Inventory and Order Management modules implementation. Client was implementing the drop ship model on 11.5.10. A techno-functional role right from the functional setups to doing technical design of the custom pieces as required.
• Confidential has acquired York Works and as a result, there should be a continuous contract data transfer between the York Works System and Oracle. York Works sends the data to Contract Booking System (CBS). We in turn validate and load the data into OM.
• Client was going for an R12 upgrade from 11.5.10, on the manufacturing and financial modules GL, AP, AR, PA, OM, INV and PO.
• Worked as an analyst in the production support team involving remedy and jira tickets. This involves close interaction with the business users, analysis of the problem and the recommended fix to solve the issue.
• Designed and supported Employee expense invoice interface into AP.
• Worked on R12 AGIS intercompany setups on the Financials side.
• Dealt with EDI 810 and 820 files for vendor invoices, bank payments for checks, ACH.
• Worked on maintaining exchange rates in AP, tax details etc.
• Created new bank accounts, branches along with vendor/supplier maintenance.
• Involved in the AP and PA month end, quarter end & yearend closes, by assisting the business users in meeting the SLA for closing the periods.
• Supported AP to GL reconciliation regarding aging balances etc.
• Worked on payables customization to send 1099’s to the IRS.
• Processes developed for York Works contract data validation and loading the orders to OM.
• Some of the functional setups done as part of the OM and INV implementation are:
• Redesigned the existing AOMS Item Import interface to accommodate the business needs.
• Worked on Holds, Demand Placement Code, Approved Suppliers List (ASL)
• Experience with R12 implementation in the Financials and Manufacturing modules.

Confidential, Appleton, WI

Responsibilities:

• Involved in the Customer Facing and Finance area at Confidential, which is an company that provides innovative and proprietary products, programs, and services to help educators engage and inspire students of all ages and abilities.
• Worked on customization of Credit Memos, Unapplied Cash & Aging Reports in AR.
• Customized the Oracle - Vertex interface based on the business needs and also provided production support for the existing interface.
• Used Explain Plan techniques in the performance tuning of complicated SQL queries.
• Actively involved in complete releases that went live in the Customer Facing and Financials area embracing scope, planning, design, development, and testing and system integration.
• Worked with the testing team closely for Configurator. Configurator should be launched from OM, and the data should come from the Configurator back to the Sales Order screen.
• Involved in the customization of the Bank Lockbox functionality.
• Worked on the Forms Personalization of the Sales Order form in Order Management.
• The client has Lockbox customization in place. Provided support for the Lockbox interface that went live. Worked on issues like - same check # from 2 customers, consolidatedinvoices, and certain checks dropping out of the file without getting applied.
• Experience with the Order-to-Cash cycle involving the steps - booking the order, pick release process, shipping, interface trip stop process, workflow background process, and auto invoice program.
• Worked on the Vertex interface with Oracle Applications. The communication between Oracle Applications and Vertex is through an XML Request file (Oracle sending all the required details to Vertex) and Response file (Vertex sending the calculated tax details back to Oracle based on the Request).
• Worked on XML/BI Publisher reports. Some of the reports are - Open Credit Memo Transactions Report, Unapplied Cash by On Account Report, Daily Credit Transactions Report, Project Revenue & Billing Exception Report and AR Custom Aging Report.

Confidential, Chicago, IL

Responsibilities:

• Involved in the Supply Chain process at HAVI, which provides global leadership in Strategic sourcing, Project Management and Execution, and Supply Chain Analytics and Integration for the food service and retail industries.
• Participated in two complete supply chain releases embracing scope, planning, design, development, customization, and testing and system integration.
• Discussed and gathered details regarding the various interfaces, the means of receiving the master and transactional data from the client’s side. Prepared the Supply Chain Integration (SCI) Standard Interface Document.
• Documented the complete test scenarios of the various modules to be used in the System Integration Testing (SIT) and also prepared test data to test these scenarios accordingly.
• Worked on the Operations Guide document that lists the detailed step-by-step execution instructions, key business and IT dependencies, scheduling information and process for rerunning in case of errors.
• Prepared a high level document of the overall supply chain process - from Data management to Restaurant Order Proposal (ROP) covering both business and IT concepts.

Confidential, St. Louis, MO

Responsibilities:

• Involved in the Customization of Oracle Financials 11i at Confidential, a financial company involved in the credit card business.
• Designed and developed various packages, reports and interfaces and also provided support for XTR, CM, AR and GL modules.
• Worked on both the Oracle Financials 11.5.7 and 11.5.10 versions as the client was going for an upgrade of their system from the 11.5.7 version to the 11.5.10.
• Customized Lockbox Interface functionality to upload a Bank Statement file containing cash receipts as AR receipts.
• Involved in the complete design of a Foreign Exchange deal interface which loads the foreign exchange deals received from the client into Oracle.
• Custom packages were designed and developed for generating Electronic Fund Transfer (EFT) files for each currency that the company settles.
• Customized an Oracle Treasury Positions Cash flows by Account Report which gives the total opening balance and a projected cash position for the various Confidential accounts.
• Designed and developed a Treasury package which calculates the number of days on the

Confidential, Williamsport, PA

Responsibilities:

• Involved in the Customization of Oracle Apps 11.5.10 at Brodart, which is the premier supplier of circulation-ready materials to libraries and offers state-of-the-art online tools, bibliographic services.
• Designed, developed and supported various Forms 6i and for INV, OM and AR modules.
• Gathered business requirements and developed a customized customer search form which searches and returns a customer based on different criteria. This customer search form is zoomed from a couple of standard forms - Customer Standard Form (OM), Tele services (CRM). Along with this, it also returns selected customer number back to standard form.
• Designed and developed a custom form which searches for a particular sales order based on the sales order number, item, customer number etc.

Confidential, Boston, MA

Responsibilities:

• Involved in the Implementation and Customization of Oracle Applications 11i andconversion from 11.0.3 at SeaChange, which designs, manufactures markets and services semiconductor video equipment.
• Designed, developed and supported various Reports 6i and Discoverer 4i Workbooks for INV, OM, BOM, Shipping, AR, AP, Service Contracts and Customer Support Modules.
• Developed several Discoverer Workbooks in Service Contracts, Depot Repair, Customer Support, Order Management, Inventory and Work in Process.
• Conducted formal Discoverer End User (50 students) and Discoverer Administrator .

Confidential

Responsibilities:

• Involved in Oracle Applications 11.5.7 Implementation at Confidential which offers a wide range of automation technology for the plastics industry; ranging from individual robots for parts removal, to fully integrated factory automation for assembly, decoration, inspection, and packaging.
• Wrote the data conversion process to accomplish the following:
• Items identified for conversion from MAS90 were loaded into Oracle Inventory Master Organization. Around 5000 Approved Supplier Lists ASL were converted from MAS90 mainframe system into Oracle 11i Applications.
• Inventory Locators conversion involves in converting around 18000 inventory locators from MAS90 system into Oracle 11i.
• Developed Cross Translation utility (XREF) to be used as one procedure for all interfaces and conversion programs to translate data values between systems.