Visual Basic Sql Server

Title:Assistant Manager

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

Document

Source below

NAME: Rajani macwan

ADDRESS:

CITY: jersey city

STATE/PROVINCE: NJ

ZIP/POSTAL CODE:

COUNTRY: USA

EMAIL: *******@*******.***

PHONE: 718-***-****

CANDIDATE ID: 194582

CITIZENSHIP: US

Citizen

EDUCATION:

EXPERIENCE: 7

WILL RELOCATE: Open

RELOCATION INFO: Any

JOB WANTED: Any

RATE NEEDED:

HOMEPAGE:

HOTSKILLS: Visual Basic,OOP with C,C++,JAVA,Applet,JSP,Servlets,JDBC,Oracle with

PL/SQL,MS Access,SQL Server,ASP,VB scripts,Java Scripts,Dynamic HTML,Com/Dcom,Active

X,IIS,MTS,MS Visual Studio,Crystal Reports,MS Front Page,Visual Intra Dev,Windows

NT,2K,9x,DOS

ESUME

Rajani S. Macwan

Professional Summary

More then Six years of experience in area of Software Application Development

in Visual Basic 6.0, Visual Interdev, ADO, COM, DCOM, with major development

involvement to work with Oracle 8 as a database designer, which include writing

PL/SQL Code, design and creating database, writing store procedures and

triggers, doing indexing and clustering required with taking care off all the

integrity of system. Used different front end to work with backend in which

used Java with Java Applets, Swing, Enterprise Java Beans, JSP, Servlets, HTML,

and DHTML. Well-versed in application development using Object Oriented

Programming skills & building complex software systems as well as parallel

involvement in studying current system and designing proposed system.

Intensive Hands on experience in designing, creating medium to large high

performance distributed relational database like Oracle 8, MS SQL Server 7.0

and Microsoft Access 97,2000. Possess strong trouble shooting and problem

solving skills and good communication skill. Quick learner. Having strong

desire to master new technologies.

TECHNICAL SKILLS

Languages: Visual Basic 6.0, OOP with C, C++, JAVA, Applet, JSP,

Servlets, JDBC

Databases: Oracle 8i 7.3/8.0 with PL/SQL, MS Access 2000, MS SQL Server

7.0

Server-Side Programming: ASP

Client-Side Programming: VB scripts, Java Scripts and Dynamic HTML

Distributed Technologies: Com/Dcom, Active X

Web/Application Server: IIS, MTS

Tools: Microsoft Visual Studio 6.0, Crystal Reports 8.0, MS Front Page. Visual

Intra Dev 6.0

Operating Systems: Windows NT, Win 2K, Windows 95/98, MS DOS

PROFESSIONAL EXPERIENCE

Banking

Account

Transaction

01/01

Till Date

Client: Complete Financial Services Bank

Long Island City, NY

The application allows users to access the Loan & Mortgage system. The client

is provided access to various operations after having been successfully

authenticated. The architecture of the system has part of the system placed on

Chase's web server and part of the system (loan pricing engine) being placed on

another server maintained at a remote location by Microsoft. The system also

sends the loan data to various branches of the bank from its centralized

database.

Responsibilities:

Involved in documenting requirements specifications.

Analyzes customer requirements via interviews, Joint Application

Design, prototyping, and other methodologies for new and/or existing systems.

Identifies alternatives, recommends appropriate course of action and

creates project plan.

Used UML methodologies for component designing.

Developed server side page and scripts using ASP with Visual InterDev.

Developed Dynamic HTML/DHTML Pages with Visual InterDev.

Developed Visual Basic forms for error logging, encryption, file

handling, etc.

Write and modify ASP pages, which included VBScript, JavaScript and ADO

to connect, display, and update the database using Visual InterDev.

Document creation after querying the database, for parsing using XML

parser and handle data transfer / communication between remote servers using

XML.

Involving in developing Visual Basic DCOM Objects to apply Business

Logic.

Involving in development of Visual Basic DCOM Objects for Business

Logic.

Done the Clustering and re-indexing to improve and fine-tune the

Database.

Coding of database triggers to fire for tables in which rows are

inserted or data is being updated. Select columns and key-index fields from

these tables were to be stored into new tables in which the old values & new

values of these columns were to be inserted.

Written PL/SQL stored procedures & functions, incorporating the new

Oracle 8 feature of Bulk Select to transfer data.

Created a database of all the forms & procedures in which particular

critical tables are being updated / inserted. Reports were created to analyze

this data.

Created Packages to Encapsulation of related PL/SQL objects, Better

application design and better performance.

Configured Oracle tools like SQL* Net to access the database from

network

Developed Visual Basic forms for error logging, encryption, file

handling, etc.

Involving in development of Visual Basic DCOM Objects for Business

Logic.

Developed Active X components to reuse and create components.

Prepare documentation for the system.

Environment: Visual Basic 6.0, MTS, ASP, Oracle 8.0, COM/DCOM, VB Script and

IIS.

Inventory Management

System

07/00

01/01

Client: Computer Exchange Ltd

.

3196, Kennedy Blvd, NJ.

Design and Developed a multi-tier Client/Server Application for an Inventory

Management System using Distributed objects. Emphasis on Object level functions

and structures, object oriented techniques such as inheritance, polymorphism

For user objects.

Responsibilities:

Involved in documenting requirements specifications.

Analyzes customer requirements via interviews, Joint Application

Design, prototyping, and other methodologies for new and/or existing systems.

Identifies alternatives, recommends appropriate course of action and

creates project plan.

Write PL/SQL Scripts for the following

o To Create database user like an exiting user with except privileges.

o Log all database errors to tables.

o To Compile all invalid database object.

o To re-create all non-system indexes.

o Copy tables from one database to another.

Installation of Oracle Database Software, and Networking Software.

Involved in designing the database with Oracle 8.0, writing complex

queries, Store Procedures.

Developed Backup and Restore procedure with systems own requirement.

Debugging of Software, Including performance tuning, creating required

indexes, adding check constraints & reducing client server activity by putting

client process on the server end.

Created a database of all the forms & procedures in which particular

critical tables are being updated / inserted. Reports were created to analyze

this data

Developed server side page and scripts using ASP with Visual InterDev.

Developed Visual Basic forms for error logging, encryption, file

handling, etc.

Write and modify ASP pages, which included VBScript, JavaScript and ADO

to connect, display, and update the database using Visual InterDev.

Document creation after querying the database, for parsing using XML

parser and handle data transfer / communication between remote servers using

XML.

Developed Active X components to reuse and create components using

MTS.

Developed server side page and scripts using ASP and VB Script

according to user requests.

Developed Visual Basic forms for error logging, encryption, file

handling, etc.

Export and import of database. Backup/Recovery of Database.

Involved in SQL Tuning and backups.

Involving in developing Visual Basic DCOM Objects to apply Business

Logic.

Developed Active X components to in Visual Basic to reuse and create

components using MTS.

Performed application integration and deployment and site maintenance.

Environment: Visual Basic 6.0, ASP, Oracle 8.0,COM/DCOM and IIS.

Health Insurance Project

Client:

Paramount Healthcare Ltd

. Bombay, India.

The application software contains the complete solution for a TPA Insurance

company allowing the user to design new insurance product like managed care,

Medi claim, etc. performing complete claim process for companys clients. The

client is provided access to various operations after having been successfully

authenticated. The application also maintaining provider fees schedule and bill

payment status, it also maintain all the agent records and H.O. transaction,

and keeps maintaining Insurance Lodgment records with all the possible results

like member reimbursement or recovery.

Responsibilities:

Involved in complete life cycle of project, coding, analysis, design

and implementation of the complete client/server.

Created Packages to Encapsulation of related PL/SQL objects, Better

application design and better performance.

Involved in writing PL/SQL statements and developing server side

scripts using ASP according to user requests.

Regression test all applications against the migrated database

Development and test copies of the customer database.

Monitor the system for a few weeks for problems.

Used PL/SQL to create Triggers, Functions and Procedures as per project

requirement.

Created Triggers to check data integrity.

Created Packages to Encapsulation of related PL/SQL objects, Better

application design and better performance.

Involved in designing the database with MS SQL Server writing complex

queries and Store Procedures.

Developing the GUI front end with Visual Basic after initial analysis.

Developed various form interfaces as Visual Basic forms to insert,

update, delete, and query data.

Developed server side page and scripts using ASP with Visual InterDev.

Developed Visual Basic forms for error logging, encryption, file

handling, etc.

Write and modify ASP pages, which included VBScript, JavaScript and ADO

to connect, display, and update the database using Visual InterDev.

Document creation after querying the database, for parsing using XML

parser and handle data transfer / communication between remote servers using

XML.

Extensively used Visual Basic designing GUI to collect information form

the user.

Developed various form interfaces as HTML to insert, update, delete,

and query data.

Used Data Reports for generating different reports according to System

requirements.

Used VB Script for data validation

Analyzed existing problems and worked with team members for possible

solutions.

Environment: Visual Basic 6.0, ASP, MS SQL Server 7.0,COM/DCOM, VB Script and

IIS.

Chemical analyzing system

Client:

Alps Chemical Ltd, India.

The main function of this system is to accept the chemical reading and prepare

reports base on that. Pre Ready database should be ready to help at the same.

As well clients can do query for different chemical including price and other

factor like availability and precaution to be taken to preserve that chemical

or some formula for creating some chemical. System has member facility for

advance help.

Responsibilities:

Involved in complete life cycle of project, coding, analysis, design

and implementation of the complete client/server.

Analyzes customer requirements via interviews, Joint Application

Design, prototyping, and other methodologies for new and/or existing systems.

Identifies alternatives, recommends appropriate course of action and

creates project plan.

Installation of Oracle Database Software, and Networking Software.

Involved in designing the database with Oracle 8.0, writing complex

queries, Store Procedures.

Developed Backup and Restore procedure with systems own requirement.

Debugging of Software, Including performance tuning, creating required

indexes, adding check constraints & reducing client server activity by putting

client process on the server end.

Created a database of all the forms & procedures in which particular

critical tables are being updated / inserted. Reports were created to analyze

this data

Involved in writing PL/SQL statements and developing server side

scripts using ASP according to user requests on oracle 8.0.

Written PL/SQL stored procedures & functions, incorporating the new

Oracle 8 feature of Bulk Select to transfer data.

Developed COM components in Visual Basic to implement business logic

and for data manipulations.

Developed server side page and scripts using ASP and VB Script

according to user requests.

Developed Visual Basic forms for error logging, encryption, file

handling, etc.

Used Crystal Reports for generating different reports according to S

System requirements.

Analyzed existingproblems and worked with team members for possible

solutions.

Environment: Visual Basic 6.0, ASP, Oracle 8.0, COM/DCOM, VB Script and IIS.

Microsoft Certification Status

Title Date Achieved

Microsoft Certified Professional Aug 24, 1999

Microsoft Certified Solution Developer Sep 15,1999

Microsoft Certification Exams Completed Successfully

Exam ID Description Date Completed

029 Designing and Implementing Databases with Microsoft SQL Server 7.0

Aug 21, 1999

176 Designing and Implementing Desktop Applications with Microsoft Visual

Basic 6.0 Aug 24, 1999

100 Analyzing Requirements and Defining Solution Architectures Sep 12,

1999

175 Designing and Implementing Distributed Applications with Microsoft

Visual Basic 6.0 Sep 13, 1999

EDUCATION:

1. Bs in information and technology (Equivalent)

2. Higher diploma (IV Semester) in Software Engineering from Aptech

Education ltd.

3. Bachelor of commerce with Ad. Account as major.

Contact this candidate