Sql Software Developer

KALPANA R

E-mail - *************@****.***

Mobile - +91-890*******

Objective:

To be employed in a firm where I can put my technical skills to use in enhancing the Oracle database systems and in developing software that will be boost the company’s productivity.

Experience Summary

4.5 years of experience in software development - SQL/PLSQL, OBRM-Testing.

Strong in SQL/PLSQL, Unix Shell Scripting.

Maintain batch jobs, billing jobs, backend queries, backend scripts

Solid grounding in designing User Interface.

Involved in BRM unit testing

Developed SQL queries, Functions and MIS Report Designing.

Improved performance and stability of database systems. Created PL/SQL scripts.

Educational Qualification:

B.Tech in Information Technology (2011) from Dhanalakhsmi college of Engineering with 67% Marks.

Diploma in computer science and Engineering (2008) from Govt.Polytechnic college for women with 80% Marks

+2 with Maths-Biology, Stats (2005) from sacred Heart Girls Higher Secondary School with 57% Marks

10th (2003) from sacred Heart Girls Higher Secondary School with 91% Marks

Employment:

Organization : Sun direct Tv Pvt ltd

Location : Chennai

Designation : Software Developer

Working From : Aug 2011 to Till Date

Automation Reports Details:

Mentioned reports created using Pl/sql and Unix shell scripting.

Activation and Deactivation Report

Used voucher data

OSD and Bmail

Carriage fee Report

Recharge details

Renewal Report

Next month Base Report

Osd and Bmail Automation

Professional Summary:

Over 4.5 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

Created Tables, Views, Constraints

Loaded Data into Oracle Tables using SQL Loader.

Partitioned large Tables using range partition technique.

Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.

Good understanding of Oracle data dictionary and normalization

techniques. Experienced in Oracle 11g/10g systems. set up backups,

export and other monitoring scripts.

Proficient at working as a team player with an aim of contributing

towards the team's success. Involved in unit testing and documented the same.

Responsibilities:

Developed SQL queries, Functions and MIS Report Designing.

Developed Perl scripts, Shell scripts in UNIX.

Analyze and Implement the DTH requirements.

Involved in Create, Edit and Automation the Cronjobs in UNIX using shell scripts.

Voucher administration- for generating new vouchers.

Issue tracking and BRM unit Testing.

Worked in Production Support Environment

Maintained the documents and create reports for the end-users.

Understand the Business requirement as well as given specification.

Involved in design of the database, which includes, table design and their relations.

Involved in all Unix System Production Support by trouble shooting customers urgent requests.

Monitored/ alerted and corrected routine and complex technical issues using Oracle/shell.

Design and implement scripts (shell/PL-SQL) for production revenue impacting issues.

Contribute to automation efforts.

Draft shell scripts and PL/SQL scripts to resolve user acceptance testing and production defects.

Create and execute validation and production support scripts for custom components. Documents, review, and execute performance tuning scripts.

Technical skills:

Oracle

PL/SQL, SQL,Data Exports & Imports,Software Maintenance, User & Security Management, Query Optimization, Export/Import Utilities

Databases

Oracle 11g/10g

Programming

SQL, PL/SQL, Unix Shell Scripting

Environment

Windows 2008/2000, Windows 98/NT/2000/XP, Unix Sun Solaris,TOAD 9.6, SQL*Loader, Sql Developer.

Web Server

Weblogic 10.3.

Personality Traits

Strong motivational and leadership skills.

Excellent programming skills.

Ability to handle the pressure situation.

Personal Details

D.O.B : 01.05.1988

Gender : Female

Marital status : Married

Nationality : Indian

Languages Known : Tamil,English

Address : Plot No 3 TTK nagar Pozhichalur Chennai-74

Declaration:

I hereby declare that the above-mentioned information is correct up to my knowledge and I bear the responsibility for the correctness of the above-mentioned particulars.

Place :

Date : KALPANA.R

Contact this candidate