Oracle SQL developer PL/SQL Oracle reports Oracle applications
Resume:
*+ 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
**************@*****.***
Senior Software Engineer- Oracle Applications
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