Sql Server Visual Basic

Jagdip Joshi

***** ******** *****. ****** ** ****4

Phone: 586-***-**** Cell :248-***-****

Email: ************@*****.*** ******@******************.***.

Certifications Microsoft Certified Professional (MCP)

Microsoft Certified Solution Developer (MCSD)

Microsoft Certified Database Administrator (MCDBA)

Microsoft Certified Trainer (MCT).

ID 2159517.

Systems Windows 95/98,WindowsXP Windows NT 4.0, Windows

2000,Windows 2003, Windows 2008, Windows7, Windows 8

Language/Tools Visual Basic 6.0, Visual Basic .Net 2005, .NET 2010

SQL, HTML, Active Server Pages, VBScript, J, Visual

InterDev, ADO, XML, Crystal Reports, BizTalk Server

2000/2002, COM/COM+, ASP.net

Databases Microsoft SQL Server 6.5-2012, Access, Oracle, Clarion,

OLAP knowledge

Networks Windows NT 4.0, Windows 2000

Industry Logistic Support, US provincial government, Web-based

Experience training, Warehouse management, Automotive

manufacturing, Dot.Com, Telecommunications,

Construction, Public Sector

Teaching Teaching Microsoft Certified Courses at Quilogy Inc.

Experience Troy MI ( 2 years)

#2073 Programming a SQL Server 2000 Database

#2071 Querying MS SQL Server 2KTransact-SQL

#2663 Programming with XML and the .NET Framework

#2310 ACL ASP.NET Web Apps with VS .NET

#2072: Administering a Microsoft SQL Server 2000

Database

Project Logistic Support Application (Electronic Pool and

Experience Distribution)

(epadonline.com)

Design and Developed ePAd. Application

Design and Developed AIMS Application

Design Gumro and Associates 's Web site

Developed GNA Database and Analysis Services

Technical Support to ePAD and AIMS

Designed Reports in Microsoft Access 2000 and Crystal

Report

Environment: SQL Server 2000, SQL Server 2005, SQL

Server 2008, Visual Basic 6.0 Visual Basic .NET 2010.

BizTalk Server Application

Working with BizTalk Server 2000 (Beta 2) since November

2000.

Working with BizTalk Server 2000 (Enterprise) since

January 2001.

Working with BizTalk production team to develop and test

questions for BizTalk Server 2000 Certification Exam.

Interacting with Microsoft production team members for

BizTalk server issues.

Researching and testing BizTalk Server 2000 Enterprise

Features.

Developing demo and presenting BizTalk Server 2000 for

Microsoft Rapid Web Development Conference

(BizTalk Server 2000, COM+, MSMQ, ASP, XML, SQL Server).

Developed demo and presentation on BizTalk Server 2000

for GM at CIO level.

(BizTalk Server 2000, COM+, MSMQ, ASP, XML, SQL Server).

Analyzing existing businesses and providing

recommendations for possible BizTalk solutions to the

following clients: Providence Hospital, Detroit Edison.

Teaching BizTalk Server 2000 Microsoft Official

Curriculum.

Environment: Visual Interdev, BizTalk Server 2000 Beta,

Visio 2000 SR-1 and SQL Server 2000.

Web-based Training

Served as a subject matter expert in SQL Server 7.0:

Administration distributed application development and

remote computing.

Responsible for quality assurance on the training

material, which included textbook chapters and

Power-point presentation.

Environment: Training, Windows NT 4.0, and SQL Server

7.0.

Automated Manufacturing

Involved in the development of an application "Recruit

Right" which was designed for IT professional to keep

track of complete information.

Participated in forming business rules.

Created user input screens with Visual Basic.

Extensively used custom controls.

Environment: Manufacturing, Visual Basic 4.0/5.0,

MS-Access 95, Windows 95

Public Sector

Team member in design of solution presented to Michigan

Legislature for the automated drafting of laws and

storage of laws in XML database.

Environment: Windows 2000, SharePoint Server, .Net and

SQL Server 2000.

Dot.Com

Team member on the development of a public website

offering coupons on-line.

Used Visual Interdev to create Active Server Pages page

written in VBScript hosted by Internet Information

Server 5.0.

Wrote Visual Basic COM+ server side components.

Used XML to create and manipulate a shopping basket.

Wrote Stored Procedures for SQL Server backend.

Used technologies such as ActiveX Data objects, CDONTS,

and Remote Data Services. Project Duration: Five

months.

Environment: Windows 2000, SQL Server 7.0

Warehouse management

Redesigned and changed existing Resku (Access

Application) warehouse management system in VB6.0 and

MSSQL6.5 to have more functionality according to the

client's requirements.

Used Unbound, DbGrid Control, Calendar Control, SSTab

control.

Used ODBC driver for remote connection and Jet 3.51 for

Access Database.

Environment: ReSku, Windows 98, Visual Basic 6.0, SQL

Server 6.0, & Access.

Financial Institution

Designed and developed FRP (Financial resource and

planning) for financial forecasting. The system was

developed to support the Financial Analysts who do

financial forecasting with a number of different

criteria and assumptions. Reset the assumptions and

provided complete analysis of the existing and future

financial situation with available resources. The

system also provided detailed analysis of each criteria

and assumption.

GUI interface was designed in VB6 and the database was

developed in MSSQL 6.5.

Extensively used Spread Control and Tree view Control.

Environment: FRP System, Windows 98, Visual Basic 6.0,

SQL Server 6.0

Manufacturing

Involved in the development of an Inventory Control

System. The system was created to track inventory,

cost, and floor space utilization for all of the

different products. It interfaced with both the

manufacturing system and the sales system.

Participated in forming business rules and process

logic.

Created user input screens for features of Visual Basic

4.0, such as OLE Automation, and extensively used DB

Grid and Sheridan custom controls.

Environment: Manufacturing, Oracle 7.1, Visual Basic

4.0, Crystal Reports 3.0, Windows 95.

Involved in the design and development of an estimating

and costing system. The system provided functionality

to precisely calculate the manufacturing cost of

automotive parts. It enabled the user to enter

information about available resources to get the optimum

manufacturing cost with a consideration for the time

involved.

Interacted with the users during development phase to

obtain requirements.

Provided user and system documentation and user

training.

Environment: Manufacturing, Visual Basic 4.0, Access

2.0, and Windows 95

Warehouse management

Designed and built Resku (Pission) warehouse management

system. Pission is a scan gun device with a GUI

interface. The application was built with Oval and

executed on the Pission device. The application process

"RECEIVE ORDERS," "PICKORDERS," "CYCLECOUNT" etc. The

system included import and export functionality from the

Pission database to Microsoft Access 97.

Responsible for design, development, and implementation

of user documentation and training.

Environment: Warehouse Management, Windows '95, Oval

5.0, Pission 4.0, and Access 97

Designed and built Resku RF (RESKU RADIO FREQUENCY)

warehouses management system. The application was

designed to run on Windows 95 and was linked through a

radio frequency device to scan guns in a multi-instance

mode. The application capabilities included maintaining

inventory level, scanning of new orders, move existing

orders, viewing of orders and cycle counts. The software

was build using Visual Basic with SQL Server and Access

as the supporting database.

Was responsible for the design, development and

implementation of user documentation and training.

Environment: Warehouse Management, Windows 95, SQL

Server 6.5, Access, Visual Basic 5.0

Telecommunications

Involved in the design, development and maintenance of

the EBP System. The system extracted the invoice from

the mainframe and placed in the queue database, which

was programmed in MS SQL 6.5. The invoice was then

reviewed by the end user, approved and sent back to the

mainframe. The bill payment review module gave the end

user functionality to review the invoice and change the

status to paid or unpaid. Status reports were then

generated for the paid invoice and emailed the

authorized person.

Environment: Telecommunications, Windows NT, MS SQL

6.5, Visual Basic 4.0 (32 bit), Crystal Reports 5.0

Construction

Participated in the design and development of a Project

Information System. The system enabled the user to

maintain and enter the information about existing

projects, budget, status, and various activities

concerning the project. The database was designed in

Oracle 7.0 and was connected through ODBC.

Created database tables, complex forms and program

specifications.

Environment: Construction, Oracle 7.0, Visual Basic

3.0, Crystal Reports 2.0, and Windows 3.1

Developed a Planning Approval System, which was designed

to replace an existing manual system to analyze and

approve drawings and specifications for proposed

construction projects according to regulations. The

system was integrated with an existing geo-technical

information system. Work involved writing database

triggers and functions.

Environment: Construction, Oracle 7.0, Visual Basic

3.0, and Windows 3.1

Education University of New South Wales, Sydney, Australia

Master of Engineering (2 years)

Birla Engineering College, V.V Nagar, Gujarat, India

Bachelor Of Engineering (4 years)

Work Experience Gumro And Associates

Position : VP of IT

Period : July 2004 - Till Today

Contact : 248-***-****

HTC Global Inc.

Position : Project Manager

Period : August 2003 - June 2004

Contact : 248-***-****

Quilogy Inc.

Position : Sr. Programmer

Period : April 2001 - July 2003

Contact : 866-***-****

4) Spherion Technology

Position : Computer Systems Analyst

Period : January 2001 - March 2001

Contact : 314/288-2151

5) Solutech Inc.

Position : Computer Systems Analyst

Period : September 2000 - December 2000

Contact : 866-***-****

Contact this candidate