Project Sql Server
Resume:
NISHITH S KHAMBHATI
E-mail: **********@*****.***
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