Tanay Dubey

Experience

• 

  Cognizant

  Nov 2015 - Aug 2018

  Programmer Analyst (Database Tester- Team Lead)

  1.) Project Management: Conducted walkthrough calls with Business Analysts and Developers for knowledge transition of the requirements and part of the Go Live support team to ensure smooth delivery of the project in the production environment.2.) Project Management: Lead a team of 7 to ensure Agile project stayed on track with test scripts maintained in Jira and were delivered under budget and time.3.) Product Ownership: Managed General Data Protection Regulation(GDPR) project as a key resource for E2E testing.4.) Database Testing: Creating test scenarios for data migration, creating and executing SQL queries to execute the scenarios accordingly.5.) Database Testing: Performed constraint testing to validate unique constraints and mapping between primary and foreign keys and performed data structure validation between source and target system.6.) Cost Optimization: Created an SQL query to increase test execution rate which reduced execution time by 30-40% , resulting in on-time project delivery and contributing towards Quarterly revenue. Show less

• 

  Hapag-Lloyd AG

  Oct 2019 - Sept 2021

  Data Analyst

  1.) Statistics: Using Descriptive statistics to dissect the data using R language, analyze results and produce comprehensive reports 2.) Dashboard: Creating BI(Tableau) dashboards as per the Business requirement for Operations, Sales and Customer Service teams 3.) Revenue Optimization: Creating Revenue optimization reports using Solver in Excel for Ships to load optimum Cargo which maximizes Revenue 4.) Exploratory Analysis: Creating Ad hoc reports on Quick Quotes, Supply and Demand, Revenue management and communicating the same to different stakeholders across Trade management, Regional Sales, Customer Service and Area Teams Show less

• 

  Swvl

  Sept 2021 - May 2022

  Global Business Intelligence Specialist

  1.) Dashboard: Handling Central operations in terms of payments and providing actionable insights through BI dashboards created through Tableau and Google Data Studio 2.) Automation: Creating Automated communication channel in PDF format using Python to communicate external stakeholders regarding new Rate Cards through Whatsapp API. Python Script Automated through EC2 Instance on AWS 3.) New Market Expansion: Performed exploratory analysis on new market and created end to end level insights for New service launched in Argentina 4.) Strategic management: Part of Strategy and innovation task force to ensure Data Governance and new initiatives to be taken for new markets 5.) Stakeholders Management: Created simple yet effective visualizations to be used by Top Managements in regular meetings and provided day to day reports to Mid Level management Show less

• 

  Talabat

  Aug 2022 - Sept 2022

  Business Intelligence Specialist

  1.) Dashboard: Creating dashboards on Tableau and Looker for Performance team for observing daily, weekly, monthly level performance KPIs 2.) Dashboard: Creating seamless Tableau Data Pipeline/ETL for efficient data aggregations and managing the same Exploratory Analysis: Providing Ad-Hoc data analysis for Short and long run projects across internal stakeholders in Sales, Logistics, Marketing team with relevant actionable insights 3.) Data Extraction and Automation: Extracting Data from AWS Redshift and Google Big Query and creating Automated scripts using Python on AWS-EC2 Instance 4.) Performance Management: Providing monthly forecast of Performance KPIs and preparing financial analytical reports on monthly basis for top management stakeholders 5.) Optimization: Co-ordinating with other Data Analysts to improvise the data reporting methods and contributing improving the efficiency of Data Modelling Show less

• 

  Almosafer

  Dec 2022 - now

  1.) Revenue Optimization: Performed In-depth Analysis of transaction level data to come up with new Pricing models, based on demand fluctuation, seasonal trends, competitive benchmarking and special events to maximize revenue and both topline andbottom-line KPIs2.) Stakeholder Management: Work closely with Sales, Marketing and operations teams to align revenue strategies with overall business objectives.3.) Flights: Analyzing performance of Low cost and Full service airlines across different routes/destinations and take corrective actions in terms of pricing and revenue streams.4.) Hotels: Collaborate with Sourcing, Marketing and Sales to optimize different distribution channels and drive direct contract bookings to increase overall margin and absolute revenue across direct and third party suppliers basis net and gross contracts.5.) Dashboard: Create Tableau dashboard to showcase performance against different Revenue Streams across all products for top management.6.) Data Extraction: Extracting data from Google Big Query and creating Ad-Hoc Google Sheet reports and Tableau Dashboard on case to case basis7. Key Actions and Achievements: Hotels: Optimized markups for Hotels as a result growth in Direct Contract Sales Share by 40% and increase in absolute revenue by 40-50% across frequently booked room types and shift in supplier mixFlights: Optimized Service Fee for Low Cost and Full Service Airlines boosting revenue by 45% Show less

  • Manager(Analytics)- Revenue Management

    Jan 2025 - now

  • Assistant Manager- Anaytics(Revenue Management)

    Dec 2022 - Dec 2024