Your browser is outdated!

To ensure you have the best experience and security possible, update your browser. Update now

×

Mahesh Madushanka

Sr. Technical Lead | AWS Certified Solutions Architect - Associate

Data solution design
Big data
ETL & Data Lake
Data Warehouse
Analytics
Mahesh Madushanka
38 years old
Driving License
Professional Status
Employed
Open to opportunities
About Me
Sr. Technical Lead with 7+ years of experience in developing enterprise ETL, Data warehouse, and BI solutions and currently leading data teams in customer experience division in Sysco labs ( Sysco), USA.
Resume created on DoYouBuzz
  • Sysco Reporting Project ( Project Technical Lead)
    Lead both Sri Lankan and Austin engineering teams.
    Technology Stack ( Redshift, Aurora, S3, Talend ETL, SQS, and Lambda, Jboss Tied)
  • Sysco Reporting Project ( Onsite Technical Lead)
    Project Technical lead.
    Technical design and groom business stories.
    Provided technical input to the product team.
    Technology Stack ( Redshift, Aurora, S3, Data Pipeline, Talend ETL, SQS, and Lambda, Jboss Tied)
  • Sysco Permission Service project (Technical Lead)
    Authorization microservice for customer-facing application.
    Technology Stack ( Aurora, S3, Talend ETL, Java)
  • Sysco Reporting Project ( Technical Lead) Implemented a BI solution in a cost-effective manner to handle more than 6 billion transactions and provide ad-hoc reporting needs of the customers.
    Technology Stack. ( AWS Redshift, Aurora, S3, Data Pipeline, Talend ETL, SQS, Jboss Tied, and Lambda)
  • Lead BI/DW and data migration projects
  • SyscoLabs is a Part of Sysco (US Largest food distributor )
  • Leapset Real Time ETL Framework ( Project Technical Lead)
    There was a requirement to implement Real Time Analytics Solution for the company POS system. During this project, we had to come up with our own framework to handle real-time data (There are no such open source products on the market).
    Technology Stack( MySql, Tungsten, Kafka, Apache Storm, Hadoop)
  • List data Migration. ( Project Technical Lead)
    Involved in reverse engineering existing DB2 Database (Legacy Database) and redesigned it in a way to support multiple microservices using PostgreSQL.
  • On-Site Experience - 2017 July to September
    Sysco Corporation(www.sysco.com) - Houston, United States
    Mysysco Reporting Project
  • Leapset Graph Database Solution (R&D/DB engineer)
    Leapset Core Product is a POS system and it stored data in a central cloud server (MySQL). This project mainly focused on providing an advanced analytics solution using Graph Database. It extracted data from cloud servers, stored them in a graph DB and performed advanced analytics.
  • Leapset Data Lake (R&D/DB engineer)
    Leapset had multiple products which store data in cloud databases. The main objective of this project was to create a central data lake where anyone can access and analyze data. Implemented this product using Tungsten Replicator and Hortenworks data platform.
  • Leapset Insights (ETL and DB engineer )
    Leapset Insight is a business intelligence solution for the restaurant owners. It processed transactional log files and generated a valuable set of reports out of it.
  • Leapset Intel BI Project (ETL and DB engineer )
    Leapset Intel is a business intelligence solution for the executives in SYSCO. Extracted data from POS system and generates valuable reports Like Sales Summary, Top Selling Products and so on.
  • Bank of Ceylon, Sri Lanka BI Project
    Worked as an ETL/DWBI engineer on this Project.
    Technologies/tools Used: MS SQL,SSIS 2008,SSRS 2008, SSAS 2008, Share Point