Karan Jain

About Karan Jain

Early in my career, I spent hours manually cleaning data until my eyes blurred. I finally stopped and asked myself: “Why am I doing this when a system could?” That curiosity led me to the Developer tab in Excel, and my professional life changed.Today, as a Senior Data Analyst at Dentsu, I specialize in eliminating manual friction. I bridge legacy systems with modern solutions by building automated workflows using VBA, IBM PAfE, and native AI integrations. My focus is on streamlining complex media reporting and pacing analytics so teams can focus on strategy instead of copy-pasting.By engineering custom automation scripts and optimizing data architecture, I transform multi-layered data into clear executive reports. This approach has successfully reduced manual processing time by over 40% for key reporting cycles, saving my teams 20+ hours of redundant work each month.I am not an \"AI Guru\", I am a practitioner. I believe the best data professionals don\'t just analyze numbers; they build the engines that make the analysis faster and more accurate.If you are an operations leader, a recruiter in the data space, or a professional tired of manual bottlenecks, let\'s connect. Send me a direct message, and let\'s talk about the one manual task you wish would just disappear.

Experience

1. Senior Data Analyst (Via Paragon Digital Services)

   dentsu

   Jan 2025 — Present

   Contracted via Paragon Digital Services. Currently working remotely to support Australian (AU) market operations.The 6-Hour to 5-Minute Win: Eradicated manual data cleaning for the BI team by engineering an advanced Excel automation workflow, reducing a grueling 6-hour daily task down to just 5–10 minutes.Enterprise Media Automation: Build and manage Forecasting & Budgeting tools using IBM Planning Analytics for Excel (PAfE) and Cognos Analytics, empowering agencies to track cross-client spending.One-Click Reporting: Consolidate massive, multi-channel media data (Display, Search, Social, TV, OOH, Audio) into standardized dynamic dashboards with custom landing pages for instant filtering and one-click data refreshing.Team Utilization Dashboards: Built an automated Excel system to consolidate daily team efforts, using that data to feed Power BI dashboards that track performance and utilization hours.

Education

• Jain (Deemed-to-be University)

  Master of Business Administration - MBA, Data Science and Analytics

• Pillai College of Arts,Commerce and Science

  Bachelor of Science - BSc, Information Technology

  2018 — 2021