Sql Server Project

Curriculum Vitae

Raja Rajeswari Mobile: +91-904*******

***, ************, ***************,, ***** : ***************@*****.***

Mangainallur (po), Kuthalam (TK),

Nagapattinam (DT),

Career Objective:

To get a challenging position where I can put all my experience and knowledge to give a significant growth to the organization.

Profile Summary

A logical, analytical thinker with excellent managerial skills possesses 3+ experiences as a Database Developer. Including 1+year of SQL Developer in MS SQL server 2008 R2

Current company : First Source solution limited, Chennai, India

Working experience in developing Joins, stored procedures, functions, Indexes, Views, CTE's, triggers, Cursors and temporary tables.

Analyzing of SQL Queries to improve the performance and minimize the execution time.

Working experience in developing T-SQL Queries.

Working experience in Excel formulae, Vlookup, Hlookup and pivot table.

Good team player with excellent skills and ability to work with a team and in an individual environment.

Skills Summary:

Operating systems : Windows XP

Languages : C, C++, Core java, C# .net

Databases : MS-SQL server 2005 & 2008R2, MS-Access 2003 & 2007

Key Achievements:

-Direct Communication between the Clients.

-Doing Estimation for the Project.

-Familiar with Store Procedures development methodology.

Description:

Automate Excel macro for data insertion in the front end using Stored procedures. Writing queries for the functionality provided by the functional team includes Dynamic query, stored procedures, functions, CTE's, triggers, Cursors, temporary tables and According to client requirement write SP implement in process.

Roles & Responsibilities:

Tracing error statements using SQL server profiler

Writing coding using MS SQL server 2008 R2 for the functionality provided by the functional team includes Dynamic query, stored procedures, functions, CTE's, triggers, Cursors, temporary tables etc.

According to client requirement write SP implement in process and automate.

Understand client problems and provide appropriate technical solutions.

Debugging Errors in stored procedures based on the functionality given by testing team.

EMPLOYEMENT DETAILS

First Source solution limited, Chennai, India

SQL Developer – Senior Process Associate.

March 2016 – TILL_NOW

Project #1

New Activation E-bill penetration for Precall Announcement – Airtel

Technology : MS-SQL server 2008R2, MS-Access 2003 & 2007.

Team Size : 2

Duration : Mar 24 to till date

Description:

New activation E-bill penetration is the overall performance of telecommunication network, particularly the performance seen by the newly activation of the network. Here overall billing customers of the telecom service provider are getting into a single dump. In this dump, the total number of newly activation customers is given with full details by circle wise. These are analyzed under some criteria and produce the result based on the overall activated customers and partitioned by ebill or paperless customers alone. Then this Result is sent to Telecom Regulatory Authority of India (TRAI) for confirming the penetrating the ebill process to the user.

Roles & Responsibilities:

Plan, design, and implement application database code objects, such as stored procedures, indexes, views and joins.

Improving the process by identifying new automations and reduce cycle time of reports.

Maintain indexes, complex queries for data analysis and extraction.

Understand client problems and provide appropriate technical solutions.

Participate in cross-functional meetings to resolve recurring customer issues.

Project #2

OBD (Outbound Dialer) – Airtel

Technology : MS-SQL server 2008R2, MS-Access 2003 & 2007.

Team Size : 2

Duration : Mar 24 to till date

Description:

OBD Dashboard report is to find the overall newly activated customers of telecommunication network in overall circle, particularly seen by the segment wise and circle wise and will show the newly activation of the network. Here overall customers of the telecom service provider are getting into a single dump. In this dump, the total number of newly activation customers is given with full details by circle wise. These are analyzed under some criteria and produce the result based on the overall activated customers (newly sim buyers, portability). Then this Result is sent to Telecom Regulatory Authority of India (TRAI) for confirming the penetrating the ebill process to the user.

Roles & Responsibilities:

Analyzing of SQL Queries to improve the performance and minimizing execution.

Perform data analysis for generating reports on periodic basis.

Provide strong reporting and analytical information support to management team.

Generate both periodic and ad hoc reports as needed.

Tamilnadu Software College, Mayiladuthurai,

.NET with SQL&COREJAVA Programmer

Jan-2014 to Feb- 2016.

Project #1

Automation Of Textile Management System

Technology : MS Visual studio 2005 & MS-SQL server 2005.

Team Size : 2

Duration : Jan-2014 to Feb- 2016.

Description:

The project titled “TEXTILE MANAGEMENT SYSTEM” is designed with the motive of maintaining all the databases of the concern. The basic aim of the project is to develop a system, which is very simple, user friendly, easy retrieval and simple access. The project has been developed using ASP.NET as front end and SQL SERVER 2005 as back end. This company deals with production of textile goods. This project aims at to monitor all process in the company, like order receiving, sampling, purchase of raw materials, production of goods, shipment and bills. As these works are done manually at the company at present it takes a lot of time to complete the work. The main goal of this project is to reduce manual works, increase the processing speed and ensure reliability of data. All process needed for the textile management is recorded for providing good information to the concern. Various reports are generated based on the requirement. Reports will present the management with the current position of the company.

The project comprises eight departments such as Order Receiving, Sampling Purchase, Processing, Production, Warehousing, Shipment and Billing.

Responsibilities

Translate application storyboards and use cases into functional applications

Design, build, and maintain efficient, reusable, and reliable C# code

Ensure the best possible performance, quality, and responsiveness of applications

Identify bottlenecks and bugs, and devise solutions to these problems

Help maintain code quality, organization, and automatization.

Education Details

Mater of Computer Application with 81% in the year of 2013 @A.V.C College of engineering Mayiladuthurai.

Bachelor of Information Technology with 62% in the year of 2010@ Dharmapuram Adhinam Arts And Science College-Mayiladuthurai.

Higher Secondary Examination – 2007 with 69% @ Govt.Hr.Sec.School, Peralam.

Secondary School Leaving Certificate–2005 with 81%@K.S.O High School Mangainallur. .

Personal Details

Name : Raja rajeswari S

Date of Birth : 24-Sep-1989

Gender : Female

Nationality : Indian

Languages Known : Tamil, English (Read, Write and Speak)

Declaration

I hereby declare that, the above furnished information is true to the best of my knowledge and belief.

Date :

Place : Chennai (Raja rajeswari S)

Contact this candidate