# Akhila Yallappa Olekar

Akhila Yallappa Olekar is a remote worker on Himalayas, Independent Study & Upskilling at Self Employed, based in India.

Source: https://himalayas.app/@akhilayallappaolekar

```text
Data Analyst using SQL, Excel and Power BI to analyze sales, delivery performance and 3.47 bn transactions.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 765k+ INR |
| Job categories | Data Analyst |
| Skills | Data Analysis, SQL, MySQL, Python, Pandas, NumPy, Excel, Power Query, Power Pivot, DAX, Power BI, Data Cleaning, Data Validation, Exploratory Data Analysis, Data Visualization |
| LinkedIn | https://linkedin.com/in/akhila-yallappa-olekar-810719390 |

## What I'm looking for

```text
I’m seeking a Data Analyst role where I can use SQL, Python, Excel and Power BI to turn data into clear insights that support business decisions.
```

## About

```text
My PhonePe Transaction Analysis project turned data on 3.47 bn transactions and 108k users into a Power BI dashboard. I tracked a 96% transaction success rate, failed transactions and 9% month-on-month growth, and used age-group segmentation to identify Gen X as the primary demographic driving peak transaction volumes.

For my Ferns & Petals Sales Analysis project, I cleaned, validated and merged three datasets covering 126 orders using Power Query. I built an Excel dashboard to track average delivery time and analyze the cities, products and occasions driving demand.

I also analyzed pizza sales with SQL, answering business questions about orders, revenue, product categories and sales patterns. I’m seeking a Data Analyst role where I can use my training in SQL, Python, Excel and Power BI to turn data into clear insights that support business decisions.
```

## Experience

### Independent Study & Upskilling (current)

Self Employed. Jan 2024 - Present

```text
Completed self-directed training in SQL, Python, Excel, Power Query and Power BI and built three end-to-end analytics projects. Followed a structured, self-managed schedule alongside competitive exam preparation.
```

Skills: SQL, Python, Pandas, NumPy, Matplotlib, SeaBorn, Excel, Power-Query, Power-BI

### Research Intern

Kay Bee Bio-Organics Pvt. Ltd.. May 2023 - Jul 2023

```text
Worked with the research team on project tasks, coordinating work across the project. Maintained accurate, well-organised documentation of research activities.
```

### Biotech Intern

Shankaranarayana Life Sciences. Jan 2022 - May 2022

```text
Executed an end-to-end recombinant protein workflow including gene extraction, His-tagging, PCR, sub-cloning, expression and purification. Managed a multi-stage process and kept accurate records of work and results.
```

Skills: PCR, Protein-Purification, Recombinant-DNA-Technology, Documentation

### Community Advocate (Water & Education)

Self Employed. Jan 2019 - Apr 2019

```text
Coordinated with villagers and local authorities in rural Karnataka to understand their concerns and provided structured guidance. Planned and organised awareness campaigns, communicating clearly with diverse groups.
```

Skills: Communication-Skills, Coordination, Campaign-Planning

## Education

### Indian Institute of Technology Kharagpur

Master of Technology, Biotechnology. Grade: 8.2/10.0

```text
Completed M.Tech in Biotechnology with a CGPA of 8.2/10.0.
```

### KLE Technological University

Bachelor of Engineering, Biotechnology. Grade: 9.03/10.0

```text
Completed B.E. in Biotechnology with a CGPA of 9.03/10.0.
```

### KLE's P C Jabin College of Science

Pre-University Course, Science. Grade: 87.5%

```text
Completed Pre-University Course with 87.5%.
```

### Skill Nation

Basic to Advanced Microsoft Excel, Microsoft Excel

```text
Completed certification in Basic to Advanced Microsoft Excel.
```

### Skill Nation

Business Intelligence using Power BI, Power BI

```text
Completed certification in Business Intelligence using Power BI.
```

### Skill Nation

Basic to Advanced SQL, SQL

```text
Completed certification in Basic to Advanced SQL.
```

### École Polytechnique

Scientific Paper Writing, Scientific Paper Writing

```text
Completed certification in Scientific Paper Writing via Coursera.
```

## Tech stack

- NumPy
- Pandas
- MySQL
- Python
- Microsoft Excel
- SQL
- Seaborn
- Matplotlib
- Power BI
- Power Query

To contact Akhila Yallappa, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Niharika User](https://himalayas.app/@niharikauser): SAP ABAP Intern, Patanjali Foods Ltd.
- [vineet gupta](https://himalayas.app/@vineetgupta1): Data Analyst, Self Employed
- [NiTiN User](https://himalayas.app/@nitinuser4): Data Analyst Intern, Self Employed
- [Purvi Varshney](https://himalayas.app/@purvivarshney): Bachelor of Technology (Chemical Engineering), P K University
- [Neeraj Vishvakarma](https://himalayas.app/@neerajvishvakarma): Data Analyst, Self Employed
- [Yash Gosain](https://himalayas.app/@yashgosain): Data Analyst Trainee, Skillcure Academy
- [Milind Saxena](https://himalayas.app/@milindsaxena): Customer Service Representative, Domino's Pizza
- [Reshma Sri](https://himalayas.app/@reshmasri): Data Analyst Intern, Skillified Mentor
- [Chidige Rajeev](https://himalayas.app/@chidigerajeev): Data Analysis using Python Intern, ExcelR EdTech
- [Harsh Srivastav](https://himalayas.app/@harshsrivastav2): Project Assistant (IT & Data Support), ICAR IARI
