Devansh Rajput
Genpact
Greater Noida
3
years of professional experience
1
Certification
Data Analyst focused on operational and financial analytics, with hands-on experience in deductions and healthcare data. Proficient in SQL, Power BI, and advanced Excel to build scalable dashboards, automate reporting, and uncover actionable insights. Proven track record of improving data visibility, optimizing workflows, and enabling data-driven decision-making across business functions.
Work History
Senior Business Analyst
2 Years 7 Months- Started with analyzing high-volume deductions and claims datasets, identifying root causes of revenue leakage and process inefficiencies across workflows.
- Transformed raw operational data into structured insights by leveraging SQL (joins, aggregations, case statements) and advanced Excel for trend analysis and performance monitoring.
- Built and scaled Power BI dashboards from scratch to track deduction aging, resolution rates, recovery performance, and SLA adherence, improving visibility for stakeholders.
- Automated recurring MIS reporting workflows using Excel and Power BI, significantly reducing manual effort and enabling faster, data-driven decision-making.
- Standardized and structured data from workflow tools and internal accelerators, converting fragmented inputs into usable datasets that supported business decisions and improved process efficiency.
- Collaborated with backend and cross-functional teams to streamline packet creation and resolution workflows, reducing backlog risk and improving turnaround time.
- Worked extensively on AR (Accounts Receivable) processes, including tools such as Cash Applications, SAP, and CDS, where I built reporting structures from scratch, automated data pipelines, and developed Power BI visualizations to track financial performance and recovery trends.
Data Analyst
1 Year 2 Months- Analyzed US healthcare datasets covering patient records, insurance verification, claims lifecycle, billing, and provider information to support operational decision-making.
- Worked extensively on insurance verification (IV) creation and updates using master databases and portals, ensuring accuracy in patient eligibility, coverage, and billing workflows.
- Utilized SQL and advanced Excel (Pivot Tables, Power Query, automation) to clean, transform, and validate data, improving reporting accuracy and data reliability.
- Performed exploratory analysis to identify inefficiencies in billing and verification processes, contributing to reduced turnaround time and smoother operations.
- Built automated reports and dashboards to track performance metrics, reducing manual effort and improving visibility for stakeholders
- Conducted ORM reviews and implemented data quality checks to minimize discrepancies in reporting.
Education
MBA - Data Science and Business Analytics
- Courses
- Basic Python
- Machine Learning
- Data Science With Python
- Tableau Training
Bsc. - Hotel Management
Skills
Power BI (Dashboard Development
KPI Tracking
Data Visualization)
SQL (Joins
Aggregations
Subqueries
Case Statements)
Advanced Excel (Pivot Tables
Power Query
XLOOKUP
Macros
Automation)
Data Analysis & Data Cleaning
Exploratory Data Analysis (EDA)
Process Automation & Workflow Optimization
Python (Pandas
NumPy – Basic Data Handling
Data-Driven Decision Making
Analytical Problem Solving
Stakeholder Communication
Cross-Functional Collaboration
Attention to Detail & Data Accuracy
Ownership & Accountability
Process Improvement Mindset
Certification
Python for Data Science
LANGUAGES
Hindi
Full Professional Proficiency
English
Full Professional Proficiency
Interests
Exploring famous landmarks
historical sites
and cultural attractions in a new destination.
Backpacking and Hiking
Adventure Travel
Gym Workouts
High-Intensity Interval Training
Hiking
Adventurous Sport
INTERNSHIPS
- Expo Mart
- Managing teams under production.
- Jaypee Green Resort
- Back Office Associate
Timeline
Senior Business Analyst
Genpact
02.2024 - CurrentRead More
Data Analyst
Capline Services Pvt. Ltd.
11.2022 - 01.2024Read More
Galgotias University
Bsc. from Hotel Management
Read More
Simplilearn
MBA from Data Science and Business Analytics
Read More