Haridas Janjire

WORK HISTORY

EDUCATION

SKILLS

ABOUT HARIDAS JANJIRE

Seasoned Data and Analytics Engineer with 12+ years of expertise in designing and implementing scalable cloud-based data and analytics solutions. Strong knowledge of data warehousing, Data modeling, data governance, performance and Cost optimization using Spark and cloud-native solutions. Technical Skills & Competencies Languages: SQL, Python, PySpark, DAX, MDX, Power query. Cloud Platforms: Azure Data Lake, Delta Lake, Synapse Analytics. Big Data Tools: Databricks, Fabric, Apache Spark, Delta Lake, Hive, Dremio. ETL & Orchestration: Azure Data Factory, Logic Apps, SSIS. Databases: Azure SQL, PostgreSQL, SQL Server, Snowflake, Synapse pool. Data Modeling: Star/Snowflake Schema, Dimensional Modeling, Normalization Analytical & Reporting Tools: SSAS (SQL Server Analysis Services), Multidimensional & Tabular Models, POWER BI. Security & Governance: Azure Key Vault, RLS, Unity Catalog, RBAC, Managed Identity, Service Principle. DevOps/Tools: Git, TFS, Azure DevOps, JIRA Designed and led implementation of modern data platform on Azure using Data Lakehouse architecture. Designed and implemented end-to-end data warehouse and BI solutions usingAzure Synapse DW/ Snowflake and MDX/tabular OLAP Cube, Power BI stack. Led migration of legacy DWH (SSIS/SQL Server/Teradata) to cloud-native pipelines using ADF and Databricks. Orchestrated ADF pipelines with Databricks notebooks/Lakeflows, Azure Analysis Services, Synapse, Logic Apps and implemented CI/CD using Azure DevOps. Reduced data processing time and cost by 60% through optimal cluster sizing, type of VMs, various Spark optimizations and data distribution techniques, Z-ordering, and optimized joins, liquid clustering techniques. Architected and developed Semantic Delta Lakehouse Model with Collaboration of Databricks Serverless and power BI dataset which replace Synapse/Snowflake DW, AAS and MDX cube. Expertise in Data warehousing, Data Modeling, logical and physical database schema design, Query optimization, performance tuning. Built SSAS cubes and Tabular models for high-performance OLAP reporting with calculated measures using MDX and DAX. Designed and implemented Semantic model, interactive dashboards and data visualizations, paginated reports. Skilled in DAX, Power Query, SQL, and creating end-to-end BI solutions using Microsoft Power Platform and Azure data services. Created SSIS packages to Extract, Transformation and Load ETL user data and other data from OLTP to OLAP.