Vishal Pahal

• Planned and executed a full-scale migration of the analytics warehouse from ClickHouse to Snowflake , including external connectors (Meta, Google, Clevertap, Branch, etc.), led a cross-functional team of 6 analysts and data engineers to deliver the 3-month project with zero disruption to end users .
• Designed and implemented the company's first end-to-end visibility architecture for inventory management , enabling real-time monitoring and decision-making across the supply chain.
• Enhanced reporting accuracy by successfully transitioning all organizational reporting and analytics from the replica database to the production database, leveraging Snowflake's advanced capabilities for reliability and consistency .
• Leading the central AI-powered conversational analyst initiative , enabling business users to interact with databases in natural language, democratizing data access and accelerating decision-making across the organization .
• Built an automated network outage detection and communication system by integrating ping data with Gupshup, ensuring faster issue identification and proactive communication to stakeholders .
• Led end-to-end data support for Fundraising & Due Diligence (DD) , independently managed all data requests during whole of the fund raise process and ensured investor-ready accuracy; directly strengthened investor confidence and company valuation.
• Developed and delivered the company's Annual Operating Plan (AOP) with financial modeling, assumptions, and debt scenarios, shaping strategic and financial decision-making at leadership level.
• Managed ClickHouse data warehouse architecture , proactively collaborating with internal tech and external Apperture teams to reduce data sync errors by 10x (0.4% → 0.04%) , ensuring reliability and stability.
• Led the migration of ~100 analytics reports from replica to ClickHouse in
• Standardized metrics and automated reporting models , cutting report update cycles from 2–3 days/month to , a 66% efficiency gain.
• Automated lead attribution logic , moving from Google Sheets to database tables; eliminated inconsistencies and saved 5–10 manual hours/month for the demand team.
• Established structured UAT process for data releases , reducing post-release errors and minimizing rework cycles.
• Championed AI adoption within the analytics team , automating workflows and saving 20+ hours/month of manual effort over six months.
• Spearheaded the design and implementation of an enterprise-wide Analytics Warehouse on ClickHouse , integrating diverse data sources (CT, Branch, Google, FB, IVR, Gupshup, BigQuery, etc.).
• Automated the monthly online revenue reconciliation process by integrating payment gateway data with internal databases, saving the Finance team 20+ of man-hours every month .
• Instituted function-wise weekly cadence with business teams , ensuring zero data-blockers and accelerating execution of analytics-driven initiatives across functions.
• Led analytics support during major tech releases (Sep'23 – Feb'24), successfully executing 30–40 report migrations/updates per release within tight deadlines.
  

• Handed the team for the largest India OTA, accounting for more than 60% of India's OTA business.
• Ensured the successful execution of the pricing strategy, delivering price parity across platforms from 70% to 90%.
• Improved focus set's share in the top 10 rank from 20% to 38%; achieved a revenue jump of over 50%.
• Created and implemented the RYG framework, a property-level revenue management tool.
• Envisioned the SSO for solving the inventory availability issue; the product was launched in April 2022.
• Worked with tech and data teams to drive automation projects necessary for scaling up.
• Received a 'Certificate of Appreciation' from the Chief Operating Officer, India, and South Asia.

Project - Chemical Release Payload (Lower Atmospheric Scientific Studies)

• Conceptualized and realized a hydro-pneumatic floating piston system for chemical release
• Delivered the project requirements timely to mark the very first successful chemical trail

Project - Semi-cryogenic Propulsion Systems Project (SPSP)

• Led the development activities of hypergolic igniter to boost the payload capacity
• Supervised the overseas shipping of development igniter, incorporating safety protocols

• Evaluated the dominant unaccounted losses - root cause for 2% deviation in net content
• Suggestions revealed improved yield with expected savings of INR 50+ Lakhs over the year
• Received 'Letter of Recommendation' from Manufacturing Head

• Designed a light-weight and low-cost version of 'Ignition Switch-cum-Steering Lock'
• Revamped design of 'Two-Track Internal Biting Key-Set' by modifying biting layout
• Received 'Letter of Appreciation' from Head, New Technology