SUMMARY:

• Over 13 years of IT experience, which includes more then 10 years of extensive experience in technical and functional aspects of Oracle Applications 11i/12Ri ( OM, CRM foundation, Service Contracts (OKS), Install Base, Inventory, Advance Pricing, BOM,AR,PO,AP,GL,TCA )
• Involved as a Techno functional in Oracle based business application design and development, implementation, customization, maintenance, conversions, interfaces, Testing and user training.
• Extensive knowledge in Oracle Applications Architecture.
• Exposure to functional aspects of CRM foundation, service contracts and OM
• Written interface/conversion programs for importing data from legacy system to Oracle using PL/SQL, SQL*Loader and UTL FILE.
• Skilled in using front - end tools like Developer 2000, Forms 4.5/6.0/6i and Reports 2.5/4.5/6.0/6 i to develop Client Server applications using Oracle (7.x/8.x/8i/9i) as the backend databases. Vast experience in customizing forms and reports in Oracle E-business suite Applications.
• Extensive experience in registering Concurrent Programs, Forms, Tables, Descriptive Flex fields in custom applications and default profile values by using Application Object Library (AOL).
• Strong programming experience in creating Procedures, API, Packages, Functions, Triggers and other database objects using SQL and PL/SQL. Also experienced in fine-tuning code for better performance.
• Extensively used Oracle standard APIs.
• Solid knowledge on UNIX shell script.
• Knowledge of using Business Intelligence Tool Business Objects.
• Ability to utilize project methodologies and standards.
• Excellent communication, analytical, interpersonal and presentation skills.
• Expert in Waterfall, Agile Methodology.
• Handled team size of 7-10 and have been leading team over 5 years across different geographic location throughout project life cycle.

TECHNICAL SKILLS:

Operating System: UNIX, Windows 95/98/00/NT/XP

Oracle CRM Modules: CRM Application Foundation, Service Contracts (OKS and Install Base

Financial Modules: General Ledger, Account Receivables and Account Payables

Distribution Modules: Order Management, Advance Pricing, Purchase Order, Inventory, BOM (11i / 12Ri)

Databases: Oracle 7.x/8.x/8i/9i /10g

Developer Tools: Oracle Forms 4.5/ 6i, Oracle Reports 2.5/6i and BI Publisher

Tools: & Utilities SQL Report Writer V1.0 and Sql * Loader

Case Tools: Designer 2000, Developer 2000

Discoverer Report: TOAD, SQL Navigator

Languages: SQL, PL/SQL, C and Java

Others: Application Object Library (AOL), Kintana, StarTeam 5.2,Perforce

PROFESSIONAL EXPERIENCE:

Confidential, CA

Techno Functional Senior Analyst

Responsibilities:

• Worked with business users for requirement gathering
• Written Functional/Technical design documents as per the Requirement
• Worked on Renewal Batch Quoting process (50 % increase in renewals quoting process)
• Wrote APIs to update IB parties based on Business requirement.
• Customized Service contracts renewal process.
• Created Service / Subscription Contracts by using APIs.
• Designed Custom Forms for building extensions.
• Worked on Form personalization.
• Well versed on Service Contracts, IB, OM, INVENTORY, BOM and AR.
• Worked in Service Contracts Consolidation process.
• Created AOL Objects such as Concurrent Programs, Value Sets, Functions, and Lookups, Profile Options as per business requirement.
• Enabled DFFs for business as per business requirement.
• Created ad hoc reports for business requirements.

Environment: Oracle Applications R12i (Service Contracts, IB, OM, AR, AP,PO, SysAdmin, AOL), PL/SQL, SQL Plus, TOAD, Unix,InfrarouterForms 6i, Reports, XML Publisher.

Confidential, CA

Techno Functional Senior Analyst

Responsibilities:

• Co-Ordinated with L3 Support team continuous improvement for resolving the Production issues.
• Worked with business users for requirement gathering
• Written Functional/Technical design documents as per the Requirement
• Worked with QA team to review test cases and during testing cycle.
• Co-Ordinated UAT with business users.
• Designed Interfaces between EBS and FMW / INFORMATICA.
• Customized IB creation process from OM to IB.
• Worked on Upgrade Order process.
• Customized SC Auto Renewal Process (Auto Renewal Booking rate is improved by 40%).
• Customized Auto Reminder Process for Renewals.
• Implemented online renewal Process with EBS-Clever Bridge and EBS-DR integration.
• Worked in the Implementation of Renewal Process EBS SC - SFDC integration.
• Implemented integration process iASSET - EBS Order Boking process.
• Implemented Commissions system EBS to Varicent.
• Implemented ModelN integration for ELA POs processing.
• Implemented Aria integration for Subscription Billing processing.
• Extensively worked with offshore team to complete the development deliverables.
• Designed Custom Forms for building extensions.
• Worked on Form personalization.
• Well versed on Service Contracts, IB, OM, INVENTORY, BOM and AR.
• Hands on Experience in Service Contracts Consolidation process.
• Worked on EDI 850,855 and 810.
• Worked on Custom Applications for Bookings and Commissions.
• Created AOL Objects such as Concurrent Programs, Value Sets, Functions, and Lookups, Profile Options as per business requirement.
• Enabled DFFs for business as per business requirement.
• Created ad hoc reports for business requirements.

Environment: Oracle Applications 11i/R12i (Service Contracts, IB, OM, AR, AP,PO, SysAdmin, AOL), PL/SQL, SQL Plus, TOAD, Unix, Perforce and PPM (Kintana)Forms 6i, Reports, BI Publisher.

Confidential, CA

Techno Functional senior Analyst

Responsibilities:

• Written Functional/Technical design documents.
• Worked on performance tuning.
• Written scripts for data base fixes.
• Worked on Service Contracts, Inventory and TCA.
• Created Concurrent Programs, Value Sets and Lookups for business requirement.
• Enabled DFFs for business requirement.
• Created ad hoc reports for business requirements.

Environment: Oracle Applications (Inventory, Service Contracts, TCA, AR, SysAdmin, AOL), PL/SQL, SQL Plus, TOAD, Unix, SVN and Win XP, Forms 6i.

Confidential, CA

Techno Functional senior Analyst

Responsibilities:

• Worked on UAT issues as part of user testing.
• Written Functional/Technical design documents as per the requirements.
• Designed Interfaces, which are called from FMW (Oracle Fusion Middleware).
• Designed, Developed and Tested performance enhancements.
• Gathered the information from TCA to show on the portal.
• Modified the AR Invoice print report.
• Created Oracle Alerts using alerts manager to send notification to the support team When concurrent program fails or when no records were processed.
• Developed database trigger on Service Contracts Contact table, which inserts data Into a staging table.
• Worked on production issues.
• Worked on WF customizations.

Environment: Oracle Applications 11i (OM, Inventory, Service Contracts, Installed Base, TCA, AR, SysAdmin, AOL), WF, PL/SQL, SQL Plus, TOAD, Perforce, Jira, PPM and Win XP, Forms 6i

Confidential, Alameda CA

Techno Functional senior Analyst

Responsibilities.

• Resolved Invoicing Issues, which are stuck in AR Interface.
• Resolved Install Base errors, Contract issues, Billing Issues as part of Production Support.
• Created new Category sets and assigned to Inventory Items.
• Extracted the data through BOM Explode of New Category Assigned Items in Inventory and dumped into Interface tables, which will use in Web center.
• Wrote Interfaces for Web developers for their requirements.
• Developed the APIs for Service Item details from Service Contracts and IB For WEB Developers
• Enabled DFF for Business Requirements
• Created Value Sets, Concurrent programs for Business Requirements
• Identified Select statements which need performance tuning and fine tuned extensive SQL statements, using TKPROF and Explain Plain

Environment: ERP/CRM: Oracle Applications 11.5.9, Service Contracts, Installed Base, OM, Advance Pricing, AR, AP, GL, Inventory, BOM, TCA, SQL*PLUS, PL/SQL, Oracle 9i, SQL Loader, Developer Suite (Forms 6i, Reports 6i), Shell Script, Macros.

Confidential, Hayward, CA

Techno functional Application Sr. Developer.

Responsibilities.

• Customized Service Contracts Order Capture process to generate service contract information for orders created in Order Management.
• Customized Billing Schedule program based on Business requirements.
• Enabled Descriptive Flexfields in SC, OM modules modifying value sets for segments according to user requirements.
• Developed Custom Forms.
• Involved in Rate Change project which replaced the current Rate Change system by a fully integrated solution on the Oracle 11i platform. The new Rate Change flow from order to cash.
• Customized Service Contract Termination process based on RMA.
• Resolved Invoicing Issues, which are stuck in AR Interface.

Environment: ERP/CRM: Oracle Applications 11.5.9, Service Contracts, Installed Base, OM, Advance Pricing, AR, AP, GL, TCA, SQL*PLUS, PL/SQL, Oracle 9i, SQL Loader, Developer Suite (Forms 6i, Reports 6i), UNIX, Shell Script.

Confidential, Fullerton, LA, CA

Techno functional Application Sr. Developer.

Responsibilities:

• Involved in the data mapping and conversion programs for moving contracts from legacy systems into OM, Product Contracts (OKC), and Oracle Service Contracts.
• Developed Interface Programs to import Orders from Contracts(OKC) into Order
• Created procedures and SQL*Loader Scripts to populate OKC Data.
• Enabled Descriptive Flex fields in OM, Contracts modules modifying value sets for segments according to user requirements.
• Registered customized forms, reports and created executables using Application Object Library (AOL).
• Customized workflow process using workflow builder 2.6.
• Performed extensive SQL tuning and optimization on views and queries generated by reporting front-end packages and developers.

Environment: ERP/CRM: Oracle Applications 11.5.9, Service Contracts, Installed Base, OM,Inventory,TCA. SQL*PLUS, PL/SQL, Oracle 9i, SQL Loader, Developer Suite (Forms 6i, Reports 6i), UNIX, Shell Script, Data modeling using E-R Data modeling and Erwin 4.0.