Summary
Overview
Work History
Education
Skills
Project
Certification
Timeline
Hi, I’m

Kartheek Naik Mood

Bengaluru
Kartheek Naik Mood

Summary

Certified Power BI and Data Analyst with extensive experience in building dynamic dashboards, maintaining scalable data pipelines, and implementing robust data governance frameworks. Proficient in Power BI, Python, SQL, and ETL processes, with a proven track record of improving data accessibility, reducing manual processes, and optimizing decision-making. Skilled in API integration, cloud data platforms, and automation tools, delivering innovative solutions for real-time analytics.

Overview

4
years of professional experience
1
Certification

Work History

Aereo
BANGALORE

Data Analyst & PowerBI Developer
06.2023 - Current

Job overview

  • Dynamic Power BI Reporting: Designed and maintained Power BI reports and dashboards for CXOs and managers, enabling real-time insights into KPIs and operations.
  • Excel Automation: Automated workflows using Power Query, VBA, and Python scripts, reducing manual data entry by 85%, and increasing efficiency across departments.
  • Pipeline Development: Built and maintained data pipelines from the Skylink API to MongoDB and Power BI, ensuring seamless data flow and integration with AWS Cloud.
  • Server Monitoring System: Created a pipeline to track server storage, CPU, and RAM utilization across daily, weekly, and monthly time frames, integrating data with Power BI for performance visualization.
  • Data Governance: Validated and monitored JSON submissions to MongoDB, ensuring data integrity, and optimized bandwidth usage for scalable reporting.

Mars Wrigley
BANGALORE

MIS Analyst & PowerBI Developer
11.2022 - 06.2023

Job overview

  • Sales Reporting & Target Analysis: Delivered daily sales reports and set monthly targets using Power BI dashboards, improving reporting speed by 30% with Power Query optimizations.
  • Budget Management: Tracked trade spend and ensured budget adherence, achieving a 10% reduction in overspending through enhanced analytics.
  • SQL Database Optimization: Enhanced ad hoc reporting efficiency by integrating SQL databases for faster data retrieval and analysis.
  • Business Insights: Created automated dashboards for stakeholders, aligning sales strategies with performance trends to improve resource allocation.

National Autoplast
Ananthapur

MIS Analyst & PowerBI Developer
07.2020 - 07.2022

Job overview

  • Cross-Departmental Reporting: Integrated daily data from production, quality, inventory, and sales departments into SAP and Power BI, streamlining reporting processes for higher management.
  • Excel Automation & Power BI: Developed Excel automations and Power BI dashboards to reduce manual data entry, and improve reporting accuracy by 25%.
  • SAP Integration: Implemented SAP Cloud Storage, linking with Excel and Power BI for secure, accessible data storage, and analytics.
  • Cost Reduction: Led weekly budget discussions with departmental teams, and implemented cost-saving strategies, achieving a 15% reduction in operational expenses.

Education

GVR&S College of Engineering & Technology
Guntur

Bachelor of Science from Civil Engineering
11-2020

Skills

  • Data Visualization & BI Tools: Power BI (Advanced DAX, Power Query), Tableau
  • Data Integration & Automation: ETL, Python (pandas, NumPy), Google Apps Script
  • Programming: Python, VBA, SQL (Joins, Window Functions, CTEs)
  • Data Storage & Management: MongoDB, AWS Cloud, SAP, MySQL, OneDrive
  • Database Design & Analysis: Data Warehousing, Star Schema, Snowflake Schema
  • Advanced Analytics: Predictive Modeling, KPI Analysis, Data Mining

Project

Dynamic Power BI Reporting and Excel Automation

  • Objective: Designed and maintained dynamic Power BI reports and Excel automation to streamline data analysis and reduce manual effort.
  • Key Activities: Automated workflows with Power Query, DAX, and VBA, reducing manual data entry by 85%. Created Power BI dashboards for CXOs, project managers, and operations teams, offering real-time insights into KPIs and operational performance. Implemented validation processes for data accuracy and ensured seamless connectivity between data sources and Power BI.
  • Maintenance: Continuously monitored data pipelines and dashboard performance, ensuring uninterrupted reporting and data integrity.

Skylink API to MongoDB and Power BI Integration

  • Objective: Developed a robust pipeline to ingest data from Skylink API into MongoDB hosted on AWS Cloud, with dynamic reporting in Power BI.
  • Key Activities: Validated JSON data submissions to MongoDB, ensuring data accuracy and compliance.
    Monitored pipeline connectivity and optimized data flows to handle large datasets efficiently.
    Built dynamic Power BI reports with advanced DAX and Power Query for real-time analytics, enabling actionable insights for stakeholders.
  • Maintenance: Regularly updated and optimized API integrations and MongoDB bandwidth usage, ensuring pipeline scalability and reliability.

Server Utilization Pipeline: Local Servers to Power BI

  • Objective: Designed and implemented a pipeline to monitor server performance metrics, including CPU, RAM, and storage utilization, across multiple time frames.
  • Pipeline Design: Local Servers → API → OneDrive → Power BI Services.
  • Key Activities: Automated data extraction using Python scripts and API connectivity to collect server metrics. Created Power BI dashboards with daily, weekly, and monthly performance views for resource monitoring. Improved pipeline efficiency by reducing data latency and enhancing connectivity with Power Query.
  • Maintenance: Continuously tracked pipeline performance and implemented enhancements to improve data accuracy and reporting efficiency.

Certification

Microsoft Power BI Data Analyst Certificate:

  • Advanced training in data preparation, modeling, and visualization using Power BI
  • .Specialized in DAX, Power Query, and dashboard creation for actionable business insights.

Timeline

Data Analyst & PowerBI Developer

Aereo
06.2023 - Current

MIS Analyst & PowerBI Developer

Mars Wrigley
11.2022 - 06.2023

MIS Analyst & PowerBI Developer

National Autoplast
07.2020 - 07.2022

Microsoft Power BI Data Analyst Certificate:

  • Advanced training in data preparation, modeling, and visualization using Power BI
  • .Specialized in DAX, Power Query, and dashboard creation for actionable business insights.

GVR&S College of Engineering & Technology

Bachelor of Science from Civil Engineering
Kartheek Naik Mood