Professional Summary:

Over 8 years of IT experience as an Oracle Techno Functional Consultant using Oracle Applications 11i and R12 across various modules with Strong SQL and PLSQL Skills

QUALFICATIONS SUMMARY:

• 8 years of IT experience in Design, Implementation, Support, Upgrades, Coordination, Interfaces, Conversions, Customization, Testing and Documentation of Oracle Applications across different versions.
• Expertise in Solution Customization Cycle involving Business Requirement Study Problem Identification AS IS Business process mapping with product Gap Analysis Customization Finalization TO BE Change Management for Customization Solution Implementation, UAT Support
• Have hands on experience in Order Management OM , Advanced Pricing , Supply Chain SCM , AOL, Advanced supply chain planning ASCP , General Ledger GL , Trading community Architecture TCA , Accounts Payable, Accounts receivable and Oracle Projects Modules
• Have Sound knowledge on Service contracts and Install Base modules.
• Hands- on Experience on Order to Cash cycle and Implementation of New organization in Supply chain Module
• Hands-on experience of RICE components design and development in Oracle Applications 11i Technical knowledge in using database back end tables for querying and reporting purposes.
• Worked on creating PLSQL Interface packages using standard Oracle APIs for Order Management, Pricing, Oracle Projects and AOL modules
• Have good knowledge in tools like Kintana, Quality center, TOAD, PVCS, SVN, Dollar Universe.
• Experience in developing forms using Oracle Developer tools like Forms 6i and 10g
• Experience in customization of the Oracle workflows to suit the business process needs.
• Good Exposure on Tuning of SQL Queries to improve performance of a system, Tables using Optimization Techniques through Explain Plan.
• Developed functional and technical specifications as well as test plans and test scenarios using AIM methodology and documents such as BR 100, MD 50, and MD 70.
• 3 years of experience working as Onsite and Offshore model and co coordinating with the offshore team and with the clients to meet the requirements and deadlines.
• Good experience in working with cross functional teams and effectively driving the meetings with Business and IT counter parts in both gathering the requirements, resolving issues and testing activities.

Presently working on the R12 and 11i setup configurations for Order Management module

TECHNICAL SKILLS:

Professional Experience

Confidential

CoOracle Pricing

Confidential is business initiative where all service sales business models are enabling on new standard systems CG1 instance with standard industrial practices. Enhance global capabilities through leveraging Oracle out of the box capabilities within R12 ERP OM and AR instances. Accelerate Cisco's time to market and expand our reach into new markets and to reduce system and process maintenance costs

Responsibilities:

• Worked on the providing solutions for Business requirements.
• Implemented the new requirement related to the Header level Discounts on manual orders using modifiers and Qualifier setups.
• Made changes to the pricing integration package to send the new discount details as per the business conditions
• Worked on modifier and qualifier migration from 11i to R12 using public API
• Worked on identifying/ owning OM related setups like OM Holds, validation templates, processing constraints, Transaction types, Defining and Assigning Document sequences, Defaulting rules, Attachment categories , OM system parameters
• Worked on the AOL setups needed for the flow like Value sets, validation values, Descriptive flex fields, Functions, Menus, responsibility creation, its profile option values and Lookup codes
• Analyzing the defects related to them and resolving as needed in daily basis
• Coordination with offshore team of 4 working on the above setups
• Supporting the transition activities for the release like TCA, TCB, FPR and Golive

Environment: Oracle Application R12, Oracle Order Management, Oracle Advanced pricing SQL, PL/SQL, TOAD, Kintana, SVN repository tool, Artifactory, Quality Center

Confidential

Oracle Techno Functional Consultant

As part of Large Scale services LSS R12 implementation for Trading Community Architecture TCA module is the key project and setting up the organizations in R12 environment

Responsibilities:

• Worked on the providing solutions for Business requirements.
• Worked on conversions to customer data from 11i to R12
• Implemented the new business enhancement to create duplicate customers with a special account type attribute
• Worked on the AOL setups needed for the flow like Value sets, validation values, Descriptive flex fields, Functions, Menus, responsibility creation, its profile option values and Lookup codes
• Analyzing the defects related to them and resolving as needed in daily basis
• Coordination with offshore team of 4 working on the above setups
• Supporting the transition activities for the release like TCA, TCB, FPR and Golive

Environment: Oracle Application R12, Oracle Order Management, Oracle Advanced pricing SQL, PL/SQL, TOAD, Kintana, SVN repository tool, Artifactory, Quality Center

Confidential

Oracle Techno Functional Consultant

As part of Large Scale services LSS R12 implementation for Inventory module is the project and setting up the organizations in R12 environment

Responsibilities:

• Worked on the setting up Inventory organization.
• Worked on the setups to define Organizations, Organization Parameters, Defining locations, sub inventories, Unit of measure, Defining Conversions, and setting up the org for Container Items
• Worked on the Deliver setups like Shipping parameters, Release rules, ship confirm rules, defining freight carriers and ship method codes.
• Worked on the AOL setups required to support like Lookups, DFFs
• Coordination with offshore team of 4 working on the above setups
• Supporting the transition activities for the release like TCA, TCB, FPR and Golive

Environment: Oracle Application E-Business Suite R12, INV, BOM, Oracle 10g, TOAD, Kintana,PVCS, Quality Center

Confidential

Oracle Techno Functional Consultant

Confidential implements the Cisco Planning module into new R12 environment and adds all the organizations as part of various releases

Responsibilities:

• Worked on adding the inventory orgs to ATP-Plan and MPS Plan
• Owned the setups like defining the organizations in the instance, Defining Supply chain planning parameters, Sourcing rules, Defining Organization security, Planning parameters, Defining Plan names and Plan options, Defining and Assigning Allocation rules
• Worked on the AOL setups required to support like Lookups, Profile options
• Coordination with offshore team of 4 working on the above setups

Environment: Oracle Application E-Business Suite R12, Advance supply chain Planning Oracle 10g, TOAD, Kintana,PVCS, Quality Center

Confidential

Oracle Technical Consultant

Confidential on the Sourcing Module. Cisco uses an outsourced manufacturing model in which CM build PCBA and assemble and test the final product. A sourcing and costing tool that will enable the organization to better align the processes and drive end-to-end cost management. As part of the team need to work on the Production issues that are present in the functionality as of now.

Responsibilities:

• Analyzing the Customizations by Cisco to the Sourcing Module.
• Also working on the MRAP and CIP reporting tools which are developed on the Manufacturing side and analyzing on the enhancements that are presently in discussions with Biz.

Provided extensive user support during UAT and Post Production phases

Environment: Oracle 11i Sourcing, TOAD, Kintana, PVCS,Quality center.

Confidential

Oracle Techno Functional Consultant

The 3 node architecture of C3 database is now transformed into 12 node architecture. Service mappings are being created application wise and made sure that all the teams use their respective service mappings to connect to the database from their respective tools such as TOAD, JVM connections etc. Large numbers of changes were needed in the Concurrent manager setups so as to make sure that all the applications are running on their designated node only to achieve the load balance.

.Responsibilities:

• Analyzed and made changes to the Concurrent manager setups such that they point to their designated Nodes.
• Analyzed the behavior of the requests getting submitted in TCB instance on daily basis and made changes accordingly.
• Have been monitoring the status of Requests in Production on daily basis and making sure that no request should encounter issue due to Concurrent manager changes or should wait for a long time due to the number of processes that are allotted to each Manager.

.Environment: Oracle Applications 11i, PL/SQL, SQL, Kinatana, PVCS, Quality center

Confidential

Oracle Techno Functional Consultant

Contract Health check report gives the total information of the possible errors that can be encountered while creating a Quote. All the errors are collected in to an excel sheet and will be sent to the requestor for him to analyze the health of that particular contract he/ she selected.

Responsibilities:

Involved in the Development of PLSQL Interface package that performs CHR functionality

Involved in Issue fixing and few changes that came in later point of time due to change in Business requirements.

As part of development team worked on the performance tuning of the SQLs to meet the SLAs of the CHR report

Worked as an Onsite and Offshore model and coordinated the things from Business to the team.

Environment: Oracle Apps Implementation Release 11, TOAD, PL/SQL, Kinatana, PVCS, Quality center

2TNG OCM Mar 2011 Oct 2011 Cisco Systems Inc, Sanjose CA

Oracle Jr. Functional Consultant

Online Contract Management is a separate track in the Cisco CSCC application which deals with the maintenance of Contracts which are being created. As part of this project, 2Tier architecture is being introduced and the corresponding changes for OCM are being implemented. Previously Users are differentiated as Internal and External Users. Now as per the new architecture, the external users are being classified into Distributors, resellers and 1Tier partners differentiated by the roles and level of accesses. Aim is to retire the existing SMS3 architecture.

Responsibilities:

• Prepared the Technical Design document as per the Functional requirement and implemented the changes successfully.
• Changed good number of existing PLSQL packages and SQL queries to meet the requirements
• Supported the testing phase of the cycle and worked on some of the defects and issues.
• Performed performance tuning for the major SQLs to reduce the waiting time
• Worked as on Onsite and offshore model from Onsite and coordinated with Business requirements and the team

Environment: SQL,PLSQL, Kintana, PVCS, Quality center

Confidential

Oracle Jr. Functional Consultant

Confidential is trying to add 20 new Operating units in addition to the 5 Operating units existing. As part of STC 2.0 Cisco International ConfidentialOperating Unit is being implemented. This involves setups across many financial modules such as GL, AP, and AR

Responsibilities:

• Performed and automated the Transaction types setup under Order Management module
• Performed setups such as Defining key flex fields, Creating Set of Books, Locations under General Ledger Module
• Performed setups such as Tax names and groups, Supplier setups under Accounts Payables Module
• Involved in performing Transaction types, Transaction Sources, Auto accounting under Accounts Receivables Module

Environment: Oracle Applications 11i GL,AP,AR SQL,PLSQL, Kintana, PVCS, Quality center

Confidential

Oracle Technical Consultant

Responsibilities:

• Automated the AOL setups and reduced the load of Kintana packages to be created because of the large number of configs that came as part of the release
• Made sure that the naming standards and other things are implemented.

Environment: Oracle Applications 11i AOL SQL,PLSQL, Kintana, PVCS, Quality center

Confidential

Oracle Technical Consultant

Oracle Projects module is being implemented in Cisco as part of Q3FY09. APC Managerial services team restricts the user access in testing instances. So as to perform the setups in Stage instances and Production, Projects team works closely with the setups team to perform them. The setups include AOL configs as well as core Projects setups

Responsibilities:

• Did several setups including Project Costing, Project Billing, Project Foundation, Project Resource Management
• Analyzing the functional flow and performing various setups in the above module and sub modules.
• Automated setups such as Defining Organizations, Defining Org Hierarchy, Defining Auto accounting Rules setups.
• Closely worked with the Projects team on the changes that were coming up in the testing phase.

Environment: Oracle Applications 11i Oracle Projects SQL,PLSQL, Kintana, PVCS, Quality center

Confidential

Oracle Technical Consultant

APC team works with the code migrations of the AOL configs and other data of different tracks present in Cisco from DEV instances to Test instances and further to Production as part of different releases. The main aim of this team is to act as a governing body to maintain the data as per Cisco standards. It also deals with the scheduling and monitoring of concurrent programs through a tool called Dollar Universe. Oracle Projects module is implemented in Cisco and the related application setups are being performed in staging instances and production by APC team.

Responsibilities:

• Involved in the migration of AOL configs using the tool kintana.
• Automated several setups using standard Oracle APIs.
• Worked on the Concurrent program scheduling tool called Dollar Universe.

Environment: Oracle Applications 11i AOL,OM, INV SQL,PLSQL, Kintana, PVCS, Quality center