Mahesh Madushanka

Resume created on DoYouBuzz

Experiences

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

Skills

Sr. Technical Lead | AWS Certified Solutions Architect - Associate