Resume

Sign in

Developer Engineer

Location:
Chennai, Tamil Nadu, 600100, India
Posted:
August 18, 2018

Contact this candidate

Resume:

RUTHRA MOORTHI. M

+91-960******* [Oracle SQL, PL/SQL, Core Java] ac6p21@r.postjobfree.com

CAREER OBJECTIVE

To work in a highly challenging position in Oracle Database Development where I can apply knowledge, creative ideas and continuous learning in Advanced Database System

PROFESSIONAL SUMMARY

Having 4.2 years of work experience in Core Java, PL/SQL, Oracle D2K and 11g Development

Having hands on experience in Development, Maintenance and Support of business applications using Oracle SQL, PL/SQL and 10gR2 -Forms & Reports

Strong knowledge of Software Development Life Cycle (SDLC)

Experience in Collections and Interfaces in Java

Experience in Oracle supplied Packages, Dynamic SQL, PL/SQL Tables and Records

Experience in processing large volume of data using BULK COLLECT

Experience in analytical functions and aggregate functions, bulk collection and ref cursor

Experience in SQL Performance Tuning using Cost Based Optimization

Highly self-motivated and versatile team player with excellent Analytical Debugging and Interpersonal skills

Knowledge of Forms migration 6i to 10g and 6i to 11g

Knowledge of Oracle Application Express(Apex) and Oracle Data Integrator(ODI)

Knowledge of Oracle Business Intelligence Publisher(OBIP)

Domain: Airline Passenger and Cargo, Travel Transport Logistic and Resource Management

WORK EXPERIENCE

Technology Analyst in EdgeVerve Systems Limited (6 Months), Bangalore

Engineer in Robert Bosch Engineering and Business Solutions (10 Months), Bangalore

Software Engineer in NIIT Technologies (2.10 Years), Bangalore

Junior Developer in NIIT Technologies (6 Months Internship), Bangalore

TECHNICAL SKILLS

Programming Languages : ORACLE SQL, PL/SQL, Core Java, Pro*C

GUI : Oracle Forms and Reports 11g, Oracle BI Publisher

Web Server : Oracle Application Server (OAS) 10gAS

Databases : ORACLE 11g, 10gR2, 6i

Scripting : JavaScript, Basic knowledge of Unix Shell scripting

Tools & Utilities : PL/SQL Developer 11.0, Oracle SQL Developer 4.0, HP-ALM, SMT

Version Control : Tortoise SVN

Operating Systems : Windows XP, Windows 7, UNIX HP-UX

PROJECT DETAILS

Project Name : Wealth Management System (WMS)

Duration : April-2016 to October-2016

Technology : Oracle 11g

Role : PL/SQL Developer

Responsibilities:

Developing PL/SQL (Packages, Stored Procedures, Functions, Views, Triggers) for implementing complex business logic as per the requirements

Developing JASPER reports using iReport tool

Optimizing packages and tuning high load SQL query

Customizing applications and implementing new functionality

Preparing test cases, test data and impact analysis

Project Name : Manage Cost and Resource (MCR)

Duration : May-2015 to Feb-2016

Technology : Oracle 11g

Role : PL/SQL Developer

MCR is a Web Based application developed to maintain cost and resource planning for upcoming eight years in Business Unit. This solution helps to the business to improving efficiency and productivity.

Responsibilities:

Coordinating with Business Intelligent and SAP development team to involving in development phase and testing using Oracle SQL and PL/SQL

Developing PL/SQL (Packages, Stored Procedures, Functions, Views, Triggers) for implementing complex business logic as per the requirements from Forms Developer

Writing Complex Views to provide information to SAP System

Optimizing high load SQL query

Processing large volume of data using BULK COLLECT and FORALL

Project Name : Cargo Operation System (COSYS)

Duration : July-2012 to April -2015

Technology : Oracle 10g and 6i

Role : PL/SQL Developer and Oracle Forms Developer

A Web Based application developed to facilitate the air cargo process in different locations across India. In general, this application automates the data and work flow process of the entire cargo operations of both International and Domestic.

Responsibilities:

Developing various Forms using oracle Forms 10g depending on the requirement

Create and customize analytical reports for existing system using Reports 10g

Developing Server side PL/SQL (Stored Procedures, Functions, Triggers & Packages) for implementing complex business logic

Create PDF and Excel report based on user requirements

Coordinating with other development team (EDI, Java and .Net) for providing database information and involving in development phase and testing

Successfully implemented the following modules: EDI Message Search, Invoice Process, Privileged End User Management, Cancel Shipments and Revive Shipments

Project Name : SITA Reservation System

Duration : January-2012 to June-2012

Technology : Oracle 10g

Role : PL/SQL Developer

Responsibilities:

Implemented new functionalities in SITA Air-Fare module

Providing Invoice reports (PDF and Excel) on daily and monthly basis to client account department

Providing analytical reports to verify the business process flow

Bug fixing and root cause analysis

EDUCATIONAL QUALIFICTION

Master of Computer Applications (2009-2012), Kongu Engineering College (Autonomous Institution affiliated to Anna University of Technology, Coimbatore) with 7.26 CGPA

Bachelor of Science (Computer Science 2006-2009), Gobi Arts & Science College (Autonomous Institution affiliated to Bharathiar University, Coimbatore) with 7.02 CGPA

Higher School Examination (2005-2006), Tamil Nadu State Board with 76.0 %

Secondary School Leaving Certificate (2003-2004), Tamil Nadu State Board with 76.5 %

PERSONAL PROFILE

Date of Birth : 26-Feb-1989

Languages known : English and Tamil

Passport Number : J8589069 Valid till 2022



Contact this candidate