Sql Server Software Engineer

Soumya Palliyath

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

Mob:860-***-****

Manchester -CT

Summary Soumya is a software engineer with 2 years of experience

in SQL server development and .NET application production

support; currently supporting multiple ASP.NET Web

Applications and maintaining complex financial online

transactional databases. Soumya has got hands on

experience in solving technical production issues,

database customizations and performance optimizations and

creating reports using SSRS.

Skills SQL Server 2005, 2008

T-SQL

SQL Server Reporting Services

SQL Server Tuning Advisor

SQL Server Profiler

SQL Server Replication

ASP.NET, C# and HTML

Manual Testing

Achievements Achieved best employee award during November 2012.

Stellar award of rising star for the year 2012.

Toper in the client satisfaction survey result through

out the financial year 2012.

Professional Accenture Services Pvt. Ltd. (18/01/2011- Till date)

Experience Project Name: Document Flow Management

Start Date: 18/01/2011 End Date: Till date

Job Title: Software Engineer

Description: Document Flow Management (DFM) is a

financial web application with complex query, workflow

and approval functionalities developed in ASP.net. DFM

receive documents from the scanning location through

secured FTP and then process it through Sorting, Data

Entry, then Query or Approval flow to complete the

workflow of the document. DFM got an online transactional

reporting module developed in SSRS and there are 20

reports and 2 of them are scheduled nightly reports.

Database is hosted in SQL Server 2005.

Responsibilities:

Production support for multiple critical web applications

and key online transactional databases.

Create cusome SQL queries for resolving technical issues

in database.

Perform production data correction with the help

analytical T-SQL queries.

Analyse the T-SQL statements in production environment

with the help of SQL Server Profiler.

Database backup and restore from production to staging

environment.

Database log purging and maintenance activities.

SQL Server replication for reporting purpose.

Create custom reports using SQL Server Reporting

services.

Analyse and resolve technical issues in reports.

Suggest the optimal set of indexes with the help of SQL

Server Tuning Advisor.

Track the status of the incidents and follow up with the

concerned department to its closure.

Monitor end to end flow of invoices from scanning till it

reaches PRT

Academics 1. Network Intrusion Detection System

Projects Course: BSc

Network Intrusion Detection System traces out the

intruder packets using IP address or data and decides if

it is to be forwarded and assures security. If the packet

is found to be an intruder it is then forwarded to the

firewall with the respective message for blocking. It

also prevents malevolent hackers from accessing

information from the network.

Technologies : C#

2. Smart X Web

Course: MCA

Smart X Web is software that allows users to access

devices connected to their systems from remote locations.

Once the software is installed on the home pc then the

user can access the devices connected to the system from

any location using our website through the Internet

Technologies : ASP.NET, C#

Education Course

Institute

Board/University

Year

Aggregate

MCA

MES College of Engineering, Kuttippuram

Calicut University, India

2005-2008

76.4%

B.Sc. Computer Science

College of applied science, Pattuvam

Kannur University, India

2002-2005

75.9%

Personal

Details Date of Birth

17-11-1984

Hobbies

Gardening, Listening Music, Cooking

Languages

English, Malayalam

Marital Status

Married

Type of Visa

L2

Work Permit

EAD

EAD Valid for

15/02/2013 to 15/02/2015

Visa Valid Till

11/06/2015

Address 39 Buckland Street,

Apt- 5323,

Manchester,

Cunnecticut - 06042

Contact this candidate