Udeshika Sandamali

Experience

• 

  Sri lankan Airlines

  Feb 2018 - Aug 2018

  On the job trainee

  * Fare Pricing Analysis: Conducted comprehensive fare pricing analysis.* Fare Evaluation: Evaluated fares across various categories, including long term, short term, group, and special fares.* Interline and Code-Share Pricing: Managed interline and code-share pricing strategies.* Market Analysis Reporting: Generated reports for market analysis.* Tools Utilized: Proficiently used tools such as AMEDEUS, DDS, FareManager, ESMASH, and PowerBI.

• 

  SAKS

  Apr 2019 - Oct 2019

  Associate Research & Analytics

  * Financial and Consumer Market Research (US): Conducted in-depth research in the areas of compensation and shares within the financial and consumer markets.* Data Sources: Utilized diverse sources, including SEC filings (Form 10-K, Form 10-Q, Form 8-K), proxy statements, Bloombergwebsite, Yahoo Finance, and various financial documents.

• 

  Octopus BI - Sri Lanka

  Nov 2019 - Dec 2021

  Data Analyst

  * Provided strategic data insights for learning excellence* Collaborated with schools in Australia and New Zealand, translating their requirements into data-driven applications and visual solutions, Managed the entire process, from gathering requirements to project delivery.* Sourced data from primary and secondary sources of learning and student management systems, operations, finance and reporting systems by proficiently designing and executing database queries.* Managed data storing, cleansing, transforming, analyzing and modelling.* Designed, constructed, and deployed Business Intelligence (BI) solutions - Developed and maintained reports, interactive dashboards, and visualizations.* Identified and defined opportunities for process enhancements.* Created and updated technical documentation and customized user guides.* Conducted training sessions for junior staff as needed. Show less

• 

  KALERIS

  Dec 2021 - Feb 2023

  Data Engineer

  * Provided cloud based supply chain execution and visibility technology solutions for USA clients.Gathering transportation related data from various sources and systems and Integrating diverse data sets for comprehensive analysis.* Identify data related issues, troubleshoot discrepancies, and develop timely and effective solutions to enhance data and reporting quality.* Designing and maintaining databases optimized for storing and retrieving transportation data efficiently.* Creating and managing data pipelines that automate the flow of data from various sources to the analytics platform.* Collaborated closely with stakeholders to gather requirements, and collaborate with cross-functional teams to understand business requirements and translate them into data-driven solutions.* Implemented Power BI as the enterprise's primary data visualization and advanced analytics tool, develop and maintain reports, dashboards, and visualizations.* Data Modeling with Power BI for creating relationships between different data tables, enabling the creation of complex data models for in-depth analysis.* Performed complex calculations, descriptive statistics, statistical analysis, Power Query, M Query and DAX (Data Analysis Expressions)queries, scheduled reports with Power BI report builder.Conducted training sessions for junior staff as needed.* Achievements: Recipient of the "Best Performer Award" for the fourth quarter of 2022, Won the second place in Hackathon - 2022 Show less

• 

  Freelance

  Jan 2022 - Feb 2024

  Freelance Consultant

  * Conduct thorough data analysis and employ data visualization techniques.* Develop advanced statistical and machine learning models.* Data preprocessing and model building - with R and advanced Excel* Produce reports using RMarkdown & interactive applications with R-Shiny.* Provide tutoring and guidance on statistical theory.

• 

  Stellantis

  Feb 2024 - now

  Database Administrator

  * Communicate and follow-up with Stellantis dealers across the region and service providers.* Ensure timely receipt of data from different sources.* Automate the data flow with Stellantis dealers.* Enhance the data quality received from Stellantis dealers.* Enhance CX systems functionality.* Update PowerBI reports.* PR/LPO process in SAP.* Department preparation/communication handling.* Gathering quotations from external service providers.* Support current team members with reporting/admin tasks. Show less