Rohan Verma

About Rohan Verma

Data is the compass that guides business strategy, and I, Rohan Verma, am a navigator in this complex landscape. As a Data Engineering Consultant at EXL, my ten-year journey in data analytics and business intelligence has been powered by a deep-seated conviction in the transformative power of data. My Master\'s degree in Business Analytics from UC San Diego\'s renowned management school has been the cornerstone of my business acumen, equipping me with the vision to craft data solutions that integrate seamlessly with overarching business goals. Certifications in SQL and Spark have laid the groundwork for my expertise in data architecture and predictive analytics.Dive into my professional realm where AWS cloud services, Python, SQL scripting, and real-time data processing converge to drive transformational growth. In the art of orchestrating data, my proficiency shines through in designing data pipelines, and ETL workflows, leveraging Snowflake for data warehousing, and employing Matillion for data integration. The strategic application of Apache Airflow for orchestration is a testament to my commitment to operational excellence and innovation. This holistic approach has consistently delivered impactful business outcomes, cementing my role as a catalyst for data-driven growth. Let’s connect and chart the course to harness the full potential of your data.

Experience

1. Senior Manager, Data Engineering

   EXL

   Oct 2023 — Present · New York, NY, US

   OTT Platform Project: Developed and optimized KPIs such as gross adds, upgrades, paid subs, churns, win backs, leveraging BigQuery, Airflow, Snowflake, AWS and data bricks to analyze terabytes of data tracking user behavior and subscription metrics.• Processed near-real-time data during the Olympics, updating executives every 15 minutes with metrics like churns, win backs, and new subscriptions. Built automated data pipelines in Airflow to feed these metrics into a live dashboard, enabling actionable insights.• Collaborated with cross-functional teams, including Marketing, Product Analytics, Finance, Executives, and Editorial, to align metric definitions and reporting structures with business goals, ensuring the dashboard delivered key insights into user upgrade trends and retention.• Leveraged a robust CI/CD pipeline to deploy data workflows, rigorously testing and validating changes within a controlled environment to ensure smooth integration of updates and maintain production stability.

Education

• UC San Diego

  Master's degree, Business Analytics

• Deenbandhu Chhotu Ram University of Science & Technology

  Bachelor of Technology (B.Tech.), Computer Science

Skills

• Microsoft Office
• C#
• Microsoft Excel
• Matillion
• Microsoft Word
• C
• Sql Server Integration Services (Ssis)
• Amazon Redshift
• Data Warehousing
• Mysql
• Informatica
• Sql
• Technical Data Analysis
• Sql Server Management Studio
• C++
• Java
• Extract, Transform, Load (Etl)
• Html