Prastut Sapkota

• Involved in requirements gathering and the concept design phase of the projects.
• Developed time series model to forecast merchants and users acquired, interbank transactions and QR transactions.
• Performed Exploratory Data Analysis and identify data transformation and data quality needs for targeted applications.
• Performed analysis and build engine for cross selling various target segments, Customer Segmentation Module and Switch Analytics.
• Collection of data through campaigns using cross selling rule engine and analyzing the output to create label data for predictive analytics. These data were then feed into ML models to create prospects for product cross selling through campaigns.

• Designed and architect Data collection module using survey CTO and performed ETL using python for International Vaccine Institute (IVI).
• Designed and architect Data collection module of Local Level Government Survey using Kobo Toolbox for International Organization of Migration (IOM).
• Train and support staff in tasks related to data collection, surveys, assessments, and overall data management activities.
• Identify gaps on data and information relevant to the programme implementation and contribute to the preparation of project proposals aiming to address such needs

• Developed time series model to forecast E-SEWA airlines ticket sales and integrating it with the in-house business intelligence tool.
• Created Change Data Capture (CDC) and complex Extract Transform Load (ETL) scripts for filling various business requirements using Pentaho.
• Created Data Provisioning layer and scripts to provision data to downstream systems.
• Scripting using python language algorithms such as forecasting, classification, clustering, regression, decision tree and correlation.
• Created data warehouse and developed automation application for Extenso Business Intelligence (XBI) which is a web based BI application.
• Project and data governance including standardization of metadata, processes, and code reviews.

Following are the two papers that I have published in my academic period:

• Sentiment Analysis on Products Using social media (Jour of Adv Research in Dynamical & Control Systems, Vol. 10, 02-Special Issue, 2018) - https://www.jardcs.org/backissues/abstract.php?archiveid=2905
• Comparison of Classification Algorithms on Twitter Data Using Sentiment Analysis (Volume 9, No.5, September - October 2020, International Journal of Advanced Trends in Computer Science and Engineering) - https://doi.org/10.30534/ijatcse/2020/179952020