Team Member/Oracle Apps Technical Con Resume

SUMMARY

Experience in Application development and Maintenance/Support projects using SQL, PL/SQL, and Unix Shell Scripting with extensive understanding of different Application development tools and technology.
Over 2 years of extensive experience as Oracle Application Technical Consultant in Implementation of Oracle e - Business Suite Applications (R12). This includes system study, design, development, and support of Oracle EBS.
Having good experience in SQL and PLSQL development using ORACLE 11g and ORACLE 12c.
Extensive experience in creating complex database objects like stored procedure, Functions, Packages, Collections and Triggers.
Experience in Creating Tables, Views, Constraints, Sequences and Synonyms.
Proficient in PL/SQL programming - Stored Procedures, Functions and Packages, Constructing of Tables, Views, Database Triggers, Synonyms, Cursors, user defined exception, indexes, Analytical Functions, SQL-Loader etc.
Aware of the Concept of Exception handling mechanism in various scope and visibility.
Involved in development of code from scratch for the given requirement.
Planning, delivering and implementation of quality solutions as per scheduled milestones.
Good communicational and interpersonal skills and involved in client interactions for scoping, effort estimates and status reporting.
Ability to learn new technologies with minimal time period and excellence in team playing with multi-location teams
Expertise in Client-Server application development using Oracle11g/12c, PL/SQL, SQL *PLUS, TOADandSQL*LOADER
Extensive experience in implementation, Migration, Customization, Production, and support of various modules in Oracle Applications with major focus in Order Management (OM), Inventory (INV), Accounts Receivable (AR), Accounts Payables (AP), Loan management(LM).
Experience in Order to cash (O2C) life cycles and Supply Chain business flows.
Proficient 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.
Developed new Concurrent Programs, Custom Forms and Reports Customizations.
Well versed with client server environment and tools like SQL*Plus, PL/SQL, SQL*Loader, Toad, Workflow.

TECHNICAL SKILLS

Operating System: Windows 7/10, Linux, Unix

Languages: VB6, SQL, PLSQL, UNIX, SHELL SCRIPTING

Tools: Used Toad, PUTTY, SQL Developer.

Version Control/Repository: GIT

RDBMS: ORACLE 10g, 11g, 12c, SQL*LOADER

Ticketing Tool: PPM

PROFESSIONAL EXPERIENCE

Confidential

Team Member/Oracle Apps Technical Con

Environment: Oracle 11g, SQL, PLSQL, SQL Developer, GIT Extension

Responsibilities:

Preparation for Documents, Modifications, and Implementation.
Technical Analysis and preparation of Installation Documents on issues.
Financial Team System Setups and creation of Roles and Responsibilities of New operating unit and modifying.
Financial Setups (AP), Intercompany Invoices in USD.
Built a brand-new Flying hours OAF form, to maintain flying hour details.
This form was built from scratch and involved extensive coding in Java, creation of Entity and View objects, and other development objects all using standard MVC architecture.
Was also involved in maintenance and bug fixing of several existing OAF forms.
Operating OAF Pages for Order Management.
Customization of Existing Reports
Worked on discoverer admin edition, desktop edition, viewer edition.
Developed discoverer tabular reports, cross tab reports, drilldown reports.
Code review and testing and fixing the problems. workflow customizations
Developed oracle apps alerts.
Preparing Technical Designing Documents by using AIM Methodology.
Involved in requirements gathering, analysis, development, QA and postproduction support.
Performed GAP analysis to ensure that the requirements are captured properly.
Build the code, design the workflow and unit testing as per test cases
Provided instant solutions to issues which were reported in the production instance.

Confidential

Team Member/Oracle Apps Technical Consultant

Environment: Oracle Technical Support.

Responsibilities:

To create loans with Web Adi, loan disbursement, we need to update which customer having number of loans.
Procedures for logically need to calculate find total interest, processing fee, and penal charges.
Creation of customer Web Adi, Create receipt Web Adi, Approval of through Web Adi.
Data Loading through SQL Loader and attached to concurrent program, inserting staging table after inserted into standard tables.
API‘S are using to achieve client logics
Loan portfolio report is the report file for each and every loan details with all taxes and deductions.
Loan Documents, Loan Files and creating the RTF Templates in BI Report.
Financial Setups (AP), Generating Invoices and receipts for the loan dues and Prepayments.
Developing the SQL queries for the customer logics and their functionality.
Worked on Loan management, Account Receivable (AR), Account Payables (AP), Application objective Library (AOL).

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship