About

Results-driven Data Analyst with 3+ years of experience in data analysis, business intelligence, and reporting across sales, e-commerce, operations, and global trade domains. Skilled in SQL, Python, and Power BI for end-to-end data workflows, including data extraction, cleaning, transformation, modeling, and dashboard development. Experienced in building automated reporting pipelines, performing customer segmentation, and improving data quality through validation and access controls (Row-Level Security).

Experience1

  1. Data Analyst

    Jun 2023 — Present

    NWS Soft Consulting Pvt. Ltd.

    Lead data extraction, transformation, and analysis using SQL, Python, and Excel for client reporting and analytics. Developed and optimized complex SQL queries, built interactive Power BI dashboards with DAX for KPI tracking, and automated reporting workflows using Python and Excel. Improved data quality via validation and implemented Row-Level Security in Power BI to control report access across business domains.

Projects3

  • Sales and Operations Performance Analytics

    Consolidated sales data from SQL Server and Excel reports across industrial and medical equipment divisions, developed Power BI dashboards with advanced DAX measures for sales tracking by product and region, optimized T-SQL queries for reporting, and implemented Row-Level Security for data access control.

    • SQL Server
    • T-SQL
    • Power BI
    • DAX
    • Excel
  • Product Sales and Customer Demand Analytics

    Cleaned and analyzed e-commerce order and customer datasets using Python and pandas, performed SKU-level sales and demand analysis, developed an RFM segmentation model to identify high-value customers, built Power BI dashboards for monitoring sales and revenue, and automated weekly reporting saving 4-5 hours per week.

    • Python
    • pandas
    • matplotlib
    • SQL Server
    • Power BI
    • Excel
  • Global Trade Intelligence and Market Insights

    Cleaned and transformed customs and shipment data across 200+ countries with Python and SQL, developed queries analyzing trade profiles and commodity flows, built Power BI dashboards visualizing import/export volumes and trade growth, identified data completeness issues, and applied indexing and partitioning for database performance.

    • Python
    • SQL
    • Power BI
    • Excel
    • Azure Blob Storage

Education1

  • B.Sc.

    2023

    Indira College of Commerce and Science

    Computer Science