Chamitha Wanaguru, Developer in Colombo, Sri Lanka
Chamitha is available for hire
Hire Chamitha

Chamitha Wanaguru

Verified Expert  in Engineering

Data Warehouse Developer

Location
Colombo, Sri Lanka
Toptal Member Since
June 18, 2020

Chamitha is an accomplished data engineer specializing in the design and development of sustainable, value-focused data systems. With a career that started at renowned international investment banks, working across technologies, regions, and organizational hierarchies, Chamitha has the ability to provide leadership to establish strategic program governance for efficacy and technical competence.

Portfolio

Octave (John Keells Holdings Centre of Excellence for Data and Advanced Analy...
Azure DevOps, Databricks, Azure Data Factory, Spark, Azure, SQL, Agile Sprints
DataScribe Solutions, USA
Microsoft SQL Server, GRAPH, QuickBooks Online, Python, Azure...
Morgan Stanley
SQL, Jira, Tableau, Python, IBM Db2, Database Development, Agile Sprints

Experience

Availability

Part-time

Preferred Environment

Azure, Tableau, SSAS, Microsoft SQL Server, Oracle, Databricks, SQL Server Integration Services (SSIS)

The most amazing...

...project I've developed was to build an MS SSAS cube from scratch to help save a business $14 million by providing color on their profit and loss breakdown.

Work Experience

Analytics Delivery Lead

2020 - PRESENT
Octave (John Keells Holdings Centre of Excellence for Data and Advanced Analytics)
  • Oversaw overall project delivery across two of JKH’s businesses, Elephant House Beverages and Union Assurance, including sustainable value creation, cost management, and client engagement.
  • Managed teams of data engineers, data scientists, and platform engineers, as well as external consultants from a top global management consultancy firm.
  • Provided thought leadership to data collection and digitization processes, solution designs, and pilot rollouts, including the Group-wide data governance initiative and the design of a data anonymization service for constituent businesses.
  • Formulated mechanisms to ensure governed project delivery and technology introduction processes.
Technologies: Azure DevOps, Databricks, Azure Data Factory, Spark, Azure, SQL, Agile Sprints

Data Engineer

2019 - 2020
DataScribe Solutions, USA
  • Designed and developed a new data platform to cater to DataScribe’s business requirements as a back-office automation service company for clients based in Kansas City.
  • Based the data platform on MS Azure with a custom-designed Python framework as the backbone, and pipelines built to various online storage systems including Google Drive, OneDrive, and Dropbox as well as their main accounting system Quickbooks Online.
  • Used VBA-enriched Excel dashboards as the main reporting tool for the system to easily fit in with existing processes at DataScribe.
Technologies: Microsoft SQL Server, GRAPH, QuickBooks Online, Python, Azure, Database Development, SQL, SQL Server 2014, Agile Sprints

Vice President

2016 - 2018
Morgan Stanley
  • Served as a manager accountable for a data warehouse for the Stock Loan division of BRM. The data warehouse is used for data analytics and trend reporting across the division, delivering outputs used by traders, analysts, and finance groups.
  • Managed a team of five with direct line management of two members based in New York.
  • Project-managed the migration of a 3TB data warehouse from a legacy platform consisting of Sybase and Perl to a greenfield warehouse of IBM DB2 Blu and Python.
  • Liaised with the stock loan trading and business quantitative analysts.
  • Designed a renovated data loading framework and the overall performance improvement of the DB2 plant.
  • Designed and implemented Tableau dashboards to be used by global trading desks.
  • Implemented best practices with regards to SQL development and Agile working.
  • Designed and developed key functional projects such as a global rate opportunities reporting platform.
Technologies: SQL, Jira, Tableau, Python, IBM Db2, Database Development, Agile Sprints

Business Intelligence Developer

2011 - 2016
UBS
  • Served as a senior BI developer and project manager of two data warehouse systems within the global financing services business.
  • Headed key ETL developments including dimensional modeling.
  • Developed reports and dashboards using popular BI tools.
  • Oversaw technical design and instigation of new technologies.
  • Created data analytics for trading desks and requirements gathering, including business analysis, for new projects.
  • Managed an off-shore team based in Singapore, and oversaw teams based in London and Pune.
  • Involved in the initiation of a big data project with exposure to technologies such as Hive, Impala, and Spark, as well as the RFI/RFP process to select an external vendor.
  • Provided the opportunity for a six-month secondment to the central web development team - additional tools learned: HTML5, JavaScript, CSS, and the Adobe CQ5 platform.
  • Used a variety of BI tools covering the complete technology stack from front to back. Led several key greenfield projects to report on profit and loss and client color to the trading and business management teams.
Technologies: Adobe Communique 5 (Adobe CQ5), CSS, JavaScript, HTML5, Oracle, SQL, Tableau, MDX, SAP BusinessObjects Data Service (BODS), MicroStrategy, SSAS, SQL Server Integration Services (SSIS), Database Development, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Spark, SQL Server 2014, Microsoft SQL Server, Multidimensional Expressions (MDX), SAP BusinessObjects (BO), Agile Sprints, SSAS Tabular

Database Load Framework

I developed a data warehouse load framework to address key concerns of any data warehouse with regards to the loading of data. This framework looks to address issues such as data lineage, data quality, portability to different platforms, and rerun-ability of data loads. The framework was designed to be implemented using Python in a modularized manner, in keeping with concepts of reusability, testability, and maintenance of code.

Profit and Loss Diagnostics

I designed and developed, from scratch, a database to report on profit and loss of a business. However, one of the principles of the design was to bring in granular data and provide the mechanism to expose that to the end-user. As such, I provided an MS SSAS cube to the end users to access the data through dynamic Excel dashboards, whereby the end users were able to drill-down into their profit and loss numbers to get color that was previously unavailable to them. The back-end used for this project was Oracle with MS SSIS forming the ETL layer.

Systems Testing for an Analytics Project

I developed a systems testing environment for an analytics project on top of TeamCity and MSBuild. The tool would destroy and create a database, run ETL scripts, deploy an MS SSAS cube, and run test cases off of the cube. Through this framework, we were able to test the full stack from table deployment to end user output.

Languages

SQL, Python, MDX, HTML5, JavaScript, CSS, Java

Paradigms

Database Development, Scrum, Azure DevOps

Storage

SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server 2014, Microsoft SQL Server, Azure SQL Databases, Oracle RDBMS, IBM Db2, SSAS Tabular

Other

Multidimensional Expressions (MDX), SAP BusinessObjects (BO), Azure Data Factory, SAP BusinessObjects Data Service (BODS), Adobe Communique 5 (Adobe CQ5), QuickBooks Online, GRAPH, Azure Data Lake, Agile Sprints, MicroStrategy

Tools

Tableau, SSAS, Jira

Frameworks

Spark

Platforms

Azure, Databricks, Windows, Oracle, Linux

2010 - 2011

Master of Science Degree in Financial Systems Engineering

University College London - UK

2006 - 2010

Bachelor of Engineering Degree in Computer Science

University of York - UK

MARCH 2021 - PRESENT

Azure Data Fundamentals

Microsoft

MARCH 2021 - PRESENT

Azure Fundamentals

Microsoft

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring