
Akhila Yallappa Olekar
@akhilayallappaolekar
Data Analyst using SQL, Excel and Power BI to analyze sales, delivery performance and 3.47 bn transactions.
What I'm looking for
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
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.
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.
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.
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
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
Bachelor of Engineering, Biotechnology
Grade: 9.03/10.0
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%
Completed Pre-University Course with 87.5%.
Skill Nation
Basic to Advanced Microsoft Excel, Microsoft Excel
Completed certification in Basic to Advanced Microsoft Excel.
Skill Nation
Business Intelligence using Power BI, Power BI
Completed certification in Business Intelligence using Power BI.
Skill Nation
Basic to Advanced SQL, SQL
Completed certification in Basic to Advanced SQL.
École Polytechnique
Scientific Paper Writing, Scientific Paper Writing
Completed certification in Scientific Paper Writing via Coursera.
Tech stack
Software and tools used professionally
Availability
Location
Authorized to work in
Salary expectations
Social media
Job categories
Interested in hiring Akhila Yallappa?
You can contact Akhila Yallappa and 600K+ other talented remote workers on Himalayas.
Message Akhila YallappaGet 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!
