ARPAN MONDAL
Executive Business Analyst at Maini Group- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English -
-
Hindi -
-
Bengali -
Topline Score
Bio
Credentials
-
Excel crash course - Corporate Finance
Corporate Finance Institute® (CFI)Jun, 2020- Oct, 2024 -
Genpact AI and Machine Learning Certification
GenpactApr, 2019- Oct, 2024 -
Google cloud certification
GoogleMar, 2019- Oct, 2024 -
Google Adwords Fundamentals; Google Analytics certification
GoogleOct, 2017- Oct, 2024 -
Market Research
Qrius (formerly The Indian Economist)Sep, 2017- Oct, 2024 -
SEAL certification from Karvy stock broking
Karvy Stock BrokingOct, 2017- Oct, 2024 -
Business simulation
Capstone Partners LLCJul, 2017- Oct, 2024 -
Project work certification on"Increasing efficiency in steel plants by PQCDSM method"
NIT DurgapurJul, 2015- Oct, 2024 -
Project on" Dry wear testing of Al.15(wt%)Mg2Si sample "
NIT DurgapurMay, 2014- Oct, 2024 -
EFSET Quick English Check - Score: Intermediate / Upper Intermediate (CEFR B1/B2)
EF Education First -
International marketing certificate from EDUCBA
- -
Market Research certificate from EDUCBA
- -
Project on " DRY slide wear testing of Aluminium specimen"
NIT Durgapur -
RUSH certification in cricket tournament
Indian Institute of Management, Ranchi -
rio+23 united nation organisation certified
- -
six sigma green belt certified
KPMG -
sprint organised by sunday club , durgapur
-
Experience
-
Maini Group
-
India
-
Motor Vehicle Manufacturing
-
1 - 100 Employee
-
Executive Business Analyst
-
May 2019 - Present
Reporting to MD.Working with Business Intelligence team and Top management. Handling 1 Aerospace plant and 8 Automotive units data.Build metrics for Investors. Involved in making P&L statements, Internal Audit, Involved in planning and analysis, production, capacity planning, EBITDA analysis, CAPEX. Working closely with Sales and Marketing, production and operation teams. Take decisions and solve company related problems. Handling and analyse business data and prepare Board meeting… Reporting to MD.Working with Business Intelligence team and Top management. Handling 1 Aerospace plant and 8 Automotive units data.Build metrics for Investors. Involved in making P&L statements, Internal Audit, Involved in planning and analysis, production, capacity planning, EBITDA analysis, CAPEX. Working closely with Sales and Marketing, production and operation teams. Take decisions and solve company related problems. Handling and analyse business data and prepare Board meeting reports. Show more Show less
-
-
-
Genpact
-
United States
-
Insurance
-
1 - 100 Employee
-
Financial Business Consultant (Band 4A Manager)
-
Aug 2018 - May 2019
1. Worked for S&P Global in an oracle project in Financial Modules.2. Reporting to Vice President and Sr. Director. 3. Worked on Toad Analytical software for data preparation and editor for Oracle, SQL server and SQL Azure, IBM DB2 (LUW & Z/os), SAP ASE, IQ, SQL Anywhere and HANA, Teradata and MySQL.Did data analysis using ER Diagram, SQL Query builder, visualization and Automation.4. Worked with Boeing team (one of the world's biggest Aircraft manufacturing company) as a client… 1. Worked for S&P Global in an oracle project in Financial Modules.2. Reporting to Vice President and Sr. Director. 3. Worked on Toad Analytical software for data preparation and editor for Oracle, SQL server and SQL Azure, IBM DB2 (LUW & Z/os), SAP ASE, IQ, SQL Anywhere and HANA, Teradata and MySQL.Did data analysis using ER Diagram, SQL Query builder, visualization and Automation.4. Worked with Boeing team (one of the world's biggest Aircraft manufacturing company) as a client in oracle project. 5. Taking care of General ledger, Accounts Receivables and Account payables on Oracle R12 platform. Report making and Monthly Presentation to Director of Client Company. 6. Taking care of internal Auditing, Bi-annual auditing and Quarterly auditing.7. Have a good experience in universal acceptance testing. And modification according to client requirements. 8. Worked on Financial platform Like Oracle R12, Zuora, Qlikview, Blakeline. Show more Show less
-
-
-
Qrius (formerly The Indian Economist)
-
India
-
Online Audio and Video Media
-
1 - 100 Employee
-
Market Research Analyst
-
Sep 2017 - Oct 2017
1. Consulting Thesis on “Brand Loyalty” for FMCG Products.2. Prepared Questionnaire to understand why people often shift from one brand to another thereby provided solution to retain customers. Took FGD's and transcribe them. 3. Worked on Advanced excel and analyzed data using SPSS.4. Formed strategy and Provide detailed solution to Qrius.5. Done Peer-to-Peer marketing,
-
-
-
Export-Import Bank of India
-
United Kingdom
-
Investment Management
-
Business Analyst
-
Apr 2017 - Jun 2017
1. Worked with Export Import of India on the project" Export potential of MSME sectors in west bengal" with the help of CII, FIEO , IIFT, MSMEDI, MSME government and DGCIS. 2. Done market survey , Meet Clients and Directors of Enterprise across West Bengal. 3. Worked with Real time data, Procured data from Database and analyzed data.4. Developed strategy to target MSME industries in west bengal.5. Proposed detailed solution to EXIM Head office which MSME should they target for… 1. Worked with Export Import of India on the project" Export potential of MSME sectors in west bengal" with the help of CII, FIEO , IIFT, MSMEDI, MSME government and DGCIS. 2. Done market survey , Meet Clients and Directors of Enterprise across West Bengal. 3. Worked with Real time data, Procured data from Database and analyzed data.4. Developed strategy to target MSME industries in west bengal.5. Proposed detailed solution to EXIM Head office which MSME should they target for financial help and market advisory. Show more Show less
-
-
-
KPMG US
-
United States
-
Financial Services
-
700 & Above Employee
-
Lean Six sigma Green Belt Certification Specialist
-
Sep 2016 - Oct 2016
Lean Six Sigma Green Belt Certified.
-
-
-
Steel Authority of India Limited
-
Manufacturing
-
700 & Above Employee
-
Summer Internship at Durgapur Steel plant
-
May 2015 - May 2015
Departments: Centre for HRD, R.H.M.P , Blast furnace, Sinter Plant, Coke Oven, SMS & CCp, W&A Plant, Merchant Mill, R.C.L, Section Mill, B&B Mill
-
-
-
-
Summer Internship at Alloy Steel Plant
-
Jun 2014 - Jun 2014
Departments: SMS &CCS,Forge Shop, BBM, Plate Mill, HTF
-
-
Education
-
Indian Institute of Management Sambalpur
-
National Institute of Technology Durgapur
-
Guru Teg Bahadur Public School
-
Durgapur Ispat Vidyalaya