Niraj Kumar
Business & Data Analytics
Hyderabad
Summary
Seasoned Business Analyst professional with a proven track record in data management, analytics, and process optimization across healthcare, security manufacturing, entertainment, and transportation sectors. Proficient in various tools including Power BI, Azure, SQL, Excel, and Tableau, with a strong focus on delivering actionable insights and maximizing organizational performance.
Overview
5
5
years of professional experience
4
4
years of post-secondary education
2
2
Certifications
Work History
Senior Associate Business Analyst
Meritus Intelytics Pvt Ltd
10.2022 - Current
- Managed team of 8 analysts to migrate Pediatric healthcare client's data warehouse from legacy Server to Azure, developing 50 fact and dimension tables with SCD type 2 implementation, resulting in weekly time savings of 120 hours for report generation and 15% annual revenue increase.
- Developed 10 Data Products leveraging Power BI, Azure, and Data Bricks for Pediatric healthcare client, enabling executive stakeholders to gain comprehensive business health insights and analyze operational metrics across all domains.
- Strengthened scalability and structure of Orders database for US-based home security manufacturer. Revamped 10 fact tables containing 250+ fields, rectifying data issues, and drove 13% increase in customer base.
- Enhanced data quality and efficiency by renovating subscription analytics tables for same organization, resulting in 10% upsurge in subscription revenue from existing customers.
- Orchestrated creation of reporting DataMart, facilitating Tableau dashboard development for executive leadership. Displayed KPIs encompassing orders, subscription, revenue, and subscription lifecycle.
- Delivered tailored training sessions on Excel, Power BI, and SQL to newly onboarded campus employees, aligning their skill sets with those of colleagues in similar roles to enhance seamless integration and performance across organization.
Associate Business Analytics
Merilytics, An Accordion Company
06.2021 - 09.2022
- Created a comprehensive KPI dashboard using Power BI for a prominent US-based healthcare provider, enabling detailed tracking of fallouts across multiple dimensions utilizing fuzzy logic
- Performed root cause analysis for the same healthcare provider (Netflix subscription model) to pinpoint factors influencing revenue loss. Resulted in an 8% increase in company revenue and reduced fallouts from 24% to 7%.
- Transformed 10 manual Excel reports into automated Power BI reports, mitigating quality check issues and yielding a weekly time savings of around 150 hours for a leading US based entertainment industry client. Reports centered on vital metrics concerning employees and customers.
- Developed customized dashboard for the C-Suite executives of the same entertainment industry client, integrating data from more than 30 business units. Provided comprehensive insights into customer analytics, company performance, employee performance, funnel health, and call center analytics. These streamlined processes resulted in a weekly time savings of 20 man-hours previously spent on manual report creation.
Senior Electrical Engineer
EDRC, Railways Business L&T
07.2019 - 05.2021
- Automated SED design using Excel, leading to 70% reduction in manpower.
- Designed SED for 300 TKM and CSD for 200 TKM for DFCC, Indian Railways, and Metro Projects.
- Created monthly waste report using site data and performed thorough root cause analysis to reduce waste, leading to decrease in overall wastage for DFCC from 18% to 7%.
Education
Bachelor of Technology in Electrical Engineering -
IIT(ISM) DHANBAD
DHANBAD, JHARKHAND 07.2015 - 05.2019
Skills
Power BI
undefinedCertification
Microsoft Certified Power BI Data Analyst Associate, 01/23 - Present
Awards
- Merilytics Meridian Award winner in Associate Business Analytics role category for FY 21-22
- Above & Beyond - 2 Times recipient for exceptional performance and team handling.
- GATE 2019: Secured AIR 976 in Electrical Engineering with a score of 764/1000
- IIT JEE 2015: Secured AIR 4439 in common Merit List
- JEE MAIN 2015: Secured AIR 10432 in common Merit List
Timeline
Senior Associate Business Analyst
Meritus Intelytics Pvt Ltd
10.2022 - Current
Associate Business Analytics
Merilytics, An Accordion Company
06.2021 - 09.2022
Senior Electrical Engineer
EDRC, Railways Business L&T
07.2019 - 05.2021
Bachelor of Technology in Electrical Engineering -
IIT(ISM) DHANBAD
07.2015 - 05.2019
Similar Profiles
YETUNDE ADEDAYOYETUNDE ADEDAYO
Digital Marketing Executive at Intelytics LimitedDigital Marketing Executive at Intelytics Limited
Melody BrantleyMelody Brantley
Perioperative Inventory Specialist at Meritus Medical CenterPerioperative Inventory Specialist at Meritus Medical Center
Yawa AdjindaYawa Adjinda
Surgical Technologist at Meritus Medical CenterSurgical Technologist at Meritus Medical Center