Ankita Gare

Senior Data Analyst | Power BI Developer | Business Intelligence Specialist

Talent

PuneMember since September 23, 2026

Power BI ServicePower Query (M)DAX StudioDrill-ThroughRelational Database DesignStar SchemaSnowflake SchemaAdvanced SQLWindow FunctionsStored ProceduresViewsQuery OptimizationIndexingDeployment PipelinesAgile/Scrum

Hire this person

Send a job offer directly to this candidate

Power BI ServicePower Query (M)DAX StudioDrill-ThroughRelational Database Design

About

Result-oriented Senior Data Analyst 3.5 + years of experience & Microsoft Certified Power BI Data Analyst (PL-300) with proven track record delivering enterprise-scale Power BI dashboards, paginated SSRS reports, and robust star/snowflake dimensional models. Proficient in relational database design, complex SQL engineering, stored procedures, and query optimization for high-throughput transactional and analytical systems. Deep expertise spanning Power BI Service administration, DAX Studio optimization, Row-Level Security (RLS), CI/CD pipelines, and data quality governance across financial and regulated environments within Agile/Scrum delivery models.

Experience

Senior Data Analyst / Power BI Developer at Atos Syntel Pvt. Ltd. (2025-08 – Present)

End-to-End Enterprise BI Delivery: Architect and deliver enterprise-grade Power BI dashboards and paginated SSRS reports for leadership, translating complex regulatory and executive requirements into scalable visual solutions.
Data Modelling & Relational Architecture: Design resilient Star and Snowflake schema data models, mapping high-volume transactional tables into optimized fact-dimension structures with strict metadata controls.
Advanced DAX & Query Optimization: Author mission-critical DAX measures, YoY/MoM time-intelligence metrics, and tune query execution plans using DAX Studio and SQL indexing, reducing report render latency by 45%.
SSRS & Paginated Reporting: Develop pixel-perfect SSRS compliance and financial status reports featuring dynamic sub-reports, parameterized cascading filters, and automated scheduled distribution.
BI Governance, Security & Deployment: Administer Power BI Service workspaces, enforce dynamic Row-Level Security (RLS) across geographic regions, set up On-Premises Gateways, and automate releases via CI/CD deployment pipelines.

Data Analyst / BI Developer at Atos Syntel Pvt. Ltd. (2022-09 – 2025-08)

Dashboard Development & Storytelling: Designed and deployed 15+ production Power BI reports and operational dashboards tracking business KPIs, operational health, and revenue variance for stakeholders.
Data Transformation & ETL: Extracted, cleaned, and reconciled multi-million record datasets using SQL and Power Query (M Language), eliminating schema anomalies and resolving null integrity issues.
Advanced SQL Engineering: Built optimized stored procedures, indexed views, and complex analytical CTE queries on relational databases to accelerate data feeding into BI reporting layers.