Sohil Khan

Business Analyst

Delhi, India1 yr 11 mos experience

Key Highlights

Expert in transforming complex datasets into actionable insights.
Proficient in advanced Excel and Power BI for data visualization.
Skilled in automating reporting workflows to enhance productivity.

Stackforce AI infers this person is a Data Analyst with expertise in Logistics and Finance sectors.

Contact

Skills

Core Skills

Data AnalysisData VisualizationReporting

Other Skills

Analytical SkillsAnalyticsAttention to DetailAutomationBig DataBusiness InsightsCustomer Relationship Management (CRM)DAXDashboard MetricsDashboardsData AnalyticsData CleaningDatabasesExcelGoogle Sheets

About

Skilled and detail-oriented Data Analyst with expertise in data analysis and visualization. Proficient in advanced Excel, with a strong ability to manipulate and analyze complex datasets. Experienced in using Power BI for creating interactive and insightful visualizations to support decision-making. Proficient in Python for data analysis, automation, and scripting, and well-versed in MySQL for efficient database querying and management. Adept at identifying trends, providing actionable insights, and driving data-driven decisions to enhance business performance.

Experience

1 yr 11 mos

Total Experience

1 yr

Average Tenure

11 mos

Current Experience

M 5 continent logistics solution (p) ltd.

Data Analyst

Jul 2025 – Present · 11 mos · Dwarka, Delhi, India · On-site

As a Data Analyst at M 5 Continent Logistics Solution Private Limited, I focus on transforming transportation data into valuable insights that support strategic and operational decisions. My responsibilities include downloading and consolidating data from internal portals, followed by thorough data cleaning and transformation using Excel and Power Query.
I create dynamic reports and dashboards using advanced Excel tools such as Pivot Tables, Macros, and VBA, and build impactful visualizations in Power BI using DAX and Power Query. These insights help the team monitor performance, identify trends, and make informed decisions.
My analytical approach includes applying techniques like ABC classification, customer segmentation, RFM (Recency, Frequency, Monetary) analysis, cohort analysis, and what-if scenarios to explore business opportunities and optimize processes.
I collaborate with cross-functional teams to provide accurate, actionable insights while continuously improving and automating reporting workflows.

Data AnalysisData CleaningPower BIExcelDAXPower Query+1

Paydash

MIS Executive

Jul 2024 – Jul 2025 · 1 yr · On-site

Managed data analysis and reporting using Excel, and Power BI, ensuring accurate business insights and decision-making
support.
Developed automated dashboards and reports to track key performance indicators (KPIs), sales trends, and operational
efficiency.
Streamlined data collection and validation processes, reducing manual errors and improving report turnaround time.
Maintained and optimized MIS systems, ensuring data integrity and security while handling large datasets efficiently.
Collaborated with cross-functional teams to generate reports for finance, sales, and operations, enhancing strategic planning.
Utilized VLOOKUP, Pivot tables, Macros, and VBA to automate reports, improving productivity by 100%.
Assisted in forecasting, budgeting, and compliance reporting, contributing to financial planning and business growth.