Sql Server Project

Name: Saravanan Velappan Mail: act71m@r.postjobfree.com

Phone: 832-***-****

PERSONAL DETAILS

Lastname : VELAPPAN

Firstname : SARAVANAN

Nationality : INDIA

Date of Birth : 05/14/1980

Visa Type : L2

Address : 46 FARM ROAD, BLDG 3, UNIT 42

City : HILLSBOROUGH

State : NJ

Zipcode : 08844

Email ID : act71m@r.postjobfree.com

Mobile Number : 832-***-****

PROFESSIONAL SUMMARY:

11 years of rich experience in analysis, design, development and deployment of commercial and business application software.

Extensive experience in design and development of Applications using ASP.Net 4.0, MVC 4.0, Entity Framework, Nuget Package Manager, WCF, C#, LINQ, Web Services, JavaScript, JQuery, CSS, XML, XSLT.

Extensive experience in MS SQL Server 2000 2005/2008 and BI (SSIS and SSRS)

Experience in Analyze, design and develop new web-based applications including coding, code based unit testing using Moq, debugging and documentation, following Agile Development Methodology (SCRUM) and played scrum master roles.

Experience in using development tools such as Visual Studio and configuration and design tools (UML, VSS & TFS)

Extensive knowledge and experience of component-based and service oriented architectures Web Services (SOAP, WSDL, DISCO) and WCF

Strong analytical skill with problem solving and Trouble-shooting capabilities.

Excellent Team Player with good communication and analytical skill.

Co-ordinate efficiently within teams and with business/application stake holders for project requirements gathering, Design discussions, Client meetings, Onsite-Offshore coordination, client’s single point of contact, implementation & Customer signoff’s

Travelled twice to UK for Business visit and KT.

EDUCATION

Bachelor of Commerce from University of Madras. (April 2003)

GNIIT from NIIT - April 2004

CERTIFICATION

Microsoft Certified in Developing ASP.NET MVC 4 Web Applications (70-486)

EXPERIENCE:

Organization

Role

Period

Location

Website

Infosys, Houston TX

Technology Analyst

Sep 2015 to Mar 2016

Houston, TX

http://www.infosys.com/

Memorial Herman

Technology Analyst

Aug 2015 to Sep 2015

Houston, TX

http://www.memorialhermann.org/

Encore Software Services

Technical Lead

Jan 2015 to May 2015

Chennai, India

http://www.encoress.com/

ANB Systems

Technical Lead

July 2014 to Dec 2014

Chennai, India

http://www.anbsystems.com/

CSS Corp

Team Lead

Jun 2010 to July 2014

Chennai, India

https://www.csscorp.com/

QuScient Technologies

System Analyst

May 2007 to Jun 2010

Chennai, India

http://www.quscient.com/

Sparza Technologies Pvt Ltd

Senior Software Engineer

Dec 2006 to May 2007

Chennai, India

Quintegra Solutions

Software Engineer

May 2004 to Dec 2006

Chennai, India

http://www.quintegrasolutions.com/

TECHNICAL SKILLS

Operating Systems

Windows NT 4.0, Windows 2000, Windows XP, Windows Server 2003

Tools

MS Visual Studio .NET, MS Visual Source Safe, VSTA, MS office 2007, Microsoft TFS.

Programming languages

.NET Framework 1.0/1.1, 2.0, 3.0, 3.5, ASP.NET, HTML, JavaScript, XML, SOAP, MSMQ, SQL Server 2000, 2005,2008 Oracle, Microsoft Access, SSIS, SSRS, Windows Active Directory, C#, VB.NET, ADO.NET, UML, NHibernate,, LinQ to SQL Classes, ADO.NET, WCF, MVC 3.0, 4.0

Functional Experience

Around 10 years in requirements gathering, functional documents, Design and UML diagrams, development, Testing, Team Management, Client Interaction, onsite-offshore coordinator, project setup and deployment.

PROJECT PROFILE

PROJECT TITLE : Marketing Intelligence platform

PERIOD : Oct 2015 – Mar 2016

CLIENT : British Petroleum

ROLE : Technology Analyst

PROJECT DESCRIPTION : This project is all about getting data from market and make it available for the traders to trade in here we are using several service model that can handle the ETL operation and there is a Informatica tool that has several workflows that will migrate data to the oracle DB that can be further process for reports to daily traders.

TECHNOLOGIES AND TOOLS : ASP.NET MVC, Knockout JS, C#, VB scripts, WPF, Entity Framework, Oracle 11G, SQL server, Informatica

FRAMEWORK : .NET Framework 4.0,

ENVIRONMENT : Windows 7,

TEAM SIZE : 5

RESPONSIBILITIES :

Getting requirement for core functionality and analyzing the deviation in the new requirement.

Coding and analyzing.

Pear Code review

Sending daily status report.

Monitoring service.

PROJECT TITLE : Flu Campaign Model

PERIOD : Aug 2015 – Sep 2015

CLIENT : Memorial Herman

ROLE : Technology Analyst

PROJECT DESCRIPTION : This project is all about the flue campaign management it all deals with the patient details whether the patient taken flu shot in the hospital premises or outside of the hospital and it maintains the patient and workers information on the flu shot.

TECHNOLOGIES AND TOOLS : Asp.net, Entity Framework, SQL server

FRAMEWORK : .NET Framework 4.0,

ENVIRONMENT : Windows 7,

TEAM SIZE : 1

RESPONSIBILITIES :

Getting requirement for core functionality and analyzing the deviation in the new requirement.

Coding and analyzing.

PROJECT TITLE : Virtuoso

PERIOD : Jan2015 – May 2015

CLIENT : Encore Software Services

ROLE : Technical Lead

PROJECT DESCRIPTION : Virtuoso is the travel industry’s leading luxury network. This project helps virtuoso to exhibit its products and the areas were they provide the service at the same time it allows the user to book their own travel and user can also contact the trip adviser who can provide the best experience.

TECHNOLOGIES AND TOOLS : Asp.net, Entity Framework, SQL server, WCF.

FRAMEWORK : .NET Framework 4.0,

ENVIRONMENT : Windows 7,

TEAM SIZE : 4

RESPONSIBILITIES :

Maintain Agile Dashboard and facilitating team on their impediments.

Getting requirement for core functionality and analyzing the deviation in the new requirement.

Coding and analyzing.

Code review for team members.

PROJECT TITLE : eTrack

PERIOD : Jul2014 – Dec 2014

CLIENT : ANB systems

ROLE : Technical Lead

PROJECT DESCRIPTION : This project is all about the incentives calculation for the saving in the energy domain. In US every state is provides incentives for the product that saves the energy. Each and every state sets its own incentives for the savings.

TECHNOLOGIES AND TOOLS : Asp.net, Entity Framework, SQL server, WCF.

FRAMEWORK : .NET Framework 4.0,

ENVIRONMENT : Windows 7,

TEAM SIZE : 3

RESPONSIBILITIES :

Preparation of detailed design document for new enhancements.

Getting requirement for core functionality and analyzing the deviation in the new requirement.

Delegated sub Tasks to team members.

Assisting team members for technical aspects.

Code review for team members.

PROJECT TITLE : Capita one

PERIOD : Nov2010 – Jul 2014

CLIENT : Capita

ROLE : Team Lead

PROJECT DESCRIPTION : This project is to maintain and keep track of the student record in UK. It is highly sensitive project for capita. There are more than 100 local authorities in UK are using capita one to maintain the children records. This project provides solution to support early intervention and prevention.

This project has several modules Admission and Transfer, citizen portal, transport, B2B, e-suite, and provider portal and so on. I have worked on the e-suite, transport and citizen portal modules that were mainly developed on the ASP.Net and MVC4.

TECHNOLOGIES AND TOOLS : Asp.net MVC 4, Entity Framework, Oracle, Nuget.

FRAMEWORK : .NET Framework 4.0,

ENVIRONMENT : Windows 7,

TEAM SIZE : 3

RESPONSIBILITIES :

Creating reusable components for the core functionality.

Getting requirement for the core functionality and analyzing the deviation in the new requirement.

Delegated sub Tasks to team members.

Contribute the technical knowledge to assist the team members.

Code review for the onshore and offshore team members.

PROJECT TITLE : EEPM

PERIOD : July 2009 – Jun 2010

CLIENT : ANB

ROLE : System Analyst

PROJECT DESCRIPTION : Oncor has a new online database tool called EEPM to give service providers and inspectors one centralized, easy to use system for the submittal, approval, tracking and payment of incentives for energy efficiency projects in the Oncor service area. EEPM will reduce paperwork, speed up the review and approval process and shorten payment timeframes.

EEPM is a web-based application that follows the Software Development Life Cycle (SDLC). Various modules including Program Config, Measure Config, Workflow Config, Rules Config, Users, Budget, Program Application, Projects, Umbrella Contract, Inspections, Dashboard, Inspection Configuration, Master Login, Payment, etc., are developed for handling and

TECHNOLOGIES AND TOOLS : SharePoint Server 2007, SQL Server 2005 (SSRS)(SSIS), Windows Service

FRAMEWORK : .NET Framework 2.0, ASP.NET 2.0

ENVIRONMENT : Windows Server 2003, XP Professional

TEAM SIZE : 8

RESPONSIBILITIES :

Creating reports in SSRS 2005 and host it in the Reporting Server using Reporting service API’s and security has been handled to APIs.

Analyzing the requirement for CR and giving the estimation for the same.

Delegated sub Tasks to team members.

PROJECT TITLE : CMS-SV

PERIOD : May 2009 – Jun 2009

CLIENT : ANB

ROLE : System Analyst

PROJECT DESCRIPTION :

This project is all about the scenario calculation for the insurance company. The client is one of the leading Insurance Company in US. This is one of the modules in Climes Management System. In this we are creating the tool for the user to providing the several scenarios how the Indemnity and Net present value has been calculated. In this we have used the SQL server 2005 as a Backend and ASP.Net 2.0 as a presentation layer and middle process as Windows Service to handle the process of calculation.

TECHNOLOGIES AND TOOLS : SQL Server 2005 SSIS, Windows Servicer,

FRAMEWORK : .NET Framework 2.0, ASP.NET 2.0

ENVIRONMENT : Windows Server 2003, XP Professional

TEAM SIZE : 2

RESPONSIBILITIES :

Created Windows servicer for the background process in upload

Creating reports in SSRS 2005 and host it in the Reporting Server using Reporting service API’s and security has been handled to APIs.

Writing highly optimized T-SQL script in SQL Server for data Migration.

Delegated the Work Breakdowns to the Developer.

PROJECT TITLE : E-Tracker

PERIOD : Oct 2008 -May 2009

CLIENT : Clear Traker

ROLE : System Analyst

PROJECT DESCRIPTION :

Client is the leading electricity domain expert in USA. They are providing the solution for power consumption and maintenance. For their power consumption tracking ANB system created the software for maintenance. With advanced dashboard system and provided the Ad-hoc reports using Reporting Service 2005

TECHNOLOGIES AND TOOLS : SQL Server 2005,

SQL Server 2005 Reporting Services(SSRS)

FRAMEWORK : .NET Framework 2.0, ASP.NET 2.0

ENVIRONMENT : Windows Server 2003, XP Professional

TEAM SIZE : 5

RESPONSIBILITIES :

Designing highly scalable Flex Dashboards and extensive ad hock reports using Flex 3.0. and Reporting service 2005

Creating reports in SSRS 2005 and hosted it in the Reporting Server directly and called the reports using reportviewer. Configured Reporting service in SQL server 2005.

Giving ad hock solution for the production issue and maintenance.

Maintaining multiple instances in the production environment and creating new instance of the application based on the client Request.

Coordinating with onsite members in a timely and professional manner.

PROJECT TITLE : Advantage

PERIOD : Feb 2008 – Oct 2008

CLIENT : Pinacle career Institute

ROLE : System analyst

PROJECT DESCRIPTION :

Client is the leading educational institute in Kansas City USA. They provide the high quality education and provide services required to prepare the student for career. From their legacy system they want to move to the new product created by fame. We did the extreme quality of migration that leads the client to use the product fluently.

TECHNOLOGIES AND TOOLS : SQL Server 2005, SSIS

FRAMEWORK : .NET Framework 2.0

ENVIRONMENT : Windows Server 2003, XP Professional

TEAM SIZE : 4

RESPONSIBILITIES :

Analyzing the business process and gathering the business relevant data for the new system. Providing on site support to offshore team.

Designing highly scalable SQL Server 2005 databases using new SQL Server 2005.

Writing highly optimized T-SQL script in SQL Server for Migrating the data into the new system.

Coordinating with onsite members in a timely and professional manner.

Handled authority in an effective and mature manner.

PROJECT TITLE : Blue Star jets

PERIOD : May 2007 - Feb 2008

CLIENT : A private jet charter brokerage company

ROLE : Senior Software Engineer

PROJECT DESCRIPTION :

Client is the world most comprehensive and efficient private jet brokerage company. With access to operators of the largest network of luxury flights. We have built a Business tracking software which has 5 modules including LMS, Prospect, Trip, and calendar.

TECHNOLOGIES AND TOOLS : ASP.NET with C#, SQL Server 2005, AJAX

FRAMEWORK : .NET Framework 2.0

ENVIRONMENT : Windows Server 2003, XP Professional

TEAM SIZE : 5

RESPONSIBILITIES :

Designing highly scalable SQL Server 2005 databases using new SQL Server 2005.

Writing highly optimized code in SQL Server for processing daily trip information.

Excellent Experience in writing stored procedures, functions and triggers

Good knowledge in writing XML based queries in SQL Server 2005

Good knowledge using XML based communication between SQL Server 2005 and .NET framework 2.0

Creating optimized and high performance powered .NET Web Applications using AJAX .NET framework 1.0 and Asynchronous call backs

Coordinating with onsite members in a timely and professional manner.

Handled authority in an effective and mature manner.

PROJECT TITLE : Advanced IVR (Interactive Voice Response) System Product

PERIOD : Dec 2006 – May 2007

CLIENT : Leading Interactive Voice Response provider in USA

ROLE : Senior Software Engineer / Project Lead

PROJECT DESCRIPTION :

Client is a leading USA based hosted interactive voice response (IVR) outsource service provider. Client has been designing and implementing successful interactive voice response programs for its clients since 1990. Product has 10 modules including Transcription, fulfillment, Audio streaming etc. It also handles live agent calls and primary objective in designing this product is to provide end to end solutions with rapid performance using .NET framework 2.0 and SQL Server 2005. Other technologies used are SSRS and SSAS.

TECHNOLOGIES AND TOOLS : ASP.NET with C#, SQL Server 2005, AJAX

FRAMEWORK : .NET Framework 2.0

ENVIRONMENT : Windows Server 2003, XP Professional

TEAM SIZE : 7

RESPONSIBILITIES :

Designing highly scalable SQL Server 2005 databases using new SQL Server 2005 features such as Partition of Tables and Indexes, Online Index etc.

Writing highly optimized code in SQL Server for processing millions of calls every day without time out issues. Implemented using new isolation level features of SQL Server 2005

Created the RDL files for the client requirement.

Good knowledge in creating CLR based components in SQL Server 2005

Excellent Experience in writing stored procedures, functions and triggers

Creating optimized and high performance powered .NET Web Applications using AJAX .NET framework 1.0 and Asynchronous call backs

Good knowledge in creating deployment modules and writing NET Services using C#

Creating scalable Data access components using ADO .NET

Coordinating with onsite members in a timely and professional manner.

PROJECT TITLE : Visual logistics 2nd phase

PERIOD : Jul 2005 – Dec 2006.

CLIENT : Elogistics GB Ltd. (UK)

ROLE : Software Engineer

PROJCT DESCRIPTION :

MFI is a leading furniture manufacturer and established all over UK. MFI has identified that transportation to be optimized to reduce the costs.

VL is web based product is intended to fulfill Transport Management System activities effectively. VL is implemented at MFI successfully. And implementation with T&B, a leading transportation unit in UK, is planned. Visual Logistics™ (VL) application is primarily a solution for organizations requiring transportation to move goods to and from a number of locations. Additionally key benefits are derived when that transportation is planned at a number of sites.

VL application has been migrated in to .net Application that is asp pages had been converted into aspx pages and I did conversion of the component and my main job is converting ADO into ADO.net and I hosted the application in the production Server did some R&D on the Intermediate page calling using XML for unwanted refresh of the aspx pages.

TECHNOLOGIES AND TOOLS : ASP.net, JavaScript, SQL Server 2000, IIS 5.0

ENVIRONMENT : Windows 2000 professional

TEAM SIZE : 4

RESPONSIBILITIES :

Programming Prototype, Report, backend Stored Procedures and Business Components

Hosting application in IIS

Using .NET Remoting for communicate web application to an exe running in the same machine.

PROJECT TITLE : Yield Control System

PERIOD : Mar 2005 – Jun 2005

CLIENT : Anacott Asia Pacific Co., Ltd. (AAP), Thailand

ROLE : Software Engineer

PROJECT DESCRIPTION :

Anacott Asia Pacific Co., Ltd. (AAP) is one of the largest Asian-based specialized providers of accommodation worldwide. The Yield Control System allows hotel partners to manage their inventory directly, making real-time changes to availability and pricing, which can be immediately displayed to customers. Hotels can also handle booking delivery, rooming lists, sales history, forecast tools, and other essential functions via this system. YCS developed as an ASP.NET extranet application in Service Oriented Architecture. System also provides user management module to manage AAP users and hotel user. .

TECHNOLOGIES AND TOOLS : ASP.Net using VB.net,

XML Web service Using SOAP Protocol

ENVIRONMENT : Windows 2000 professional

TEAM SIZE : 8

RESPONSIBILITIES :

Developed hotel reservation module.

Prepared of Low Level Design documents.

Prepared of Test Cases and Test Plan.

Performed Unit Testing and System Testing.

Keep tracking of database changes.

Build, deploy and packaging application.

PROJECT TITLE : Visual logistics

PERIOD : May 2004 – Feb 2005

CLIENT : Elogistics GB Ltd. (UK)

ROLE : Software Engineer

PROJECT DESCRIPTION :

MFI is a leading furniture manufacturer and established all over UK. MFI has identified that transportation to be optimized to reduce the costs.

VL is web based product is intended to fulfill Transport Management System activities effectively. VL is implemented at MFI successfully. And implementation with T&B, a leading transportation unit in UK, is planned. Visual Logistics™ (VL) application is primarily a solution for organizations requiring transportation to move goods to and from a number of locations. Additionally key benefits are derived when that transportation is planned at a number of sites.

VL is already in a maintenance phase in this my concern I did some critical bug fixing and developed some complicated Reports created the necessary documents for development purpose.

TECHNOLOGIES AND TOOLS : ASP, JavaScript, VB com, SQL 7.0

ENVIRONMENT : Windows 2000 professional

TEAM SIZE : 4

RESPONSIBILITIES :

Code mining

Prototype Development for Reports,

Development of ASP’s, Stored Procedure and Business Components.

Contact this candidate