Ruchita Jadhav
Business Intelligence Specialist
Ballerup Municipality
Summary
7+ years of Expertise in Business Intelligence and Data Visualisation, I am skilled as BI consultant who has delivered data-driven solutions with a proven track record of Designing, Developing, Reports, Dashboards, and Analytical solutions using MSBI, Power BI, Datawarehouse, DAX, Python, Azure Data Factory, SQL on-Prem as well as on Cloud Solution. A keen planner, strategist and implementer with demonstrated success in end-to-end project management and technical consultation. I have mentored and trained junior BI developers and collaborated with cross-functional teams and Customers to ensure the alignment of the BI deliverables with the business requirements and best practices.
Overview
15
15
years of professional experience
2
2
Certifications
1
1
Language
Work History
Advanced Business Intelligence Developer
Novo Nordisk
05.2024 - Current
- Lead initiatives to analyze supply chain health, implementing actionable insights that enhance operational efficiency and effectiveness.
- Conducted thorough analyses to identify which BI solutions are most effective for specific use cases, selecting optimal tools to meet operational requirements.
- Design and develop dynamic dashboards, enabling stakeholders to visualize key metrics and make data-driven decisions.
- Collaborate with Production Planners and Affiliates to gather requirements, ensuring alignment with business needs and enhancing analytical capabilities.
- Spearheaded the development of Inventory Key Performance Indicators (KPIs), effectively coordinating with Data Engineering, Architecture, and Analytics teams for successful implementation.
- Drive data operations through experienced use of Fabrics Workspaces, streamlining deployment pipelines for enhanced data accessibility and performance.
- Analyze complex datasets utilizing Databricks; create compelling visualizations using Power BI to facilitate strategic insights.
BI Specialist
Infosys (Contract)
10.2023 - 05.2025
- Handled End to End BI Solution, right from getting the data into staging, using SSIS as ETL, to Data warehouse, populating Cubes (SSAS) and Handling report in Targit
- Worked on multiple sources such as Flat Files, IBM DB2, MS SQL in SSIS
- Worked with Azure Devops for deployment and version control of packages, Deployed Packages to Dev/Test/Prod successfully by following necessary protocols
- Created accurate and efficient solutions for data warehousing, Implemented Incremental Load and SCD as per the Business requirements
- Implemented Error Handling and Event handling Techniques
- Developed Data Pipelines in Azure Data Factory to handle data loads from multiple source systems
- Developed Data Model and ETL process for Power BI
- Implemented DAX, redesigned existing reports as per the requirements
- Mentored and Guided Team of 5 members
- Documented the Data Model and Architecture
- STARK Project
Sr. Specialist
LTI Mindtree
02.2023 - 05.2023
- Successfully completed a short-term project for Johnson Controls, which focused on the archival of data and reports
- Led the project and effectively managed a team of 4 members. Collaborated on building pipeline in Azure Data Factory and creating SQL scripts in Hive DB to facilitate report development
- Conducted in-depth analysis of the data model to comprehend the table relationships, enabling the development of accurate and relevant scripts
- Johnson Controls Project
Sr. Lead Business Intelligence Analyst
Dot solved System (Contract)
07.2022 - 01.2023
- Worked on Snowflake and Python to create queries for ad-hoc and monthly dashboards and ETL respectively
- Successfully worked on enhancing the design and aesthetics of 20 to 30 Power BI reports through template designing and improvements
- Collaborated with Fresh work to develop an Insight Driven Report, focusing on Product Sales Analysis
- Created Power BI Shared Dataset to optimize and ease maintenance of reports
- Freshworks
Sr. Lead Business Intelligence Analyst
First Rand Services
08.2021 - 07.2022
- Developed a Sales Data-Mart specifically tailored for the Home Loans Department using tools like SSIS, SSAS
- Designed and implemented a Power BI report to effectively analyze the Sales Model for business consumption, providing valuable insights and enhancing decision-making processes
- Created and scheduled SSRS reports to cater to the requirements of the Products Team, with a focus on serving the needs of privileged customers. These reports aided in monitoring and understanding the performance of various products and services provided by the bank
- First National Bank
Sr. Specialist
Willis Towers Watson
03.2017 - 07.2021
- Supported in Designing Data Mart with ETL processes and semantic layers for reporting.
- Created cubes, visual reports, and dashboards using Power BI, SSRS, and Excel. Automated report distribution using Power BI email subscriptions.
- Developed complex SQL queries, and maintained SQL objects for data transformation. Collaborated on various reports, dashboards, and risk assessments for management & Conducted SLA analysis for specific business requirements.
Project Engineer
Wipro Technologies
11.2010 - 03.2017
- Managed software installations and provided installation reports using Oracle SQL Developer.
- Handled Licenses for Software as Part of Software Management
- Health Check and Daily Operations were performed
- Citibank
Education
Bachelors of Science - Information Technology
Mumbai University
01.2009
Skills
- SQL
- Power BI (Desktop & Service)
- Snowflake, Databricks
- Data Modelling
- SSIS (ETL)
Certification
DA 100 - Power BI
Timeline
Advanced Business Intelligence Developer
Novo Nordisk
05.2024 - Current
BI Specialist
Infosys (Contract)
10.2023 - 05.2025
Sr. Specialist
LTI Mindtree
02.2023 - 05.2023
Sr. Lead Business Intelligence Analyst
Dot solved System (Contract)
07.2022 - 01.2023
Sr. Lead Business Intelligence Analyst
First Rand Services
08.2021 - 07.2022
Sr. Specialist
Willis Towers Watson
03.2017 - 07.2021
Project Engineer
Wipro Technologies
11.2010 - 03.2017
Bachelors of Science - Information Technology
Mumbai University
Similar Profiles
Tanuja YadavTanuja Yadav
Senior SDTM Programmer at NOVO NORDISKSenior SDTM Programmer at NOVO NORDISK
Mohamad Nakli AldaoudiMohamad Nakli Aldaoudi
STUDENT ASSISTANT at Novo NordiskSTUDENT ASSISTANT at Novo Nordisk
Deeksha ShettyDeeksha Shetty
Department Coordinator -Project Office at Novo Nordisk Service Centre India Private LimitedDepartment Coordinator -Project Office at Novo Nordisk Service Centre India Private Limited
Lydie BarbereauLydie Barbereau
Operatrice-Coordinatrice at Novo Nordisk ProductionOperatrice-Coordinatrice at Novo Nordisk Production
Jagadish DharmalingamJagadish Dharmalingam
Supply Chain Coordinator at TVS Motor Company LtdSupply Chain Coordinator at TVS Motor Company Ltd