Experienced Business Analyst with over 2 years of proven expertise in leveraging Power BI to transform complex data into actionable insights. Skilled in data aggregation and visualization, I excel at creating comprehensive reports and dashboards that drive informed decision-making. Adept at data modeling and seamlessly integrating diverse data sources, I thrive in collaborative environments, fostering cross-functional relationships to enhance business performance. Committed to continuous improvement and delivering strategic solutions that align with organizational goals.
Hi, I’m
Harsha Lohiya
Business Analyst
New Delhi
Summary
Overview
6
years of professional experience
2
Certifications
3
Languages
Work History
Provana
Business Analyst
12.2022 - Current
Job overview
- Gathered data from Blob, SFTP, SQL, Excel, and other data sources
- Transformed the data and produced reports using the Power BI platform
- Developed over 30 reports and dashboards resulted in increase in operational efficiency
- Optimized dashboards with a focus on usability and performance by introducing Composite Model and result in dashboard reduction by more than 50%
- Collaborated with cross-functional teams to identify data sources and streamline data collection resulting in a 25% reduction in report development time
- Improved dashboard usability by implementing interactive visualizations resulting in a 20% increase in user engagement
- Streamlined project management with effective communication and collaboration across cross-functional teams.
- Performed gap analysis between existing systems or processes and desired state, identifying areas for improvement or enhancement.
- Optimized client relations by managing 20 clients, streamlining calls, generating reports, and fulfilling custom requests
Sunstone
Data Analyst Intern
09.2022 - 12.2022
Job overview
- Company Overview: Ed Tech
- Created and automated daily performance reports for 30 campuses, consolidating data from multiple sources into Excel for timely distribution to stakeholders, including the CEO and VPs, in a fast-paced startup environment
- Utilized Tableau to develop and maintain interactive dashboards for real-time data visualization, enhancing stakeholder decision-making with actionable insights
- Streamlined data preparation by automating Excel spreadsheets for daily reporting, improving accuracy and efficiency in stakeholder communications
- Collected and integrated data from various sources, ensuring comprehensive datasets for analysis and reporting
- Collaborated with engineering teams to understand and manipulate code, optimizing data integration within online dashboards
- Analyzed student reports, identify trends in campus attendance, course enrollments, and campus locations, supporting strategic planning and decisions
- Ed Tech
Happy Hours
Educator
09.2020 - 09.2022
Job overview
- Company Overview: NGO
- Taught full-time at an NGO, managing educational programs, handling social media, and event coordination, while preparing students' performances that supported holistic development, demonstrating strong teaching, operational, and communication skills
- NGO
Delhi Police Public School
Teacher
09.2019 - 02.2020
Job overview
Nava Hind Senior Secondary School
Teacher Intern
07.2018 - 10.2018
Job overview
Education
University of DelhiDelhi, DL
B.A. (Hons.) from Economics
04.2001 - 01.2016
University Overview
Guru Gobind Singh Indraprastha UniversityDelhi, DL
Bachelor of Education
01.2018 - 01.2020
University Overview
Indira Gandhi National Open UnivesityDelhi, DL
Masters in Economics
01.2017 - 01.2021
University Overview
Coding InvadersCertificate In Data Analytics
Certificate from Data Analytics
04.2001
University Overview
Skills
Power BI
Data Modeling
SQL
Excel
Power Automate
SharePoint
VBA
Effective Time Management
Certification
Data Analytics
Timeline
Business Analyst
Provana
12.2022 - Current
Data Analyst Intern
Sunstone
09.2022 - 12.2022
Educator
Happy Hours
09.2020 - 09.2022
Teacher
Delhi Police Public School
09.2019 - 02.2020
Teacher Intern
Nava Hind Senior Secondary School
07.2018 - 10.2018
Guru Gobind Singh Indraprastha University
Bachelor of Education
01.2018 - 01.2020
Indira Gandhi National Open Univesity
Masters in Economics
01.2017 - 01.2021
University of Delhi
B.A. (Hons.) from Economics
04.2001 - 01.2016
Coding Invaders
Certificate from Data Analytics
04.2001