Data Analysis, Power Bi, SQL, Advance Excel

CHANAKA

ABEYKOON

*/**, ******************,

Ganemulla

077*-******

*************@*****.***

PROFILE

Experience in Data analyzing and visualizing of 4+ years in the government sector.

Background in applying Statistical Analysis

concepts. Focused on deriving insights that drive

decision-making.

Well-versed in conducting advanced data cleaning,

modeling, and transformation using SQL.

Good understanding of the business environment,

excellent communication skills and ability to work proactively in a fast-paced environment

SKILLS

Creativity

Leadership

Problem solving

Multitasking

Communication

Teamwork

Time management

Responsibility

0 0.5 1

WORK EXPERIENCES

Divisional Officer (Data Analysis) – Information Management Unit of the Department of Agrarian Development (DAD). (2019 Jan-Present)

• Generates National-level Excel reports on time using Advanced Data Analytics in Excel as per the ministry’s request.

• Experiences working with PHP my admin, MySQL workbench, and Complex queries to analyze and generate different kinds of reports for the national level as per the Ministry’s requirements.

• Experience handling missing values, error checking, manipulation, and Pre- processing huge bundles of data using Excel Power Query. (Around 1.6 million).

• Provide innovative ideas using different tech platforms (“GeoGoviya” Mobile App – Farmer/Farm Information Management System).

• Involving and collaborating with various projects conducted by various institutes in the world such as World Bank, UNDP, UN, ADB, International Water Management Institute (IWMI), and FAO.

• Involved to implement a web-based System that accesses more than 1000 users daily. (agrarian.lk).

• Handled and was involved in the overall process of the project of giving cash subsidy to the 1.2 million farmers by ADB in 2021,2022, and 2023 using SQL. Production & Planning Executive – Link Natural Products Pvt Ltd (2016 Sep-2018 Dec)

• Working knowledge of the Company’s MRPS (Manufacturing Resource Planning System).

• Generation of MS Excel reports required by Planning and Evaluation section.

• Maintain zero Stock outs of production by aligning the production with the production plan.

• Reporting and analyzing production KPIs of each production section in the factory.

• Reporting and analyzing performance evaluation method called “Performance Wheel”.

PROJECTS/SKILLS

• SQL for Data Analysis Google Certificate Completed.

• Data Cleansing and Pre-Processing Project

https://github.com/ChanakaAbeykoon/Data-Cleansing-and-Pre-processing

• 120 Years of Olympic History Data Analysis using MySQL Workbench https://github.com/ChanakaAbeykoon/Olympic-History-Data-Analysis

• Solved Questions from different sources using SQL. https://github.com/ChanakaAbeykoon/Practice-Questions

• Expert in Advance Excel (Pivots, Lookup Procedures, Complex formulas) and Google Workspace.

• Sound knowledge of POWER BI data visualizations and DAX functions.

• Knowledge of Agile Methodology.

EDUCATION

• University of Colombo School of Computing, Sri Lanka (2021–Present) Master of Business Analytics

Main subjects: Statistics, Machine Learning, Data visualization, Modeling & Simulation of Data, Text Analytics (NLP), Predictive Analytics, Data Mining Languages: Python, SQL

Software: SPSS, WEKA, NetLogo

• University of Kelaniya, Sri Lanka (2013-2016)

Bachelor of Science in Physical Sciences

Main Subjects: Statistics, Computer Science, Pure Mathematics

• Power BI Master Class – Beginners to Advance in Udemy Online learning platform

• Isipathana College, Colombo 05, Sri Lanka (2010) GCE Advanced level, Physical science stream

OTHER QUALIFICATIONS

• Completed CIMA foundation level (2012-2013)

SPORTS

• University color holder for both wrestling & hockey for 2014 and 2015.

• Played for 2nd fifteen-team of the school rugby team in 2005-2006. EXTRA-CURRICULAR ACTIVITIES

University of Kelaniya, Sri Lanka

• A member of the Math Society University of Kelaniya and a committee member of the Club 2014 organized a project to teach math to students who lived in rural areas in Anuradhapura.

• An officer of Career Fair 2013 organized by the Career Guidance Unit University of Kelaniya.

• An Organizing Committee member of Career Fair 2015 Organized by the Career Guidance Unit University of Kelaniya and Responsible person for Officer Handling and Magazine by career fair 2015.

• As a Member of the Math Society, we organized a photo Exhibition Called Maths in Nature.

I hereby certify that the above information is correct and complete to the best of my knowledge & belief.

Chanaka Abeykoon

2023/08/18

PERSONAL INFORMATION

Date of Birth

08th November 1991

Age

31 years

Gender

Male

Nationality

Sri Lankan

Marital status

Married

REFEREES

S R Vijayakumar – Commissioner

MSc in Organizational Management

Dept of Agrarian Development

Colombo 07

Email: *********@*****.***

Phone: +947********

Mr. R.A.B Abeygunawardana,

Head of the Department,

Department of Statistics,

University of Colombo.

Email: ********@****.***.**.**

Phone: 077*******

Contact this candidate