Anubhav Srivastava

Anubhav Srivastava

Data Analyst
India
English, Hindi
Full-time Hybrid

نبذة عني

Data Analyst and Business Intelligence professional with 4+ years of experience in SQL development, Power BI reporting, ETL pipelines, data warehousing, and reporting automation. Skilled in SQL, Power BI, DAX, SSIS, SSAS…

الخبرة

Business Intelligence Developer

Tata Consultancy Services (TCS) · Bengaluru, India
Jan 2023 - حتى الآن · 3 سنوات 9 أشهر

<ul><li>Led end-to-end redesign of enterprise BI applications, migrating OLAP-based SSAS reports to Power BI. </li><li>Developed 10+ interactive Power BI dashboards for KPI, financial, and operational reporting. </li><li>Implemented advanced DAX measures (YTD, MTD, YoY, RANKX, CALCULATE) for business analytics. </li><li>Designed SSIS ETL pipelines with incremental load logic to improve data processing efficiency. </li><li>Integrated REST APIs using C# scripts within SSIS packages to extract JSON data, load it into SQL Server, and perform transformations. </li><li>Migrated data extraction to Snowflake after source decommissioning, loading data into the data warehouse for Power BI reporting. </li><li>Optimized data warehouse jobs, reducing execution time by 60% and improving report refresh performance. </li><li>Created an Excel-based order upload template for the M3 system using lookup functions, formulas, and SQL queries to retrieve data from the data warehouse. </li><li>Optimized SQL queries and DAX calculations, reducing report refresh time by up to 30%; supported production deployments and resolved refresh failures. </li></ul>

System Engineer

Infosys · Bengaluru, India
Sep 2021 - Jan 2022 · 4 أشهر

<ul><li>Developed data-driven reporting components by integrating backend APIs with structured datasets for analytical consumption. </li><li>Designed and optimized relational databases (MySQL) to support reporting and business intelligence requirements. </li></ul>

Software Engineer

Janes · Bengaluru, India
May 2020 - May 2021 · 1 سنة

<ul><li>Configured Apache Airflow for automated daily data extraction from multiple external news and intelligence sources. </li><li>Installed and configured ELK Stack for server performance monitoring and analytical reporting. </li></ul>

Summer Intern

IHS Markit · Bengaluru, India
Jun 2019 - Aug 2019 · 1 شهر

<p>Developed a Python-based image optimization tool, reducing website load time and improving server performance.</p>

المشاريع

Sales & Revenue Intelligence Dashboard

Self Help
المدة : 01-Jun-2026 - 01-Jul-2026

<ul><li>Built a Power BI dashboard using a star schema to analyse revenue, profit, and regional sales performance. </li><li>Developed DAX measures for YoY growth, profit margins, and KPIs, identifying high-discount losses and top-performing markets. </li></ul><p></p>

الشهادات

Databricks Certified Data Analyst Associate

databricks · Bengaluru , Karnataka , India · 2026

المهارات

Power BI DAX Power Query Data Modeling Dashboard Development Tableau Databricks AI/BI SSIS SSAS ETL Pipelines Data Warehousing OLAP Cubes Apache Airflow SQL MySQL PostgreSQL Snowflake Advanced SQL Joins CTEs Window Functions Query Optimization PivotTables XLOOKUP VLOOKUP Conditional Formatting Data Validation Python C# ASP.NET SSMS Git Visual Studio
الإبلاغ عن هذا الملف الشخصي؟