Avtar Singh, IT Manager

Avtar Singh

IT Manager

Fenda Audio (India) Pvt. Ltd

Location
India - Delhi
Education
Master's degree, Computer Science
Experience
13 years, 10 Months

Share My Profile

Block User


Work Experience

Total years of experience :13 years, 10 Months

IT Manager at Fenda Audio (India) Pvt. Ltd
  • India - Delhi
  • My current job since November 2016

Responsible for ensuring the reliable performance of ERP and Systems.
Developing Reports in ERP for user’s requirements.
Developing and configuring ERP for all Departments (Sale, Purchase,
Accounts, Finance, Order Processing, Stock, Logistics) etc.
Maintaining Company’s branches (25) software within all over India.
Maintain network, printers, LAN and other Peripherals in Head Office.
Training to the new staff and new changes to the existing staff.
Participates in projects to implement, test and configure ERP systems and applications.
Resolves ERP related hardware, software and system problems of Head Office
as well as all over India Branches.
Monitors and maintains ERP systems security.
Installs new software releases and system upgrades, and evaluates and installs
patches.
Solves the issue of any query in any modules of end users.
Performs a variety of tasks, maintaining desktops, laptops and Server 2008 R2,
2012, 2016, SQL Server 2012 database backups.
Performing Database backup schedule, disk drives backup maintains.
Maintaining computers, laptops, networking, Database backup, Applications,
Printers, sharing drives, etc.
Purchasing Computer hardware products as required.
Configuring ERP reports to all departments as per requirements.
Servers maintaining, backup storage related settings.
Troubleshooting systems problems.
Help desk support.

ERP Administrator at High Star Décor LLC
  • United Arab Emirates - Dubai
  • August 2013 to September 2016

Troubleshooting, controlling and managing company’s Software and Hardware.
Duties:
* Working and supporting on customized ERP application.
* Customized according to the each departments and implementing user’s
credentials and user roles and application access authority.
* Configuration an erp according to the user’s requirements and modifying reports,
columns, queries as per Organization’s/end user’s need.
* Managing the project and implementing new software and updating the existing.
* Hardware Implementation, peripherals devices and troubleshooting.
* Responsible for sql database backup maintenance, recovery, security,
restoration.
* Diagnose and resolve technical issues of erp.
* Converting and importing the data and data entries through excel from previous
erp to the new Application.
* Troubleshooting the erp application if any bug or error and communicating the
vendor regarding major issues to an application.
* Preparing updates to each clients and server during offline.
* Daily schedule for maintenance of a server and client’s pc.
* Designing reports & printing according to the user’s need.
* Analyze and diagnose the server’s requirement for storing erp database and
application files and Backups.
* New reports, Forms, Updates are verified and training to the end user’s.
3
* Self starter, strong computerized and Organization skills

Sr. Customer Support Engineer at Logic ERP Solutions Pvt. Ltd
  • India
  • February 2011 to August 2013

Responsible for supporting the company’s customers at all level as part of any technical
support issues on Software Applications.
Duties:
* Implementation and supporting vb.net applications for Enterprise Software’s,
Retail, Pharma, Inventory, Manufacture, Payroll & Production, FMCG and
trading software’s.
* Maintaining sql database, sql queries, views, sp, triggers, Indexes and Backup
& restoring settings.
* Customer’s queries and requirements fulfill.
* Problem solving skills and strong customer's service orientation.
* Remotely service providing through different software like Anydesk, Cisco
Webex, Teamviewer, Ammyy admin to the Customers.
* Coordination and management of the information desk and call centre team.
* Ticketing process wise Customer’s service through FIFO (First In First Out).
* Understanding of Business workings including all the modules like Inventory,
HR, Project Management, Payroll, Production, Procurement, Finance,
Logistics, Retail, Hospitalization, CRM, Sale, Accounts, Banks, Taxes, Excise
& VAT, Income Tax, Sale tax etc.
* Working on mostly Accounting areas like Accounts Receivable/Payable, Taxes,
Finance, Daybook/Bank Book, Ledger, Dues Ageing and Analysis, Invoices,
LPO, Delivery Orders, Reporting, Etc.
* Working of SQL Databases versions like 2000, 2005, 2008 R2, queries, views,
joins, reports, triggers, stored procedures, etc. MDX Queries for analysis
services.
* Work with application development staff to coordinate the creation and
management of reporting environment through SDLC process.
* Working on Server Side for maintaining Database for proper checking the
details and working criteria of ERP application.
* Working with the complex queries and maintaining the each server and client
into better updated condition.
* Updating the software under new changes by the Government Taxes.
* Database upgrade, backup, troubleshooting, repairing, indexing.
* Reports, forms and new patches updates to the database through the SDLC.
* Checking Database tuning and troubleshooting.
* Better understanding of the Networking, Domain and Server/Client modules of
working on an Application.
4
* Tested and verified daily software builds using quality assurance plan.
* Maintain the company’s network infrastructure.
* Traveling to client sites to troubleshoot installation, deployment, training and
Configuration settings as per end User’s any requirement

Project Engineer/Customer Support at Tally Solutions
  • India
  • May 2010 to December 2010

Responsible for providing service for the well designed Accounting application.
Duties:
* Enterprise Application (ERP) Implementation, troubleshooting.
* Working with multiple projects and third party tools for the implementation of an
ERP.
* Customer interaction, daily meeting, training, demos, implementations,
debugging and troubleshooting the applications.
* Networking, Server, Printers and other peripherals installation and
troubleshooting.
* Online and onsite training to the valuable customers.
* Handling Daily work status.
* Understanding cost and time value.
* Applying patches in accordance with company procedures.
* Assistance with training of staff and compiling procedural documentation.
* Daily maintaining the schedule for the next job.
* Proper understanding and implementing of the customer’s requirements.
* Experienced with the daily new ups and down in SDLC

Education

Master's degree, Computer Science
  • at Punjab Technical University
  • July 2011

Master in Computer Science

Bachelor's degree, IT
  • at Punjab Technical University
  • September 2009

(

Specialties & Skills

ERP CRM
ORACLE 11G DBA
SQL Server
Customer Service
Troubleshooting
DATABASE ADMINISTRATION
FINANCE
LOGISTICS
NETWORKING
PRINTERS
TROUBLESHOOTING
UPGRADES

Languages

English
Expert
Hindi
Expert
Punjabi
Expert

Training and Certifications

Microsoft SQL Administration (Certificate)
Date Attended:
July 2017
Cisco Certified Network Associate (Certificate)
Date Attended:
September 2018
Microsoft Certified Solutions Expert (Certificate)
Date Attended:
November 2018
Microsoft Certified Solutions Associate (Certificate)
Date Attended:
August 2018
Microsoft Certified Professional (Certificate)
Date Attended:
August 2018

Hobbies

  • Music listening, Travelling, Driving and Playing Cricket