SUMMARY

• Sr. Programmer, process consultant with passion, innovation and a future - oriented vision, 9+ years of experience in implementing the full software system development life cycle in defining, designing, building and managing various projects across different sectors and technologies.
• Hand on experience in wide range of Business Operations specializing in Oracle modules like Quote to Cash, Sales and Channels, Distribution, Strategic Pricing Management.At my current role at Cisco Systems Incorporation, have been leading as a Sr. Programmer Analyst:
• Trade Agreement Act: The Trade Agreements Act (TAA) is a requirement for US Governmentprocurement of all “end products”. “End products” are defined as those articles, materials and suppliesto be acquired for public use. Within Cisco systems, “End Product” is interpreted to mean each “line item” onthe purchase order. TAA requires that all products supplied on a contract valued greater than $203,000be manufactured or substantially transformed in the US or a TAA -designated country.
• TO Xtrack Pricing Waterfall Finance: Strategic pricing and finance team is a group drivingstrategic requirements improving overall Pricing process which in turn helps in generating more Ciscorevenues and helps Sales to improvise day to do business. This project called Sales discount guidanceproject is to come up with a dash board to help Account Manager of Cisco to give a betterunderstanding of customer historical transactions for a specific deal.
• Sustenance and Optimization (S&O) List Price/Price lists in Oracle 11i/R12 (ERP):Sustenance and Optimization (S&O) group is a part of Cisco Pricing and Discounting Org. This groupis responsible for stabilizing, analyzing, providing short term and long term analysis to criticalproduction issues. S&O group is responsible to analyze issues on List price and List to net price forcisco products and services.
• Country Enablement is centered in extending Cisco’s sales model and incountry presence to better meet customers’ expectations for higher levels of accountability, localengagement and global consistency. For India, Brazil Country enablement, Pricing and discountingwill be enabling the new India, Brazil buy-sell entity with price list in Indian Rupees, Real (the localcurrency). There is a need to perform quoting and ordering in INR, Real currency.
• Advanced pricing applications (List Price, Price list, Discount modifiers) run the business enhancements:Pricing and discounting services belong to Cisco Quote to Cash (Q2C) group. This consists of a set of internaljava applications and web based services which help in calculating the final net price after applying series ofdiscounts on various products and services.
• Confidential Demand Planning Implementation: This project is an Implementation project. The tool

TECHNICAL SKILLS

Manufacturing: Advanced Pricing and Discounting, Oracle Supply chain, Quote2cash cycle, Inventory, Configuration, Bill of material (BOM), B2B, Costing, Purchasing.

Finance: Oracle ERP modules: Accounts Payable, Accounts Receivables, fixed assets, General Ledger

Languages/Development/Productivity Tools: Oracle Developer, Oracle database, SQL*Plus, PL/SQL, TOAD, Microsoft Office Visio, Business Objects, Microsoft word, Excel, Power-point, Outlook

Testing Tools: Action Item System

Patch Migration Tool: HP Quality Center, Mercury Interactive Suite (Win Runner, Test Director & Load Runner)AXSYS

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Drive extensive meetings with all cross functional tracks to work on end to end business solution.
• End to end business solution includes from new product introduction, pricing of new products in price list, quoting, configuration, sales order, dispatch and invoicing.
• Worked in Oracle R12 environment (ERP) on modules likes advanced pricing, quoting, order2cash.
• In Oracle 11i environment on inventory, forecasting and demand planning, configuration rules, product end of life cycle.
• Perform deep dive working sessions to clarify and narrow down high level business scenarios, architectural design into exact business requirements.
• Build AS-IS, TO-Be process flows, end to end system flows necessary to build business or functional specification documents.
• Worked closely with End users, Business Users to prepare and update Business Requirement document (BRD) and Functional Requirement Document (FRD) for long term solutions. Developed system process flow diagrams using Microsoft Visio.
• Identify requirements to “operationalize” supply chain process like inventory segregation, more accurate scheduling, reduce fulfillment lead time, improved forecasting ability for better demand management.
• Utilized Quality Center for directing, tracking defects and outlining needs during project SDLC process.
• Worked in escalation and exception handling processes, supporting data, post go-live business support and maintenance and data migration and conversion requirements.
• Formed detailed User Acceptance testing (UAT), Business Acceptance testing (BAT), managing system level testing during pre-go live and go live period of major releases.
• Preparing training materials and carrying out end-users training sessions working globally after every major release.
• Drive Policy impact assessment with legal and Contracts, Policy, Global Tax and Customs.
• Participate and/or Initiate in fact finding discussions, gap analysis and documents.
• Participate in all major toll gates: Business Commit, Concept Commit, Executive Commit, Dry run, Go-Live, and Launch.
• Involved in Project Scope Document creation, Organization Adoption Strategy.
• Plan and drive the User Experience Walkthrough to receive sign-off from program team and key stakeholders on To-Be process.

Confidential

Responsibilities:

• Upgrade of Oracle Applications from version 10.7 to 11i.
• Migration of customizations from 10.7 to 11i.
• Setting up Payment Programs and Payment Formats for check printing customization.
• Unit & Integration: Testing standard test cases on (setups, forms, reports, transactions old and new). Testing Custom objects like forms, reports and interfaces on upgrade Test instances.
• Preparing the Unit Test Cases, Check-list, performing Peer Review for the Build Components.
• Development of reports for various Oracle Applications modules such as Purchasing, Receivables, Order Entry, Inventory using Oracle Reports.
• Created Oracle pl/sql program to enable Invoice terms flowing over from Order to be updated before the Orders are interfaced from Order entry to Accounts receivable.
• Extensive use of RDBMS, SQL concepts to build data level objects which includes designing ER Diagrams, Tables creation, Indexes, sequences, synonyms, database triggers, constraints and snapshots.
• Preparing the Unit Test Cases, Check-list, performing Peer Review for the Build Components.
• Using automation testing tools like win runner, load runner to generate test scripts in Oracle financial ERP modules.
• Developing, validation of test automation tool script in General ledger, Accounts Payable modules in Oracle application ERP of 11.5.10 version.
• Review of functional documents.
• Debugging complex SQL, PL/SQL programming code to resolve critical errors in production environment.