Pl Sql Oracle Plsql

Ramachandran N (Java / J*EE / Advanced Oracle PLSQL) +1-913-***-**** / +1-913-***-****

Career Objectives

n Overall experience is 16 years and currently working in Mphasis for 8.5 years on Java/ Webservices/ Oracle PLSQL/Business Analyst. I have involved in developing and maintaining complex Java applications using Oracle PL/SQL. I am also proficient in using GitLab for version control and project management, and I have experience setting up and managing CI/CD pipelines.

TalentNext Certified Skill

Skill Details: Java Microservices, Extensive knowledge in PLSQL Development, Requirement Gathering

Technical Competencies

Programming Language: Java / Restful / Api Webservices, Advanced PLSQL

Tools: GitLab, Oracle SQLDeveloper, SVN, Toad for Oracle, Eclipse

Education Details

Qualification/ Degree

Discipline

Education Institution

University

Year of Completion

PUC/12th Grade

Mathematics

Donbosco HSS

Directorate of Government Examinations, Tamil Nadu

2000

SSLC/Metric/High School

SSLC/Metric/High School

Donbosco HSS

Directorate of Government Examinations, Tamil Nadu

1998

B.Sc.

Mathematics

Thiruthangal Nadar College

University of Madras

2003

M.C.A.

Computer Applications

Pachaiyappa's college

University of Madras

2006

Projects Experience Summary

Project Name

MagentaBuilt (T-Mobile 5G Towers)

Organization

Mphasis Corporation, Kansas, USA

Duration

01-Mar-2022 to Till Date

Environment

Java Rest API, Advance Oracle PLSQL

Advanced Skills

Expertise in Oracle PLSQL, Procedures, Packages, Triggers, Table Partition and Oracle Query Tunning. Bulk upload using the merge query.

Description:

MagentaBuilt maintain inventory of the 5G Tower from Installation to Making (On-Air) Live and Bring back to Off-Air. Ring and Site Creation Processes, Ring Management, Ring and Site From/To Matrix, Ring and Site Status Definitions, How to use Ring Tracker Maps, Site Management

Responsibilities:

A senior PL/SQL developer with 15 years of work experience is a highly skilled and experienced database professional with a deep understanding of the PL/SQL language and the Oracle database. They have a proven track record of developing, maintaining, and optimizing complex PL/SQL applications.

In addition to their technical skills, senior PL/SQL developers also have strong analytical and problem-solving skills. They are able to work independently and as part of a team to deliver high-quality results on time and within budget.

Senior PL/SQL developers are in high demand in a variety of industries, including healthcare, finance, telecommunications, and manufacturing. They typically work for large enterprises, but there are also opportunities for senior PL/SQL developers to work for smaller companies and startups.

Here are some of the responsibilities of a senior PL/SQL developer:

Develop, maintain, and optimize complex PL/SQL applications

Development in following Java/JSP/Servlet/Webserivces

Write and review PL/SQL code for accuracy, performance, and maintainability.

Oracle PLSQL Development / DBMS Scheduler / Oracle Performance query tuning

Work with database administrators to ensure that PL/SQL applications are properly tuned and optimized

Participate in the design and prepare the requirement document. Implementation of new database features and functionality

Well Expertise knowledge in GitLab

CI/CD configuration experience in GitLab and automatic deployment for PLSQL (DDL/DML)

End-to-End knowledge in Gitlab (Branching / Pipeline / Merge request)

Kumaran System Pvt LtdProject Name

PJ025845

Organization

Mphasis

Duration

20-Oct-2021 - 28-Feb-2022

Environment

JBoss Application Server-WebApplication Servers;Java Basics/Foundation;Oracle Apps DBA;Oracle EBS – OAF

Advanced Skills

Expertise in Oracle PLSQL, Procedures, Packages, Triggers and Oracle Query Tunning. Bulk upload using the merge query.

Description:

n Access Refresh with new terms based on upgrade or downgrade of orders.. and reordering the coding flow new Orders and change orders and billing process

Responsibilities:

n Requirement gathering from Client, Evaluate the Design and Coding, Development, Team Code Review,.

n Familiar in writing a Complex PLSQL Blocks like Procedures, Triggers, Packages, View, MV, DB_LINKS.

n Written a Merge Query to Move the Large number of data from one DB to another DB.

n Massive Data Import and Export using Oracle SQLDevelper tool.

n Good expertise in Oracle SYS Objects.

Project Name

PJ025752 WC3

Organization

Mphasis

Duration

02-Aug-2021 - 30-Sep-2021

Environment

JBoss Application Server-WebApplication Servers;Java Basics/Foundation;Oracle Apps DBA

Advanced Skills

Expertise in Oracle PLSQL, Procedures, Packages, Triggers and Oracle Query Tunning. Bulk upload using the merge query.

Description:

n Introduced new Product and implemented with Customer Account, Ordering, Inventories, contracts and billing.

Responsibilities:

n Familiar in writing a Complex PLSQL Blocks like Procedures, Triggers, Packages, View, MV, DB_LINKS.

n Written a Merge Query to Move the Large number of data from one to another region.

n Massive Data Import and Export using Oracle SQLDevelper tool.

n Having good experience in Databae design.

Project Name

PJ022373 WC6

Organization

Mphasis

Duration

01-Feb-2021 - 30-Jul-2021

Environment

JBoss Application Server-WebApplication Servers; Java Basics/Foundation;Oracle Apps DBA

Advanced Skills

Procedures, Packages, Triggers, Views and Oracle Query Tunning.

Description:

n Introduced new Product and implemented with Customer Account, Ordering, Inventories, contracts and billing.

Responsibilities:

n Requirement gathering from Client, Evaluate the Design and Coding, Development, Team Code Review,.

n PLSQL Development (Procedure, Packages, Triggers, Views and Oracle Query Tunning).

Project Name

PJ023219 WC5

Organization

Mphasis

Duration

01-Oct-2020 - 29-Jan-2021

Environment

JBoss Application Server-WebApplication Servers; Java Basics/Foundation;Oracle Apps DBA

Advanced Skills

Procedures, Packages, Triggers, Views and Oracle Query Tunning.

Description:

n Introduced new Product and implemented with Customer Account, Ordering, Inventories, contracts and billing.

Responsibilities:

n Requirement

n Gathering from Client, Evaluate the Design and Coding, Development, Team Code Review,.

n Testing .

n,Deployment and Leading the Project Implementation in production.

Project Name

PJ024314-WC1 <*****-***********-********-***@******.***>

Organization

Mphasis

Duration

22-Jan-2020 - 30-Sep-2020

Environment

JBoss Application Server-WebApplication Servers;Java Basics/Foundation;Oracle Apps DBA

Advanced Skills

Procedures, Packages, Triggers, Views and Oracle Query Tunning.

Description:

n Introduced new Product and implemented with Customer Account, Ordering, Inventories, contracts and billing.

Responsibilities:

n Requirement

n Gathering from Client, Evaluate the Design and Coding, Development, Team Code Review,.

n Testing .

n,Deployment and Leading the Project Implementation in production.

Project Name

PJ022384 WC4

Organization

Mphasis

Duration

01-May-2019 - 02-Dec-2019

Environment

Oracle Apps DBA

Advanced Skills

Procedures, Packages, Triggers, Views and Oracle Query Tunning.

Description:

n Access Term Functionality has been implemented with Customer Account, Ordering, Inventories, contracts and billing.

Responsibilities:

n Requirement

n Gathering from Client, Evaluate the Design and Coding, Development, Team Code Review,.

n Testing .

n,Deployment.

Project Name

PJ0223 WC1

Organization

Mphasis

Duration

31-Oct-2018 - 30-Apr-2019

Environment

Oracle Apps DBA

Advanced Skills

Procedures, Packages, Triggers, Views and Oracle Query Tunning.

Description:

n Access Term Functionality has been implemented with Customer Account, Ordering, Inventories, contracts and billing.

Responsibilities:

n Requirement

n Gathering from Client, Evaluate the Design and Coding, Development, Team Code Review,.

n Testing .

n,Deployment.

Project Name

PJ23733

Organization

Mphasis

Duration

02-Jul-2018 - 30-Oct-2018

Environment

Oracle Apps DBA

Advanced Skills

Procedures, Packages, Triggers, Views and Oracle Query Tunning.

Description:

n Smart UC, new Product Plan type added to the Customer Extract, which was input for Downstream application

Responsibilities:

n Requirement

n Gathering from Client, Evaluate the Design and Coding, Development, Team Code Review,.

n Testing .

n,Deployment.

Project Name

PJ020783-WC7

Organization

Mphasis

Duration

01-Oct-2017 - 01-Jun-2018

Environment

Oracle Apps DBA

Advanced Skills

Procedures, Packages, Triggers, Views and Oracle Query Tunning.

Description:

n Addind new Product component to the Existing Product Catalog.and adding new NonSpa Acess category and implementin g the same flow in Ordering and Billing

Responsibilities:

n Requirement

n Gathering from Client, Evaluate the Design and Coding, Development, Team Code Review,.

n Testing .

n,Deployment.

Project Name

PJ017932

Organization

Mphasis

Duration

16-Feb-2015 - 31-Jul-2017

Environment

Oracle Apps DBA

Advanced Skills

Procedures, Packages, Triggers, Views and Oracle Query Tunning.

Description:

n Billing and Ordering Application for Wireless Telecom Project for Sprint Account, This Project implementing the BEC Value for Billing and replace the BIC value with Respective BEC Billing Value

Responsibilities:

n Requirement

n Gathering from Client, Evaluate the Design and Coding, Development, Team Code Review,.

n Testing .

n,Deployment.

Project Name

#1

Organization

Coromandel Infotech pvt ltd

Duration

12-Dec-2007 - 04-Jun-2010

Environment

JBoss Application Server-WebApplication Servers;Java Basics/Foundation;Oracle Apps DBA

Advanced Skills

Procedures, Packages, Triggers, Views and Oracle Query Tunning.

Description:

n ERP Domain, Salary Processing for Manufacturing Company. Coding the ERP Application of Development and Documentation. Testing the application with zero defects

Responsibilities:

n Trainee Software Engineer Coding the ERP Application of Development and Documentation. Testing the application with zero defects

Project Name

#1

Organization

Kumaran Systems

Duration

-

Environment

Core Java;EJB3;J2EE;JNDI;Jboss Application Server-WebApplication Servers;Oracle Apps DBA

Description:

n Ticketing Soluton for Telecom Company "Bell", Location Canada

Responsibilities:

n Development, Code Review, Testing and Project Deliverable

Project Name

#1

Organization

Shriram Value Services

Duration

-

Environment

Core Java;J2EE;JNDI

Description:

n Chits Leagal System

Responsibilities:

n Development and Documentation

Personal Details

Date of Birth: 10-Dec-82

Sex: M

Contact No: +919*********

Location: Kansas, USA

Strengths: Java. J2EE / Oracle/ PLSQL

Interests:

Contact this candidate