Back to Developers
Lavika Rana

Lavika Rana

Data Analyst

Dehradun $3/hr Hybrid Full-time 3+ yrs exp 97 · Outstanding

About

With a strong foundation in data analytics, hands-on experience with Excel, SQL, Python, Power BI, and Tableau, and over three years of professional experience in a role that demanded accuracy, organization, and analytical thinking, I am eager to contribute to your team. Recently, I completed a Data Analytics with Generative AI program, where I developed practical experience working with real-world datasets through end-to-end analytical projects. My work involved data cleaning, validation, transformation, exploratory data analysis, SQL querying, KPI reporting, and interactive dashboard development. These projects strengthened my ability to identify inconsistencies, ensure data accuracy, and transform raw data into meaningful business insights. One of my key projects focused on Financial Performance Analysis, where I used Excel, SQL, Python, and Power BI to analyze financial data, validate datasets, investigate budget variances, and create executive dashboards that supported informed decision-making. In another project, I analyzed retail sales data by extracting, cleaning, and transforming large datasets to uncover trends and deliver actionable business insights. These experiences have prepared me to work with large volumes of data while maintaining a strong focus on quality and accuracy. Before transitioning into data analytics, I worked as an English Instructor, where I managed student performance records, analyzed assessment data, maintained detailed documentation, and collaborated with colleagues to improve learning outcomes. This experience strengthened my communication skills, attention to detail, and ability to solve problems systematically—qualities that are equally valuable in data-focused roles. What attracts me most to work as a data analyst is the opportunity to contribute to improving data quality and supporting business decisions through reliable and well-managed data. I enjoy investigating data issues, optimizing processes, and working collaboratively with cross-functional teams to deliver accurate and meaningful results. I am confident that my technical skills, eagerness to learn, and commitment to excellence would enable me to make a positive contribution to your organization. Thank you for considering my application. I would welcome the opportunity to discuss how my background, technical skills, and enthusiasm for data analytics align with the goals of your team.

Skills & Expertise (38)

MS Excel Advanced
8.5/10
3
Years Exp
Time management Advanced
8.0/10
3
Years Exp
Multitasking Advanced
8.0/10
3
Years Exp
Teamwork Advanced
8.0/10
3
Years Exp
Attention to Detail Advanced
8.0/10
3
Years Exp
Problem Solving Advanced
8.0/10
3
Years Exp
analytical skills Advanced
8.0/10
3
Years Exp
Communication Advanced
8.0/10
3
Years Exp
Reporting Advanced
8.0/10
3
Years Exp
Data Analysis Advanced
8.0/10
3
Years Exp
Data Cleaning Advanced
8.0/10
3
Years Exp
Pivot Tables Advanced
7.5/10
3
Years Exp
Dashboard Development Advanced
7.5/10
3
Years Exp
Data Transformation Advanced
7.5/10
3
Years Exp
Data Quality Advanced
7.5/10
3
Years Exp
Power BI Intermediate
7.5/10
3
Years Exp
Presentation skill Advanced
7.0/10
3
Years Exp
Power Query Advanced
7.0/10
3
Years Exp
SQL Intermediate
7.0/10
3
Years Exp
Trend Analysis Advanced
7.0/10
3
Years Exp
Data Integrity Advanced
7.0/10
3
Years Exp
Data Profiling Intermediate
6.5/10
3
Years Exp
Python Intermediate
6.5/10
3
Years Exp
DAX Intermediate
6.5/10
3
Years Exp
Descriptive Statistics Intermediate
6.5/10
3
Years Exp
RFM Analysis Intermediate
6.0/10
3
Years Exp
Pandas Intermediate
6.0/10
3
Years Exp
Tableau Intermediate
6.0/10
3
Years Exp
NumPy Intermediate
5.5/10
3
Years Exp
Chat GPT Intermediate
5.0/10
3
Years Exp
Lovable Beginner
2.0/10
Gemini Beginner
2.0/10
Claude Beginner
2.0/10
Gamma Beginner
2.0/10
Data Validation XLOOKUP IDA EDA

Work Experience

English instructor

Defense Panthers Coaching Institute

May 2021 - Nov 2024

Collaborated with cross-functional teams to standardize reporting processes and improve data consistency to develop aligned lesson plans and analyze the question trends for consistent student learning. Monitored performance metrics and generated reports that supported academic planning and operational decisions through targeted teaching strategies and implementing assessment tools. Improved students’ engagement by delivering lectures with hands-on examples. Maintained and validated student performance datasets ensuring data accuracy for reporting and decision-making. Analyzed student assessment data to identify learning trends and improve instructional strategies.

Education

Data Analytics with Gen AI - Career247

2025 - 2026 · India

Master of Arts in English - SGRR P.G College, Pathribagh, Dehradun

2018 - 2020 · India

Bachelor of Science (Mathematics) - SGRR P.G College, Pathribagh, Dehradun

2014 - 2017 · India

Certifications

Data Analyst

Career 247 · 2026

I received the certificate of Data Analyst with Generative AI from Career247 after 8 months of learning tools with hands-on practice and tests like MS Excel, SQL, Power BI, python and Tableau.

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 12/15
💰 Rate 5/5
🏆 Certs 5/5
Verified 5/5
Total Score 97/100

Profile Overview

Member sinceAug 2026
Work ModeHybrid
AvailabilityFull-time

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation