OBJECTIVE

Seeking an innovative and responsible position wherein my technical prowess and experience can be utilized appropriately with exposure to new areas to enable me to make useful contributions for the benefit of the organization.

PROFESSIONAL SUMMARY (May,2014-Present)

Over 6 years of experience as Oracle Application Technical Developer in study, design, development, and support of Oracle based products. This includes working on and managing multiple products at the same time along with client interactions and process flow derivations.

Over 1 year of experience in Oracle Cloud.

Working on latest emerging technology of Blockchain.

Hands-on experience in Data Conversion, Integration and Data Migration within several modules in Oracle Applications.

Worked extensively on Oracle Fusion Reports which includes modules like AP, TAX, PO, Projects etc.

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

Well versed with client server environment and tools like SQL*Plus, PL/SQL, Oracle*Forms, Oracle*Reports.

Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, Oracle packaged APIs etc.

Involved in Customer Conversions to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs

Developed and tested various standard templates (Suppliers, Customers, GL Journal import, Customer Quotes, QP Price List and some Custom Objects) for conversion.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Submitted Service Request with Oracle Support in different Scenarios, for providing Solutions to the Bugs identified during Production support resolved various bugs, working in collaboration with Oracle Support.

Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.

Strong in Performance Tuning

Write technical design documents for conversions, troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).

Interacted with users, fixed the bugs, developed test plans and provides daily production support.

Adroit in Performance tuning for optimized results using tools like EXPLAIN PLAN, BULK FEATURE.

Excel in team collaboration, quick adaptation and problem solving with good communication skills.

Presented ppts for representing the project to the Client

Developed code for the common batching process which will enhance the performance of Conversions.

TECHNICAL PROFICIENCIES

ERP

ORACLE E-Business Suite R12.2.4

CLOUD

Oracle Cloud

ERP & Cloud Modules

Purchasing

Receivables

Accounting

GL

Quoting

TCA

TAX

Relational Databases (RDBMS)

ORACLE 10g

Tools

ORACLE FORMS & REPORTS 9i & 10g

BI Publisher

PLSQL Developer

WinSCP (ftp),Putty

SQL Developer

Oracle Cloud Explorer

Languages

Structured Query Language(SQL)

Procedural Language(PLSQL)

Core Java

C & C++

Total Experience

Total 4.7 years IT Experience

TRAINING DETAILS

Skills Learnt

PL/SQL

Core JAVA

Oracle D2K Forms/Report

XML Publisher

Oracle Apps R12

R12.x Oracle Purchasing Fundamentals

R12.x Oracle Receivables Fundamentals

TCA Architecture

BI Publisher

ADF

Oracle Cloud

ACHIEVEMENTS

Achieved Pat on the back Award for delivering excellent performance

Received Appreciation award at the time of go live for excellent performance.

Achieved Spot Award for demonstrated high level of commitment in delivering the tasks assigned.

CERTIFICATIONS

Oracle Financials Cloud Receivables Certified Implementation Specialist

Oracle Financials Cloud Payables Certified Implementation Specialist

Oracle Financials Cloud General Ledger Certified Implementation Specialist

PROFESSIONAL EXPERIENCE

DELOITTE CONSULTING INDIA PVT. LTD., Gurgaon.

Dec 2016 – Dec 2019

Role

Oracle Apps Technical Consultant

Responsibilities

Worked in ERP Integration and Interface Reports.

Worked on Cloud fusion Reports touching various modules such as AR,AP,PO,TAX and Projects.

Worked on the development of Inbound and Outbound interfaces touching various modules such as Suppliers, Invoices, AR and AP.

Developed various XML Reports with bursting functionality.

Interacted with client and onsite team members to understand requirements and process flows.

Created solution design documents for various modules.

Key member in designing technical and functional solutions for various requirements like creation of AR Invoice, AP.

Expertise in System Administrator responsibility to create users, responsibilities, Values Sets and Request sets.

Developed PL/SQL packages to validate the data and generate the output file.

Used Bulk Collect feature to improve performance.

Developed PL/SQL procedures, functions, packages to validate the data and insert the validate data into Oracle Standard interface tables.

Proactively tuned SQL queries & Views using Explain Plan and indexes.

Involved in handling and organizing cultural events.

Part of developing a solution in Blockchain.

Developed a tool for automatic configuration from EBS to Cloud.

Team Size

40+

Environment

Oracle Applications R12

IGATE GLOBAL SOLUTIONS PVT. LTD., Airoli, Mumbai.

May 2014 – Nov 2016

Project Name

GE Aviation Material Connect

May 2015–Nov 2016

Client Name

GENERAL ELECTRONICS.(GE)

Role

Oracle Apps Technical Consultant

Responsibilities

Part of Conversion track. One of the 4 tracks the project is divided into.

Worked on the development of Data Conversions, touching various modules such as Vendors, Customers, Quotes, INV and AP.

Developed custom programs to load data into Inventory using custom staging tables.

Interacted with client and onsite team members to understand requirements and process flows.

Created solution design documents for various modules.

Developed customer conversion program to load the customers from legacy system into Oracle EBS System by using the TCA APIs

Key member in designing technical solutions for various requirements like creation of Vendors, Customers, Quotes, Work Order, Pricing,AP.

Expertise in System Administrator responsibility to create users, responsibilities, Values Sets and Request sets.

Worked on Version Control software to check-in codes.

Submitted Service Request with Oracle Support in different Scenarios, for providing Solutions to the Bugs identified during Production support resolved various bugs, working in collaboration with Oracle Support.

Used Bulk Collect feature to improve performance.

Developed PL/SQL procedures, functions, packages to validate the data and insert the validate data into Oracle Standard interface tables.

Proactively tuned SQL queries & Views using Explain Plan and indexes.

Received appreciation mail from client within few days of working in the project.

Team Size

30+

Environment

Oracle Applications R12

Project Name

CMS(Cemli Management System)

June 2014-May 2015

Client Name

IGATE Internal Project

Role

PL-SQL Developer

Responsibilities

PL-SQL Developer for migration of data from Legacy system to Oracle Applications

Played the pivotal role in the team

Involved in loading data and developing Various PL-SQL programs for the development of automated tool to be used for data importer and configuring templates and running the conversion.

Developed and tested PL/SQL Packages and codes for Conversions.

Developed code for the common batching process which will enhance the performance of Conversions.

Presented ppts for representing the project to the Client

Involved in Design and Development of new requirements.

Involved in understanding & analysis of the current migration custom processes.

Closely worked with team to understand the needs and objectives.

Worked on SQL*Loader Scripts to migrate the invoice data from the flat files and populate the staging tables before implementing auto invoice interface.

Developed PL/SQL procedures, functions and packages for validating the Customers data before importing it into Account Receivables interface tables.

Involved in Conversions of GL Journal Import, Vendors and Customers.

Developed various scripts to validate migrated data.

Developed various programs using dynamic SQL for the automated conversion tool.

Involved in identification of bugs/shortcomings of the migration programs and suggested feasible solutions as per the requirements.

Motivated the team to put in extra efforts and deliver under pressure.

Team Size

15

Environment

Oracle Applications R12

OTHER JOBS HANDLED (I.T)

In-charge of raising Service Requests with Oracle Corporation via Metalink for issues relating Oracle Database, Application Servers and Forms & Reports.

Handled client calls whenever required.

Working in one of the firm initiative in Blockchain.

Training imparted on TCA Architecture.

OTHER JOBS HANDLED (NON-I.T)

Worked as a Senior Lecturer of Mathematics and Business Development Manager in Mentors Academy Chandigarh for 1 year(2011-2012)

Worked as a Junior Lecturer of Mathematics in Mentors Academy Chandigarh for 1 year (2010- 2011).

EDUCATIONAL QUALIFICATIONS:

Kurukshetra University, June 2013.

Bachelor of Technology in Electronics and Communication from Kurukshetra University with 68%

CENTRAL BOARD OF SECONDARY AND HIGHER SECONDARY EDUCATION, CHANDIGARH.

12th with 80%. [March 2009]

10th with 82%. [March 2007]

OTHER DETAILS:

Working Status : Confirmed.

Date of Birth : 22nd November, 1991

Nationality : Indian.

Marital Status : Single.

Language Proficiency : English, Hindi and Punjabi.

Hobbies : Singing, Dancing, Painting, Solving Mathematical Calculation

Signature:

Anjali Bakshi.

Contact this candidate