Pranab Ghorui

MBA, Graduate in Science, ERP, Automation and Digital Transformation, Dynamics 365 F&O Functional Leader and result oriented dynamic IT Professional having 24+ years of experience in Software Development, IT Support, Project Planning & development, Requirement Analysis and Team Building – Application Software and Production Industries.

Currently

Associated with DIAMOND BEVERAGES PVT. LTD., KOLKATA as Manager IT & System and looking after Dynamics 365 F&O as Functional Leader and Customized Report building in Power BI and Easy Report system. Highly resourceful in interacting with clients/Vendors, coordinating with technical team and rendering production support.

Demonstrated problem analysis/ resolution skills, ability to troubleshoot, solve problems quickly & completely. Adept at mapping user requirements, custom designing solutions & troubleshooting for complex IT related problems. Excellent mentor and coach with an ability to take up challenges and perform in changing work environments.

Demonstrated ability to motivate staff to maximum productivity and control costs through the most effective uses of manpower and available resources.

Extensive

Project experience and quick adaptability to changing trends and technologies with comprehensive knowledge of software solutions. Analytical abilities and creativity to build up competitive advantage & contribute to the growth of the business. Excellent temperament to multi-task & coordinate various activities under high pressure and time constraints.

Manager IT & System - DIAMOND BEVERAGES PVT LTD, KOLKATA (Unit of Coca Cola Bottling Plant) - Kolkata

(2019-06)

Applications: Dynamics 365 F&O with Production module, Jaguar (Sales and Distribution system for Beverage Industries), SFA Ultralite (Sales Force Automation system of Online Order and Billing Process in Market). Advance Analytics Power BI and Easy Report Software. Platforms & Tools: Oracle, SQL Server 2014, VB.NET, Power BI, Easy Report, Microsoft Azure.

• System Implementation and Support (D365 and Other Software): Oversee the implementation, configuration, and maintenance of Microsoft Dynamics 365 (D365) and other software. Ensure smooth integration of D365 with existing systems and business processes across departments of manufacturing, inventory management, finance and Supply-Chain.
• Team Management and Collaboration: Manage a team of IT professionals and collaborate with cross-functional teams (Sales, production, operations, finance, etc.) to understand system requirements and implement effective IT solutions. Lead training sessions for employees on D365 features, workflows, and best practices.
• Software Development and Customization: Work with Vendor and developers to customize D365 and other software solutions to meet the specific needs of the Company. Design and develop reports, dashboards, and analytics using D365 to provide real-time insights into production, inventory, and operational performance.
• Troubleshooting and Issue Resolution: Proactively identify system issues or bottlenecks and work with the IT team to resolve them swiftly, using SQL, debugging tools, and other technical resources. Serve as a point of contact for all system-related escalations, providing timely solutions to end-users.
• Vendor Management: Liaise with third-party vendors for the procurement, maintenance, and support of software tools, ensure that vendor solutions are aligned with organizational requirements and performance standards.
• Reporting and Analysis: Generate and present regular IT system performance reports, key metrics, and project status updates to senior management.
• Project Management: Lead IT-related projects, such as system upgrades, new software rollouts, and process automation initiatives, ensuring they are completed on time and within budget.
• Change Management: Support the change management process, ensuring seamless transition during system updates and changes.

Manager (Technical Support) - ITERATE INDIA PVT LTD, NEW DELHI - Posted at Maruti Suzuki India Ltd, Regional Office, Kolkata

(2000-08 - 2019-05)

Platforms & Tools: FoxPro & FoxPro Applications, Oracle, Oracle Apps. J2RE, SQL Server 2008 R2, VB.NET,

• Handling team management responsibilities including allocation of work to team members as per their aptitude, supervising the progress of work and providing guidance to team wherever needed
• Job responsibilities include Sales & marketing, installation, implementation, training and support on DMS (2004-2006) Automate and AVTS (Automatic Vehicle Tracking System) software used in Maruti Authorized Dealer and MASSs in Eastern Region) with 10-12 Team members.
• Adept at reviewing and analyzing problems of clients’ and troubleshooting problems by providing effective solutions using SQL and other tools.
• Challenged to handle the entire gamut of work involving Selling products, installation, Implementation, Training and Support on AutoMate package (Maruti Workshop & Inventory Management software used in Authorized Service Station all over India) in Eastern Zone Maruti Authorized Service Stations (MASS). My territory includes West Bengal, Sikkim, Andaman-Nicobar, Bihar, Jharkhand, Orissa and Chhattisgarh
• Arranging and attending client meets for successful promotion of the packages while looking after various software’s developed by ITERATE INDIA PVT LTD for Maruti Suzuki India Ltd.
• Devising various analytical reports and presentations for the region to facilitate effective decision making

Assistant Programmer - BIRLA DLW LTD, BIRLAPUR, KOLKATA - Birlapur, Kolkata

(2000-04 - 2000-07)

• Platforms & Tools: Back End: SQL Server 7 & Front End: VB
• Handled the task of drafting data flow diagram and developed database structure
• Carried out coding in Visual basic 6
• Responsible for writing Code for generating reports as required by the company and clients

EDP In-charge/ Programmer - BIRLAPUR VIDYALAYA, BIRLAPUR, KOLKATA - Birlapur, Kolkata

(1998-04 - 2000-03)

• Platforms & Tools: Teachers Payroll and Student Academic Result Preparation software (Using Clipper and FoxPro)
• Accountable for Data base creation along with development of the package.
• Administered official work related with computer documentation and reports

Sr. Faculty cum programmer - LAKHOTIA COMPUTER CENTRE, BATANAGAR, KOLKATA - Batanagar, Kolkata

(1997-04 - 1998-02)

• Platforms & Tools: C, C++, Oracle, VB 6, SQL, PLSQL
• Taught theory of Clipper, FoxPro, C, and Oracle-7. Dev-2000, SQL server, VB6 and took practical classes
• Developed program for clients of the organization in FoxPro 2.5. and SQL and VB6

MBA - IT Management - SMU, Kolkata (2016 - 2016)

Post Graduate Diploma Courses - Computer Science - LCC InfoTech, Kolkata (1997 - 1997)

B. Sc. - Pure Science - Calcutta University (1995 - 1995)