OBJECTIVE:

• I am seeking opportunities to utilize my Business Process, Technical and Applications Consulting expertise to implement and provide solutions for Oracle E - Business Suite 11i and R12 Application implementation projects.

SUMMARY:

• Functional and technical expertise in implementing Item Master, Quoting, Approval Management (AME), Advance Pricing, Incentive Compensation, Service Contracts, CRM Foundation Components, Tele Service, iSupport, HTML Service, Depot Repair, Knowledge Base, Install Base modules of Oracle EBS.
• AIM SDLC methodology-based expertise in business flow accelerators, global blended delivery project management, business analysis, process re-engineering, design, development, testing, migration, and support.
• Proficiency in design, development and implementation of Custom extensions and solution for Quoting, Advance Pricing, Incentive Compensation, Install Base, Service Contract, Service and iSupport modules of Oracle EBS using Oracle Applications and Database technologies
• Extensive experience in providing solutions with Data Conversions mapping of Legacy data to Oracle Open Interfaces and customizations using Oracle PL/SQL, Forms, Reports, Workflow, Application Object Library (AOL), System Administration.
• Proven success in planning, managing, and coordinating in-house and offshore custom development, integration, and testing efforts.

TECHNICAL SKILLS:

Application: Oracle E-Business Suite R12/11i, Siebel CRM On-Demand, Baan ERP

Database: Oracle 8i / 9i / 10g / 11g, Sybase, SQL Server, DMSII, DMS1000

GUI: Oracle Forms 6i / 9i / 10g

Language: PL / SQL, SQL*Loader, SQL, SQL*Plus, Shell Script, VB / VBA, Java, JSP, JavaScript,Delphi 7.0, HTML, DHTML, Shell Script, IIS, .NET, C#, ASP, VBScript, XML, C/C++, Java,Java Script, ActiveX, ADO, COBOL, PROGENI, WFL

Tools: Discoverer, SQL Developer, Data Loader, Toad, Oracle JDeveloper, MS Visual Studio,Crystal Reports, S-Designer, ERWin, ETL, MS Project, MS Power Point, MS Word, MS Excel, Visio

Methodology: Application Implementation Methodology, Oracle Unified Methodology

Hardware: Windows, HP UNIX, SUN Solaris, Linux Red Hat, Unisys A-Series, COMS, GEMCOS

PROFESSIONAL EXPERIENCE:

Confidential

Functional Lead (SME)

Responsibilities:

• Oracle Incentive Compensation & Resource Manager Modules:
• Re-implementation of OIC module for Spine Subdivision in new instance
• New implementation of OIC Module for Ortho-biologics Division
• OIC Instance parameters, product classification and revenue classes setups.
• Collection process setup with direct and indirect column mappings, triggers and filters
• Complex SQL queries to extract data based on division, products, territories, salesperson and sales hierarchy for data validation, Commission Analyst functions and reconciliations
• Analysis and Assembly of Standard and Special Compensation Plans for Dealers, Distributors, Specialists and Regional Managers based on Geography, States, Named Accounts, Hospital names and Doctors/Surgeons names.
• Setup of Compensation Plans for Bonus payouts based on Quota s
• Define and import employee from HR module and Supplier contacts AP module
• Define and setup Roles, Groups and Roll-up hierarchy for Resource Manager integration
• Auto-transfer setup for Dealer and Distributor payments to Accounts Payable
• Ad-hoc reports, custom dealer statements and SQL queries for user support and data validations
• User and system support
• Inventory Module
• Define and setup of Inventory Categories
• Define and setup Sales and Marketing Categories identifying attributes division, Sub-division, brand, product class and product type
• OIC-Collection process configuration using direct/indirect mapping and post collection triggers to collect data from AR Invoices and External Sources
• Analysis, transformation and implementation of complex Commission Plans based on Divisions, Organization Hierarchy, Sales Hierarchy, etc.
• Implementation and calculation of monthly, quarterly and yearly target dependent Bonus Compensations for Sale force and Dealers.
• Integration with Resource Manager - Import and maintenance of Resources/Supplier Contacts, Planning and Assignment of Groups, Transaction Rollup Hierarchy and Roles.
• Integration with Territory Manager - Qualifier setups, Territory assignments for Sales Reps/Dealers based on divisional qualifiers and territory distributions.
• Complex SQL queries used for ad-hoc reporting, data validation/reconciliation and to perform data to day functions
• Custom Rice Objects:
• Design and implementation of Custom Territory based Bonus calculation for Sales reps using custom tables, PL/SQL packages and Compensation plans
• ADP Report for commission/bonus payouts for Employee
• Division based custom sale representatives and dealers Statement
• Automatic assignment of sales reps to order lines based on Assigned Named Accounts, Geographies and/or Product Categories triggered from order booking event
• Daily Order and Invoice MTD reports for Sales reps and Managers
• Multi-divisional, multi-currency, cross- with identical Integra or competitor products Quotes
• Ability to check product price and discounts, customer details and payment terms, change product price or discount percent at header and lines
• Flexibility to set quote expiration date based on divisional requirements, Cross identical Integra or competitor products
• AME setup for static and dynamic approvals based on product discount matrix and Sales hierarchy
• SFDC Quote Integration with Oracle Quoting and Pricing modules
• Custom RICE Objects:
• Create discount modifiers from quotes upon final approval of the quote
• Create discount modifiers for multiple accounts from quote
• WEBADI object to upload quote lines to a quote
• Quote with trade-in items
• Display MSRP, list, contract or discounted prices, trade-in value on the quote
• Calculate gross margin at product and quote level
• Oracle and email notifications of approval requests
• Alerts to Sales Operations, Pricing Team and Sale Reps for approved quotes
• Quote print in secure PDF format with additional details like customer payment terms, Notes, T&C, trade-in details, additional/bundle item details, accessory item details, attachments, etc.
• Restrict price or discount for restricted price products in pricing module
• Excel export to view all active discounts for a customer
• Identify products discounted outside the contract pricing for a quote

Confidential

Functional Lead (SME)

Responsibilities:

• Business Requirement gathering and Business Process analysis. Creation of Requirement Traceability Matrix (RTM) with Map and Gap analysis.
• Mapping and Configuration of R12 Service Contracts and Install Base modules for multiple business organizations. Creation of Configuration Setup Documents (BR100) to configure modules.
• Analysis and creation of Functional Design documents (MD050) for Conversion, Custom Extensions and Reports.
• Data conversion analysis and mapping from different sources like Oracle 11i and legacy Solomon/Internal systems. Creation of Conversion Design Document (MD050) and Data Mapping Templates. Coordination between different data extraction and import teams (US & Offshore). Validation of extracted and converted data
• Evaluate, Analyze, Map and Document custom reports for Business Reporting requirements
• Provide Solution, Design and Documentation to fit business requirements with Custom Extensions like Subsidy, Non-Standard Billing, etc.
• Preparation and execution of System Test and System Integration Test sessions.
• Creation of Test Scripts aligned with the RTM using User Productivity Kit (UPK) and Excel format.
• Integration with SFDC and other systems like Decision1, LMS, etc.

Confidential

Consultant

Responsibilities:

• Co-Term of Service Contracts based on Solution Ids - Custom extension to renew and consolidate selected contracts based on Solution id with proper validation.
• Additional Data Transfer from Sales Orders to Service Contracts - Concurrent program to run on schedule intervals to transfer addition info like End User, Reseller and Solution Id from Orders to Service Contracts.
• Activation Process - Custom extension to facilitate user activation process by transferring ownership of Install Base and Service Contracts and terminating existing Stock Contracts.
• Install base and Service Contract Conversion - Developed data mapping and conversion programs to convert and integrate Install Base and Service Contract data with existing production instance.

Confidential

Principal Business Analyst/Applications Developer

Responsibilities:

• Requirement gathering, defining business process flows (BP080), requirement documents (MD050), technical design documents (MD070), configuration documents (BR100), installation Instructions (MD120)
• Multi Organization, Business Units, Divisions and Currency deployment
• Implementation of complex comp plans based on Business Units, Divisions, Organization Hierarchy, Sales Organization, etc.
• Implemented dispute resolution leveraging Oracle Tele Service and iSupport modules
• Custom Solution to distribute Compensation Plans/Supplements with hierarchal approval process
• Design of territory based Sales Rep assignment engine (OIC-Pre-Processor) and developed custom extension for allocate multi sales credits
• Customized Plan Copy extension to copy Comp Plans from one instance to another
• Configured OIC-Collection process to auto collects revenue transactions from Orders, Invoices and External Sources
• Configured Sales Hierarchy to pay managerial rollups through OIC calculation engine
• Custom XML Reporting like Auto generation and distribution of consolidated yearly Sales Rep Statements, Over Achiever Report, Stack Ranks Report, etc.
• Managed implementation projects including liaising with off-shore development teams
• Worked with business users to get signed off on Requirements, System Design and TestingInvolved with setups, work flows, maintenance, bug fixing, and modification of the application.
• Analyze, develop and implement enhancements and customizations
• Creating functional and technical design and solution documents
• Working with Oracle support and off-shore development teams to address the bugs, modifications, patches and new releases
• Managed projects to roll out modules for new divisions, Mergers and Acquisitions, under the overarching principles of Oracle AIM-based SDLC
• Drove a successful initiative to upgrade to latest versions of Service and Support applications, which were over 2 years behind
• Implemented Oracle HTML Service and isupport module for Focus group
• Rolled out of Oracle Tele Service, iSupport and Knowledge base modules for acquired companies (Tegic, SpeechMagic, eCopy, etc). Steps include operations analysis, business process re-evaluation, requirement gathering, application and workflow setups, data conversion and multi organization implementation.

Confidential

Responsibilities:

• Requirement gathering, defining business process flows (BP080), requirement documents (MD050), technical design document (MD070), configuration document (BR100), installation Instructions (MD120)
• Involved with setups, work flows, maintenance, bug fixing, and modification of the application.
• Analyzed, developed and implemented enhancements and customizations
• Engaged with business process flow analysis, gap analysis, integration planning and implementation of mergers and acquisitions
• Solutions for new business requirements and shifts
• Designed and developed custom Invoice and Commission Reports

Confidential

Responsibilities:

• Upgrade Applications Technology Group Rollup Patch Set7 (ATG RUP7)
• Upgrading to JRE to replace J-initiator with standard Java,
• Upgrade DB 9i to 10g
• Replacing Unix with Linux,
• Upgrade Sun w/10g upgrade and Linux w/10g
• Upgrade Linux w/10g upgrade and Linux w/11gR2
• Upgrade Sun w/10g upgrade to Linux w/11gR2 with 2 application/db servers with load balancing
• Identify patches and customizations
• Create and run test scripts and scenarios
• Identify and resolve application and customization issues
• Conduct CRP and UAT sessions with KBUs and BPOs
• User Validation and Approval sign-off
• Production deployment and validation

Confidential

Responsibilities:

• Involved with operations analysis, business process re-evaluation, requirement gathering, application setups, data conversion
• Setups, testing and evaluation of CRP1, CRP2 and UAT cycles of the project
• Developed data mapping, extract/load programs to convert data from Legacy CMS and BAAN ERP systems for Product, Customer, Service Contract, and Install Base modules
• Worked with offshore consultants to load data into the Oracle database as well as solving the data load errors issues logs

Confidential

Responsibilities:

• Expense Reporting System (ERS): Developed enterprise Expense Reporting System using C#, Web Services, ASP.NET and Oracle. Designed and coded the web user interfaces using Web Forms to facilitate business policies and approval processes. Developed Objects for use in the system using C#.
• Contract Management System (CMS): Built this mission critical system with a three-tier web based architecture and wrap around methodology that share real time data with ERP System to channel companies service revenue (Approx. 100 Mil) by maintaining user warranties and service contracts of sold products. Also developed batch processes like Sales Orders, Business Partner’s Configuration & Objects, Shipment, Warranty Entitlements, Invoices and General Ledger to interface with the ERP system. Implemented periodic business and financial reports through web based Report Catalogue subsystem.
• Customer Relationship Management (CRM): With this web based system, provided customer information such as location and addresses, contacts, order details, environment, products, configurations, external and internal call flows, service history, attachments and notes used by service employees to guarantee customer service and support. Built direct links to access ERP data.
• Business Location and Role based Security System (SS): Designed and developed web based security system to access all intranet applications based on the hierarchy, business location and assigned role of the employees in the company.
• Commissions System (CS): Implemented this system to manage sales and service commissions to the company’s employees. Completely transitioned printed statements and reports to an employee self-service commission’s portal. Built direct interfaces with ERP (Sales, Invoicing and Financial modules) and Payroll systems. Implemented frequently revised employee commission plans and calculations by the management.
• Expense Processing & Reporting System (EPRS): Automated employees’ travel and expense reporting to a process that included electronic workflow, enforcement of T&E policy, approval hierarchy, routing to reimbursement channels such as Direct Deposit, Payroll and ERP System (Accounts Payable and General Ledger modules), and reporting facilities to Management.
• Sales and Financial Data Warehouse/Tools (Sales and Product Analysis; Profit and Loss; Revenue Recognition Reports; Order life cycle): Developed data warehouse to provide management reports on sales forecasting, budget control and monitoring of business operations. Eliminated periodic printed reports and enabled daily snapshots of business activity with this browser based approach. Enabled management through reporting on life cycles of orders to control costs by managing installation schedules and to increase revenues by collection on invoice balances.

Tools: and Technologies: Microsoft IIS NT and Windows 2003 Servers, Delphi 7.0, HTML, DHTML, CSS, JavaScript, VBScript, XML, C#, .Net, ASP, SQL, PL/SQL, 9i, SQL, PL/SQL, SQL Loader, etc.

Confidential

Consultant

Responsibilities:

• Integrated Broadcast System (IBS): Led the design, development and migration of the mission’s critical broadcast traffic system from legacy to a Windows NT and Oracle/Unix based three-tier architecture. Liaised with CSC consultants to gather requirements, specify business rules and GUI interfaces, document work and data flows, and design the logical and physical databases. Also directed teams in the development, testing and rollout of software.
• Electronic Data Processing (EDI): Coordinated meetings with Donovan Data System, Add Value Network, Foote, Cone, Belding and other agencies to gather requirements. Designed, developed and implemented an industry standard electronic interface to transfer invoice and contract data from CBS to advertising agencies.
• Sales Information System (SIS): Provided management and sales force, tools to analyse revenue, sales forecasting and rate card evaluation in TV, Radio and Cable markets via this data warehouse system. Developed data mapping and extracts for data warehouse applying ETL methodology, for both UNIX and Legacy based TV, Radio and Cable stations.
• System Interface Integration (SII): Designed and developed cross-system interfaces to exchange data with Accounts Receivable and Payable, Broadcast Log and Feedback, and Nielsen Rating information.
• Data Migration (DM): Developed data mapping, implemented process for extraction of data from legacy DMSII database and loaded into the IBS Oracle databases. Automated DM by using WFL and Shell Scripts on Unisys mainframe and UNIX based machines, respectively.
• Traffic and Sales system (TSS): Designed and developed Proposal, Rate-card, Order Entry, Instructions and Material Assignments, Billing, Spot Scheduling, Broadcast Log/Feedback and Post buy Analysis sub systems for TV, Radio and Cable stations. Coordinated the development of test plans, quality assurance and rollouts.
• System Support: Provided 24X7 support to all Oracle and DMSII databases, offline/ batch processes and job scheduling of Unisys and UNIX based systems. Coordinated the coexistence and data synchronization across IBS and legacy systems, and testing for Y2K compliance.

Tools: and Technologies: VB, Dynasty, C, PL/SQL, SQL, Shell Scripts, Oracle, PROGENI, COBOL, WFL, DMSII Database on Unisys A-Series (A18) platforms.