Sql Server Project

DEBASISH MONDAL

Software Developer

***,*.*.* *****, Tiljala

Pin-700100

Mobile. No.-980-***-****

E-mail : *******@*****.**.**

E-mail : ***.******@*****.***

Career Objective

To obtain a long-term career with an organization, which has a strong background

and will be an opportunity to work with challenging people with excellent environment as a professional and help me to reach on the apex of the IT World.

Career Summary

-Result oriented professional with 4 years of software development on Microsoft platform.

-Hands on Experience on C#, ASP.Net,VB.Net,JavaScript,JQuery,Ajax,CSS and SQL Server.

-Good understanding of Database, Windows 7 OS, Crystal Report, Entity Framework, Linq,Rad Control(Telerik) and Applications.

-Extensive Experience in writing stored procedures with SQL Server 2005 and 2008.

Experience

COMPANY NAME JOINING DATE RELASE DATE MONTHS

GD Websolutions Pvt ltd. October on 2008 July on 2009 10 Months

MPS Infoservices June on 2012 December on 2012 7 Months

Rashmi Infotech January on 2013 April 2014 16 Months

HK Infoware Ltd. May on 2014 16 Months

itechconsultancyservices November 2015 Current

(SAPZANT)

Academic Profile

B-TECH in COMPUTER SC. & ENGG with a DGPA of 7.2 from Meghnad Saha Institute Of Technology affiliated to AICTE.

Details of 10th & (10+Diploma) standard:

INSTITUTE

BOARD

EXAMINATION

PERCENTAGE

DIVISION

Tiljala high school.

W.B.B.S.E

Madhyamik

60%

I

Saroj Mohan Institute of Technology

W.B.S.C.T.E

Diploma

68.7%

I

SOFTWARE PROFICIENCY

Summer Training: Pursued course on J2EE program from SOFTWARE

TECHNOLOGY GROUP

Operating System: MS Windows 98, XP, Windows 2000 & 2003,Windows7,Linux

Language Proficiency: Asp.net(2010),C#,VB.Net

EDMX(Entity Framework with Linq ).Telerik(Rad control)

Web Technology: HTML,Java Script, VB Script,J Query, CSS, Ajax,XML.

Data Base: SQL Server(2008,2005), MS Access

Reports : Crystal Reports

Project Done

Medical Shop Management System

It’s very needful software of a medical shop, would can watch or keep every information about that shop appositely. Object oriented programming based application and the language was vb.net with sql server. Few features are menus such as Log-in page, Registration, employee Schedule, selling information, account section, customer records (those are regular and reputed) and also some menus. By these menus user can see whole administration system of that medical shop.

Project duration: 8 months

Team Size : 4

Asset management System

It is an excellent project to keep and get data for anyone’s valuable asset. This is an object oriented programming application and build with vb.net with sql server. There are some menus such as Log-in page, Company detail, property description, property price, category item and Also some menus. By these menus user can calculates the whole asset of company very easily and perfectly.

Journey Church

It is basically a social video site from there user can see videos as they want. there are many features such as most viewed, features, series from there user can chose there videos and may get the detail and can share this link with social network like Facebook, twitter and share this link with friends by outlook express. User can search videos by video name or series name. If anybody wants to keep a note about video he can write and save it on his machine and also send it by email id. Here is an blog part from there user can keep a comment.

There is an admin part from there user can anything related with videos. Content management system, insert, update details, delete, comments permission for blog is done from here. Admin can upload videos single or group wise from your system or YouTube or anywhere.

This project language is asp.net with sql server . whole project is made by only me.

Link:www.accumensoft.com/church/churchhome.aspx

Project duration: working on 8 months

AMPL(Mining)

It is very important project to keep all records of mining related information and make a flow of works for a company of single project or multiple project.

We have used entity framework (edmx) hare with vb.net(used telerik control) and sql server 2008 as back end. We have used store procedure, function, trigger, view, transaction etc we use multiple database which is generating on the time of creating of a project with data of master information.

Hare are so many section like Account which contains Ledger A/c, Purchase A/c, Inventory which contains Good received Note(GRN), Job card, Stock Transfer, Stock Journal etc., Order Which Opening Stock, Purchase Order etc., Work-done which contains Break down, Requisition

Etc. and there are so many list and report for finalization. It’s a very important project for mining company to do there all kind of work from here including employee details.

Project duration: 2 years Team Size : 6

Pheonix Education Management System:

Working on Educational project on portion of marks entry as per financial year subject wise for a student, student information which contains student all information like a new students detail, update existing details, permanent leave of a student etc. current status of tuition fees for a student, Pay roll its sum of all financial records of salaries for an employee, wages, bonuses and deductions, report. It is developed by asp.net and sql server as backend on web application. Cessation entry it contains an employee cat stop their job termination as a reason wise. Cessation cancelation.

And making all kind of reports group wise, single wise, cross tab etc. by Crystal reports and few bar and pie chart reports.

Katalize Star:

Working on Hotel related project where after login we can see all the room status with rate. When a guest will entry as location wise, at the time of check-in all details will be registered for a single or a family but in case of family a person will be main person who booked the room and all report will came out by this person’s identity. there are so many setups which will determine the cost or rate like room fair as per category it may be general, luxury or single or double and food rate for KOT, laundry charge etc. making food bill(KOT) as per rate by quantity wise with service tax or any discount.

And at checkout time total days will be count as per check-in time wise and delivery charges, laundry charges, service tax, if any discount, tips amount all will be added in bill.

We can keep all about information of staff and maintain their salaries, joining date releasing date, increment, holidays, sifting, over time etc.

And there is so many types of report daily, monthly, yearly earnings report. Room wise report, food item wise report, table wise report, employee details report etc.

Project duration: from last 12 months

Team Size : 5

Fab Cleaning:

This is a very big project where an organization can keep their all information and transaction from here. This is an inventory system. Opening stock, Good receipt Note, quality checking, Requisition, Journal, delivery Notes, Normal Bill, Return Details, Purchase Order etc.

Here we use telerik and entity framework. There are so many masters, setups about all charges and others and transactions. We can accept order or giving order. After getting the items its go for cleaning and measure the cleaning cost with service tax and transport cost.

And there are so many reports.

Project duration: from last 8 months

Team Size : 6

Gas Distributor:

This is an important project for a gas distributor who can keep all the records and can make transactions from here. There are so may masters, setup, transactions and reports.

A distributor will enter as per branch wise.by opening stock they can collect cylinders and keep it decided store which may be central godown or branch wise godown.

After sailing those cylinders they must return that empty cylinders so there is an Empty cylinder Return interface.

Lost cylinder record and giving compensation record and maintenance by journal to the main source.

Normal billing is used for cost measurement .here Gas may be sail cylinder wise or item wise, at time of billing customer detail and billing information will be in header portion and items will be in detail section.at the time of bill creation first select the item and automatically rate, godown will show and then select a category for cylinder wise or unit wise because it will determine the unit and then give the quantity and will generate the amount.

Now taxes and delivery charges will be added with these.

And there must be another option for payment which contains two mode one Cash and another Cheque. For cheque

There will be Cheque detail portion. this is for purchasing gas.

There are another option for rental.

Project duration: from last 6 months

Team Size : 4

Many web (ASP.net) development projects have been done as a professional.

West Bengal Essential Commodities Supply Corporation Limited

Procurement Division is entrusted with the procurement of Paddy directly from farmers of the State at Minimum Support Price fixed by the Government and delivery of Custom Milled Rice to Central and State godowns.

ICDS division has been entrusted for supply of food commodities (Rice, Dal, Salt, M.Oil) to the ICDS projects

Sugar division deals for procuring of Sugar, storing and delivering to F&S Department.

Basically here we Supplier Registration, setup rate for commodity, Supplier Information, Generate MR and stock maintenance.

Supplier Godown to central godown and from there to distributor godown means stock maintenance.

Here we work this project with .net frame work C# as front end and uses somany store procedure,functions,triggers in Sql Server 2008 R2 as backend.

Link is http://wbecscegovernance.itechconsultancyservices.com/index.aspx

Personal Details

Date of Birth : 28th January on 1979.

Father’s name : Sri Sunil Kumar Mondal.

Father’s occupation : Retired State govt. employee.

Marital status : Single

Language known : English, Bengali, Hindi

Hobbies : surfing internet, listening music, watching & playing

Football & Cricket

Co-curricular activities : Active participation in college cultural activities, college

Sports and other related social activities

Strengths : Honesty, Strong will power, excellent communication

Skill.

Objective : Dedication towards my profession for the development

of the concern.

(I declare that the information given above is true to the best of my knowledge)

Dated: Signature:

Contact this candidate