Mainak Das Email & Phone Number

Hyderabad, Tg, In

Kolkata, West Bengal, India

Enhanced BI system reengineering by migrating legacy systems to Microsoft Power BI, delivering financial, audit, MI, and regulatory reports with actionable insights, improving reporting efficiency by 60%.Designed automated dashboards to visualize Fund Under Management for 35+ schemes, leveraging Power BI for metrics like Fund Value, Policy Status, and Retirement Years, ensuring compliance with HMRC reporting standards.Developed 50+ Functional Requirement Documents (FRDs) for MIS… Show more Enhanced BI system reengineering by migrating legacy systems to Microsoft Power BI, delivering financial, audit, MI, and regulatory reports with actionable insights, improving reporting efficiency by 60%.Designed automated dashboards to visualize Fund Under Management for 35+ schemes, leveraging Power BI for metrics like Fund Value, Policy Status, and Retirement Years, ensuring compliance with HMRC reporting standards.Developed 50+ Functional Requirement Documents (FRDs) for MIS reporting on customer journeys such as Transaction Cost, New Business, and Death Claims, showcasing expertise in stakeholder management and legacy system analysis.Implemented automated dashboards for tracking KPIs in State Pension, Workplace Pension, and Personal Pension schemes, reducing manual effort by 50% using Power Query and Calculated Measures.Documented business processes for TCSBaNCS CRM functionalities like Pension Sharing and Policy Transfer Out using BRDs, FRDs, and workflow diagrams in Microsoft Visio, collaborating with 20+ stakeholders.Managed 200+ change requests across 3 CRM systems using Agile, ensuring seamless delivery for processes like Fund Maintenance and Policy Charges, while overseeing defect lifecycle resolution.Ensured 95% on-time delivery of business requirements by implementing Requirement Traceability Matrix (RTM) and using prioritization techniques such as MoSCoW Method and KANO Analysis. Show less

Kolkata, West Bengal, India

● Business Documentation: Produced multiple Epic Elaborative Documents (EED), business requirements documents (BRD), functional requirements documents (FRD), Technical Specs, and report specifications documents for more than 6 customer journeys, with demonstrated effective stakeholder management and business systems analysis ● Process Modeling: Executed Microsoft Visio and Systems Analysis to generate over 18 functional workflow and process flow diagrams. ● Defect Management: Headed… Show more ● Business Documentation: Produced multiple Epic Elaborative Documents (EED), business requirements documents (BRD), functional requirements documents (FRD), Technical Specs, and report specifications documents for more than 6 customer journeys, with demonstrated effective stakeholder management and business systems analysis ● Process Modeling: Executed Microsoft Visio and Systems Analysis to generate over 18 functional workflow and process flow diagrams. ● Defect Management: Headed in managing and resolving defects for 3 parallel implementations of the Enterprise Resource Planning System, ensuring efficient assignment to relevant stakeholders and leading to prompt resolution implementing strong problem solving skills, which provides robust customer support. ● Project Management: Elevated project efficiency by 30% through collaborative creation and maintenance of internal and external trackers, streamlining progress and workflow analysis with 6 distinct departments for various Business-As-Usual (BAU) tasks, ensuring on-time delivery. ● Industry Knowledge: Implemented an in-depth understanding of the life and pension insurance sector, to identify areas of improvement, reduce waste, and optimize industrial processes. Show less

Kolkata, West Bengal, India

● Data Analysis: Leveraged statistical computing and data analytics tools like R, and Python to analyze comprehensive 5year sales (time series data), resulting in sales forecasting with <10% MAPE for the financial year 2021. ● Data Visualization: Established valuable data visualization, identified new opportunities by analyzing 5 years of sales and production data, and effectively utilized Tableau to create visually engaging dashboards showcasing business performance metrics and data… Show more ● Data Analysis: Leveraged statistical computing and data analytics tools like R, and Python to analyze comprehensive 5year sales (time series data), resulting in sales forecasting with <10% MAPE for the financial year 2021. ● Data Visualization: Established valuable data visualization, identified new opportunities by analyzing 5 years of sales and production data, and effectively utilized Tableau to create visually engaging dashboards showcasing business performance metrics and data insights for presentation. ● Marketing Analytics: Recommended five products causing negative deviations in sales through comprehensive market research and the application of statistical computing and data analytics tools like R, SPSS, and Python, furthermore, investigated those 5 products to identify the causes and effects of these deviations through analysis of consumer behavior and market trends. ● Sales Forecasting: Established a forecasting model by implementing data science that helps to make a business strategy, by analyzing historical data to find the breakup of the sales target for products that contribute 80% to total revenue. ● Market Research: Conducted qualitative and quantitative market research through a statistical analysis like T-test, Z-test, F-test, chi-square test, hypothesis testing, regression, Anova, and Manova to make business decisions driven by data insights. ● Social media monitoring: As a part of social media strategy, produced 2 promotional videos as digital assets specifically accommodated for social media marketing which increased traffic by 60%, leveraging market research, market trends, and sales analysis to improve the brand sentiment and online presence by 50%. ● Data-Driven Marketing: Single-handedly, customized and executed data-driven marketing with strategic insights for 2 product mixes to increase sales by 35% and give an extra edge over competitor activities as an integral part of marketing analytics. Show less

Pgdm, Marketing

Activities and Societies: Represented ANANTHA AND ANANTHA in VIBRANT TAMIL NADU,2019. Participated in the field sales of EVER REAY.

Bachelor Of Technology - Btech, Applied Electronics And Instrumentation

Bachelor Of Technology - Btech, Applied Electronics And Instrumentation

Bachelor Of Technology, Electronics And Instrumentation, Dgpa - 6.48

Activities and Societies: Organised college cultural festival. Made few short films , I have uploaded some my short films YouTube links. I.