Pavan Penmetsa
Helsinki
Summary
Results-driven Senior BI Consultant/Lead Architect with 17+ years of experience delivering data analytics solutions in finance and operations. Proficient in Power BI, OBIEE, SSAS, SQL, Snowflake, Azure technologies, and Dynamics 365 F&O, with hands-on expertise in Microsoft Fabric. Skilled in leading BI modernization projects, integrating diverse data sources, and creating interactive dashboards that enhance executive decision-making.
Overview
19
19
years of professional experience
Work History
Senior BI Consultant/ Lead BI Architect - Data & Analytics
Digia Oy
01.2016 - Current
- Enhanced reporting capabilities through Power BI, Azure, and Microsoft Fabric solutions.
- Developed centralized semantic models for self-service reporting by analysts and executives.
- Integrated diverse data sources into cohesive Power BI analytical models.
- Optimized report performance via DAX, storage strategies, and dataset size reduction.
- Configured K4 Analytics for effective budgeting and forecasting across departments.
- Executed seamless migration from Oracle BI to Power BI, improving analytics scalability.
System Specialist – Finance Analytics
Microsoft
01.2014 - 01.2016
- Developed financial dashboards using Power BI and Data Zen for internal departments
- Designed SSAS Tabular and Multidimensional Cubes for cost tracking, product revenue, and budget variance analytics.
- Supported finance controllers in conducting monthly performance reviews using KPI-led visualizations.
Oracle BI Specialist (Finance Analytics)
Nokia
01.2011 - 01.2014
- Administered OBIEE environments for financial and operational reporting.
- Designed dashboards integrating Oracle Financials, Essbase, and SAP data using custom OBIEE RPDs.
- Implemented data-level security models and performance-enhancing aggregates for complex reports.
Programmer Analyst – OBIEE Support (Walmart client)
Cognizant
01.2010 - 01.2011
- Provided infrastructure-level support for global OBIEE deployments, including patching and migration tasks.
- Created OBIEE diagnostic dashboards for monitoring system usage and performance KPIs.
Software Engineer
Activecubes
01.2008 - 01.2010
Intern
Satyam Computers Ltd
01.2007 - 01.2008
Education
Bachelor of Engineering (Hons.) - Computer Science
Birla Institute of Technology and Science (BITS)
Pilani, IndiaSkills
- BI & Analytics: Power BI, OBIEE, SSAS, Data Zen, K4 Analytics, Microsoft Fabric
- Modeling & Languages: DAX, MDX, Power Query (M), SQL, Tabular Models, Star/Snowflake Schema Design
- Cloud & Data Engineering: Microsoft Fabric, Azure Data Factory, Azure Synapse, Dataflows, Logic Apps, AWS
- ERP & Business Systems: Dynamics 365 F&O, SharePoint, Oracle Essbase, SQL Server, Teradata
- Security & Lifecycle Management: Power BI RLS, Workspace Management, Lifecycle Deployment (Dev-Test-Prod)
Accomplishments
- Architected and deployed enterprise-wide BI ecosystems using Power BI and Microsoft Fabric, enabling governed analytics across finance, operations, and executive reporting.
- Delivered centralized semantic models supporting governed self-service analytics for hundreds of users across multiple business domains
- Reduced report refresh and query response times by up to 70% through DAX optimization, storage mode strategies, and dataset performance tuning.
- Delivered board-level financial and KPI dashboards adopted by senior leadership for strategic planning, forecasting, and performance reviews.
- Recognized as a trusted BI advisor and solution architect for complex analytics transformations across global enterprise clients.
Timeline
Senior BI Consultant/ Lead BI Architect - Data & Analytics
Digia Oy
01.2016 - Current
System Specialist – Finance Analytics
Microsoft
01.2014 - 01.2016
Oracle BI Specialist (Finance Analytics)
Nokia
01.2011 - 01.2014
Programmer Analyst – OBIEE Support (Walmart client)
Cognizant
01.2010 - 01.2011
Software Engineer
Activecubes
01.2008 - 01.2010
Intern
Satyam Computers Ltd
01.2007 - 01.2008
Bachelor of Engineering (Hons.) - Computer Science
Birla Institute of Technology and Science (BITS)