Chamitha Wanaguru, Data Warehouse Developer in Colombo, Sri Lanka
Chamitha Wanaguru

Data Warehouse Developer in Colombo, Sri Lanka

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.
Chamitha is now available for hire

Portfolio

Experience

Location

Colombo, Sri Lanka

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.

Employment

  • 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, SSRS, 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

Experience

  • 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.

  • Three Principles of Data Warehouse Development (Publication)
    Data warehouses aren’t exactly a new concept, but industry demand for data science services, coupled with the rise of AI and machine learning, is making them more relevant than ever. In this post, Toptal Data Warehouse Developer Chamitha Wanaguru outlines three basic principles you need to keep in mind when developing a new data warehouse.

Skills

  • 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, SSRS, Jira
  • Frameworks

    Spark
  • Platforms

    Azure, Databricks, Windows, Oracle, Linux

Education

  • Master of Science Degree in Financial Systems Engineering
    2010 - 2011
    University College London - UK
  • Bachelor of Engineering Degree in Computer Science
    2006 - 2010
    University of York - UK

Certifications

  • Azure Data Fundamentals
    MARCH 2021 - PRESENT
    Microsoft
  • Azure Fundamentals
    MARCH 2021 - PRESENT
    Microsoft

To view more profiles

Join Toptal
Share it with others