Siva Kamatham Oracle EBS DeveloperEmail: siva_oraclecrm@yahoo.com Cell: 224-532-7320

Professional Summary

10 years of professional experience in Oracle Applications Design, Development, Implementation, Upgrade and Maintenance projects and Web Applications, Data warehousing, E-Commerce projects using J2EE, XML

Experience in Order-to-Cash, Procure-to-Pay, Financials & CRM Project Life Cycles (11i and R12).

Experience in functional requirement analysis, provide technical design, architect solutions and lead technical teams

Extensive experience in data mapping, design, development, testing of interfaces and conversions from legacy systems to oracle EBS

Experience in Functional Setups, implementation & customization of Oracle Application modules Quoting, Order Management, Advanced Pricing, Inventory, Install Base, Service Contracts, Field Service, Accounts Receivables, Oracle Sales Online, Telesales, Oracle Incentive Compensation, Procurement, iProcurement, iStore, iSupport, iExpenses, Oracle Content Management, Partners Online, Customers Online, Oracle Configurator, Oracle Trade Management & Oracle Marketing Online

Exposure to other Oracle Applications like, BOM, WIP, HRMS, Teleservice Extensive experience in Oracle Applications Framework (OAF), AOL, JTF, JSP

and HTML DB/APEX forms Experience in Forms 6i, Reports 6i/10g, Custom.pll, Forms personalization, OAF

forms personalization and customizations, Workflow, TCA, Multi Org, Web Services and XML (BI) Publisher.

Experience in JDeveloper, Unitask, Workflow Builder, J2EE, SQL, PL/SQL, SQL*Loader, SQL Navigator/Developer, TOAD, CVS and PVCS.

Strong understanding of Application Object Library (AOL), RDBMS concepts and different operating systems like Sun Solaris, Linux, UNIX.

Experience in functional setups like Service Contracts, Field Service, Territory Manager, User Management setups, Custom Menu, Flex Fields, Value Sets and custom security etc.

Extensively used AIM (Application Implementation Methodology) in implementing solutions and experience in writing MD050, MD070, MD120, CV010, CV040, CV060, CV120 & TE20

Experience in performing Technical Design Reviews, Code reviews, coordination with offshore team, UAT, CRP testing and SQL Performance Tuning

Working closely with Oracle Support to resolve issues while development, testing and post production support phases

Result oriented individual, team player with excellent verbal and written communication skills and having good problem solving and analytical abilities.

Technical Skills

Frameworks: OA framework, OSO, OMO, JTT, HTML DB/APEX forms, WorkflowRDBMS: Oracle 8.x/9i/10g, Sybase, Sql server, DB2Programming: PL/SQL, Java, JDBC, JSP, Servlets, EJB, JAAS, HTML, Java Script, XML, BPELOperating Systems: UNIX, Sun Solaris, Linux, WindowsOther Tools: Workflow Builder 2.6, Toad, SQL Navigator, Jdeveloper, Unitask, CVS, Harvest and Clear QuestWeb/Application Servers: Apache, Tomcat, Websphere, Weblogic, JBoss

Work Experience

M.A. Mortenson Nov 2010 – Current Senior Technical Developer Golden Valley, MN

As part of Mortenson Oracle EBS 11i technical team, I am working on Project Accounting, Procurement, iProcurement and Workflow applications.

Responsibilities: Design and Development of Logging Framework for PMA interface between Skire

Unifier and Oracle Project Accounting. Email Notifications using Oracle Workflow 2.6 and sending emails to multiple To,

Cc and Bcc recipients and lotus notes groups. Design and Development of PL/SQL programs for inbound and outbound interfaces

for Project Agreements, SOVs and Project Cost updates. Design and Development of personalization to Oracle Projects form Personalization to iprocurement forms using OAF and customizations for freight

integration with standard requisitions and purchase orders. MD070s, CRP testing, Code Migration using Unitask and GO Live Activities.

McQuay International Oct 2008 – Oct 2010 Senior Technical Developer Plymouth, MN

McQuay International delivers engineered, flexible solutions for commercial, industrial and institutional HVAC requirements with reliable products, knowledgeable applications expertise and responsive support. Working as part of Oracle 10.7 to Release 12 (R12) upgrade project, I was responsible for design, development, unit test and code migration of various RICE in the applications Service Contracts, Install Base, Field Service, Tele Service, Order Management, Inventory, Advanced Pricing, AR, PO, Workflow and BI (XML) Publisher and playing a Technical Architect role with techno-functional responsibilities. Responsibilities: Participation in requirement gap analysis and proposing suitable solution, estimations Providing techno-functional assistance to the entire team and technical training

Design Development, testing of Customer Site addresses, Install Base, Item Costing, Purchase Orders and pricing conversions.

Customizations and Personalization to Service Request Form, Debrief Form, Material Transactions, Contracts Authoring, Contract Termination forms, Install base and Mass update forms

Design, Development and unit testing of custom charge line pricing, custom cost calculations, custom validations, customized service order submission, Auto invoice preprocessor for contracts billing, Workflow customization

Design, development of various XML Publisher Reports like Line of business, contract profitability, SR & contract commission, deferred revenue, revenue recovery, custom cost reclassification reports for debriefed parts and expense items, customized invoice report and warranty report reports

Design, Development of Mass Update form customizations and Gross Margin Report using OA Framework and Jdeveloper

Setup and Development of custom contract quality assurance processes and check list Configure Territory manager for Auto Assignment of Field service applications. Development of create PM (preventive maintenance) effectivities for PM programs

and activities Customized OM workflow to default Service Request Information on Service Orders,

create sales credits on order header and lines, Purchasing workflows to default custom accounting, Contract Approval workflow to remove notifications.

Custom Extension to modify/generate Material Transaction Accounting segments and integration to Debrief Posting Program, customization to material transaction form.

Resolve production support issues and working with oracle support, Code migration to CRP, UAT, PROD.

Participation in Cut-over plan review meetings and Gathering and Preparing list of interfaces to be scheduled on PROD and frequency

ACCO Brands Nov 2007 – Oct 2008Senior Techno Functional Consultant Chicago, IL

ACCO Brands Corporation manufactures a wide variety of office supplies, ranging from paper clips and staplers to personal organizers, computer peripherals, and software. As part of the Oracle Applications 11i implementation team, I worked on Order Management, Install Base, Service Contracts, INV, PO, AR, Advanced Pricing, Territory Manager, OIC, Sales Online and Telesales.

Responsibilities:

Design and Development of various technical solutions in OM, IB, OKC, Procurement, Accounts Receivables, Advanced Pricing, Incentive Compensation, Sales Online, Telesales, iStore using Java, JSP, XML, OAF, Forms 6i and documentation using AIM

Participation in requirement Gap Analysis and proposing, prototype technical solutions, demo to business, functional design review meetings and escalating technical, application, integration limitations and issues

Technical Designs (MD070s), Design and Development of custom solutions coordinate development activities with onsite, offshore teams, review technical designs, code and leading offshore team of 3 developers.

Reviewed Install Base and Contracts Configurations, Modifications and Configure Contracts Auto Renewal, billing, territory setups for Field Service and modify BR100

Worked on Advance Pricing price lists, Qualifiers, Modifiers, Custom Pricing Default Attribute setups for OM and Service Contracts Global Setup

Design and development of various conversions like Service Contracts, Install Base, Invoices, Statements and Price Lists.

Design and Development of various interfaces for customer, contract coverage and install base updates, XML Messaging using web services to external systems

Developing various forms customizations, personalization, reports using Forms 6i, Reports 6i and BI Publisher,

Active participation in CRP, UAT defect tracking meetings Code promotions) and Go-Live conversion activities and scheduling interfaces, jobs

and post production activities

Danka Aug 2007 – Nov 2007Techno Functional Consultant St. Petersburg, FL

Danka is the largest diversified wholesale distributor serving the copiers, image scanners, fax machines manufactured by Canon, Kodak, Hp, Toshiba etc., Oracle Application 11i (11.5.10) implementation was done to automate all the business processes.

Responsibilities: Participated business requirements gathering, solution review meetings Design and development of Contact Centrals Tasks & Notes conversion, new form to

manage tasks and notes using OAF. Customizations and bug fixes in Quoting, Order Management, Service Contracts,

Install Base and Advanced Pricing using Forms 6i, Personalization, Workflow, Oracle Applications Framework, Jdeveloper and JSP

DeKalb County July 2006 – Aug 2007Techno Functional Consultant Atlanta, GA

DeKalb County is using the mainframe system called OASIS for their Property & Tax Management. Due to various obvious reasons like CUI, Slow performance, Limited upgrade possibilities county decided to implemente Oracle Application’s GUI for their complete customized solution. This particular customized module will cater to the end to end requirements of DeKalb County‘s Tax Application, Exemption Applications, Adjustments, Write Off, Invoice Generation, Receipt Application etc using Oracle Install Base, Service Contracts and Accounts Receivables, iReceivables applications. This new application has been named as Tax Accounting System (TAS).   Responsibilities: Leading Data Conversion team of four, Designed and development of data

conversion from legacy system (OASIS) to Oracle 11i

Involved in System requirements meetings, understanding the legacy data structures and identifies the required data fields, mapping (CV040), providing execution, instance refresh plan, test strategy and test plan

Design and Development of conversion programs (using pl/sql) to convert legacy data into Oracle Install Base, Customer Data (TCA) and Accounts Receivables (Invoices & Receipts)

Design and development of various interfaces between legacy and Oracle 11i vice versa to integrate the new Oracle 11i applications with existing legacy systems in the areas of assessment, GIS

Design and Development of new forms using OA Framework and JDeveloper for Property Splitting, Merging and Owner, Owner Address maintenances and iReceivables.

Design and Development of contract creation program and Auto-Renewal setup SQL performance tuning and Documenting the proposed solution using AIM like

MD050, MD070, MD120, CV010, CV040, CV060, CV120

ADP Mar 2006 - July 2006Oracle Applications Consultant New Jersey, USA

ADP handles employer-related functions, Brokerage services, Dealer services and Screening & Selection services that require extensive processing, record keeping, technology and up-to-date best practices. As part Oracle 11i implementation I worked Quote to Cash, Order Management and Oracle Incentive Compensation etc.

Responsibilities: Design and development of custom forms using OA framework for Quote to Cash

Management. Involved in implementation and customizations of Oracle Incentive Compensation

and customization of OIC Reports like Missing Quota, Exceptions, YTD reports etc., using PL/SQl, Jdeveloper, OAF, Java and Forms Personalization

Configure Territory Manager and User Management activities for OIC and sales credit assignment process in Quote to Cash process.

Developing Reports data to Excel sheets, pl/sql procedures, functions and packages for various reports, custom extensions in Incentive Compensation application

Generating Java, pl/sql Wrapper APIs for pl/sql packages using Oracle Rosetta Technical Design discussions with functional/user team and sign off Involved in setups like AOL Resources, Users, Menus, Functions, AK Regions,

Attributes, Messages etc., Issue tracking and Bug fixes on the existing implementation

EMC2 Sep 2005 - Mar 2006Oracle Applications Consultant Massachusetts, USA

Accenture Consulting implemented Synergy project using Oracle 11i which encompasses the development, customizations and deployment of functionality for Oracle Sales Online, Quoting, Field Services, Customer Support, Contact Center,

Tele Service, Depot Repair, Installed base, Mobile Field Receipts, iStore and iSupport modules using Java, JSP, Workflow and Oracle Applications Framework.

Responsibilities: Involved in development of various Customizations, extensions for Sales Online,

Quoting, Installed Base, Field Services, Teleservice, Contact Center, Depot Repair, Spares Management, iStore and isupport applications using JSP, OAF, Forms 6i. Reviewing Functional design, preparing Technical design for new features, customizations and demo to business and interaction with EMC teams.

Worked on Sales Online Opportunities, Leads and Quoting customizations and using TCA APIs for updating customer data, customizing Field Service Dashboard page, SR Creation page, Advanced Search pages, Install Base Advanced Search Screen, Item Instance Details Screen, View Configuration Screen, and Create Item Instance Screen and Tasks View for Service Requests in Field Services.

Worked on building, implementing custom security across Sales Online, Quoting, Field Services and Installed Base modules

Worked on AOL, Functions, custom menu setups, migrating definitions using LDT Development and customizations in iStore, iSupport, Depot Repair, Spares, Oracle

Field Receipts (MWA) applications Extensively worked on AIM documents like MD070, MD120s

Harvard Pilgrim Health Care Jan 2005 - Sep 2005Oracle Applications Consultant Massachusetts, USA

HPHC developed Enrollment End to End (EEE) using Oracle Applications 11i which encompasses the development and deployment of functionality for Oracle Sales Online, Telesales, Customers Online, Quoting, OM, AR, Oracle Configurator, Workflow, XML Gateway and APEX (HTMLDB) modules.

Responsibilities: Involved in development, Customization, implementation and deployment of various

extensions, customizations in Oracle Sales Online, Quoting, Telesales, Customers Online and Oracle Configurator using Java, JSP, Workflow, Custom PLL and Forms 6i.

Design and Development of Custom Security in Sales, Customers Online using data security groups and VPD.

Development of new forms using APEX and integration with Oracle Applications Development of functional companion using Java, CIOs, Oracle Configurator for

Rate Request, Lit Request. Developed a new Oracle Workflow for sending notification for Admin Options

Management, Creating Quote using data coming from legacy over XML Gatgway Design and Development of customized/wrappers for TCA APIs Participation in CRP Testing, providing turnaround time line and fixing issues Extensively worked on AIM documents like MD050, MD070, MD120

Oracle Corporation Apr 2002 – Jan 2005Senior Applications Developer

Oracle E-Business Suite is a complete set of business applications that runs entirely on the Internet, enabling client to cut costs; increase revenues across front - and back - office functions; and access current, accurate, and consistent data. It creates unprecedented access to new worldwide markets; produces closer relationships with customers and partners; allows companies to bring products to market faster; and dramatically reduces sales and operating costs.

Responsibilities: Involved in Oracle CRM 11.5.9 and 11.5.10 Development, implementation and

configuration of Marketing Online, Sales Online, e-Marketing, Trade Management, iStore, iSupport, iProcurement and iExpenses.

Design, development, testing of various forms, customizations and extensions in Sales Online, Marketing Online, Trade Management, Integrations between Marketing to Content Management, scripts, iStore, integration between sales online to proposals using Java, JSP, PL/SQL, Oracle Applications framework (OAF) using jDeveloper

Worked on Site Creation, Bins, Product Catelog and Content management. Personalize user screens using Forms 6i, JSP, OA Framework technologies. Extensively worked on XML parsers and Java wrapper for PL/SQL Apis CRM Foundation setups like Responsibilities, Menu exclusions, Request Groups,

Territories, User management, JTF tasks and Notes. Worked on Admin UI and Customer UI of iStore Support Product interface,Sales and Marketing 11.5.9 and 11.5.8 applications.

Environment: Oracle CRM 11i (11.5.9, 11.5.10) – Sales online, Marketing Online, Trade Management, iStore, iSupport, OA framework, Oracle 9i, PL/SQL, JDBC, JSP, XML, J2EE, JDeveloper, Oracle Workflow, UNIX, LINUX

Aztec Software July 2000 - April 2002Senior Software Developer

DT/Studio:DT/Studio is an ETL Product developed for Embarcadero Technologies Ltd.,

USA. DT/Studio Extracts data from heterogeneous databases, transforms data according to customer requirements and Loads into heterogeneous databases. As part of this product development team, I was responsible for design, development and unit testing the below components.

Responsibilities: Involved in Design and developing a Logging framework, purge routine, build

automation tool using java, javascript for automating regression testing. Design, Development and testing of various transformations like Duplicate, Dup-

Elimination, Mathematical that are using in loading and transforming data between transactional databases to data marts.

Implemented User Authentication and Authorization support in both client communication layer and client manager modules and scratch area enhancements like DT/Studio creates various temporary files such as data file, error logs, and control data files during the execution of a task. These are modified to create in the specified scratch area at server. Also Designed and implemented debugging of task execution in all reader/writer components

Development of various message driven EJBs for effective load balancing and testing using various application servers like Jboss, Weblogic and Websphere.

Environment: Java2.0, XML, EJB, JBoss 2.5, Web Logic 5.1, Windows ‘NT, Linux, Sun Solaris, Oracle, MS-SQL Server, Sybase, DB2, SybaseIQ Server

Aztec Software Jan 2000 - July 2000Software Developer

CSHarness:CSHarness is a java-based tool, which automates whole testing process for Data

Transit project. It generates Task Definition File (TDF) using the properties given by the user, deploys the task on DT/Engine, initiates the task execution and verifies the test results. It also has reporting facility, which tells how many tasks passed/failed, what are the reasons for failures (i.e. data mismatch or gets the error message from DT/Engine log database) etc. It has facility to log the test results into database along with file logging.

Responsibilities: Involved in Design, Coding, and Testing.

Aztec Software Sept 1999 - Jan 2000Software DeveloperAdministration Management System:

Administration Management System automates Aztec’s administrative activities. This project mainly has three modules, Services, Inventory and Notification. Services deals with all types of services like request for stationary, monitor replacement etc., Inventory module does Inventory Management and Notification module notifies the appropriate Services Provider in case of new request, notifies the requester in case if Service Provider approves the request through Email system.Responsibilities: Involved in Analysis, Design, Coding and Testing of Inventory Module.

Educational Qualifications Master of Computer Applications (MCA).