Prem Rekha

Cell: +973******** Email:acs52y@r.postjobfree.com

Career Objective

A position in IT and IT enabled services providing the opportunity to make strong contribution to organizational goals through continued development of professional skills with a strong emphasis in challenging technologies and do challenging jobs producing exclamatory results.

Professional Summary

Around 8+ years of software development experience. (Oracle-SQL, PL/SQL).

Experience in Ports, HRMS and Telecom Sales Domain.

Developed modularized application with database using packages, procedures, functions, triggers, collections and cursors.

Experience in query optimization, performance and tuning.

Experience in software tools: TOAD, SQL Developer, PL/SQL Developer

Exposure to all phases in Software Development Life Cycle (Waterfall model and Agile).

Works effectively with Development Team, Product Support Team and with Client.

Experience Summary

Organization : DP World, Dubai

Designation : Oracle Consultant

Duration : Sep 2012 to Sep 2015

Organization : Tech Mahindra, Bangalore

Designation : Senior Technical Associate

Duration : July 2010 to Apr 2012

Organization : IGate Patni Global Solutions, Bangalore

Designation : Senior Software Engineer

Duration : Jan 2007 to July 2010

Organization : Synova Innovative Technologies Pvt. Ltd, Bangalore

Contract for : IBM India Pvt. Ltd

Designation : Software Engineer

Duration : July2006 to Dec 2006

Organization : Linova Info Pvt. Ltd, Bangalore

Designation : PL/SQL Developer

Duration : Jan 2004 to July 2006

Academic Profile

M.Sc. (Information Systems), Mangalore University- 2003

IT Acquaintance

Operating Systems : UNIX, MS Windows- 98, 2000, XP

Programming Languages : SQL, PL/SQL

RDBMS Packages : Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i

Software Tools : Toad, PL /SQL Developer, SQL Developer

Interpersonal Skills

Ownership, patience and hard work

Excellence in team work

Good communication skills

Excellent analytical skill

Project Profile

Project #1: Rostima Labour Management System

Organization : DP World, Dubai

Client Name : Staff Control Dept, DP World

Project Duration : Sep 2012 – Sep 2015

Technologies used : Oracle 11g, 10g, PL/SQL

Description:

Rostima is a product with automation on roster maintenance and Employee management. It is integrated with HRMS to get latest updates of employee status. Time And Attendance module in Rostima schedules the shifts of the employees, keeps track of the shifts of the employee, in time and out timing, hours worked, and leave management.

Individual Contribution:

*Interacted with business users to gather and analyze business requirements.

*Prepared technical specification.

*Involved in development of HRMS Integration.

*Developed PL/SQL packages, functions, procedures.

*Tuning the queries.

*To support the application on all DB issues.

*Analysis and debugging of complex packages/procedures and writing SQL queries.

Achievements:

Received appreciation for integration of HRMS module with Rostima.

Project #2: Berthing Planner Application

.

Organization : DP World, Dubai

Client Name : Berth Control Dept, DP World

Project Duration : Jul 2013 – Sep 2015

Technologies used : Oracle 11g, Oracle10g, PL/SQL

Berth Planning Application is developed as in house product and can configure terminals, yard blocks and berths. It facilitates planning of the berth for incoming and outgoing vessels calculating the time of berthing based on arrival and departure of the vessels. It schedules the cranes for the berthed vessels. The system shows the moves of containers done by the crane on each vessel in operation.

Individual Contribution:

* Interacted with business users to analyze and gather requirements

*Involved in Data base design and development of BPA application.

*Developed PL/SQL packages, functions, procedures.

*Used collections for query optimization.

*To support the application on all DB issues.

*Involved in optimization of SQL queries for optimal and maximal performance.

Project #3: Remote Tally Information Systems

Organization : DP World, Dubai

Client Name : Tally Clerks, DP World

Project Duration : Jul 2013 – Sep 2015

Technologies used : Oracle 11g, Oracle 10g,PL/SQL

Description:

RTIS system would take care of assigning the jobs to tally clerks as soon as a move is confirmed by OPUS TOS and Milestone has captured the video clippings for the same. After assigning the job, tally clerk needs to either pass the verification or manage the exceptions and send to PROMIS and OPUS TOS systems. A simple and smart tech savvy solution to assist labour pooling in a well tracked, efficient and optimized manner.

Individual Contribution:

*Involved in Data base design and development of RTIS application.

*Developed PL/SQL packages, functions, procedures.

*To support the application on all DB issues.

*Tuning the queries.

Project #4: APE – Access Pricing Engine

Organization : Tech Mahindra, Bangalore

Client Name : British Telecom, U.K.

Project Duration : Jul 2010 – till date

Technologies used : Oracle 10g, PL/SQL

Description:

APE is a web-based application used by the BT Sales team to request Access line prices for various BT products. The user submits a request with the site, product and speed information and if the pricing information for those details is available in the database, the price is generated automatically either in the form of a quick quote or a full price quote.

If the pricing information is not available in the database, the user is given an option to submit the request to the Access Front Line staff. Then the Front Line staff processes the request manually and the quote is presented to the user.

Individual Contribution:

*To develop PL/SQL packages, functions, procedures and triggers.

*Part of 3LS team in defect fix and resolving production DB issues.

*Supporting the team for all ad-hoc DB activities.

*Analysis and debugging of complex packages/procedures and writing SQL queries.

*Knowledge in SQL tuning with indexes and toad profiler.

Achievements:

Valuable Team Player Award for key performer and excellence in team work contribution.

Project #5: eComp(Development)

Organization : iGate Patni Global Solutions, Bangalore

Client Name : GE Corporate, U.S.

Project Duration : Jan 2007 - Apr 2010

Technologies used : Oracle 9i, Oracle 10g

Description:

eComp is an application to plan compensation details for the client employees. In this project the ratings for the employees which has been fed into eComp manually from other application, Myorg, was integrated and the process is automated. A batch job will be run daily to insert the ratings details from Myorg application to eComp database. The eComp user can then choose ratings from Myorg or can plan his own rating and compensation details. The users will be able to track the rating details which have been planned for employees. A separate report is captured for the rating details of each employee.

Individual Contribution:

*Involved in development and Production Support.

*Involved in the Impact analysis and design phase.

*Developed PL/SQL modules.

*Done Peer Review and created unit test cases.

*Done Configuration management activities in VSS and SVN

Achievements:

R& R award for individual contribution to the team.

Project #6: eComp(Production Support)

Organization : iGate Patni Global Solutions,Bangalore

Client Name : GE Corporate, U.S.

Project Duration : Oct 2007 - Apr 2008

Technologies used : Oracle 9i, Oracle 10g

Description:

The planning cycle starts from Oct-March every year to plan Compensation for the employees. A ticket will be raised for technical issues during planning.

Individual Contribution:

*Interaction with the client.

*Attending status call.

*Debugging and bug fixing.

*Tracking the closure of the tickets.

*Releasing small enhancements

*Giving KT to new members in the team.

Project #7: INOSS-Intelligent Network Operational Support System

Organization : IBM India Pvt. Ltd, Bangalore

Client Name : Telstra, Australia

Project Duration : Jul 2006 – Dec 2006

Technologies used : Oracle 9i

Operating System : Unix

Description:

Intelligent Network Operational Support System (INOSS) is a windows application that provides the user with the ability to manage the activation process of all Telstra’s identified Inbound Products, which are supported by the Alcatel IN Network Platform. INOSS allows the user to record Customer details, set up a new IN Service (Inbound, Infocall, IVR and CTI), and make changes to an existing IN Service, identify the current stage of any job created within INOSS for an activation process and produce reports and monitor the activation process.

Individual Contribution:

*Developed PL/SQL modules.

*Created unit test cases.

*Done Integration testing.

Project #8: Power Management System

Organization : Linova Info Pvt. Limited

Client Name : Ramco, India

Project Duration : Feb 2006 – May 2006

Technologies used : Oracle 9i

Description:

This software is developed to automate the operations in Manufacturing, Stores, Purchase and Quality Control departments to bring efficiency in day-to-day activities of these departments. The software provides monitoring the work order, maintaining the status of inventory, evaluation of stock, processing of payments, inspection and testing and generates various kinds of reports.

Individual Contribution

*Writing queries for DB testing.

*Created Unit test cases.

*Done Integration testing.

Personal Profile

Marital Status : Married

Nationality : Indian

Visa Status : Residence Visa

Languages Known : English, Malayalam, Kannada and Hindi.

Passport No. : G 0714328

Declaration

I do hereby declare that the particulars of information and facts stated above are true and complete to the best of my knowledge and belief.

Contact this candidate