07/13/2026 updated
100 % available
Data Analyst | SQL, Python,Excel & Power BI Specialist
Varanasi, India
India
B.Tech, Computer Science & Engineering (expected 2026), DY Patil University, PuneAbout me
I am Sarthak, a Data Analyst skilled in SQL, advanced Excel, Python data tools, and Power BI. I specialize in engineering dynamic dashboards and extracting actionable insights for the logistics sector. I thrive on turning complex datasets into strategic solutions that drive real business growth.
Data AnalysisBusiness IntelligenceBusiness AnalysisExtract Transform Load (ETL)Data Manipulation LanguagesData TransformationData VisualizationDatabase QueriesPython (Programming Language)Predictive AnalyticsMicrosoft Power BISQL Databases
SQL & Database Engineering
Expertise in SQL with MySQL and PostgreSQL, including advanced techniques such as CTEs, window functions, subqueries, and RANK() OVER(PARTITION BY). Design and implementation of PostgreSQL schemas for complex analytical use cases.
Python for Data Analysis
Proficiency in Python using Pandas, NumPy, and Matplotlib for data cleaning, transformation, exploratory analysis, and pipeline automation. Application of Python to process datasets exceeding 450,000 records.
Power BI & Data Visualization
Development of multi-page interactive Power BI dashboards with DAX measures, star-schema data modelling, and drill-through reporting. Creation of visualizations for KPI tracking, geospatial sales performance, and cybersecurity threat intelligence.
Microsoft Excel
Advanced use of Microsoft Excel including complex formulas, pivot tables, and data cleaning. Building reusable dashboards to standardize cross-team reporting.
Tableau
Knowledge of Tableau as a data visualization tool for presenting analytical findings to stakeholders.
Exploratory Data Analysis & Data Wrangling
Hands-on experience conducting exploratory data analysis on real-world business datasets, identifying key trends, and delivering structured insight reports to support management decisions.
KPI Reporting & Process Automation
Automation of recurring SQL and Excel reporting pipelines, eliminating manual effort on weekly data extraction and reducing report turnaround time. Definition and tracking of KPIs across sales and security domains.
Jupyter Notebook & Git
Use of Jupyter Notebook for interactive data analysis and Git for version control in data projects.
Threat Intelligence & Cybersecurity Analytics
Analysis of 450,000+ raw honeypot network attack logs to extract threat intelligence, isolate top attacker IPs per country, and calculate botnet attack velocity from sequential timestamps.
Expertise in SQL with MySQL and PostgreSQL, including advanced techniques such as CTEs, window functions, subqueries, and RANK() OVER(PARTITION BY). Design and implementation of PostgreSQL schemas for complex analytical use cases.
Python for Data Analysis
Proficiency in Python using Pandas, NumPy, and Matplotlib for data cleaning, transformation, exploratory analysis, and pipeline automation. Application of Python to process datasets exceeding 450,000 records.
Power BI & Data Visualization
Development of multi-page interactive Power BI dashboards with DAX measures, star-schema data modelling, and drill-through reporting. Creation of visualizations for KPI tracking, geospatial sales performance, and cybersecurity threat intelligence.
Microsoft Excel
Advanced use of Microsoft Excel including complex formulas, pivot tables, and data cleaning. Building reusable dashboards to standardize cross-team reporting.
Tableau
Knowledge of Tableau as a data visualization tool for presenting analytical findings to stakeholders.
Exploratory Data Analysis & Data Wrangling
Hands-on experience conducting exploratory data analysis on real-world business datasets, identifying key trends, and delivering structured insight reports to support management decisions.
KPI Reporting & Process Automation
Automation of recurring SQL and Excel reporting pipelines, eliminating manual effort on weekly data extraction and reducing report turnaround time. Definition and tracking of KPIs across sales and security domains.
Jupyter Notebook & Git
Use of Jupyter Notebook for interactive data analysis and Git for version control in data projects.
Threat Intelligence & Cybersecurity Analytics
Analysis of 450,000+ raw honeypot network attack logs to extract threat intelligence, isolate top attacker IPs per country, and calculate botnet attack velocity from sequential timestamps.
Experience
Professional experience0 - 5 years
Freelancer since2026
Languages
EnglishFluent
Project history
Ingested, cleaned, and analysed 450,000+ raw honeypot network attack logs using Python (Pandas). Engineered a PostgreSQL schema and wrote advanced SQL queries using RANK() OVER(PARTITION BY), CTEs, and window functions to extract threat intelligence. Built a dark-themed Power BI SOC dashboard with DAX measures to visualize global threat actors in real time.
Engineered a multi-page Power BI dashboard with DAX measures to analyse $769M in mobile sales data, tracking KPIs including transaction volume, average order value, and regional market share across 12+ regions. Implemented a star-schema data model and visualized geospatial sales performance and seasonal demand trends.
Led end-to-end development of a digital marketplace for agricultural labour as Project Lead; owned technical documentation, timelines, and stakeholder demos. Project won an internal university hackathon. Analysed public agricultural datasets to build predictive models forecasting labour demand by region and season.
Certificates
Data Analytics Essentials
Cisco2026
Data Analytics Essentials
Cisco2026
Data Analytics Essentials
Cisco2026
Data Analytics Essentials
Cisco2026
Data Analytics Essentials
Cisco2026
Data Analytics Essentials
Cisco2026