Deepika Thelapola

• Analyzed travel booking data and customer behavior metrics using SQL and Python to identify trends and support revenue optimization initiatives, processing datasets containing millions of transaction records across global distribution systems
• Built and maintained interactive Power BI dashboards tracking key performance indicators including booking conversion rates, average transaction values, customer retention metrics, and agency performance scores with drill-down capabilities by region, travel type, and time period
• Written complex SQL queries against SQL Server and Azure Data Explorer (ADX) databases to extract, transform, and aggregate large datasets for weekly and monthly reporting, utilizing window functions, CTEs, and stored procedures for efficient data retrieval
• Developed Python scripts using Pandas and NumPy to perform exploratory data analysis on booking patterns, identifying seasonal trends, pricing anomalies, and customer segmentation opportunities that inform marketing strategies
• Collaborated with product and finance teams to define data requirements and deliver ad-hoc analysis supporting strategic business decisions, including fare competitiveness analysis, route profitability assessments, and customer lifetime value calculations
• Performed comprehensive data quality checks and validation to ensure accuracy of reporting metrics, documenting data inconsistencies and working with engineering teams to resolve schema changes, missing data issues, and integration failures
• Automated routine reporting tasks using Python scripts and Power Automate workflows, reducing manual report generation time by approximately 30% and enabling stakeholders to receive daily performance updates via email distribution
• Created and maintained data dictionaries and technical documentation detailing table structures, column definitions, business logic, and calculation methodologies to ensure consistency across analytics deliverables and facilitate knowledge transfer
• Supported compliance and audit requirements by maintaining data lineage documentation and ensuring all customer data handling adheres to privacy regulations and company security policies
• Participated in sprint planning and retrospectives using Azure DevOps, collaborating with cross-functional teams to prioritize analytics requests and deliver insights within agreed timelines
• Conducted peer reviews of SQL code and dashboard designs to maintain quality standards and share best practices across the analytics team

• • Supported data analysis projects for retail and inventory management clients by writing SQL queries to extract sales and inventory data from relational databases
  • Assisted in developing Tableau dashboards displaying weekly sales performance, inventory turnover rates, and supply chain metrics for client stakeholders
  • Cleaned and standardized datasets using Python and Pandas, addressing missing values, duplicate records, and format inconsistencies
  • Created Excel-based reports with pivot tables and charts to summarize business metrics for non-technical stakeholders
  • Participated in daily standup meetings and used JIRA to track assigned tasks and project progress in an Agile development environment
  • Documented data transformation logic and SQL query specifications for knowledge transfer and future reference
  • Collaborated with senior analysts to understand business requirements and translate them into data specifications

• • Performed data entry and record updates in company databases using SQL and Excel spreadsheets
  • Assisted with basic data validation by comparing source documents against database records and flagging discrepancies
  • Learned fundamental SQL commands (SELECT, WHERE, JOIN, GROUP BY) to retrieve information for team reports
  • Created simple charts and summary tables in Excel to present findings during team meetings
  • Supported quality assurance testing by logging software bugs and documenting test cases in tracking systems
  • Attended training sessions on database concepts, software development lifecycle, and company tools
  • Shadowed senior team members during client calls and technical discussions to learn business analysis processes