Suvajit Gayen
Kolkata
Summary
Data-driven product leader with over 10+ years of experience transforming insights into growth strategies across the finance and CPG industries. Skilled in building scalable analytics ecosystems using Power BI, DAX, and SQL to uncover consumer trends, optimize brand performance, and inform product roadmaps. Known for leading cross-functional teams, streamlining reporting workflows, and empowering leadership with real-time business intelligence. Passionate about blending data, creativity, and technology to drive innovation and sustainable growth in dynamic global markets.
Overview
11
11
years of professional experience
Work History
Senior Specialist
LTIMindtree
Kolkata
09.2022 - Current
- Created a centralized Power BI product analytics platform used by marketing, sales, and supply chain - reduced reporting time to near real-time, enabling daily revenue optimization.
- Proficient in creating insightful visualizations and interactive dashboards using Power BI, enhancing data-driven decision-making.
- Expertise in automating repetitive tasks and workflows with Power Automate, streamlining processes, and improving efficiency.
- Implemented a streamlined process enabling users to independently refresh data by deploying Power Automate workflows.
- Collaborated with cross-functional teams to gather, document, and translate requirements into impactful analytics solutions.
- Expertise in managing Power BI capacities, recommending license allocations, and optimizing performance for enterprise and self-service BI solutions.
- Combined the capabilities of DAX Studio and Tabular Editor to streamline the development, analysis, and optimization of DAX calculations and data models, ensuring efficient Power BI solutions.
- Skilled in leveraging SQL to extract, manipulate, and analyze data, providing valuable insights to drive business strategies in the CPG industry.
- Created measures and calculated columns in Power BI using advanced DAX.
- Integrated Power BI with Azure Data Factory (ADF) to orchestrate data pipelines, enabling seamless data extraction, transformation, and visualization for comprehensive analytics and reporting.
- Imported data from SQL Server DB, Azure SQL DB, and BigQuery (GCP) to Power BI to generate reports.
- Created new stored procedures, and optimized existing queries and stored procedures.
- Created Azure Blob Storage for import/export data to and from .CSV file. Explored data in a variety of ways and across multiple visualizations using Power BI.
- Establishing XMLA Endpoint Connections for Advanced Data Integration
- Used Power BI Gateways to keep the dashboards and reports up to date.
- Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services
- Successfully implemented incremental refresh and query folding strategies in Power BI, optimizing data processing and reducing load times for large datasets, resulting in more efficient and responsive dashboards.
- Understand business requirements to set functional specifications for reporting applications.
- Implemented Row level security to ensure that each user can only access data associated with their organization's ID on power bi service portal
- Data Modeling: Star Schema, Snowflake Schema
- Promoted and implemented self-service BI solutions, empowering business users to access and analyze data independently for better decision-making.
- Identifying key performance indicators (KPI) to help companies adjust and fulfill objectives
- Worked closely with stakeholders to align analytics initiatives with business objectives, delivering actionable insights and ad-hoc analyses.
- Proficiently oversee and lead a team of six members while actively contributing to their training and development.
Assistant Manager
Cogneesol
Chandigarh
10.2021 - 09.2022
- Developed interactive Power BI dashboards and reports, transforming raw data into insightful visualizations.
- Created complex DAX calculations to provide meaningful business metrics and KPIs.
- Utilized SQL queries to extract, manipulate, and transform data from various sources.
- Collaborated with business stakeholders to gather requirements and ensure accurate representation of data.
- Implemented data models using star schema and snowflake schema to optimize query performance.
- Designed drill-through dashboards to allow users to explore data at granular levels.
- Presented findings and insights to non-technical stakeholders, facilitating data-driven decision-making.
- Contributed to team training sessions on Power BI best practices and new features.
Executive
Macquarie Global
Gurugram
01.2020 - 02.2021
- Processed and performed quality check of MIS and KPI reports in Excel and Power BI which are very critical reports from Stakeholderʼs perspective (Weekly, Monthly and Quarterly).
- Experienced in creating Bordereaux and financial reports using variance analysis for each insurer.
- Optimized performance through systems analysis and reorganization of reporting methods.
- Monitor work, and evaluate results to ensure that organizational objectives and operating requirements are met and are in line with the SLAs.
- Prepared RCA and Error sheet on weekly basis and discussed same with the team for quality improvement.
- Quality check and maintaining standard on day to day basis. Automated regular reports in Power BI like Insurer and Broker reports.
Senior Analyst
AXA XL
Gurugram
10.2016 - 01.2020
- Optimized performance through systems analysis and reorganization of reporting methods.
- Processed and performed quality check of MIS and KPI reports Excel which are very critical reports from Stakeholderʼs perspective.
- Assisted in transition of Auto rating from onshore to offshore by getting training from onshore through video calls and successfully implemented this process by giving training to the team members.
Analyst
Xceedance
Gurugram
04.2015 - 10.2016
- Providing support to the North America underwriting team by processing various tasks in the policy life cycle such as submissions, quotes, bind, etc. on Duck Creek.
- Analyze documents shared by the underwriters and capture relevant information related to policy in the Duck Creek system.
- Compiling Risk Data Tool to be used for CAT Modelling.
- Responsible for preparing and issuing Property, Casualty, E&P and Healthcare policies for North America region.
Education
BTech -
West Bengal University of Technology
01.2014
Higher Secondary -
K V Ballygunge
01.2009
10th Standard -
K V Ballygunge
01.2007
Skills
- Power BI
- DAX calculations
- Performance optimization
- Power Automate
- SQL
- Alteryx
- Python
Projects
CPG DASHBOARDS, Led end-to-end execution of advanced Power BI projects within the Consumer Packaged Goods (CPG) sector, integrating data from diverse sources, including Google Cloud Platform (GCP), sales databases, and customer feedback repositories., Utilized ETL processes to extract, transform, and load data from GCP-based BigQuery datasets, on-premises SQL servers, and other relevant CPG data stores, ensuring a unified and comprehensive data source for accurate analysis., Collaborated with cross-functional CPG teams, such as sales, marketing, and supply chain, to derive insights from data visualizations, fostering agile adjustments to CPG strategies based on market trends and consumer behavior., Presented findings from CPG Power BI dashboards to executive leadership, utilizing sophisticated data storytelling techniques to communicate complex trends and actionable insights, thus informing strategic decisions.
Personal Information
Date of Birth: 10/25/91
Timeline
Senior Specialist
LTIMindtree
09.2022 - Current
Assistant Manager
Cogneesol
10.2021 - 09.2022
Executive
Macquarie Global
01.2020 - 02.2021
Senior Analyst
AXA XL
10.2016 - 01.2020
Analyst
Xceedance
04.2015 - 10.2016
BTech -
West Bengal University of Technology
Higher Secondary -
K V Ballygunge
10th Standard -
K V Ballygunge