Project Sql Server Management .Net System Developer

Location:

Pune, MH, India

Salary:

2.5

Posted:

December 10, 2012

Contact this candidate

Resume:

SAGAR KASTURE

Email :

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

Mobile : +91

992*******

Professional Summary

. Total 3.10 years of experience in Logistic,Inventory and HRMIS domain

. Experience in various phases of the lifecycle of the project;

Analysis, Design, Development, Testing and implementation of real time

and customized application.

. Worked extensively in application programming using ASP.NET 2.0,C#.NET

3.0, VB 6.0,VBA Excel.

. Well versed with RDBMS like MS-SQL server 2005, MySQL, and MsAccess.

Experience (3.10 Years)

|Organization |Designation |Duration |

|Dynamic Logistics Pvt Ltd, Pune |Software Programmer |Jun - 2008 to Till Date |

|APEX Vantage IT Enabled Services |Technical Supporter |Jan - 2008 to Jun - 2008|

|Pvt. Ltd Pune. | | |

Technical skills

|Operating Systems|Windows XP/2000/NT/98/95 |

|Languages |C#/VB, .NET Frame Work 4.0, HTML, VB 6.0, JavaScript,C, C++, |

| |Excel VBA |

|Databases |SQL Server 2000/2005, MySQL |

|Technology |ASP.NET |

| | |

|Excel Skill |V-lookUp,H-lookUp,PivotTables,Conditions,Cases,Filtering,Index. |

|Reporting Tools |Crystal Reports, SSRS 2005 |

|Domain Knowledge |Logistics, Inventory and HRMIS |

educational profile

|M.C.M. |Pune University, (MH) |Oct 2006 | Higher Second|

project profile

|1. |Project Name: Fixed Deposit System |

|Client |Mahadevnagar Co-Operative Bank |

|Role |Team Member |

|Team Size |5 |

|Environment |Languages: VB.NET, JavaScript |

| |Technology: Microsoft Visual Studio 2005, ASP.NET |

| |Tools : Crystal Reports |

| |Database: SQL Server 2005 |

| |O/s: Windows Xp/2000 |

Project Objective: It Mainly Contains Calculation of FD and Loans.

Project Description: The "Fixed Deposit System" was done for the

Mahadevnagar Co-operative Bank, this project was developed for handling of

all FD Module.

Coding architecture is divided into the Presentation Layer, Business Layer

and Data Access Layer. The front end is in VB.Net whereas the backend is

provided by MS SQL Server 2005. Applications are coded in VB.NET. For

report generation Crystal Report was used.

Contribution

. Understanding bank requirements.

. Writing Client Side Coding.

|2. |Project Name: Warehouse Management System (WMS) |

|Client |Kirloskar Oil Engine, Greaves Cotton Ltd |

|Role |Team Member |

|Team Size |2 |

|Environment |Languages: VB6.0 |

| |Database: SQL Server 2000 |

| |Reports : Crystal report 8.5,Ms Excel |

| |O/s: Windows XP |

Project Description

WMS is windows based application. The project includes 8 different modules.

Receipt process is to get details of truck [Truck No. & Driver Name

and License]. Challan Details [Challan is uniquely defined by supplier

contains part details, PO No, Octroi Details].

The counting process includes counting of part for final

confirmation and rejection.

Processing is the processing of parts with oiling and kitting.

Binning is to place each part in its primary or over flow

location depending on location availability.

Pick list of parts generated for final dispatch.

Reports generated on client side requirement basis.

Contribution

. Direct interaction with clients.

. Understanding user requirements.

. Writing Views/Stored Procedures.

. Development at Client Side

|3. |Project Name: Warehouse Management System (WMS) Web Based |

|Client |EICHER, Indore |

|Role |Team Member |

|Team Size |6 |

|Environment |Languages: ASP.Net Ajax# 2.0, JavaScript,ASP.Net Webservice |

| |Database: SQL Server 2005 |

| |O/s: Windows XP |

Project Description

We have done the migration of our WMS Project to our new system from vb6.0

to Asp.net 4.0 and SQL Server 2005.

WMS is web based application. The project includes 8 different modules.

1. Receipt

2. Unloading

3. Counting

4. QA

5. Bining

6. Picking

7. Packing

8. Dispatch

Only authenticated users can access the system. Each user belongs

to some group which is process based. System has some special features

like System generated i.e. automated Alerts for its users about parts

or Entities like Dealer, Supplier, and Transporter etc. Alerts are

generated for each process with priority available that is set to

particular parts or entity by in charge. Reports generated on client

side requirement basis.

Contribution

. Direct interaction with clients.

. Understanding user requirements.

. Writing Views/Stored Procedures.

. Writing Web Services.

. Writing Client Side Coding.

|4. |Project Name: MIS (Management Information System) |

|Client |Dynamic Logistics, Pune |

|Role |Team Member |

|Team Size |3 |

|Environment |Languages: ASP.NET2.0, C#.NET 2.0 |

| |Database: SQL Server 2005 |

| |O/s: Windows XP |

Project Description

This system is developed to generate various reports user required to view

day in and day out. This system is web based. Also as in ICD System V3 and

WMS this system is also based on user authentication and he/she can view

only those reports, which are associated with his/her authentication group.

|5. |Project Name: CMS (Contractor Management System) |

|Client |Dynamic Logistics, Pune |

|Role |Team Member |

|Team Size |3 |

|Environment |Languages: VB6.0 |

| |Database: SQL Server 2000 |

| |Reports : Crystal Report |

| |O/s: Windows XP |

Project Description

Dynamic Logistics An ISO 2000 certified Company handling all Logistics

Activities. It Provides Services for Inbound / Outbound logistics,

Warehouse and Stores Management.CMS System Helps in Communicating with all

Contractors and maintaining Records. The System handles Bill, Manpower

calculations, MIS reports.

Contribution

. Direct interaction with Contractors.

. Understanding user requirements.

. Designing Forms, and Writing codes for different modules.

. Writing Stored Procedures.

. Analyzing bugs, studying scenario and depending upon it fixing bugs.

|6. |Project Name: HRMS (Human Resource Management System) |

|Client |Dynamic Logistics, Pune |

|Role |Team Member |

|Team Size |3 |

|Environment |Languages: ASP.NET4.0, C#.NET 4.0 |

| |Database: SQL server 2005 |

| |Tools : Crystal Reports |

| |O/s: Windows 2000/Xp |

Project Description

This project is currently at development stage.

The system is an Web application totally new System developed from scratch

on the basis of our old System Payroll System (VB 6.0,Access).The system

handles all HR Functionality, MIS reports. This System is three tier

architecture and process based.

We have done the migration of our old data to our new system from Access to

SQL Server 2005.

There are different Modules like Leave Management, Position

Management, Separation, and Recruitment. The System is developed in ASP

.net 4.0 as Front end, SQL server 2005 as back end on W2k server was used.

Contribution:

. Coded Modules.

. Developed Reports To Print various Documents

. Performance tuning

. Support for data loads.

. Involved in Change Controls implementation.

. Analysis of the specification provided by the client for Change

Controls.

personal profile

Contact this candidate