M Vishal Kumar Rao

BIO ref BRL Resource EXTN.| COGNIZANT

• Created and implemented reports and dashboards that drastically improved operational efficiency.
• Conducted in-depth data analysis to validate the feasibility of new dashboard features, which increased user engagement.
• Collaborated with cross-functional teams to identify data sources and streamline data collection, resulting in a reduction in report development time.
• Streamlined data integration process by transforming and importing information with PowerQuery, eliminating duplicate records.
• Increased user engagement through the implementation of interactive visualizations to improve dashboard usability.
• Developed reports using SQL queries to track progress against key performance indicators.
• Developed user stories and use cases for BI solutions, improving data-driven decision-making across the organization.
• Played a key role in the migration of analytics platforms to a more robust system, increasing the data processing speed.
• Developed and implemented software solutions to improve the efficiency of existing systems.
• Maintained existing software systems by identifying and correcting software defects.
• Drafted functional specifications documents outlining project scope, objectives and deliverables.
• Identified and analyzed user requirements, procedures and processes to develop optimization strategies.
• Streamlined data collection and analysis procedures, resulting in enhanced data accuracy and faster time-to-insight .
• Analyzed and interpreted complex data sets to assist with strategic decision-making, influencing key business initiatives.
• Crafted and documented comprehensive data metrics and business rules, significantly enhancing report accuracy and reliability.
• Tech Stacks: PowerBI, PowerQuery, SQL, Data Modeling, Data Visualization

PARTNER DATA WAREHOUSE CLOUD R.| COGNIZANT

• Developed and utilized advanced DAX queries for improved performance.
• Crafted and documented comprehensive data metrics and business rules, significantly enhancing report accuracy and reliability.
• Developed efficient data models and transformed report solutions to Power BI for enhanced reporting capability.
• Managed the creation and optimization of data models using Power Pivot.
• Played a key role in the migration of analytics platforms to a more robust system, increasing data processing speed .
• Increased data-driven decision making by developing self-service dashboard for sales team.
• Achieved a 30% decrease in load time by successfully implementing indexing and partitioning, enhancing overall dashboard performance.
• Documented all changes made to software applications during development process.
• Reviewed project documentation and made important changes to match updates to project scope.
• Collaborated with business analysts to understand project requirements, customer expectations and timelines.
• Tech Stacks: PowerBI, Power Pivot, Data Modeling, DAX, SSRS, SQL