Ing. SAMIT JENA

• Created comprehensive design documents for Azure cloud solutions, ensuring alignment with business requirements and industry best practices. • Mentored junior team members on Azure Databricks and Data Factory, providing guidance on best practices and troubleshooting techniques.

• Led end-to-end data integration solutions using Azure Data Factory (ADF) and Azure Databricks to orchestrate data movement and transform from various sources • Implemented dynamic parameterization and logging mechanisms in ADF pipelines, optimizing data processing workflows, and improving overall pipeline efficiency. • Developed Azure Databricks notebooks using PySpark code to efficiently handle large volumes of data and execute complex data transformations.

• Designed and implemented efficient Extract, Transform, Load (ETL) pipelines to read and process data using Azure Data Factory (ADF) and Azure Databricks, ensuring timely execution and delivery of critical data • Successfully migrated legacy data workflows to Azure Data Factory, converting SQL code to Databricks notebooks and optimized Spark Jobs by analyzing Directed Acyclic Graph (DAG) execution plans. • Developed SSAS Tabular Model, wrote DAX queries to implement various KPI’s in cube

• Created complex SSAS cubes with multiple fact measure groups, and multiple dimension hierarchies and implemented Time Intelligence functions in SSAS cubes • Performed the ETL from databases and flat files sources by using SSIS Packages, contributed to building Data Marts and multi-dimensional models like Star Schema and Snowflake schema • Wrote T-SQL scripts, dynamic SQL, complex stored procedures, functions, and triggers; scheduled and maintained SSIS packages on a daily, weekly and monthly basis

• Formulated and documented detailed business rules and guidelines • Created and maintained 70+ MDX cubes, including complex SSAS cubes with multiple fact measures groups and multiple dimension hierarchies • Developed master cube from which all other cubes could be created and deployed; created automated jobs using SSIS for data validation between current cube and previous cube • Worked on complex MDX query and created SSIS packages for reading and processing daily files

Mathematics, Physics, Chemistry, Economics, Computer Programming