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
Data Analyst
Jun 2023 — PresentNWS 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.
2023Indira College of Commerce and Science
Computer Science