ABHISHEK PAL

Data Analyst · SQL Developer

New Ashok Nagar, Delhi, India

@abhishek_pal1

0 followers

🎓 B.Tech in Computer Science Engineering at J.S. University · Graduated 2025

About

Data Analyst and SQL Developer with 4 years of experience in SQL, ETL, reporting, and dashboard development. Experienced in Power BI, Python, Excel, and data quality improvement for large-scale datasets.

Experience

Data Analyst Role

Srivastava Infotech Software Solutions Pvt. Ltd · Sector-10, Noida, UP

Oct 2025 – Present

Managed and analyzed large-scale survey and business datasets using SQL Server and Excel; improved data quality through validation rules and duplicate detection; developed SQL Server stored procedures and ETL workflows to automate data processing, validation, and reporting.
SQL Developer Role

Srivastava Infotech Software Solutions Pvt. Ltd · Sector-10, Noida, UP

Aug 2022 – Present

Designed and optimized complex SQL queries using CTEs, window functions, and advanced joins; designed and implemented ETL pipelines; created and maintained stored procedures, views, and indexes to optimize query performance.

Education

2025

B.Tech in Computer Science Engineering

J.S. University

Computer Science · 2022 – 2025

Computer Science · 2022 – 2025
2021

Diploma in Computer Science Engineering

Prasad Polytechnic

Computer Science · 2018 – 2021

Computer Science · 2018 – 2021
2018

Intermediate

Swami Dayanand SIC

2017 – 2018

2017 – 2018
2014

High School

Mission English School

2013 – 2014

2013 – 2014

Skills

2 to 5 years

SQL ETL Window functions Stored Procedures Query Optimization

1 to 2 years

Python Reporting Data Analysis Data Cleaning Data validation

<3 months

KPI Development Dashboard Development Exploratory Data Analysis

Tools / apps / platforms

2 to 5 years

Microsoft SQL Server

1 to 2 years

Microsoft Excel

<3 months

Git MySQL GitHub VS Code Jupyter Notebook Microsoft Power BI

Projects

PhonePe Transaction Data Analysis

Python, SQL, Power BI

Analyzed millions of transaction records to identify user growth trends and transaction patterns. Built interactive Power BI dashboards and found that the top 10 cities accounted for 65% of total transaction volume.
Luxury Housing Sales Analysis – Bengaluru

Python, SQL, Power BI, Excel

Analyzed 100,000+ luxury property records to identify sales trends and high-growth markets. Used Python for data processing, SQL for analysis, and Power BI dashboards for visualization.
Bihar Government Survey Data Analytics & ETL Processing

SQL Server, Stored Procedures, ETL, Excel, VBA/Macros, Data Validation

Processed and managed large-scale government survey datasets; performed data cleaning, validation, duplicate detection, and quality assurance; developed SQL Server stored procedures and ETL workflows to automate survey data processing and database integration.

Courses & certifications

Master Data Science Program · GUVI (Powered by HCL)

🏆 Achievements & awards

Improved report generation speed by 30%

Optimized SQL queries to improve report generation speed by 30% and developed 10+ interactive Power BI dashboards used by cross-functional teams.

Explore the Broxer community

💬 Q&A Ask about roles, salaries and interviews — and help others. 👥 Circles Join discussions on skills, companies and industries. 📰 Feed Follow updates and insights from the community.