Data Analyst

NIKITA NIKHARE

SUMMARY

Delivered data-driven solutions as a Data Analyst Intern with hands-on experience in Python, SQL, Tableau, and Power BI. Developed dashboards that reduced manual reporting time by 40% and built predictive models improving churn prediction accuracy to 83%. Skilled in data cleaning, KPI reporting, and visualization.

+91-928******* *************.**@*****.*** linkedin.com/in/nikita-nikhare-075537172/ EDUCATION

Bachelor of Technology (B.Tech) in Computer Science and Engineering WORK EXPERIENCE Mar 2025 – Jun 2025

Contributed to a live business intelligence project for a SaaS client, tracking real-time metrics. Cleaned and preprocessed large datasets using Python (Pandas) and Excel Power Query. Developed dynamic Power BI dashboards to visualize KPIs and operational metrics. Wrote SQL queries for customer segmentation and business performance reporting. Designed an interactive Tableau dashboard that reduced manual reporting time by 40%. Delivered weekly data insights to stakeholders, influencing customer retention strategies. Nitya ClouTech – Data Analyst Intern (Remote)

Jan 2021 – Jan 2024

J D College of Engineering, Nagpur

PROJECT

Telecom Customer Churn Prediction Python, SQL, Power BI Constructed a logistic regression model using Python and Pandas, achieving an 83% accuracy rate in predicting telecom customer churn.

Developed interactive Power BI dashboards to visualize churn trends across regions, contract types, and payment methods, facilitating strategic decision-making. Executed comprehensive data cleaning and exploratory data analysis (EDA) using SQL and Python libraries to enhance model accuracy and data integrity. Delivered actionable insights and recommendations that supported a potential 20% reduction in churn, improving customer retention initiatives.

Supermarket Sales Dashboard SQL, Excel, Tableau

Cleaned and analyzed 12 months of sales data utilizing SQL joins and Power Query to ensure data accuracy and consistency.

Developed and deployed an interactive Tableau dashboard highlighting seasonal sales trends and pinpointing top-performing regions for strategic insights. Conducted exploratory data analysis (EDA) to uncover patterns, supporting data-driven decision making across sales and inventory domains.

Improved inventory management efficiency by 15% through data-driven recommendations and KPI reporting, optimizing stock levels and reducing waste. Hospital Readmission Risk Prediction Python, Seaborn, Excel Developed predictive models using Random Forest and Decision Tree algorithms to accurately identify patients at high risk of hospital readmission.

Designed and implemented interactive Excel dashboards and heatmaps to visualize patient risk profiles for clinical decision support.

Conducted detailed exploratory data analysis and data cleaning to enhance model accuracy and reliability. Recommended and supported process improvements in the discharge workflow, achieving a 12% reduction in hospital readmission rates.

SKILLS

Languages: Python (Pandas, NumPy,

Matplotlib, Seaborn), SQL

Soft Skills: Communication, Problem Solving,

Collaboration, Time Management

Data Visualization: Tableau,

Power BI, Excel Dashboards

Credit Card Fraud Detection Python, Scikit-learn, Matplotlib Processed and analyzed over 284,000 credit card transactions using Isolation Forest and Random Forest algorithms to detect fraudulent activities.

Implemented SMOTE technique to address class imbalance, enhancing fraud detection recall by 22%, thereby increasing model accuracy and reliability. Developed comprehensive visualizations using Matplotlib to effectively communicate fraud patterns and insights to business stakeholders.

Collaborated with cross-functional teams to integrate analytical findings into decision-making processes, improving overall fraud prevention strategies.

Analytics & Reporting: EDA, Data Cleaning,

Data Modeling, KPI Reporting

ACHIEVEMENTS

Cisco Networking Academy – Data Analytics Essentials Certificate Microsoft & LinkedIn Learning – Career Essentials in Data Analytics NPTEL – The Joy of Computing using Python

Contact this candidate