Lochanie Bandara
Project Management
pepiliyawala, Sri Lanka
Skills
Data Engineering
About
LOCHANIE BANDARA's skills align with Database Specialists (Information and Communication Technology). LOCHANIE also has skills associated with System Developers and Analysts (Information and Communication Technology). LOCHANIE BANDARA has 9 years of work experience, with 2 years of management experience, including a low-level position.
View more
Work Experience
Freelance Data Engineer
AWS Solutions
August 2023 - Present
- Support to people who need assistance for their projects in the data engineering side. Professional development -Getting ready for professional exams: AWS Solutions Architect, DASCA Senior Big Data Engineer, Data Camp courses.
Data Engineer II
Circles.Life
September 2022 - August 2023
- Sri Lanka Automated Pipeline Management: Proven expertise in designing and managing automated data pipelines using Apache Airflow for seamless and efficient transfer of diverse data sources to data warehouses, ensuring optimal performance and reliability. • Lead the design and management of automated data pipelines using Apache Airflow, ensuring seamless and efficient data transfer from diverse sources to Snowflake and Amazon RDS data warehouses. • Implemented best practices for pipeline orchestration, monitoring, and optimization. Data Integration and Processing: Experience in database management, including designing, Implementing, and optimising relational databases. Proficient in SQL for querying and managing data within databases. • Spearheaded the integration of Telco industry data from sources such as Oracle, MongoDB, MySQL, and API endpoints, employing both batch and real-time ingestion methods. • Applied Python, Pyspark, and Hadoop for data processing, ensuring high-quality, standardised data. Cloud Expertise: Proficient in deploying and optimising data solutions on cloud platforms, including AWS and GCP, with the ability to adapt configurations based on country-specific requirements. Demonstrated experience in enhancing overall system performance through effective cloud resource utilisation. • Successfully deployed solutions on AWS and GCP, adapting to country-specific cloud configurations. • Collaborated with cross-functional teams to optimise cloud resources and enhance overall system performance.
Lead Data Engineer
Information and Communication Technology Agency
March 2021 - September 2022
- Sri Lanka Dashboard Development: • Designed and developed Grafana dashboards for monitoring ERL, Police E-Service, LGPS, HHIMS, and GOVSMS systems, providing real-time insights. • Ensured the visual representation of data met the highest standards for usability and accessibility. Open Data Initiatives: • Led a proof-of-concept project using CKAN Tool to promote the open sharing of Sri Lankan government data, contributing to transparency and accessibility. • Collaborated with stakeholders to understand data requirements and implement data-sharing best practices.
Data Engineer
KBSL Information Technologies Pvt. Ltd
February 2019 - March 2021
- Sri Lanka Predictive Analytics Projects: • Managed the Vault Cash Prediction project for Sampath Bank PLC, orchestrating data extraction (ETL) from Oracle DB to MySQL using Python (Pandas, Numpy) on Linux Centos. • Implemented Predictive Analytics Solutions for ATM projects at Nations Development Bank, involving ETL from E-Journals and MongoDB. Technological Proficiency: • Demonstrated expertise in Python, MySQL, Linux Centos, MongoDB, and object-oriented programming for efficient data extraction and transformation. • Collaborated with clients to understand business requirements and provided data-driven solutions. Machine Learning: Knowledgeable in machine learning concepts and techniques with hands-on experience in implementing machine learning models. Proficient in using machine learning libraries and frameworks such as TensorFlow and scikit-learn.
Research Assistant and Visiting Demonstrator
University of Peradeniya
February 2018 - February 2019
- Sri Lanka •Facilitated training programs for data management at the Post Graduate Institute of Science. •Contributed to the development of a Meta data web portal and GIS databases for Elephant Corridors. Skills: Statistical Data Analysis, Data Preparation, Data Cleaning, Data Visualization, Data Research Skills, Data Analysis, Data and Insight Presentation, Linux and Windows OS.
Senior Operations Analyst/Operations Analyst
Synergen Health (Pvt.) Ltd
November 2014 - February 2018
- Sri Lanka •Managed billing, posting, collection follow-ups, and operational processes for assigned clients using data analytical techniques. •Implemented improvements in process flows and collaborated with crossfunctional teams for enhanced client satisfaction via data analytical methods. Skills: Python Data Analysis, Data Preparation, Data Cleaning, Data Visualization, Data Research Skills, Data Analysis, Data and Insight Presentation, Project Management, Project Designing, Microsoft Excel *References Available Upon Request.
