*+ years of engineering service experience in working with Oracle SQL and PL/SQL, P2ES,

Oracle Application 11i/R12, BI Publisher Report, Oracle Alerts, SQL Loader and Report Builder. Areas of Expertise:

Expertise in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages with validations and exception handling and SQL Loader.

Expertise in Concurrent program executable, program, value sets, user, responsibility, menu and functions creation and mapping it to the corresponding application group.

Good Exposure on preparing installation shell script for deploying and handling performance issues.

Expertise in customer handling.

Good Knowledge in Data template, Shell Scripting and bursting.

Basic knowledge in Informatica process.

Highly motivated, energetic individual, with good communication skills.

Excellent Technical skills and an excellent team player

Good knowledge in understanding functional documents and designing technical documents. Experience:

Organisations Position Duration

VG IT Solutions Pvt. Ltd, Chennai Senior Software Engineer April-2011 to Till Date. Certification and Course:

Completed Oracle 9i PL/SQL Developer Certified Associate (OCA) certificate at ORACLE. Professional Experience:

BATHRANANTHAM. A

adkmds@r.postjobfree.com

Senior Software Engineer- Oracle Applications

+91-999*******

Palani-624621

Technical Skills:

Category Tools/Technologies

RDBMS Oracle 10g, Oracle 9i

Languages/Scripting SQL, PL/SQL, XML Publisher and Shell Script Operating Systems All MS-Windows versions and Linux Oracle Tools

TOAD, SQL PLUS, PL/SQL, SQL LOADER, Report Builder 6i/9i/10g, Winscp, FileZilla, Putty, Oracle BI Publisher (RTF), Informatica Power Center

ERP Oracle E-Business Suite 11i/R12(OracleApps)

P2ES Production, JVA, Revenue, Land

Project Details:

No

Project Name Duration Key Environment

1 Southwestern Energy Feb 2017 - Till Date

PL/SQL,Oracle Application

R12, P2ES

2 OXY Shared Services Support Nov 2016 - Jan 2017 PL/SQL 3 AP/AR Web Application Jan 2016 - Oct 2016

Oracle Application R12, BI

publisher Reports, PL/SQL

4 Southwestern Energy Jan 2015 - Dec 2015

PL/SQL,Oracle Application

R12, P2ES

5

Occidental Petroleum Corporation

(OXY)

Feb 2014 - Dec 2014 PL/SQL

6 Southwestern Energy Jul 2011 - Jan 2014

PL/SQL,Oracle Application

R12, P2ES

Project 6: Southwestern Energy, USA

We have developed all RICE(Reports, Interface, Conversion and Extension) components across various modules such as Revenue and Production Management. Roles & Responsibilities:

Developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages, Reports, SQL Loader, Oracle alerts and email bursting.

Creation of database objects, developing numerous interfaces and conversions with validations based on requirements.

Creating executable, concurrent programs, value sets and registering them into oracle applications for running the interface, conversion, reports and sql loader.

Analyzing and modifing Informatica Workflow to load data from one db to another.

Onsite coordination – Regular interaction with client and getting requirement details, updating and tracking status of tickets.

Preparing code bundle, technical design documents MD-070 and Installation document MD120.

Project 5: OXY Shared Services Support, Occidental Petroleum Corporation (OXY), USA The purpose of this project is to provide production support to OXY. We did few enhancement and fixed issues in existing packages, Oracle workflows, Oracle forms and SQL loader. Roles & Responsibilities

Modifing/creating custom objects, PL/SQL package, procedure, functions, SQL loader, forms and workflow based on the requirement.

Development and customization of executable, concurrent programs, creating value sets and registering them into oracle applications for running the interface, conversion, reports and sql loader.

Preparing code bundle, technical document and installation document. Project 4: AP/AR Web Application, Indigo Beam, USA Replacing the existing MS-Access technology with Oracle APEX for the AP/AR applications with user security. Migrating objects used in the MS-Access to Oracle database objects. Creating all MS-Access reports in oracle BI/XML Publisher reports and register concurrent programs. Roles and Responsibilities:

Migrating MS-Access objects to Oracle objects by developing stored packages, procedures and functions accordingly.

Creation of DB objects, XML publisher reports, user, responsibility, menu and functions.

Development of executable, concurrent programs, creating value sets, request sets and registering them into oracle applications.

Preparing code bundle, technical documents and installation scripts. Project 3: Southwestern Energy, USA

We have developed all RICE(Reports, Interface, Conversion and Extension) components across various modules such as Revenue and Production Management. Roles & Responsibilities:

Developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages, Reports and SQL Loader.

Involved in development of interfaces which will extract the data from flat files into custom tables using SQL Loader and developed package to validate and load data into base tables.

Development of executable, concurrent programs, creating value sets and registering them into oracle applications for running the interface, conversion, reports and sql loader

Preparing Technical Document (MD070) and Installation Document (MD120). Project 2: Occidental Petroleum Corporation (OXY)

The purpose of this project is to separate all California assets as separate company and whole new separate entity. We have created Conversions to Identify EU CA (California) data and loaded those into custom tables.

Roles & Responsibilities

Creation of custom objects, PL/SQL package, procedure and functions.

Data loaded into tables using Conversions with validations.

Handling exceptions and performance issues.

Tuning and testing the codes.

Creation of Technical (MD070) Document and installation scripts. Project 1: Southwestern Energy, USA

We have developed all RICE components across various modules such as Revenue and Production Management.

Roles & Responsibilities:

Developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages, Exceptions, Reports and SQL Loader.

Creation of database objects, developed numerous interfaces and conversions based on requirements.

Development and customization of reports based on requirements.

Preparing deployment script of developed codes for migrating into client server using shell script.

Responsible for feasibility analysis and preparing technical design documents MD-070 and Installation document MD120

Education :

Course Institution

Board/

University Year of Passing

MBA(TM)

(PT)

Madras Institute of Technology(MIT),

Chennai

Anna

University

2014

B.E (ECE) Sri Subramanya College of Engineering &

Technology, Palani.

Anna

University

2010

HSC Crescent Matriculation Higher Secondary

School, Neikkarapatti, Palani

State Board 2006

SSLC Crescent Matriculation Higher Secondary

School, Neikkarapatti, Palani.

Matriculation 2004

Personal Details :

Father’s Name : Angamuthu K

Marital status : Married

Date of Birth : 10.05.1989

Gender : Male

Languages Known : English, Tamil

Permanent Address : V.P Pudur, Palani (TK), Dindigul (DT) – 624621 I hereby declare that the above written particulars are true to best of my knowledge. BATHRANANTHAM A

Contact this candidate