Dilan Madusanka Email & Phone Number

Sri Lanka

Deputed at Sysco Labs Technologies (Pvt) Ltd.

Colombo, Western Province, Sri Lanka

--Enabling SQL Change Automation with source control--Snowflake data ingestion--Developed and optimized the performance tuning in stored procedure and queries

--Handle big data pipelines and warehouses with ETL and ELTL processes and analysis data.--Managing CI/CD Pipelines in Azure.--Creating pipelines for new sources.--Creating new releases of pipelines.--Snowflake data ingestion.--Developing reports to validate data.--Developing modules for maintaining/increasing the quality of data (Balance controllers , Snowflake cost optimization) --Configuring alerts to data and pipeline-related components.--Monitor pipeline-related alerts.--Working on on-call sprint.--As a developer giving pipeline-related patching activities and zero/full downtime activities.--Building and maintaining the ETL process.--Developing DBT projects for data transformation--Used DB2, MySQL, SQL for RDBMS databases

Offshore IT contractor from Colombo, Sri Lanka

Colombo

Project : VERACODE INCEnvironment : Java 8, J2EE, Hibernate, Spring boot, AWS, Postgres, MySQL, Maven, Gradle, Stash, Gitlab, Jira, Git, JenkinsResponsibilities :· Engaged in end-to-end application development, debugging and integration using Java EE, Spring boot, angular JS, JSP.· Worked on bugs and defects assigned by QA engineers. Collaboratively worked with the team consisting of Software engineers, Technical Leads and QA engineers with the objective of ensuring the quality of teams’ productivity.· Worked with geographically distributed teams while myself attached to Colombo - Sri Lanka offshore team and client teams from USA & Singapore.· Used GIT version control, Maven & Gradle build tool, AWS· Carried out peer-to-peer code reviews.· Conducted Knowledge Transfer sessions for new team members.· Practiced Scrum agile framework. Participated in daily stand-up meetings, story grooming, story point estimations, retrospective meetings, creating and assigning stories in JIRA.· Recorded demonstration videos for clients based on work completed in sprints.· Rendered support for writing unit tests and automation scripts Award for “Best Project Team” as my team at Veracode Awards - 2019Project : INFOMC INCEnvironment : SQL Server, SSIS, T-SQL, Microsoft Azure, Microsoft Power BI, JIRAResponsibilities :· Involved to ETL (Extract-Transform-Load) processes· Enhanced performance, speed and robustness of the MSSQL databases· Engaged in end-to-end stored procedure development and testing· Optimized and performance tuning in stored procedure and queries that are already using· Developed optimized scripts and visualizations that are fast and easy to comprehend· Created documentations and presentations.· Using Power BI and JIRA dashboards, produced analytics dashboards and visualizations for clients and users.· Conducted Knowledge Transfer sessions for new team members.

Colombo 8

Nittambuwa

Bachelor Of Science (Special), Computer And Information Sciences, General

Bachelor of Science (Special) in Information Systems

Advance Business Solution Developer Course (J2Ee), Computer Software Engineering

Education record

Activities and Societies: Science Society Chess Club Astronomical Society Scouting Association Buddhist Association