Data Engineer
2019 - 2020DataScribe 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: MS Azure, Python, QuickBooks Online, MS Graph API, MS SQL ServerVice President
2016 - 2018Morgan Stanley, UK- Served as a senior manager accountable for a data warehouse for the Stock Loan division of Business Resource Management. The data warehouse is used for data analytics and trend reporting across the division, delivering outputs used by traders, quantitative 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: IBM DB2, Python, Tableau, Jira, SQLBusiness Intelligence Developer
2011 - 2016UBS, UK- Served as a senior BI developer and project manager of two data warehouse systems within the global financing services business. Competent in 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.
- 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.
Technologies: SSIS, SSAS, SSRS, MicroStrategy, SAP Business Objects, MDX, Tableau, SQL, Oracle, HTML5, JavaScript, CSS, Adobe CQ5
Data Warehouse Developer in Colombo, Sri Lanka
Member since July 18, 2018
Chamitha is an IT professional specializing in data warehouse system architecture, data engineering (modeling, analytics, and visualization), business analysis, and project management. His skills have been developed and demonstrated by strong academic performance and working within the IT departments of top global investment banks.
Chamitha is now available for hire
Portfolio
- DataScribe Solutions, USAMS Azure, Python, QuickBooks Online, MS Graph API, MS SQL Server
- Morgan Stanley, UKIBM DB2, Python, Tableau, Jira, SQL
- UBS, UKSSIS, SSAS, SSRS, MicroStrategy, SAP Business Objects, MDX, Tableau, SQL...
Experience
- SQL 8 years
- SQL Server Analysis Services (SSAS) 7 years
- Multidimensional Expressions (MDX) 7 years
- SQL Server Integration Services (SSIS) 6 years
- SQL Server Reporting Services (SSRS) 6 years
- SAP BusinessObjects (BO) 5 years
- Tableau 4 years
- Python 3 years
Availability
Full-time
Preferred Environment
Windows, Oracle, SQL Server, SSAS, Tableau
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
Experience
- Database Load Framework (Other amazing things)
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 (Development)
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 (Other amazing things)
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, JavaParadigms
Database Development, ScrumStorage
SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server 2014, Oracle DBMS, IBM DB2, SSAS TabularOther
Multidimensional Expressions (MDX), SAP BusinessObjects (BO), Azure Data Factory, Agile Sprints, MicroStrategyTools
Tableau, JiraPlatforms
Azure, Databricks, Linux
Education
- Master of Science degree in Financial Systems Engineering2010 - 2011University College London - UK
- Bachelor of Engineering degree in Computer Science2006 - 2010University of York - UK
