Candidates About

 

Ashish Tripathi

           Summary

• Having 6(+) years of experience in Oracle Application as Techno-Functional Consultant.

·        Extensively worked on Procure-to-Pay (P2P) and Order-to-Cash (O2C) with iProcurement and iExpense, Supply Chain Management (SCM), WIP (Work in Progress), Service Contract, Installed Base (CRM), Advance Pricing and Approval Management Engine (AME), EB-Tax including related Open Interfaces and APIs.

·        Extensive experience in Defining Value Sets, Lookups, Descriptive Flex Fields, Messages by using Application Object Library (AOL).

• Actively Involve in data conversion/migration from legacy system to Oracle Application database in multi organization and multicurrency environment using SQL*Loader, PL/SQL Open Interface and API’s Programs.
• Extensive experience in PL/SQL programing to develop Packages, Stored Procedures/ Functions, Collections, REF Cursors, Bulk Collect and Database objects like Table, Views, Materialized views, Indexes, Constraints.
• Extensive experience in using Oracle hidden Packages like DBMS_SQL, UTL_FILE, DBMS_OUTPUT, DBMS_UTILITY, UTL_HTTP and UTL_SMTP, Web Service Integration.

·        Continuous review of Business critical Database to proactively identify space issues, performance tuning issues.

·        Conducted Performance Review of Oracle Database for business critical applications with Senior Leadership team.

• Extensive experience of writing Shell scripts and Cron Job/Tidal job scheduling.    
• Extensive experience in developing Oracle Apps Custom Forms using Template.fmb.
• Hands on Experience on XML/BI Publisher, Bursting, Oracle Forms/OA Framework Personalization and Alerts.
• Hands on experience in development of RICE and CEMLI components.
• Extensive experience of custom Forms/Reports Migration from 11i to R12.
• Extensive experience of Oracle APEX 4.0/4.2 and Integration with Oracle Application.
• Having Extensive experience with Oracle XML Gateway setup for ASN in Multi Org Environment.

·        Demonstrated ability to identify root causes/ debugging of problems and troubleshoot, considering both long and short-term impact of proposed solutions and developed workable solutions.

• Wrote ETL (Extract, Transform and Load) script for data Warehousing (Oracle Data warehousing/Informatica tools).

·        Extensive experience of third parties integration with Oracle apps using XML or Web services. (Ex. CONCUR, COUPA, Sales Force).

·        Experience in Working on Onsite and Offsite Model and manage the WSR (Weekly status report) and Tickets status.

• Strong Problem solving skills using Metalink–TAR, involved in 24 X 7 production Support.

·        Ability to work individually as well as in a team, Self-motivated and committed person with excellent interpersonal communication skills and willingness to learn new tools, concepts and environments.

 

 

 

Technical Skills

EBS	Oracle EBS (E-Business Suite) 11.5.10.2 and 12.1.3, 12.2.4 GL (General Ledger), SLA (Sub ledger Accounting) AP (Account Payables), AR (Account Receivables), PO(Purchase Order), INV(Inventory), OM(Order Management), iProcurement, iExpense, Service Contract and Install base.
RDBMS	Oracle 11g, 10g, 9i, MySQL
Language	PL/SQL, SQL, C, C++, Java Script, XML, HTML
Development Tools	Oracle Forms 10g/6i, Workflow Builder 2.6.3, Oracle Apex 4.0/4.2, OA Framework (OAF)
Reporting Tools	Oracle Reports 10g/6i, XML/BI Publisher, Oracle Apex 4.0/4.2, Discoverer
Operating System	Windows XP/7, Linux and Unix
Other Tools	TOAD, SQL Developer, Microsoft Office (Word, Excel, PowerPoint,              MS Access), Perforce, Service-Now, Tidal, SSH client, WINSCP, Putty and Star Team

 

 

Professional Experience

 

C&S Grocers, Keene NH                                                                                                                                         (Feb 2015 to Till Date)

(Sr. Oracle Consultant)

Responsibility:

·         Involved in meetings with Business users and Functional folks.

·         Customized some standard processes in P2P and O2C standard flow to fulfill the business need.   

·         Imported BICEPS PO in to ORACLE Application and created invoice in AP.

·         Applied the deals concept (Company specific) on Customers Sales and given the discount based on the deals.

·         Calculated Deals amount on sales using custom application and create accounting for those transactions.

·         Created AR Invoices for external source, Pushed into Sub ledger and created journals using custom code, standard Interfaces and Concurrent Programs.

·         Extracted the item level sales information and send to Hyperian system.

·         Extracted Vendor information from Oracle and send to Mainframe system using SOA and configured XML Bursting for sending multiple alerts to Business team.

·         Extracted AP, AR, INV, GL data for OBIEE reporting purposes.

·         Extracted PO Information and sent it to Teradata system using SOA.

·         Developed Finance reports using XML Publisher as per the business need.

·         Involved in Go-Live and Post-Production support activities, resolved the tickets on priority basis. 

·         Customized the standard PO form for searching PO from other sources like BICEPS which reside in attribute values.

·         Wrote a Customer and AR Invoice conversion for recently acquired company.

Environment: R12(12.2.4), (OM, INV, PO, AP, AR, GL), Oracle Database 11g, Forms/Reports- 10.1.2.3.0, JDeveloper, Oracle Workflow Builder 2.6, BI/XML Publisher, PL/SQL, SQL*Loader, Oracle APEX, Data Loader, FNDLOAD, Toad, Linux, STAT(5.7.2), SVN(1.7.10) and Auto Task.

 

 

 

Cubist Pharma, Lexington MA                                                                                                                             (Nov 2014 to Jan 2015)

(Sr. Oracle Consultant)

Responsibility:

·         Designed documents like MD70 (Detailed Technical Design), CV.40 (Conversion Data Mapping), CV.60 (Conversion Program Technical design).

·         Integrated Oracle apps with 3PL and Data warehouse application using PLSQL and XML Integration.

·         Developed Sales Order, Pick release and Ship confirmed Interfaces/Conversions to automate the process.

·         Customize the OAF form for validating customers info at real time.

·         Developed Purchase order and PO receipt interface to create receipt on the basis of requisition. 

·         Extracted the Finance data for data warehouse, Informatica and reporting purpose.

·         Developed the process to validate the customers using export compliance web integration.

 

Environment: R12(12.2.4), (OM, INV, PO, AP, AR, GL), Oracle Database 11g, Forms/Reports- 10.1.2.3.0, JDeveloper, Oracle Workflow Builder 2.6, BI/XML Publisher, PL/SQL, SQL*Loader, Oracle APEX, Data Loader, FNDLOAD, Toad, Linux, Service-Now.

 

Staples Inc, Framingham MA                                                                                                                                 (Jun2014 to Oct 2014)

(Sr. Oracle Consultant)

 

Responsibility:

·         Developed solutions for business in oracle application through functional setup and Technical development.

·         Worked in Offshore and Onshore environment.

·         Extended and modified the Web services to import data from Java based custom Application to Oracle Application.

·         Developed complex custom APIs for Rewards calculation using PL/SQL and Shell Scripts and configured in (Concurrent Program) Oracle Application.

·         Scheduled jobs on Linux server using CronJob/Tidal to import data through FTP and push into Oracle Application DB.

·         Designed AP Invoice Interface to create invoices on for Rewards amount on the monthly basis.

·         Customized Oracle OA Framework form to maintain customer information on Weekly, Monthly and Yearly basis and showing their Rewards calculations and Paid date using drop down option.

·         Developed Monthly statement, Check format report for customer, Monthly detailed and summary reports using BI/XML Publisher for business.

Oracle Apex-

·        Formulated SQL queries, functions and processes as per customization requirement for APEX.

·        Supported APEX applications and conducted performance tuning for PLSQL.

·        Contributed with database designs and assisted in increasing response time for APEX reports.

·        Designed application framework and developed Oracle APEX Application.

·        Developed Custom Reporting application using Oracle APEX 4.0/4.2 and used E-Business Suite user/responsibility authentication.

·        Designed shipping queue dashboard report, Auto refresh report using java script in Oracle Apex.

·        Oder book and pick release interactive report in oracle Apex with on page print button.

 

Environment: Oracle Application 12.1.3 (AP, PO, SLA, GL), Linux, PL/SQL, Oracle database 11g, Oracle Apex, Oracle Reports 10g, Oracle Forms 10g, Oracle Workflow Builder 2.6, PL/SQL, SQL*Loader, Toad, WINSCP, Web Services, Shell Script, CronJob, Service-Now.

 

Greatbatch, Clarence NY                                                                                                                                      (Aug-2013 to May-2014)

(Sr. Oracle EBS Developer)

Responsibility:

·         Interacted with the Business/end users and gathered all the required information and converted into functional documents.

·         Customized the standard Account generator workflow for Purchase Order.

·         Upgraded Oracle application from 11i to R12 with Forms and reports.

·         Upgraded the interface and conversions with the necessary changes.

·         Developed Context based Zoom form to store additional information on PO, Quotation and RFQ Forms.

·         Wrote multiple packages for calculation purpose using advance PL/SQL and converted data into excel sheet using UTL_FILE.

·         Developed multiple views for AR analytical reports using PL/SQL.

·         Wrote ETL Script for data conversion to use in legacy system.

·         Developed custom reports for Requisitions, PO’s and Invoices and PO-Projects link, Matched Unmatched Report, AP Expense reports as per the business needs using Oracle Reports and XML Publisher.

·         Extended OA Framework based custom form to full fill user needs.

·         Personalized the PO(Purchase Order) and Requisition form to address business needs like additional Validations, renaming fields label, populating default values  and prompt messages.

·         Designed Alerts (Both Periodic and Event based) to send emails on new events like when new supplier or customer created or modified, and submit concurrent programs.

·         Experience with Sub Ledger Accounting (SLA) and Trading Community Architecture (TCA).

·         Written Conversions and Interfaces for data conversion (PO, PO Receipt and Requisition) using SQL Loader and Open Interface.

·         Configured Dependent free text DFF and Context based DFFs on PO, RFQ and Quotation forms.

·         Migrated objects from one instance to another instance using FNDLOAD.

·         Worked on AOL (Application Object Library) functionality to register Reports, Forms, Functions, and various types of concurrent programs like PL/SQL packages, host etc.

·         Created Technical documents (MD 70) on the basis of Functional documents (MD 50).

        

     Oracle Apex –

·         Used Oracle APEX 4.2 for designing application structure.

·         Formulated oracle process, data retrieval methods and SQL code blocks.

·         Designed and evaluated applications, and provided architectural input apps.

·         Coded, tested and troubleshot software applications.

·         Conducted unit testing and maintained data extractions and object models.

·         Supported QA activities, test plans and performance enhancement techniques.

·         Invoice register with filter facility, Payment register and customer invoice classic report in Oracle Apex with export data facility.

·         Invoice balance and vendor wise Invoice interactive report in Oracle Apex with on page print facility.

·         Developed form in Oracle Apex to upload data from “.csv” file into oracle Database tables and popup on form.

 

Environment: Oracle Application 11.1.3 and 12.1.3 (INV, OM, PO, AP, GL, BOM, Service contract, Installed Base), Linux, PL/SQL, Oracle Apex, Oracle database 11g, Oracle Reports 10g, Oracle Forms 10g, Oracle Workflow Builder 2.6, PL/SQL, SQL*Loader, Toad, WINSCP, JDeveloper.

 

Blue Coat, Sunnyvale CA                                                                                                                                           (Feb 2012 to Jul 2013)

(Consultant Oracle Application)

 

Responsibility:

·        Designed and developed interface and conversion programs for AR Auto Invoice, Auto Lockbox and Customer information using SQL Loader and Open Interface/API.

·        Developed custom Discount forms to give discounts to customers as commission from AR to AP, using Template.fmb.

·        Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API(Interfaces) to import the data from legacy system into Install base IB tables

·        Setup the formula based Advance pricing and Qualifier/Modifier for the specific items.

·        Customized the OM Header workflow and added Export Compliance functionality using Web service to validate ship to Customer Information.

·        Developed Vendor wise Cancel Report to display PO Details, BOM Report by using XML Publisher.

·         Developed Custom Reporting application using Oracle APEX 4.0/4.2 and used E-Business Suite user/responsibility authentication.

• Customized order booking, order cancellation and Order Hold Summary report for Order Management with multiple conditional parameters as per the business requirements.

·        Developed PL/SQL packages for generating XML files from Oracle database using PL/SQL, DBMS_JOB, UTL_FILE.

·        Personalized the standard forms for renaming context, additional data validations, responsibility checks, and show customize messages as per the business needs.

·        Worked with AOL (Application Object Library) to register Forms, Functions, Reports, PL/SQL packages, Values Sets, add profile options, Enabled DFFs etc.

 

Environment: R12(12.1.3), (OM, INV, PO, AP, AR, GL, BOM, Service Contract, OLFM and Install base), Oracle Database 10g, Forms/Reports-10g, JDeveloper, Oracle Workflow Builder 2.6, BI/XML Publisher, PL/SQL, SQL*Loader, Oracle APEX, Data Loader, FNDLOAD, Toad, Linux, Service-Now.

Rolta India Limited, Gurgaon (India)                                                                                                               (May 2011 to Jan 2012)               

(Consultant Oracle Application) 

Responsibility:

 

·         Migrated and retrofitted PO, AP, GL, AR custom reports from 11i to R12.

·         Migrated PLSQL custom programs from 11i to R12 and modified those to have R12 compatible.    

·         Developed new reconciliation reports in AR using XML Publisher.

·         Developed custom form for pre-requisition to address specific business needs.

·         Designed and developed custom Pre Requisition approval workflow for custom form to get approval from authorized personnel.

·         Migrated custom forms and changed tables and views as per R12 standards.

·         Migrated AOL Objects like Value sets, Concurrent programs, Lookups, form Personalization, Request groups, and Request sets using FNDLOAD.

·         Designed few Alerts (both Periodic and Event based) to sending E-mails and schedule concurrent programs.

·         Enabled zoom forms to see the related information using custom.pll

·         Converted Legacy data from Flat file to Oracle database in Multi- Organization environment using SQL Loader, PL/SQL.

 

Environment: EBS 11i (11.5.10.2) and R12(12.1.3) (OM, INV, PO, AP, AR, GL), Oracle Database 10g/11g, Forms/Reports-6i/10g, Oracle Workflow Builder 2.6, XML/BI Publisher 6.3, PL/SQL, SQL*Loader, FNDLOAD, Toad, Linux.

OASIS Investment LLC, Gurgaon (India)                                                                                                        (Mar-2010 to Apr 2011)

(Consultant Oracle Application)

 

Responsibilities:

• Customer Conversion following AIM document set and using APIs.
• Developed Supplier Conversion and Technical documents.
• Developed Lockbox Interface as per business need.
• Unidentified Receipt application Interface.        
• Wrote PL/SQL scripts for database triggers, views, procedures/functions for custom application.
• Worked with Oracle support and TAR management.

 

Report Development:

• Developed PO, Receipt match report with different-2 format of output and Requisition Analytical reports.
• Developed Customer Invoice Report.
• Designed PO-Invoice Matching status report using XML Publisher.
• Customized the Dunning letter generation report as business needs changed.
• Developed PO-Requisition Match reports with multiple parameters.

Environment: Support 11i(11.5.10) of Oracle Application,  (OM, INV, OPM, PO, AP, AR, GL), Oracle Database 10g, Forms/Reports-6i, Oracle Workflow Builder 2.6, XML Publisher, PL/SQL, SQL*Loader, Data Load, FNDLOAD, Toad, , Linux and XML data.

SRF Limited, Gurgaon (India)                                                                                                                            (May-2009 to Feb-2010)

(Consultant - Oracle Applications)

 

Responsibilities:

• Resolved the assigned tickets daily basis within specified time period.
• Developed Invoice and PO matched status Report and PO Print report.

·         Developed Purchase order and Account Payables Invoice Report to display the PO and corresponding Invoice details.

·         Wrote Multiple Functions, Procedures, Packages and Trigger using advance PL/SQL fulfill specific business requirements.

·         Wrote dynamic query using SQL to fetch data from multiple tables and combined them in required manner to use in analytical reports.  

·         Resolved standard open interface issue and implemented data quality solutions.

• Creation of CTL file to populate data into temporary tables using SQL* Loader utility
• Developed custom reports for Payment Register and Open AP Invoices.
• Developed Payment Details Alert and Scheduled Concurrent Program through Alerts.

Environment: Support R12(12.1.1) of Oracle Application,  (OM, INV, OPM, PO, AP, AR, GL), Oracle Database 10g, Forms/Reports10g, Oracle Workflow Builder 2.6, XML Publisher, PL/SQL, SQL*Loader, Data Load, FNDLOAD, Toad, , Linux and XML data.

Education:

     Bachelor of Engineering (BE) Major in Computer Science from RGPV University, India.