Project Management Business Intelligence
Resume:
PRABHAT MANDWANI
***************@*****.***
+91-942**-***** https://www.linkedin.com/in/pmandwani Areas of Expertise
• Project Management
• ERP, O2C,P2P with AI
• Business Intelligence Analytics
• Accounting & Finance
Industry Lines Served
Financials, Accounting & Tax, Banking,
Pharmaceuticals, Nutraceuticals, Bakery,
Paint, Food & Beverage, Information
Technology, Transport, Grocery, Apparel,
Jewellery, Manufacturing, Retail, C&F, Start
ups, Telecom, Auto, Packaging, Energy,
Omnichannel
IT Systems
• Enterprise Solutions
SAP Business One, BMM SAP, OptiPro,
WMS, BatchMaster, BatchMaster Mobile,
Audit Logger, MP2 Software,
• Project Management
Clarity, JIRA, MS Office, MS Project, MS
Access, MS Visio, MS Sharepoint,
Wrike, Service Now
• Product Development
VB, Crystal Reports, Oracle, SQL Server
2008/2012, Postgres,
• Big Data and Analytics
Qlikview, Tableau, Microsoft Power BI,
KNIME Analytics,Neo4J, Hadoop, Spark
SQL, Python, Map Reduce, MongoDB,
Splunk, GraphX, Giraph
Accounting & Tax Systems
Sage Accpac, Microsoft
Dynamics, QuickBooks, Tally,
Tata Ex, KITRET, KSTRET
Professional Qualifications
Education
• Chartered Accountancy from ICAI ‘ New
Delhi, India
• Bachelor of Commerce from DAVV
University, India
Certifications
• Product Management, Sales : Referral
Selling
• Agile Project Management, Big Data
Specialization, and Advanced SQL for
Data Scientists
• ITIL Intermediate Certificate in IT
Service Management
• CISA from ISACA ’IL, DISA from ICAI
• Qlikview Designer & Developer level
training certificate
• SAP – FI Module Training, Oracle 9i
Professional Experience & Principal Areas
• Chartered Accountant with over 22 years’ experience in Information Technology and Accounting, and having expertise in developing, implementing and enhancing business processes along with IT applications, to the extent of catering to Business Intelligence \Big Data\ Artificial Intelligence (AI) needs, for multinational organizations.
• Rich experience in project planning, execution and management including resource administration, client interaction, testing and risk management.
• Spearheaded design, development & release of large scale digital transformation from idea generation through implementation & support in an Agile manner.
• Strategic thinker and planner with a developed capacity to present the big picture through KPIs to identify impact on P/L, with the view to devise appropriate control measures.
Apr 2024 - Till Date
Self Employed, Pune’ India
• Stock Market Trading
• Volunteer for spiritual causes
Nov 2022 - Apr 2024
Program Manager - Zycus Infotech Pvt Ltd, Pune’ India
• Role involved team leadership and management of the implementation programs of the Zycus Procurement Management Suite with Merlin AI Capabilities for US,EU,ANZ and APAC regions
• Projects : Spirent Communications, Porsche,UPMC, The GAP Inc, Graphic Packaging International, ERCOT, IPC (Idaho Power Company),Wrike Implementation (Internal Project)
• Integrations : SAP, Oracle, JD Edwards, Asset Suite, D&B Jul 2021 – Nov 2022
Implementation Manager - Vinculum Group ‘India
• Oversee all team members and provide leadership and support towards high quality implementation, evaluation and assessment within the programs for APAC and EMEA region.
• Projects : Metro Brands, Malabar Gold, Acer, Daily Objects, Landmark Group (Max and BabyShop), Woovly, Al Shamsi (Okaidi and Jacadi), MGH Group
• Integrations :
• Finance : SAP, Oracle
• Market places : Prestashop, Amazon, AJIO, Flipkart, Myntra, Snapdeal,TataCliq, World Sellers, Tokopedia, Shopee,, Lazada,Zalora
• Logistics : Shyplite, First Flight, Amazon Logistics, Pickrr, Shipway, Shiprocket, Shipa,CEVA,Ninjavan
Jan 2020 – Dec 2020
Product Manager - Co-Action.com Pvt Ltd’ Pune, India (Now part of Dun & Bradstreet ‘USA)
• Lead the ideation, technical development, and delivery of applications in O2C domain of Co-Action product
Jun 2017 – Dec 2019
Self Employed’ Pune, India
• Working on IT Projects in an independent capacity
• Distributor of Enagic India Pvt Ltd
• Council Member at GLG (Gerson Lehrman Group)
• Member of Rotary Club International
• Stock Market Trading
Page ! 2 of 3
Career Accomplishments
• Led the execution of several on-line ERP
system (Order to Cash, Procure to Pay,
AR,AP &GL)projects with an estimated
cumulative value of US$
6.11 Million; Achieved significant
improvements in accounting & cost
control and operations management.
• Delivered a major release of the ERP
system to 3 branches with >200 users,
enabling virtualization o f
infrastructure
• Presented clients position on ERP
landscape to project boards, including
Chief Executive Officers (CEOs)
• IT Process enablement in the areas of
Lot Traceability, Allergen
Management, 24x7 Production Process
Planning, Material Staging & Return
process, Statistical Process Control,
Production Down Ti m e, Wa s t e
Management, and Sales Budget
Monitoring.
Career Time Line
Sep 2015 – May 2017
Assistant Vice President – Corp Technology, Deutsche Bank ’Pune, India Project Manager – MIS Reporting
• Lead complete portfolio of projects including budgeting, planning, vendor selection, and execution.
• Implemented project plans within pre-set budgets and deadlines; planning project activities such as scoping, estimation, tracking, change management, delivery management & post implementation support.
• Interfacing with senior management for evolving strategic vision, driving change, infusing new ideas and taking enterprise system performance & productivity to the next level, in an agile manner.
• Coordination for smooth implementation of the project; extending post- implementation and application maintenance support to the client.
• Prepared proposals, business presentations to clients and managing resource planning, technical direction, effort estimation, tracking, risk management, audit and compliance issues.
• Leading, mentoring & monitoring the performance of team members to ensure efficiency in process operations.
• Developed competency among the team members; managing appraisal process across the levels, managing recruitment process to recruit the right talent and resources.
• Consulting with customers about software system design and maintenance.
• Preserving assets by implementing disaster recovery and back-up procedures. Significant Accomplishments:
• Supervised internalization of ETL Developer and Qlikview Developer role, for saving of approx €100 k annually
• Facilitated reduction of network spike from 150 mbps to 25 mbps which led to saving of approx $64 k yearly network overhead
• Re-established OLA with upstream owners to ensure information availability to MIS at T+3 on consistent basis
• Reduction of MIS application maintenance downtime from 2 hours to 10 seconds
• 30% Qlikview application size reduction and initiated the Shared Objects Management Program with User Groups
• Managed migration of Development and UAT Server to Cloud environment
• Facilitated restructuring of SL2 operations with improved communication by having daily status calls, daily Processing planning and monitoring, for maintaining SLAs
• Acted as Member of Finance IT Panel for interviewing Qlikview Developers
• Worked as Technical Information Security Officer (TISO) for the MICRON Project and Secondary Business Continuity Coordinator for Pune’s Corporate Technology Group
Feb 2013 – May 2015
Business Systems Analyst for ERP (Order to Cash, Procure to Pay, AR, AP
&GL), TH Foods Inc (Mitsubishi owned) ‘IL, USA
• Acted as Business Analyst of 200+ user group comprising the warehouse operators, shop floor operators, production supervisors, office staff, and managers spread across 3 locations
• Assisted the stakeholders in daily review of the Sales Data, Production Planning, P/L statements and other Operational and Business Critical Reports
• Managed Qlikview Projects for functional departments, which includes Sales Tracking, Production Score Card involving KPIs such as downtime %, waste %, cost per unit, for managing direct labour and improved operational efficiency
• Maintenance & Supplies Expense Reporting for prioritizing the expenditure and better cost control
• Prepared Statistical Process Control dashboard for monitoring & controlling the process by Production QA staff
• Implemented multiple tier of QVD architecture and optimized the Qlikview Application by reducing the overall reloading time from 30 minutes to 30 seconds
• Liaised between Software Provider Team and Business Users to prioritize issues, bugs and enhancements
2001
Chartered Accountant
Indore and Mumbai
2004
Multiple Roles
BatchMaster Software’ Indore
2013
Business Systems Analyst
TH Foods Inc, IL, USA
2015
AVP : Corp Technology
Deutsche Bank’ Pune
2017
Self Employed’ Pune
2020
Product Manager
Co-Action.com’ Pune
2021
Implementation Manager
Vinculum Group ’ Ahmedabad and Pune
2022
Program Manager
Zycus Infotech’ Pune
2024
Self Employed’ Pune
Page ! 3 of 3
Recognitions
• Team Goody Certificate for Adoption of
Wrike PM Collaboration in 2023
• Employee of the Year - 2012
• Appreciated for ERP Implementation
in 2010
• Recognized for 'Multiple Task
Handling Abilities' in 2005
• Recognized as 'Best All Around Debutant
of the Year’ in 2004
US Visa Details
B1 (Valid until Oct’2028)
H1B (Cap Exempt)
IELTS Details
CEFR Level :C1
Jan 2004 – Jan 2013
Solution Architect, BatchMaster Software ‘Indore India 20+ ERP (Order to Cash, Procure to Pay, AR,AP, & GL )Implementation Projects in US, Caribbean and India region.
• GAP\FIT Analysis to present customer with Solution Blueprint document.
• Discuss GAPs and establish time line with Product Architect, Project Manager and Reports Manager for the deliverable.
• Mentoring Implementation Team in Database Conversion, performing Iterative User Pilots, and conduct reviews before obtaining Customer System Acceptance on the basis of Conference Room Pilot Presentation, followed by production environment preparation for Go Live
• Documentation of business processes flows, work instructions and process ownerships and imparting user training. Assistance to the customer for developing in house training resources for catering to their future training needs.
• Development and customization of reports and dashboards
• Perform necessary upgrades and installation of the hot fixes on the UAT Server. After obtaining UAT confirmation, performing the necessary upgrades and installation at the available system down time.
• In coordination with Project Manager perform Project Closure and prepare Project Closure Report for transferring the account to the Customer Care.
• Troubleshooting customer issues via remote connection\online meetings and helping QA Team for test scenarios preparation
• As an SME to the Accpac and Great Plains Dynamics software, assisted Sales Team for filling in RFI deliverables and demo preparation for the prospects. External Projects : Five Star Gourmet Foods, House Autry Mills, Alessi Bakeries, Simmering Soups, United Pharma, New Hope Formulas, TH Foods Inc., Jarrow Formulas, Jarrow Industries, Highland Labs, Helen Foods, The Synergy Co., Lanco Paints, Puerto Rico & Dominican Rep. and HRI Cosmetics’ India, Torginol Paints Inc. Guyana, Biozone Labs, Coolant Controls Inc., Qualitek International, and Synthetic Labs Internal Projects :
• Financial Statement Review.
• In House Implementation of Financial Software.
• Sending welcome letter to new customers, Preparing the contracts with agreed terms and conditions, Facilitating execution of the contracts.
• Generation of the invoices on the agreed milestone\due date, follow up for the payments from customers.
• Introduction of the Meal Vouchers as part of the employee welfare\tax planning initiative
• Licensing Coordination with the Software Service Providers. Jan 2001 – Dec 2003
Chartered Accountant, Mumbai and Indore
• Imparted Accounting, Tax & Audit Services to Retail and Corporate Clients
• Provided assistance in Transfer Pricing Reporting for MNC IT Organization.
• For BSNL, Telecom Organization, assisted staff in improvements of accounting procedures and helped in internal audits and statutory audits
• Part of the Internal Audit team and IS Audit team for Depository Participant
(Stock Holding Corporation of India) for
their financial products
• Performed the Special Audit under the provisions of Board for Industrial and Financial Reconstruction (BIFR) as an assistance to either revive or shut down sick company.
• Carried out different audit assignments for various MNC organizations: Cadbury India, Albright & Wilsons Chemicals India Limited’ Mumbai, Jindal Iron and Steel Company Limited, Chhabaria Marketing Limited (Marketers of ‘ Officer Choice’ whisky), CG Investments Ltd (Crompton Greaves group concern), Mathur Micro Motors & Appliances Ltd. (Manufacturer of ‘Sumeet’ Mixers), Armstrong World
(India) Limited.
Contact this candidate