Pavan Penmetsa
Helsinki
Summary
Strategic and hands-on Senior BI Consultant & Lead Architect with 17+ years of experience designing, developing, and leading business intelligence initiatives across finance, supply chain, and HR domains. Expert in Power BI (9+ yrs), OBIEE, Microsoft Fabric, Dynamics 365 F&O, and Azure Data Services. Skilled in data modeling, performance optimization, and delivering real-time analytics for executive decision-making. Translating business needs into scalable BI architecture and driving digital transformation through cloud-based analytics.
Overview
18
18
years of professional experience
Work History
Senior BI Consultant (Lead Architect)
Digia Plc
Helsinki
07.2016 - Current
- Architected and deployed enterprise-grade BI solutions using Power BI, Azure Data Factory, and Microsoft Fabric.
- Created centralized semantic models and handling large size models.
- Integrated Power BI with D365 F&O for real-time financial, supply chain.
- Developed paginated reports and drill-through dashboards with KPI visualizations for leadership teams.
- Performance enhancement technics applied to optimize models.
- Led migration of OBIEE/Excel-based reports to scalable Power BI platforms.
- Delivered K4-based planning and forecasting solutions for multiple projects.
- Conducted client workshops and user enablement programs
- Key Clients: Pfizer, Valio, ST1, Walki, Metsä, Koskisen, Wärtsilä, Ramirent, SOK, Abloy, Oulu University, Palmia, Vero, eSett
System Specialist – Finance Analytics
Microsoft
Espoo
04.2014 - 06.2016
- Developed Power BI & Data Zen dashboards for internal finance and operations teams.
- Built SSAS Tabular & MD cubes for product revenue and budget analytics.
- Managed reporting via SharePoint, supporting controller-led monthly reviews.
OBIEE System Specialist – Finance BI
Nokia
Espoo
04.2011 - 03.2014
- Implemented OBIEE dashboards and RPD models integrating Oracle, SAP, and Essbase data.
- Built data-level security and aggregates to improve reporting responsiveness.
- Supported compliance and user onboarding across global finance teams.
Programmer Analyst – BI (OBIEE)
Cognizant
Bangalore
01.2010 - 03.2011
- Company Overview: Client: Wal-Mart Infra
- Provided OBIEE environment support, migrations, and optimization.
- Developed system usage and health dashboards.
- Client: Wal-Mart Infra
Software Engineer – BI Developer
Activecubes
Bangalore
06.2008 - 01.2010
- Delivered BI dashboards for retail & supply chain clients using OBIEE and SQL Server.
Intern – BI & Analytics
Satyam Computers Ltd
Hyderabad
07.2007 - 12.2007
Education
B.E. (Hons.) - Computer Science
Birla Institute of Technology and Science (BITS)
Pilani, IndiaTechnical Toolbox
Power BI | OBIEE | SSAS | DAX | MDX | SQL | Azure Data Factory | Microsoft Fabric | K4 Analytics | Dynamics 365 F&O | AWS | SharePoint | Paginated Reports
Core Competencies
Power BI (Desktop, Service, Embedded), OBIEE, SSAS, SSRS, K4 Analytics, Microsoft Fabric, Azure Data Factory, Logic Apps, AWS, DAX, MDX, SQL, Star & Snowflake Schema, Tabular Modeling, Financial Reporting, Forecasting & Budgeting, Supply Chain Analytics, HR & Payroll Dashboards, KPI Scorecards, Power BI RLS, Performance Tuning, Gateway Config, Dynamics 365 F&O, CRM, SharePoint, Oracle Essbase, SQL Server
Timeline
Senior BI Consultant (Lead Architect)
Digia Plc
07.2016 - Current
System Specialist – Finance Analytics
Microsoft
04.2014 - 06.2016
OBIEE System Specialist – Finance BI
Nokia
04.2011 - 03.2014
Programmer Analyst – BI (OBIEE)
Cognizant
01.2010 - 03.2011
Software Engineer – BI Developer
Activecubes
06.2008 - 01.2010
Intern – BI & Analytics
Satyam Computers Ltd
07.2007 - 12.2007
B.E. (Hons.) - Computer Science
Birla Institute of Technology and Science (BITS)
Similar Profiles
Pakorn NetayarakPakorn Netayarak
Head of Operating Department at Sabuy Technology PLC., Sabuy Solution PLC.Head of Operating Department at Sabuy Technology PLC., Sabuy Solution PLC.
Chinukwe ChandaChinukwe Chanda
Manager: Forensic Investigations at Absa Bank Zambia Plc (formerly Barclays Bank Zambia Plc)Manager: Forensic Investigations at Absa Bank Zambia Plc (formerly Barclays Bank Zambia Plc)
KEHINDE FRANCIS AINAKEHINDE FRANCIS AINA
Credit Control/ Sales Liaison Executive at Red Star Express Plc, FedEx Red Star Express PlcCredit Control/ Sales Liaison Executive at Red Star Express Plc, FedEx Red Star Express Plc
EMMANUEL ARINZECHIEMMANUEL ARINZECHI
Logistics and Transportation at Self Employed ServicesLogistics and Transportation at Self Employed Services
Stephen SmithStephen Smith
Customer Success Manager at LumoaCustomer Success Manager at Lumoa