Post Job Free

Resume

Sign in

Project Sql Server

Location:
Surat, GJ, India
Posted:
April 15, 2014

Contact this candidate

Resume:

NISHITH S KHAMBHATI

( : 026*-*******/982-***-****

E-mail: acdoo4@r.postjobfree.com

More than 15 years of experience in developing and maintaining

Hardware and Software's at various levels.

Career Objective

I am a seasoned software developer with a variety of skills

encompassing a variety of languages and platforms. I am seeking an

opportunity to make a significant contribution either as an individual

developer or as a member of a software team.

PROFESSIONAL PROFILE

. Over Fifteen years of experience in diversified fields of Application

Software Development and implementing Billing and Business projects.

. Worked extensively in Visual Basic 6.0, VISUAL BASIC 2012, VISUAL C#

2012, SQL Server 2012, ASP.NET 3.5, MS-Access, FOXPRO 2.6 and ORACLE

8. Expert in Application & Development Tools like D2K, API, OLE

AUTOMATION REPORTING TOOLS, CRYSTAL REPORT 9.0, DATA REPORT, ACTIVE

REPORTS & VBA.

. Extensively worked on ERP Projects and creating different report for

management requirement and analysis

ACCOMPLISHMENTS

. Received awards for automatic paging transmission for all

subscribers or selected subscribers.

. Received an appreciation letter from DOT and WIPRO for developing

s/w of complaint paging and helping them in call center.

SKILLS SUMMARY

Languages Visual Basic 6, Visual C#, VB.Net, ASP.Net.

PLATFORM SUN AND WIPRO

Databases SQL Server 2012, Oracle 8, MySql, MS Access, FOXPRO

2.6

OS/Servers SOLARIES 5.7, SCO UNIX 5.0.4,WINDOWS 98,WINDOWS NT,

WINDOWS 2008

Application Tools D2K, VISUAL BASIC 6,API, OLE AUTOMATION

REPORTING TOOLS CRYSTAL REPORT 9.0, DATAREPORT,

ACTIVE REPORTS,CHARTDIRECTOR CHART REPORT.

PROFESSIONAL EXPERIENCE

COMPANY PROFILE Spectrum Dyes & Chemicals Pvt. Ltd.

April 2006 - Till Date

Deputy Manager

Job Profile

. Currently working on ERP project using Visual Basic 6 and SQL SERVER

2012 For Spectrum Dyes & Chemicals Pvt. Ltd. Also Developing ERP using

Visual C#.Net 2012 for the same.

. Define, plan, direct and coordinate activities to deliver assigned

projects within the approved scope, schedule and cost.

. Manage multiple projects of varying complexity simultaneously.

. Design and developed Modules for Accounts, Maintenance, Dispatch &

Logistic Department.

. Developed extensive financial reports up to trial balance using

crystal reports 9.0.

. Track and Responds to operational problems on client site.

. Acting as a DBA for backup of SQL server database and OS.

. Reporting the progress of the project on day to day basis to the

higher management.

Project Name: ERP For Spectrum Dyes & Chemicals Pvt. Ltd.

It is a complete enterprise wide business solution that attempts to

integrate all departments and functions in a company into a single

computer system. It consists of software modules such as: marketing

and sales, production and inventory control, human resources, finance

and accounting, and information services. Integration between the

modules is stressed without the duplication of information.

. Participation in all phases of project life cycle, design, develops,

test, debug, maintain, and update, as well as the development.

. Worked as a senior Programmer, providing a wide array of software

expertise in building an ERP for Marketing & Sales, Accounts,

Engineering & Technical Department.

. Successfully constructed, tested, documented, and implemented all

projects into production.

. Successfully created and implemented MIS Reports as per company'

requirement which will add value to the analysis and decisions of the

higher management.

. Applied my expertise in creating utilities such as Database Backup &

Database Restore, Accounts Merge and Reminder utility.

. Technologies used include Visual Basic 6, Sql Server 2000 and CRYSTAL

REPORT 9.0

COMPANY PROFILE Microwave Communications Ltd. Jan 1995- July

2005

EXECUTIVE - SYSTEMS

A HFCL Group Company, under the brand name of (PAGELINK) engaged in

Sales of Pagers & providing Radio Paging Services, having Joint

venture with Shinawatra International of Thailand. Providing Service

of Fax over Internet tied up with Macrofax US.Call Center Business.

Job Profile

. Overall responsibility for online paging system for 24 Hrs.

. Generated Billing of Paging with following activities. :

. Keeping track of individual subscriber billing with different paging

model, schemes and billing cycle.

. Maintaining record of different "Value Added Service".

. Successfully developed printing form of bill as per Business

requirement.

. Developed and tested various Management reports for further analysis,

which helps management to understand market strategy.

. Analyses and developed varied module for accounting purpose to reduce

duplication of work and possible error.

. Developed module based scripts to reconcile data from different

sources which will tremendously reduce time and enhance efficiency in

reconciliation.

. Developed software for call centers.

. Responsible for periodic backup of oracle database on weekly basis and

Account server backup on regular basis.

. Maintaining accounting software (FACT).

. Making Call Center Reports In Visual Basic 6 using oracle database

connectivity with the help of OLE Automation.

. Maintaining Network of paging and Internet.

. Co-ordination with franchise for maintaining Hardware condition up to

date to make smooth operation.

Project Name: Billing & Query System

. System developed for Billing and Accounts Department.

. This s/w is useful to view the Customer detail as well as Billing

detail. Through this module Billing department can explain details to

customer of his billing with his outstanding and various charges like

Rental, Maildrop, OAP, Intercity etc. Billing and Customer Care

department can view details of customers and his all billing cycle.

. Responsible for developing modules for payment and adjustment entry

view, Cycle wise billing analysis and as on date debit and credit

customer's bifurcation in various VAS.

. Technologies used include Oracle - 7, Forms 4.5 and Fox base, SCO-Unix

Project Name: Address Verification Module

. System developed for Customer Relation Department who are responsible

for Address verification of Customer after new Activation.

. This module keeps track of every customer and follow up with customer

till 15 days as per procedure. E.g. On second day they have to call to

customer and confirm the address. Due to any reason if address is not

verified then on third day they have to send post-card, on fifth day

they have to call again, after ten days we have to page etc.

. Responsible for making all entry, follow-up and reports.

. Technologies used include Fox base and SCO-Unix

Project Name: Complaint and Follow-up System

. System developed for Customer Complaint entry and Follow-up.

. This module is helpful to all departments. As when complaint launch at

CCU it is entered in this module and pass to concern department. E.g.

If it is related to pager fault complaint should pass to service

department and if necessary pager should send to concern company. In

this complaint track of pager sent to vendor also should be kept.

. Responsible for making follow-up module. Developed a single window

screen through which all department can enter the status as per their

rights and view the details.

. Developed different reports for pending complaints.

. Technologies used include Oracle - 7,forms 4.5 and SCO-Unix

.

Project Name: Mass Paging Module

. System developed to send automatic message to multiple customers as

per requirement.

. Through this module any department can send message to particular

customers as per their criteria.

. Technologies used include Fox Base, PC Plus and O/S: SCO-Unix

Project Name: Call Centers Module

. Module developed for various customers. Through that company can

continue various Call center. We had a call center like Zee Malamal

contest, OM Kotak Mahendra life Insurance, Hotel Surya etc.

. Responsible for making product as per customer's requirement and

questionnaires. Apart from that daily or hourly report should reach at

customer place automatically.

. Technologies used include O/S: Solaris 5.7, Oracle 8 and D2K

Project Name: Receipt module

. System developed for front cash counter.

. With this s/w Cashier can generate receipt and print it online. They

can modify, delete and enquire also. Through this module Accounts

department do not need to enter payment entry after receipt entry.

Receipt will directly reflect against bill also. Apart from that

Accounts can generate different daily and monthly reports also.

. Responsible for allotting job to member and making main addition

module and reports.

. Technologies used include O/S: Solaris 5.7, Oracle 8,D2K and Pro*C

Education Description

Qualification Board/University Passing Year

S.S.C. G.S.E.B 1989

H.S.C. G.S.E.B 1991

B.COM S.G.U. 1994

Professional Qualification

Course Institute Year

Diploma In Information System Aptech Computer 1995

Management Institute

Progrsss Informatics Computer 1999

(C,C++,UNIX,ORACLE,D2K,POWERBUILDE Institute

R)

Mastering In Visual Basic 6 Karrox Computer 2002

Institute

HTML,ASP.Net,C# Aptech Computer 2013

Education



Contact this candidate