Shruti Jain

Mobile: +1-949-***-**** Exp: ** yrs Email: adg5fz@r.postjobfree.com LinkedIn Profile: https://www.linkedin.com/in/shruti-jain-72601a19/

Oracle Apps Technical Consultant

Professional Summary

Around 11 years of experience as an Oracle Applications R12/11i (E Business Suite) Techno Functional consultant, with expertise in Oracle Financials modules (AP, AR and GL), Supply Chain Modules(OM, INV, Shipping, PO) and Service and Depot Repair modules

Hands on experience to upgrade Oracle On-Premise solution to Oracle IAAS Cloud based solution which involves lot of coordination, analytical skills, complete architectural knowledge of application and strong technical skills.

Expertise in implementing RICE (Reports, Interfaces, Conversions, Extensions) components in the area of technical design, development, Integration testing and deployment using open interfaces and APIs.

Exposure to OAF customizations using J Developer

Plan and integrate architectural frameworks for Oracle applications with other applications and translate to Oracle intelligence.

Acted as the primary liaison between the client departments and the Information systems department to collect requirements, business process information and documented them in Document post analysis of all risks associated with them

Strong Knowledge and full hands on experience in Order to Cash (O2C) and Procure to Pay (P2P) Cycle and other Oracle Application modules like OM, PO, AP, AR, WMS and GL.

Extensively worked on changing the reports according to client requirements and Optimizing the Report Performance using XML publisher and Oracle report builder

Strong Knowledge in creating Analytical reports/KPI/Dashboards using Power BI, Discoverer Reports and working knowledge of Oracle Analytics Cloud.

Sound knowledge on EDI implementations and integration with Oracle apps.

Integration knowledge on Loft ware labeling system where managed and created new labels for shipping, packaging material for different vendors

Solely managed the activities like design, development, coding, testing and End-user training.

Substantial development experience in creating stored procedures, Packages, Triggers, Functions, Indexes etc.

Proficient in Performance Tuning SQL statements using EXPLAIN PLAN, AUTOTRACE, SQLTRACE and TKPROF.

Good working knowledge in designing technical documents using AIM Methodologies (MD50, MD70 and TE70).

Experience in using Oracle tools like SQL Navigator, SQL*Loader, Data Loader, FND LOAD, SQL developer and TOAD.

Automation by writing PLSQL scripts to trouble shoot the bugs.

Good experience in Remote database administration using Winscp software, remote desktop, Filezilla and Putty

Good hold on Unix commands and shell scripting

24x7 Production Support, customer interactions, team-player, and ability to handle multiple tasks independently.

Understanding the gaps between systems and providing the analysis and solution for same

Technical SKILL SET

ERP: Oracle E-Business suite R12/11i Accounts Receivables AR, Accounts Payables AP, Order Management OM, Shipping, Purchasing PO, General Ledger GL, WMS, Cost Management, Service

Application Tools: Oracle Reports, XML Publisher Reports, Discoverer Reports, Oracle Forms 6i/9i/10g, Form personalization, Microsoft Power BI

Databases & Tools: Oracle 11g/10g/9i, TOAD, SQL*Loader, SQL* Developer, TFS, HP Quality Center, JIRA, Serena, Subversion, Winscp, Jdeveloper

Operating Systems: Windows XP/7, UNIX

Languages: SQL, PL/SQL

Scripting Languages: Unix Shell scripting

ETL: Oracle ODI 10g

PROJECTS

Company: Denso Ten America Limited Mar-2018 till now

Job Title: Oracle EBS Developer

Current Project: Oracle Apps R12 ERP support, EDI Implementation Integration with Oracle, Power BI implementation, and Overall IT support to Michigan, Texas and LA locations.

Description: Denso Ten America ltd is a leading provider of high quality automotive audio, video, navigation and control systems in North America marketplace. Provide support to existing ERP system in 12.0.5. Plan and facilitate process mapping, requirement gathering, new development and testing. Building solutions to support new business flows by developing new oracle forms, form personalization, interfaces and reports etc.

Responsibilities:

Single point of contact from technical side to support existing ERP system, finding RCA and bug fix all issues across all locations. Accountable for implementations design, stability, scalability and expandability of the architecture.

Key member and accountable for oracle R12 upgrade from On Premise solution to Oracle IAAS cloud based solution. Responsible for Oracle EBS integrity with various third party application after IAAS move, requires good analytical, technical and interpersonal skills for stable business operations.

Assessing migration of BI reports to Oracle Analytics Cloud/ Power BI.

Creating new reports and dashboards for business users in discoverer.

Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis, designed new process flows, documented the Business Process, various Business Scenarios and activities of the business from the conceptual to procedural level.

Responsible for functional test cases, UAT and approval process for migrations

Provided Customized End to end solution from Order entry to shipping with EDI integrations like EDI 850, EDI 856

Development of Labels using Loftware Systems Software

Personalize OAF pages and developed OAF form as per business requirements like PDI Data management

Designed and developed various custom interfaces to upload inventory items, update item cost, update item price which enhanced efficiency of business users.

Developed interface to upload dealer daily web based file to create service requests, repair orders and setup customer master if customer details are missing. This reduced 90% of manual work done by call center

Creation of custom oracle forms using form builder to support warehouse users on conveyor belt, ASN extensions and Unix Scripts.

Worked with various Business stakeholders to gather reporting requirements, understand the intent of reports, development of reports and attended meetings to provide updates on status of the projects.

Implement strategies to migrate discoverer report to Microsoft Business intelligence Power BI.

Development of financial reports using XML publisher, discoverer and oracle report builder as per accounting requirements from AP/AR and GL.

Customized complex Packing Slip, Pick Slip and other EBS reports as per requirement to support business

Existing EBS support to fulfill day to day user requirements for all modules Service, CRM, Sales, Finance, Purchasing (OM, AP, AR, GL, PO, Service, INV, Depot Repair)

Present deliverables, risks, issues and status to senior stakeholders and managers

Managing and following up on Oracle SRs

Development of many reports to support JSOX Audit company wise

Maintained documentation for all change requests and code versions using SVN

Monitor end to end supply chain process and ensure there is no issue

Past Experience – Infosys Limited (8 Years 2010 – 2018)

Project 1: MNAO Implementation (Mazda North America Operations from Jan 2015 – Mar-2018) –Irvine, CA

Job title: Oracle Application Tech Lead

Description: Migration of Mazda’s parts business in three geographies (US, Canada and Mexico) from legacy applications to a next generation supply chain platform based on Oracle Applications (eBS R12) as part of its Global Supply Chain Management program (GSCM). As a part of this implementation, it is required to develop real time and batch interfaces to synch up various legacy dealer systems, interfaces to replace PDC, MEANS Legacy system, Outbound financial data from EBS to SAP.

Responsibilities:

Work on designing interfaces as per the requirement, Performance and Index tuning.

Extensively worked on ETE complex shipping interfaces to receive the inbound EDI 856 ASN interface data to oracle apps and then outbound to third party warehouses for receiving Vendors and PO by mapping the data, writing oracle stored procedures, packages and oracle seeded packages.

Email notification of erred ASNs to business users.

To correct the ASNs in EBS created one customized ASN correction form which open up the functionality to reprocess the ASNs in error.

Worked on AP /AR and GL outbound interfaces for sending the invoices, credit memos, debit memos and GL related data to SAP on business requirements by writing PL/SQL, stored procedures and packages

Worked on SAP to AP inbound interface for AP payments where file transfer is done by middleware team to eBS staging tables

Worked on the development of SOA, EDI 810, EDI 824 and Batch based Interfaces, Customizing Oracle Reports in finance touching various modules such as GL, AR, INV and OM.

Worked on performance tuning like Explain Plan to improve the performance of various custom PL/SQL Packages developed.

Prepared many Functional and Technical documents for requirements, design, and implementation steps, test plans and functional user training guides for all the phases of the project

Code review of all components before they deployed to any environment

Developed various oracle alerts to notify users for any error in interface or standard programs

Project: Dana Europe/Mexico Implementation from Oct 2013 – Jan 2015

Job title: Oracle Application Tech Lead

Description: Implementation projects of Oracle 11i for a leading manufacturer of drivetrain technology. It requires full development and implementation of interfaces (Inbound/Outbound) and other RICE components which were client specific

Responsibilities:

Worked on backend of container management workbench for OM module and delivery system in WMS to load the truck delivery details in EBS

Worked on HFM(Third Party) outbound interface to get the GL data

Worked on hard pegging solution interface in ASCP module where sourcing rules are assigned to OSP items. Sourcing split and allocation of component requirement to multiple suppliers.

Form personalization on AP is done to show users warning message

Prepared technical specifications documents MD70, test scripts, assembly test documents and deployment documents based on the functional requirement specifications MD50.

Registered concurrent programs in Application Object Library (AOL).

Developed UNIX Shell scripts to FTP the Flat file from External Server to Oracle UNIX Server location

Client: Toyota Motors Europe Dec‘12 – Oct ’13

Job title: Oracle Application Tech Lead

Description: Oracle Financials Pan European R12 Implementation & Rollout, Oracle Application is the main platform used by TME and affiliates.

Responsibilities:

Developed Oracle Alerts and set up vacation rules

Involved in application testing, deployment and production support.

Performed Unit Testing and captured the results.

Performed Knowledge Transfer to end users on how to submit the jobs and check the flat file contents.

Development of inbound and outbound interfaces in AR module

Helped End-Users performing User Acceptance Testing (UAT).

Project 3: Fanuc Americas from Jun’11, Dec’12

Job title: Technology Analyst

Description: Implementation of R12 upgrade project from Oracle 11i) for leading supplier of robotic automation in the Americas where played critical role by developing RICE components and major enhancement with form personalization in AP modules.

Responsibilities:

Analysis of modules, task distribution, Client calls, Coding, Unit testing, Bug fixing and delivering Execution document, Technical Specification to client.

Development of form personalization, forms and reports in AR, AP, OM modules

Enhancements in PLSQL packages

Enhancement in .rdf reports, .fmb forms and writing unix scripts for interfaces

Deploying application in all environments (Dev./Test/Staging/Production).

Client: Arrow Unity Dec ‘10 – Jun ’11

Job title: Senior systems developer in Oracle Apps

Description: Arrow Conversion is a project that includes process where existing data from the client’s old system is extracted, cleansed, formatted, and installed into a new system. Before Go-Live in the production environment the required master data, the open transaction data and the historical transaction data need to be imported from the old legacy applications to Oracle Applications.

Responsibilities:

As Senior Systems Eng. Functional Specification gathering, Coding, Bug fixing and delivering Execution document, Technical Specification to client.

Responsible for ETE Conversion of GL, Customer Master and sourcing rules in oracle R12 from legacy system

Preparing and Publishing fallout details for the application.

Deploying application in all environments (Dev./Test/Staging/Production).

Writing reconciliation scripts in pl/sql as per the requirements.

Company – Tech Mahindra Limited 2008-2010

Client: Tiscali Support and CNM management Dec ‘08– Dec ’10

Job title: Technical Associate in Oracle Apps

Description: CNM is a centralized team to support all communications with an AT&T customer, which includes resolving tickets, a data (email) repository, and integration with systems to support customers

Responsibilities:

As Technical Associate Requirement gathering, Application Interface Design, Coding, Bug fixing and delivering notes to client.

Writing scripts in PLSQL as per requirement.

Bug fixing

Automation to find stuck orders

Responsible for P1/P2 Ticket resolution

Learned various modules such as order management, accounts receivable and accounts payable while working on support project

Participate in walkthrough and Preparing Project related Documents

Team Management

Working closely with the development team for resolving critical issues

Interacting with business professionals for system study, requirements verification and analysis.

Ramping up the teams’ knowledge base if the team member is new to process by providing appropriate trainings.

Scheduling Daily and weekly meetings for sync up on ongoing issues as onsite counterpart and tech lead

QUALIFICATIONS

B.Tech in Computer Science & Engg: LLRIET College under PTU with 82.5% (2008)

Contact this candidate