Prajjval Mishra.
GCP Data Engineer & Analytics Specialist.
Prajjval Mishra.
GCP Data Engineer & Analytics Specialist.
Building scalable data pipelines & BI platforms.
Expert in BigQuery, Power BI & GCP.
Selected Works
A curated selection of projects across data engineering, AI automation, analytics, and creative brand work — each with real business results.
Business 360
Enterprise-level BI platform with fact/dimension schemas, cutting report refresh by 25%.
Keepa Analysis
Automated Keepa API pipeline tracking price history, BSR trends & competitor drops across 50K+ ASINs.
Product Research Engine
Multi-source product research pipeline scoring niches by demand, competition & margin potential.
Amazon Sales Dashboard
End-to-end Amazon seller dashboard covering revenue, ACOS, inventory & buybox health across brands.
Amazon API Integration
Scalable SP-API connector ingesting orders, inventory & advertising data into BigQuery in real time.
Market Keyword Tracker
Automated keyword rank tracker monitoring 5K+ terms daily with trend alerts and share-of-voice reporting.
Kind Words
Feedback from clients and collaborators I've had the pleasure of working with.
“Prajjval built our end-to-end GCP pipeline from scratch. His work on BigQuery and dbt models transformed how we use data — the ACOS improvement to 25% speaks for itself.”
Ryan D.
Operations Lead, Next Degree Products
USA
“The Power BI dashboards Prajjval delivered gave our finance team real-time visibility into KPIs for the first time. Dashboard refresh times dropped by 25% — that alone saved us hours every week.”
Amit K.
Finance Manager, Ambrapali Electrotech
Pune, India
“Prajjval's hospitality analysis was eye-opening. He identified root causes behind our revenue decline and his recommendations directly drove a 10% market share recovery within six months.”
Suresh M.
Strategy Director, Hotel Chain
India
“His ability to translate complex business questions into clean SQL models and actionable dashboards is remarkable. He reduced our reporting effort by 40% — game changer for the team.”
Priya N.
QA & Operations Head, OPPO
Greater Noida, India
“Prajjval built our end-to-end GCP pipeline from scratch. His work on BigQuery and dbt models transformed how we use data — the ACOS improvement to 25% speaks for itself.”
Ryan D.
Operations Lead, Next Degree Products
USA
“The Power BI dashboards Prajjval delivered gave our finance team real-time visibility into KPIs for the first time. Dashboard refresh times dropped by 25% — that alone saved us hours every week.”
Amit K.
Finance Manager, Ambrapali Electrotech
Pune, India
“Prajjval's hospitality analysis was eye-opening. He identified root causes behind our revenue decline and his recommendations directly drove a 10% market share recovery within six months.”
Suresh M.
Strategy Director, Hotel Chain
India
“His ability to translate complex business questions into clean SQL models and actionable dashboards is remarkable. He reduced our reporting effort by 40% — game changer for the team.”
Priya N.
QA & Operations Head, OPPO
Greater Noida, India
“Prajjval built our end-to-end GCP pipeline from scratch. His work on BigQuery and dbt models transformed how we use data — the ACOS improvement to 25% speaks for itself.”
Ryan D.
Operations Lead, Next Degree Products
USA
“The Power BI dashboards Prajjval delivered gave our finance team real-time visibility into KPIs for the first time. Dashboard refresh times dropped by 25% — that alone saved us hours every week.”
Amit K.
Finance Manager, Ambrapali Electrotech
Pune, India
“Prajjval's hospitality analysis was eye-opening. He identified root causes behind our revenue decline and his recommendations directly drove a 10% market share recovery within six months.”
Suresh M.
Strategy Director, Hotel Chain
India
“His ability to translate complex business questions into clean SQL models and actionable dashboards is remarkable. He reduced our reporting effort by 40% — game changer for the team.”
Priya N.
QA & Operations Head, OPPO
Greater Noida, India
Insights
Building Scalable Data Warehouses on GCP with dbt
How I designed staging, intermediate, and mart layers for Amazon & Shopify datasets using BigQuery and dbt — and why modular data modelling matters at scale.
Power BI DAX Optimization: Cutting Dashboard Refresh by 25%
Real-world techniques I used to reduce report refresh times by 25% — from query folding in Power Query to optimizing DAX measures and fact/dimension schema design.
From Raw Data to Business Impact: The ACOS Story
How structured before/after PPC analysis on $120K/month ad data improved ACOS to 25% — and the SQL + Python workflow behind the insight.
Technical Arsenal
4+ years of hands-on expertise across data engineering, analytics, visualization, and cloud platforms.
My Journey
From product analytics at OPPO to building GCP data platforms for US e-commerce. Here is a glimpse into my professional evolution.
Data Operations Specialist / Senior Data Analyst
Next Degree Products, USA (Remote)
Designing end-to-end GCP data pipelines using BigQuery, Cloud Storage, Dataflow, Airbyte, dbt, and Cloud Functions for Amazon & Shopify datasets (10K+ SKUs). Orchestrating workflows with Cloud Composer (Airflow) and CI/CD via GitHub Actions. Improved ACOS to 25% on $120K/month PPC operations.
Data Analyst
Ambrapali Electrotech Pvt. Ltd., Pune
Built automated Power BI and Looker Studio dashboards for a ~$989M insurance portfolio. Designed SQL-based data transformation pipelines, advanced DAX calculations, and MoM metrics. Optimized data models to reduce dashboard refresh times significantly.
Product Analyst Engineer
OPPO, Greater Noida
Used SQL and Power BI to identify process inefficiencies — improving production efficiency by 30%. Built automated KPI dashboards reducing manual reporting by 40%. Led data analysis across 19+ NPI production cycles coordinating with QA, R&D, and operations.
B.Tech., Electronics & Communication Engineering
Graphic Era Deemed University, Dehradun
Graduated with a B.Tech. in Electronics and Communication Engineering, building strong analytical and engineering foundations that shaped my data-driven career.
Let's work
together.
Open to data engineering and analytics opportunities. If you need scalable data pipelines, BI dashboards, or data-driven insights, let's connect.
Download Resume