SUMMARY:

• Over 14 years of rich experience in IT industry.
• Extensive experience of complete software development lifecycle of application software in Oracle E - Business Suite.
• Performed roles as Subject matter expert, Technical Team Lead, and member of the Task force for high impact projects in the Organization.
• Member of the Task force of eight for implementing four major Oracle releases across different countries - Canada, US, USA Packaging, China, Chile.
• Lead the world wide support after successful implementation for Oracle E-business suite at Confidential, TX, which is currently supported by an offshore team.
• Successfully lead a team of six in the data conversion and cleanup effort, Oracle 11i Implementation. Involved in the creation of Business models for the Legacy System for the Confidential, Water Revenue Bureau.
• Represented Idhasoft at various trade shows, User Groups and at client sites in the technical capacity.
• Subject Matter expert for Advanced Pricing, TCA, Order Management, Receivables, Custom Form Libraries, Personalization, Workflow, Conversions and Interfaces at Confidential, TX. Well versed in the Technical/Functional concepts in Finance, Manufacturing, CRM, Applications Open Interfaces for data conversions which includes customer, invoice, order, pricing interfaces and API’s, customizing the existing Oracle Applications Reports, Forms, Workflow, Self- service personalization along with creating new components.
• Responsible for Architecture, Design and Development of Custom Inbound and Outbound Interfaces, Conversions for the External System integration with Oracle.
• Very strong SDLC experience in addition to requirement gathering and project plan creation, As-Is process analysis and To-Be process design, Configure & Build, CRP reviews, System Testing, Integration Testing, Acceptance Testing and Go-Live or phased rollout..Participated in requirement gathering meetings with functional, legacy management. Prepared Technical, Functional Design Documentation as per AIM (MD20, MD50, and MD60) and RICE Methodology.

TECHNICAL SKILLS:

OS: Windows 7/XP/2000/NT/98/95, Sun Solaris, MS DOS, UNIX, HP-UX, Linux, IBM AIX

Language: PL/SQL, SQL, SQL*LOADER, Pro*C, C, UNIX Shell Script, PerlJSP, Java, HTML/DHTML, CSS, JavaScript, Node.jsXML, XPATH, XSLT,JSP (OA Framework)Ruby on Rails, PHP,RMI, Java Swings, Servlets, J2EE

Tools: Oracle Forms 6i, Oracle Reports 6i, Developer 2000, Oracle Designer 6i,JDeveloper (OA Framework), XML/BI Publisher, Discoverer 10g, Workflow Builder, Discoverer 11g, MS Visio, MS ProjectsData Base: Oracle 8i/9i/10g/11g, MS Access, MySQL, Mongo DB (NoSQL)

Server: Oracle Application server, Apache, XAMP, BEA Web Logic 9.2

Methodology: AIM, RICE, Relational Database Design Techniques, Client/Server, 3 Tier web Architecture

ORACLE MODULES: Oracle

EBusiness Suite: Modules11.0.3, 11i,R12 ONT - Order Management, QP Advanced Pricing,, TCA Trading Community Architecture, WSH Shipping, OE - Order Entry, ALR Alert, AR - Receivables, FND - Application Object Library, OCO Oracle Customers Online IEU - Universal Work Queue, IEX Advanced Collections, JTF - CRM Foundation, AME - Approvals Management, Sales Online / ASO - Order Capture, XDO - XML Publisher, CSC - Customer Care, CN - Incentive Compensation INV - Inventory, WSH - Shipping Execution, PO Purchasing, CSI Install Base, OKS/OKC Oracle Service Contracts AR - Receivables, GL - General Ledger, AP - Payables, FA Fixed Assets, CE Cash Management GMD - Process Manufacturing Product Development, GME - Process Manufacturing Process Execution, GMF - Process Manufacturing Financials, GMI - Process Manufacturing Inventory, CST - Cost Management, WIP Work in Process OUB Oracle Utility Billing, OKC - Contracts Core / OKO - Contracts for Sales ( XXSC - Custom Module based on Oracle Module), FA Fixed Assets, CE Cash Management, CSC - Customer Care, CN - Incentive Compensation

WORK EXPERIENCE:

Confidential, San Francisco, CA

Business Analyst

Responsibilities:

• Release 12.1.3 to 12.2.5 Version Differences for AR, AP, GL, FA, IEX, PO, ICX, ICX - Mobile
• Order Management Features and SFDC Integration modes - Business use cases
• Preparation of the List of All the Custom Objects
• Identifying Patches and Working with Oracle SR for upgrade

Confidential, Mountain View, CA

Responsibilities:

• Adding Custom filtering conditions based on the Custom EGO Attributes
• Converting Oracle report in 11i to Excel Output using BI Publisher
• Concurrent Program to reprocess the Delayed/Timed Out Notifications

Confidential, Sunnyvale, CA

Responsibilities:

• iStore Renewals and Order Import Module: Architect/Designer/Developer for a custom module in Service Contracts for Renewals using iStore user interface and renewals flowing to Service Contracts - Includes customizing JSPs, PL/SQL APIs and designing new JSPs, PL/SQL APIs for the Blue-Store Web Portal
• Order submission enhancement - (Using Order import API) Customizing and Enhancing Oracle order submission process in iStore using excel spreadsheet -Worked on Enhancements/Integration part to import Quote/Orders from different External source systems with oracle apps.
• Designed and Developed Track Quotes pages - For user display for quotes in various stages of approval
• Using Java Classes to serve the JSP requests that encapsulate business logic.
• Patches - Testing and Recommending updates on the Patch set versions
• Account Consolidation (Form for IB Asset Ownership transfer without terminating the Contract)
• Sales Order Form (PLL) Customization
• Service Contracts form customization
• Item Bulk Updates (Using API to update item attributes from spreadsheet)
• VAT tax calculation enhancementsManaging the Order/RMA flow from Salesforce to Oracle Orders, Shipping, Invoicing, Service Contracts, Install Base, and Licensing.
• Interacting with the users, identifying gaps, gathering requirements for enhancements designing and developing custom solutions and providing production support
• RMA Automation with including third party interface (Interactions with TALEND for integration between Oracle and Saleforce.com)

Confidential, Valencia, CA

Environment: - Oracle10g, Reports 6i, Forms 6i, XML/BI Publisher, MS Visio 2003, Oracle Apps 11.5.10 (Advanced Pricing (QP), Order Management (ONT), TCA(HZ)), Inventory (INV), Shipping (WSH), Receivable(AR)

Responsibilities:

• Special Pricing: Customer specific pricing, GSA/IDN pricing
• Managing and Maintaining Pricing Hierarchies - From legacy systemsCustom Modifier and Qualifiers using Custom Attributes

Confidential, Greenwood Village, CO

Advanced Pricing and Order Management SME

Responsibilities:

• Enhancements and Suggestions for Advanced Pricing, Order Management
• Process Improvements, Business process mapping and solution building - Advanced Pricing, Order Management
• Requirements Gathering Sessions - Advanced Pricing, Pricing Procedures, Quoting Procedures
• Setup enquiry of Order Management/Advanced pricing for iStore implementation
• Set up Retail Price lists for iStore Implementation.
• Responsible for studying the business process.Prepared AS-IS understanding document for Advanced pricing and Order Management
• Assisted in business process reengineering, created TO-BE process document.
• Delivered sessions/Presentations on Comex’s business process and created documents for presentations to the client.
• Review and scope new requirements, requests for change and problems for modules already implemented.
• Creating/updating automation files for removing ‘repetitive’ and ‘Non Valued added’ activities

Environment: - Oracle10g, Reports 6i, Forms 6i, XML/BI Publisher, MS Visio 2003, Oracle Apps 11.5.10 (Advanced Pricing (QP), Order Management (ONT), iStore (IBE), Receivable(AR), TCA(HZ))

Confidential, Irving TX

Senior Oracle Apps Consultant/Subject Matter Expert

Responsibilities:

• Lead a team in the data cleanup process which is provided by legacy system. f the personal for the data mapping and clean up.
• Member of the Task force of eight for implementing four major releases across different countries -
• Lead the world wide support after successful implementation for Release3 at Confidential, which is currently supported by an offshore team.
• Responsible for Code reviews and documentation reviews for the Off-shore team and Onsite support team.
• Expert on Data Conversion, External System Integration with Custom Interfaces, Personalization, Custom Form Libraries ( pll’s ), Custom.pll
• Participated in various meetings with functional team and legacy system management to gather user requirements regarding reports and other customizations and in corporate those requirements into Oracle applications features.
• Preparing Technical design documentation
• Helped the conversion team in mapping, conversion and validation of historical data for Customer Master, Sales Orders, Invoices
• Excellent knowledge of TCA in customer interface.
• Designed developed and Implemented Purchasing Document Open Interface Program in Oracle Purchasing.
• Developed PL/SQL script to Import Customers, Customer profile classes data through Customer Interface.
• Responsible for analyze, design and developing programs for conversion of legacy data in to General ledger throw Journal import program and Interfaces. The conversion includes writing PL/SQL package Also responsible for budget upload throw budget interface, loading daily rates to gl daily rates table throw gl daily rates interface table and average & month end rates to gl translation rates table for various set of books including MRC reporting books. Developed SQL* Loader programs to load interface/staging tables.
• Preparing Technical design documentation and developed report modifications like Packing Slip, Dunning Letter, Selected Invoice Printing, sales Tax Report.
• Designed the invoice report for their invoicing purposes.
• Customized sales order Invoice reconciliation report, orders on hold report.
• Check printing - Quick pay, payment batch
• Defined and Customized the order management Workflow (Samples and Novelties) to control the order flow process

Environment: Oracle Applications11i, Oracle 11G, SQL*Plus, SQL*Loader, PL/SQL, Forms 6i, Reports 6i, Shell Script, TOAD, HP Unix, Windows 2000, Windows’ XP, Discoverer, Workflow

Confidential

Responsibilities:

• Quality/Technical Team of Oracle Applications for all of the Water Department in the Confidential and involved in the creation of data models to Testing.
• Provided inputs on the quality of Effort and ways to improve the efforts of the development team.
• Creation of special procedures to implement all the rules for the Translation of the Legacy data and making it Conversion compatible with the Oracle Data structures. f the personal for the data mapping and clean up.
• Lead a team of three for the Data Conversions
• Lead a team of six in the data cleanup process which is provided by legacy system.
• Defined concurrent Executables, Programs and Registered using system administration.
• Responsible for Code reviews and documentation reviews.
• Populated the data into interim tables using SQL*Loader.
• Developed PL/SQL packages and stores procedures to validate and insert the data into interface tables.
• Developed Unix Shell Scripts to automate the interface process.
• Responsible for extraction of legacy data in fixed length file format using UTIL FILE utility.
• Developed Util file programs for extraction of data.
• Customer Conversion: Converted the Customer Data for the Individual Owners and Group Bill Customers using the Customer Interface
• Litigation: Converted the data for payment agreement from city to Oracle Applications
• Payment Agreement: Converted the data for payment agreement from city to Oracle Applications
• Transactions: Converted the data for 13 Month History of the Transactions data from city to Oracle Applications instance. Used the Auto Invoice for Loading this data
• Payment Receipts: Converted the 13 Month History of the Payment Receipts from city to Oracle Applications instance.

Environment: Oracle Applications11i, Oracle 8i,SQL*Plus, SQL*Loader, PL/SQL, Forms 6i, Reports 6i, Shell Script, TOAD, HP Unix, AR, OUB, CRM and Reports 6i

Confidential, San Diego, CA

Oracle Applications Technical Consultant

Responsibilities:

• Successfully implemented the 60,000$ Project Operations Scorecard, within the allocated budget and time lines.
• Participated in various meetings with functional team and legacy system management to gather user requirements pertaining reports and other customizations and in corporate those requirements into Oracle applications features.
• Wrote SQL, PL/SQL scripts for this data to be directly mailed to the user.
• Preparing Technical design documentation, Functional Design Documentation MD20, MD50, MD60
• Designed and Developed Reports for Operations Scorecard
• Involved in Gathering requirements, Analysis, Design until User acceptance and into Production This involved continuous interaction and feedback from the User.
• Designed and Documented the Process flows for RAS (Return Analysis System) and GERS (GE Retail Store) from the existing STN Flows
• Developing Packages and Extracts for Analysis of Sony’s Sales and Marketing Retail divisions
• Compares the Sales Forecasts and the actual Orders Booked.
• Compares the percentage of orders which have missed the Expected Order date
• Provides the data in a spreadsheet, and is mailed to the users as an attachment
• Generated a report for providing the Percentage of Orders delayed
• Orders on Hold Report: This report is used for analyzing the time taken to release holds on the order.

Confidential, San Jose, CA

Oracle Application/IT Analyst

Responsibilities:

• Worked Extensively on Auto Invoice and Customer Auto Loader
• Designed alert requirements for the failed transactions in the order fulfillment.
• Developed Pl/SQL Programs/ Packages for Customer Auto Loader.
• RMA Order import for the data migration from the 10.7 to 11i
• Host file for Loading EDI information into the EDI Database