Pallabi Mandal

Data Analyst

South Delhi, Delhi, India6 yrs 10 mos experience
AI EnabledAI ML Practitioner

Key Highlights

  • Reduced report preparation time by over 90%
  • Increased customer loyalty levels by 40%
  • Achieved 100% error-free vendor payment
Stackforce AI infers this person is a Data Analyst with expertise in Data Visualization and Business Analytics.

Contact

Skills

Core Skills

Data VisualizationData AnalysisReportingSales ManagementCustomer Relationship Management

Other Skills

AlteryxAnalytical SkillsAnalyticsAttention to DetailBusiness AnalysisBusiness AnalyticsBusiness InsightsBusiness Intelligence (BI)Business Intelligence ToolsCollaborative Problem SolvingCommunicationDashboardDashboard BuildingDashboard reportingData Analytics

About

➡ Introducing Pallabi, a highly motivated and results-driven Data Analyst and Data Visualization specialist with more than 5 years of experience & having a fervent passion for leveraging data to propel business growth. With a wealth of experience in Data Analytics, Pallabi has honed her skills in Reporting, Exploratory Data Analysis, Data Visualization, Predictive Modelling, R, SQL, Tableau, Alteryx, Advanced Excel, VBA, and Microsoft Suite. ➡ As a Financial Analyst at American Express, Pallabi optimized vendor WIP report automation, consolidated data, performed exploratory data analysis, and synthesized insightful trends analysis, resulting in a reduction of report preparation time by over 90%. ➡ She also developed the Procure to Pay Dashboard project, meeting top management demands, and exhibiting procurement metrics compared with global competitors, while utilizing an array of six to seven tools, including Tableau, Hive Terminal, Oracle, MS Excel, VBA, Alteryx, and MS PowerPoint. ➡ In her previous role at DMI Finance, Pallabi synthesized astute insights, performed performance evaluations for executive management appraisal, administered collection expenses, and liaised with finance and operations teams. She also achieved 100% error-free vendor payment, disseminated monthly reports while preserving dashboards, and leveraged an assortment of four tools, including Advanced Excel, AWS Athena, Tableau, and Salesforce. ➡ Pallabi's expertise extends to CRM, where she seamlessly orchestrated overseas customer journeys at SpiceJet Ltd. She capitalized on revenue-generating opportunities, increasing customer loyalty levels by 40%, formulated sales targets through expert analysis of annual sales quotas, and predicted sales volumes for both established and novel offerings. Pallabi employed Navitaire, Genesys, MS Office, and Salesforce as key instruments in facilitating these achievements. ➡ As a Certified SQL and Alteryx professional, Pallabi has completed Tableau Desktop - Speed & Performance Optimization certification from Udemy. ➡ Her phenomenal educational background includes a Master's degree in English Literature from Rabindra Bharati University, Kolkata, and a PGP in Business Analytics & Business Intelligence from the McCombs School of Business, University of Texas, Austin. Pallabi's knowledge, skills, and experience position her well to make an immediate and significant impact on any organization.

Experience

Ets

Quality Analyst

Feb 2025Present · 1 yr 1 mo

Self-employed

Data Analyst

Feb 2023Dec 2024 · 1 yr 10 mos · Remote

  • Over this timeframe, executed 5-6 Freelance projects, provided consulting and training on dashboard building and design.
  • Important Projects -
  • Sales and Shipping Analysis Dashboard - Conducted Market, Product and Shipment Analysis of an E-Commerce company, identified more than 10 key insights for operational optimization, improving overall efficiency by 50%.
  • Customer Churn Analysis - Fabricated a dashboard for a Telecom company, that revealed customer churn patterns, resulting in a significant 30% increase in sales and customer retention.
  • Engaged in the Tableau User Group community, contributed as a volunteer and guest speaker.
  • Focused on maintaining and enhancing skill set and upskilled through Certifications in SQL, Tableau, while also learning Design Thinking process in Figma for dashboard development.
TableauSQLDashboard BuildingDesign ThinkingData VisualizationData Analysis

American express

Financial Analyst

Feb 2022Dec 2022 · 10 mos · Gurugram, Haryana, India · On-site

  • Engaged in GSM Analytics COE, executed assigned BAU activities, encompassing report publication & maintaining 3-4 Global Enterprise Dashboards
  • Streamlined Vendor WIP Report & Automation, diminishing report preparation duration from hours to ~10 minutes. Consolidated data, conducted Exploratory Data Analysis, & generated perceptive insights & trend analysis
  • Developed the Procure to Pay Dashboard project, employing diverse data visualization techniques to satisfy top management demands, & exhibited procurement metrics juxtaposed with global competitors
  • Improvised Tableau dashboard performance, cutting query times by 50% and boosting server performance by 30%.
  • Managed user access, content, and security for multiple sites on Tableau Server.
  • Leveraged an array of 6-7 tools including Tableau, Hive Terminal, Oracle, MS Excel, VBA, Alteryx, & MS PowerPoint, partnered with the team having 3-4 members & catered to the business requirements
AlteryxProcess AutomationTableauTableau ServerBusiness AnalyticsData Analysis+1

Aine ai

Data Science Intern (Virtual Internship Program)

Nov 2021Dec 2021 · 1 mo · Remote · On-site

  • Executed comprehensive data analysis & visualization utilizing MS Excel, with a focus on scrutinizing Black Friday sales data
  • Employed T-SQL via Azure Data Studio to scrutinize & analyze product sales performance by 80% with a keen eye for detail & a drive for optimization
  • Spearheaded an in-depth study of the global Covid-19 outbreak, exploring the interplay between 3 to 4 key factors like demographic, economic, & public health factors in influencing the pandemic's spread & mitigation
Data MappingPivot TablesAnalyticsAttention to DetailBusiness InsightsVisualization+3

Dmi finance private limited

Analyst (Collection Support)

Nov 2020Oct 2021 · 11 mos · India · On-site

  • Headed the Agency Performance Overview Dashboard for monitoring 25-30 Agency’s performance across different Regions.
  • Analysed and maintained monthly cost collection and billing data.
  • Published monthly reports while preserving dashboards, pulling off 100% error-free vendor payment.
  • Collaborated with cross-functional teams to collect data and streamline operations.
Presentation SkillsMIS ReportingDashboard reportingCollaborative Problem SolvingAttention to DetailData Analysis+1

The sparks foundation

Business Intelligence Intern

Aug 2020Sep 2020 · 1 mo · Singapore · On-site

  • Fabricated 2 Intricate Regression models & clustering algorithms through the utilization of R programming language, showcasing an exceptional capacity for mathematical analysis & advanced computational methodologies
  • Collaborated with the team & pioneered the creation of a seamless linkage between 2 data sets within Tableau, thereby facilitating accurate predictive modeling & exhaustive trend analysis
Pivot TablesAnalyticsAttention to DetailBusiness InsightsVisualizationDashboard+2

Spicejet limited

Senior Executive

May 2018Jul 2020 · 2 yrs 2 mos · Gurugram, Haryana, India · On-site

  • Enhanced Customer experience both domestically and internationally and maintained customer loyalty.
  • Resolved customer query and grievances through company's CRM tool Salesforce.
  • Executed lead generation and lead conversion to contribute to company's revenue.
  • Developed Sales dashboard, increasing sales productivity by 30% and revenue by 20% in the first quarter.
  • Operated Navitaire, Genesys, MS Excel, MS PowerPoint & Salesforce as key instruments in facilitating these achievements.
CommunicationAttention to DetailSales StrategyRelationship BuildingProblem SolvingSales Management+1

Education

Texas McCombs School of Business

Post Graduate Program — Business Analytics and Business Intelligence

Jan 2019Jan 2020

Great Lakes Institute of Management

Post Graduate Program — Business Analytics and Business Intelligence

Jan 2019Jan 2020

Calcutta University, Kolkata

Bachelor of Arts - BA — English Language and Literature

Stackforce found 100+ more professionals with Data Visualization & Data Analysis

Explore similar profiles based on matching skills and experience