Sql Server Project

Manisha Sawant

*** *** *****

Hauppauge, NY *****

Phone: 631-***-****

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

PROFILE

I have more than 10 years of commercial experience in design and

development of software applications. I have U.S. Green card. I have

extensive experience with following

* ASP.Net, C#, VB.NET * SQL Server 2005 & 2000, MS ACCESS

* Crystal Reports * VB script, JavaScript, HTML, XML

* VB6, Classic ASP, JQuery * Visual Studio 2005/2008, MS

Front Page

MAJOR PROJECTS

Name of the Company : Transportgistics (url: www.transportgistics.com)

Duration: from Feb 2005 - Till Date (as Senior Analyst Programmer)

TransportGistics is a global, multi-product and services company that

provides market leading, simple, incremental solutions for transportation

management and logistics functions within the supply chain. Company's main

business is Transportation Management.

Company : Transportgistics, Bohemia, NY

Team size : 5

RDBMS : SQL Server 2000 & 2005, MS-Access 2000

Tools : Visual Studio 2008, Visual Interdev, Front Page

Reports : Crystal Reports 9, CR XI

Release 2 version, Acrobat

Languages :ASP.Net, C#, ASP, VB6, VBScript,

JavaScript, JQuery

Key Responsibilities:

. Maintaining & enhancing various products of the company, such as

. www.TGIRater.com, www.Transportgistics.com/TGIBID,

www.InsourceAudit.com, www.RoutingGuides.com, www.BLGEN.com,

www.FreightTracing.com. www.TGIRater.com

. Developed new web sites using ASP.NET (Visual studio 2005 & 2008, Visual

Web Developer 2008 Express Edition) with C# and VB.Net. (Full life cycle

experience).

. Understanding customer requirements and writing design specifications.

. Writing database stored-procedures, modifying existing databases as per

client's requirements, using Web Services, designing new reports, new web

Services etc.

. Created middleware COM components/DLLs using VB6 for multi-tier

applications.

. Migrating database from SQL Server 2000 to SQL Server 2005

. Migrating from Crystal Reports 9 to Crystal Reports XI Release 2 version.

Name of the Company : Sales Lead Management (url: www.slmbiz.com)

Duration: from Aug 2004 - Jan 2005

Sales Lead Management provides software and leads data to stockbrokers. SLM

also markets complied data generated from multiple resources and providing

it's client unique alternatives in finding high and ultra net worth

prospects. I worked on The Broker's e-Vantage project exclusively. Wrote

complex search engine to find required leads from database and buy those

leads online.

Company : Sales Lead Management, Melville, NY

Team size : 9

RDBMS : SQL Server 2000, MS-Access 2000,

Tools : Visual Studio .Net, Visual Interdev

Reports : Crystal Reports, ACCESS

Key Responsibilities:

. Gathered functional requirements while having discussions and interviews

with the users and sales manager.

. Designed the package/code layout for the application to organize the

application into manageable modules.

. Design new databases, tables, stored procedures and views.

. Created stored procedures that interacted with local server, remote

server, development server and production server.

. Performed database design, code review, and creation of various modules,

and implementation at the client side, bug fixing, client support etc.

. Encapsulated all data logic into stored procedures, and eliminated all

direct SQL calls and created Database triggers.

. Involved in QA testing using different tasting tools, Unit and system

test applications prior to deployment

Name of the Project : FireMaster (URL: www.alertmaster.com)

Duration: from Feb 2004 - Aug 2004

Project details: This is complete software application developed for Fire

Department. I am involved with all aspects of the software development

including analyzing, design, development, reviews, documentation, quality

reviews, testing and implementation.

Company : DECOM, West Babylon, NY

Team size : 4

RDBMS : SQL Server 2000, MS-Access 2000, ORACLE 9i

Tools : VB.Net, VB6, Visual Interdev, HTML, XML

Reports : Crystal Reports 8.5, VB6

Reports

Key Responsibilities:

. Gathered functional requirements while having discussions and interviews

with the business analysts.

. Created stored procedures that interacted with local server, remote

server, and inserted data using Linked Server functionality.

. Encapsulated all data logic into stored procedures, and eliminated all

direct SQL calls and created Database triggers.

. Understanding and analyzing user requirements.

. Programming in VB.Net.

. Testing and debugging existing applications.

. Writing Crystal reports

Name of the Project : LARA Systems

Duration: from Mar 2002 - Feb 2004

Project details: This is complete software application developed for

Finance Industry. I was involved with all aspects of the software

development lifecycle including design, translating functional business

requirements into technical specifications development, reviews,

documentation, quality reviews, testing and implementation's. I got

complete life cycle experience of this project.

Company : LARA Technologies Inc, Hicksville, NY, U.S.A.

Team size : 12

Hardware : IBM-PC/AT/586

Operating system : Windows 2000, Windows-NT 4.0, UNIX

RDBMS : SQL Server 2000, ORACLE 9

Tools : .Net, VB6, Visual Interdev, HTML

Reports : Crystal Reports

Key Responsibility:

1. Understanding and analyzing user requirements.

2. Translating functional business requirements into technical

specifications.

3. Designed and developed the business rules and logics from the existing

rules.

4. Designing databases and writing stored procedures and triggers.

5. Created dynamic queries and tables according to system requirements,

normalization of existing database to improve speed and performances.

6. Designing screens and developing COM Components.

7. Designing and developing ASP pages using .Net

8. Worked extensively with Object Oriented Programming

9. Solving client's queries and customizing software as per client's

requirements.

10. Prepared test cases for developing systems.

Name of the Project : BLS Limousines(URL : www.blslimo.com)

Duration: from Jan 2001 - Feb 2002

Project details: This application was developed for BLS limousine services

to facilitate online Reservations, online Confirmations and print Invoices

in Crystal Reports.

Company : Multiple Technologies Inc, Bohemia, NY

Team size : 6

RDBMS : SQL Server 2000, ORACLE 8i, DataFlex

Tools : ASP, Visual Interdev 6.0, IIS, Crystal Reports,

Rational Rose

Key Responsibilities:

. Responsible for enhancements, automation, smooth functioning, and

maintenance of the browser based application, which used SQL Server

2000 as a back end, and ASP as front end.

. Designed and developed the User Interface using HTML, VB Script, Java

Script, Front Page.

. Worked on Windows CE for Pocket PC Development.

. Designed and Developed class components in VB6 for accessing SQL Data,

stored procedures.

. Created custom error handling ASP pages.

. Developed back end stored procedures and triggers.

. Worked on Rational Rose

Name of the Project : Estate Gazette Interactive (URL: www.egi.co.uk)

Duration: from July 2000 - till December 2000

Project details: This application is developed for publishing industry. EGI

is the leading on-line news, research and information service for the UK

commercial property market.

I work on this website exclusively guides in residential and commercial

property tax

Assessment, Exemptions, and claims. I wrote many critical and complicated

search engines for different clients.

Company : Reed business information systems, London, UK

Team size : 22

RDBMS : SQL Server 7.0

Tools : VB 6.0, ASP 2.0, Visual Interdev 6.0, MTS, IIS 4.0

Reports : Crystal Reports

Key Responsibilities:

Understanding user requirements for the searching architecture.

Designing and developing ASP's using VBScript and JavaScript.

Developing VB COM components.

Designing Databases, tables in SQL Server.

Writing database stored procedures, creating views.

Create Full life cycle documentation.

Name of the Project : Aries Business System

Duration: from June 99 - July 00

Project details: This is complete software application developed for

publishing industry and book's trade. It contains different modules such as

Accounting, Order Processing, Contacts, Goods-in, Stock and Subscription

etc. I got full project life cycle development experience while developing

complete Accounting system for this application which includes different

modules e.g. Sales Ledger, Purchase Ledger, Payments, Receipts, Bank

Reconciliation etc.

Company : Aries business Systems, Cheltenham Spa, UK

Team size : 8

RDBMS : SQL Server 7.0, MS-Access 2000, ORACLE 8

Tools : VB 6.0, ASP 2.0

Reports : Crystal Reports

Key Responsibility:

11. Understanding user requirements for accounts module (e.g. Sales Ledger,

Purchase Ledger, Bank, Nominal Ledger, Journal entries etc.).

12. Designing and developing Accounts modules using Visual Basic.

13. Creating COM components creating DLLs and Activex Controls in VB 6.

14. Designing database and writing stored procedures, creating views in SQL

Server.

15. Developing custom reports using Crystal Reports 8

Contact this candidate