- Python
Amila Gunawardana
Senior Software Engineer - Analytics Engineering
Colombo,Western
Summary
I’m currently working as a Senior Software Engineer - Analytics Engineering at Wiley Global Pvt. Ltd. I’m looking forward to work in an environment which provides an opportunity to enhance skills and apply them to grow parallel with the organization, and also expect to achieve career goals with dedication hard work. Seeking to use proven Business Intelligence and modeling skills to improve quality, cost and time metrics for upcoming and existing projects. To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.
Overview
5
5
years of professional experience
7
7
years of post-secondary education
7
7
Certifications
Work History
Senior Software Engineer Analytics Engineering
Wiley Global
Colombo, Western Province
08.2021 - Current
- Building Data Warehouses for financial data in research publications on snowflake database this has been impacted to sales teams directly.
- Writing ETLs and ELTs using Apache Airflow
- Creating Power BI repots for executive board for sales teams, Earlier practice was to analyze data manually for each month and historical data were not available
- Create data quality dashboards for better transparency of data
- Creating and maintaining data models inside Data warehouses
- Worked with customers to understand needs and provide excellent service.
- Increased customer satisfaction by resolving issues.
- Learned new skills and applied to daily tasks to improve efficiency and productivity.
- Managing and mentoring junior colleges
Senior Business Intelligence Engineer
London Stock Exchange Group
Colombo, Western
06.2021 - 08.2021
- Creating and managing Sprints
- Review junior code and perform code Freeze
- Design and Implement Data Warehouses using Microsoft BI Stack
- Create and Manage Power BI reports for Executive boards overlooking interdepartmental data
- Create and Monitor ETL systems using SSIS
Business Intelligence Engineer
London Stock Exchange Group
Colombo, Western
10.2019 - 06.2021
- Writing Data custom pipelines using python
- Automating data gathering from JIRA for dashboards for further analysis
- Create Dashboards using PowerBI for LEI/SEDOL team for monitor performance of the team
- Create Outlier Detection Report by using python integration in PowerBI
- Build a tool (Python Flask web application) for LEI for searching GLEIF Registration Authorities and other related entry searching
- Maintaining and building Data Warehouses using Microsoft BI Stack (SQL server, SSIS,SSAS) for Company Fundamentals and Securities Dividends data
- Gathering requirements from end users and implement data warehouse solutions
- Worked with UI path and figuring out the Processes that can be automated
- Identified issues, analyzed information and provided solutions to problems
Business Intelligence Engineer
Ayra Analytics Pvt (Ltd.) (now goes as Octopus BI)
Colombo, Western
08.2017 - 10.2019
- Developed DANN (Data Analytics Neural Network) For generating SQL queries from Any Dataset Given (Python)
- Creating a Sentiment Analysis system for analyzing teacher comments for students.
- Power BI Reporting
- Data Warehousing in On-prem MSSQL server environments
- Creating and managing AWS Cloud System resources (EC2, S3, Redshift)
- Azure VDI Creation and Maintenance
- Azure ML Studio and Azure SQL server
- Started a IoT Device project that is Capable of monitoring plant growth and watering in Australian K12 schools.
- Devoted special emphasis to punctuality and worked to maintain outstanding attendance record.
Education
Bachelor of Science - Electronics and IT
University of Colombo
Colombo 01.2014 - 12.2017
GED -
St Sebastian's College
Moratuwa 01.2010 - 12.2012
Skills
- Ability to communicate with stake holders to Engineers
Certification
- Microsoft Certified: Data Analyst Associate (https://bit.ly/3lBAwJo)
Affiliations
Former LEO member of university of Colombo and member of Moratuwa Centennial.
Accomplishments
- Got Meraki Award for best project in LSEG regarding a automation project for LEI team in year 2020.
- Got award for best team in the LSEG BSL Sri Lanka in year 2020
- Two times Youngest Speaker in SLDC (Sri Lankan Data Community)
- Got selected to final 24 of "kotiyak watina adahasak" reality program organized by Sirasa TV (MBC/ MTV Channels (Pvt) Ltd). (https://kva.mobitel.lk/index.php/teams/)
- Best team leader at LEO Leadership camp (ACCIO 17
Software
- Power BI
- DAX
- Airflow
- Core Java
- C#
- TSQL
- Snowflake
- MySQL
- SSIS
- Tabular
Interests
- Enthusiasm in searching new electronic devices and components for enhance the effectiveness day to day life activities
- Blogging and learning new technologies
- Robotics and AI Machine Learning using Python
- Troubleshooting computers and other electronic devices (mobile phones etc)
- Passionate about teaching
- Playing Rugby as a hobby
REFEREES
- Gogula Aryalingam,
Lead Architect – Business Intelligence | MVP, Data Platform,
Fortude Pvt Ltd, 146 Kynsey Road, Colombo 7,
Email : gogulaa@gmail.com,
Phone : 0773066440
- Dr. Hiran H E Jayaweera
Senior Lecturer Department of Physics,
University of Colombo, Colombo 03.
Email : hiran@phys.cmb.ac.lk,
Phone : 011 215 8351/0716029334
Timeline
Senior Software Engineer Analytics Engineering
Wiley Global
08.2021 - Current
Senior Business Intelligence Engineer
London Stock Exchange Group
06.2021 - 08.2021
- Microsoft Certified: Data Analyst Associate (https://bit.ly/3lBAwJo)
01-2021
Business Intelligence Engineer
London Stock Exchange Group
10.2019 - 06.2021
Business Intelligence Engineer
Ayra Analytics Pvt (Ltd.) (now goes as Octopus BI)
08.2017 - 10.2019
Bachelor of Science - Electronics and IT
University of Colombo
01.2014 - 12.2017
GED -
St Sebastian's College
01.2010 - 12.2012
Similar Profiles
HIMALI KULARATHNAHIMALI KULARATHNA
Senior Salesforce Developer at Wiley Global Technology (Pvt) LtdSenior Salesforce Developer at Wiley Global Technology (Pvt) Ltd
HIMALI KULARATHNAHIMALI KULARATHNA
Salesforce Developer at Wiley Global Technology (Pvt) LtdSalesforce Developer at Wiley Global Technology (Pvt) Ltd
Kelsey SanchezKelsey Sanchez
Elementary School Teacher (1st Grade) at Wiley Post ElementaryElementary School Teacher (1st Grade) at Wiley Post Elementary