Power BI
Ravindra Kumar
Senior Lead Operation Analyst
Pune,Maharashtra
Summary
Experienced Senior Lead Operations professional with 8+ years in team handling and project management, specializing in analytics, data visualization, and processing. Proficient in BI tools like Power BI, DAX, SQL, and macros, with expertise in designing interactive dashboards. Skilled in ETL, data cleansing, and modeling using Power Query, Power Pivot, and Power Automate. Adept in MS Office suite and possess strong interpersonal communication and presentation skills. Known for strategic thinking, problem-solving, and critical analysis. Proven track record in team and project management, with a knack for innovation and tactfulness.
Overview
8
8
years of professional experience
4
4
years of post-secondary education
Work History
Senior Lead Operation Analyst
VASTA BIO-INFORMATICS (OMEGA HEALTHCARE COMPANY)
2021.08 - 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, 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 a Power Automate flow to automate the delivery of productivity emails to 200 users, personalized with their own data, enhancing communication and efficiency within the organization.
- Oversaw a team of 40 Medical Analysts, monitoring their productivity and pacing, and providing essential support to the 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.
Lead Operations and Data Delivery
XDBS PVT LTD
2018.01 - 2021.07
- Designed and created interactive
and intuitive dashboards using tools such as Excel, Macros, Power BI and SQL - Played an instrumental role in a Pre-Sales Process to keep track of lead generation with help of constructing tools on Excel Macros and Power BI.
- 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
2015.11 - 2017.12
- 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 a pivotal role in maintaining operational efficiency by monitoring and ensuring the completion of daily and weekly production targets, as well as addressing Corrective Action Plan (CAP) items as required.
- 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 a subject matter expert, providing expertise and guidance on data management processes, tools, and best practices to support organizational objectives.
Education
Mechanical Engineering
Army Institute of Technology
Pune, India 2011.05 - 2015.05
Senior Secondary - Science
Narayan IIT Academy
Vijayawada 2001.04 -
Skills
Data Processing: Data cleansing, modelling, and aggregation using tools such as Excel, (Power Query & Power Pivot), Power BI (using DAX)
undefinedAnalytics 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.
Accomplishments
Awarded with Best Innovative idea in Omega Global Awards 2022 - 2023
Software
Power Query
DAX
Power Automate
SQL
Macros
Advanced Excel
Timeline
Senior Lead Operation Analyst
VASTA BIO-INFORMATICS (OMEGA HEALTHCARE COMPANY)
2021.08 - Current
Lead Operations and Data Delivery
XDBS PVT LTD
2018.01 - 2021.07
Subject Matter Expert
XDBS PVT LTD
2015.11 - 2017.12
Mechanical Engineering
Army Institute of Technology
2011.05 - 2015.05
Senior Secondary - Science
Narayan IIT Academy
2001.04 -
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.