Ranjitha H
Data Analyst
Bengaluru
Summary
A result oriented Data analyst with a year of experince in analyzing sales data,identifying trends and delivering actionable insights leads to revenue growth.
Overview
7
7
years of professional experience
2
2
Certifications
Work History
Data Analyst
ANALYTICS WITH ANAND
11.2023 - 10.2024
- Produced monthly reports using advanced Excel spreadsheet functions.
- Improved decision-making processes with accurate data analysis and visualization techniques.
Education Counselor
Interior Design Institute
03.2019 - 04.2020
- Met with students in-person and spoke over telephone to help students construct class schedules.
- worked in CRM and maintained a database of customer information for Analysing the trends in data.
- lead generation,converted leads into sales and reached the monthly sales targets.
Quality Engineer
3G Consultants
11.2017 - 12.2018
- Performed quality inspections and drafted reports to detail non-conforming material issues.
- Enhanced product quality by implementing inspection procedures and conducting thorough root cause analysis.
Education
Bachelor's Degree - Civil Engineering
Jawaharlal Nehru National College of Engineering
Shimoga, India 04.2001 -
Skills
MS Excel
SQL
Python
Power Bi
Cloud knowledge
Statistics
Sales
Certification
Master Data analytics using cloud and AI- Analytics with anand
project
Analyzing Road Safety in UK Sql, Python
- Analyzed road safety in the UK to evaluate accident severity trends by various motorcycle and based on different vehicle type.
- used python libraries for data cleaning and finding statistical insights in accident severity.
- calculated median severity of accidents by joining different tables,used aggregate functions, window functions and found sports bikes were more involved in severe accidents.
- extracted meaning full insights and suggested potential focus areas for road safety improvements based on accident severity patterns.
Czechoslovakia Banking Data Analysis SQL, Excel, Power BI, Snowpipe, AWS S3
- Analyzed a 1M-record dataset over 5 years to identify trends, optimize banking performance, and evaluate loans, transactions, and account usage.
- Conducted demographic analysis to proile high-value customer segments and assess probtability across districts.
- Proposed strategies to reduce costs, optimize the loan portfolio, and introduced new financial products for revenue growth.
Timeline
Data Analyst
ANALYTICS WITH ANAND
11.2023 - 10.2024
Education Counselor
Interior Design Institute
03.2019 - 04.2020
Quality Engineer
3G Consultants
11.2017 - 12.2018
Bachelor's Degree - Civil Engineering
Jawaharlal Nehru National College of Engineering
04.2001 -