Pranay.L

Project Description:

Objective of the project is to develop the Power BI solutions for showcasing the Finance outline and Supply Chain KPI's of a Hardware manufacturing company. The dashboard is used by the Leadership for decision making.

Responsibilities:

• Involved in consultation with internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project life cycle.
• Created Semantic models for multiple report requirements using Direct Query from Big Query.
• Worked on the Advanced features in Power BI such as Drill Through and Drill down effectively.
• Implemented Filtered measures and the Custom columns using the complex DAX Calculations.
• Designed and developed test strategy for validating data for every report through SQL server before deploying it.
• Supported stakeholders during User Acceptance Testing phase before final deployment.
• Documented every step of report development process including end to end design and testing.
• Worked with few Custom visuals such as Mass filters, Cylinder Gauge etc.
• Created real-time reports using Oracle DB.
• Created data quality reports for data flowing from multiple sources.

Project Description:

Objective of the project is to develop the Power BI solutions for showcasing the Finance outline, HR metrics, Agriculture P&L and stock performance of the company. The dashboard is used by the multiple members for analyzing the Financial health, Stock performance and HR metrics of a agriculture products & sugar manufacturer.

Responsibilities:

• Cleaned the huge dataset by applying the transformations within the Power BI Query editor.
• Integrated multiple data sources into the dashboard.
• Implemented Filtered measures and the Custom columns using the complex DAX Calculations.
• Created and maintained the Share-points that need to be updated on the daily frequency, which are used by vast number of users.
• Documented every step of report development process including end to end design and testing.
• Used advanced features in Power BI Service for refreshing the data both On-Demand and Scheduled basis.

• Designed and developed solution demos, various POC’s for showcasing company's BI capabilities to prospective clients.
• Assisted multiple ongoing projects.

Project Description:

Objective of the Project is to deploy BI solution to better understand and manage the progress of Unilever Product Portfolio across the globe. The solution also caters detail dashboards on various subject areas such as overall sales trend, market growth and net revenue to analyze the performance of competitors in predefined categories.

Responsibilities:

• Developed Power BI reports that provide clear visualizations of various industry-specific KPIs.
• Accessed and transformed massive datasets through quick/context/global filtering, grouping, aggregation, and statistical calculation.
• Involved in consultation with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project life cycle.
• Strong understanding of advanced Power BI features including calculated fields, table calculations, joins and dashboard actions.
• Documented every step of report development process including end to end design and testing.
• Used time intelligence functions for comparing the sales of different products for yearly and quarterly basis.
• Used geographical map visual for showcasing the performance of a certain products in the geographical area.

• Provided exceptional customer support by troubleshooting and resolving complex technical issues in a timely manner.