Sneha Pattem

Ph: 818-***-**** Email:adg5lq@r.postjobfree.com

●Around Nine years of IT experience in complex environments with strong techno-functional experience in design, implementation, upgrade, customization, application development of Oracle EBS R12/11i Financials (GL, AP, PO, AR, Fed Admin (FV)), Warehouse /Order Management (OM) and Inventory)

●Significant experience developing with OA Framework (OAF)and JDeveloper (Java/J2EE)

●Expertise with Forms and Reports 6i and 10g, Discoverer 9i, SQL*Plus, PL/SQL, BI (XML) Publisher & Workflow Builder.

●Responsible for Design and Development of Interface Programs.

●Developed data conversion systems for various modules (GL, AR, AP, OM and INV) through interface programs using PL/SQL and SQL*Loader.

●Experienced in Developing Technical Specification and Design Documents.

●Experienced in Modifying Standard Oracle Workflows, designing new workflows to suit the business requirement.

●Extensive experience in development of Custom Forms using Template.fmb, customizations using Custom.pll, Forms Personalization

●Experienced in customizing standard oracle reports, creating new oracle reports using XML Publisher

●Strong programming experience in creating Procedures, Packages, Cursors, Functions, Triggers and other database objects using SQL and PL/SQL.

●Proficient in writing and tuning complex SQL statements, complex joins and sub- queries.

●Experienced in UNIX SHELL Scripting.

●Experienced in building Oracle Framework Applications (OAF) extensions/Customizations using SPEL, PPR and Dependent LOVs

●Strong Analytical skills with expertise in diagnosing and resolving complex system problems.

●Expert in trouble shooting production issues and Debugging Code.

●Strong communication, written and inter-personal skills at the technical and user level.

●Capable of working independently with minimum supervision or as a great team member.

●Ability to work under pressure and deliver on time to meet the deadlines.

Education Qualifications

●Bachelor’s in Computer Science

Technical Skills

ERP

EBS R12, 11i

Modules

GL, AP, PO, AR, Fed Admin (FV), Warehouse /Order Management (OM), iSupplier, and Procurement

Programming

SQL, PL/SQL, XML, JAVA

Database

Oracle 7.3/8i/9i/10g

Operating Systems

UNIX (Sun Solaris, AIX, HP-UX, Linux), Windows

Software Tools

Toad, SQL*Loader, Discoverer 2.5/4i/9i, MS Project, MS Office, Visio, Oracle Workflow 2.6, BI Publisher, SQL Developer.

GUI’s

Oracle Forms 10g/ 9iAS/ 6i/4.5,Oracle Reports 10g/9iAS/6i/2.5

Professional Experience

Client: Department of Education September 2017-Till date

Washington, DC

Senior Oracle Applications Techno-Functional Consultant

This project involved upgrading Oracle Applications 11.5.10 to R12.2.6

Involved in the project level activities for all phases of the project including solution design, specification documentation, test case preparation and execution using Oracle Federal Financials.

●Developed a custom form (IPAC) to provide users ability to approve/reject/process invoices from external CPSS system.

●Developed a custom interface to import AP invoices and credit memos using Payables Open interface.

●Developed an interface to import Micro purchase invoices into Oracle.

●Designed and developed an interface to upward and downward adjust the AP invoices.

●Worked Extensively on R12Payments.

●Performed various SLA setups.

●Developed an interface to auto-adjust AR transactions based on certain business rules and create aggregate AR transactions.

●Extended custom.pll to incorporate additional business rules.

●Designed and developed an interface to import journals from FMS using GL interface.

●Extended Oracle Data Act interface programs to generate File A, File B and File C DATA ACT files

●Customized standard oracle Reports like Account Analysis Report, Receipt Journal Report etc.

●Developed custom reports like Payables Activity Report, Award Financial history report, using Oracle Reports.

●Extensively worked on Integration testing to test multiple interfaces, extensions, reports as well and end to processes.

●Provided UAT support by working with end-users to clarify and resolve various production defects

●Worked with oracle to resolve various Service Requests raised during the R12 upgrade.

Environment: Oracle EBS R12, PL/SQL, SQL*Loader, Import/Export, TOAD, Forms 10g, Reports 10g, Oracle Workflow, OAF, XML Publisher, GL, AP, AR, PO

Client: National Science Foundation Feb 2017- Aug 2017

Alexandria, VA

Senior Oracle Applications Techno-Functional Consultant

This project involved in the support and maintenance of iTRAC systems which is the NSF’s state-of-the art financial management system developed on EBS.

●Involved in Operations and Maintenance of iTRAC and coordinated with users

●Designed and Developed a program to import Employees from external FPPS system using Person API.

●Designed and Developed a program to create vendors for Employees using the Vendor API.

●Enhanced existing interface codes to end-date duplicate vendors and employees using HR APIs. Also added logic to automatically perform supplier merge when there is balance against an old vendor.

●Performed various OAF Personalizations on iProcurement using OAF concepts like SPEL, Partial Page Rendering, VO extension and Substitutions.

Developed an interface to sweep funding balances to the apportionment or allotment level using BE Import Program

Developed a new form using Template.fmb to perform Purchase Order Supplier Merge.

Environment: Oracle EBS R12, PL/SQL, SQL*Loader, Import/Export, TOAD, Forms 10g, Reports 10g, Oracle Workflow, OAF, XML Publisher, GL, AP, AR, PO

Client: Health and Human Services Jul 2015 – Jan 2016

Silver Spring, MD

Oracle Applications Techno-Functional Consultant

This project involved in the support and maintenance of Unified Financial management system (UFMS) for HHS and its OpDivs FDA, CDC, HIS and PSC to offer effective processing and tracking of financial and accounting transactions.

●Involved in data fix analysis and recommended the solutions.

●Provided technical support to the R12 Upgrade team and helped them in understanding the UFMS and their business processes.

●Involved in Operations and Maintenance of UFMS and coordinated with users.

●Involved in providing Solution design, development and documentation for conversions, interfaces, forms and reports, code development, test case preparation and execution in Oracle Applications.

●Performed debug, defect fixing and support during code releases and communicated with business users.

Environment: Oracle EBS R12, PL/SQL, SQL*Loader, Import/Export, TOAD, Forms 10g, Reports 10g, Oracle Workflow, OAF, XML Publisher, GL, AP, AR, PO, iProcurement, AME

Client: National Institute of Health Sept 2014 – Jun 2015

Bethesda, MD

Senior Oracle Applications Techno-Functional Consultant

This project involved upgrading Oracle Applications 11.5.10 to 12.2.2

●Performed CEMLI Analysis to determine which objects require Remediation and Redesign.

●Worked on PANAYA tool to perform impact analysis of the custom code.

●Remediated custom objects like GL Trial Balance reports, AP and AR Aging reports, GL, AP and AR associated packages, triggers and views for R12 compatibility.

●Performed OAF Personalization on Buyers Work Center to add a new LOV field that shows all the CAN values, when user selects a can value, it will automatically populate the kff segments on purchasing distribution page.

●Designed and developed a custom form to enter banking details and enabled it via Zoom on the person details form.

●Developed a custom workflow to enable approval of Person details and launch the Vendor creation process upon approval of Person details

●Developed a custom workflow to enable approval of Bank details and launch the bank creation process upon approval of Banking Details.

●Extensively performed forms personalizations on Person Entry form, Purchase order form and AP Invoice form.

●Converted existing 11i custom.pll code on the forms to OAF extensions for

Purchase Order Form, Supplier Form and Customer Form since these forms were converted to OAF web pages in R12

●Extensively worked on FNDLOAD scripts to migrate concurrent programs, value sets, Request sets, form functions, form personalizations etc to various instances.

●Developed Sql queries using SLA tables for Period end Financial Reconciliation

●Developed shell scripts to migrate grants, enable custom triggers as part of post upgrade steps.

●Extensively participated in UAT and Production Readiness testing

●Documented all the technical development work as per the client requirements.

●Won Champion of the Month Award for troubleshooting and remediating critical customizations in 12.2.3 successfully.

Environment: Oracle Applications 12.2.3, PL/SQL, SQL*Loader, TOAD, Forms 10g, Reports 10g, Oracle Workflow, XML Publisher, GL, AP, AR, PO, iProcurement, AME

Client: Silgan Plastics Feb 2013– Jul 2014

Chesterfield, MO

Oracle Applications Techno-Functional Consultant

This project involved upgrading Oracle Applications 11.5.10 to 12.1.3

●Upgraded GL, PO, AP, AR, OM, INV, BOM and WIP from 11i to R12

●Redesigned custom objects associated with Banks for R12 compatibility

●Developed a custom XML report 'Accounting details by Location' to break out the GL lines by shipment organization using SLA tables

●Developed custom XML reports like ‘Actual vs Budget Trial Balance’, ‘12 months Actual Report’, ‘Supplier Paid history report’, ‘Bill of Lading Report for Open Deliveries’

●Performed forms personalization to make the 'need by date' on the purchase order form a required field

●Implemented OM, INV and Shipping Execution to three new Inventory Organizations.

●Performed OAF customization in iProcument to show available quantity while creating Internal Requisition.

●Personalized iProcurement checkout page to add new region that would allow users to enter accrual information showing how the PO amount would be spent which will be used for budgeting purpose.

●Developed an interface to import Bills into the new inventory organizations using BOM Open Interface.

●Imported Price list data into Oracle using Price List API.

●Designed and developed a custom interface to import AP invoices received at the warehouse into Oracle using Payables Open Interface.

●Designed and developed a custom interface to import AR invoices shipped out from a 3rd party warehouse using Autoinvoice Master Program

●Developed a WebADI process to import Journal lines into GL.

Environment: Oracle Applications 12.1.3, PL/SQL, SQL*Loader, TOAD, Forms 10g, Reports 10g, GL, AP, AR, PO, OM, INV, WSH, BOM, iProcurement, AME, Oracle Workflow

Client: Kotak Mahindra Bank Jun 2009– Dec 2012

Bangalore, India

Oracle Applications Technical Consultant

●Extensively worked on Development and Production support of GL, AP, AR and PO

●Designed and developed a process using SQLLDR and Purchasing Open interface to load expenses into Oracle

●Developed a process to import Receipts into Oracle Receivables using Lockbox.

●Developed a package to auto-adjust AR Transactions based on certain criteria using AR Adjustment API.

●Customized existing Oracle Report Aging Bucket by Collector to add additional fields as per business requirement.

●Performed forms personalizations based on customer requirement on Invoice Workbench and Transaction Workbench.

●Developed a package to import Journals from external system using Journal Import program.

●Developed various custom forms using Template.fmb and enabled them via Zoom functionality.

●Developed custom Reports in XML publisher and customized Standard oracle reports to suits the client’s requirements.

●Worked with users to resolve tickets as part of Production support.

Environment: Oracle Applications 11.5.10, PL/SQL, SQL*Loader, TOAD, Forms 10g, Reports 10g, GL, AP, AR, PO

Contact this candidate