Sql Server Project

S.Vadivukarasi Email:***.****@*****.***

Mob:*****997

Objective: Highly motivated dedicated individual seeking challenging international opportunity in software development where my knowledge and skill set can be nurtured and used for effective software development.

Technical Summary:

8+ Years of experience in VS.NET Applications Software Development and SQL Server 2000/2008 R2

Extensive knowledge of Web based applications using ASP, ASP.NET, MVC, ADO.NET, C#, Web Services, WCF, HTML,JQuery. JavaScript, SQL Server, ORACLE

Good Working Knowledge on Windows Forms

Excellent analytical skills with Proficiency in debugging and Problem Solving.

Extensive experience with source control systems such as Visual Source Safe and TFS.

Extensive Object Oriented Design and Development skills.

Knowledge on SSIS and SSRS

Knowledge on Control-M tool

Worked with Brackets and Github desktop version

Experience in Software Engineering Concepts including Designing, Programming, Implementation and Testing.

Strong Skills in developing 3-Tier and N-Tier Architecture systems deployed on windows platform.

Versatile team player as well as independent contributor.

Ability to conceptualize, document, and communicate project ideas and plans.

Enthusiastic and Quick to learn new applications and tools and willing to take individual responsibilities.

A good team player with strong ability to learn and adapt new skills and makes efforts to do the work at hand and manage time effectively

Proven track record of designing and implementing flexible solutions which support frequent UI and Functional changes

Provided customer support on time for the applications which i have worked with.

Professional Summary: Hardworking, enthusiastic and highly committed to the growth and success of the organization.

Very quick and efficient in solving complex technical issues

Possess good work ethic and high-level of integrity.

Flexible, result-oriented and adapt to the environment quickly to meet the goals of the product and the organization.

Handled Customers and collected the requirement and prepared documents according to the requirement.

Flexible in learning new technologies

Proven track record of designing and implementing flexible solutions which support frequent UI and Functional changes

Prepared analysis, design documents for different component and functional modules required by the system.

Participated in writing Stored Procedures and other database operations such as complex SQL queries, views and triggers etc.

Working on Deployment to QA and Production with Configuration settings. Experience with IIS. Fortunately got an opportunity to work closely with QA for bug fixes to ensure the efficiency and accuracy of the code.

Career Summary:

With Virtusa Software services Ltd., Chennai as a Consultant from July 2013 to Apr 2015.

With Virtusa Software services Ltd., Chennai as a Senior Software Engineer from Feb 2012 to June 2013

With Sify Technologies Pvt., Ltd., Chennai as a Software Engineer From Dec 2007 to Aug 2010.

With Talent Maximus Pvt., Ltd., Chennai (Outsourcing) Sify Limited, Chennai as Software Engineer From Mar 2007 to Dec 2007.

With Prime e-Tech Pvt., Ltd., Chennai (formerly known as ITRT Solutions) as Software Developer from Apr 2005 to Feb 2007.

Project: OptiFreight New Generation System

(Environment: VC# Window Forms, ASP.NET,,JQuery, SQL Server 2008 R2 Windows 2008,

Duration: Jan 2015 – Apr 2015

Cardinal Health, Inc. is a $91 billion health care services company that improves the cost-effectiveness of health care. As the business behind health care, Cardinal Health helps pharmacies, hospitals, ambulatory surgery centers, clinical laboratories and physician offices focus on patient care while reducing costs, enhancing efficiency and improving quality. Cardinal Health is an essential link in the health care supply chain, providing pharmaceuticals and medical products and services to more than 100,000 locations each day and is also the industry-leading direct-to-home medical supplies distributor.

Responsibilities:

Handled change requests individually with 2 member team

Involved in Windows Form design and change request implementation also WCF Services creation.

Involved in Client interaction for getting signoffs on the change request

Project: DOI Exception Dashboard

(Environment: VC#, ASP.NET 4.0, JQUERY,MVC,LINQ, SQL Server 2008 R2, SSIS, SSRS, Windows 2008,

Duration: Sep 2013 – Dec 2014

This client must comply with regulatory requirements by making a public declaration, whenever its securities holdings or certain client’s holdings exceed designated thresholds. DOI (Disclosure of Interest) Application is developed to meet the global regulatory requirements for DOI reporting. Daily Batches & Reports Jobs are scheduled in the Control-M automation scheduling tool for business need.

Responsibilities:

Created Development of procedures, views, functions and triggers

Involved in development of SSIS packages and SSRS Reports

Involved in Integrating SSRS Report in Existing ASP.NET Application

Involved in Design activity for new enhancements for meeting business needs across the globe

Handled the Change requests individually with 3member team

Project: DOI (Disclosure of Interest)

Environment: VC#, ASP.NET 4.0, SQL Server 2008, Windows 2008, Control-M tool

Duration: Feb 2012 – Aug 2013

The goal of the DOI project is to meet the global regulatory requirements for Disclosure of Interest reporting. Investment Banking must comply with regulatory requirements by making a public declaration, called a “disclosure of interest,” whenever its securities holdings or certain clients’ holdings exceed designated thresholds. Voting rights are granted to owners of shares of a corporate equity. Usually there is one vote granted per share. Shareholders vote on a variety of aspects of corporate governance, so a shareholder of a large number of shares of a particular corporation can have a strong influence over a security’s price, and possibly the entire stock market. Stock markets are an integral and important part of most countries’ economies, so governmental bodies regulate the markets. Disclosure of interest is part of governmental market regulation.

Responsibilities:

Handled change requests individually with 2 member team.

Involved in Web Form design also developed individual console applications to run on Control-M tool.

Created and scheduled jobs in Control-M tool.

Involved in Client interaction for getting signoffs on the change request.

Project: ICTACT Education Portal

Environment: VC#, ASP.NET 3.5, SQL Server 2000, Windows 2000

Duration: Feb 2010 – Aug 2010

This portal allows the student, faculty and Industry to register the details. Only the registered students can access the job details, job fair details which is posted by the company. The registered industries only can post the job information in the portal. The registered faculties can get their course materials offered by ICTACT if their college is member of ICTACT. Journals can be posted to this site and separate account will be created for the posted journal. It will be reviewed by the ICTACT Admin. Journal user can know status of the journal by logging with the Username and password sent to their email id.

Responsibilities:

involved in client interaction to collect the requirements

involved in Web Page Design and Creation of SQL Queries, Views and Stored Procedures, extensive coding for completing the change request

Involved in Client interaction for getting signoffs on the change request.

Project: KWE Warehouse Management System

Environment: VC#, ASP.NET, SQL Server 2000, Windows 2000

Duration: Jun 2009 – Jan 2010

This project maintains all the information required for Warehouse Management. It maintains information about Principle, Products, Warehouse, Location, Manufacture, Customer, KWE Branches, Charge, Logistic Partner and Unit of Measurement. Each Warehouse will have own set of Products, Location. It allows the Warehouse user to enter Opening Stock, Current Stock. It allows the warehouse user to place Shipment Order, Purchase Order, and Goods Receipt. It allows the warehouse user to Allocate Stock, Pick Stock, Delivery Note and POD Management for the Shipment Order. It allows the Warehouse user to transfer product from one Warehouse to another warehouse. It also allows the user to handle defective products.

Responsibilities:

Involved in client interaction to collect the requirements for my module

Involved in Web Page Design and Creation of SQL Queries, Views and Stored Procedures, extensive coding for completing the change request

Project: Lucas Dealer Management System

Environment: VC#, ASP.NET 1.1, SQL Server 2000, Windows 2000

Duration: Nov 2008 – May 2009

This project maintains all the transaction for Dealer and Supplier information. It allows the dealer to perform the following transaction: Order, Order Acknowledgement, Delivery, Invoice, Creation of Job Card, Job card Status, Special Scheme, New Products, special scheme, Excess Stock and Closing Stock. It allows the supplier to perform the following transaction: PO, Delivery Plan, Shipment Notification and Goods Receipt Note. It is controlled by the Admin user. It gets the Dealer and supplier information from the SAP through regular intervals. Job card also verified through SAP.

Responsibilities:

Involved in client interaction to collect the requirements for my module

Involved in Web Page Design and Creation of SQL Queries, Views and Stored Procedures, extensive coding for completing the change request

Project: Same Dealer Management System

Environment: VC#, ASP.NET 1.1, SQL Server 2000, Windows 2000

Duration: Nov 2008 – May 2009

This project maintains all Dealer transaction information. Dealer will get the Tractors through Sell In which will be accumulated in the Dealer Stock. If there is any problem in the Tractor they will return the tractor through Sales Return. Dealer can sell the Tractors to Customers through Delivery. At the time it will be given to Customer as Advance, once they satisfied with the Tractor, it will retail to the Dealer. If any problem at the time of advanced, customer will return the tractor to the Dealer. It classify the Dealer based on Zone and State.

Responsibilities: Web Page Design, Created SQL Queries, Views and Stored Procedures, coding

Project: NHT CBU System

Environment: VC#, ASP.NET, SQL Server 2000, Windows 2000

Duration: Apr 2007 – Jan 2008

This project maintains all the information based on hierarchy. This hierarchy is based on the following category, Direct Sales, Exports and Country. It maintains information about Zones, CBU, Area Sales Office, Dealer, Tractor Model and Bank Information. It allows the Area Sales officer to create Source order and it should be approved by various higher level users. This order will transfer to the existing BAAN system where the users will create the Sales order and invoice. It also maintains information about the Dealer Inventory, Delivery Sales and Delivery Receipt.

Responsibilities: Web Page Design, Created SQL Queries,Views and Stored Procedures, coding

Project: Marathi Site

Environment: VC# 2005, ASP.NET, SQL Server 2000, windows 2000

Duration: Jan 2007 – Feb 2007

This is the site for ladies.This is the multi lingual site in Marathi language. This site is having lot of information for ladies. It contains Rangoli designs, Mehandi designs and jewel designs. Pooja, Recipes, Home Medicine information also available. This also has the intranet application where the administrators use this to upload the new designs, receipes and news. Using this site user of the site can post their feedbacks and rating of the particular design.

Responsibilities: Web Page Design, Created SQL Queries, Views and Stored Procedures, coding

Project: Stored Value Card

Environment: VC#, ASP.NET, ORACLE 9i

Duration: Oct 2006 – Dec 2006

Fuel Card is nothing but a “Stored Value Card”. This plastic currency enables customer to buy any product of their choice at the cinema, there by avoiding carrying huge cash. It gives flexibility in terms of buying cinema tickets, concession or even for that matter a parking coupon. Using this site they can add the friends or family members to this card. If they want remove the add-on member from the card that also they can do with this site. Recharging of the card will be done here.

Responsibilities: Web Page Design, Created SQL Queries, Views and Stored Procedures, coding

Project: Unlimited Gatekeeper

Environment: EVC++, VC#, SQL Server 2000 CE, RDA Technology, SQL Server 2000

Duration: Jan 2006 – Sep 2006

Gatekeeper is a Pocket – pc application which is used in the entrance of the theatre for the verification of ticket which was booked by Unlimited Card. This application gets the ticket information from the server every 3 minutes. These tickets may be booked using the Internet application or POS application. Based on the ticked booked it will get the card information and the person information if it is booked by the card. So based on this person information the end user can verify the person is valid person or not. This application is controlled by Back office. Using Back office, it is possible to assign the users for the PDA application, assign the PDA to the particular entrance and assign the entry time for the particular theatre entrance.

Responsibilities: User Interface Design, Programming, SQL Queries

Project: Employee Monitoring System

Environment: VC# 2003, SQL Server 2000

Duration: Oct 2005 – Jan 2006

Task Monitor is a desktop application. This Application monitors the activities of the employees. This Application maintains the project and Employee information. Task Monitor gives the reports about the developer estimated task, developer activity report, workstation report and project report. In this Developer has to enter the Daily task what they are going to do. Based on time settings it will pop up the status window (every half an hour or 1 hour) and they have to enter the status about the Daily task.

Responsibilities: User Interface Design, Programming, SQL Queries

Project: Office Organization System

Environment: VC# 2003, ORACLE 9i, Windows 2000

Duration: May 2005 – Sep 2005

Office Organization System involves maintaining the internal details of the company. It maintains project information, employee information, expenditure information and meeting information. It has the capabilities to calculate the salary details at the end of the month and it also maintains the Attendance information of the Employees. This will help the management to know about the project Status, Employee Performance and account management.

Responsibilities: User Interface Design, Programming, SQL Queries

Educational Qualification:

Academic Profile

University Name

Passed Out

Percentage

MCA

Vellore Institute of Technology

2004

9.04 (CGPA)

B.Sc.(Computer Science)

Madras University

2001

79%

+2

TamilNadu state board

1998

70.6%

10

TamilNadu State Board

1996

85.6%

Contact this candidate