Shubham Singh Rao

Client: Trends, Vishal Mega Mart, Rajasthan

• Analyzed weekly customer scorecards, comparing current and prior year sales, uncovering opportunities for growth and expansion; leveraged MySQL database to ingest and perform ETL on data, ensuring data integrity by removing outliers and cleaning up bad records, resulting in improved decision-making and actionable insights.
• Improved overall decision-making 25% by designing and developing BI reports and providing invaluable insights and clean up the bad records.
• Comprehend business requirements in a BI context and developed 15+ data models to convert raw data into actionable insights.
• Identify 10+ KPIs with outlined objectives and consistently monitor them.

Client: Union Bank of India

• Design and develop of reporting data module for Credit Card Marketing Analytics.
• Developed Up-selling and Cross-selling reports using DAX functions.
• Creating Row level security with power bi and integration with power bi service portal.
• Developed profit analysis reports and dashboards by products and customers.
• Worked on all types of transformations that are available in Power bi query editor.