Sql Oracle

SHARADHA D

Professional Summary:

Over * plus years of experience in Oracle Applications (E-Business Suite) R12/11i on Analysis, Design and Development, Testing, Implementation, maintenance and support of Oracle EBS.

Excellent experience in Application Modules of Oracle which include General ledger (GL), Accounts payable (AP), Accounts Receivables (AR), Purchasing (PO), Inventory (INV), Order Management (OM)

Good Knowledge on Development skills in developing RICE (Reports, Interfaces, Conversions and Extensions) Components in the domain of Oracle Applications E-Business Suite.

Good Technical experience in Procure to Pay (P2P) and Order to Cash (O2C) life cycles with related Open Interfaces and API’s.

Strong knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards, Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).

Excellent Knowledge of R12 MOAC architecture, 11i Multi org structure and AOL Objects.

Expert at creating and maintenance of users, responsibilities, menu, requests, value sets and registering applications, forms, form functions, reports and concurrent programs, etc.

Strong programming experience in creating Procedures, APIs, Packages, Functions, Triggers, views, collections (nested tables and arrays), records, sequences, views, Constraints and other database objects using SQL and PL/SQL.

Experience in OA Framework and customization and Personalization of JSP pages.

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Good in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.

Good Knowledge on Conversion, inbound and outbound interfaces Programs using PL/SQL, Interface tables and Oracle Standard API's.

Good knowledge in Oracle cursor management and Exception handling.

Proficiency in creating business and technical project documentation.

Ability to work hard as an individual and in a team to achieve desired results and ability to work under pressure in coordinating multiple tasks in the work environment as a good team player.

Excellent in quick adaptation and problem solving with client interaction/customer handling, conflict management, escalation handling and analytical skills.

Technical Skills:

Oracle Applications:

Oracle E-Business Suite R12, 11i

Modules:

GL (General Ledger), AP (Account Payables), AR (Account Receivables), PO (Purchasing), OM (Order Management), INV (Inventory), P2P, O2C, Cash Management (CM) and AOL (Application Object Library).

RDBMS:

Oracle 8i/9i/10g, SQL Server 7/2000

Development Tools:

XML Reports & Forms 6i/10g

DB Tools:

SQL*PLUS, SQL*Loader, TOAD, SQL*Navigator, SQL Developer.

Languages:

SQL, PL/SQL, C, C++,JAVA, .NET (BASICS), SAS

Reporting Tools:

Reports 6i/10g, XML/BI Publisher.

Operating Systems:

Windows 10/XP/NT/2000/98/95/2007, LINUX,UBUNTU,UNIX

Office Tools:

Microsoft Word, Excel, Outlook, Access

Experience:

Process Weaver/Merckanimal Health, Santa Clara, CA Nov’ 15 – Mar’17

Oracle Apps Technical Consultant

Description:

Process Weaver is a product based shipping solution provider Company, which provides Multi carrier shipping solutions for all the ERP’s globally, which involves Enterprise Centralized Shipping, Enterprise Track and Trace, Enterprise Address Validation

Responsibilities:

Customized standard Oracle Applications (EBS) reports and developed custom reports on Order Management, Purchase Order, Account Receivables, and Account Payables.

Preparation of AIM (Application Implementation Methodology) Documents for Functional and Technical specifications of Customizations, Interfaces and Conversions.

Developed New Reports and Customizations in XML Based reports using BI/XML Publisher.

Customized PO Print report

Developed Standard Purchase Order Inbound Interface.

Developed several PL/SQL packages, procedures, functions, triggers from GUI events or database triggers, to implement complex business logic.

Developed ITEM MASTER Conversion

Worked on Order to Cash life cycle implementation and integrating modules.

Developed many new reports like Customer Order status report etc.

Developed the AP invoices Interface program, loaded the data from flat file to the staging table using SQL * Loader and did all the necessary validations before loading into interface tables and Calling Payable Import Program.

Worked on GL Interface, Payables open Interface, AR Transactions conversions and interfaces.

Worked in Creating Value sets, Descriptive flex fields.

Environment: Oracle E-Business Suite R12.1.3 (GL, AP, AR, INV & OM, PO), Oracle 10g/9i, SQL, PL/SQL, Form10g, Reports 10g, Workflows, OAF.

Process Weaver/Intermec,India May’ 14 – Aug’ 15

Oracle Apps Technical Consultant

Project: R12 Support and Enhancement Project

Description:

The project is being an Implementation of Oracle Inventory, Account Payables, General Ledger.

This project involves providing complete Design, Development &testing and Post Production support.

Responsibilities:

Developed the reports development of Account Payables purchasing, purchasing modules.

Creating packages, procedures, functions, trigger and other database objects using SQL and PL/SQL

Creation of value sets in various modules of the application

Customization of standard packing slips Report.

Developed AP inbound Interface

Developed Purchase Order outbound interface using UTL_FILE package to transfer the data into global system.

Developed Payment outbound interface using UTL_FILE package to transfer the data into global system.

Developed Inventory Item Listed Report

Updated the customer bill to address details using API.

Developed custom interface that performs ship confirm or back order/cancel or apply custom Hold for the given order.

Worked on Item Conversion using API.

Creating a problem ticket with the monthly release team if the long term fixes for the issue needs any code changes to avoid the issue from happening again and suggest them where the changes are to be made.

Co-ordinate with deployment teams during the deployment windows and verify the fixes for the issues before giving sign off.

Environment: Oracle Applications R12.1.3 (AP, AR, HRMS, PO, OM), Developer 10g, PLSQL Developer, PL/SQL, SQL* Plus, SQL *Loader, Win SCP, BI Publisher.

GE-Capital, India Apr’13 – Apr’ 14

Oracle Apps Technical Consultant

Responsibilities:

Worked on Purchase Order Interface and receivables interfaces by loading data into staging tables from the legacy system.

Involved in Requirement Analysis, Design, Data mapping and client interaction.

Involved in Functional setups like Multi Org, Purchasing Module, Inventory Module

Developed New Reports and Customizations in XML Based reports using BI/XML Publisher.

DBMS development include building data migration scripts using Oracle sql*loader and UTIL packages

Worked on Purchase to Procure implementation and integrating modules.

Designed and developed PL/SQL packages to validate and import invoices into Oracle Receivables.

Worked on Unix shell scripts for data migration to UAT, SIT, Production.

Developed Item Conversions using PL/SQL packages.

Invoked standard API’s within custom packages for creating and updating Customer, Sites and

Contacts.

Worked on WSH report & email notifications of the report.

Involved in test plan and test cases in all the phases.

Trouble shooting, bug fixing and resolving critical errors while merging to Production.

GE-Health Care, India Aug’ 12 - Apr’ 13

Oracle Apps Technical Consultant

Description:

GE Healthcare is a subsidiary of General Electric (GE). The company provides medical imaging and information technologies, medical diagnostics, patient monitoring systems, drug discovery, bio pharmaceutical manufacturing technologies and performance solutions services.

Responsibilities:

Customized standard Oracle Applications (EBS) reports and developed custom reports on financials (AR, AP, GL), SCM Modules and inventory INV modules.

Preparation of AIM (Application Implementation Methodology) Documents for Functional and Technical specifications of Customizations, Interfaces and Conversions.

Developed New Reports and Customizations in XML Based reports using BI/XML Publisher.

Worked in Form Personalization's in Financial and manufacturing Modules.

Worked on Order to Cash life cycle implementation and integrating modules.

Developed many new reports like Customer Order status Report, Backlog Detail Report, Backlog Summary Report, Backlog by Item Report, Cycle Status Report, Open Work Order Report, Sales Rep Commission Report, Customer Profiles Report etc.

Developed the AP invoices Interface program, loaded the data from flat file to the staging table using SQL * Loader and did all the necessary validations before loading into interface tables and Calling Payable Import Program.

Designed, developed the screens like main menu, cash date form, general ledger input form which is involved in refreshing data and process net settlement activity on any particular day for batch rejections, individual rejections using Developer.

Worked in Creating Value sets, Descriptive flex fields, Lookups, Customer Design using TCA, setups and Statement of account Setups customizations in Dunning letters and Statement of accounts.

Extensively worked on RICE objects to view, transfer and modify the data in the same or different system.

Worked on HRMS Module.

Proficient in Procure to Pay (P2P) & Order to Cash (O2C) life cycles.

Developed PL/SQL programs using TCA API’s to validate and import customers from legacy system into base tables.

Involved in migration of GL and AP custom interfaces and reports, during oracle financials upgrade project.

Developed an interface to upload the journal data into the Oracle Application’s General Ledger, developed a PL/SQL procedure, which transfers data to interface tables after performing necessary business validation.

Experience with the Software Development Life Cycle (SDLC) process - performing detailed analysis, collecting requirements, technical specifications, development and unit testing, integration and production install and support.

Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.

Skillful in utilizing key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Developed several PL/SQL packages, procedures, functions, triggers from GUI events or database triggers, to implement complex business logic.

Involved in troubleshooting errors, fixing the bugs and fulfilled the new business requirements.

Interacted with users to resolve any issues during the production, development and enhancement phases.

Experience on TAR's (Service Requests) with Oracle on Demand Team and End users.

Involved in Performance tuning of complex queries.

Environment: Oracle E-Business Suite R12 (GL, AP, AR, INV & OM, and PO), Oracle 10g/9i, SQL, PL/SQL, Form10g, Reports 10g.

GE Wind Energy, India Jul’ 11 - Aug’ 12

Oracle Apps Technical Consultant

Description:

GE Wind Energy was a branch of GE Energy, a subsidiary of General Electric. The company manufactures and sells wind turbines to the international market. In 2009, GE was the second largest wind turbine manufacturer in the world.

Responsibilities:

Developed an Interface from Legacy System to Oracle General Ledger

Create a custom wrapper for Quoting process and embedded in quote details page based on the business requirements.

Inter linked quoting with Order management –Sales order form.

Created custom report in supply chain modules using BI Publisher.

Created dependent LOVs.

Customized various pages like create questionnaires page, search questionnaires page, update questionnaires page, delete questionnaires page, questionnaires detail page, confirm message page.

Hands on experience in development and extension RICE components using SQL and PL/SQL, Customization of forms using CUSTOM.pll, reports using Report builder 6i, XML Publisher Created custom forms with vendor specific information to aid Payables department secure information by department

Designed and developed custom forms and changed the forms based on requirement.

Added Descriptive and Key Flex fields on various Pages.

Created multiple pages with advanced table regions and export to excel functionality so users can export all the data in the excel file.

Created a PL/SQL package to create and handle procedure and function which perform required actions in the backend

Developed a PL/SQL package procedure to calculate multiple calculations based on Business requirement.

Developed a custom report to download price list and customer quotation using BI/ XML publisher.

Interacted with business analysts to develop modeling techniques and re-structuring strategies

Created Testing and Migration document (TE 20 / MD 120) for the testing components worked on.

Environment: Oracle Applications R12/11i, Toad 10.1, Java, Java Scripts, BI/XML Publisher, WinSCP, Putty.

GE OIL & GAS, India Nov’ 09 – Jul’ 11

Oracle Apps Technical Consultant

Description:

GE Oil & Gas offers VetcoGray equipment and services for onshore and offshore drilling and production. With over a century of experience in the oil and gas industry, VetcoGray can offer, through a single interface, customized or standardized solutions to meet the needs of any drilling and production project from concept to full production. The product offering covers the spectrum from single well onshore drilling projects to multiple well deepwater facilities and subsea production systems.

Responsibilities:

Created new procedures, functions, triggers, packages, and SQL*Loader scripts, and modified existing codes, tables, views, and SQL*Loader scripts

Worked on standard customization on reports.

Involved active participation in code migrations

Worked on category updating for different inventory organization

Worked on FNDLOAD scripts and post production support

Developed Item Upload Interface and tested the interface and make sure these interface are running as per the functional specifications.

Worked on the Quick Service Request Custom Form. Performed Major enhancement as per the Business needs.

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Developed several PL/SQL packages, procedures, functions, triggers from GUI events or database triggers, to implement complex business logic

Prepared the MD Documents for the Custom form as per the AIM Docs.

Involved in Converting Quotes from Legacy system to Oracle Applications. It involves populating headers and lines interface tables and finally converting all the Quotes to Oracle Applications using Import Price Catalog Process

Created a process to import data from excel file directly into the oracle table.

Responsible for migration script of code to different instances.

Developed reports for Quotation, Invoice, contracts and checks using BI/XML Publisher.

Involved with Testing Team in testing and fixing all the issues that came up while testing.

Created Functional, Technical, Testing, Migration documents (MD 200, TE 20, MD 120) by gathering the entire business requirements, components etc worked on.

Environment: Oracle Applications 11i, Developer 10g, PLSQL Developer, PL/SQL, SQL* Plus, SQL *Loader, WinSCP, BI Publisher.

Education:

Bachelor of Technology in Computer Science, JNTU, India

Contact this candidate