RAGHUL.V

Flat No:**** NPL Anjli Apartments,

*** *.*.* ****, Villivakkam,

Chennai - 600049

Mobile no - 996-***-****

Email id:ac4kyq@r.postjobfree.com

OBJECTIVE

To secure a position that will allow me to fully utilize the depth and breadth of the knowledge and skills that I have cultivated so far, as well as to gain valuable work experience that will allow me to grow both professionally and personally.

EXPERIENCE SUMMARY

Having 3.5 years of experience in design, development and supporting of Oracle Applications 11i and R12.

Hands-on experience in Oracle Open Interfaces and APIs.

Exposure to key business processes in different modules like AP, AR, GL,PO,FA and OM.

Experience in Application Developer & System Administrator Responsibilities.

Proficient in writing stored Procedures, Functions, Packages and Triggers using SQL & PL/SQL.

Experience in working with Utilities like SQL*Loader, Toad, UTL_FILE Package and WINSCP.

Good Technical and Functional knowledge in Procure to Pay Cycle and Order to Cash Cycle.

Amazon Cloud : Amazon Web Services (EC2, Route53, S3, RDS, Cloud Watch, IAM, VPC,ELB)

Hands on experience in Technical Documentation using AIM Methodologies.

Translate business needs into technical deliverable solutions.

Capable of working independently and as well as a part of a team.

WORK EXPERIENCE

Worked as a Associate Technical Consultant for Chain-Sys India Private Ltd, Chennai(INDIA) from Jan 2014 to Till Date.

INTERNATIONAL CERTIFICATIONS

Oracle Certified SQL Expert- ORACLE

Completed a course on SQL Server® 2008,Implementation and Maintenance and I have been certified(MCTS) by the Microsoft.

Completed a course on Amazon Technical Essentials on Amzon Web Services.

EDUCATIONAL QUALIFICATION

B. E Electronics and Communication from Velammal Institute of Technology, Chennai(INDIA).

TECHNICAL SKILLS

ERP : Oracle Applications 11i/R12

Modules : AP, AR, GL, PO,FA and OM

Oracle Stack : Oracle Database 10g/11g

Languages : SQL, PL/SQL

Tools/Utilities : Toad, SQL Developer, WINSCP,SQL*Loader and Postman Application

Operating Systems : Windows XP/ Vista/ Windows 10,Windows 7,Windows 8

Cloud : Amazon Web Services(EC2, Route53, S3, RDS, Cloud Watch, IAM, VPC,ELB)

ETL Tool : Appload-Migrator, AppConnect which is similar to Informatica

Expert in creating SQL Queries, PL/SQL package, function, stored procedure, triggers, and cursors.

Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL Developer and SQL*Plus.

Created PL/SQL functions to facilitate business functions and calculations.

Enforced database integrity using primary keys and foreign keys.

Worked on PL/SQL Cursors, Collections and Set operators.

Setup/Managing CDN on Amazon CloudFront to improve site performance.

Create/Managing buckets on S3.

Creating AWS Instances using AMI.

PROJECT EXPERIENCE

Project#1

Client

ALLEGION

Project

Oracle Application 11i

Role

Developer

Environment

Oracle Applications 11i,SQL Developer, TOAD

Modules

INV,AR

Duration

APR 2014 - AUG 2014

ROLES AND RESPONSIBILITY

Interacted with the users for requirement gathering for above Module.

Developed AppMigrate Data template and loader to load data into Oracle applications via Excel.

Map the AppMigrate template columns to Open Interface Tables to load into 11i.

Executing the Concurrent program from PL/SQL block.

Solving the issues raised by Client according to their requirement.

Project#2

Client

CDM SMITH

Project

Oracle Application 11i

Role

Associate Consultant

Environment

Oracle Applications 11i,SQL Developer, TOAD

Modules

HRMS

Duration

SEP 2014 - APR 2015

ROLES AND RESPONSIBILITY

Interacted with the users for requirement gathering for above Module.

Created Custom Packages for strong validation of records and Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Developed AppMigrate Data Templates for above objects as per business requirement.

Moving the Data template file to WINSCP location by FTP Methodologies.

Involved in writing Post processor blocks, anonymous blocks and incorporating it in ETL tool.

Project#3

Client

GENERAL ELECTRIC

Project

Data Migration from 11i to R12 using AppLoad tool

Role

Associate Consultant

Environment

Oracle Apps 11.1.8 & R12.1.3,SQL Developer, TOAD

Modules

PO,AP,GL

Duration

MAY 2015 - MAR 2016

ROLES AND RESPONSIBILITY

Interacted with the users for requirement gathering of objects development.

Worked as an Oracle Application R12/11i (E Business Suite) Techno Functional consultant

Involved in development of API’s and Open Interfaces for data conversions.

Developed 11i extract query for extraction of data and loaded in R12 instances.

Involved in creation of data Pre-validation and Conversion procedures for loading the data.

Provided the Technical & Functional support in SIT, UAT and Production Instance.

Project#4

Client

SUFFOLK

Project

Data Migration from Oracle R12.13 into Cloud using AppCONNECT tool by Web Service API

Role

Associate Consultant

Environment

Oracle Apps R12.1.3,SQL Developer, TOAD and Postman Application

Modules

HRMS,AP

Duration

APRIL 2016 - Present

ROLES AND RESPONSIBILITY

Testing Create, Update, Show, List Web Service API’s using Postman Application.

Migrating Employee and Vendor Data from R12.1.3 into Procore (Non-ERP Product) which is in Cloud by passing Web Service URL.

Developed R12 Extract Query for Migrating data from R12 and load these data in temporary table.

Developed data templates according to web service API columns.

Hands on Experience on Procore (Non-ERP Product) in Cloud.

ACHIEVEMENTS

My name was published in the paper “THE TIMES OF INDIA” as a leading run scorer in the blue sky tournament at Don bosco cricket ground in Perambur(INDIA).

Awarded Excellence in Leadership by General Electric company for leading GE Corporate project.

PERSONAL DETAILS

Date of Birth : 04-08-1992

Languages known : English, Tamil(Read, Write, Speak)

Date:

Place: Chennai(INDIA) RAGHUL.V

Contact this candidate