Sushil Rajendra Bandal
Pune
Summary
· Holding 9+ Years of experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) database applications using Azure Cloud (ADF,Databricks,Spark,PySpark,and Spark-SQL),MSSQL Server 2014/2016 SQL Server Integration, Reporting & Analysis Services.
· Experience on Migrating SQL database to Azure data Lake, Azure data lake Analytics, Azure SQL Database,DataBricks and Azure SQL Data warehouse
· And Controlling and granting database access and Migrating On premise databases to Azure Data Lake store using Azure Data factory.
· Experience in Developing Spark applications using Spark - SQL in Databricks for data extraction, transformation and aggregation from multiple file formats for analyzing & transforming the data to uncover insights into the customer usage patterns.
· Good understanding of Spark Architecture including Spark Core, Spark SQL,DataFrames, Spark Streaming, Driver Node Worker Node,Stages,Executors and Tasks.
· Experience in Database Design and development with Business Intelligence using SQL Server 2014/2016, Integration Services (SSIS), DTS Packages, SQL Server Analysis Services (SSAS), OLAP Cubes, Star Schema and Snowflake Schema.
· Excellent communication skills with excellent work ethics and a proactive team player with a positive attitude.
· Domain Knowledge of Finance, Insurance, Travel and HealthCare.
· Strong skills in SSRS reporting tool. Tabular & Matrix reports design & development.
· Expertise in various phases of project life cycles (Design, Analysis, Implementation and testing).
· Lead database administration and database performance tuning efforts
· to provide scalability and accessibility in a timely fashion, provide 24/7 availability of data, and solve end-user reporting and accessibility problems.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Azure Data Engineer
Synergycom Technologies Pvt. Ltd .
05.2024 - 02.2025
- Designed and implemented scalable ETL/ELT pipelines using Azure Data Factory (ADF) and Databricks.
- Ingested and transformed structured and unstructured data from various sources, including SQL databases and cloud storage (ADLS).
- Developed high-performance Spark jobs in Databricks for processing large volumes of data.
- Optimized Delta Lake performance for efficient querying and data versioning.
- Integrated multiple Azure services, including Azure Synapse Analytics, Azure SQL Database, and Azure Data Lake Storage (ADLS Gen2).
- Implemented incremental data processing using ADF mapping data flows and pipelines.
- Wrote and optimized complex SQL queries, stored procedures, and indexing strategies for high-performance data retrieval.
- Designed data models and schema structures for scalable database architecture.
- Worked closely with U.S. stakeholders, data analysts, and business teams to deliver insights-driven solutions.
- Maintained technical documentation, data flow diagrams, and best practices for future reference.
- Performed daily support activities, including monitoring and troubleshooting scheduled jobs, ensuring timely execution, and resolving failures to maintain system reliability.
Azure Data Engineer
Synechron Technologies
10.2021 - 02.2024
- Analyse, design and build Modern data solutions using Azure PaaS service to support visualization of data.
- Understand current Production state of application and determine the impact of new implementation on existing business processes.
- Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and T-SQL Azure Data Lake Analytics.
- Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, ADF) and processing the data in Azure Databricks.
- Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse.
- Developed Spark applications using Pyspark and Spark-SQL for data extraction, transformation and aggregation from multiple file formats for analyzing & transforming the data to uncover insights into the customer usage patterns.
- Experience in Database Design and development with Business Intelligence using SQL Server 2014/2016, Integration Services (SSIS), DTS Packages, SQL Server Analysis Services (SSAS), OLAP Cubes, Star Schema and Snowflake Schema.
- Responsible for estimating the cluster size, monitoring and troubleshooting of the Spark data bricks cluster.
- Experienced in performance tuning of Spark Application.
Azure Data Engineer/MSBI Developer
Capgemini Technology
10.2019 - 10.2021
- Understand the project requirements and the architecture diagram designed for the way the pipeline is expected to run.
- Establishment of Azure Data Factory for the development, testing and production environment.
- Deployment through CI-CD released pipeline for Dev to Test and Test Production deployment.
- Created a linked service for the blob storage and Azure Sql Server.
- Implementation of the dataset needed to create a pipeline.
- Transformation used as Filter, Alter Rows, Get Metadata, Copy Data, Azure Logical Apps, Azure function, Lookup, Derived Column, Staged, etc.
- We collaborated with the Power BI team, assisting them in leveraging ADF and Databricks functionalities for easy data utilization and dashboard creation.
- All the necessary logic was implemented within the Databricks environment.
- One Year worked as MSBI developer- Designed SSIS Packages to transfer data from flat files, Excel SQL Server using Business Intelligence Development Studio.
- Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
MSBI Developer
Janata Bank [Data-Center]
03.2015 - 10.2019
- Designed various staging, warehouse and Data mart SSIS packages.
- Analyzed business requirements, facilitating planning and implementation phases of the OLAP model in Team meetings.
- Participated in Team meetings to ensure a mutual understanding with business, development and test teams.
- Created SSIS packages to implement error/failure handling with event handlers, row redirects, and loggings.
- Obtained user approval from the client for the collected requirements to ensure similar understanding between development team and business.
- Design Drill-down, Drill through, cascade parameterized Reports in SSRS.
Education
Bachelor of Engineering - Computer
01.2013
Skills
- Azure Data lake
- Azure Data factory
- Azure Synapse
- Azure Key vault
- Azure Databricks
- Spark
- PySpark
- Azure SQL database
- Azure SQL Data warehouse
- Spark SQL
- MSBI (SSIS, SSAS, SSRS)
- Data Visualization
- Data Migration
- Analytic Problem-Solving
- Agile
- Jira
- Active Job
- SQL Server
- Denodo (Reporting Tool)
- MySQL
- Amazon Redshift
Certification
- Microsoft Certified: Azure Data Engineer (DP-203)
- Microsoft Certified: Azure Data fundamental (AZ-900)
- Databricks Data engineer associate (Scheduled)
Accomplishments
· STAR Award- Recipient of the Start Award for outstanding performance and contributions to project management leadership, innovation, and driving successful project outcomes. (Synechron client)
· SPOT Award- For Major role performed in Migration project (Synechron)
· Best employee award April 2020 for handling P1 ticket alone which stopped business impact in the production environment (Capgemini)
· Surpass Award: Successfully completed CBS migration(Janata Bank DC)
Languages
Marathi
First Language
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Timeline
Azure Data Engineer
Synergycom Technologies Pvt. Ltd .
05.2024 - 02.2025
Azure Data Engineer
Synechron Technologies
10.2021 - 02.2024
Azure Data Engineer/MSBI Developer
Capgemini Technology
10.2019 - 10.2021
MSBI Developer
Janata Bank [Data-Center]
03.2015 - 10.2019
Bachelor of Engineering - Computer
Similar Profiles
Venkata Nagaraju InakolluVenkata Nagaraju Inakollu
Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)
S ChetanS Chetan
Assistant Manager - Finance at ANIMALL TECHNOLOGIES PVT LTD, Technologies Pvt LtdAssistant Manager - Finance at ANIMALL TECHNOLOGIES PVT LTD, Technologies Pvt Ltd
Shweta SinghShweta Singh
Support Engineer-IT at I-Telemetry Technologies Pvt. Ltd. (Subsidiary of Aaxis Nano Technologies Pvt. Ltd.)Support Engineer-IT at I-Telemetry Technologies Pvt. Ltd. (Subsidiary of Aaxis Nano Technologies Pvt. Ltd.)
Soumyadeep GhoshSoumyadeep Ghosh
Graduate Engineer Trainee at Air ProductsGraduate Engineer Trainee at Air Products
Pooja Anil SuryawanshiPooja Anil Suryawanshi
Senior Software Engineer at FIS GlobalSenior Software Engineer at FIS Global