Priyanka Ramsai

ad35oa@r.postjobfree.com

+1-945-***-****

PROFESSIONAL SUMMARY

Senior Oracle EBS Technical Consultant with 11+ Years of experience in implementing and extending Oracle eBusiness Applications R12.

Extensive experience in using SQL, PL/SQL, Oracle Developer Suite(Forms, Reports, JDeveloper, OAF), Workflow builder, XML Publisher, RICE Components (Data Conversons, Interfaces, Reports, Form Customizations, Personalizations& Alerts)

Having 5+ years of experience on APEX page Customizations.

Strong technical experience in design, implementation of interfaces, API and customization of Oracle Applications 11i and R12 (GL, AP, AR, OM, PO, SCM, INV, Advance pricing and AOL objects).

Excellent understanding and implementing the Order-to-Cash (O2C) and Procure-to-Pay (P2P) business process.

Expert in understanding the business process, Requirement Analysis, module setup, writing the training documents and end user support in Order Management, Purchasing, Accounts Payable, Inventory and General Ledger.

Strong experience in customizing Oracle Forms, Reports, and PL/SQL programming.

Strong programming experience in creating/SQL Stored Procedures, Functions, Stored Packages, Database Triggers, SQL* Loader scripts, Shell scripting, Forms (6i/10g),Reports (6i/10g).

Extensive experience in design and implementation of Oracle Forms & Alerts and customizing Oracle Workflow.

Extensive experience in developing and designing custom reports using XML/BI Publisher Reports.

Experience in personalization, custom page design and extending Oracle Self-Service applications using OAF, JDeveloper10g/11g.

Proficient in writing and tuning complex SQL statements.

Excellent Knowledge of using Oracle AIM Methodology for the project Implementation Methodologies.

Excellent understanding of the AOL, System Administration and Application Developer module.

Experienced in Developing Technical Specification and Design Documents.

Experience working on Oracle forms, forms personalization/Logical Apps for adding the functionality. Working knowledge of Custom. pll for forms customization.

Expertise in the Customization, Extensions and Personalization of OAF Components.

Experienced in data migrations from legacy systems into Oracle Applications.

Creation and follow ups of SR and Applications of Patches as and when required.

Excellent in analysis of current business processes, application configuration, managerial reports, and information processing.

Involved in 3 complete system development life cycles including the analytical skills necessary to satisfy testing documentation and Change management requirements.

TECHNICAL SKILLS

ERP Modules

Oracle Applications R12(12.2.X)

OM, PO, AP, AR, GL, INV, WIP, iProcurement and iSupplier

Database

Oracle 10g/11g

Application Tools/Technologies

SQL plus, SQL Developer, PL/SQL, Toad, Tkprof, SQL*LOADER, Workflow Builder, BI Publisher(XML Publisher), Discoverer, Report Builder(Oracle Reports (6i/10g)), Putty,JIRA, Service now, Version Control(CA Harvest Workbench, Microsoft Visual Source Safe (MS-VSS) and Clear Case)

Languages

SQL, PL/SQL, XML Publisher, APEX, Unix Shell Scripting, OAF

Environments

Windows XP/2000/7, UNIX (Sun/Solaris/AIX)

EDUCATION

Master of Computer Applications(M.C.A) from JNTU, India in 2012.

Bachelors in Computer Science from Shri Venkateshwara University, India in 2009

PROFESSIONAL EXPERIENCE

Client: Denso Automotive, Southfield, MI Apr 2022 – Till date

Role: Senior Oracle EBS R12 Developer

Responsibilities:

Worked on interfaces and Conversions to integrate legacy system to Oracle applications R12 for GL, AP, AR, PO, OM modules.

Supporting customer tickets (JIRA)and resolving those issues on time.

Preparation of Business Requirement Documents, Functional Specifications, High level and Technical Design Documents.

Created reports from AP, AR and Inventory modules

Tuned PLSQL procedures which was running more than the expected executions time

Created XML publisher reports using data template & PLSQL Approach

Customized RDF reports

Worked extensively on APEX pages to support the customer.

Oracle Forms Personalization for Accounts Payables supplier contact directory.

Functional setups verifications when required

Code deployment and participated in UAT

Developed custom OAF pages.

Conducted daily scrums and weekly calls with stakeholders

Created MD70 other technical and training documents

Created reusable scripts for the repository

Created triggers

Oracle Forms New Enhancement for Grants Accounting search and detail forms based on the Project and Award.

Involved in Form personalization

Workflow related issues as part of production support

Developed Xml Publisher reports with multiple layouts and multiple templates.

Involved in Procedure and Packages performance tuning.

Created XML publisher reports using data template & PLSQL Approach .

Environment: Oracle EBS R12 (12.2.10)(AR, AP, GL, OM, PO, Shipping, Pricing, P2P and O2C Cycles), Oracle 11g/12c, SQL, PL/SQL, Reports 11g, Reports 11g, PL/SQL, Workflow, XML/BI Publisher, UNIX Shell Scripting), OAF

Client: Macy’s, New York, NY Jan 2020 – Apr 2022

Role: Senior Oracle EBS R12 Developer

Responsibilities:

Working as a Senior Oracle EBS Technical Lead and leading a team of ERP consultants

Worked on interfaces and Conversions to integrate legacy system to Oracle applications R12 for O2C (Order to Cash) cycle modules.

Supporting customer tickets (JIRA)and resolving those issues on time.

Preparation of Business Requirement Documents, Functional Specifications, High level and Technical Design Documents.

Developed outbound Integrations for Order Management system.

Executed the flows of Drop ship and Back to Back order cycles in Order Management

Assist functional team members with high-priority projects requiring technical assistance. Serves as a Technical Lead for existing custom tools throughout their lifecycle

Provides troubleshooting and debugging assistance to perform system analysis and issue resolution

Assisting with the technical planning & requirements gathering phases including estimate, develop, test, manage projects, architect and deliver

Worked on Extension and Personalization of OAF pages.

Managing the delivery and quality control of onshore as well as offshore resources.

Code Review/Design reviews to ensure the delivery of quality solutions

Providing production support as and when required

Worked on different modules like OM, INV, AP, AR, and Pricing etc.

Involved in Order to Cash (O2C) and Procure to Pay (P2P) business flow.

Worked on multiple Conversion like Sales Order, PO, BPA, Supplier Conversion, AP Invoices, AR Invoices, Customer Conversion etc.

Experience in development of complex Oracle forms for their custom application.

Worked on Multiple Interfaces like Sales Order, Purchase order, OnHand Quantity etc.

Prepare technical solutions as well as review technical solutions

Act as the local escalation point of contact for Development and Quality Management

Attended client daily status meeting’s and hand off session for Customizations and enhancements of RICEW components.

Responsible for moving the objects from one instance to another instance by using FND_LOAD and WINSCP Tools.

Works in an agile development environment and associated concepts

Environment: Oracle EBS R12 (12.2.5)( OM, AR, AP,WIP,BOM, GL, PO, SCM, INV, iProcurement), Oracle 11g, SQL, PL/SQL, Reports 10g, SQL * Loader, PL/SQL, Workflow Builder, XML/BI Publisher, UNIX Shell Scripting, OAF)

Client: Pampered Chef, Chicago IL June 2018 – Dec 2019

Role: Senior Oracle EBS R12 Technical Consultant

Responsibilities:

Involved in developing/reviewing Data Conversions, Data Mapping, Data Extraction and Open interfaces related to SCM modules.

Worked on Sales Orders Interface in Oracle Order management module to import Sales Orders from flat files.

Supporting customer tickets (Service now )and resolving those issues on time.

Preparation of Business Requirement Documents, Functional Specifications, High level and Technical Design Documents.

Ensured efficient and timely reconciliation of all international, Canadian and US accounts.

Preparing daily/monthly cash receipt reports for balancing to AR and supporting monthly cash receipt forecast.

Developed and maintained daily log and reconciliation of credit card receipts.

Generated reports for management to include cash flow and aging reports.

Facilitated successful external audits through thorough documentation

Developed Oracle Forms using to implement postdated cheques (PDC) functionality in Account Receivables (AR).

Monthly Close: Delivered accurate and on-time monthly financial closing for A/R functions.

Involved in Procure to Pay (P2P) & Order to Cash (O2C) business flow.

Developed Auto Invoice Interface which imports invoices, credit memos and debit memos into Oracle Receivables (AR) module using SQL*Loader and PL/SQL validations.

Worked on RMA Process, importing orders, and Credit Memo process in Order Management, Account Receivables Application

Perform Root Cause Analysis (RCA) for various repetitive problems and provided suggestions for speedy problem resolution.

Performed System Administrator functions such as defining Users, functions, responsibilities, concurrent programs, flex fields, Value Sets, Profile Options, registering forms in AOL and also the post clone tasks.

Environment: Oracle EBS R12 (12.2.3)(AR, AP,WIP,BOM, GL, OM, PO, SCM, INV), Oracle 11g, SQL, PL/SQL, Reports 10g, SQL * Loader, PL/SQL, Workflow Builder, XML/BI Publisher, UNIX Shell Scripting, OAF)

Client: Rheem Manufacturing Company, India Aug 2015 – Apr 2018

Role: Senior Oracle EBS R12 Technical Consultant

Responsibilities:

Support of Oracle EBS R12 on SCM/Manufacturing Modules: SCM: PO, Bill of Material (BOM), Work in Process, Inventory, Master Data Management, Purchasing, Outsourcing, Distribution: OM, WSH, QP, Shipping, Advanced Pricing & Quality.

Worked on Customization of OM Sales Order Workflow.

Design and Developed Auto Receive PO and Close the PO’s interface in Purchasing.

View Object extension for several OAF pages.

Worked on Interfaces and Conversion API’s in SCM and Financials modules.

Worked on business Requirements Mapping for INV, OM, SCM, QP, AR, Shipping and planning modules.

Involved in Procure to Pay (P2P) & Order to Cash (O2C) business flow.

Worked on Payables Standard Invoice Interface to import Invoices data into Oracle AP base tables. Various validations are performed on the staging table data.

Designed and developed PO requisition interface to load PO requisitions from the legacy System into oracle purchasing (PO) using SQL*Loader and PL/SQL validations

Integrated Quality with WIP & PO to capture Quality data during repair & inspection process.

Developed Auto Invoice Interface which imports invoices, credit memos and debit memos into Oracle Receivables (AR) module using SQL*Loader and PL/SQL validations.

Performed System Administrator functions such as defining Users, functions, responsibilities, concurrent programs, flex fields, Value Sets, Profile Options, registering forms in AOL and also the post clone tasks.

Analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec) and MD150 (Migration Document).

Developed UNIX Shell scripts to run the interface program and to archive the data.

Environment: Oracle EBS R12 (12.2.1)( GL,AP,AR,OM, PO, SCM, INV), Oracle 11g, SQL, PL/SQL, Reports 10g, SQL, Loader, PL/SQL, Workflow Builder, XML/BI Publisher, UNIX Shell Scripting, APEX reports, OAF)

Client: Topps Inc, India Jan 2013 – Aug 2015

Role: Senior Oracle EBS R12 Technical Consultant

Responsibilities:

Analyzed the existing elements and customizations in business process.

Involved in the complete setup of pricing that included price lists, modifiers, qualifiers, profile options, lookups, attribute mapping, etc.

Good experience on Custom Attribute Mapping, Pricing APIs, Price Books, and other Advanced Pricing Setups and Configurations like Price Lists, Modifiers and Qualifiers.

Developed the SQL Loader script to load the data to staging tables and then to interface tables for Order Release program to release orders Wrote packages and worked extensively on validations in the orders released from OM to AR, OM to TDW and populating the interface tables.

Modified the existing Interface Program to import Invoices to AR.

Enhanced custom processes, defined setups for Oracle Alerts ALR to inform business users of certain events.

Worked on development, Unit Testing, Implementation and Documentation of Claims Incentives, Costing, OM to TDW Projects and AP, AR, OM Oracle EBS Modules.

Customized the order header workflow to make certain header level attributes mandatory before the order is booked.

Developed PL/SQL packages to communicate data to business users. Automated emails sent as CSV attachments and minimized month end issues and efforts to reconcile.

Performed performance improvements and fine tuning of materialized views.

Took part in enhancing ETL process. Worked on Informatics mappings, sessions and workflows. Ran scripts to load updated data into dim tables.

Generated unit testing documents. Documented processes in MD-70, MD-120 based on requirements.

Developed the PL/SQL Scripts to translate the old Asset Category to new Asset category values that are been setup in the R12 Fixed Assets

Developed the SQL Loader script to load the data to staging tables and then to interface tables for Order Import program to import orders. Wrote packages to validate and populate the interface table

Customized the PO workflow to send notifications to specific people using adhoc roles.

Developed workflow business events to report the promise date and schedule ship date changes on the orders.

Designed and Developed Blanket Sales Agreement and Blanket Release Reports using XML Publisher for better lookup.

Used CONCSUB to invoke and execute the Concurrent Programs from Unix Shell Scripts.

Environment: Oracle EBS R12 (12.1.3)(Advance Pricing, AP,AR, GL, iProcurement, OM, PO, SCM, INV, BOM), Oracle 11g, SQL, PL/SQL, Reports 10g, SQL * Loader, PL/SQL, Workflow Builder, XML/BI Publisher, UNIX Shell Scripting)

Contact this candidate