Oracle Sql

Harsha

Oracle E-Business Suite (EBS) Techno-Functional Consultant

Email:*************@*****.***

Phone: 401-***-****

Professional Summary

Around 4 years of experience in software industry in the Analysis, Design, Development, Migration, Implementation and Customization of Implementation of Software Applications.

Proven Technical skills in all aspects of software development Life Cycle, Conversion, Testing, Installation, Support, troubleshooting and enhancements.

Good expertise in RICEW (Reports, Interfaces, Conversions, Extensions, Workflow, OA Framework) components.

Extensive experience in Oracle Back-end (server-side) PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers using SQL Navigator and Toad as development tools. Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, and Synonyms.

Working knowledge in Performance tuning of the database using utilities like Explain plans, TKPROF, Tuning Lab, AWReports.

Worked extensively on Oracle Application Framework on jDeveloper 10.1.3.3.0

Development experience in SOA Web services on jDeveloper 11.1.1.6.0

Working Knowledge in Oracle Applications (E-Business Suite 11i/R12) Oracle Purchasing (PO),Order Management(OM), Trading Community Architecture (TCA),WEB ADI, General Ledger (GL), Accounts Payables(AP), Accounts Receivables(AR), Fixed Assets (FA),Procure to Pay, Order to Cash, and Self Serviced Applications such as iProcurement, isuppliers, iExpenses, System Administration, Application Object Library, and Oracle Alerts.

Well Versed with the various versions of Oracle Applications viz. R12.1.3/11.5.10/11.5.7.

Worked on various BI Publisher reports, interfaces development and conversions from scratch.

Worked extensively and has strong experience in the Oracle Application E-Business Suite development tool-set (Oracle 8i/9i/10g/11g, SQL*Plus, PL/SQL, Developer 6i (Forms and Reports), Jdeveloper 10g, Discoverer, BI Publisher, TOAD, XML Publisher, Shell Scripting, OAF, Forms Personalization, Form Customization using CUSTOM.pll, Customizing and Developing Workflows and using Oracle Applications API’s).

Performed various roles like Custom Design, Software Engineer and Technical Consultant in Production support, implementation and upgrade activities.

Implementation Methodologies like AIM (MD200/MD50/60/70/120, BR100, TE50, Process Documents).

Excellent communications and interpersonal skills. Well versed in gathering requirements from customers/clients. Conversant with Project Management and Quality procedures and working with Oracle Support, Creating Service Requests, and Visual Safe Source to maintain source code.

Extensive experience in Creating Users, Responsibilities, Request Sets, Request Groups, Profile Options and registering Executables, Concurrent Programs, Form Functions, Reports by using Application Object Library (AOL), System Administration.

Proficient in Interface Programs and Conversion Programs for importing data from Legacy Systems using SQL LOADER.

Technical Skills:

Oracle Applications

R12.1.3, 11i (11.5.10/11.5.7), 11.0.3, SOA Web service, OAF, ADF

Modules:

Order Management, Shipping, Purchasing, Payables, Receivables, Inventory, Bills of Material, Work in Process, Configurator, EDI, XML Gateway, Cost Management, Depot Repair, Oracle Pricing, Quality, ASCP, Demand Planning, System Administration and Workflow modules, General Ledger, SLA, Internet Procurement, Sys Admin and AOL Modules, iExpenses, Order Management.

Tools

BI Publisher, Oracle Discoverer, jDeveloper 11.1.1.6.0,10.1.3.3.0, Developer (Form 9i/6i/4.5 and Reports 9i/6i/2.5), SQL Loader, TOAD, SQL Navigator, SQL Developer

Platform

Apex Classes/Controllers, Apex Triggers, SOQL, SOSL, Visual force (Pages, Components & Controllers), Lightning Components, AppExchange, Communities, DocuSign, Knowledge, Force.com Sites, Integration, Apex Web Services (SOAP, REST), Force.com IDE Plug-in.

Languages

Advanced PL/SQL, SQL, C, JAVA, Shell scripting, PERL

Operating System

WINDOWS, UNIX

Professional Experience:

Inovalon, MD Nov 2016 – Present

Technical Consultant

Description: Technical consultant part of Financials team.

Part of Upgradation team for 12.0.1 to 12.2.4

OAF personalization on supplier and customer OAF Page

Involved in post migration support includes analysis, debugging and code fix.

Also part of the production support Team to resolve Oracle ADF issues for the present screens.

Implemented GL, AP, AR, Purchasing, Inventory, Order Management, System Administrator modules.

Performed setups for Order Management and Shipping Execution modules.

Month end closing support for financial modules

Coordination with oracle support on production issues based on severity thru service requests.

Timely interact with functional team gathering new requirements on custom business objects.

Involved in custom process of escheatment process in account payables.

Involved in resolving crucial production issues related to: Conflict resolution manager, Positive payments stuck at reconciliation, Project accounting vs chargeable funds invoicing rules.

OAF Customizations on iProcurement screens

Involved in SAND testing and quarterly maintenance along with patch analysis.

Developed key or complex reports in project accounting, accounting payables and receivables.

Environment: Oracle Applications EBS (12.1.3), Sys Admin, AOL, GL, AR, AP, PO, PL/SQL, OM, SQL*Plus, Toad, Reports 10g, Forms 10g, Discoverer, BI Publisher. Advance Pl/sql, Pl/sql, Sql, Forms6i, Reports 6i, Unix, Shell Scripting, Performance Tuning, Oracle Discoverer, XML, Java script.

AQR Capital Management LLC, Greenwich, CT Sep 2015 to Sep 2016

Technical Consultant

Description: Involved in Design/Development of EBS custom business requirements and Deployments.

Part of Upgradation team for 12.0.1 to 12.1.3

Worked on Creating Data Source, Users, Roles, and Assigning Roles to Users, developing BI publisher reports in OBIEE.

Developed two custom OAF Pages by creating Entity Objects, View Objects and Controllers and registered them in Oracle Applications.

Lead the development team and consultant’s teams globally.

User training and production support of Oracle Applications 11i/ R12 (Procure to Pay, Order to Cash, Self Serviced Applications such as iProcurement, suppliers, iExpenses, Purchases, Order Management, Workflow, Self Service Web Applications, Cost Management,WEB ADI,

Involved in the Customization of Purchase order and invoice approval Workflow.

Involved and reviewing the MD50’s and MD70’s for designing and developing Interfaces, conversions and reports for the Phase II

Developed internal Service Request system by customizing Oracle Forms, alerts and reports

Utilized AIM METHODOLOGY and created MD50, MD70 and CV40 documents for supporting applications

Generating the Code Combinations using Account Generator and Workflow

Developed PL/SQL program for Loading the Data from the file into Oracle Custom tables using UTL File utility

Developed PL/SQL program for Processing the Data for customer and vendor validations and insert into AP & AR interface tables

Worked on Auto Invoice, Auto Lockbox, and Customer Interfaces in AR module

Customized the Variances reports for executive business requirement

Customized the ACH and Positive pay process for sending to Bank

Customized the AR Lockbox process.

Designed and developed the Custom Check printing process

Designed and developed the Service Request system internally to maintain all the bugs/enhancement requests.

Designed and developed the Procurement Card Transactions process.

Designed and developed Global Inventory Details by Account reports.

Involved in Unit and SAND Testing of quarterly EBS refresh and maintenance.

Imported Customer Information by using Customer Interface in Receivables. Worked on Auto Invoice to import Invoices, Debit Memos and Credit memos

Created programs to validate the data received from banks and developed program to create lock box interface lines and header records to lockbox interface tables.

Performed system administration functions such as Creation of Users, Creation of Responsibilities and Set up user profiles specific to applications

Working with global users to gather the requirements.

Involved in user meetings for Gap Analysis

Coding the Custom Packages, Procedures and Functions for Custom Reports for all the various modules using PL/SQL programs.

Environment: Oracle Applications EBS (12.1.1), Sys Admin, AOL, GL, AR, AP, PO, PL/SQL, SQL*Plus, Toad, Reports 10g, Forms 10g, Discoverer, BI Publisher. Advance Pl/sql, Pl/sql, Sql, Forms6i, Reports 6i, Unix, Shell Scripting, Performance Tuning, Oracle Discoverer, XML, Java script.

Arcelor Mittal- Burns Harbor, IN Aug 2014 to July 2015

Technical Consultant

Handled Multiple roles and responsibilities; Lead, Developer and Performance Changes in the custom objects for communication sector EBS projects.

Identifying the Various Unit areas for Performance Tuning.

Creating the Virtual Users and taking the Readings using JMETER. Metadata Collection for all the modules given as a requirement.

Post Implementation support of oracle EBS 11.5.10.

Involved in upgrade of EBS 11.5.7 to 11.5.10

Developed webservices for reporting customer outstanding balances to internal business applications.

Used oracle subscriptions to develop custom process post workflow approvals.

Environment: Oracle 9i, SQL, PL/SQL,JavaScript, Win 2000/XP, TOAD 7.5, SQL, PL/SQL,JSP,Javascript,Forms6i, JDeveloper,MSXML4.0 XSL, SOA.

Capgemini Solutions, Bangalore July’ 13 to July’14

Technical Consultant

Description: As a fresh Graduate Got assigned to work on Oracle associated Projects and as a beginning.

Trained as Oracle Application Developer in SQL STAR INTL

Key project implementations as team member

ICDS-CARE (Integrated Child Development Services).

o Developing the forms and reports using forms9i and reports9i.

oProduction support on custom application and debugging.

Involved in development, customization and data migration into Oracle Applications project.

Involved in the creation of database and database activity, performance tuning.

Utilized Application modules, e.g., PO, INV and PA. Involved in the customization of forms and reports using developer/2000 tools and loaded legacy data into Oracle applications modules.

Developed various custom programs in Oracle Applications as concurrent programs. Involved in data load using Interfaces to load legacy data into Oracle modules, Used SQL * Loader and PL/SQL to load data into Apps production tables from flat file via temporary tables, Worked as a member of Oracle Applications ERP Data Migration Support Team, Responsible for registration of new programs in Oracle Applications as concurrent programs, Used UTL_FILE packages, DBMS Packages and PL/SQL to develop batch programs.

Developed “Electronics File Transfer Payment” programs to automate payment transfer.

Wrote Shell scripts that were directly called from Oracle Applications, Conducted training on SQL, PL/SQL and Oracle Developer.

Prepared design and deployment documentation provided deployment and data migration services and assisted with user training, Involved in registering the reports, screens and batch programs, unit testing, and verification with users.

Contact this candidate