Developer Oracle
Resume:
Sandeep Bandari
Oracle Techno-Functional Consultant
*****@******************.***
PROFESSIONAL SUMMARY
Extensive experience as Oracle Application Techno-Functional Consultant in implementation, upgrade and customization of Oracle e-Business Suite Applications (R12, 11i) and Oracle Fusion R12.
Extensive experience in implementation, Migration, Customization, Production and support of various modules in Oracle Applications Financials and Supply Chain Management with major focus in General Ledger (GL), Order Management (OM), Inventory (INV), Account Receivable (AR), Account Payables (AP), Purchasing (PO), Fixed Assets (FA), Cash Management (CE), SLA/FAH, EB-TAX, Advanced Pricing (QP), Shipping (WSH), etc.,
Hands on experience working on Oracle Cloud Integrations using ADFDI, FBDI and Oracle SOA Services.
Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications. Developed processes to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.
Worked on Cloud reporting tools like Fusion Reporting Hub, Financial Reports Studio, Smart View Reports, OTBI and OBI publisher to create reports with real time data as per business requirement.
Technically proficient in RICEW components (Report, Interfaces, Conversions, Extensions, Workflows).
Experience working on building extensions for various business process flows including Procure to Pay (P2P), Order to Cash (O2C) and Record to Report (R2R).
Strong Knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards, Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).
Expertise on designing and implementing Oracle Alters and Lookups.
Good experience in developing, customizing and personalizing web forms using Oracle Application Framework (OAF).
Experienced in Customizing and Personalizing Oracle Forms as per the business requirements. Proficient in developing and registering Oracle Forms using TEMPLATE.FMB and CUSTOM.PLL
Dexterous in Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g and XML Publisher (BI Publisher).
Knowledgeable in implementing various oracle features for globalization and stability like MRC (Multiple Reporting Currency) implementations, MOAC (Multi-Org Access Control), SLA (Subledger Accounting), TCA (Trading Community Architecture) and others.
Well versed with client server environment and tools like SQL*Plus, PL/SQL, SQL*Loader, TOAD, Oracle Developer, Oracle Forms, Oracle reports, Workflow and modified the formats using XML Publisher for customizations as per client specification.
Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL Loader, UTL_FILE, Oracle packaged APIs etc.
Expertise in requirement analysis, system design, Data Flow Designs, Support, development, testing, documentation and design reviews.
Expert in developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120).
Strong in Performance Tuning of various core components of Oracle applications built in SQL, PLSQL and UNIX shell scripting.
Proficient in troubleshooting issues, including creation/follow-up of Oracle Service Requests (SRs).
Advanced skills in oracle database programming using PL/SQL (Stored Procedures, Functions, Packages and triggers), standard built-in oracle packages.
Good team player with good communication skills and flexible for learning new technologies.
TECHNICAL SKILLS
ERP
Oracle Applications EBS R12 (12.2.5/12.1.3/12.0.6), 11i (11.5.10.2/11.5.8) GL, AP, AR, FA, Advancing Pricing, OM, PO, INV, iExpenses, iProcurement, iSupplier, EB-Tax, Oracle ERP Cloud R12/R13 (GL, Payables, Receivables)
Programming Languages
SQL, PL/SQL, UNIX, PERL, JAVA, XML
Oracle Application Tools
Forms Builder 9i/10g/11g, Reports Builder 9i/10g/11g, BI Publisher, Discover, Workflow, ADF, ADFDI, FBDI, Smart View Reports, OTBI
Developer Tools and Utilities
SQL Developer, TOAD, SQL*PLUS, ERWIN, SQL*LOADER
Documentation Skills
AIM – MD50, MD20, MD70.
Databases
Oracle Database 9i/10g/11g/R12.
Other Tools
Putty, WinSCP, MS Office.
PROFESSIONAL EXPERIENCE
Client: Memphis Light Gas Water (MLGW), Memphis, TN October 2018-Till Date
Role: Oracle Techno-Functional Consultant
Description: MLGW requires that the system provide the ability to control security to restrict which users may perform updates, when users will be able to have access the system to make those updates, and who will approve elements of the budget.
Responsibilities:
As an Oracle Apps developer, involved in development, enhancement of Budget Application project.
Developed process to regenerate and update the data in the custom tables, to support the Oracle EBS Budget Implementation.
Worked on BI Publisher (XML Publisher) for Various Purchasing reports. Generated new reports as well as converted existing oracle reports to XML, by creating RTF templates using Template Builder.
Designed, developed, tested and implemented new BI Publisher Report that gives the users complete list of all budget application reports.
Modified Budget Report using BI Publisher to add new fields to the report layout. The validations for new fields are added to PL/SQL package that builds the data model for the report.
Developed a new custom inbound interface to send information from Oracle EBS system to Budget system. Interface is responsible for extracting incremental data in the form of flat files from several functional areas such as Invoices, Inventory and Catalog Items, General Ledger as per the business rules.
Developed several programs using Linux Shell scripting to implement OS level file handling functionalities such as splitting files into multiple files based on the business rules, transferring files using FTP/SFTP, reading and processing the files, extracting data from files, moving and purging files.
Developed programs in Linux that handle PL/SQL functionalities from shell such as submitting Concurrent Programs, running SQL queries and PL/SQL blocks, handling database errors, and generating concurrent program output reports.
Used FND_LOAD utility to migrate various FND entities like concurrent programs, value sets, executables, Flex fields, Request Groups, Request Sets, etc. from one environment to another. The entities are first downloaded from database to text files and then uploaded to different environment as per the requirement.
Developed scripts using UTL_FILE utility to create and read inbound files and SQL*Loader for processing inbound files.
Registered customized Oracle reports and XML Publisher reports using System Administrator and Application Developer.
Prepared Functional (MD50), Technical (MD70) and Interface Agreement documents for various development projects.
Environment: Oracle Applications R12 (12.1.5) (Budgets, AP, AR, GL, Projects), Oracle BI Publisher Reports, SQL*Loader, TOAD, SQL Navigator, SQL Developer, PL/SQL.
Client: Anthem – Norfolk, VA November 2017-September 2018
Role: Oracle Techno-Functional Consultant
Description: Service Enablement project for Anthem is to provide strategy for implementation of micro services to provide the customers consistent and secure information. Micro services strategy enables to streamline the services and to bring them on a cloud-based platform for high availability and increased agility.
Responsibilities:
As an Oracle Apps Techno Functional developer, involved in development and enhancements of various technical components of existing Oracle applications System.
Enhance DCA Order Post-production Status reports for better tracking of Drop Ship Orders. Include additional columns and input parameters to filter data.
Involved in development of the process to regenerate and update the data in the custom tables, based on the Outside Processing Setup.
Worked on the development of Interfaces, Data Conversions, Developing New Forms, Reports, and Customizing Oracle Reports in Procure-to-Pay Cycle touching various modules like INV, OM, and Purchasing.
Imported Items from legacy system into Oracle Inventory using the standard Item Interface program.
Designed and developed Packages, Procedures and Triggers using PL/SQL.
Developed new report such as Report Builder 10g and also customized seeded reports for different products like PO, INV and OM.
Interacted with Business Analysts to understand the functionality and their requirements.
Developed PL/SQL Procedures and UNIX Shell Scripts to load and extract the data.
Created Oracle Packages, Procedures and Functions using SQL, PL/SQL, SQL navigator and SQL Developer.
Extensively handled errors to ease debugging and to display error notifications in the application using Exception Handling.
Experience working on SQL*Loader, SQL*Plus, Oracle Import/Export utilities and SQL*Navigator.
Designed and developed load processes and data validations using Stored Procedures, Functions and Triggers.
Performed bulk data loading into database tables from external data files using SQL*Loader.
Coordinated activities with Testing and the Technical team to resolve daily reported Production issues. Facilitated discussions with end-users / managers to gather functional requirements on their issues.
Assisting end users to resolve problems in carrying out their daily business activities in the above modules.
Working with Oracle on SR management on high priority issues parallelly.
Translate business requirements into functional and technical designs (Technical design documents).
Tuning queries in SQL. Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes
Extensively used bulk collection in PL/SQL objects for improving the performing.
Involved in full development cycle of planning, Analysis, Design, Development, Testing and Implementation.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Environment: Oracle Applications 11i (11.5.10.2) (Manufacturing, Shipping, OM, Packing), Oracle Forms/Reports 6i, SQL*Loader, TOAD, SQL Navigator, SQL Developer, PL/SQL.
Client: Express Scripts, Franklin Lakes, NJ March 2016- November 2017
Role: Oracle Applications Techno-Functional Consultant
Description: CBV provides a new tool that will be built for clients to view benefit setup information that was formerly available on the ESI legacy West Anchor Green Screens. New screens will be built within the eSD application that can be accessed from the Client Website and Client eSD that will contain information our Legacy West clients used in the Legacy West Anchor
Responsibilities:
Oracle Apps Technical Consultant for upgrade and support project.
Involved in the day to day activities of production support of Oracle applications environment in PO, INV, iProcurement and iSupplier portal.
Involved in the analysis of the assigned support tickets including replicating the issue, analyzing the custom processes/API's/reports/forms and updating the ticket with the appropriate information.
Work on the development activities as part of issue resolution. Perform Unit Testing, migrate to next environments, assist user testing and closing the tickets.
Closely worked with users to understand business needs and objectives.
Personalized Oracle standard and custom Forms using oracle forms builder as per the Client requirements.
Expertise in implementation of procures to pay life cycle.
Customized forms using custom. pll to change the functionally of the standard forms.
Developed various Custom reports, Customized existing reports (PO Purchase Order and Releases Detail Report, Purchase Requisition Status Report) according to the functional specifications using Reports 10g and XML publisher.
Created custom templates with Data Definitions for XML Publisher and Developed reports using reports and registered as XML reports in applications.
Worked on Form Personalization in Order Management (OM).
Developed a program to load external data from legacy system into PO_HEADERS_INTERFACE and PO_LINES_INTERFACE.
Registered the Concurrent Programs, Forms, Reports and Requests Sets in AOL and System Administration.
Worked in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, Collections, records, views, materialized views and Packages using PL/SQL.
Extensively worked in developing technical documents (MD70).
Extensively involved in SQL tuning, troubleshooting, debugging and fixing the code and made the changes according to the new business requirements.
Worked on Approval Management Engine for i-Supplier registration approval.
Customized PO Output for communication Report with additional data and New Template.
Working with Oracle support through Service requests to fix Oracle standard bugs and data fixes.
Interacting with Business lead over weekly support status.
Environment: Oracle Applications R12.2.6 (PO, INV, iProcurement, iSupplier, GL, OM), XML/BI Publisher, Oracle Forms/Reports 10g, SQL*Loader, TOAD, PL/SQL.
Client: IVRCL Limited, India April 2013-August 2015
Role: Intern Oracle Apps Developer
Description: The project was on the technically side where developing the forms for the user and developing the reports for the user which helps the Inventory system of the company.
Responsibilities:
Customized and generated the reports, customized forms and registered them as concurrent programs in oracle applications using AOL.
Developed supplier conversion to import the supplier details from legacy system to oracle applications base tables.
Designed and developed conversion to load on hand quantities, lots and locators into inventory INV using oracle on hand and lots interface.
Worked with new custom forms by using Template. fmb.
Worked with call one form to another form and query find forms as per client business requirements.
Developed XML reports as per the client requirement by using the .rdf formats and developed the .rft files.
Developed packages to extract the data from base tables into flat files by using UTL_FILE packages.
Developed inbound interface to import the details from legacy system to oracle applications base tables.
Worked with Form personalization as per business requirement.
Customizing DFF as per client requirement.
Worked with registering and as well as scheduling the concurrent programs as per the client requirements.
Application system administration activities like application user setup, defining responsibilities, values sets, flex fields, registering menus, forms reports, concurrent programs as per the client requirement.
Written stored procedures, functions and triggers using PL/SQL.
Environment: Oracle Applications 11.5.9, AOL, INV, BOM, WIP, AP, AR, GL, PL/SQL, Oracle Reports, Oracle forms.
EDUCATION
Master of Science in Industrial Management 2015-2017
California State University Los Angeles, CA
Bachelor of Science in Civil Engineering 2010-2014
Jawaharlal Nehru Technology University, Hyderabad, INDIA
Contact this candidate