Sql Server C#

Prachi Kulkarni

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

Contact no: +91-770*******

Present Address: c/o Prasad Kulkarni, Flat No 604, Moraya Basil, Bavdhan Pune-411021.

SUMMARY:

Over 5.4 years of experience in IT Industry using .NET Technologies (Asp.net, C#, VB.net, SqlServer 2008) for Software development and programming in Information Technology industry and over 2 year experience in SAP B1 and crystal reports and SQL SERVER 2008.

Proficient with ASP.NET, VB.NET, C#, MS SQL Server, Stored Procedures, Triggers on Web Application.

Proficient with understanding the technical, functional specifications, design, development, and unit testing of the application

Excellent communication and interpersonal skills with proven abilities in resolving complex software issues

Hands on Experience on Excel based reporting integrated with SAP.

TECHNICAL SKILLS:

OPERATING SYSTEMS : Windows 2000/ XP /Windows10

LANGUAGE/ TECHNOLOGY : MS.Net Framework 4.5 / 3.5, MVC, ASP.NET 2.0

.NET, JavaScript, Ajax, HTML,MVC, Linq

DATABASES : MS SQL Server 2000/2005/2008.

TOOLS : Crystal Report, Visual Studio 2015,Visual Studio 2013

FUNCTIONAL SKILLS:

Strong client facing skills.

Training New Members in the team and getting them productive more quickly.

Problem solving capability peered with strong communication skills.

ACADEMICS RECORD:

Year

Degree/Certificate

Institute/School

Percentage Marks

2001-2005

B.E(IT)

Aurangabad University

72%

2000-2001

XIIth

CBSE Board

73.5%

1999

Xth

CBSE Board

74.5%

WORK EXPERIENCE:

ORGANIZATION: EclaraiantTechLabs from July2018 – Oct 2019.

ORGANIZATION: Alpha ICT LLP as Software Developer from February 2016 -April2018.

ORGANIZATION: Praxis Infosolutions from November 2011 to Oct 2013.

ORGANIZATION: Sankalp Computer’s & Systems Pvt Ltd. From Feb 2009 to Nov 2011.

PROJECT EXPERIENCE IN Eclariant TechLabs

PROJECT-1

NAME – ENVIROCARE

TEAM SIZE – 4

TECHNOLOGIES USED: C#.NET,SQL SERVER 2008/R2, JAVASCRIPT

DESCRIPTION:

This application is used for testing samples for example food products,water.This application is also integrated with SAP B1 database.

RESPONSIBILITIES :

Developed ULR Number logic for all the samples generated.

Handled many production issues and enhancement to the existing web application.

Written stored procedures, queries using SQL in SQL SERVER 2008 .

Worked on Crystal reports

PROJECT-2

NAME – METALAB

TEAM SIZE – 4

TECHNOLOGIES USED: C#.NET,SQL SERVER 2008/R2, JAVASCRIPT

DESCRIPTION:

This application is used for testing samples for example food products,water.This application is separate application very much similar to envirocare but not integrated with SAPB1.

RESPONSIBILITIES :

Handling production issues and enhancement to the existing web application.

PROJECT EXPERIENCE IN ALPHA ICT LLP

PROJECT-1

NAME – SMART PARKING

TEAM SIZE – 4

TECHNOLOGIES USED: C#.NET, MVCV4.0, SQL SERVER 2008/R2, JAVASCRIPT, LINQ,

DESCRIPTION:

Smart Parking is used to reserve parking space. Parking space can be done using web application as well as mobile app. This application basically allows users to search lot and then book the parking space whichever is available by doing the required payment transaction.

If user prebooks any space then he gets the qr code in his mail which he should show at the time of check in. This application also contains feature for number plate reorganization .With this application it is also possible to check the current status of lot.

Responsibilities :

Developed bay selection functionality for mobile app.

Developed login and registration functionality for mobile app.

Developed Revenue Share Screen and also different reports .

Handled many production issues and enhancement to the existing web application.

Written stored procedures, queries using SQL in SQL SERVER 2008 .

Developed different WCF services for Inserting records into database using specific url format.

PROJECT-2

NAME – REAL INSIGHTS

TEAM SIZE – 7

TECHNOLOGIES USED: C#.NET, ASP.NET, SQL SERVER 2008/R2, JAVASCRIPT, LINQ,

DESCRIPTION:

REAL INSIGHTS IS WEB APPLICATION TO SALE PROPERTIES ONLINE.THERE IS CONCEPT OF AGENCY,AGENT AND BRAND. FACILTY FOR CREATING NEW BUSINESS CASE IS GIVEN TO USER WHERE HE CAN SELECT THE AGENTS HE WANTS,PROPERTIES HE WANT .THERE IS FACILITY FOR ADDING PATCH WITHIN SUBURB.USER CAN ALSO CHECK WHICH AGENT OR AGENCY HAS DONE HOW MUCH BUSINESS WITHIN PARTICULAR REGION.SETTING PAGE IS GIVEN WHERE USERS CAN UPLOAD THERE INFORMATION ACCORDING TO THAT REPORT WILL BE GENERATED FOR THAT USER EX IF USER WANTS 6 TO 12 PROPERTIES IN PDF,THEN HW WANTS EVERYTHING IN MAIL OR NOT.

Responsibilities :

BUG FIXING.

DEVELOPING NEW FUNCTIONALITES IN PROJECT.

UNIT TESTING .

DEPLOYMENT OF CODE.

Written stored procedures, queries using SQL in SQL SERVER 2008 .

PROJECT-3

NAME – CAMP(CONTROL AND MONITORING PLATFORM)

TEAM SIZE –3

TECHNOLOGIES USED: C#.NET, WPF, SQL SERVER 2008/R2

DESCRIPTION:

CAMP is just like repository of all components of company.

User can upload, download, view, print files using this application.

Rights are provided for users like Contributor, Admin, User, etc.

User can also give feedback to particular document.

Responsibilities :

Developed Registration screen using WPF.

Developed screen for Displaying Error Logs using WPF.

PROJECT EXPERIENCE IN PRAXIS INFOSOLUTIONS

PROJECT-1

NAME – SERVICE PORTAL.

TEAM SIZE – 5

TECHNOLOGIES USED: C#.NET, ASP.NET, WCF, SQL SERVER 2008/R2, JAVASCRIPT, LINQ,

DESCRIPTION:

Service Portal is a web application for the customers who can register their complaints online & get the service rather than manually registering their complaints. The complain gets register, a request to corresponding person is received through email.

If request gets approved then that request further transfer to corresponding department to manage the service request. The service portal has API to save service request details in SAP. Also customer gives feedback for their service.

PROJECT-2

NAME – KOTHARI AGRITECH PVT LTD.

TEAM SIZE – 5

DESCRIPTION:

This is SAP B1 based project. Developed the production slip utility for integrating .NET and SAP B1.The main purpose of this utility was that normally the end user have to do the entries manually for issue for production, receipt for production and Goods Issue Transaction and also create production order manually. To avoid all this and to perform all the transactions at one click the utility was developed.

The related sap tables were affected in this transaction.

PROJECT-3

NAME – IBC

TEAM SIZE – 5

DESCRIPTION:

This is SAP B1 based project. Developed sales promotion scheme add on using VB.NET and SQL SERVER2008.Developed the Scheme Master, Customer Master and Quantity Master using screen painter and did related coding.

And was involved in designing the database tables related to it.

PROJECT-4

NAME – PUSHPAM FOOD AND BEVERAGES PVT LTD.

TEAM SIZE – 6

DESCRIPTION:

This is SAP B1 based project. Developed all the crystal reports for this client and developed the related procedures.

NAME – SANJAY TOOLS AND ACCESSORIES PVT LTD.

TEAM SIZE – 6

DESCRIPTION:

Sanjay Tools is trading company. We developed SAP B1 project for this client.

I was involved in developing all the sql procedures and crystal reports and excel based reports for this client.

PROJECT-6

NAME – METAFORGE

TEAM SIZE – 6

DESCRIPTION:

Was involved in finding the solutions for using barcodes in crystal reports and displaying it in sap b1.Also developed one utility in .NET for importing the clients data from excel sheet and updating the same in the database.

Responsibilities:

Understanding the technical and functional specifications.

Worked on database design, sql, Stored procedures, Cursors.

Application design, development & Unit Testing.

Worked on UI Design of screens.

Responsible for Performing testing for database.

PROJECT EXPERIENCE IN SANKALP COMPUTERS & SYSTEMS PVT LTD.

PROJECT- 1

NAME – JUNIPERUS

TEAM SIZE – 2

DESCRIPTION:

This project is developed using 3 tier architecture. In this project income depends on the number of active products. Member are provided with a transaction where they can request any product,this request is sent to admin module where confirmation transaction is provided if admin performs transaction for particular product then that `product become .The member will get income only on active products in his downline and will get income only if he is active.

Responsibilities:

Understanding the technical and functional specifications.

Worked on database design, sql, stored procedures, Cursors.

Development of ASPX pages and visual basic code.

Worked on UI Design of screens.

Responsible for Performing testing for database.

Design & Development of application

PROJECT- 2

NAME – ASHUTOSH REAL ESTATE

TEAM SIZE – 2

DESCRIPTION:

In these project members join using paid epins. These are a matrix plan 3*3 matrixes. Under one member 3 members can join at 1st level. At second level 9 and at third level 27 and so on. Three different incomes r there in these project matrix income which was given only upto 4 levels, Spill income which was given on directs after 4th direct and Trinery income based on leg count.

Reentry concept is also there in these projects.

Responsibilities:

Understanding the technical and functional specifications.

Worked on database design, sql, Stored procedures, Cursors.

Development of ASPX pages and visual basic code.

Worked on UI Design of screens.

Responsible for Performing testing for database.

Design & Development of application

PROJECT- 3

NAME – COLOR IT SERVICES PVT LTD.

TEAM SIZE – 2

TECHNOLOGIES USED: NET FRAMEWORK 2.0, C#, MS SQL SERVER 2005

DESCRIPTION:

This project is based on financial domain .In this project income is based on points (PV’s). Three different incomes are there Binary Income, Direct income and level income. In Binary Income for 1st pair income member has to bring 2:1 or 1:2 counts and member gets income on matched PV’s and unmatched PV’s are lapsed. From second pair onwards qualifying condition is 20pv and remaining pv’s are carried forward .In direct income member gets direct income on his directs but from 3rd direct onwards .In level income if the sponsors income is 1000 then members which are at 1st level will get 4% of sponsors income divided by number of qualifiers at that level. For second level members will get 3% of sponsor’s income divided by number of qualifiers at that level and for 3rd level members will get 3% of sponsor’s income divided by number of qualifiers at that level.

Responsibilities:

Understanding the technical and functional specifications.

Worked on database design, sql. Stored procedures, triggers and Views.

Development of ASPX pages and User Controls.

Worked on UI Design of screens.

Responsible for Performing testing for database.

Design & Development of application

PROJECT-4

NAME – SMS INTEGRATOR

TEAM SIZE – 2

DESCRIPTION:

SMS Integrator is a product which can be used clients to send messages (sms) for their business.

We are providing three different ways of sending sms:

Single Send-In these sms can be sending to single mobile number using sms integrator.

Multiple Send-In these we are providing bulk sms facility that is sms can be send to multiple mobile numbers at a time.

Personalized sms-In these suppose we want some common message to be sending to everyone then it can be used.

Responsibilities:

Understanding the technical and functional specifications.

Worked on database design, SQL. Stored procedures.

Development of ASPX pages and Visual Basic code.

Worked on UI Design of screens.

Responsible for Performing testing for database.

Design & Development of application

Technologies used:

.Net Framework 2.0, C#, MS SQL Server 2005, Visual Basic6.0

PERSONAL DETAILS:

Date of Birth : 12-September-1983

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

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

Contact no : +91-770*******

Gender : Female

Present Address: Flat No 604,Moraya Basil,Bavdhan Pune.

Languages : Marathi, Hindi

Marital Status : Married

Contact this candidate