Arnab Dey
Hyderabad,India
Summary
Dynamic and results-oriented professional with extensive experience in end-to-end project management and process optimization. Skilled in leading cross-functional teams and managing multiple large-scale projects, ensuring alignment with strategic business goals. Proficient in both Agile and Waterfall methodologies, consistently driving initiatives that enhance operational efficiency and deliver measurable results.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Supervisor - PMO, Business Risk Consulting
RSM US LLP
12.2021 - Current
- Worked as PM for 36 projects in Automation and Analytics with cumulative value of USD $5.3 million through end to end project management closing the project resulting in USD $136K write up
- Collaborated with other Line of Business leaders for cross training and cross teaming to increase team utilization as well as leveraging possible analytics solution for reducing repetitive manual effort
- Worked as PM for 13 ITACs and 14 key Reports projects using both Waterfall and Agile methodology in Pharmaceuticals, Manufacturing and Financial Services clients using different ERP tools like Oracle EBS, Workday, NetSuite, SAP etc
- With cumulative value of USD $4.2 million managing the client coordination, kickoff and daily and weekly status calls, monitoring finances as well as adherence to deadlines resulting in USD $67.5K write up
- Supported implementation, validation and maintenance of computerized systems in compliance with regulatory requirements (21 CFR Part 11 and GAMP 5)
- Tested IT Application Control & Key Reports for different client in multiple ERP applications like SAP, NetSuite, Workday etc
- Lead a team of 7 professional to manage all ERP Risk and Automation Services projects, mentoring them to learn new technologies to get versed with project works for better project management, solving the critical issues for the team through discussing with the leadership
- Utilized project management tools like Smartsheet & DevOps for project progress tracking and monitoring
- Executed validation protocol, test scripts and summary reports for computerized systems to ensure compliance with regulatory requirements
- Developed Project Management Dashboard using Tableau Desktop version 2023.1.4 and Microsoft Excel Spreadsheet as data source for Leadership of a financial industry client demonstrating qualitative parameters (e.g., Industry, Project Lead, Functional Lead, Location etc.) as well as quantitative parameters (e.g., Total Budget, Budget Vs Actuals, Critical Next Steps, Project Health etc.) to get a complete overview of all the ongoing projects
- Prepared Project Status Tracker using Smartsheet and a Project Micro-management tracker Dashboard using Power BI version 2.131.901.0 for more effective management of projects as well as leadership visibility of Project Status
- Lead a team of 2 Sr
- Associated and 3 Associates to complete a project on Dashboard development for a Manufacturing sector client for monitoring their key processes like PTP, Sales, OTC etc
- And subsequent periodic maintenance of the dashboard successfully completing the project within budget as well as stipulated timeline
- Prepared a Bot using Automation Anywhere A360 v.25 for automated timesheet monitoring of employees and email reminder for missing or mismatched timesheet entry
- Helped team to achieve USD $201.5K write up overall in all the projects managed
- Received recognition from leadership for creating the Project Management Dashboard
- Received recognition from leadership for creating the Smartsheet Project Tracker and ITACs & Key Reports Project Management Dashboard
Senior Consultant, Business Consulting
Ernst & Young LLP
12.2018 - 12.2021
- Worked as PMO consultant for a project using Agile methodology for automating the financial as well as operational controls using SQL and Tableau for a Manufacturing MNC
- Taken care of business requirement from various stakeholders and prepared plan and estimate to complete
- Facilitated workshops and status update discussions between business and technical leads
- Prepared and tracked planned/budget vs actual
- Worked as PMO consultant for a construction of high-rise building managing scratch to end of the project using Waterfall methodology
- Identified process gaps leading to loss of INR 1.67 Cr through review of Capital Expenditure processes
- Found INR 2.44 Cr of excess raw material consumption reviewing Raw material handling and material balancing
- Managed Capital Expenditure Internal audit with documenting process gaps leading to cost over booking of $ 2.1 Million
- Located non booking of consumption of USD 821K of raw materials while reviewing Plant operation process
- Completed feasibility study on Data Analytics in Plant operations and maintenance for automated control optimization
- Prepared Data visualization using Tableau Desktop version 2019.4 and Power BI version 2.91.701 for visual representation of deliverables to client
- Managed project to help client to develop SOP for key processes like Finance & Accounting, Procurement, Supply Chain Management, Sales & Marketing etc
- For a large FMCG MNC
- Helped preparing proposal and won the project for various engagements with win amounting total of INR 8.3 Cr
- Led a project on preparation of structured Fixed asset register as a Team Lead at Senegal, Africa
- Co-ordinated review of Building bridge and changing river course identifying process gaps at Kenya, Africa
- Received Kudos Award from EY for outstanding performance across different engagement
- Received appreciation from client for early completion of project without compromising on quality
Deputy manager, Project Control
Shapoorji Pallonji E&C
08.2013 - 12.2018
- Performed structural Design and Resource optimization (Construction Equipment) for 37 projects in eastern region
- Worked in cross-functional role between Inventory & logistics dept., Planning, Procurement, and Tendering
- Performed as a Project Manager looking after the project using Waterfall methodology from initiation to closing including planning, resource monitoring, periodic monitoring of project financials as well as progress, stakeholder management, getting the deliverables delivered to client in due time and getting sign-off
- Executed successful Citrix based ERP to SAP Migration as a part of the core member for the material module
- Cost optimization of INR 4.7 Cr in Guwahati Airport project at Guwahati using innovative construction technology
- Selected among 11 out of 151 Trainees in the coveted Leadership Development Program (ALDEP)
Education
B.E - Construction Engineering
Jadavpur University
07-2013
Skills
- Project Management
- Project Financials
- Program & Portfolio Management
- Smartsheet
- Tableau
- Power BI
- Alteryx
- Automation Anywhere
- MS Project
Positions Of Responsibility
- Departmental Co-ordinator, Placement Committee, Jadavpur University, 08/01/09, 05/31/13
- Joint Convenor, Freshers welcome program, Jadavpur University, 01/01/10, 12/31/10
- Joint Treasurer, Departmental Re-union, Jadavpur University, 01/01/12, 12/31/12
Certification
- PMP
- CLSSBB
- CSM
Skills And Tools
Project Management Professional (PMP), Certified Lean Six Sigma Black Belt (CLSSBB), Certified Scrum Master (CSM), Tableau, Power BI, Alteryx, Automation Anywhere, Primavera P6, Smartsheet, DevOps, MS Project, MS-Office suite, Project Management, Project Financials, Program & Portfolio Management, Tableau, Power BI, Alteryx, Automation Anywhere, Manufacturing, Construction, Real Estate, Banking & Financial Services, Pharmaceuticals, Industrial, Metals & Mining
Others
- Completed 'C' Certification in NCC (National Cadet Corps)
- Completed Basic Mountaineering Training Course from Bhoruka Mountaineering Trust
- Arranged two Blood donation camps sponsorship program for Thalassemia affected students
Languages
English
Full Professional
Bengali
Native or Bilingual
Hindi
Full Professional
Interests
- Avid Reader
- Backpacking and Hiking
- Photography
Timeline
Supervisor - PMO, Business Risk Consulting
RSM US LLP
12.2021 - Current
Senior Consultant, Business Consulting
Ernst & Young LLP
12.2018 - 12.2021
Deputy manager, Project Control
Shapoorji Pallonji E&C
08.2013 - 12.2018
B.E - Construction Engineering
Jadavpur University