Sandeep Sain

Data Analyst | Power BI Developer

Delhi 5+ yrs exp 90 · Outstanding

About

Data Analyst with 5+ years of experience and 4 years of dedicated Power BI expertise, delivering ~30 production dashboards built on DAX-driven models for Orders, Revenue, and P&L reporting. Skilled in SQL, dimensional modeling (Star/Snowflake schema), and translating business requirements into scalable BI solutions, with data sourced and validated across Oracle, Snowflake, and Google BigQuery. Manages the end-to-end reporting lifecycle — from requirements gathering and data validation to executive dashboard delivery — backed by a strong ETL/SQL foundation (SnapLogic, PL/SQL) that ensures reporting data is accurate, reconciled, and audit-ready. Added exposure to Tableau, KPI monitoring, and data governance.

Skills & Expertise (24)

Power BI Advanced

8.5/10

Years Exp

DAX Advanced

8.0/10

Years Exp

SQL Advanced

8.0/10

Years Exp

Python Intermediate

7.5/10

Years Exp

Data Cleansing Advanced

7.5/10

Years Exp

KPI Monitoring Advanced

7.0/10

Years Exp

Dimensional Modeling Intermediate

7.0/10

Years Exp

Tableau Intermediate

6.5/10

Years Exp

Git Intermediate

6.0/10

Years Exp

NoSQL Intermediate

6.0/10

Years Exp

Airflow Intermediate

5.5/10

Years Exp

Informatica Intermediate

5.0/10

Years Exp

Compliance Documentation Data Governance Jira Transformation Snaplogic Snowflake Google BigQuery SQL Server Oracle SQL NumPy Pandas Excel

Work Experience

System Engineer

Tata Consultancy Services

Apr 2021 - Present

Designed, published, and maintained ~30 Power BI dashboards, building DAX measures and calculated columns (including variance and cumulative logic) on Star/Snowflake schema data models for Orders, Revenue, and P&L reporting. Partnered directly with clients to gather and analyze reporting requirements, translating them into scalable BI solutions and presenting finished dashboards to business stakeholders. Built and optimized data models in Snowflake, handling slowly changing dimensions and complex data mappings to keep reporting layers accurate and scalable. Applied data cleansing, transformation, and validation methods prior to visualization, identifying and resolving discrepancies between source systems and reporting layers to ensure dashboard accuracy. Extracted and integrated data from multiple source systems (Oracle, Excel, Kafka, DB2, Google BigQuery) using SnapLogic ETL mappings and SQL/PL-SQL scripts to feed reporting layers. Performed source-to-target data validation and reconciliation using SQL, and supported UAT/regression testing cycles for BI releases to confirm outputs matched business requirements. Worked hands-on with complex Oracle stored procedures, functions, and packages, plus SQL querying on Google BigQuery, to support ad hoc analysis and reporting needs. Migrated mappings, sessions, and workflows across Development, Testing, and Production environments, supporting reliable, production-grade reporting releases. Prepared technical documentation, data dictionaries, and process flows supporting audit, compliance, and data governance requirements.