Hi, I’m
Rushikesh Kharat
Data Analyst
Aurangabad, Maharashtra
Summary
Experienced Data Analyst with a strong track record in leveraging data-driven strategies to drive business improvement and process optimization. I am looking to apply my data analysis skills in a dynamic environment that fosters professional development and the use of data for impactful business solutions.
Overview
3
years of professional experience
3
Certification
Work History
Codify Software Services
Data Analyst
07.2021 - Current
Job overview
- Thorough EDA: Analyzed datasets of 100,000 to 1,000,000 records, identifying trends, outliers, and correlations using Python, Pandas, Numpy, SQL, and Power Query.
- Optimized Power BI Reports: Developed and optimized 30+ interactive dashboards and reports with Power BI Desktop and Service, aligning them with business requirements to communicate complex findings effectively.
- Accurate Data Modeling: Maintained precise data models using Power BI Desktop, ensuring bi-monthly updates.
- Collaborative KPI Definition: Defined KPIs and metrics for 20+ measures across 2 projects, monitoring weekly performance and visualizing data through interactive reports in Power BI Service.
- Utilized Advanced Statistical Methods: Applied advanced statistical techniques for root cause analysis, achieving a 15% efficiency gain with insights from Power BI Desktop.
- Power BI Administration: Managed row-level security (RLS) for data privacy, ensuring system uptime and performance optimization within the Power BI Pro License environment.
- Data-Driven Market Research: Conducted quarterly market research and optimized data infrastructure with IT teams using insights from Power BI reports.
- User Support: Proactively resolved Power BI issues, managing Power BI Portal for 100+ users to ensure data refreshes and access to insights.
- Mentoring and Training: Provided advanced Power BI Desktop and Service training to over 10 employees, serving as an SME on data analytics tools.
- Quality Assurance Measures: Implemented rigorous QA measures to maintain data integrity across Power BI reports and dashboards.
Education
Maharashtra Institute of TechnologyAurangabad, Maharashtra, India
Bachelor of Technology from Mechanical Engineering
07.2018
Skills
- Python, NumPy, Pandas, PySpark
- SQL, MS SQL, MySQL, PostgreSQL
- Advanced Excel, Macros
- DAX Queries, SSAS, SSIS
- Matplotlib, Seaborn, plotly
- Web Scraping
- BI Technologies - Power BI, Tableau
- AWS - Basic
- Core Expertise - Data Analytics, Data Visualizations, Data Modeling, Power Query, Power Pivot, Data Cleaning, Jira
- Machine Learning - linear regression, decision trees, random forests, and k-means clustering
Certification
- SQL Advanced- Hackerrank
- SQL Intermediate - Hackerrank
- Data Engineering Essentials using SQL, Python, and PySpark (Currently persuing from udemy)
Timeline
Data Analyst
Codify Software Services
07.2021 - Current
Maharashtra Institute of Technology
Bachelor of Technology from Mechanical Engineering
Similar Profiles
NIDHI JAISWALNIDHI JAISWAL
Senior Test Engineer at Codify Software ServicesSenior Test Engineer at Codify Software Services
Sohail SheikhSohail Sheikh
Business Development Manager at Codify Software ServicesBusiness Development Manager at Codify Software Services
Pooja BotulePooja Botule
Associate Cloud Support Engineer at Codify Software ServicesAssociate Cloud Support Engineer at Codify Software Services