Skip to main content
AO
Looking for a job

Akhila Yallappa Olekar

@akhilayallappaolekar

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

India
Message

What I'm looking for

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.

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

Work history, roles, and key accomplishments

SE
Current

Independent Study & Upskilling

Self Employed

Jan 2024 - Present (2 years 10 months)

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.

KL

Research Intern

Kay Bee Bio-Organics Pvt. Ltd.

May 2023 - Jul 2023 (2 months)

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

SS

Biotech Intern

Shankaranarayana Life Sciences

Jan 2022 - May 2022 (4 months)

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.

PCR
Protein Purification
Recombinant DNA Technology
Documentation
SE

Community Advocate (Water & Education)

Self Employed

Jan 2019 - Apr 2019 (3 months)

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.

Education

Degrees, certifications, and relevant coursework

Indian Institute of Technology Kharagpur logoIK

Indian Institute of Technology Kharagpur

Master of Technology, Biotechnology

Grade: 8.2/10.0

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

KLE Technological University logoKU

KLE Technological University

Bachelor of Engineering, Biotechnology

Grade: 9.03/10.0

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

KS

KLE's P C Jabin College of Science

Pre-University Course, Science

Grade: 87.5%

Completed Pre-University Course with 87.5%.

SN

Skill Nation

Basic to Advanced Microsoft Excel, Microsoft Excel

Completed certification in Basic to Advanced Microsoft Excel.

SN

Skill Nation

Business Intelligence using Power BI, Power BI

Completed certification in Business Intelligence using Power BI.

SN

Skill Nation

Basic to Advanced SQL, SQL

Completed certification in Basic to Advanced SQL.

École Polytechnique logoCP

École Polytechnique

Scientific Paper Writing, Scientific Paper Writing

Completed certification in Scientific Paper Writing via Coursera.

Availability

Looking for a job

Location

India

Authorized to work in

Salary expectations

765k+ INR

Job categories

Interested in hiring Akhila Yallappa?

You can contact Akhila Yallappa and 600K+ other talented remote workers on Himalayas.

Message Akhila Yallappa

People also viewed

View all talent

Get matched with your dream remote job

Sign up now and join over 1,000,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan