SUMMARY

• Oracle Applications (EBS) TechnicalDeveloper with expertise in SQL, PL/SQL, Stored Procedures, XML Publisher, Conversions, Interfaces, Forms,Performance tuning and working experience in BI Reporting. Worked on Oracle EBS modules like Financial and Supply Chain Management. Possess strong analytical, conceptual, business and problem solving skills.
• 9+ years of technical experience with Oracle Applications (EBS) which included requirements gathering, technical analysis, design, development and post implementation support for the projects.
• Experience in Oracle EBS Modules like General Ledger (GL), Accounts Receivables (AR), Fixed Assets (FA), Accounts Payable (AP), Inventory (INV), Order Management (OM), and Purchasing (PO).
• Experience in working with PL/SQL, SQL*LOADER, TOAD, SQL Developer, SQL * Plus, XML Publisher Reports, DataTemplate Reports, Pl/SQL Reports, Performance Tuning on SQL queries, API’s, Shell Script and basic working knowledge in Forms, Workflows, and Form Personalization.
• In - depth working experience on Procure to Pay (P2P) and Order to Cash (O2C) cycles.
• Experience in developing Reports, Interfaces, Conversions components.
• Proficient in developing PL/SQL program units using Procedures, Functions, Packages, Triggers.
• Created database objects like tables, views, procedures, triggers, and functionsetc
• Developed technical documents like MD70, CV60 according to AIM Standards.
• Worked on SVN and Dell Stat tools for moving the codes into the next instances.
• Successfully completed full life cycle implementation using Oracle Applications 11i and R12
• Involved in many requirements session, fit-gap analysis and solution design phases of the project.
• Experience in Production Support i.e. analyzing and fixing Production issues, developement and enhancements, according to the business needs.
• Worked with ETL tool Datanet to extract/transform and load tables in AWS Redshift DW as part of creating a reporting backend, to be utilized for BI reporting.
• Experience with BI toolTableau, creating and automating reports and Dashboards for stakeholders to monitor and track KPI’s and key Business Metrics.
• Excellent Leadership, Analytical, verbal and written Communication skills and the ability to develop creative solutions for challenging stakeholder needs.
• Capability to adapt and learn new tools and applications.
• Keen and enthusiastic with constant desire to learn and a commitment to excel.
• Team player and efficient at working without much assistance.

TECHNICAL SKILLS

Databases / DB Tools: Oracle 11g/10g/9i, TOAD, SQL*Plus, SQL Developer, ETL Manager, AWS Redshift

BI Tools: OBIEE, Tableau

Oracle Tools: Reports10g, Forms 10g, Oracle 11g/10g/9i, XML Publisher, SQL * LOADER

Application Package: Oracle Applications EBS 11i/R12 - Oracle Supply Chain Management Modules (Order Management, Purchasing and Inventory) Financial Module (Accounts Payables, Accounts Receivables, General Ledger)

Programming Languages: SQL, PL/SQL, XML, HTML, Java

Desktop Tools: MS Office suite 2003, 2007, 2010, 2013.

Methodologies: Enterprise Resource Planning.

Operating Systems: Windows 2000/XP/Vista/7/8/10

PROFESSIONAL EXPERIENCE

Confidential, San Jose

Application Developer

Responsibilities:

• Developed GL Conversion program and moved the balances for both Primary and Secondary ledgers from Confidential system (source) to Plantronics system (destination).
• Developed Fixed Assets Conversion Program and moved all the CORP Book and TAX Book data from Confidential system to the Plantronics system.
• Created Purchase Order Requisition Approval Program for checking on the Approved Requisitions with a specific message type.
• Worked on creating the DB Links with DBAs between multiple instances to move the data from one instance to the other from backend.
• Worked on developing a Utility Pkg for the project to move the data from Confidential instance staging table to Plantronics instance staging table using the DB Links.
• Developed the queries to get the data for GL conversion and FA conversion from the Source instance ( Confidential ).
• Worked on SVN and Dell Stat tools for moving the codes into the next instances.
• Created a row level Triggerfor an audit table that would fire for a before Update operation performed on the Audit table.
• Created Valuesets, Lookups and moved them through the Dell Stat into Prod.
• Involved in Functional testing and in User testingof the components.
• Performed Post go-live support.

Confidential, Seattle

Application Engineer

Responsibilities:

• Developed ‘GL Close journals by user’ XML Publisher Reports to get the journal details and user details
• Used Bulk Collections for better performance and easy retrieval of data by reducing context switching between SQL and PLSQL.
• Designed and Developed Transfer Pricing Balances Program, which involved creating PL/SQLPackage in a way that the program will select fiscal year and perform the YTDcalculations on the balances from the Gl Balances table according to the Ledger selected and move all the Ledger, Balance detailsetc intoacustom tablewhichwill be accessed by downstream programs.
• Created Triggers to cut Trouble Tickets whenever a duplicate value gets inserted into few important tables to avoid month end issues.
• Developed a package usingBulk Collect, Bulk Bind and Hints (to improve the performance as huge data is present in the tables) which identifies the journals with wrong ledgers and BSV combinations.
• Customization of AR Aging Reports as per business requirement.
• Documented Business requirements and designed interface between third party billing system and Oracle Receivables (AR) to load external invoices data on daily basis. Used SQL*Loader for importing invoices into Staging tables, and developed PL/SQL program for complete validation of data and inserting into AR Interface tables.
• Identifying the Root Cause and Corrective Action (RCCA) of the issue logged by end users and reduce the redundancy of the same issues providing permanent fix.
• Worked on GLAPPL/SQL Report that gives the details ofVendor details, PO details and Journal details along with the 7 Segments details. Created global temporary table in the report to maintain the data session specific.
• Developed a Procedure for getting all the Company codes which are assigned to wrong Ledgers and registered the procedure as Concurrent Programs in Apps.
• Worked on GL Journal Import Package to improve the performance of the program.
• Worked oncustom GL Currency Details Data Template Report which displays Journal related details, currency details, currency conversion details and journal Created By name in both Virtual Trader(third party tool) and GL.
• Created Alerts which sends an email to the team when few important programs completed with ‘Warning’ or ‘Error’
• Developed many MD70 documents with all flow diagrams.
• Added many programs to the Request Sets, created Value sets, Lookups and moved the programs thru LDTs into PROD.
• Writing Packages and Procedures, registering them as Concurrent Programs in Apps.
• Was responsible for helping users to Test the Patches/Fixes that our Team gets from the Virtual Trader (third party tool).
• Worked and resolved several critical Trouble Tickets to support resolving Production issues and enhancements.

Confidential

Application Engineer

Responsibilities:

• Designed and developed aprogram for Fixed Assets module, created a Package, Shell Script and a XML Publisher Report for the program. Created a Wrapper program which calls 100 child programs in multiple intervals. Created this program to automate the FA Depreciation Projection Programandmoved the files into AWS S3 bucket.
• Responsible for checking > 10,000 components and modifying the programs which were vulnerable for the to-be implemented higher character company codes.
• Modified 30 components which include Plsql reports, XML Publisher Reports, Interfaces, Forms, Lookups,Valuesets and successfully moved them into Production.
• Developed Triggers on few custom tables.
• Developed Alerts for the validations and sending emails to the team
• Worked on GREP commands, FINDSTR commands in both Unix and Windows
• Developed many complex SQL queries for GL, AP, AR for post validation activities for the project
• Involved in Functional testing and in User testing to test more than 1500 components
• Working with ETL tool Datanet as part of creating a reporting back-end, and used Tableau to build Dashboards for tracking KPI’s and key Business metrics
• Experience with Software Development Life Cycle (SDLC) process, performing detailed analysis, collecting requirements, technical specifications, code development Testing which involves Unit Testing, Integration Testing, User Testing and deployed into PROD.
• Involved in various activities like reviewing functional and technical documents, discussions with the client regarding the proposed solution, PL/SQL programs scripts, related reports, unit level and user acceptance testing (UAT).
• Used Auto invoice to import regular, debit memo, credit memo invoices from legacy systems into (AR) Oracle Receivables.
• Performed Post go-live support.
• Performed tuning on the SQL and PL/SQL packages to improve processing time and efficiency.
• Used SQL trace files in tuning process.

Confidential, San Diego, CA

Oracle Technical Consultant

Responsibilities:

• Handled Period, Qtr. and Year end close activities for Sub-ledger modules including GL independently.
• Worked on Form personalization to hide and change the column name in Purchase Order form.
• Involved in various activities like reviewing functional and technical documents, discussions with the client regarding the proposed solution, PL/SQL programs scripts, related reports and forms, unit level and user acceptance testing .
• Involved in Functional Design Review and preparing the Detail Technical Design Documents.
• Involved in Customization of Standard Oracle Reports as per client requirements.
• Involved in Code Review Process to make sure that code follows AIM methodology.
• Using DB Links extracted data from legacy system to Oracle Staging tables
• Used Oracle Applications Object Library (AOL) features like Value Sets, Descriptive Flex fields, Concurrent Programs, Profile Options, standard request submissions (SRS) and parameters in the process of development.
• Worked on existing issues in AP Payment Report and added the logo to the template.
• Created temporary tables using PL SQL and developed SQL*Loader control files to load data from Legacy system into temporary tables.
• PersonalizedCustomer OAF Form and added new fields for form to enter extra information with respect to business and user requirements
• Developed a custom conversion program to validate customer information before loading them into AR Base Tables.
• Verify and resolve all issues related ITR (Invoice to receipt)
• Worked on Purchase order Inbound Interface to import the purchase orders from third party to our oracle Ebiz by using Import Standard Purchase Order Program.
• Effectively handled System Administrator responsibility for creating Users, Responsibilities, Concurrent Programs, Value Sets, Request Groups
• Communicating with the business user directly, in case of any priority issues logged and enforce myself to resolve the issue before the TAT.
• Worked on XML Bursting to send the email to the customers.
• Prepared MD70’s and CV60 Technical documents for the components as per the AIM Standards.

Confidential

Oracle EBS Developer

Responsibilities:

• Worked on solving bugs/problems and providing requested business information by building queries to the customers.
• Worked on Purchase Order and Sales Order XML Publisher Report issues and successfully moved them into production.
• Writing Packages and Procedures, registering them as Concurrent Programs in Apps.
• Worked on Item Outbound Interface to extract the items data into the Flat File from the GLPROD.
• Worked for XML Reports for PO, OM Modules.
• Developed Supplier API Interface using AP VENDOR PUB PKG for the new Supplier Management System.
• Production to Production moving took place, where the whole data should be moved from GLPROD Production instance to PRODERP production instance.
• Worked on Purchase Order and Sales Order XML Publisher Report issues and successfully moved them into production.
• Involved in various activities like reviewing technical documents, discussions with the client regarding the proposed solution, PL/SQL programs scripts
• Presenting the New Enhancement Changes in Change Control Board and getting that moved to Production.
• Involved with study of existing system, preparing Functional(MD50) design documents as per business requirements using AIM Methodology.
• Responsible in sending daily reports to the Business Users.
• Produced Technical design documents (MD70) based on the business requirement in AIM Standards.
• Responsible for giving KT’s (Presentations) to other Confidential Teams on how PRODERP Production instance works.
• Providing support to customer by solving bugs/problems and providing requested business information by building queries and/or extracting required data.