Sql Server Software Engineer

GAURAV KUMAR SINGHANIA

Flat No. B****, Nagarjuna Maple Heights, Survey No. 182 & 183,

K.R.Puram - Marathahalli Outer Ring Road, B. Narayanpura, Mahadevpura Post,

Bangalore - 560016, Karnataka, India

+91-99-165*-**** ( ******.*********@*****.***

EXPERIENCE SUMMARY:

Processware Systems Pvt. Ltd.

From: July 2011 || Till: Today

Designation: Software Engineer

As a Software Engineer working on .Net Technology (C#, SQL server2008) in

Banking Domain my experience summary is as

stated below:

Technical Experience

. Development of Web-Based application (on ASP.NET C#) - CBS

application of Processware Systems

. Expertise in writing stored procedures and Triggers in SQL server

2005 and SQL server 2008

. Expertise in building ASP.NET Web Applications with Ajax

components.

. Worked on VS 2005 and currently working VS 2008 and on .Net

Framework 3.5

. Having sound knowledge in using Web Services.

. Worked extensively with Data Adapter, Dataset, Data reader as a

part of ADO.NET to access and update database.

. Having sound knowledge on Data Conversion and Data Migration.

. Having exposure in Visual Source Safe (VSS) 6.0

. Having knowledge of CSS (Cascading Style Sheets)

Implementation Experience

. Implemented CBS application of Processware Systems in RBI's Urban

Co-operative Bank (UCBs) across Karnataka.

Domain Experience

. Knowledge of various modules of Banking Domain namely Loans,

Payments, Limits, Liquidity & Cash Management, Financial

Accounting, Customer & Account Management.

. Understanding user requirements, mapping them to system

requirements and incorporating changes in the software product.

. Scripting of "User Manual" for the development work undertaken.

TECHNICAL SKILLS:

PROJECT ROLE: Design, Development, Testing,

Implementation

LANGUAGE: C#, ASP.Net, JavaScript, Jquery, XML, Ajax

Components

DATABASE: MS-SQL Server 2005/08

DEVELOPMENT TOOLS: Visual Source Safe 6.0

EDUCATION: Siliguri Institute of Technology, W.B.U.T

Siliguri, West Bengal

Master of Computer Application (MCA),

Aggregate: 82.30% (8.23 pointers), June' 2011

Majors: Computer Architecture, C, C++, Data Structure,

Java,

Networking, OS, UNIX, Artificial Intelligence, DBMS,

Graphics,

Software Engineering, Visual Basic, Distributed Database

Umesh Chandra College, Calcutta University

Kolkata, West Bengal

Bachelors of Commerce (Honours), June' 2007

Rank / Position: 2nd Class

Subjects: English, Advanced Accountancy, Corporate

Accountancy,

Management Accounting, Business Mathematics & Statistics,

Tax, Costing

The Assembly of God Church School, CBSE Board

Purulia, West Bengal

Senior Secondary, June' 2004

Aggregate: 71%

Subjects: Accountancy, Mathematics, Economics,

Business Studies, English, Information Practices.

The Assembly of God Church School, CBSE Board

Purulia, West Bengal

Secondary, June' 2002

Aggregate: 78%

Subjects: Accountancy, Mathematics, Science, English,

Hindi.

PROJECTS:

Project #1

CoreBanking Solution for Karnataka urban and Non Urban Cooperative Banks

|Core Banking Solution |

|Client |Product |

|Environment |ASP.NET, C#, Ajax, Javascript, Visual Studio 2008|

|Database |MS-SQL Server 2008 |

|Role |SE |

|Team Size |8 |

|Duration |(From Jul-2011 to Till Date) |

|Responsibilities |Design and Development of Transaction, |

| |Authorization, Budget, Day Process Module. |

| |Information Gathering |

| |Involved in Development |

| |Creating Stored Procedures for various module |

| |Creating Triggers for many transaction processes |

| |Query tune Up in SQL server 2005 and SQL server |

| |2008 |

| |Core Banking Deployment in IIS 7.0 |

| |Supporting Clients. |

|Description: The objective of Core Banking Solution application is to |

|provide user-friendly application software to the Bank so that they can |

|carry out and extract transaction data from a Centralized database |

|located at remote location in a quick and reliable manner. This product |

|will be hosted on server and can run on a browser in any conventional |

|computer. |

| |

|Following are some of the Modules I have developed in Core Banking |

|Solution - |

|Transaction module, Authorization Process for all types of Transactions, |

|Standing Instruction, Interest Slab details, Common System, Branch |

|Details, Organization Details, query Module, Export Import to Head |

|Office, Writing stored procedure & Triggers |

Project #2

Cheque Management and Budgeting System

|Cheque Management |

|Client |Venus Controls and Switchgear Pvt. Ltd. |

|Environment |ASP.NET, C#, Ajax, Javascript, Visual Studio 2008|

|Database |MS-SQL Server 2005 |

|Role |Developer |

|Team Size |6 |

|Duration |2 months 5 days (15th Feb 2011 to 20th Apr 2011) |

| | |

|Description: The objective of Cheque Management System is to Provide a |

|complete control to the user of his Receipt and Payments made through |

|Cheque. So that he can budget his Expenses and Keep a records of Cheques |

|in Transit |

| |

|The application helped the Entrepreneur to Maintain the Inflow and Out |

|flow for his firm and it helped him to stop his cheques from being |

|bounced as he now had a clear idea about the cheques in transit and |

|Available and Ledger balances in each account and also could fore cast |

|his expenses accordingly |

| |

|The application also provided a mechanism to automatically generate |

|cheque for Mandatory Payments and showed the actual amount that will be |

|available after making such payments, the provision of adding and |

|removing any |

|Permanent Expenses with easy dropdown list boxes. |

Project #3

Web Application for Across Tou and Tra

|Across Tou and Tra |

|Client |Across Tou and Tra |

|Environment |PHP, Ajax, Javascript, WAMP,MySQL, Dream weaver |

|Database |MYSQL |

|Role |Developer |

|Team Size |6 |

|Duration |2 months (20th Sep 2010 to 20th Nov 2010) |

| | |

|Description: The objective of Across Tou and Tra is to give the client |

|the ease of Renting cars and booking buses from the comfort of there |

|home. The client operates in the north eastern region of India and |

|provides various types of cars on rent. Each having a different rent |

|according to distance and days and the type of car. |

| |

|This application provides the client to select the available car for |

|there trip and it shows them the entire cost of journey according to |

|their selection of destination and number/Km of there journey. The |

|application also provided a mechanism to select the seat of your |

|preference when booking a bus for a trip |

| |

|The entire information is updated in a data base and the person is |

|diverted to payment portal for making payment and finalising his bookings|

SOFTWARE EXPOSURE:

Programming Languages

. C, C++, Java, Visual Basic, ASP.NET, C Sharp, Html

Scripting Languages

. Java Script, ASP,PHP

Tools Used

. MS-Office, Dream weaver

Operating System

. Dos, Windows 2000/Xp, Beginner's UNIX.

Data Base

. Oracle, SQL Server 2005

Networking

. Fundamentals

. Protocols: TCP/IP, SMTP, UDP/IP

ACHIEVEMENTS:

. Attended training on SQL Server 2008 in Processware

Systems Pvt. Ltd.

. Ranked EX (excellent) in Web Development during ACCP

2005 in Aptech.

PERSONAL INFORMATION:

. Marital Status : Single

. Sex : Male

. Nationality : Indian

. Date of Birth : 11th Feb 1985

. Languages : English, Hindi and Bengali

. Father's Name : Dr. Shrawan Kumar Singhania

DECLARATION: I, hereby declare that all the information given above are

true to the best of my knowledge & belief.

Gaurav

Kumar Singhania[pic]

Contact this candidate