Engineer Sql Server

RENJITH R

Mobile no.:+91-783*******

Email:

*********@****.***

Software Engineer

Profile

. 3 years of experience in software development using Microsoft .Net

Technology.

. Experience in Leading, Analysis, Design, Development, Testing of

Windows (Desktop) & Web (Client-server) multiple-tier applications

. Good hands in .NET 4.0 and 1.1, C# and VB.NET, ASP.NET, AJAX, WCF,

LINQ, SQL Server 2005-2008, Visual Studio 2010 Team foundation server

(TFS)

. Expertise in Banking, Infrastructure and IT domains.

. Good Knowledge of .Net fundamentals, .Net framework, CLR, CTS, .NET

application deployment

. Proficient on Window Forms, Windows services, Web Forms, ASP.Net Web

Services & WCF

. Database modeling, design, writing SQL queries, stored procedures and

Triggers

. Good Knowledge of Performance Tuning for SQL Server Queries and Stored

Procedures

. Experience in Reporting Services: Microsoft SQL Server and Reporting

Services

. Experience with Software Development Processes & Models: Agile,

Waterfall, RAD & Scrum Model

. Having good problem solving and analytical skills, highly motivated,

quick learner

. Establishing proper communication among the different delivery

locations.

. Mapping requirements; participating in the finalization of product

specifications and selection of appropriate technologies

. Experience in Testing web based applications/Database Testing using

SQL

. Provide follow-up on the status of issues and action plans.

. Ensure traceability is maintained from requirements to design to

implementation

. Ability to effectively communicate with tools team members.

Work Experience

Associated with HCL Technologies, Gurgaon as a "Specialist" since 18th

March 2014 to till date

Responsibilities

. Automation of Reports

. Worked as designer and senior programmer and analyzed user

specifications for workability, completeness and business flow

. Designed Web pages with ASP.NET.

. Designed databases and wrote Queries, Stored Procedures in SQL 2005

. Performed Coding/Programming tasks to specification and in accordance

with Development standards

. Documented and coding Technical artifacts and developed test plans

. Automation of Manual Processes

. Accountable to the Citi GUAT Tools Team manager for day to day

activities.

. Analyze business requirements.

. Create functional design documents.

. Document tools solutions developed.

. Ensure traceability is maintained from requirements to design to

implementation.

. Ability to effectively communicate with tools team members.

. Record time and effort spent on a daily basis.

. Attend all Citi GUAT Tools Team meetings.

. Understand Citi GUAT methodology and Tools inventory.

. Provide follow-up on the status of issues and action plans.

. Advise of functional and process improvements to existing tools.

. Identify report and escalate problems and issues related to test

tools.

Associated with Barclays Shared Services Pvt. Ltd. as a "Sr.Software

Engineer" since 10th Oct 2011 to 10th March 2014.

Responsibilities

. Working on web based portal in .net platform with TFS (Team Foundation

Server)

. Creating procedures, Enhancing database/table/query performance

. Taking requirement from clients and developing standalone application

. Developed standalone application in Excel VBA and Access

. Creating Test Scripts for Testing

. Performing Manual Testing on DEV, UAT and SIT environment

. Once the testing is done, fixing the bug on the basis of priority

. Experience in Testing web based applications/Database Testing using

SQL 2005

. Interacting with end users to get to know issue being faced in

application

. Being In-House project, we tries to improve portal's functionality,

visibility and performance

Projects:

1. Application Gateway: In this we manage employees from the day he/she

join Barclays as an employee and till the time he/she attrite. It contain

sub modules and they are as follows:

I. eStar: In this we manage employees with respect to data storage.

Employees are uploaded and managed (transferring to other manager,

referring to HR, Changing the hierarchy of business, marking overtime,

etc.) Reporting / Line Manager with the help of this module.

a. DCnG Module: Disciplinary, Capability and Grievances are managed

in this module. Managers could raise Disciplinary or Capability

cases against reportees. In Grievance, any employee within

Barclays can raise grievance against his/her manager or

colleague or employee within Barclays.

b. RHR Module: Whenever there is a capability issue against any

reporting employee, first an interview is scheduled with the HR.

For this, RHR module is used.

c. Overtime Management: Employees working for more than 9 hours a

day, he/she can mark overtime in this module. Overtime marked

must be approved by Line Manger.

d. Employee Transfer: There is always a change in employee

reporting or change in process of an employee. It is managed in

this module.

e. FnF (Full & Final): There are five departments who use to give

sign off to employee which states that, there is no due pending

from the side of employee who is leaving organization.

f. Employee Exit: After the process of department sign off, there

is an exit interview conducted with the HR. Once it is done,

employee is given final sign off by HR.

II. eTransport: This module helps users to mark their roster and make

themselves to avail cab for Pick up and drop from and to Office

III. CMS: In this module, employees who are not BSS employee but works for

Barclays are managed.

IV. Payroll: Employee's salary is managed through this module

V. VMS: In this module, visitors coming from Outside India or employees

from India but from different sites are managed

VI. Exception Tracker: It captures exception of employees like system

issues, cab delay etc.

. Technology Used : Asp.Net 4.0 using C#, SQL Server 2005

. Duration : Dec 2011 to March 2014

. Team Size : 10

. Position : Sr. Software Engineer

2. Automated Tools: Digital Cockpit- It tracks the production time of

employees. Employees are supposed to click on activities that they

perform in the tool.

. Technology Used : VBA, Access 2003

. Duration : Oct 2011 to March 2014

. Team Size : 1

. Position : Sr. Software Engineer

Associated with "MGF Mall Management" as a "IT Support Engineer" since 11

July 2011 to 3rd Oct 2011

Responsibilities

. Developing and maintaining in-house website

. Managing existing domains

. Fixing bugs in website

Education and Skills:

Course/Class Board/University Institute Passing Year Percentage

B. Tech (IT) Uttar Pradesh Dronacharya 2011 1st Division

Technical College of

University Engineering

12th C.B.S.E Delhi Kannada 2006 62.40%

School

10th C.B.S.E Kerala School 2004 66.40%

Technical Skill Set:

. Programming Languages: C#.Net, VB.Net, C, C++,

JavaScript, VB, PL/SQL, T-SQL, LINQ

. Microsoft Technologies : ASP.NET, WCF, ADO.NET, Win

Forms, WPF, WCF, AJAX 1.0,

Microsoft Office

2003, 2007 and 2010, Visual Studio Team System

. Web Technologies : HTML, DHTML, CSS, Java

Script, XML

. RDBMS & Tools : SQL Server 2005 and 2008,

MYSQL, MS Access, SQL Profiler

. Reporting Tools : Microsoft SQL Server

Reporting Services (SSRS)

. Version Control : Team Foundation Server

[TFS]

. Testing : Manual Testing on UAT,

SIT and DEV environment,

Creating

Testing Scripts, Test Design, Test Planning and Bug fixing

. Databases : SQL Server 2005, Access

Database 2003

. Other Tools : Macromedia, Quality

Center 10.0

Internships and Training:

. Had training from Entab Pvt. Ltd. (Okhla Industrial Area, Delhi) for 6

weeks on Server Installation. Worked on database creation, server

maintenance and maintenance of Institutional Management Software.

. Went through 6 weeks training in MTNL (Delhi). Learning the concept

and working of the IVRS server in detail, including the Print Screens

and the Reports. Networking Concepts and the working of the CSMS

server and FRS server in detail

. Have 6 (six) months training experience in PHP/mySQL technology from

Ducat (Noida).

Personal Information:

Date of Birth : 4th Sep, 1987

Gender : Male

Father name : Shri. Rajan K

Marital Status : Married

Languages : English, Hindi & Malayalam

Address : Flat no: 111D, Pocket: A2,

Mayur Vihar, Phase-III,

Delhi-110096, India

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.

Date:

Place:

(RENJITH R.)

Contact this candidate