Power BI
Ravindra Kumar
Senior Lead Operations ( 9 Years, 4 Months )
Summary
Experienced senior lead operations professional with 9+ years of experience in team handling and project management. Specializes in analytics, data visualization, and processing. Brings expertise in BI tools such as Power BI, DAX, Looker Studio, SQL, and macros. Excels in designing interactive dashboards and utilizing Power Query and Power Pivot for data cleansing and modeling. Proficient in the MS Office suite. Possesses strong interpersonal communication and presentation skills. Renowned for strategic thinking, problem-solving abilities, and critical analysis. Proven track record in team and project management. Drives organizational success through optimizing workflows and implementing process improvements. Focuses on team collaboration to deliver measurable results. Adaptable and reliable. Excels at identifying and implementing solutions to meet changing needs.
Overview
9
9
years of professional experience
6
6
years of post-secondary education
Work History
Senior Operations Lead
VASTA BIO-INFORMATICS (OMEGA HEALTHCARE COMPANY)
08.2021 - Current
- Utilized tools such as Power Query, DAX, Power BI, and Power Automate throughout project lifecycle, managing end-to-end processes and ensuring seamless integration of data analytics solutions.
- Created interactive and insightful reports utilizing Power BI, Looker Studio focusing on visualizing clinical research data to facilitate decision-making processes.
- Developed and iteratively enhanced dashboards linked to multiple users' data on SharePoint Online, enabling real-time tracking of performance metrics and operational status reporting to clients.
- Conducted data cleaning and processing of real-time data sourced from SharePoint using Power Query Editor and Power BI, ensuring data integrity and accuracy.
- Designed and implemented Power Automate flow to automate delivery of productivity emails to 200 users, personalized with their own data, enhancing communication and efficiency within organization.
- Oversaw team of 40 Medical Analysts, monitoring their productivity and pacing, and providing essential support to Project Manager and Operations team.
- Collaborated closely with stakeholders to understand project requirements, translate business needs into actionable insights, and deliver high-quality analytical solutions that drive business value.
- Coordinated with multiple departments to optimize workflows, streamline communication channels, and improve overall efficiency within the organization.
- Managed cross-functional teams for timely project completion and delivery of high-quality results.
Lead Operations and Data Delivery
XDBS PVT LTD
01.2018 - 07.2021
- Designed and created interactive
and intuitive dashboards using tools such as Excel, Macros, Power BI and SQL - Played instrumental role in Pre-Sales Process to keep track of lead generation with help of constructing tools on Excel Macros and Power BI which increased that lead generation by 15%
- Constructed tracker tools using Macros
- Directly supervised assigned Analysts/Executives and is responsible to address day to day questions/concerns, ensure daily and weekly production targets are met and completion of CAP items when required
- Performs basic data queries as needed to aid productivity monitoring and validation
- For project(s) assigned, responsible for project dashboard maintenance, case and flag allocation for all project team members and daily completion of project production trackers, alerting Project Manager, Operations for any production deficit(s) and reason (e.g., slow performers, unplanned leaves).
Subject Matter Expert
XDBS PVT LTD
11.2015 - 12.2017
- Developed and implemented tracker tools utilizing Macros, enhancing data management processes and facilitating efficient tracking of key performance metrics.
- Provided direct supervision and guidance to assigned Analysts/Executives, overseeing their day-to-day activities, addressing inquiries and concerns promptly, and ensuring adherence to established production targets.
- Played pivotal role in maintaining operational efficiency by monitoring and ensuring completion of daily and weekly production targets, as well as addressing Corrective Action Plan (CAP) items as required to reach 90% above productivity
- Conducted basic data queries as necessary to support productivity monitoring and validation efforts, ensuring data accuracy and integrity.
- Collaborated closely with cross-functional teams to identify opportunities for process improvement, implement best practices, and drive continuous enhancement of operational workflows.
- Acted as subject matter expert, providing expertise and guidance on data management processes, tools, and best practices to support organizational objectives.
Education
Bachelor of Engineering - Mechanical Engineering
Army Institute of Technology
Pune, India 05.2011 - 04.2015
Senior Secondary - Science
Narayan IIT Academy
Vijayawada 05.2008 - 03.2010
Skills
Data Processing: Data cleansing, modelling, and aggregation using tools such as Excel, (Power Query & Power Pivot), Power BI (using DAX), Looker Studio
Accomplishments
Awarded with Best Innovative idea in Omega Global Awards 2022 - 2023
Software
Power Query
DAX
Power Automate
SQL
Macros
Advanced Excel
Looker Studio
Timeline
Senior Operations Lead
VASTA BIO-INFORMATICS (OMEGA HEALTHCARE COMPANY)
08.2021 - Current
Lead Operations and Data Delivery
XDBS PVT LTD
01.2018 - 07.2021
Subject Matter Expert
XDBS PVT LTD
11.2015 - 12.2017
Bachelor of Engineering - Mechanical Engineering
Army Institute of Technology
05.2011 - 04.2015
Senior Secondary - Science
Narayan IIT Academy
05.2008 - 03.2010
Analytics Skills
Strategic thinking, problem-solving skills, a deep understanding of the context, and critical thinking abilities, Designing and creating interactive and intuitive dashboards using tools such as Excel, Macros, Power BI and SQL, Data cleansing, modelling, and aggregation using tools such as Excel, (Power Query & Power Pivot), Power BI (using DAX)
Projects
Project Name: Personalized Productivity Reminder
Tools used : Power Automate, Power BI, Power Query, DAX
Summary: The Personalized Productivity Reminder project employs Power Automate to orchestrate tailored email notifications to individual users, delivering their personalized productivity data from Power BI. This automated flow ensures that users receive reminders twice weekly, containing pertinent insights on their productivity metrics alongside a comprehensive list of pending tasks. By leveraging Power Automate capabilities, this project enhances user engagement, fosters accountability, and promotes proactive task management within the organization.
Project Name: Oncology Insights Dashboard
Tools used : Power BI, Power Query, DAX, Share point
Summary: The Oncology Insights Dashboard is a Power BI project focused on analyzing clinical research data from cancer patients. Utilizing data sourced from Online SharePoint, the dashboard provides real-time insights into key metrics such as Average Handling Time (AHT), error percentage, and client deadline estimations. With a user base of 150 individuals, the dashboard enables comprehensive analytics and reporting to facilitate informed decision-making in cancer patient care and clinical trial management within the healthcare sector.
Project Name: Task Efficiency Insights
Tools used : Power BI, Power Query, DAX, Share point
Summary: Task Efficiency Insights is a Power BI project designed to track and analyze associates' daily tasks. By integrating data on productivity, quality errors, and task duration, the dashboard offers comprehensive insights into performance metrics. It enables analysis of productivity levels, identification of quality error trends, and assessment of time allocation for tasks. This project supports continuous improvement initiatives by providing actionable insights to optimize task efficiency and enhance overall performance.
Project Name: Lead Generation Insights
Tools used : Power BI, Power Query, DAX, SQL
Summary: The Lead Generation Insights project leverages market research and lead generation efforts to compile sales leads, complete with their respective LinkedIn profiles and specified criteria. Through Power BI, this dashboard provides a comprehensive view of target leads and their outcomes, facilitating efficient tracking and analysis of lead generation efforts. With detailed insights into lead characteristics and outcomes, this project supports informed decision-making and strategy development to optimize sales and marketing initiatives.
Projects
Project Name: Personalized Productivity Reminder
Tools used : Power Automate, Power BI, Power Query, DAX
Summary: The Personalized Productivity Reminder project employs Power Automate to orchestrate tailored email notifications to individual users, delivering their personalized productivity data from Power BI. This automated flow ensures that users receive reminders twice weekly, containing pertinent insights on their productivity metrics alongside a comprehensive list of pending tasks. By leveraging Power Automate capabilities, this project enhances user engagement, fosters accountability, and promotes proactive task management within the organization.
Project Name: KPIs Tracking Dashboard
Tools used : Looker Studio, Google sheets
Summary: Tracking the KPIs on team by making dashboard on looker studio with datasource from Google sheets. Collating multiple Google sheets with help of App script and connect it to Looker studio,
Project Name: Oncology Insights Dashboard
Tools used : Power BI, Power Query, DAX, Share point
Summary: The Oncology Insights Dashboard is a Power BI project focused on analyzing clinical research data from cancer patients. Utilizing data sourced from Online SharePoint, the dashboard provides real-time insights into key metrics such as Average Handling Time (AHT), error percentage, and client deadline estimations. With a user base of 150 individuals, the dashboard enables comprehensive analytics and reporting to facilitate informed decision-making in cancer patient care and clinical trial management within the healthcare sector.
Project Name: Task Efficiency Insights
Tools used : Power BI, Power Query, DAX, Share point
Summary: Task Efficiency Insights is a Power BI project designed to track and analyze associates' daily tasks. By integrating data on productivity, quality errors, and task duration, the dashboard offers comprehensive insights into performance metrics. It enables analysis of productivity levels, identification of quality error trends, and assessment of time allocation for tasks. This project supports continuous improvement initiatives by providing actionable insights to optimize task efficiency and enhance overall performance.
Project Name: Lead Generation Insights
Tools used : Power BI, Power Query, DAX, SQL
Summary: The Lead Generation Insights project leverages market research and lead generation efforts to compile sales leads, complete with their respective LinkedIn profiles and specified criteria. Through Power BI, this dashboard provides a comprehensive view of target leads and their outcomes, facilitating efficient tracking and analysis of lead generation efforts. With detailed insights into lead characteristics and outcomes, this project supports informed decision-making and strategy development to optimize sales and marketing initiatives.
Similar Profiles
ZAYDA SHAIKHZAYDA SHAIKH
Deputy General Manager at Vasta Bio-Informatics (An omega Healthcare Company)Deputy General Manager at Vasta Bio-Informatics (An omega Healthcare Company)
Sarang KulkarniSarang Kulkarni
Project Manager at Vasta Bio-informatics Pvt Ltd (Now Omega Healthcare)Project Manager at Vasta Bio-informatics Pvt Ltd (Now Omega Healthcare)
MUKESH DASWANIMUKESH DASWANI
Deputy General Manager at Vasta Bio-Informatics Pvt. Ltd.Deputy General Manager at Vasta Bio-Informatics Pvt. Ltd.