Name: Akhil K N

Job Role: Technical Lead – Data Analyst at Infosys

Experience: 8 Years

Address: Bangalore, Karnataka, India

Skill

SQL 85%
Power BI 85%
Microsoft Fabrics 80%
Microsoft Excel 80%
Python 80%
SharePoint 80%
Tableau 75%
Microsoft Power Automate 75%
Microsoft Power Apps 70%

About

About Me

I'm Akhil K N,Technical Lead – Microsoft Certified Fabric Analytics (DP-600) professional with 8 years of experience in data analytics, BI, and database management, including 3+ years in Healthcare/Clinical data. Expert in designing and implementing scalable data models, ETL pipelines, and enterprise reporting solutions using Power BI, Microsoft Fabric, DAX, and SQL. Proficient in developing low-code automation solutions using Power Apps, Power Automate, and SharePoint for integrated data workflows. Hands-on experience with advanced DAX measures, Python-based data analysis, custom visuals, and performance tuning for large datasets. Skilled in transformation, normalization, metadata management, and statistical analysis across diverse data platforms and APIs

Tools and Technologies I work with:
- Power BI
- SQL
- Tableau
- Microsoft Fabrics
- Python
- Microsoft Excel
- Power Automate
- SharePoint
- PowerApps

My Functional Areas:
- Data Gathering
- Data Cleaning
- Data Modelling
- Data Analysis
- Data Validation
- Dashboarding
- Data Visualization
- Business Requirements
- Data Governance
- Key Performance Indicators

Driven by a strong sense of curiosity and a passion for using my programming, management, and data analysis skills, I am committed to making a significant impact. I am excited about the opportunities to learn, innovate, and contribute positively to the world through data.

  • Profile: Data Analytics
  • Domain: Healthcare, Logistics, Supply Chain, Finance
  • Education: Bachelor of Engineering
  • Language: English, Kannada, Hindi
  • Analytical Tools: Power BI, Microsoft Fabrics, Advanced Excel, Tableau, Statistics
  • Certification: Microsoft Certified (DP-600): Fabric Analytics Engineer Associate
  • Programming Languages: SQL, Python
  • Database: MySQL, MSSQL, SharePoint
  • Software: Power Apps, Power Automate, GitHub, Sharegate, Jupyter Notebook, VS Code, Joget, Google Colab
  • Web Development: HTML, CSS, JavaScript, PHP
  • Soft Skills: Communication, Problem-Solving, Collaboration, Customer Focus

0 +   Projects completed

Github

Resume

Resume

Microsoft Certified Fabric Analytics (DP-600) professional with 8 years of experience in data analytics, BI, and database management, including 3+ years in Healthcare/Clinical data. Expert in designing and implementing scalable data models, ETL pipelines, and enterprise reporting solutions using Power BI, Microsoft Fabric, DAX, and SQL. Proficient in developing low-code automation solutions using Power Apps, Power Automate, and SharePoint for integrated data workflows. Hands-on experience with advanced DAX measures, Python-based data analysis, custom visuals, and performance tuning for large datasets. Skilled in transformation, normalization, metadata management, and statistical analysis across diverse data platforms and APIs

Experience


Sep 2024 - Present

Technical Lead

Infosys Limited, Bangalore

  • Led the migration of 100+ legacy dashboards from Tableau to Power BI using Microsoft Fabric and Lakehouse architecture, integrating data from Oracle, SQL Server, Denodo, DB2, Excel, SharePoint, and Outlook. Automated data ingestion and reconciliation using Python scripts, reducing manual effort by 40%.
  • Developed 25+ advanced dashboards with star schema modelling, custom DAX measures, drill-through navigation, and cutting report generation time by 40% and improving operational efficiency by 30%.
  • Optimized data pipelines by implementing incremental data refresh, Gate way connections, and parameterized queries across Power BI datasets and Derived tables in the Microsoft Fabrics, enhancing query performance by 35% and ensuring data integrity and validation across platforms.
  • Managed the full BI development lifecycle (Requirement Analysis, Data Modelling, ETL, Report Development, Testing, Deployment, Hypercare) using Agile methodologies, delivering projects on time with a 25%+ increase in adoption and stakeholder satisfaction.

Jul 2024 - Aug 2024

Internship

iNeuron.ai, Bangalore

  • The Heart Disease project focuses on the healthcare sector, analyzing complex data to diagnose heart conditions. This roles require a deep understanding of data analytics, including statistical analysis and predictive modeling techniques.
  • Collaborated effectively to analyze a complex heart disease dataset, focusing on critical metrics such as age, sex, chest pain type, resting blood pressure, and serum cholesterol levels to derive valuable insights into cardiovascular health.
  • Conducted an in-depth examination of the dataset, revealing significant patterns such as 47% of patients exhibiting symptoms of typical angina and 38.4% displaying signs of reversible defects, which are crucial for effective diagnosis and treatment planning.
  • Utilized statistical analysis and predictive modeling techniques to navigate through the dataset, uncovering actionable insights that aided in understanding and diagnosing heart conditions.
  • Leveraged PowerBI tools to create detailed reports and interactive dashboards, enhancing strategic decision-making for stakeholders and deepening my proficiency in applying data analytics to real-world healthcare scenarios.

May 2022 - Jan 2024

Programmer Analyst

Novigo Solutions, Mangalore

  • Engineered 20+ Power BI reports and 8 interactive dashboards by integrating SAP BW via REST APIs and Excel data sources, implementing data modelling, relationships, and DAX-driven KPIs to deliver actionable insights across supply chain, payment terms, and cross-purchasing verticals.
  • Applied ABC inventory classification and time-series analysis on fast-moving and slow-moving items, optimizing stock levels by 20%, reducing excess inventory by $50,000, and improving inventory turnover ratio.
  • Performed vendor-level payment term analysis using Power BI and SQL-based aggregation logic across 5 payment categories, calculating Days Payable Outstanding (DPO) for 50+ vendors, contributing to a 10% cost savings (~$1.2M annually).
  • Conducted variance analysis using Actual vs Target metrics for 10+ business units with calculated DAX measures, enabling the recovery of 20% of missed purchases in 3 months and achieving $80,000 in cost savings.
  • Developed KPI-driven dashboards tracking 10+ inventory categories and financial indicators using Power BI Bookmarks, Tooltips, and Drill-through, leading to a $0.5M revenue increase and a 15% gain in cross-purchase process efficiency.

Feb 2019 - Apr 2022

Junior Programmer

Nitte University, Mangalore

  • Led as a Full Stack Developer for the Hospital Management System (HMS) Project, overseeing modules like OP, IP, Billing, Insurance, Pharmacy, MRD, Lab, Radiology, etc., and spearheaded the development of the OPEMR module for 30+ departments, serving a user base of 400+ doctors.
  • Achieved a 15% decrease in Hospital Expenditure by implementing the HMS Project, significantly reducing paperwork and administrative overhead costs, amounting to savings of ₹5,00,000 annually.
  • Decreased patient waiting times by 20% through streamlined processes enabled by the HMS project, enhancing patient satisfaction and retention.
  • Contributed to a 15% increase in hospital revenue, generating additional revenue of ₹10,00,000.

Apr 2017 - Dec 2018

Content Scheduler

Perform Group, Mangalore

  • Creating the content for the Live and Future events.
  • Performing the Quality checks for the Articles/Contents which have been done by other creators.
  • This led to a 10% decrease in Error showing in the upcoming or live matches.



Education


2012-2016

Information Science Engineering

Jawaharlal Nehru National College of Engineering, Shimoga, Karnataka.

Grade: First class.

2011-2012

Higher Secondary School

Vidhya Bharathi College Shimoga, Karnataka.

Grade: First class.

Projects

Internships and Projects

Below are the Data Analytics Internships and Projects on Power BI , Python, SQL , GenAI, Excel and Tableau.

Heart Disease Diagnostic using PowerBI

Completed an Internship at iNeuron, where I analyzed complex healthcare data to diagnose heart conditions. I employed statistical analysis and predictive modeling techniques and built comprehensive reports using PowerBI.

US Healthcare Analytics PowerBI

Explore the U.S. healthcare landscape (2019-2020) through our PowerBI analysis. Delve into hospital performance, patient outcomes, and payer-provider dynamics with detailed reports and visualizations.

Bank Loan Analysis in Power BI using MSSQL

Presents a comprehensive analysis of bank loan data, encompassing key metrics such as loan issue date, loan status, payment date, annual income, loan amount, and payment type.

Text-to-SQL LLM Application for Querying SQL Databases Using Google Gemini Pro

Developed an end-to-end application using Google Gemini Pro to create a Text-to-SQL LLM app, which converts natural language inputs into SQL queries and retrieves results from the SQL database.

Nutritionist Gen AI Doctor Using Google Gemini Pro Vision

Developed a comprehensive Nutritionist Generative AI application using Google Gemini Pro Vision. This application allows users to upload food images and receive detailed nutritional information, including calorie counts, for each meal.

Analyzing Bike Sales Data with Excel

This report offers detailed insights into Employee ID, Marital Status, Income, Gender, Children, Education, Occupation, Homeowner Status, Commute Distance, Region, Age, and Purchased Bike.

Data Analysis project for Awesome Chocolates Company with Excel

This report provides comprehensive information regarding the employees of the Awesome Chocolates company hailing from New Zealand and India.

The Emergency Room Dashboard

Created a Tableau dashboard to provide insights into Emergency Room details.

Python Project for Scraping YouTube using the YouTube Data API

In this project, we're extracting data from the YouTube channels of Codebasics and Krish Naik using an API key.

All projects on Github

A person passionate about data.


GitHub

Contact

Contact Me

Below are the details to reach out to me!

Address

Bangalore, India

Contact Number

+91- 77609 26372

Email Address

akhilnagarajkn@gmail.com

Download Resume

resumelink



Have a Question? Click Here