Post Job Free

Resume

Sign in

Sales Sql Server

Location:
Chennai, TN, India
Posted:
July 30, 2015

Contact this candidate

Resume:

CURRICULAM VITAE

P.R. SURESH BABU MIG ***, TNHB COLONY

acq0hr@r.postjobfree.com SINGANALLUR

Mobile No. 971-***-**** COIMBATORE – 641 005

TAMILNADU, INDIA

OBJECTIVE:

SYSTEM KNOWLEDGE

Join Software development team as a Programmer / Software development coordinator and ultimately achieve the team goal and implement the system successfully.

I have good knowledge in Visual Basic .Net, SQL Server 2005/2008, PL/SQL and Oracle 10g. In SQL Server and Oracle I can create triggers and stored procedure. I can lead ERP team and maintain any business flow ERP.

I can generate reports using objects and create report in Excel and crystal reports.

I can install and maintain Linux mailserver(Cent OS) and maintaining and configure Firewall (Sonicwall)

Payroll generating through Bio-metric machine data.

ACCOUNTS KNOWLEDGE

I have good knowledge in accounts in preparation of General Ledger, Debtor and Creditor Ledger.

Creditors / Debtors Age wise analysis

Prepare Trial Balance, Profit and Loss account and Balance sheet.

Prepare Sales Tax Return and Central Excise Return

Prepare Bank Reconciliation Statement

Prepare Stock Statement

Co-ordinate with Auditors to furnishing MIS reports to filing statutory reports.

Stock movement report

Prepare purchase and sales analysis reports.

EXPERIENCE SUMMARY

Programmer - 01-08-1992 to 03-09-1993

M/s. G.K. STEELS & ALLIED IND. LTD., DINDIGUL

I have developed Payroll, Sales, Stores software in Foxpro 2.6 and overall incharge of hardware and software maintenance.

EDP In-Charge - 04-04-1994 to 31-03-1997

M/s. DJS Stock and Shares Ltd., Coimbatore

I have Developed Share Transfer package, Financial Accounts package in Foxpro 2.6 and assist the Registrar of Companies work to the Chartered Accountant.

System Analyst - 02-04-1997 to 05-05-1998

M/s. Jeetstex Engineering Ltd., Coimbatore

I have Developed Stores and Financial Accounts Package in Power Builder.

EDP In-Charge 11-05-1998 to 31-12-2002

M/s. Hamsaveni Spinners Private Limited, Coimbatore

M/s. Hamsaveni System Links Private Limited, Coimbatore

I have developed Financial Accounting package, Stores and Inventory Control, Payroll package for Hamsaveni Spinners Private Limited.

Hamsaveni System Links is a Software development concern, it is a Group concern of Hamsaveni here I was working as a Project Manager and I handled all the client side Softwares. I have handled the following clients :

Prachidhi Spinners Private Limited, Udumalpet

Ranga Textiles Private Limited, Coimbatore

Aswin Textiles Private Limited, Dharapuram

Operating System : Windows 2000, Windows 98, Windows ME

GUI : Visual Basic .Net, Oracle Forms and Reports

Database : SQL Server 2000 and Oracle 9i

EDP In charge – 02-01-2003 to 31-01-2004

Veejay Savio Lakshmi Machinery Ltd., Coimbatore

I have developed Stores and Sales packages.

oOperating System : Windows 2000, Windows 98, Windows ME

oGUI : Visual Basic 6.0

oDatabase : SQL Server 7.0

EDP Manager – 17-04-2004 to 27-12-2007

Liberblu Enterprises Private Limited, Tirupur

Overall incharge of Software and hardware maintenance and developed software to production and administration department. Basically this company is an Italian Company and once I visited Head Office in Italy and adopt their all concept in Tirupur office. Liberblu is a Garment manufacturing concern

oOperating System : Windows 2000, Windows 98, Windows ME

oGUI : VB .Net 2005 / Oracle Forms and Reports

oDatabase : SQL Server 2005 / Oracle 9i

Assistant Manager – ISD - 01-03-2007 to Till date

M/s. Sandfits Foundries Private Limited,Coimbatore

Sandfits is a Automobile spare parts manufacturing Unit. Here I am maintaining their total ERP (ICSoft) system and generate Production MIS reports and Finance MIS reports. I control datas by my own Triggers

ERP is included the following process

1. Production Module include all the process (Moulding, Melting, Knockout, shotblasting, fettling and subcontract)

2.Purchase and Inventory.

3.Finance module

4.Planning module

5.Sales module

6.Payroll module with biometric system

I have developed Payroll software and existing ERP correction and Creating New module in VB.Net through Bio-metric machine datas.

Maintaining and configure settings in Linux mail sever (Centos) and Firewall

Personal Details

Father’s Name : P.R. Rangasamy (Late)

Permanent Address : 17 Muniappan Koil Street,

Nagal Nagar, Dindigul - 624 003

Tamilnadu - INDIA

Date of Birth & Age : 16 – 05 – 1970 & 44 Years

Marital Status : Married

E-Mail : acq0hr@r.postjobfree.com

Gender : Male

Nationality : Indian

Passport Number : B1403354

Education Qualification : Bachelor of Commerce [1987-1990]

G.T.N. Arts College, Dindigul

Post Graduate Diploma in Computer Application

[1990-1991] G.T.N. Arts College, Dindigul

PL/SQL and Oracle 10G Course completed in

Redleaf, Coimbatore (December 2014)

Contact Phone No. : 091-97155 - 23260

Language known : Tamil, English and Hindi

(Read and Write)

Salary Drawn : Rs. 35,000 + other allowance

Technical Excellence

Typewriting : Tamil and English (Both Higher)

Hardware Platforms : XT/AT and Pentium /Intel based PC’s

Operating Systems : MS-DOS 6.22, Windows 95, 98, 2000, NT

Linux Cent OS, Windows Server 2003 and

Windows server 2008

Packages : Foxpro, Clipper, MS Office 2000

Database : SQL Server 2008/2012, Oracle 10G

GUI Tools : Visual Basic, VB .Net, C#, Oracle Forms and

Reports

Reporting Tool : Crystal Report, SSRS and Oracle Reports

Projects handled

Financial Accounting Package

Client : Sri Ranga Textiles Pvt. Ltd., Coimbatore

Siddharatha Exports, Coimbatore

Operating System : MS DOS 6.22, Windows 95,98, ME

This is a Foxpro based application. It has been developed for assist the Management to monitoring the financial books of accounts.. From this software we can able to prepare periodical Profit and Loss account, Balance Sheet and overhead analysis statement. Also it is very much helpful for prepare cashflow and fundflow statements for bank finance.

Payroll and Store Package

Client : Sri Ranga Textiles Pvt. Ltd., Coimbatore

Siddharatha Exports, Coimbatore

Operating System : MS DOS 6.22, Windows 95,98, ME

This is a Foxpro based application. It involves preparation of salary and other statutory deductions for all classes of employees like Permanent, Temporary and Apprentice on monthly and daily basis. It is also helpful for taking abstracts to be submitted to statutory bodies PF, ESI and other statutory bodies.

The Inventory package covers the routine purchase accounting procedures such as Raising Indents, comparing the competitive quotation, placing Purchase Order, Bill passings, maintaining stock ledgers as well as preparation of stock statements on a periodical basis.

Stores Management System

Client : M/s. Sharp Tools

Operating System : Windows 2000, Windows 98, Windows ME

GUI : Visual Basic 6.0

Database : SQL Server 7.0

This package is like ERP. It includes :

1.Production Planning Control

2.Raising Indent

3.Placing Purchase order

4.Goods Inward

5.Rejection Entry

6.Issues

Sales Monitoring System

Client : M/s. Sharp Tools

Operating System : Windows 2000, Windows 98, Windows ME

GUI : Visual Basic 6.0

Database : SQL Server 7.0

This software includes :

1.Receiving Orders

2.Sales Invoice and Spares sales invoice

3.Pump wise monthly sales report.

Financial Accounting Software, Payroll, Stores Package

Clients : M/s. Prachidhi Spinners Private Ltd., Udumalpet.

M/s. Hamsaveni Spinners Pvt. Ltd., Coimbatore

M/s. Aswin Textiles (P) Ltd., Udumalpet

Operating System : Windows 2000, Windows 98, Windows ME

GUI : Visual Basic .Net

Database : SQL Server 7.0

This software is like ERP. It is developed to support the management procedures of the Company. This software is totally integrated.

It includes

1.Cash Book, Bank Book, Journal Book, Sales and Purchase Book

2.Profit and Loss account, Balance Sheet,

3.Creditors Age wise analysis.

4.General Ledger, Debtor and Creditor ledgers

5.Monthly Payroll Register

6.Stock report

Thanking you,

Yours sincerely,

(P.R. SURESH BABU)

Reference :

P.Mahendran, B.Sc,, FCA

Chartered Accountant

Mobile No. 944-***-****



Contact this candidate