Back to Developers
Ankit Panwar

Ankit Panwar

Senior Associate

New Delhi, INDIA
80
Profile Score

About

With 5 years of experience, I specialize in designing scalable SQL queries for efficient data extraction and analysis. Proficient in Python for large dataset analysis, I consistently deliver actionable insights that support strategic business decisions. Skilled in developing comprehensive reports and interactive dashboards using leading BI tools, I drive data-driven strategies to improve organizational performance. My expertise spans data management, visualization, and analytics, ensuring accurate, timely, and impactful information delivery for stakeholders.

Skills & Expertise (17)

Python Advanced
8.2/10
5
Years Exp
SQL Advanced
8.0/10
5
Years Exp
Power BI Advanced
7.8/10
3
Years Exp
Azure Data Factory Intermediate
7.5/10
2
Years Exp
Azure Databricks Intermediate
7.0/10
2
Years Exp
ADF ETL ADLS Gen2 Excel (VBA, Power Query) PySpark Git DAX Warehouse Data Validation Delta Lake Pipeline ELT

Work Experience

Senior Associate

AMAZON DEVELOPMENT CENTRE

Mar 2021 - Feb 2024

Led end-to-end delivery of recurring business reports and interactive Power BI dashboards, supporting Seller Operations, Risk, and Compliance teams, driving enhanced data-driven decision-making and operational insights. Developed and optimized advanced SQL queries leveraging CTEs, window functions, and complex joins to analyze seller performance, detect fraud indicators, improve retention rates, and monitor key operational KPIs across large-scale datasets. Created automated Power BI reports with efficient data models and dynamic DAX measures, reducing manual reporting efforts by 40% and increasing leadership visibility into critical business metrics. Leveraged Python (Pandas, NumPy) to perform data cleansing, transformation, and complex ad-hoc analyses on high-volume datasets, enhancing data accuracy and boosting process efficiency by an estimated 30%. Collaborated cross-functionally with operations, compliance, and program management teams to translate complex business requirements into scalable, actionable analytical solutions. Improved reporting efficiency and reduced decision-making turnaround time by implementing automation workflows and establishing standardized metric ownership across multiple teams. Focus Areas: Seller performance evaluation, revenue and category analysis, user behavior analytics, retention strategy development, and operational efficiency optimization.

Analyst

Contrion Technologies

Jan 2018 - Feb 2021

Conducted comprehensive data requirement gathering to identify client needs and project objectives. Executed data collection utilizing web scraping techniques, including Beautiful Soup and Selenium, to extract relevant information. Cleaned and manipulated datasets using Pandas, ensuring high data quality aligned with client specifications. Performed A/B testing to evaluate the conversion rates of new features on product pages, providing insights for product optimization. Collaborated with cross-functional teams to translate data findings into actionable recommendations for stakeholder decision-making.

Education

B.Tech/B.E. in Computers - Gb pant govt. engineering college, Delhi, GGSIPU

- 2018 · Afghanistan

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 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 80/100

Profile Overview

Member sinceFeb 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation

Skills (17)

Python SQL Power BI Azure Data Factory Azure Databricks ADF ETL ADLS Gen2 Excel (VBA, Power Query) PySpark +7 more