MALLIKHARJUNA KARTHIK BALLA
Hyderabad
Summary
Data Analyst with 3+ years of experience in data analytics, business intelligence, and data-driven decision-making. Proficient in SQL, Python, Tableau, and Power BI to gain insights, streamline processes, and drive business growth. Experienced in ETL, data cleansing, modeling, and predictive analytics to enhance data quality and reporting efficiency. Proficient in KPI tracking, ad-hoc analysis, and automation, minimizing manual efforts, and improving operational performance. Solid background in machine learning, forecasting, and data pipeline optimization, with practical experience in AWS, Apache Airflow, and big data processing. Demonstrated skill in communicating insights to stakeholders, and informing data-driven strategies.
Overview
5
5
years of professional experience
1
1
Certification
Work History
DATA ANALYST
DIGITAL REALTY
London
02.2024 - Current
- Optimized SQL queries and big data processing, improving operational costs by 20%
- Built ETL pipelines and automated data integration workflows using Apache Airflow, improving data consistency and processing speed
- Developed predictive models for time series forecasting, applying Python (Pandas, NumPy, Scikit-learn, TensorFlow) to enhance system reliability
- Created interactive Tableau dashboards, enabling real-time KPI tracking, business intelligence (BI), and data storytelling
- Automated reporting workflows, improving stakeholder communication and reducing manual effort in decision-making processes
ASSOCIATE DATA ANALYST
BHANIX
Mumbai
03.2021 - 12.2022
- Performed data cleansing and transformation using SQL and Python, ensuring data accuracy and reliability for business insights
- Built predictive models for customer segmentation and forecasting, leading to better customer targeting and engagement
- Designed interactive Power BI dashboards, improving KPI tracking and enabling data-driven decision-making for stakeholders
- Optimized SQL query performance, reducing data retrieval time and improving overall system efficiency
- Automated ad-hoc reporting and analysis, reducing manual workload and enhancing real-time insights for business teams
CONSULTING ANALYST
CETRIC TECHNOLOGIES
Pune
06.2020 - 02.2021
- Conducted data mining and exploratory analysis, identifying key business trends and customer behavior patterns
- Designed SQL-based data models, improving data storage efficiency and reducing query execution time
- Built Tableau dashboards for KPI tracking and trend analysis, enabling marketing teams to optimize campaigns
- Automated ETL workflows using Apache Airflow, ensuring seamless data integration across platforms
- Delivered data-driven insights, leading to a 12% increase in customer retention and a 20% improvement in marketing performance
Education
MASTER OF SCIENCE (MSc) - DATA SCIENCE AND ANALYTICS
UNIVERSITY OF LONON
LONDON, UNITED KINGDOM01.2023
BACHELOR OF TECHNOLOGY (BTech) - COMPUTER SCIENCE AND ENGINEERING
PVPSEC
VIJAYAWADA, INDIA05.2020
Skills
- Data Mining
- Data Cleansing
- Data Modeling
- Statistical Analysis
- KPI Reporting
- Business Intelligence
- Power BI
- Tableau
- Excel
- Python
- SQL
- R Programming
- SQL Querying
- Advanced SQL
- Joins
- Performance Optimization
- CTEs
- Data Warehousing
- Window Functions
- Query Optimization
- Predictive Modeling
- Forecasting
- Regression Models
- Classification Analysis
- Scikit-Learn
- Feature Engineering
- TensorFlow
- A/B Testing
- Time Series Analysis
- ETL/ELT Automation
- Data Pipelines
- Data Integration
- Apache Airflow
- Pyspark
- Azure Databricks
- AWS
- Redshift
- S3
- RDS
- GCP
- BigQuery
- Dataflow
- Azure
- Synapse
- Data Factory
Certification
- Microsoft Certified: Data Analyst Associate
- Microsoft Certified: Azure Data Engineer Associate (DP-203)
- AWS Certified Solutions Architect – Associate
- Google Cloud Certified – Associate Cloud Engineer
- Certified Data Scientist
Personal Projects
Supply Chain Disruption Tracker | 2023
- Developed an automated data pipeline that scrapes Port Authority APIs (NY/NJ, LA/LB) to track real-time congestion metrics
- Built an interactive Excel dashboard with dynamic KPIs: lead time variability analysis using XLOOKUP and LAMBDA functions, and container dwell time forecasts with exponential smoothing
- Identified three alternative shipping routes through geospatial analysis of AIS vessel data, reducing logistics costs by 12% ($240K annual savings) and the average delay during peak season by 18 days
Loan Approval Prediction Engine | Python, Random Forest, EDA
- Developed a machine learning model predicting loan eligibility with 82% accuracy, using applicant profiles (income, credit history, employment status)
- Engineered features through exploratory data analysis (EDA) include identifying credit history as the strongest predictor (0.42 correlation) and income thresholds affecting approval rates (95% approval above $6,500 per month)
- The optimized Random Forest classifier (n_estimators=7) outperformed SVM/KNN by 18% accuracy
- Automated data preprocessing: Handled missing values with mean imputation, Encoded categorical variables (marital status, education) using LabelEncoder
- Visualized key insights with Seaborn heatmaps and catplots showing gender/income biases.
Timeline
DATA ANALYST
DIGITAL REALTY
02.2024 - Current
ASSOCIATE DATA ANALYST
BHANIX
03.2021 - 12.2022
CONSULTING ANALYST
CETRIC TECHNOLOGIES
06.2020 - 02.2021
MASTER OF SCIENCE (MSc) - DATA SCIENCE AND ANALYTICS
UNIVERSITY OF LONON
BACHELOR OF TECHNOLOGY (BTech) - COMPUTER SCIENCE AND ENGINEERING
PVPSEC
Similar Profiles
ARTHUR PAAKWESI EMMANUELARTHUR PAAKWESI EMMANUEL
Data Center Operation Manager at Digital RealtyData Center Operation Manager at Digital Realty
Anthony PiggueAnthony Piggue
Operations Engineer Level IV at Digital RealtyOperations Engineer Level IV at Digital Realty
John HalsteadJohn Halstead
Facility Assistant at Digital RealtyFacility Assistant at Digital Realty