Alok Hosamane Jayaranga Prabhamani
Data Analyst
About
Data Analyst with 3.8 years of experience in SQL-heavy data engineering, ETL pipeline development, and business analytics. Proficient in Python, SQL, Azure Data Factory, Azure Data Lake Storage, and Databricks for building and automating scalable data workflows. Experienced in designing data pipelines, ensuring data quality, and delivering actionable dashboards via Tableau and Power BI. Adept at cross-functional collaboration and translating business requirements into reliable, production-ready data solutions.
Skills & Expertise (32)
Work Experience
Data Analyst
Medspark Global Solutions Pvt Ltd
Nov 2020 - Mar 2022
Built and maintained Python-based ETL pipelines to extract, clean, validate, and transform 100K+ records per monthly cycle — structuring raw data into analysis-ready datasets to support operational and customer analytics. Designed and optimised SQL-intensive analytical queries (multi-table joins, aggregations, subqueries) supporting exploratory data analysis, KPI deep-dives, and variance analysis, reducing ad-hoc analysis turnaround time by ~15%. Integrated Python + SQL data pipelines for recurring data preparation, reconciliation, and schema-level transformations — reducing manual processing effort by ~30% and improving pipeline reproducibility across reporting cycles. Developed Tableau-based analytical dashboards using Python-processed datasets to visualise operational and performance metrics, enabling faster pattern identification by cross-functional teams. Implemented Python-based data quality checks tracking completeness, accuracy, and timeliness — reducing recurring analytical error rates from ~6% to ~2% and strengthening trust in analytical outputs. Delivered ad-hoc technical analyses for product, finance, and operations teams using Python and SQL, supporting process-optimisation initiatives that resulted in a projected ~8% labour cost reduction in a targeted workflow.
Data Consultant
Solitude Space (now Four Fold Agency)
Dec 2023 - Oct 2025
Designed and implemented end-to-end data ingestion and transformation pipelines using Azure Data Factory (ADF) and Azure Data Lake Storage (ADLS), enabling centralised, reliable data delivery across marketing, sales, and operations for 15+ clients. Leveraged Azure Databricks and Python (PySpark) to automate weekly and monthly ETL workflows, cutting data processing time from 10+ hours to <1 hour per cycle and improving pipeline reliability. Developed and maintained SQL data pipelines processing >50M records/month — including complex multi-table joins, aggregations, and transformations — enhancing data reliability and supporting cross-channel analytics. Wrote and optimised complex SQL queries to extract, transform, and load data for client dashboards and segmentation models, contributing to a 22% increase in client ROI on ad spend through improved campaign targeting. Architected and deployed 30+ interactive dashboards in Power BI / Tableau, reducing manual reporting effort by 78% and enabling data-driven decisions across leadership teams. Monitored and optimised Python automation processes, achieving a ~33% reduction in runtime errors through robust logging and exception handling.
Digital Marketing Executive
Novel Office
Aug 2020 - Oct 2020
Extracted and cleaned campaign datasets for KPI dashboards and ROI analysis. Built Excel-based dashboards using Pivot Tables, LOOKUPs, QUERY, and custom formulas. Standardized reporting templates and automated recurring reports using spreadsheet scripting.
Education
MSc in Big Data Management & Analytics - Griffith College Dublin
- 2023 · Afghanistan
BSc in Computer Science - Reva University
- 2020 · Afghanistan
Certifications
Google Data Analytics with Python Specialization
· 2026
Google Advanced Data Analytics
· 2025
Google Data Analytics Professional Certificate
· 2024
Python Bootcamp Certification
Udemy · 2021
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Relocation
Open to Relocation
