SKILL MATRIX

Confidential

New Projects/Support

• Did the requirements gathering, design and coordination of the following financials related projects
• Usage Billing Project
• US State Tax Project
• Polish and Hungary Daily Rates Interface
• Responsible for supporting existing Financials and HR customizations and developing new ones
• Supported Order Entry to Cash Cycle by troubleshooting interface/ data issues on a daily basis
• Assisted users during month end putting on hold required jobs, running them in time to generate required results
• Developed numerous XML publisher reports for invoice prints

R12 Upgrade

• Tested customizations and extensions before handing them over to business
• Involved in Payment Format programs in AP, redesign as per the R12 architecture.
• RBAC: Designed new Roles as per user requirement and assigned to users. Translated existing 11i permissions to new Roles

• Primary Functional and Technical Resource for the Implementation of Service Contracts and Depot Reapir
• Provided functional and technical Support for Supply Chain and Financials modules
• Designed new workflow process for auto pick release , auto shipment and fulfillment for a particular Order type
• Performed the required setups for Consolidated billing in AR.
• Designed a new customization for a planning tool to be used by warehouse planners for inventory replenishments.
• Dealt with business users to discuss process changes or introduce new Oracle processes.
• Developed XML reports and Discoverer worksheets for Customer Notifications and Order Aknowledgement reports
• Supported Third Party Application Clear Orbit which integrated to Order Entry.
• Managed Oracle Configurator. Did BOM Changes. Ran jobs to refresh and publish Configurator Models.Created and Maintained rules in configurator
• Developed a new set of Approval rules using AME to be integrated with Oracle quotes

• Production support of customizations around TeleService , Contracts, IB, TCA, Workflow
• Overseeing and troubleshooting the problems related to OM to OKS integration and OM to IB integration
• Wrote scripts to migrate data from legacy to IB for sytems having open contracts
• Wrote Scripts to expire systems for which new relationships were defined in Oracle
• Solving problems related to Charges integration from Telesales to OM.
• Resolving production issues related to pick release and shipping transactions form
• Maintaing customizations in OEOL and OEOH workflow

• Involved in the functional design of a Custom Application by leveraging the framework of iSupport and iStore
• As a technical developer, designed and developed a file based interface to send BOM, INSTALL BASE, Warranty data from Oracle to third party systems.
• Used BOM Explosion API bomoexpl for retrieving component information for Model BOMS
• Developed FTP scripts to be run nightly to transfer extracted data from Oracle to third party systems
• Developed a PL/SQL load program to load inventory Item information into iStore. This was an alternate to the standard program which Oracle provides

• Involved in 11.5.6 to 11.5.10 code upgrade
• Worked in to Quote to Cash Cycle.
• Modified programs to create quotes, create Orders/Contracts, Interface the contracts to AR and invoice the Contracts.
• Worked on OM to OKS and IB to OKS Integration.
• Did gap analysis between 11.5.6 and 11.5.10 data model and created a change document for the team
• Designed and Developed/modified code according to 11.5.10 standards in OKS
• Suggested easier ways to implement/create programs taking into consideration the upgraded environment
• Created new custom programs like Bulk Order Activation to activate multiple contracts with one click thereby replacing the manual process of approving and activation.
• Created new workflow for custom approval process of Quote Creation.

Primary Contact for Service Contract on the technical front

• Entrusted with the responsibility of making sure that custom programs developed integrate perfectly with OKS and the Contracts generated thereafter go through the entire life Cycle in OKS perfectly.
• Coordinated among team members and business for defining deliverables, time lines, test plans.
• Validated and guided the technical approach taken by other team members during implementation of projects.
• Thoroughly Conversant with Main Billing flow and the integration with AR as pertains Contracts Billing
• Worked thoroughly in the development and troubleshooting of various programs revolving around Usage, Single Counter and Dual Counter Machines, Rollovers, Contract Renewals process, Bill Streams and Level Elements, Contracts Main Billing.
• Developed a program Called Service Contracts Accruals. Purpose of the program was to calculate the total Contracts revenue that was due to the company at any given point.
• Developed a program Using Standard OKC APIs to Update Contract header and Contract Lines identified as corrupted.
• Developed a Custom Program Using Standard OKC APIs to Terminate Contract Lines identified as billing beyond termination dates.
• Developed a PL/SQL Extract to identify the contracts terminated by a particular order and the duplicates within them.
• Responsible for scheduling Bi-Weekly Billing run the task was to run, monitor programs over a weekend. Data validations needed to be done at regular intervals. Developed scripts to make a data fix if needed.
• Responsible for monitoring jobs during database downtime and planned shutdowns Put scheduled jobs on hold, coordinated with other team members. Monitored the jobs and released the jobs after the application server comes up.