Technical Skills
- Python
- Pandas
- NumPy
- Scikit-learn
- SQL
- PySpark
- VBA / Macros
- Azure
- AWS
- Snowflake
- ETL pipeline development
- Data integration
- Power BI
- Tableau
- Jupyter Notebook
- Git
- APIs
- RESTful services
Resume
Rishab Khatokar
Data Analyst
Summary
Professional summary
Data Analyst with 5 years of experience in healthcare, financial, and business analytics, specializing in data engineering, predictive modeling, and business intelligence. Adept at designing and optimizing ETL pipelines in Azure and AWS, building machine learning models for risk scoring and customer churn prediction, and creating interactive dashboards using Tableau and Power BI.
Career
Work experience
- Aug 2025 - Present
Data Analyst
- Lead advanced analytics on large-scale U.S. healthcare datasets, including claims, clinical, and provider data, applying predictive modeling and machine learning to identify trends, improve patient outcomes, and ensure HIPAA-compliant data handling.
- Design and maintain interactive dashboards and reports using Tableau, turning complex clinical and financial metrics into actionable insights for non-technical stakeholders.
- Develop and optimize Python-based data pipelines and SQL/PySpark queries in Azure to support high-quality, scalable ETL workflows for sensitive healthcare reporting.
- Partner with data scientists, actuarial teams, and business units to support ML-driven risk prediction and evidence-based Medicare and Medicaid strategy.
- Support payment integrity and quality initiatives through data validation, root-cause analysis, anomaly detection, and reporting automation.
- Aug 2022 - Jul 2024
Data Analyst
- Developed and maintained financial models to forecast loan performance and evaluate investment opportunities while reducing non-performing assets and operational risk.
- Monitored KPIs and portfolio performance, delivering real-time insight to senior management across vehicle finance, SME loans, and investment products.
- Built ETL pipelines using Python and SQL to integrate data from multiple financial platforms with strong emphasis on data accuracy, integrity, and regulatory compliance.
- Created Power BI dashboards translating market trends, credit scores, and portfolio data into practical lending and investment decisions.
- Automated data collection and reporting workflows using Python, SQL, and Excel VBA to reduce manual effort and improve reporting speed.
- Sep 2020 - Jul 2022
Data Analyst
- Collected and analyzed information from multiple sources to identify trends, improve operations, and provide actionable recommendations for clients.
- Turned large volumes of business data into clear insights and performance metrics for managers, supporting stronger project delivery decisions.
- Managed structured datasets with Excel and SQL to keep analysis, reporting, and planning accurate and reliable across multiple engagements.
- Analyzed business processes and conducted market research to uncover inefficiencies and opportunities for process improvement.
- Built Power BI dashboards that converted complex information into decision-ready visual reporting for stakeholders.
Skills
Technical and domain skills
Resume-backed capabilities, organized for fast scanning and future updates.
Machine Learning & Analytics
- Predictive modeling
- Random Forest
- Logistic Regression
- XGBoost
- Feature engineering
- Model evaluation
- Anomaly detection
- Regression analysis
- Time series forecasting
- Clustering
- NLP basics
- A/B testing
Data Management & Reporting
- Data cleaning
- Validation
- Transformation
- Workflow automation
- KPI tracking
- Financial modeling
- Reporting efficiency
- Performance monitoring
- Dashboards
- Pivot tables
- Data reconciliation
- Data governance
- Metadata management
Healthcare Domain Expertise
- Claims datasets
- Clinical datasets
- Provider datasets
- Medicare / Medicaid
- HIPAA compliance
- HEDIS
- Payment integrity
- Population health analytics
- Risk adjustment
- Patient outcomes analysis
- Care management metrics
Business & Strategic Skills
- Process improvement
- Operational efficiency
- Cross-functional collaboration
- Stakeholder management
- Actionable insights
- Decision support
- Project management
- Requirement gathering
- Business process analysis
- Strategic planning
Projects
Resume projects
Predictive Modeling
Customer Churn Prediction
Machine learning workflow for predicting churn from transactional and behavioral data so teams can act on retention risk sooner.
- Python
- Scikit-learn
- Tableau
- Built and evaluated classification models to predict churn across multiple customer segments.
- Engineered features and cleaned historical data to improve prediction quality and decision usefulness.
- Used Tableau dashboards to visualize churn probabilities, customer segments, and key risk factors.
Financial Analytics
Financial Risk Scoring System
Risk scoring workflow for loan and investment portfolios, built to improve credit decisions and highlight high-risk accounts.
- SQL
- Power BI
- Enhanced risk scoring logic using historical financial and transactional data.
- Engineered SQL queries and data models to segment customers and surface portfolio exposure.
- Planned interactive Power BI views for real-time risk monitoring and stakeholder review.
Healthcare Data Pipeline
End-to-end healthcare pipeline for ingesting, transforming, and reporting on clinical, claims, and provider datasets with HIPAA-aware handling.
- AWS
- Snowflake
- Python
- Designed ETL workflows that transformed raw healthcare data into structured analytics-ready outputs.
- Integrated AWS and Snowflake for scalable reporting and near real-time analysis.
- Delivered Power BI dashboards for healthcare KPIs, claim trends, and patient outcomes.
Education
Academic Background
Degrees and focus areas pulled directly from the current resume PDF.
-
Master of Science (MS)
Information Science / Machine Learning
-
Bachelor of Technology (B.Tech)
Electronics and Communication
Certifications
Current status
No certifications were listed in the current resume PDF, so this section has been intentionally left empty.