Back to Developers
Abhay singh

Abhay singh

Data Analyst

New Delhi, India 3+ yrs exp 86 ยท Excellent

About

Data Analyst with over 2 years of experience transforming complex datasets into actionable business intelligence using Python, SQL, and Power BI. Proven track record of designing robust end-to-end ETL pipelines, automating operational workflows, building interactive dashboards and delivering ad-hoc reports that significantly reduce manual reporting effort and drive strategic executive decision-making. Adept at performing rigorous data validation and query optimization to ensure maximum data quality and governance.

Skills & Expertise (22)

Advanced Excel Advanced
8.0/10
2
Years Exp
Power BI Advanced
8.0/10
2
Years Exp
Python Intermediate
7.5/10
2
Years Exp
SQL Intermediate
7.0/10
2
Years Exp
Postgresql Intermediate
7.0/10
2
Years Exp
DAX Intermediate
6.5/10
2
Years Exp
Pandas Intermediate
6.5/10
2
Years Exp
NumPy Intermediate
6.0/10
2
Years Exp
Power Query Intermediate
6.0/10
2
Years Exp
Matplotlib Intermediate
5.5/10
2
Years Exp
Seaborn Intermediate
5.0/10
2
Years Exp
SQLAlchemy Intermediate
5.0/10
2
Years Exp
OpenpyXL Intermediate
5.0/10
2
Years Exp
XlsxWriter Intermediate
5.0/10
2
Years Exp
Regex Intermediate
5.0/10
2
Years Exp
Git Intermediate
5.0/10
2
Years Exp
GitHub Intermediate
5.0/10
2
Years Exp
SAP Intermediate
4.5/10
2
Years Exp
Zoho CRM Intermediate
4.0/10
2
Years Exp
RLS Power BI Services MongoDb

Work Experience

Data Analyst

MacTrigon Pvt Ltd

Aug 2024 - Present

Developed 17+ interactive Power BI and Advanced Excel dashboards for 50+ business users, reducing manual reporting effort by 60% and enabling data-driven decision-making across Revenue, AOV, Order Performance, Customer Retention, Seller Performance, Product/Category Trends, Payment Behaviour, and Delivery KPIs. Integrated and transformed data from CSV, Excel, AWS, GCP, Snowflake, and PostgreSQL, performing ETL, data validation, data cleansing, data modelling, and KPI development to deliver scalable business intelligence and automated reporting solutions. Automated daily PostgreSQL ETL/ELT workflows using Python and pgAgent, including data ingestion, staging, validation, incremental loading, and import logging to improve data-processing efficiency and reporting reliability. Analyzed SAP financial transaction data across invoices, payments, vendor/customer transactions, and FI/CO records, performing data validation, reconciliation, discrepancy analysis, and financial reporting support to improve data accuracy. Performed ABC/Pareto, Cohort, RFM, Customer Segmentation, and Trend Analysis across sales, customer, product, and transaction data to identify revenue drivers, high-value customers/products, purchasing patterns, and business growth opportunities.

Business Operations

Turito India Pvt Ltd

Mar 2023 - Mar 2024

Collected, validated, reconciled, and consolidated data from Sales, CRM, Finance, and Operations teams, identifying data discrepancies and maintaining accurate business records for management reporting. Developed and maintained Daily, Weekly, and Monthly MIS reports using Advanced Excel to track sales performance, lead conversion, operational KPIs, and business trends, supporting leadership decision-making. Analyzed sales funnel, customer touchpoints, conversion trends, and pipeline performance to identify revenue growth opportunities and provide actionable insights for operational strategy. Performed data reconciliation, quality checks, Excel-based analysis, and cross-functional reporting to improve data accuracy and ensure timely delivery of business-critical reports.

Education

BBA in Economics - Lovely Professional University

2018 - 2021 ยท Afghanistan

MBA in Data Science (Distance Education) - Lovely Professional University

- 2027 ยท Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 11/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 86/100

Profile Overview

Member sinceSep 2026