Tushara Samarajyam

• Built the iBake Sales Performance Dashboard from scratch, incorporating outlet-level sales analytics, Days
Since Last Purchase, Gross vs Net Sales tracking, SKU performance, missed SKU identification, and stales
analysis; later migrated data source to a semantic model while retaining full ownership of the BI and reporting
layer.
• Built the MOB Sales Performance Dashboard from scratch in Power BI Service, designing the full data model
and covering 13-month trend analysis, area-wise and category-wise performance, and top and bottom SKU
analysis.
• Built a Philanthropy Impact Dashboard for the owners family, tracking committed vs disbursed grant funding,
lives impacted across 10 NGO partners, partner scorecards, pillar-wise spend, and planned disbursements
from 2023 to 2029.
• Develop advanced DAX measures for FMCG commercial reporting including FreePromoValue,
DiscountViewValue, VolDiscount, Good Returns, Bad Returns, and Days Since Last Purchase at B2B outlet
level.
• Apply advanced Power BI features across dashboards including small multiples, dynamic axis, field
parameters, ArcGIS custom visuals, bookmarks, drill-throughs, tooltips, and conditional formatting.
• Own and maintain an 18-report commercial analytics suite including Weekly Sales Report, iBake Weekly
Sales Report, Weekly Activity Report, Stales Analysis Report, and monthly sales meeting presentations.
• Built a Power Automate flow from scratch to automate stock data extraction from Excel via script, feeding a
SharePoint list that refreshes a live Power BI dashboard and eliminating manual data entry.
• Identified and resolved 11 critical data integrity issues in core commercial reporting, including broken
calculation logic, missing regional data, and incorrect net sales figures; rebuilt the underlying model to restore
accurate outputs.
• Own KPI governance standards across all reporting outputs, defining data definitions, calculation rules, and
quality controls to ensure a single source of truth across all commercial reporting.
• Coordinate as internal project manager for a live ERP migration workstream (JDE to Dynamics 365),
monitoring data accuracy and flagging integrity issues before they impact reporting outputs.

Big 4 delivery centre. Data governance, financial reconciliation, and performance reporting for global financial
services clients.
• Took sole ownership of a data governance and KPI reporting workstream at a Tier 1 global investment bank,
standardising data definitions, quality controls, and reporting standards across 5 regions and presenting the
framework to senior client leadership.
• Conducted financial data reconciliation and integrity checks across high-volume datasets for global financial
services clients, maintaining 98%+ accuracy and identifying issues before they reached management and
regulatory reporting.
• Led root cause investigation into financial data discrepancies for a global custodian client, identified the
source of integrity issues through structured analysis, and delivered resolution recommendations ahead of
regulatory reporting deadlines.
• Built and maintained performance trackers, reconciliation outputs, and executive reporting materials,
translating complex data into clear, actionable insights for senior stakeholders.
• Identified process inefficiencies in client reporting pipelines and contributed to a 30% reduction in reporting
overhead through evidence-based improvement recommendations.
• Provided guidance and knowledge transfer to junior analysts and interns, supporting team development and
ensuring quality of analytical outputs.

Management consulting startup. Analytics and performance reporting across client engagements.
• Delivered data analytics and commercial reporting across 10+ client engagements, contributing to a 20%
reduction in operational costs through structured, data-driven recommendations.
• Conducted market and competitive benchmarking contributing to a 20% improvement in client win rate across
the team.

Aster is amongst the leading healthcare providers in UAE with branches in India as well. I interned with them on a critical project as a performance management analyst.

Areas of Exposure during the internship included:
• Working on a project involving digitizing performance management system by updating the group data and supporting the team in any new upcoming projects
• Compiling data, updating Excel spreadsheets and producing reports.
• Worked closely with the performance management team to revamp their existing competency framework to make it more cohesive and less time consuming.

KPMG is one of the Big 4 Consultancy firms. I interned with them for a period of 2 months (June 2019 to August 2019), during which I worked on the following:

• As part of the financial risk management team, I summarized and highlighted discrepancies in client’s policies.
• Assisted in research and created reports on crucial financial tools used in the market such as LIBOR. The same was approved by the partner and uploaded to the intranet, thereby being available to employees of KPMG worldwide as a reference document.
• Assisted the Forensic department with digitizing bank statements and analyzing the data using my excel skills.
• Worked from the client site to find problematic trends with regards to the practices and processes of the client organization.
• Also performed some administrative duties like organizing and creating digital records of critical documents.

flydubai is a leading low-cost carrier belonging to the Emirates Group and I interned with them in their Corporate HR Department Dubai, UAE, under their REACH -Intern Engagement Programme from 22nd July 2018 to 30th August 2018.

The areas of exposure included:

• An understanding of the Process Flows of Recruitment
• Use of Microsoft PowerBI to analyze and report their compensation trends over the years.
• Drafting policy and procedures on substance abuse