Renuka Pimpalkar

Projects :

CBRE – Lilly (Pharma Domain – Facility Management)
Description: Designed facility management dashboards integrating API data into Power BI.
Key Tools/Technologies Used: Power BI, SQL Server, APIs, Power Query, DAX
My Role and Key Responsibilities:
Developed ETL pipelines in Power Query for API data integration.
Applied validation checks for data quality and compliance.
Designed dashboards with KPIs for facility operations.
Achievements:
Enhanced reporting accuracy with automated validation.
Improved facility management visibility through real-time data integration.

DP World (Logistics & Supply Chain – Port Operations)
Description: Created Power BI dashboards to monitor port operations, logistics, and supply chain KPIs.
Key Tools/Technologies Used: Power BI, SQL Server, APIs, Power Query, DAX
My Role and Key Responsibilities:
Unified multiple data sources (SQL, APIs) into optimized Power BI models.
Built dashboards for port activity, container flow, and logistics monitoring.
Automated refresh schedules for near real-time data availability.
Achievements:
Delivered centralized dashboards that improved operational efficiency and decision-making.
Reduced manual data preparation time by 40% with automated ETL.

Control Tower (Ongoing – Asset Data Management with Six PAC Metrics)
Description: Developing a centralized Control Tower dashboard for asset performance and data management using Six PAC metrics.
Key Tools/Technologies Used: Power BI, SQL Server, APIs, Excel, Power Query, DAX
My Role and Key Responsibilities:
Designing enterprise-level dashboards for monitoring asset performance and compliance.
Building advanced DAX measures and data models for Six PAC metrics.
Integrating multiple sources (SQL, APIs, Excel) into a unified reporting framework.
Achievements:
Streamlined asset reporting processes with a single source of truth.
Enabling leadership with enterprise-wide visibility into asset compliance and performance.