Software Engineer Business Intelligence

SANJEEVANI GADADE

Email: ****************@*****.***

Mobile: +917*********

Software Engineer with 7.5+ years of industry experience in designing, developing, implementing, deploying complex and strategic BI solutions. Motivated and result driven developer with experience in Business Intelligence (BI), Data Warehouse (DWH) and Data Engineering projects to identify business needs and develop valuable solution to drive accuracy and process efficiency. TECHNICAL SKILLS

Microsoft SQL Server/T-SQL Data Engineering Microsoft Azure ADF Datawarehouse/DWH Business Intelligence/BI SSIS

Microsoft Fabric Azure Datalake SSRS

SOFT SKILLS

Good Communication Problem Solving Ownership

Team player

EXPERIENCE

Enterprise Data Platform Team

Bajaj Finserv (Senior Data Engineer) 09/2023-Present

•Worked on loading core tables of Loan Management System (LMS) from different servers and systemson daily and monthly basis.

•Worked on implementing Microsoft Fabric Platform in the organization. Worked on setting up workspaces, data warehouses and lake houses for different business teams. Integrated various Azure services (Data Lake, SQL Database) with Microsoft Fabric for enhanced data storage and accessibility. Collaborated with cross-functional teams to build custom dashboards and reporting tools using Power BI, streamlining decision-making processes across departments.

•Led the migration of on-premise data pipelines to Microsoft Fabric, optimizing data workflows and improving performance by 25%.

Enterprise Data Warehouse Team

Nihilent technologies (Senior Software Engineer) 03/2021-09/2023

•Working in a Finance domain to load the complete customer related data from different business applications and sources into the enterprise data warehouse system using full load, partial load and incremental load techniques.

•Worked on complex SSIS package design, development and multiple transformations, tasks related to scheduled data load using SQL server jobs. Worked on complex stored procedures, indexes and functions.

•Worked on data migrations from on-premises to Azure cloud data-warehouse system using Azure Synapse Analytics and Azure data factory pipelines and activities which helped to improve the data loading time with more than 50% efficiency. Worked on query optimization and performance tuning. Home Delivery Solution Team

Capgemini (Associate Consultant) 01/2019-03/2021

•Established connections to multiple data sources, on premise data servers, cloud services, several file formats and created datasets and data pipelines for efficient loading of the bigdata.

•Worked on complex SQL objects, stored procedures, functions, performance improvement and tuning for slow performing reports to bring down report rendering time from 15 minutes to 30 seconds.

•Development of complex and custom DAX queries to support ad hoc requests for data

•Communicate with clients and customers to discuss business needs and solutions. Vanguard BI and Reporting Team

Capgemini (Analyst) 07/2017-12/2018

•Migrated data from different business tools and administered the data in relational database management systems using data warehousing and ETL concepts.

•Designed, developed, and deployed SSIS packages to facilitate incremental load process.

•Administered SQL Server database, security constraints, used efficient backup and recovery policies, worked on database tuning and optimization.

ACHIEVEMENTS

B.E. (I.T.), 2017, Pimpri Chinchwad College of Engineering with distinction. Savitribai Phule Pune University.

ACHIEVEMENTS

•Received Star Recognition award for consistent project performance at Capgemini.

•Participated in McDonald’s International Burger Hackathon Event as a part of Pune team.

•Nominated and completed Automation Engineer Practitioner certification provided by GI&A Automation Academy.

Contact this candidate