Back to Developers
ISHIKA BANSAL

ISHIKA BANSAL

Data & Analytics professional

India $20/hr 3+ yrs exp 91 · Outstanding

About

Data & Analytics professional with 3+ years of experience delivering BI, reporting, and analytics solutions for global enterprise and life sciences clients. Strong expertise in SQL, Python, Qlik Sense, Power BI, data modeling, forecasting, and reporting automation. Experienced in translating business requirements into scalable analytical solutions, driving self-service analytics across 15+ countries, and partnering directly with stakeholders to deliver data-driven business insights.

Skills & Expertise (36)

Power BI Advanced
8.0/10
3
Years Exp
Qlik Sense Advanced
8.0/10
3
Years Exp
SQL Advanced
8.0/10
3
Years Exp
Dashboard Development Advanced
8.0/10
3
Years Exp
Python Advanced
8.0/10
3
Years Exp
Pandas Advanced
8.0/10
3
Years Exp
Forecasting Intermediate
7.5/10
3
Years Exp
DAX Intermediate
7.5/10
3
Years Exp
ETL Pipelines Intermediate
7.5/10
3
Years Exp
Power Query Intermediate
7.5/10
3
Years Exp
KPI Analytics Intermediate
7.5/10
3
Years Exp
Statistical Analysis Intermediate
7.5/10
3
Years Exp
NumPy Intermediate
7.5/10
3
Years Exp
Data Modeling Intermediate
7.5/10
3
Years Exp
Data Integration Intermediate
7.0/10
3
Years Exp
Requirements Gathering Intermediate
7.0/10
3
Years Exp
Power Automate Intermediate
7.0/10
3
Years Exp
Advanced Excel Intermediate
7.0/10
3
Years Exp
Stakeholder Management Intermediate
7.0/10
3
Years Exp
Agile Intermediate
7.0/10
3
Years Exp
Scrum Intermediate
7.0/10
3
Years Exp
Sprint planning Intermediate
7.0/10
3
Years Exp
Azure Data Factory Intermediate
7.0/10
2
Years Exp
Databricks Intermediate
7.0/10
2
Years Exp
Azure Synapse Analytics Intermediate
7.0/10
2
Years Exp
Amazon Redshift Intermediate
7.0/10
2
Years Exp
Copilot Intermediate
6.5/10
2
Years Exp
A/B testing Intermediate
6.5/10
2
Years Exp
MySql Intermediate
6.5/10
2
Years Exp
Informatica PowerCenter Intermediate
6.0/10
2
Years Exp
Claude Intermediate
6.0/10
1
Years Exp
ChatGPT Intermediate
6.0/10
1
Years Exp
Prompt Engineering Intermediate
6.0/10
1
Years Exp
AI Intermediate
6.0/10
1
Years Exp
Window Functions CTEs

Work Experience

Business Technology Solutions Associate Consultant (Senior Data Engineer)

ZS Associates

Jul 2026 - Present

Own end-to-end delivery of analytics and reporting solutions using Qlik Sense, Power BI, and SQL, translating business requirements into KPI definitions, dashboard designs, and validated production outputs; shipped 15+ dashboards across 13+ regions and 9+ business units. Leading migration of Qlik Sense dashboards from Amazon Redshift to Databricks — repointing data sources and revalidating SQL/business logic to preserve reporting continuity across the affected dashboard suite. Ran sprint planning, task prioritization, and delivery coordination across 15 analysts, sequencing concurrent analytics initiatives and hitting 98% on-time delivery. Reviewed and signed off Qlik Sense, Power BI, and SQL deliverables from 4 analysts, catching KPI logic and calculation errors pre-release and cutting post-release defects from an average of 10/month to 1/month. Develop and enhance Power BI dashboards using DAX and Power Query, building reusable measures, calculated logic, and interactive visualizations for self-service analysis, cutting new-dashboard build time by 20%.

Business Technology Solutions Associate (Data Engineer)

ZS Associates

Mar 2024 - Jun 2026

Built interactive Qlik Sense dashboards using SQL and Qlik ETL, integrating CRM, sales, and survey datasets across 13+ regions and 9+ business units to provide standardized insights to leadership. Owned 30+ KPIs across monthly and weekly reporting in Qlik Sense/NPrinting reducing manual reporting effort by 50% and improving consistency across regions. Built SQL-based analytical datasets using joins, CTEs, window functions, and business logic, creating reusable reporting layers and reducing dependency on manual spreadsheet calculations. Developed Power BI dashboards using DAX and Power Query for business users, translating business requirements into reusable KPI measures, calculated logic, and interactive visualizations for self-service analysis. Developed Python-based forecasting solutions using Pandas, NumPy, OLS, SES, Holt-Winters, and SARIMA, providing Region–Category–Channel forecasts across a 5-year horizon. Consolidated multi-source datasets using SQL and Databricks, developing governed analytical data models and standardized KPI definitions; automated Excel/PowerPoint reporting using Python and Power Automate, reducing reporting turnaround time by 70% for 100+ stakeholders. Drove self-service analytics adoption across 15+ countries through Qlik Sense & Databricks enablement and training, reducing support tickets by 50%. Implemented Copilot/Claude + Power Automate workflows to automate repetitive reporting, information retrieval, and documentation, reducing manual effort from 8 hours to 15–20 minutes per reporting cycle.

Data Analyst

Birlasoft

Sep 2023 - Mar 2024

Developed ETL pipelines using Azure Data Factory, integrating 3+ heterogeneous data sources through transformation and validation workflows, reducing data processing time by 40%. Optimized analytical data models in Azure Synapse Analytics to support scalable reporting and downstream analytics, improving the structure and performance of analytical datasets. Performed data validation, transformation, and quality checks across source systems, identifying inconsistencies before data reached analytical layers and improving reporting data reliability.

Education

BTech

2019 - 2023 · India

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 5/5
🏆 Certs 0/5
✅ Verified 5/5
Total Score 91/100

Profile Overview

Member sinceOct 2026