MSBI Developer - Data Engineer - Immediate Joiner

Aniket Rathod

MSBI Developer Data Analytics Data Engineer MS SQL Developer

Software Engineer

*.**********@*****.*** 844-***-**** Pune,Maharastra

www.linkedin.com/in/aniket-rathod-9b9429144

PROFILE

IMMEDIATE JOINER, Currently seeking new opportunities to contribute and grow in a challenging BI environment. Dynamic and results-oriented MSBI Developer with over 5+ years of experience in delivering comprehensive Business Intelligence solutions using Microsoft SQL Server, SSIS, SSRS, and SSAS. Demonstrated expertise in designing and implementing end-to-end BI solutions that align with business goals and enhance decision-making processes. Skilled in data ETL development and report/dashboard creation, with a strong ability to collaborate with cross-functional teams to transform business requirements into scalable, efficient BI solutions. Passionate about utilizing data-driven insights to optimize operations and support strategic decision-making. SKILLS

T-SQL SSIS SSRS SSAS Advanced SQL Power BI DAX DWH Data Modelling MS ACESS ADF Snowflake Excel JIRA Agile Lexis Nexis ERP Control-M PROFESSIONAL EXPERIENCE

BNY - Experis IT Pvt Ltd Payroll, Software Developer Dec 2024 – Present Pune

•Developed and automated user access management processes using T-SQL scripts and SSIS packages.

•Designed and scheduled SSIS workflows to extract overdue alerts via T-SQL, format them into reports (Excel/CSV)

•Implemented system health checks through SQL scripts, monitoring failed jobs, performance metrics, and database status, configured alerts for proactive issue resolution.

•Played a key role in the Batch Job Migration, translating legacy batch logic to new SQL and SSIS processes.

•Provide support for production issue analysis.

•Used PowerShell to automate daily data tasks and reduce manual operational effort and data load monitoring, and system health checks.

APTIA GROUP INDIA,

PUNE SPECIALIST - IMPLEMENTATION SERVICES

Mar 2024 – Sep 2024 Pune, India

This company has recently separated from the Marsh McLennan group and is now operating as an independent entity, while maintaining the same roles and responsibilities as before like, Marsh and McLennan,

PUNE SPECIALIST - IMPLEMENTATION SERVICES

Jun 2022 – Feb 2024 Pune, India

•Extensive experience in data migration, data cleansing, and data mapping, facilitating the extract, transform, and load (ETL) process into target tables and data warehouses.

•Implemented complex logic in mappings by utilizing SSIS transformations such as Lookup, Aggregator, and Expression.

•Worked on Data Migration project where using SQL server, SSIS and SSRS.

•Wrote stored procedure with dynamic queries to migrate the data across different databases of different applications.

•Created SSIS packages to automate the migration.

•Created parameterized integration mapping templates for staging, dimension (Incremental Load), and fact load processes.

•Expertly utilized SSIS transformations such as Execute SQL Task, Data Flow Task, Sequence Container, Conditional Split, For Loop Container, For Each Loop Container, Data Conversion, Derived Column, Multi-Cast, Lookup Transformation

•Improved SSIS performance by implementing error handling, event handling, and checkpoint features to ensure efficient rerun of failed components in SSIS packages.

•Designed and implemented various Database Objects such as Tables, Stored Procedures, Triggers, Rules, Defaults, user-defined data types, and functions for the project, ensuring streamlined data management and access.

•Integrated Python with SQL pipelines to improve data quality and optimize business reporting. Bajaj Finserv, PUNE ASSISTANT MANAGER ANALYST Mar 2020 – Mar 2022 Pune, India

•Executed importing of Source/Target tables from respective databases using Execute Package Task and Control Tasks in SQL Server Integration Services.

•Developed ETL packages based on specifications for staging area and Warehouse data loading leveraging SQL Server Integration Services and SQL Server 2012.

•Automated reporting for diverse business sectors including Urban, Rural, Banking, Consumer, SME by utilizing SSRS and EDW.

•Generated action filters, parameters, and calculated sets to prepare insightful dashboards and worksheets in Power BI.

•Designed Power BI visualizations and dashboards using Power BI Desktop.

•Created various Dashboards such as Insta EMI card funnel, Cash management Dashboard, Rural Dashboard, and Mandate Related Dashboard.

•Constructed interactive Power BI Dashboards with views, trends, and drill downs for enhanced data analysis.

EDUCATION

DYPIT, Pune, Bachelor of engineering Completed in 2018

Contact this candidate