Oracle Ebs Fusion

* * * * *

Resume of PRIYADHARSHINI MADESWARAN

Email: *******************@*****.***

Mobile No: 973-***-****

SUMMARY

• Over 14+ years of IT Experience in Oracle Applications. 12 years of experience in Oracle EBS (R12) and 2+ Years of experience with Oracle Fusion Cloud Applications.

• Extensive Experience in Development, Enhancement, Upgrade and Production Support of Oracle EBS and Oracle Fusion Cloud Applications.

• Strong expertise in Oracle Fusion General Ledger, Intercompany, Cash Management, Accounts Payable and Oracle EBS Incentive Compensation modules.

• Expertise in the development of Interfaces (Inbound and Outbound), Conversions, Report Development and Customization and Alerts and Oracle PLSQL.

• Experience in SmartView and Financial Reporting Studio (FRS) Reports.

• Excellent Knowledge in developing OTBI reports, designing ESS jobs and configuring scheduled alerts.

• Good experience on Fusion Middle product BPM.

• Strong expertise in the configuration of Business Units, Legal entities, Primary and Secondary Ledgers, Ledger Sets, Auto Post Criteria Sets, Account Hierarchy, Intercompany Organizations, Bank account related setups.

• Certified Salesforce Administrator with experience in Process Builder, validation rules, workflow rules, flows and approval processes.

• Worked on the design and development of custom Oracle OAF Forms for reviewing and approving and exporting customer transactions.

• Performed Customizations and Personalization in the Oracle EBS R12 Payment form to enable and disable the payment request submit functionality based on the user roles.

• Developed Oracle APEX based web dashboards to display Order and Contract fulfilment report, Order progressed based on operating units.

• Highly skilled in Oracle Cloud Enterprise Structure and chart of accounts design.

• Involved troubleshooting in Oracle Fusion functional issues in Production and provide quick resolution

• Involves in providing valuable suggestions to client in Improvement of Business process and Exploitation of process flow for better support.

SKILLS

Technology SQL, PL/SQL, Oracle Reports 10g, XML Publisher, OAF, Oracle Apex, Salesforce Admin, OTBI Reports, SmartView and Financial Reporting Studio (FRS) Reports. Tools Toad, SQL Developer, WinSCP, putty, SQL * Loader, Oracle JDeveloper, Oracle Apex PROFESSIONAL EXPERIENCE

Client Name Meta Platforms, Inc. Environment Oracle Fusion, OTBI, BPM Duration Dec 2022 – till Position Technical Lead

• Involved in the configuration of Business Units, Legal entities, Primary and Secondary Ledgers, Ledger Sets, Auto Post Criteria Sets, Account Hierarchy, Intercompany Organizations, COA, Bank account related setups.

• Created users and assign appropriate roles to user and Custom roles creation in fusion.

• Involved in the customization of Bank Statement Reconciliation rules for the automation of reconciliation in Priyadharshini Madeswaran

2 P a g e

cash management.

• Involved in the page customization in the Payments using Sandbox.

• Involved in the customization of approval process using the BPM in General Ledger.

• Cleared the exceptions arises during the process of Journal or Intercompany batches Import, Journal Reversals and approvals and posting and ensure smooth periodic closure.

• Developed Segment values or Hierarchies modification, Open Period Exceptions, GL Accounts with no activity report alert to the business users using OTBI reports.

• Created the custom allocation rules for generating allocation journals in BPM and deployed.

• Created YTD Balance Sheet and Trial Balance Financial Reporting Studio (FRS) Reports in GL. Project Name Helen Of Troy Environment Oracle EBS R12 Duration Jan 2021 – Nov 2022 Position Technical Lead

• Developed many custom OAF pages with search and export functionality of search results.

• Organized weekly call with customer and had a very good relationship with customer and maintained customer satisfaction in all deliverables.

• Developed export PDF and export WORD document by using XML publisher as template in OAF page.

• Developed OAF pages with Send Email functionality with attachment as PDF document.

• Created many PLSQL procedures, functions, and triggers.

• Developed OAF pages with export EXCEL functionality with formulas in it.

• Migrated OAF and Database objects from one instance to another instance. Project Name JUUL Environment Oracle EBS R12(OM), Salesforce Duration Jan 2020 – Dec 2020 Position Technical Developer

• Worked in troubleshooting issues that arise in O2C Process.

• Involved in Configuration of user roles and Permissions.

• Creation of various custom reports to support Client business.

• Involved in preparing knowledge artefacts for repeated production issues.

• Providing Technical Solution and Support to business requirements

• Involved in Clean-up of unused packages from instance by documenting the dependency of fields/process/folder and then uninstalling the packages from the salesforce system.

• Created custom Theme object with Lightning record page layout for ticket tracking purpose.

• Created approval process, workflow and validation rules, profiles, permission sets for object permissions.

• Worked on mass uploading of data for Sales and Service-related objects. Client Name VERITAS Environment Oracle EBS R12 (OIC, SC and OM) Duration Jul 2016 – Dec 2019 Position Technical Developer

• Performed enhancements in commission calculation packages and commission reports.

• Bug Fixing for PLSQL Packages Code Issue and providing technical solution. Priyadharshini Madeswaran

3 P a g e

• Quickly responded for the incidents created by user.

• Performed root cause analysis and built complex queries to fix the issues which raised in production environment.

• Monitored the scheduled jobs which perform commission calculation on daily basis and fixed the issue which raised during job.

• Interacted with Business analyst to analyze and gather business requirements/ production issues.

• Worked on developing PLSQL packages and Concurrent programs for business requirements.

• Created Service request and supported for SR.

• Supported 24/7 during month /Quarter/Year end to perform full calc.

• Prepared KEDB for the issues reported and reduced the incidents using KEDB.

• Maintained SLA for the incidents reported.

Client Name Polymer Group Inc Ltd. Environment Oracle (OM) Duration Jun 2014 – Jul 2016 Position Technical Developer

• Analysed the Technical and Functional impacts of new development requests.

• Requirement gathering and estimation of effort required for delivering various objects.

• Prepared Technical requirement documents, Unit testing and migration documents.

• Worked in the Major Integration of Custom Reports from one instance to another.

• Worked in the creating of Apex Application for Entering Sales order data and Budget data and created Interactive report to view the Entered data.

• Modified the SQL report to Excel Output using XML Publisher.

• Developed Intranet Form in seven languages like Spanish, Chinese, Italian, Dutch, French, Portuguese and German for Environment and Health Safety form (EHS) using VB Script.

• Worked in the scheduling of windows script using power shell to copy the files from windows server to Linux server.

• Importing the data in custom table through SQL Loader. Worked in Enhancement of custom Oracle Reports.

• Worked in creation of wrapper program to bring Excel output for Sqlplus based concurrent program.

• Worked in creation of Oracle Alert Notification to Buyer When a Requisition was approved. Client Name Accelerator Enhancements

& Development

Environment Oracle (OM, SC and IB)

Duration Aug 2013 – Feb 2014 Position Technical Developer

• Created custom Login Page based on the requirement where the user Login with their own username and password.

• Created a dashboard page which displays Order and Contract fulfillment report, Order progressed by OU.

• Developed Custom Packages, views, functions. Prepared the MD070 Document.

• Created User Management Page where the user’s credentials like email, role, and organization name are maintained.

• Created Reset Password page where the new password is sent to user’s mail in database.

• Developed Proactive Alert Page to send the exception alert to the user’s email as a notification. Priyadharshini Madeswaran

4 P a g e

• Developed User Preference Page where KPI information will be displayed based on user selection.

• Created the dynamic Refresh of Region in a page which will refresh a particular region without affecting the other.

Client Name Sapient Environment Oracle (AP)

Duration Sep 2012 – Apr 2013 Position Technical Developer

• Involved in Impact analysis and retro fitment of View Objects, OAF Page, OAF Common Region, OAF Personalization/Extension, OAF Class File, OAF Page Form Function, OAF XML File, OAF AM XML File.

• Involved in the OAF page level personalization and extended the existing Controller Objects (CO) and View Objects (VO) to get the required functionality.

• Worked in enhancement in Payment batch, Self Service and Bank Details.

• Developed custom PLSQL packages with Boolean returning functions and called in JAVA code for enhancement in Payment Batch.

• Designed the OAF Personalization Document for issues solved.

• Prepared code migration documents which will be used by the DBA to migrate the code in production.

• Prepared Unit test case documents for the components. Client Name Brocade Communications Inc. Environment Oracle (AP) Duration Sep 2011 to Feb 2012 Position Technical Developer

• Developed the PL/SQL Packages for the HR Employee and Sales Order conversion which will validate the data and load into the base tables through interface or API.

• Worked in SQL Loader for loading data.

• Developed a custom Pay Order Form in Payables, using triggers and procedures. COMPANY EXPERIENCE

Company Name Duration Designation

HCL Technologies July 2021 till present Lead Consultant HCL Technologies January 2017- July 2021 Senior Consultant HCL Technologies July 2014 - Jan 2017 Consultant

HCL Technologies August 2012 - July 2014 Associate Consultant HCL Technologies May 2011 - August 2012 Software Engineer QUALIFICATIONS

Level Subject University

Bachelor’s degree B.E., Electrical and Electronics Engineering Anna University, Chennai.

Contact this candidate