SUMMARY:

• An accomplished professional, over 12 years of experience in Oracle EBS System Analysis, Design, Development, Maintenance and Implementation process. Experience in Oracle Financials, Quote to Cash, Procure to Pay, Customer Data Hub, TCA, HRMS, Install Base and Service Contracts. Over 2 years experience in SaaS Applications like Salesforce, Marketo and 3+ years of experience in developing solutions to Integrate between oracle and other third - party systems using oracle fusion Middleware.
• Extensive experience in RICE design methodologies and practices.
• Oracle Order Management, Pricing, Service Contract and Teleservice integration with Salesforce.
• Salesforce and Marketo Integration for Leads, Campaigns and Activities.
• Technical expertise in Oracle E-Business Suite modules like Order to Cash, Pricing, Install-Base, BOM,WIP, Inventory, Purchasing, Shipping, Service Contracts, Financials, HR, web ADI, XML Publisher.
• Development, maintenance and daily support for SOA /BPEL & ESB processes.
• SFDC System Administration experience.
• Experience in SQL/PL/SQL Performance Optimization.
• Strong Problem solving, Analytical skills and ability to work in a time-constrained and team-oriented environment.
• Hands-on experience with Oracle Forms/Reports, Libraries, SQL, PL/SQL, Interfaces/APIs, Workflow, Web PL/SQL, Forms Personalization, SQL Loader, XML Publisher and Web Services .
• Extensive experience in Interfaces, Customizations, Extensions and Data migration.
• Data Gathering and Solution Recommendation.
• Design of Application Extensions and Integrations.
• Preparation of Documents and User Guides.
• Daily Production Support and Application Administration in Oracle applications.
• Managed Projects, Enhancement requests and deployments.
• Solution recommendation and Support for Order to Cash, Procure to Pay, Manufacturing and Financial functional tracks.

TECHNICAL SKILLS

Oracle Application: Oracle Financials, Quote to Cash, Procure to Pay, CDH, HRMS, Install Base, Service Contracts, Oracle Inventory, BOM, Costing and Oracle Projects

SaaS: Sales Cloud, Service Cloud, Marketo Lead Management

Middleware: Oracle SOA, BPEL, ESB

Programming Languages: PL/SQL, SQL, Java, XML, HTML

Developer Tools: Oracle Forms6i/9i, Reports 6i/9i, Discoverer, TOAD, Oracle Workflow Builder, JDeveloper, XML Publisher.

PROFESSIONAL EXPERIENCE:

Confidential, Pleasanton CA

Information Technology Specialist

Responsibilities:

• Responsible for requirement gathering and process design for various Corporate Projects
• Performed Data/System analysis to help decide the project timeline, System design and Implementation Plan.
• Responsible for requirement gathering, data extractions from Oracle Procurement and AP for Enterprise Procurement’s Spend Analytics tool-Ariba spend visibility .Prepared transformation and data mapping documents for data extraction from Oracle EBS. Developed custom solution to extract and load data into Ariba.
• Performed GAP analysis and upgraded the Perceptive Content 7- A content management system that HR manages to keep Employees Office Personnel file. Developed Cusom sql Script to develop Audit reports that provides document viewing history. Developed Custom PL/SQL batch process to update latest Employee profile into Perceptive content.
• Active member in the design and development of SCIF’s Wellness platform-Wellness portal. Designed the data model and Developed oracle-Wellness user profile Sync process and CSS styling for wellness Web UI
• Developed WEB ADI interface for HR to accommodate IT reclassification changes.
• Configured iExpense Spreadsheet setup to upload expenses to oracle EBS.
• Discoverer report to Print All Expense Report since existing Report Not Capturing every Expense Report
• Periodic/Event alerts to send notifications to HR for Applicant status change, Data change, Employee termination, Employee termination reversal.
• Resolved critical production issues, managed Oracle issues via TAR escalation.
• Managed production rollouts. Used FNDLOAD for code migrations in various environments. Used WINCVS as a repository for version control.
• Provided effective production support for AP, AR, HRMS, GL& PO on daily basis.

Confidential, Alameda CA

Sr. Technical Analyst-Business Applications

Responsibilities:

• Responsible for requirement gathering and process design for various Corporate Projects
• Performed Data analysis to help decide the project timeline, resources, System design.
• Prepared Data transformation and Mapping documents for data migration from oracle to various other CRM Applications like SFDC Sales Cloud, SFDC Service Cloud, Marketo etc.
• Designed and developed various integration projects like between oracle and various Custom/Third-party applications like Windshare, Vastera, Mindtouch, Download Center etc.
• Developed New Service Entitlement process to create Support Cases in SFDC based on customer entitlement changes in Oracle Service Contracts. As part of the process developed custom Oracle APIs and BPEL process to extract and upload data to SFDC on daily basis.
• Lead the Electronic software Delivery project initiative to reduce the shipping overhead. As a technical lead, designed and developed new process for ESD Orders. As part of the process, modified existing Order creation process from SFDC to Oracle to support Electronic (ESD) orders, New OE validation to restrict ESD products from ship orders, New ESD notification (XML Publisher) to notify customers with order details and download instructions when an ESD order is processed in Oracle, Developed Custom Pl/Sql APIs to provide order, service contracts, and product & install key details of the ESD order purchased in Customer Download center.
• New BPEL process for Pricing Integration between SFDC and oracle. Developed custom programs using Oracle Pricing APIs to process the pricing updates.
• Development and maintenance of new BPEL process to get Oracle Install Base details for Service contract creation in SFDC.
• Custom Integration to sync leads from Windriver Contact center/ Whitepaper downloads/SFDC to Marketo (Marketing Application).Developed custom APIs/Tables/BPEL to process leads from these sources to Marketo.
• Developed custom APIs to display Employee details for Employee Directory.
• HR Employee Extract for Benergy and Travizon.
• Modified APEXP workflow to expedite iExpense approval/review process for Executives. The intent is to review and remove any bottleneck so that Executives are paid/ reimbursed faster.
• Custom API to modify EMEA Freight tax code change in Auto invoice interface for freight lines.
• Vastera Check (BPEL process/ Vastera API) to restrict processing orders/service to certain denied parties/customer/leads.
• Developed and supported several enhancement requests for Form personalization, Workflow Modifications, Discoverer Report changes & RDF changes from different business tracks.
• Developed and maintained several OM/HR XML Publisher reports using Rdf & Pl/Sql as data source as part of migrating JETFORM reports to XML Publisher.
• Developed custom AP Payment formats and Payment extracts for Citibank SEPA EFT file transfer.
• Provided effective production support for OM, SC, IB, AP, AR, HRMS, GL, INV, QP, Projects, BOM, Tele Service on daily basis.
• Resolved critical production issues, managed Oracle issues via TAR escalation.
• Managed production rollouts. Used FNDLOAD for code migrations in various environments. Used WINCVS as a repository for version control.
• Involved in deployment planning meetings and managed deployment of Technical deliverables for this project in a timely manner and Prepared technical status tracking, technical design, deployment documents
• Coordinated with internal Sales force team in planning and preparing technical deliverables based on project timelines.
• Developed migration scripts to export data from Oracle HR to load data into Oracle HCM. Developed integration process to sync data between Oracle core HR and Oracle HCM
• Integrated environment setup to conduct development and testing. Prepared test cases to make sure the integrated environment is working.
• Developed migration scripts to export data from Oracle to SFDC Service & Sales Cloud.
• Managed testing and rollout of data migration from Oracle to SFDC on various environments like Development, Test and Production
• Participated in business requirement gathering, prepared requirement documents, functional and technical design documents.

Confidential , San Jose CA

Sr. Oracle Application Developer

Responsibilities:

• New AME Rules, Conditions and Usages to create business specific quote Approval Rules in order to optimize the Quote approval cycle.
• Customized the Quoting user hook to calculate Discount % based on the DFF value.
• Modified Quote Approval workflow notifications with VP approval authority to show GM% and Category Discount %.
• Modified Quote Approval workflow notifications to provide Link to Quote Details to approve through Black Berry.
• Developed BPEL Process to Create, Find and Print Quotes for Pillar partner portal.
• Responsible for creating “Sales Responsibilities” for channel partners. These responsibilities restricted the ability to discount quotes, submit orders, view custom reports, view pillar pricelists, view pillar Quotes and Opportunities.
• Developed a custom cost import interface to insert /replace new costs and cost elements like material, resource and overhead into CST tables using standard ‘Cost Import Process’.
• Customized QP CUSTOM for special Service Pricing. Also, Created formula to implement special service pricing.
• Service Pricing Enhancements.
• Calculate EMEA Distributor Service Prices from EMEA Standard price list.
• Top Model quantity is applied twice in the final calculation - Bug in the existing system
• Exclude certain Software Products from Current Service pricing calculation.
• Customized REQAPPRV workflow to add custom routing to include Engineering Approver.
• Pillar HR Enhancements and Customizations.
• Custom packages to extract new-hire information and data changes for existing employees from Oracle HRMS into text file in order to upload to ADP and PROVIEW
• Customized HRSSA workflow time off notifications
• Modified Employee Self Service (ESS) and Manager Self Service (MSS) pages .Customization involved creating new messages, changing text, hiding fields, buttons and regions and disabling LOV values.
• New formula LOA to skip Weekends.
• Discover/SQL reports such as Employees Cost Allocation, Terminations, Head count, Organizations Supervisory Hierarchy.
• Customize HTML Print Quote Functionality to display “Quote report - No Price” option only in the Quote Template List and jsp customization to default selection of subtotals by product category.
• Alert to send “Standard Quote report - List Price” output for all approved quotes to certain power users.
• Customized Lead and Opportunity Center Forms using CUSTOM.pll to make source code mandatory.
• Customized standard reports such as Invoice Print Report, VP Quote Report, Vendor Service Performance Analysis Report, Min-Max Planning Report and Order Acknowledgement Report.
• Created several SQL reports & Discoverer reports such as Sales Coach, AR revenue distribution.
• Provided production support for AP/AR/GL/HRMS/PO/Quoting/OM/INV/BOM/Marketing. Resolved critical production issues, managed Oracle issues via TAR escalation and web conferencing.
• Wells Fargo Extract Program for AP.
• Managed production roll outs. Used FNDLOAD, WFLOAD for code migrations. Used WINCVS as a repository for version control.

Confidential , San Francisco CA

Application Developer

Responsibilities:

• Customization using CUSTOM.pll.
• Order Organizer form to show all related orders for a specific customer number
• Sales Order Screen: Enforced credit card number and expiry date mandatory when payment term is Immediate and Payment type is Credit Card
• E-Business center: Enabled zoom button to show ‘Consolidated Sales History’ Discoverer report when users query on a particular customer account
• Implemented Install Base Module in Confidential
• As part of this project, I have developed interface programs to bring all previous sales records into install base track customer, item instance history
• Modified OEOL workflow to create Install Base records during shipment/Fulfillment, created scripts to make items install base track able
• Created custom packages to fix RMA errors and No instance Found errors and registered them as scheduled concurrent programs
• Modified Telesales and Install Base Forms (HTML and Oracle Forms). Customization Involved modifying spread tables (JTF Grids), adding fields and table personalization in HTML forms.
• Developed custom Noetix and Discoverer reports as per user requirement.
• Alerts to notify users important business schedules, messages and events as per business needs
• Provided support for credit card processing through Paymentech.
• Production support for AR/OM/Telesales/Install Base modules. Resolved several critical production issues, managed Oracle issues through TAR escalation and web conferencing.

Confidential, Milpitas CA

Oracle Technical Consultant

Responsibilities:

• Data import using SQL* Loader utility from ROI Legacy. Also, wrote server side packages to load Master/Detail data into custom tables.
• Custom forms using Template.fmb and registered with Oracle application.
• Performed System Administration functions like defining Profiles, Responsibilities, Menus, Functions, Forms, Concurrent Programs, Value-Sets, Print Styles and Flex Fields.
• Customized Order Entry and Quoting Screens using Custom.pll. Created a new procedure to calculate ATP details and display it on a custom form.
• Enabled Zoom functionality in Discrete Jobs screen to bring up a custom form that shows problem codes, diagnostics codes etc.
• Developed custom Sales Order Activity repo rt to print Daily/Weekly/Monthly /Yearly Booking and shipment details
• Developed Shipping Backlog Report which prints shipping backlog and work order details associated with the sales order. Defined new Printer Style for this report.
• Developed SQL Reports and Modified Oracle Standard Reports such as

Confidential, Jamesburg NJ

Oracle Technical Consultant

Responsibilities:

• Imported flat file data into the staging tables using SQL*loader utility. Wrote server side packages to perform validation checks and insert data into pricing table using QP price list pub.process price list API.
• Customized Telesales forms to in corporate Oracle enhancements that were available in 11.5.6 Telesales forms. Also, modified custom.pll to provide “pop up” message for quantity availability.
• Server side package using OE order cache.load line type API to override the defaulting rule for “Schedule Ship Date” in OM based on the line type selection in the order line. Added line level dependency between “Schedule Ship Date” and “Line Type” in OE dependencies extn package to make it effective in order line.
• Developed several custom reports and modified standard oracle reports
• Daily production Support, Performance Tuning and Maintenance of existing code .Used PVCS to maintain different versions of code.