Resume

Sign in

Sql Server Sales

Location:
Palanpur, Gujarat, 385001, India
Salary:
2000
Posted:
November 28, 2017

Contact this candidate

Resume:

Udaysinh C. Vaghela

ERP Support / technical support LAN/ WAN/ Fire wall/ CCTV/ Desktop/Laptop/ Veeam Backup / Antivirus

SBS 2003, SBS 2011 System Administrator Windows Server + (MS Exchange)

SQL Server 2000/ 2005/ 2008 Database Administrator

Application developer (Microsoft VB6 + SQL Server 2008/Crystal Report + Ms Access)

With 15 + Years comprehensive experience

OBJECTIVE

To live up to the expectations of my organizations for which I will be working by giving best results in my area of work.

WORK PROFILE AND TECHNICAL SKILLS

15 + Years of ERP SUPPORT / TECHNICAL SUPPORT LAN/ WAN/ Firewall / CCTV DESKTOP/LAPTOP/

SBS 2003, SBS 2011 SYSTEM ADMINISTRATOR WINDOWS SERVER + (MS EXCHANGE),

SQL SERVER 2000/ 2005/ 2008 DATABASE ADMINISTRATOR

APPLICATION DEVELOPER (MICROSOFT VB6 + SQL SERVER 2008/CRYSTAL REPORT + MS ACCESS)

Report Designing, Administration, troubleshooting & user support of Windows 2000/2003/2010 Active Directory domain network, Routers, SonicWall firewall & Wireless Access Point, CCTV

In House Development as per management requirement like MIS, Production, HR etc.

Microsoft Outlook Mailing Client, Adding system to domain,

Complete functional knowledge and experience of Sales and Distribution System, Purchase and Requisition, Stores, Production, QC and Accounting.

End User Training & Support, Providing IT assistance to all levels of staff

Maintains all Documents as per Company’s IT Policy, upgrades or replaces hardware, OS and software systems.

Supports and maintains user account information including rights, security and systems groups

To Study the Requirement System of the Organization ( System Requirement Study- ANALYSIS)

To code for the required modules.( In House Development)

To Design all kind of Reports using present database or using new database also as per requirement.

Design Printing Format (Using Crystal Reports) All kind of Report Format Designing Using Crystal Reports

Maintenance and Troubleshooting of LAN and WAN connectivity.

Installation and maintenance of various types of Local Area Networks, using Hubs and Switches. Well experienced in troubleshooting of windows, MS office, Exchange server, e-mail and Internet based solutions, Microsoft Products and all kinds of Hardware

Installing, Maintaining and Troubleshooting – with good knowledge of IT Hardware, O/S and Application Software, Peripherals and Internet/LAN Software and Equipments.

Microsoft Outlook Mailing Client, Adding system to domain,

Maintenance and Troubleshooting and Administration of E-mail Server (MS Exchange 200x Server), Active Directory domain network, support all user's on queries and usage of system

Maintains, analyzes, troubleshoots, and repairs computer systems, hardware and computer peripherals.

Identifies Analyzes, and repair IT equipment, failures, order and replaces parts as needed.

Improving and documenting software processes Ability to communicate well with the technical team.

Knowledge of Backup, Restore & Recovery of files, Antivirus Updating.

Familiarity with a variety of tech support concepts, practices, and procedures

Works under general supervision and may perform end – user training.

ERP

Complete functional knowledge of Sales and Distribution System, Purchase and Requisition, Stores, Production, QC and Accounting.

Manage ERP software,.

Complete knowledge and experience about all module of ERP including module Purchase Order, GRN, Purchase Invoice, Sales Order, Delivery Memo, Sales Invoice, Production, Qc and financial transaction. Responsible for all this module and guide to all user if any query. If any time mistake by user in any trisection I edit or delete the transaction after checking.

Create New Item in Item Master and guide to Store & Production Department for create New Item parameter

Create New Account in Account Master and guide to Account Department for Create New Accounts and Edit Account.

Create user defined report as user requirement using crystal report from our ERP database linking different module

All kind of Troubleshooting and help to user of ERP

Administration of SQL server database and ERP software, Backup, Restore

Account

Complete functional knowledge of Maintain books, Cash book, Bank Book, Sales Register, Purchase Register, etc.

Operate Financial Transaction, Bank Payment, Cash Payment, Journal, Debit Note, Credit Note, Expense Voucher Etc.

Complete experience of Preparing Trading Account, Profit & Loss Account, Trail Balance, Balances Sheet.

Complete experience and knowledge of Accounting Package: Tally 4.5, 5.4, 6, 7.2, Profit, Focus

Work Experience

DESIGNATION

COMPANY

DURATION

It In-Charge

Gulf Mushroom Products Co. (S.A.O.G)

Sultanate of Oman

Industry Type : Food and Agriculture

14-11-2007 to 15-03-17

EDP(IT) In-charge

Gokul Refoils & Solvent Ltd. (India,Gujarat Kandala Port)

Industry Type : Food Oils & Solvent

(ISO 9001 and ISO 27001)

Oct,2006 to Oct,2007

Accountant cum EDP(IT) In-charge

Gokul Refoils & Solvent Ltd. (India,Gujarat)

Industry Type : Food Oils & Solvent

(ISO 9001 and ISO 27001)

Sep, 2005 to Sep, 2006

Accountant Cum Programmer

Balaram Auto Agency Pvt. Ltd.

Industry Type: Automobil and Spar part

(Authorised Dealer Bajaj Auto Ltd & Maruti)

Feb 2001 to Aug 2005

Computer Operator Cum Accountant

M. Kantilal Export, Surat

Industry Type: Dimand and Jewelry Mfg.

Aug 1997 to Jan 2001

PROJECTS

Project # 1 HRMS (HUMAN RESOURCE Management SYSTEM (In-House Project)

Client: In House Project, Gulf Mushroom Products Co. (S.A.O.G.)

Tools Visual Basic 6.0, SQL Server 2008, MS Access, ADO, ODBC, Crystal Reports, Windows 2003,

XP, Windows 7

Description Project was to maintain all kind of employee data like Designation, Department, Passport and Residence Card, Weekly off from date of joining the company until the date of leaving. Maintain attendance sheet with using Fingerprint Machine Data to calculate the salary of the employee with a User Access Controls.

The system will calculate Annual Leave days and amount, Sick leave with pay sheet and maintain Sick leave register, E.L and all other leave calculation as per Labour Law of Sultanate of Oman.

The system will Provide Pay sheet, Net Salary, Salary Payable, Bank wise Salary details with option export to Excel, PDF, word

Design Printing Format for Salary slip

Auto Alert for all kind of license and Company registration, like Labour card expiry, Passport Expiry, Health Card Expiry, Vehicle Registration Expiry, Insurance Expiry, company commercial License Expiry, Fire Extinguishers Expiry, Employee Uniform Expiry etc and

The system will allow data to be entered, updated and view report from multi locations as per user rights.

Project # 2 Cheque Printing

Client: In House Project, Gulf Mushroom Products Co. (S.A.O.G.)

Tools Visual Basic 6.0, MS Access, ADO, ODBC, Crystal Reports, Windows 2003, XP, Windows 7

Description Project was to print Cheque as per different bank’s Cheque for payment to party with account pay or with amount in word.

Project # 3 M.I.S, Dispatch, Daily Growing and farm Activity for Mushroom Production Industries

Client: In House Project – Gulf Mushroom Products Co. (S.A.O.G)

Tools Visual Basic 6.0, SQL Server 2008, MS Access, ADO, ODBC, Crystal Reports, Windows 2003,XP Windows 7, Hyper Terminal

Description MIS Project can record and calculate: Mushroom Rec. from growing by using Weight Machine Functionality and Effect according to, Can record daily dispatch and print gate pass or material, can record Rejection, Sales Return, Daily physical Stock, and maintain date wise stock with average. Maintain mushroom stock ledger, Reconciliation of all type of mushroom production and calculate daily moisture loss.

Project was to record batch wise and room wise all kind of activity in farm with all the stage like mixing, spawning, casing, growing, harvesting, cock out etc.

The system will allow data to be entered, updated and view report from multi locations as per user rights.

Project # 4 Weight Bridge Functionality

Client: In House Project, Gulf Mushroom Products Co. (S.A.O.G.)

Tools Visual Basic 6.0, SQL Server 2008, MS Access, ADO, ODBC, Crystal Reports, Windows 2003, XP Windows 7, Hyper Terminal

Description Weight Bridge Functionality and Effect according to it

Data collect as per Vehicle Weight Bridge, Empty weight, Load weight, Take Print material Weight and all data maintain in database, date wise, Vehicle wise, and group details wise report can view multi locations

Project # 5 Stock Maintenance (A Inventory Software)

Client: Balaram Auto Agency Pvt Ltd / Baleshwar Bajaj / Raj Motors / Meet Motors

Tools Visual Basic 6.0, SQL Server 2000, MS Access, ADO, ODBC, Crystal Reports, Windows 2000,XP Windows 95

Description Project was maintain all the spar part stock with effect sales, purchase and issue to Job card, and showing bin wise information for all the spar part with stock quantity

The system will allow data to be entered, updated and view report from multi locations as per user rights.

Project # 6 Maintenance and Job Card History

Client: Raj Motors / Balaram Auto Agency Pvt Ltd/ Baleshwar Bajaj / Meet Motors / GMPCO

Tools Visual Basic 6.0, SQL Server 2000, MS Access, ADO, ODBC, Crystal Reports, Windows 2000,XP Windows 95

Description Project was to maintain historical data for all maintenance and repairing job details with parts issue details and machine wise cost report or can maintain Job cost center, pending job and authorization, Service Tax calculation as per Indian Tax Structure.

The system will allow data to be entered, updated and view report from multi locations as per user rights.

Project # 7 Billing Software ( Sales & Purchase with inventory stock effect)

Client: Sonalika Tractor / Meet Motors Raj Motors /Balaram Auto Agency Pvt Ltd/ Baleshwar Bajaj /

Raj Motors

Tools Visual Basic 6.0, SQL Server 2000, MS Access, ADO, ODBC, Crystal Reports, Windows 2000,XP Windows 95

Description Sales Module For Billing as per Indian Tax Structure. Item Master, Customer Master, Company and Tax Master(Sales Tax, VAT), Sales Invoice and Reports

Project # 8 Accounting Software

Client: Raj Motors / Sonalika Tractor / Meet Motors Raj Motors /Balaram Auto Agency Pvt Ltd

Baleshwar Bajaj

Tools Visual Basic 6.0, SQL Server 2000, MS Access, ADO, ODBC, Crystal Reports, Windows 2000,XP Windows 95

Description Cash Receive, Cash Payment, Bank Receive, Bank Payment, Journal, Connecting with Inventory (Sales and purchase, Job and Service Bill) with full accounting effect with Payment Receipt Printing

Project was maintain Trading Account, Profit & Loss account, Trial Balance sheet, Balance sheet, All Party Account, Group wise Leger Sumer, like Account payable, Account Receivable, Indirect Expense, Direct Expense, Capital Account with full accounting effect

The system will allow data to be entered, updated and view report from multi locations as per user rights.

Project # 9 M.I.S Project for Edible Oil Industries

Client: In House Project - Gokul Refoils & Solvent Ltd.

Tools Visual Basic 6.0, SQL Server 2000, MS Access, ADO, ODBC, Crystal Reports, Windows 2000,XP Windows 95

Description MIS Project can record and calculate :- Daily & Monthly Production and Loss of oil, Row Oil Inward, Row Chemical Consumption, Row Power Consumption with Meter Reading, Steam Generation, R.O. Water Generation, Steam Cost, Power Cost R.O. Water Cost, Product Cost Per Ton, Product wise Apportionment of Monthly Administration Expenses, Power Exp., Steam Exp. R.O. Water Exp., Chemical Exp. And other exp. And after the month end we can calculate Cost per ton of oil.

The system will allow data to be entered, updated and view report from multi locations as per user rights.

PERSONAL DETAILS

Birth Date : 1st, AUGUST 1974

Religion : HINDU

Gender : MALE

Marital Status : Widowed

Mother Tongue : GUJARATI

Passport No : N4892384.

Language known : ENGLISH, HINDI, GUJARATI ( read-Write-Speak)

Hobby : LISTENING MUSIC.

Strength : DETERMINATION, CONFIDENT, HARDWORKING

EDUCATIONAL QUALIFICATION/CERTIFICATION

Bachelor of Commerce from North Gujarat University with 58 %. (Year : 1995)

D.P.C.S.C (Data Preparation & Computer Software) with 78% from Industrial Trading Institute, Gandhinager, (Year : 1996)

Microsoft Certificate of Completion “Maintaining Microsoft SQL Server 2008 Database” Course:(6231A) an official Microsoft learning product as prescribed by Microsoft Corporation.

Microsoft Certificate of Completion “Exchange Server 2011 ” Course an official Microsoft learning product as prescribed by Microsoft Corporation.

I hereby declare that the information furnished above is true of the best of my knowledge and belief.

Thanking you,

Udaysinh C. Vaghela

ac3icu@r.postjobfree.com



Contact this candidate