Sql Software Engineer

Sumathi R

Mobile: +91-996*******

Email Id: ********.*******@*****.***

SUMMARY

3+ years of progressive IT development/support experience.

Strong skills include Oracle 10g SQL, PL/SQL, Unix Shell Scripting.

Exposure writing SQL Queries.

Experience Using PL/SQL Collections, Ref Cursor, Bulk collect.

Create Stored Procedures, Packages, Triggers, Views and Indexes, and knowledge in Oracle cursor management and exception handling.

Interaction with co-workers and users to high level of service provided to company/customer.

Handled projects individually from front-end user interface design, to back-end relational database design and development.

Involved in development of the applications through Oracle using Pl/SQL created Tables, cursors and SQL Queries.

Understanding the requirements and carrying out impact analysis documents.

Involved in fixing Production issues.

Ability to work in 24x7 environments, preparing root cause analysis and ensuring the action points.

Exposure to version control tools, and good team player.

WORK EXPERIENCE:

Working for S.I Systems as Software Engineer, April 2009 to till date

PROJECT SUMMARY:

Expense Tracking System

Client: HSBC Bank, US.

Duration: August 2011 to till date

This project is mainly involved to provide the client with robust software that generates around 60 customized reports, which will either be used by the bank for their internal purposes, or be sent to their headquarters in New York. These reports will be generated based on the data available in their seven Departments and 180 Cost Centres spread across 13 countries.

Environment: Oracle 10g, PL/SQL, Java, UNIX Shell Scripting, TOAD, SQL Developer, OOAD, Rational Rose, SQL PLUS

Roles &Responsibilities:

As a Programmer as involved in the following

Interacted with clients to understand their requirements.

Involved in table design.

Programmed Packages, stored procedures, queries, and triggers on 10g.

Database Query tuning and Implementation.

Communicated with the clients for issues updates in status call meeting.

Unit and System Testing.

Involved in resolving production problems for the applications and Ensure all support service level agreements are met.

ATLAS-RDC Automation

Client: Target Corporation, US

Duration: June 2010 to August 2011

Target Corporation uses 3D Application to handle the Distribution Activities. The 3D currently handles the inbound schedules of product, shipments from vendors/carriers, and the receipt of products into the DC. 3D Vision system is used at the distribution centers for efficient storage and handling of merchandise. As part of the enhancements, 3D is partially automated by SWISSLOG in Regional Distribution Centers to improve productivity.

Roles & Responsibilities:

Preparation of High level and Low level design

Study and documentation of the existing system.

Coding and Development

Unit test case preparation and Unit testing

Coordination with Onsite team.

Support for the current running project.

Environment: Oracle 10g, PL/SQL, UNIX Shell Scripting, TOAD, JAVA, SQL Developer, SQL Plus.

Fast Repair

Client: T&C Manufacturing, UK

Duration: April 2009 to May 2010

T&C Manufacturing Co. Pvt Ltd is an engineering, manufacturing and distribution company in Singapore and Japan

Fast Repair is a Customer Relationship Management Tool used by the T&C Call centres in Singapore and Jamaica to log calls for the defects faced by the customers using JJ machines and keep track of the customer logs. Fast Repair has various functionalities like Remote Call Assistance, Onsite, Second Level Log, T and M Override, Service Rates, Non-Technical Solutions and Customer Information. Fast Repair SA is deployed in three Production Environments.

SS application is an add-on application to Fast Repair I SA system. SS is used with Fast Repair for service contract look up for a serial number.

Roles & Responsibilities:

Designing and preparation of design documents.

Database Query tuning and Implementation.

Created Procedures, Triggers, Functions and Packages.

Understanding the requirements and carrying out impact analysis.

Code Walk Through, Review and Testing.

Development & System testing.

Solving ITT Tickets. Bug Fixing.

UAT and Live support.

Coordinate with the team.

Environment: Oracle 10g, UNIX Shell Scripting, PL/SQL, TOAD, JAVA, SQL Developer, SQL Plus.

TECHNICAL SKILLS:

Oracle -SQL

PL/SQL

UNIX shell scripting

ACADEMIC:

B.E (ECE) from Velalar College of Engineering and Technology passed with 68%.

PERSONAL DETAILS:

Date of Birth : 25-01-1984

Marital Status : Single

Languages Known : English, Tamil

Nationality : Indian

Passport No : G0052550

DECLARATION:

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

Place:

Date:

(Sumathi R)

Contact this candidate