Sql Server Project

Name: - Kumaravijayan Chandrasekaran (Vijayan)

Contact Info: - 916-***-****

Email: - ********@*****.***

SUMMARY:

A total IT experience of 11+ years in Microsoft Technologies/.net framework

Involved in various roles such as design, development and testing of web-based/client server applications

The scope of work in various involves project included designing, developing, maintaining, implementing and enhancing various business components using technologies such as ASP.Net, C#, WCF, web services, VB6.0 and SQL server as database

Extensive knowledge and experience in designing, developing, and testing various business applications using Visual Studio .NET 2008/2005/2003, C#, VB.NET, ASP.NET 3.5/2.0/1.1, ADO.NET, and SQL Server 2000/2005

Engaged with users to gather business requirements, map technology to business needs, create Business Use Cases and Sequence Diagrams.

Designed application using appropriate design patterns to enhance extensibility and promote standards to program to an interface rather than implementation.

Used AJAX controls to minimize server round trip and enhance customer experience.

Experience working with end users to create business requirements and Business Process Mappings. Translating requirements into use cases and refine requirements and make sure they cater to customer’s expectation.

Exceptional communication and presentation skills, ability to interact with people at all levels.

Ability to analyze and define business processes for improvement, Excellent Analytical and Decision making skills.

Extensive hands on experience in Windows Communication Framework (WCF). Involved in creating complex services and consumed the same

Strong working knowledge of web technologies including HTML, JavaScript, VBScript and XML.

Worked extensively with ADO.NET objects such as Data Adapter, Dataset, and Data Reader to interact with databases

Extensively worked on complex database queries along with creating Constraints, Indexes, Views, Stored Procedures, Cursors and Triggers in SQL Server 2000/2005

Experience in creating and consuming XML Web Services

Experience in creating Web Forms, Win Forms, User Controls and Custom controls for GUI library.

Experience in gathering customer/functional requirements and converting them to technical requirements.

Experience in maintaining and providing post implementation support.

Strong knowledge of .NET security features such as Authentication & Authorization, Windows-based Authentication, Forms-based Authentication, Authorizing Users and Roles.

Good understanding of Object Oriented Programming (OOP) concepts and design patterns

Experience in working with Visual Source Safe, Team Foundation Server.

Excellent analytical/communication skills, hardworking, good team player, highly Adaptable and used to working under stringent timelines.

Technical Summary

MS .Net Technologies

Microsoft .Net Framework, ASP.Net,C#.Net,ADO.Net, VB.Net, Web Forms, WCF

Web Technologies

ASP, Web Services, AJAX, XML

Web Servers

IIS 5.0, IIS 6.0, IIS 7.0

Programming Languages

VB 6.0, C#.Net, VB.Net, JavaScript, VBScript, HTML

Frameworks

Microsoft .Net 4.0/3.5/3.0/2.0

Databases

SQL Server 2008/2005, SSRS

Version Controller

TFS, Microsoft Visual SourceSafe, CVS

Operating Systems

Windows NT/95/98/2000/XP

Search Platform

Apache Solr 4.7.1

Education

Master in Computer science

India.

Certification

MCAD (Microsoft Certified Application Developer)

BIG Data / Hadoop Boot Camp

Experience

E – Business International (Contractor)

Team Lead/.Net Lead Developer

NOV’12 to Till

Global Tel* Link (Full Time)

Sr. Software Engineer

APR’08 to OCT’12

ARRMAN INC (Contractor)

Software Engineer

AUG’06 – APR’08

ACSYS Software Ltd (Full Time)

Software Engineer

JUN’05 – JUN’06

Spectra Soft Software Ltd (Contractor)

Developer

JUN’04 – JUN’05

DigiBlitz (Contractor)

Trainee

JAN’03 – MAY’05

RECENT PROJECTS:

Project #1

Company E-Business International JAN’14 – Till

Client SCIF

Title CSTM Reports

Location Pleasanton, California

Environment Visual Studio 2012, Oracle11g, SSRS, WCF Service

Role Lead .Net Developer

Project Description:

CSTM (Customer Timeliness Matrix) is a SSRS report application. We created more than 30 reports with different templates. We scheduled the reports with Data driven and default recipients.

Role and Responsibilities:

Involved in Requirements gathering, Design & Analysis of the Customer Specifications, and Development of the reports.

Design Walkthroughs with related Technical Teams.

Project #2

Company E-Business International NOV’12 - DEC’13

Client SCIF

Title Raptor

Location Pleasanton, California

Environment Visual Studio 2012, C#, MS SQL Server 2008, ASP.NET, SSRS, SSIS

Role Team Lead

Project Description:

RAPTOR (Release and Project Online Reporting) is a web application that enables Executives and Managers to schedule and manage releases, projects and allocate resources. The application facilitates resources to submit hours for approval. Features included are calendar events, milestones management, user role based access, time tracking, cost report / invoice generation, time sheet approval process and email integration.

Role and Responsibilities:

Involved in Requirements gathering, Design & Analysis of the Customer Specifications, and Development of the Application following waterfall methodology.

Designed and development of UI/Business Components/ Data access layer using ASP.net, C# and SQL server.

Design Walkthroughs with related Technical Teams.

Conduct meetings with stakeholders for clarifications and approvals.

Feasibility analysis, identifying operational constraints.

Representation in technical team in requirement meetings.

Project #3

Company Global Tel Link (Full Time Employee) MAR’12 – OCT12

Title Notifier

Location Sacramento, California

Environment Windows XP, Visual Studio 2010, C#, MS SQL Server 2005

Role Lead .Net Developer

Project Description:

The project “Notifier” processes the requests from the Breakage processor and IVR Notifier web service. We created this WCF service for managing the notification queue and the Exclusion list. The Breakage Processor run every day and gets the list of Inactivity accounts. For each account the processor call the “Notifier” service to validate whether to break the account or not. Service uses DataContract for both Input and output. All input DataContract uses the public input “TransactionID” and “SecurityToken” along with additional input required by the function. All input Data Members includes the IsRequired and Order properties.

All the exposed Web Portal Functions log the request, response and validate the Security Token to ensure the client has access if not “Access Not Allowed” Error message and related error number will be return back to the client and the transition will not process.

Role and Responsibilities:

Involved in Requirements gathering, Design & Analysis of the Customer Specifications, and Development of the Application following waterfall methodology.

Responsible for creating the Entity-Relationship, Data Modeling, Class diagrams, Activity diagrams and Process Flow diagrams using Visio 2002 Designed component specification and created Physical and logical level Design document.

Designed and development of Middle tier/Data access layer/Business Components using C#/Sql server.

Create/consume window services.

Responsible for maintaining versions of source code using Team Foundation Server.

Design Walkthroughs with related Technical Teams.

Involving all partnering applications to discuss the design and mode of communication, which will enable smooth data exchange.

Discuss system exception situations and design appropriate recovery techniques.

Conduct meetings with stakeholders for clarifications and approvals.

Feasibility analysis, identifying operational constraints.

Representation in technical team in requirement meetings.

Project #4

Company Global Tel Link (Full Time Employee) MAR’11 – FEB’12 Title Rate Processor

Location Sacramento, California

Environment Windows XP, Visual Studio 2010, C#, MS SQL Server 2005

Role Lead .Net Developer

Project Description:

The vendor pushes the rate file containing rates to an FTP server. WCF service then read and parses the file and updates the table in a SQL server. This project consists of three objects. The first object is the service that will be installed on the server. The second one is an interface, which the service will call when processing the files. The third one is a DLL it provides the actual functionality to process the rate files. This DLL contains a class that inherits the interface. It implements the actual functionality for parsing the flat file and then updating the SQL table with the new values. For each entry in the file, it will search for that particular NPA\NXX combination and update that record. The DLL will provide notification when the number of records changed reaches a configurable percentage level. This will be a Warning message type.

Role and Responsibilities:

Involved in Requirements gathering, Design & Analysis of the Customer Specifications, and Development of the Application following waterfall methodology.

Responsible for creating the Entity-Relationship, Data Modeling, Class diagrams, Activity diagrams and Process Flow diagrams using Visio 2002 Designed component specification and created Physical and logical level Design document.

Designed and development of Middle tier/Data access layer/Business Components using C#/SQL server.

Create/consume window services.

Responsible for maintaining versions of source code using Team Foundation Server.

Design Walkthroughs with related Technical Teams.

Involving all partnering applications to discuss the design and mode of communication, which will enable smooth data exchange.

Discuss system exception situations and design appropriate recovery techniques.

Conduct meetings with stakeholders for clarifications and approvals.

Feasibility analysis, identifying operational constraints.

Representation in technical team in requirement meetings.

Project #5

Company Global Tel Link (Full Time Employee) JUN’10 – FEB’11

Title Call Record Search Tool

Location Sacramento, California

Role Lead Developer

Environment Windows Server 2010, Visual Studio.Net 2008, Windows

Forms, C#, SQL Server 2005, Team Foundation Server

Project Description:

The Call Record Search Tool is a standalone leave behind solution product for former accounts requesting access to historical call data from GTL or previous ITS providers after contract termination. The application provides users with a standalone Windows application and SQL database to access Call Detail Records (CDRs) with basic searching capabilities (CDR Fields) and call recordings. The application also provides an export function to download .CSV files to a directory on the user specified workstation or external media (CD/DVD).

Role and Responsibilities:

Involved in Requirements gathering, Design & Analysis of the Customer. Specifications and Development of the Application following waterfall methodology.

Designed and developed Data access objects and Business Components using C#/Sql server

Design and development of User Interface using asp.net/C#

Contributed towards the Security model in .NET framework for the administration module using verification process, Code Access security, and Role-based security

Involved in writing complex queries and Stored Procedures

Created ASP.NET Web forms and server controls to display dynamic data obtained through the use of Microsoft ADO.NET and Data binding.

Used CSS (Cascading Style Sheets) for branding purposes and user look and feel.

Extensively used JavaScript for Client side validation.

Extensively used the ASP.NET features like Grid View, Detail View and other custom controls

Involved in unit/integration testing

Played crucial role in implementation and post implementation support.

Project #6

Company Global Tel Link (Full Time Employee) APR’08 – MAY’10

Title Payment Gateway/Fraud Engine

Location Sacramento, California

Role Sr.Developer

Environment Windows Server 2008, WCF Visual Studio.Net 2008, Windows

Forms, C#, Asp.Net, Xml, SQL Server 2005, Web Services,

Team Foundation Server

Project Description:

The project titled ‘Payment Gateway’ consists of several phases. The first phase of this project involves migration of the current fraud engine to a new third-party hosted solution to validate such as credit card and address.

The second Phase of this project involves migration of the current payment processor to a new third-party hosted solution to process payment information such as credit cards and also involved implementing real time credit card authorizations for orders placed by customers using Website and call center applications.

The third phase of this project involves taking IVR payments and lockbox (Check\Money order). The fourth phase of this project emphasizes on implementing a tokenized credit card solution for PCI compliance where token numbers are used rather than actual customer credit card numbers for all payment transactions.

Role and Responsibilities:

Involved in Requirements gathering, Design & Analysis of the Customer. Specifications and Development of the Application following waterfall methodology.

Designed and developed Data access objects and Business Components using C#/Sql server

Design and development of User Interface using asp.net/C#

Contributed towards the Security model in .NET framework for the administration module using verification process, Code Access security, and Role-based security

Involved in writing complex queries and Stored Procedures

Created ASP.NET Web forms and server controls to display dynamic data obtained through the use of Microsoft ADO.NET and Data binding.

Used CSS (Cascading Style Sheets) for branding purposes and user look and feel.

Extensively used JavaScript for Client side validation.

Extensively used the ASP.NET features like Grid View, Detail View and other custom controls

Involved in unit/integration testing

Played crucial role in implementation and post implementation support.

Project #7

Company AARMAN INC AUG’06 – APR’08

Client Verizon business

Location Sacramento, California

Title TAG

Role Developer

Environment Visual Studio.Net 2003, ASP.Net, VB.NET, SQL Server 2005, VSS

Project Description:

This is an intranet web application written in ASP.net, VB.net and SQL server 2005. It used by our customer service representative to create and manage customer account also it process Credit card transactions. Customers end up here if IVR (Interactive Voice Response) not able to serve the customer request.

Project #8

Company AARMAN INC AUG’06 – APR’08

Client Verizon business

Location Sacramento, California

Title Site Monitor

Role Developer

Environment VB6, SQL Server 2000, VSS

Project Description:

This is a windows application written in VB6, SQL server2000 and Java applet is used to show live traffic in graphical representation. We designed this application to monitor our live call traffic from each sites. If any issue with traffic likes “failure call”, “Hang Up”, “Blocked” application has the capable to notify the concern person before even customer aware of the failures.

Project #9

Company AARMAN INC AUG’06 – APR’08

Client Verizon business

Location Sacramento, California

Title CC Monitor

Role Developer

Environment VB6, SQL Server 2000, VSS

Project Description:

This is a Window application written in C#, asp.net, SQL server 2005 and JAVA Applet. Its monitors the live credit traffic and create graph for each transaction we processed. If the system identified any Timeout, failed transaction it will automatically sent alert to concern person.

Project #10

Company ACSYS Software System June’05 – June’06

Title INVERSTRAK.NET

Location Chennai, India

Role Developer

Environment VB6, SQL Server 2000, VSS

Project Description:

Ivestrak.net is a complete and a generic mutual fund management system for all AMC’s.(Asset Management company’s ex:-HDFC,SBI,ICICI,TATA Mutual fund, Chola, DSP Merrill Lynch, Birla Sun Life ) .The first module is Customer Relationship Module (CRM). This module aims at providing basic and complete information to the investor. Further this system provides an extensive report generation facility. This module acts as a front end for the whole Investrak.net module, where customer and employee interaction are more. The workflow in this module is well documented and authorized in different levels to make this system a complete and secured investor tracking system (INVESTRAK).

Project #11

Company SPECTRA SOFT Technologies Ltd. June’04 – June’05

Title ERP

Location Chennai, India

Role Developer

Environment VB.net, SQL Server 2000, VSS

Project Description:

We developed this project as product for various clients. It contains so many modules. I worked in HR module. The module sub divided in to three divisions (Master, Transaction, Report).

The master is one time entry. Get the basic information from the user. The information like employee details, activity type, wage type, Statutory Types and etc.

Transaction contains payroll processing and employee creation. Payroll process means to run the payroll for the selected employee, first to get his/her basic salary and separate the earning and deduction wage types. Add the earning wages to basic pay and detect the deduction wages from basic pay finally we get the total gross pay of the employee.

The report division contains following reports Pay slip details, Earning details and deduction details, Employee details.

Contact this candidate