Gaurav Rana
Seattle,WA
Summary
Architecting large-scale data engineering platforms, powering high-growth product ecosystems with self-service analytics. Results-oriented IT professional with more than 17 years of experience leading application development into scalable distributed systems. Proven ability to lead high-performance teams through large-scale IT projects impacting mission-critical process improvements. Skilled at analyzing requirements and translating business needs into a comprehensive strategy, road map, and implementation plans. Highly regarded for interacting effectively with clients, building trust and rapport while enabling business and product teams to make fast, data-driven decisions at scale.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Data Engineering Lead / Senior BI Architect
Holland America Cruise Line
Seattle, WA
11.2018 - Current
- Mentored Data engineering team to understand the Business functionality and rules, conducting brainstorming sessions within team to conceptualize and formulate efficient orchestrations that are scalable with minimum changes.
- Streamlined Scrum process by introducing different stages in the agile sprint methodology starting from Pre-grooming, Grooming, Tech Review, Mid Sprint Health check , Retrospective meeting which help in better coordination and knowledge transfer within the team.
- Built scalable cloud-based data pipelines across AWS + Snowflake for the processing of data from on-prem and shipside applications, focused on Reservations, Onboard Revenue & Inventory, Safety and Audit, Revenue analytics, and Accounting and Finance analytics.
- Leading a team of Data engineers in transforming the current data architecture into next-generation architecture with the use of cutting-edge tools.
- Developed a customized Python ingestion framework for data maintained by Business users, giving them the capability to load the csv files to Snowflake/Oracle performing data checks and applying data referential constraints for uniqueness and duplicity.
- Migrated SSRS → Power BI at scale to reduce reporting latency by 40%, supporting self-service analytics for 1,000+ stakeholders.
- Automated reporting and alert systems through Power Automate, saving more than 200 analyst hours per month.
- Partnered with business and led BI and Data engineering team to enable performnat datasets and brought down the Power BI compute by approx. 30% by utilizing Dataflows and moving transformations to database layer.
BI Consultant
Interglobe Technologies
Seattle, WA
08.2014 - 11.2018
- Designed interactive, scalable Tableau dashboards that support global revenue operations and product analytics.
- Democratized data by training over 500 users in self-service analytics.
- Designed cross-functional data specifications to align Finance, Marketing, and Ops KPIs across global teams.
Business Analyst & Senior Developer
IBM India Pvt. Ltd.
Bengaluru, Karnataka
05.2010 - 07.2014
- Led CRM data migration (Clarify → Siebel) for Vodafone, impacting 10M+ users with new data platform.
- Acted as an SME on Order Management and Product Configuration modules of Siebel CRM.
- Delivered BI Publisher-reporting pipelines integrated with CRM, providing scalable operation insights.
Education
B. Tech - Electronics & Communication
GGSIPU
Skills
- Leadership & Mentoring
- Data Modelling and Warehousing
- Reporting
- Cross-functional collaboration
- Maintenance & Debugging
Certification
- Trifacta Admin
- Trifacta Wrangler
Key Technologies
- Snowflake
- Power BI
- Tableau
- Python
- Matillion
- PowerCenter
- Siebel
Timeline
Data Engineering Lead / Senior BI Architect
Holland America Cruise Line
11.2018 - Current
BI Consultant
Interglobe Technologies
08.2014 - 11.2018
Business Analyst & Senior Developer
IBM India Pvt. Ltd.
05.2010 - 07.2014
B. Tech - Electronics & Communication
GGSIPU