VIKRANT PAL
Top Rated Freelancer on Upwork with a 100% Job Success Score.
Hi! I’m a senior data analyst focused on building end-to-end analytics solutions. From data modeling and ETL pipelines to interactive dashboards and performance reporting, I help organizations turn complex datasets into strategic clarity.
Hi, I’m Vikrant.
I work as a data analyst building end to end analytics systems. From data modeling and ETL pipelines to dashboards and performance reporting, I help organizations transform raw data into clear, strategic insights.
My experience spans data engineering, analytics automation, reporting architecture, and business intelligence. I focus on creating scalable data foundations that support smarter decisions across teams.
Built end-to-end analytics systems integrating marketing, CRM, and operational data to deliver accurate ROI attribution and executive reporting. Automated market research workflows and commission systems, significantly reducing manual effort while improving data accuracy and business visibility.
Designed high-impact marketing dashboards for 20+ clients while managing and optimizing Snowflake data warehouse environments. Automated reporting workflows and developed advanced SQL models to enable real-time campaign performance tracking and strategic decision making.
Built scalable data pipelines using Python and SQL to automate reporting and improve operational efficiency. Led cohort, retention, CLTV, and fraud analysis initiatives that increased customer engagement and supported revenue growth strategies.
Developed and optimized SQL queries, improved database schema design, and enhanced query performance by reducing response times. Gained foundational expertise in database systems and structured data modeling.
Areas of Expertise
I collaborate with startups, founders, and growing teams on analytics-driven projects.
Data Analytics & Business Intelligence
Transforming raw datasets into meaningful insights through advanced SQL, Python, and BI tools. I design KPI frameworks and dashboards that help leadership make confident, data-backed decisions.
Data Engineering & ETL Pipelines
Building clean, scalable data pipelines and automated workflows. Experience with structured data modeling, transformation logic, and analytics-ready architecture.
Dashboarding & Visualization
Creating interactive dashboards using Metabase, Apache Superset, Power BI, Tableau, and custom visualization tools to simplify complex metrics into intuitive visuals.
Analytics Automation & Reporting
Designing automated reporting systems that reduce manual effort and improve operational efficiency across teams.
Data-Driven Growth & Performance Analysis
Analyzing user behavior, revenue metrics, and operational data to uncover opportunities for optimization and measurable growth.
Cloud Analytics & Infrastructure Architecture
Designing and migrating end-to-end analytics stacks across cloud environments, with hands-on experience in AWS ETL pipelines, data lakes, and scalable cloud architectures.
Portfolio
A glimpse of the projects I've been working on
End-to-End AWS Analytics & API Data Pipeline
Architected and owned an end-to-end AWS-based analytics pipeline integrating API ingestion, Glue ETL processing, Redshift warehousing, and automated reporting workflows.
🚀 Multi-Client Marketing Analytics Infrastructure
Owned and delivered 150+ automated dashboards across 50 marketing clients using Airbyte, PostgreSQL, and Metabase, building a scalable analytics infrastructure for agency-wide reporting.
Customer Lifetime Value (CLTV) Analytics – Real Estate Investment Platform
Built a customer lifetime value framework to analyze investor behavior, repeat investments, and revenue performance using SQL and Metabase.
Full Analytics Stack Migration
Led full migration of ETL pipelines, databases, and dashboards from AWS to Hetzner Cloud, reducing infrastructure costs by ~80% while maintaining reporting reliability.
Cross-Channel Paid Media Performance Dashboard
Built a cross-channel performance dashboard integrating Bing and Facebook campaign data to track impressions, CTR, conversions, cost efficiency, and demographic performance.
Facebook Paid Media Performance Dashboard
Built a Facebook campaign analytics dashboard analyzing 140,145 impressions and 626 clicks, with deep segmentation across device, age, gender, and geography.