Alpesh Jain

About Alpesh Jain

Microsoft certified Data engineer associate with over 3.5 years of experience in IT BI and Data warehouse lifecycleusing SQL server tools like Azure Data FactoryAzure SynapseAzure Data Bricks SSIS SSRS and Power BI Experienced in design and development of PipelinesNotebooksSSIS packages to Extract Transform and Loaddata from heterogeneous sources DeltaParquetAvroCSV etc files Databases to data warehouse OLAP according to userrequirements Experienced in coordinating across various phases of Software Development Life cycle Engaged in DatabaseDesign Development and Maintenance of OLTP system Strong command over creation of various Database objects like Tables Views Indexes Stored Procedures andUser Defined Functions Expertise in creating Workflows based on Functional Specification Document Experience in Deploying andMonitoring ETL packages in SQL Server by job scheduling the flow of packages from Development Server to Testand Production Server Basic experience with Microsoft Power BI and proficiency in creating datasets dashboards reports complexsemantic layers Designed ELTETL pipelines to process delta files using the Mendallion architecture incorporating Azure capabilities and created views for facts and dimensions in the Gold layer for enhanced reporting Migrated Azure synapse pipelines and Databricks notebooks from lower environment to higher environment by creating release pipelines via Azure Devops Proficient in optimizing SQL queries performance tuning using SQL Profiler as well as understanding executionplans Extensive knowledge on SSAS Multidimensional modelPowerBi Dataflows Experienced in creating various reports like Tabular Matrix Drill down Drillthrough Parameterized CascadingConditional Chart Sub Reports and Deploying Reports in report server Coherent with Data Profiling Data Cleansing with Python Data Conversion Performance Tuning Unit TestingSystem Testing User Acceptance Testing Expert in Unit Testing System Integration Testing Performance Tuning and Indepth knowledge in Tuning SQLQueries and improving Query performance Worked closely with the ProjectProgram Managers Business Analyst DataETL developers in determining the exactbusinessrules and functionalities required for deliverables using Agile and waterfall methodology Good knowledge in Multitier and Crossplatform environments strong analytical and leadership qualities withexcellent communication skills

Experience

1. Azure Data Engineer

   Fractal

   Nov 2024 — Present · Gurugram, IN

Education

• Tilak Public School

  SSC

• Tilak Public School

  HSC, PCM

  2015 — 2016

• Rajasthan Technical University

  Bachelor of Technology - BTech, Computer Science engineering