Akash Prasad

Data Analyst with 4+ years of experience delivering end-to-end analytics across B2B, healthcare, and finance. Skilled in building ML-ready datasets (95% classification accuracy), automating high-volume data pipelines, and designing executive dashboards using SQL, Python, BigQuery, Power BI, Tableau, and Looker Studio. Known for translating complex data into insights that drive revenue growth, operational efficiency, and strategic decision-making.

Data Analyst at OfBusiness (2024-12 – Present)

• Engineered and maintained 200+ production Apache Airflow DAGs orchestrating MongoDB → Google Cloud Storage → BigQuery pipelines, resolving schema mismatches, OOM failures, and parse-time bugs to cut pipeline failure rate by 20%
• Optimized BigQuery query performance and partitioning strategy across core pipelines, reducing average query runtime by 20% and cutting monthly compute costs by 30%
• Automated cross-functional reporting workflows using Google Apps Script, Google Sheets, BigQuery, and Google Chat webhooks, saving the team 8–10 hours/week
• Delivered market share, retention/churn, and funnel dashboards in Looker Studio, powered by advanced BigQuery window functions (QUALIFY ROW_NUMBER(), LAG()), adopted by leadership to guide go-to-market strategy
• Built a predictive client engagement tracker in BigQuery/Python to surface dormant-account upsell opportunities, identifying ₹50L+ in pipeline
• Built and maintained funnel tracking dashboards (Intents → Requirements → Revenue) in Looker Studio using BigQuery, segmented by acquisition channel (Inorganic, Marketing, Organic), enabling sales and marketing to pinpoint highest-converting channels
• Designed a Gemini API-powered tender-bidder relevancy model in Python, analyzing client bidding history and eligibility criteria to surface high-fit tenders, improving match relevance by 80%
• Benchmarked multi-model LLM prompt pipelines for automated sector categorization, cutting tagging latency by 90% while maintaining precision above 95%

Data Analyst at Visit Health (2023-09 – 2024-08)

• Analyzed healthcare utilization data with SQL, uncovering trends that contributed to a 15% increase in client revenue
• Built dynamic operational dashboards on AWS QuickSight and Looker Studio, enabling real-time decision-making across product, clinical, and sales teams
• Automated Python-based reporting pipelines using AI tools, cutting report generation time by ~90% (from 2 hours to 10-15 minutes)
• Developed segmented service-performance visualizations that improved user engagement and service adoption by 30%
• Delivered recurring and ad hoc analytics reports for leadership, product, and sales teams to support strategic and operational planning

Analyst at Aon (2021-09 – 2023-09)

• Managed and validated large-scale employee benefits datasets in Excel, achieving 100% SLA compliance across all reporting cycles
• Optimized SQL queries for data cleaning and validation, reducing data inconsistencies by 50%+ and improving downstream report reliability
• Built detailed reports analyzing benefits enrollment trends and financial impact for internal stakeholders
• Documented SOPs, process workflows, and QA checklists, adopted as standard process across a 20 person team and reducing onboarding time by 50%
• Partnered with stakeholders to gather business requirements and deliver analytics solutions

Bachelor of Business Administration in BBA – Bhagwan Parshuram Institute of Technology, GGSIPU (2018-08 – 2021-08)