RAJEEV KUMAR
Ludhiana
Summary
Dynamic ERP Manager with extensive experience at Morepen Laboratories Ltd., excelling in SQL Server configuration and project management. Proven track record in optimizing workflows and enhancing user training, leading to improved operational efficiency. Adept at vendor coordination and budget management, driving successful project outcomes through effective team leadership.
Overview
18
18
years of professional experience
Work History
Manager
Morepen Laboratories Ltd.
GURGAON
09.2022 - Current
- Company Overview: Pharmaceutical company
- Responsible for Administration of ERP System, Users, Roles, Authorization, and Maintenance
- Configurations of SQL Server, NAV Server, Windows-based Instance, or NavUserPasword Based Instance
- SQL Server Database Backup-restore, User Creations
- Responsible for functional and technical support for all the Modules of ERP
- Responsible for different project documentation and any other assignments given by management
- Responsible for Design Tables, Pages, Reports, Dataport, and Web services
- Development, enhancement, and customization of the application based on User’s Requirements
- Responsible for setting up all approval workflow like BSO, SO, PO, Bank payment approvals, and Job queues
- Configuration of Production Modules in NAV like BOM, Routing, Machine center, and Work Centre
- Support users in finishing Production orders on monthly closing
- Managing Yearly Budget and CAPEX Entries
- Pharmaceutical company
Assistant Manager
Arjas Steel Pvt. Ltd
12.2020 - 08.2022
- Company Overview: Manufacturer of Alloy & Special Steels Bars, Auto Component
- Strong knowledge of relevant SAP modules
- Good understanding of integration with other SAP modules
- Experience of systems development and project management methodologies
- Coordinate with the vendors for gathering business requirements, business blueprinting, user training, generated sap query reports, and performed data migration using LSMW procedure
- Involved in creating various Excel sheets for various Reports with the help of SQL Queries and Micros
- Provide technical guidance and support to users
- Installation of NAV server, SQL Server, and troubleshooting of NAV software on client sites
- Generation of adhoc reports in ERP as per users' needs
- Understanding department needs & implement solutions that are related to ERP System
- Responsible for Administration of ERP System, Users, Roles, Authorization, and Maintenance
- Communicate all the issues within the company and resolve the problems with the Vendor of the ERP System
- Providing training for newly recruited staff in Sales and marketing, Payroll, and Purchase modules and providing them with full support so that they can learn about the system more effectively
- Responsible for different project documentation and any other assignment given by management
- Manufacturer of Alloy & Special Steels Bars, Auto Component
Executive
Modern Steels Ltd
11.2006 - 11.2020
- Maintenance and Support of (ERP) Microsoft Dynamic Navision 2009 & 2016
- Create new Tables, Design Pages and Reports as per requirement
- Modify existing objects as per business process
- Write C/AL Code in different objects for project requirements
- Design report with SSRS Report Builder
- Write SQL Queries and Integration with Excel to get real time data in excel
- Create RapidStart Package for Import-export data to Master Tables like Vendor, Customer, and Item
- Set various No
- Series according to user requirements in modules like Finance, Sales, and Purchase and maintain posting dates
- Involved in different tax setups like GST, TDS, and TCS for business functionality
- Create different TAX structures as per user’s requirement
- Worked on preparing Roles (Both newly defined /existing) and assigned
- Permission to various users as per their activities in the company
- Change Menu-suit display according to the User ID
- Give End-user training to show functionality and workflow in MS NAV
- IT vendor management
- IT procurement and vendor contract negotiation/management
- Maintain inventory records and controls process when moving or swapping hardware
- Troubleshooting and diagnosing desktop support issues
- Maintain AMC, Windows, and other Application licenses
Education
Advanced Diploma - Computer Application
Alfa ITI
Hamirpur, H.PMSC - IT
Punjab Technical University
Skills
- ERP administration
- SQL server configuration
- Data migration
- Database management
- User training
- Process improvement
- Project management
- Vendor coordination
- Budget management
- Team leadership
- Technical support
- Project planning
Hobbies and Interests
Playing Chess
Projects
Involved in the upgrade from NAV 2009 to 2016, I subsequently developed over 50 new reports and numerous customizations
Successfully customized and implemented a gate entry system linked to purchase orders for efficient document generation
Successfully upgraded the payroll system from NAV 2009 to 2016
Updated the version from CU 19 to CU 60
I was part of the SAP Implementation Team, participating in BPD, and data gathering My responsibilities included data migration, training, UAT, cutover, go-live activities, and support
I also implemented QR code generation on packing labels and quarantine labels within NAV 2016
Personal Information
- Date of Birth: 12/20/81
- Marital Status: Married
Other Responsibilities
- IT vendor management.
- IT procurement and vendor contract negotiation/management.
- Maintain inventory records and controls process when moving or swapping hardware.
- Troubleshooting and diagnosing desktop support issues.
- Maintain AMC, Windows, and other Application licenses.
Languages
Hindi
First Language
English
Proficient (C2)
C2
Punjabi
Intermediate (B1)
B1
Timeline
Manager
Morepen Laboratories Ltd.
09.2022 - Current
Assistant Manager
Arjas Steel Pvt. Ltd
12.2020 - 08.2022
Executive
Modern Steels Ltd
11.2006 - 11.2020
Advanced Diploma - Computer Application
Alfa ITI
MSC - IT
Punjab Technical University
Similar Profiles
SAMRIDHI SHARMASAMRIDHI SHARMA
NA at Morepen Laboratories Ltd.NA at Morepen Laboratories Ltd.
PITAMBER VERMAPITAMBER VERMA
Project Manager at Morepen Laboratories LtdProject Manager at Morepen Laboratories Ltd
Pratik MistriPratik Mistri
Deputy Manager in ADL at Morepen Laboratories LtdDeputy Manager in ADL at Morepen Laboratories Ltd