Sarthak Rohilla Email & Phone Number

Sydney, NSW, AU

Acton, MA, US

- Participated in Global design as technical architect, Requirements gathering for integrations across different modules in Oracle Fusion Cloud, worked closely with Business and Functional leads to understand requirements and provide overall solution design of integrations. - Worked on multiple RFP deliverables as part of pre sales process, deciding and.

-Designed and developed Oracle- Ariba(SAP) PO integration process.- Developed Custom EDI 945 and 940 Process for Client ( third party warehouse)-Developed Cloud ERP GL Actual and Budgets OBIEE report and integrated the report output with Tableau.- Implemented Oracle Order export compliance( International Trade Management) for customer to check for denied.

- Designed functional requirement document for Custom EDI 940, 850 Oracle interfaces and coordinated end to end testing(functional, regression, validation and smoke) with the Customer.-Created test and Deployment Documents as part deliverable.- Troubleshooted defects and proposed feasible solution for change requests.- Developed complex Xml publisher.

- Created Complex XML Publisher GL detail report in Oracle Fusion Applications from scratch. - Created new Oracle R12 AP check template ( RTF).- Simplified data extraction flow for existing Oracle OPM BI Report, reducing its execution time by 400 percent. - Worked on various extensions in internal Oracle Diagnostic tool, which included working on multiple.

- Planned and executed Marketing activities of various events of club at UT Dallas held in the month of December.- Conducted deep dive sessions on Business analysis for the Club members. Event went for multiple weeks and Business Analysis process from Requirement Planning to Traceability Matrix was covered in detail.- Coordinated and Executed various other.

Teaneck, New Jersey, US

• Gained Functional expertise on Install Base and Service Contracts modules of Oracle Applications.
• Lead the team of 5 members, who were involved in Developing Service Contract Creation Process for Vmware’s RS2 Project.
• Developed a PLSQL API to automatically initiate the transfer of Quote (Service Contract) XML file to clients JSCAPE Server at partner-specific location.
• Developed Complex interface(API) exposed as web service to SOA, which will be called by partner for service contract creation and consolidation. This is a custom process, which acts as alternative to standard Oracle.
• Developed Java Concurrent Program for Generation of Quote Files Based on XML Data Templates in PDF, XLS and XML format on EBS Application Server.
• Created Custom Business Events for Triggering the Middleware (Oracle SOA) Process Flows.

Austin, Texas, US

• Functional knowledge on Order Management (Inventory, Bill of Materials, Quoting(ASO) modules).
• Administered one of the Project Release as Offshore Release Coordinator.
• Tuned the existing business flow for Quote duplication and brought down the execution time by 200 percent.
• Worked for NetApp on CRM implementation (Order to Cash Cycle) project focusing primarily on integration between Sales force and Oracle. Requirement gathering, Code development, Unit testing and documentation were major.
• Created Inbound and Outbound interface using advanced PLSQL and Oracle SOA Repository to generate PLSQL web services.
• Developed PL/SQL Reports, Conversions, Interfaces, Extensions in Oracle R12 Environment.

Austin, Texas, US

a) Successfully completed 3 months Training at Oracle university ( OTP,Bangalore) with the emphasis on following areas: 1. SQL 2. PLSQL and Advanced PLSQL 3. Oracle Forms and Reports. 4. Oracle BI Publisher 5. Oracle Purchasing (Procure to Pay Cycle) 6. Oracle Fulfillment ( Order to Cash cycle) 7. Oracle Financial. 8. Oracle Receivables. 9. Oracle.

Master'S Degree, Information Technology And Management

Btech, Electronics And Communication