Email: acrg8n@r.postjobfree.com

Mob: 919-***-****

Summary:

7.5 Years of Techno-Functional experience in solution analysis, design, development, testing,implementation and Support of Oracle Applications 11i&R12(OM, INV, AP, PO, GL,AR, PA, Workflow), Experience in various oracle tools like Reports, Pl/Sql, SQL and oracle database concepts.

Extensive experience in effectively managing Crisis and Escalation situations in Application production support.

Excellent skills in managing and driving escalations with cross-functional teams until resolution.

Strong understanding of Cisco OM and SOX processes.

Excellent skills in working with Cisco Support Projects.

Wide understanding of Cisco Tools.

Expert in Cisco OM (ordering and shipping) process.

Experience to support complex technical and Functional issues.

Involved in multiple projects which include implementation, Customizations development, Support and Maintenance.

Expertise on Month End, Quarter End and Year End close process and assists Client Managers and Specialists in all aspects of close process.

Knowledge of SOX and process documentation

Expertise in developing Reports, Interfaces, Alerts and working with APIs

Expertise in AOL, Sysadmin of Oracle applications 11i.

Proficient in Developing Inbound and Outbound Interfaces Using PL/SQL, Sql*Loader and Utl_File packages.

Having knowledge on Report and Forms.

Having knowledge on Business Objects Reports.

Education&Certification:

Bachelor of Computer Science, from Sri Venkateswara University, India in 2003.

Master of Science in Physics from Periyar University, Tamil Nadu, India in 2005

Master of Business Administrations from Pondicherry Central University, Tamil Nadu, India in 2012.

Oracle Certified Associate (SQL&PL/SQL) from Oracle.

Professional Experience:

Currently working as Techno-Functional Specialist in Zensar Technologies Inc, since Apr’ 2008.

Technical Profile:

ERP/Domain : Oracle Applications11i and R12

Modules Majored : OM, INV, PO, AP, GL, INV, Oracle Workflow.

Modules Minored : AR, PA

Operating Systems : Windows 2000/XP, Unix

Tools&Techniques : Ms Word, Excel and Power Point

Programming Languages : C, Core Java, SQL, PL/SQL

RDBMS : Oracle 8i, 9i,10g,11g

GUI’s : Reports 6i, Forms 6i, XML Publishers

Utilities : SQL * Loader, UTL_FILE

Tools : SQL*Plus, TOAD, SQL Developer, Remedy, Lotus Notes

Project Summary:

Project#5

Cisco Systems Order Management Production Support

Client : Cisco Systems Inc.,

Duration : Dec ’09 to Till Date

Role : Sr. Team Lead and Escalation Manager

Team size : 5

Environment : Oralce Apps11i&R12(OM, Inv, AR and Worfklow), Commerce Work Space, Remedy, SOM Scrubber, Status Tool, Toad, Webex, SSH, PVCS.

Description:

Cisco has implemented and customized ERP 11i Oracle Order Management (OM) in order to automate its order to cash business process. There are three teams supporting this application: CS support, OM Biz Support and OM IT Support. OM Biz support team plays a very critical role and resolves Techno-functional OM support issues. This team is also a facilitator that acts as an interface between OM IT support team and CS support team.

Responsibilities:

Own the support cases coming to OM Production Support Team, CPE Biz queues. Address it by resolving, triaging or forwarding to correct queues.

Knowledge of "ERP Super user" tasks for Oracle 11i, recommend system improvements, test, manage work flow matrix and organize system documentation.

Education of the OM, AR, MFG team and related teams regarding ERP changes

Understand the Cisco process and customizations of IC Engine, SOM Programs, Holds, Global Scheduling.

Have an understanding of Pricing, RMA, C3 programs, Customer setup/ flow.

Perform Order Management Setups.

Understand the validity and significance of PDF’s performed by OM IT Support team and provide post approval of Kintana patch in 24 hours of creation in order to meet SLA.

Coordinate with cross functional teams - CS, MFG IT, Biz groups and help resolve support issues.

Have hands on experience on Cisco Sales Order Work bench forms.

Have a fair idea of working of status tool, UG tool, Invoice tool and have ability to use SOM scrubber and change order scrubber.

Managing and driving Escalations until resolution by collaborating cross-functional Teams day to day.

Escalate / push cases that are taking time with cross-functional teams.

Identifying system abnormalities and intimate to Cisco Dev Team.

For system change impacting OM - attend all training, meeting and KT sessions, understand the changes, document / inform them for CS and reference.

Own the user training issues. E.g. a case is open due to incorrect understanding. If there is a case, it is with OM Biz.

Own cases where IT does not have an immediate fix for the system generated errors and which requires workaround (with different teams).

Address Ad hoc requests and have ability to write complex Oracle Sql querys. Provide queries and reports to requestors without using Support IT time etc.

Project#4

Cisco Systems Inc., SOX

Client : Cisco Systems

Duration : Sep’09 – Dec’09

Role : Techno-Functional Consultant

Team size : 5

Environment : Oralce Apps11i(OM,Inv,AR), Remedy, Webex, PVCS, Kintana

Version : 11.5.9

Project Profile:

Sarbanes Oxley (SOX) Compliance monitors controls for key enterprise-wide processes that have a direct impact on Cisco's financial reporting. SOX Compliance documents, standardizes, tests and reports on these key controls in IT and the business to meet annual legislative requirements.The rules and enforcement policies outlined by the SOX Act amend or supplement existing legislation dealing with security regulations.

Responsibilities:

Analysis of codes, Discuss with on site co-coordinator and users if required. Review and testing of SOX Controls (Monthly, quarterly, Yearly) as per auditor’s request.

All test evidences are delivered in time, test evidences for IT controls to perform SOX audits, SOD-RA, QCS- Controls, QAR-controls. R-DAC Validation, DB/ Schema validation, user validation, new report testing and validate data from front end with backend, test evidences for IT controls non IT controls, ACL registration, working on kintana packages for ELC-report, working on PDF packages to get business approval, working on PVC'S to get the code. Working on ONC PCC to test the samples, Preparation/Modification of queries which are regularly used in work. One escalation from on site for the report CSC-006c. Along this I improve My technical skills by brushup my knowledge on oracle reports, PL/SQL,OM related stuff which is use ful in my daily work activities. I handled the complete OPUS UAC for this quarter and also I am handling the UAC for AE and CCRM, I also doing the CCRM reports testing with support of CCRM team. I completed the 2 reports 1.Cisco Service Contract Hold Details Report and 2. Cisco sales general by GL Account report successfully. I also updated the document for OPUS UAC testing because the query which was earlier used is changed, the document which I updated is useful for all to get detailed information on this. I have taken an initiation step to start CCRM and AE UAC testing which is earlier I am not aware. I have proactively working on RDAC invalid logs. Till now I have completed all action items in time. There is no pending items.

I delivered all test evidences in time, test evidences for IT controls to perform SOX audits, SOD-RA, QCS- Controls,

R-DAC Validation, DB-Schema validation, user validation, new report testing and validate data from front end with backend, test evidences for IT controls non IT controls, ACL registration, working on kintana packages for ELC-report, working on PDF packages to get business approval, working on PVCS to get the code.

Worked on Cisco Service Contract Hold Details Report.

Project # 3

Electronic Arts(EA)- Daybreak Build, Nordic Support and ABC migros

Client : Electronic Arts(EA)

Duration : Jan’09 – Aug ’09

Role : Techno-Functional Consultant

Team size : 7

Environment : Oralce Apps11i(OM,PO,Inv ), Oracle 9i, EDI,TIBCO, Windows XP, SSH.

Version : 11.5.9

Project Profile:

Daybreak:

Daybreak solution will leverage existing European Oracle e-biz implementation on an existing technology infrastructure. Oracle E-biz has already been implemented for all countries related to Daybreak project, and they are using are using most of the E-biz core modules. The only difference that daybreak project will replace ENS warehouse serving Nordic countries and Finland will move out CEO warehouse. Eventually all EU countries along with emerging markets will move out of CEO to Arvato. Thus finally both ENS and CEO operations will be replaced by Arvato.

Conceptually the hub will have two primary components - the ERP Interface (ERPI) and the Trading Partner Interface (TPI). Broadly, these interfaces can be classified into two categories – inbound and outbound. The inbound interfaces are the set of document/message types that the trading partners send to EA. The outbound interfaces are those that EA transmits to its trading partners.

For outbound interfaces the process for a particular transaction in the ERPI component extracts all the transaction records for that transaction type from the ERP interface tables, builds a common data model (CDM) object and publishes it on a topic for that transaction type. For inbound transactions, the ERPI receives transactions as CDM objects through the messaging bus and stores them into the ERP database

Using TIBCO will configure all the message types for Arvato in Day Break Project.

CRMIS service is basically implemented to enable the interface between AV-NOI and EA to share the MIS reports details. CRMIS Process added to send CRMIS file once MIS report has been generated by AV-NOI.

Using the AV-NOI CRMIS process TIBCO sending required data for CRMIS to EA.

Nordic:

The primary goal of the Nordic Order to Cash project is to optimize European supply chain efficiency and thus achieve cost savings for the EA business in the Nordics region. In order to achieve this, the existing ENS managed service in the Nordics (for EA Norway, EA Denmark and EA Sweden) is to be terminated in April 2009, and the business repositioned as follows:

The Order to Cash (O2C) processes are to be “in sourced” and aligned to the existing European O2C processes used by other territories.

The Warehouse Management and Distribution processes to be re-located to a new 3rd Party Logistics (Arvato) provider that will be enabled as part of Project Daybreak (CEO replacement),

The EA Finland processes (which are already run internally by EA) are to be aligned with the EA Norway, EA Denmark and EA Sweden solution i.e. alignment of the Order to Cash processes and a consolidation of warehouse management and distribution services to be delivered by the new 3PL warehouse.

Nordics O2C solution will leverage existing European Oracle e-biz implementation on an existing technology infrastructure. Oracle E-biz has already been implemented for Nordic countries, and the Nordics are using most of the E-biz core modules. The only difference that this project brings is to enable the O2C cycle modules for higher volume of customer transaction and receipt activity, and a rearrangement of process and task ownership. The re-arrangement of Nordics O2C process ownership will result in some business processes (eg, Sales Administration) to be managed in-house by EA, and other business processes to be managed by a 3PL (to be decided by Daybreak) other than the existing ENS warehouse.

ABC migros:

MAGROS’ is ABC’s one of the major customers. MAGROS is connected to ABC through EDI interfaces. Presently ABC uses EDI ORDER Outbound, EDI DESADV outbound and XML INVOICE outbound. EDI PRODAT Inbound comes to ABC server but ABC is not using that file.

Responsibilities:

Developed defaulting the shipping method in the order line level by using defaulting rules.

Developed defaulting the shipment priority in the order line level by using defaulting rules.

Developed Update the item planned released date from ODS system by using dblink.

Involved in customization of shipping request details to send to 3pl.

Defined the functional setups like price list, Item and order type’s setups so on.

Involved to process the messages SHPREQ, DESADV, POOUT (Inbound & Outbound interfaces).

Involved in Nordic Support.

Developed Non customer items in the order, send those details to the customer by using alert.

Customized the Order form not accepting the Non customer items in the order line by using Logical Apps.

Project # 2

Dairy Crest(DC)- Milk&More

Client : Dairy Crest’s Milk&More

Duration : Sep’08 – Dec'08

Role : Techno-Functional Consultant

Team size : 5

Environment : Oralce Apps11i(OM, Inv ), Oracle 9i, Windows XP, SSH

Version : 11.5.10.2

Project Profile:

Dairy Crest Limited is the UK’s leading chilled dairy foods company. The company has got 1.4 million customers that include traditional doorstep customers, food service customers and online customers. Dairy Crest hence forth will be called DC, has launched an interim website www.milkandmore.co.uk. By launching this Milk & More web site DC is aiming to add new on line customers and also encouraging the traditional (Off line) customers to become on line. DC has made it easier for customers by providing on line service that is more convenient and flexible. DC offer on line apart from milk in glass bottles, a range of products including lunch box, cereals, juices, household products, and organic produce.

Responsibilities:

Developed Remove Orders holds on customer account reinstate.

Developed Set Orders on hold on Customer account suspension.

Developed Cancel the customer orders on line level up to Repayment.

Developed Product Decommissioning.

Developed Replace new product instead of decommissioned product.

Developed Customer Account Suspension.

Developed Update the product attributes and make them not-available in Inventory.

Project # 1

Activision

Client : Activision.

Duration : Apr 08 to Aug 08

Role : Technical Consultant

Team size : 7

Environment : Oralce Apps11i(OM, Inv ), Oracle 9i, Windows XP, SSH

Version : 11.5.10.2

Project Profile:

Activision is a worldwide pure-play on line and console game publisher with leading market positions across all categories of the rapidly growing interactive entertainment software industry. Headquartered in Santa Monica, California, Activision Blizzard, Inc. Activision Blizzard maintains operations in the U.S., Canada, the United Kingdom, France, Germany, Ireland, Italy, Sweden, Spain, Norway, Denmark, the Netherlands, Romania, Australia, Chile, India, Japan, China, the region of Taiwan and South Korea.

Responsibilities:

Developed Reports by using Oracle Reports 6i.

Functional Setups as per client requirement..

Involved in Requirement gathering and assigning tasks to Team.

Contact this candidate