Devansh Rajput
Greater Noida
Summary
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.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Senior Business Analyst
Genpact
Noida, India
02.2024 - Current
- 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
Capline Services Pvt. Ltd.
Noida
11.2022 - 01.2024
- 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
Simplilearn
Greater Noida08.2024
Bsc. - Hotel Management
Galgotias University
Gautam Buddha Nagar07.2022
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 - Current
Data Analyst
Capline Services Pvt. Ltd.
11.2022 - 01.2024
Bsc. - Hotel Management
Galgotias University
MBA - Data Science and Business Analytics
Simplilearn