Manager Software

Sanjeev Kohli

House No. - ***, Sector - **, Mob : 987-***-****

Faridabad, Haryana - 121003 (India). Mail : *********@*****.***

Summary

Intend to get a position to utilize my skills and abilities into practice for mutual growth and benefit and make endeavours towards the way which is innovative, creative & excel in my field.

ERP/Software Implement design, coding, testing and supporting. responsibility for the day-to-day operations of the Project, Reporting, Planning and Tracking.

Expertise in Winforms, C#, VB.Net, MS Sql Server, Crystal Report 10. Good knowledge in HTML, CSS, Javascript, Jquery, Bootstrap, Asp.Net for ERP, EDP, MIS, Reporting and fully work process in all functional area like Procurement, F.A., Sales & Distribution, Finance, Payroll, Inventory, Production, etc.

A focused, self-motivated team member that takes pride in solving complex technology problems and delivering user-friendly solutions

In depth understanding of all stages of software development life cycle (SDLC), IT Infrastructure, LAN/WAN.

Technical Skills

Operating System : Windows-7/XP/2000, 2003, DOS

Database (RDBMS) : SQL Server 2012, Ms-Access

Programming Tools : Dot Net: C#, VB.Net, VB 6.0,

Web Tools : HTML, CSS, JavaScript, JQuery, Bootstrap

Reporting Tools : Crystal Report 10, SQL Reporting Services 2005 (SSRS)

SAP-ERP (ABAP/4, 4.7E) : Reports, BDC, Dialog Programming, Smartforms

Office Business Applications : Ms-Excel, Ms-Power Point, Ms-Word

Networking : LAN/WAN, TCP/IP, Ethernet, Hubs, Firewalls

Experience

Technofab Engineering Ltd [ 11th Jun.’2012 – Present ]

Faridabad

Deputy Manager-IT

Presently working as a Deputy Manager-(IT), responsible for all IT Activities, ERP implement, Database Security, Reporting. Technofab (www.technofabengineering.com) an ISO certified company and is a electro- mechanical Engineering and Construction Company, Power, Industrial and Infrastructure sectors, Piping Systems, Fuel Oil, Wastewater and Effluent Treatment and Recycling Systems, Tankages.

Designing & Implement ERP system, currently working on modules (Procurement, Billing, FA, Finance, Production, HR), using Tools Window Based (winforms) .net C# 2010, Sql Server 2012 and Reports in Crystal Reports 10 & ASP.Net, HTML, CSS.

Worked extensively on SQL Queries, Stored Procedures and Functions. Wrote complex Stored Procedures. T-SQL Programming skills like Tables, Views, Indexes, Triggers, Functions, Coding.

Strong RDBMS skills with excellent of Design, Normalization and Database Management Concepts.

Good knowledge in web designing using HTML, CSS, JavaScript, JQuery, Bootstrap.

Analysing Data and with the help of Sql Server and advance formulas of Excel like vlookup, hlookup, sumif, sumifs, pivot table, index & match, vba etc for ETL, MIS.

Gathered information regarding the users, workflows and produce functionality in ERP system and provide training to end user.

Co-ordinate with software vendor and evaluate, test, advise, train and support I.T. related projects.

• Also experience in manage hardware and software, Domain Server, Office 365 Mail Server, Anti Virus Server, Backup Server, Firewall etc.

Zep Infratech Ltd [ 16th Aug.’2011 – 9th Jun.’2012]

(Zeppelin Mobile Systems India Ltd), Noida

Dy. Manager-Systems (IT)

Worked as a Deputy Manager-Systems (IT) role and responsibilities of maintain Server and ERP System. Zep Infratech Ltd, Noida (Formerly Known as Zeppelin Mobile Systems India Ltd –

….2

:: 2 ::

Zeppelin Mobile System GmbH (ZMS) of Germany) an ISO 9001: 2008 and ISO 14001: 2004 certified company (www.zepinfratech.com). Zep Infratech is a part of Sintex Group. Zep is manufacturing of Turnkey Solution Provider (TSP), Shelter, Towers, Insulated Truck Bodies, Cold Rooms/stores and Insulated Panels, Ambulances and Mobile Medical Systems.

Maintained & Implemented ERP system, ERP Module (Billing & Sales, Purchase & Pricing, Accounts, HR, Banking). Updated Existing ERP Module using Tools .net C# 2010, Sql Server 2008 and Reports in Crystal Reports 10.

Worked extensively on SQL Queries, Stored Procedures and Functions. Wrote complex Stored Procedures.

T-SQL Programming skills like Tables, Views, Indexes, Triggers, Functions, Coding, Joins.

Run daily, weekly and monthly reports for management consumption (MIS) reports using Crystal Reports.

Consulted with user regularly regarding projects, technical issues that arise during the development process.

Modified existing software to detect and correct errors, improve performance, and upgrade interfaces.

Prepared reports on specifications and activities for each project.

Responsible for maintain Domain Server, Windows Exchange Server for Local Mail, Anti Virus Server, Firewall etc.

Reed Medway Packaging Compony of India P.Ltd [ 22nd Dec.’2008 – 13th Aug’2011 ]

(Chronos Richardson India P.Ltd), Faridabad

EDP Incharge (ERP Implementation)

Worked as EDP Incharge looked all IT activities, Server and ERP with VB.net, SQL Server 2005, Crystal Reports. Reed Medway one of the biggest manufacturing of Packing Machines, Weighing & Bagging Machines, Wrapping Machines, Palletisers etc for Rice mills, Fertilizer etc and has sister-manufacturing concerns Chronos Richardson, the company is MNC and manufacturing automatic bagging and discharging scales use of robotic technology from Japan/German technology. Both company has been accredited with ISO 9001: 2000 certification for the quality control management systems.

Developed & Updating the Existing functionality, customize and add new forms and implement ERP (ERSys) with C# and Reports in Crystal Reports. This ERP is Win Forms base Software includes Forms/Reports of All Modules like FA, HR, SCM, Prod., Quality etc.

Run daily, weekly and monthly reports for management consumption (MIS) reports using Crystal Reports.

Worked extensively on SQL Queries, Stored Procedures and Functions. Wrote complex Stored Procedures.

T-SQL Programming skills like Tables, Views, Indexes, Triggers, Functions, Coding.

Monitored and provided front-line support of daily processes.

Used SQL Server Enterprise Manager for the backup, restore, creation and import/export.

Preformed complete Database design, development.

Maintained the SQL database and resolves any issues, using SQL Profiler, Batch Jobs.

Plan, design and implement application database code objects, such as stored procedures. views and triggers

Responsible for hardware and software installation, maintenance and repair.

Maintain Domain Server, Windows Exchange Server for Local Mail, Anti Virus Server, Backup Server, Sonicwall Firewall etc.

Maintain Networking, Domain/User/Group, Maintain Mail Server, Installation, set-up computers, printers, and related peripherals.

Anu Products Limited [ 1st Oct.’2002 – 18th Dec’2008 ]

(Agro Chemcials Division), Faridabad

EDP Officer/Programmer

Worked as a VB 6.0, VB.net, Sql Server 2000 Developer/Programmer. Developed verity of applications for end users such as Inventory management system, Payroll, Accounts, Banking etc. Anu Products Ltd is well reputed in field of manufacturing of Agro Chemicals, Insecticides, Pesticides, Weedicides, Fungicides & Bio-Fertilizers and its formulations and analysis of Pesticides and Technicals.

To Monitor and update all existing systems like Payroll System, Material and Inventory Management System and Financial Accounting System.

Good T-SQL Programming skills like Tables, Views, Indexes, User-Defined Data types, Triggers, functions, coding.

….3

:: 3 ::

Worked on the SQL queries, stored procedures. Wrote complex stored procedures

Used DDL & DML to writing Triggers, Stored Procedures to check data entry and payment verification

Performed complete Database design, development.

Run daily, weekly and monthly reports for management consumption.

Backup & Restore Data in SQL Server.

Qualification

M.C.A. from Maharashi Dayanand University, Rohtak in 2008.

ERP – SAP/ABAP (Advance Business Application Programming) Software Development nine Month training in 2008.

Diploma in Dot Net Technologies (Vb.net, Asp.net, C#, XML) from SSI in 2004.

Diploma in Mini Computer Systems (Unix, C, RDBMS) from UPTRON, ACL in 1995.

Graduation from Delhi University in 1993.

PGDCA (IT) from Bal Bhawan, Faridabad, (Haryana State Council) in 1991

Personal Details

Father's Name : Sh. S.P. Kohli

Date of Birth : January 03, 1971.

Martial Status : Married

Passport No. : L 4637971 / (From 26.09.13 to 25.09.23)

Languages Known : English, Hindi & Punjabi

Salary Drawn (CTC) : 8.2 Lacs Per annum

Salary Expected : Negotiable (as per company norms)

Place : Faridabad

Dated :

[Sanjeev Kohli]

Contact this candidate