Jayanta is available for hire

Jayanta Sarker Shuva

Verified Expert in Engineering

Data Analyst and Developer

Location

Dhaka, Dhaka Division, Bangladesh

Toptal Member Since

May 25, 2021

Jayanta is a seasoned BI expert and data storyteller with practical experience in large-scale database handling and visualization. He's experienced in getting the most out of Tableau, Power BI, SAP Web Intelligence (SAP Business Objects), Oracle PL/SQL, Python, SQL, and Microsoft Office. Jayanta's specialty is transforming pools of disorganized data into a useful format and creating business insights with the help of data visualizations.

Oracle Tableau Microsoft Power BI Machine Learning Oracle PL/SQL Python 3 Business Intelligence (BI)Data Visualization SQL Hadoop Database Design PostgreSQL Databases ETL Data Engineering

Portfolio

Robi Axiata Limited

Tableau, Oracle PL/SQL, Microsoft Power BI, SAP BusinessObjects (BO), Python 3...

Robi Axiata Limited

Business Intelligence (BI), Oracle, Tableau, Microsoft Power BI...

Kantar

Business Intelligence (BI), Tableau, Python 3, Oracle PL/SQL, Microsoft Excel...

Experience

Microsoft Power BI - 6 years Data Visualization - 6 years Tableau - 6 years Oracle PL/SQL - 6 years Business Intelligence (BI) - 6 years Python 3 - 6 years SAP BusinessObjects (BO) - 3 years Machine Learning - 2 years

Availability

Part-time

Preferred Environment

Anaconda, Tableau, Oracle, Microsoft Power BI, Google Data Studio

The most amazing...

...project I've done was creating a digital business portfolio performance monitoring dashboard for a telecom giant in Bangladesh.

Work Experience

Manager of AI and Predictive Analytics

2020 - PRESENT

Robi Axiata Limited

Built an end-to-end—ETL data cleaning model and dashboard development process to improve the customer network experience by increasing network availability during adverse weather using Python, Pandas, Matplotlib, Scikit-learn, Oracle, and SAP BO.
Developed a Telegram chatbot for getting user input based on the replies of different business KPIs; it was built with Python, Pandas, Matplotlib, Oracle, and Telegram chatting app.
Segmented (i.e., clustering) different types of the customer base of MFS rechargers to find out the characteristics of the MFS recharger base; used Python, Pandas, Matplotlib, Scikit-learn, and Oracle.
Launched and introduced Tableau and the Power BI platform reporting to Robi for management committee business updates and Salesforce updates.
Implemented probable MFS recharger customer base predictions using Python, Pandas, Matplotlib, Scikit-learn, and Oracle.
Predicted low-quality activation using Python, Pandas, Matplotlib, Scikit-learn, and Oracle.
Created a sales performance dashboard including RLS (row-level security) to ensure data governance; used Power BI, Oracle, Python, and Pandas.

Technologies: Tableau, Oracle PL/SQL, Microsoft Power BI, SAP BusinessObjects (BO), Python 3, Business Intelligence (BI), Machine Learning, Google Data Studio, Microsoft Excel, BI Reports, DAX, Power Query, R, Robotic Process Automation (RPA)

Specialist of AI Innovation and Planning

2018 - 2020

Robi Axiata Limited

Developed a customized Tableau and Power BI dashboard for business stakeholders.
Checked the accuracy and developed new models iteratively involving advanced statistical methods and deep learning for solving specific business problems.
Consulted with stakeholders to understand the business problems and fix analytic context.
Generated a subscriber base for offering promotions in combination with stakeholders. Provided criteria and predictive model output and analyzed the effectiveness of promotional activities.
Developed and managed the tools for automated reporting and mobile updates.

Technologies: Business Intelligence (BI), Oracle, Tableau, Microsoft Power BI, Microsoft Excel, BI Reports, DAX, Power Query, R, Robotic Process Automation (RPA)

Senior Executive of Analytics

2017 - 2018

Kantar

Worked on a project called Best Brand Bangladesh which was conducted by Millward Brown and a sample size of 4,000+. It was a brand tracking study that covered all 34 categories of brands including all FMCG and non-FMCG categories.
Built a dashboard with full routine settings, data uploads, and a data chart website for Robi Axiata. It was built with the Google Chart API, HTML, CSS, JavaScript, PHP, Bootstrap, jQuery, Ajax, MySQL, MS Excel, and SMTP protocol.
Developed a dashboard with data uploads and a data chart viewing website for Coca-Cola. It was built with Google Chart API, HTML, CSS, JavaScript, PHP, Bootstrap, jQuery, Ajax, MySQL, and MS Excel.
Contributed to the project called the Micro-finance Study of Bangladesh which was conducted by the Melinda Gates Foundation with a sample size of over 4,000.

Technologies: Business Intelligence (BI), Tableau, Python 3, Oracle PL/SQL, Microsoft Excel, BI Reports, R, Robotic Process Automation (RPA)

Analytics Executive

2015 - 2017

Kantar

Interpreted data, analyzed the results using statistical techniques, and provided ongoing reports.
Developed different types of web-based apps for MIS and other data visualization dashboards as per the client's requirements.
Implemented different types of algorithms to identify, analyze, and interpret trends or patterns in complex data sets, e.g., cross tabs, regression, factor analysis, CSAT performance, Jaccard analysis, BIP, SOE (share of endorsement), and SWOT analysis.
Analyzed data and generated reports using SPSS, dimensions, and more for data analysis software.
Created different kinds of automation—from Excel data to PPT presentation slides—using Excel VBA.

Technologies: Business Intelligence (BI), Market Research & Analysis, Oracle, Tableau, Microsoft Excel, BI Reports, R, Robotic Process Automation (RPA)

Experience

Superstore Sales Report

https://rb.gy/y4ipg

The entire sales performance, including revenue and profit reports. Those reports can be segmented by category and region and find insights on daily/monthly/quarterly/yearly sales. Each chart works as a filter. By clicking, you can find segment-wise performance

Sales Performance

https://public.tableau.com/app/profile/jayanta.sarker3104/viz/EventTicketing/SalesPerformance

This is a sales performance dashboard for a ticketing platform. I built this by collecting data from three different sources, developing an ETL pipeline, and then making a visualization in Tableau. For the ETL development, I used Python.

120 Years of Olympic History

https://public.tableau.com/profile/jayanta.sarker3104#!/vizhome/120yearsofOlympichistory/120YearsOfOlympicsHistory

This is an animated visual demonstration of all Olympic games in Tableau. It has all of the host cities along with a map of all the winning countries. I also added a racing bar chart for the country rankings based on the total number of medals.

Google Search Trend Analysis for Bangladeshi Telcos

https://public.tableau.com/profile/jayanta.sarker3104#!/vizhome/GoogleSearchTrends_15955128759670/GoogleTrendAnalysis

Bangladesh has three telco giants, and I have collected Google search behavioral data regarding these three operators and created this comparison dashboard. Click on the brand icons to see a brand-wise view.

Supply Chain Performance Dashboard

A telecom company needed a supply chain logistics and auction monthly dashboard for MoM performance monitoring. It needed to track PO, LC, and shipments on a regular basis so they used this dashboard to track all of their KPIs.

Excel-to-PowerPoint Automation

I automated a 60-page PowerPoint file (PPT) process. The process automatically generates a PPT file using the charts and data from over ten different Excel workbooks. Starting with the Excel file, we build a fixed format, and then the data is refreshed weekly using an SQL database. Then after running the VBA script, the PTT file is generated.

Skills

Languages

Python 3, SQL, Python, Excel VBA, Visual Basic for Applications (VBA), R, Java

Tools

Tableau, Microsoft Power BI, Microsoft Excel, Power Query, Excel 2016, Microsoft Access, Google Sheets

Paradigms

Business Intelligence (BI), Database Design, ETL, Data Science

Platforms

Oracle

Storage

Oracle PL/SQL, Databases, DB, Microsoft SQL Server, SQL Server Reporting Services (SSRS), PostgreSQL, MySQL, Database Migration, Data Pipelines

Other

Data Visualization, Data Modeling, Dashboard Development, Database Optimization, Customer Data, Data, BI Reports, DAX, Dashboards, Robotic Process Automation (RPA), Business Services, Machine Learning, SAP BusinessObjects (BO), Google Data Studio, Market Research & Analysis, Data Engineering, Data Warehousing, Data Warehouse Design, Data Analysis, Data Analytics, APIs, Data Migration

Frameworks

Hadoop

Education

2020 - 2021

Master's Degree in Machine Learning and AI

Liverpool John Moores University - Liverpool, UK

2011 - 2015

Bachelor's Degree in Computer Science and Engineering

Ahsanullah University of Science and Technology - Dhaka, Bangladesh

Certifications

MAY 2020 - PRESENT

Tableau Designer

Tableau

MAY 2020 - PRESENT

Tableau Consumer

Tableau

MAY 2020 - PRESENT

Tableau Author

Tableau

MAY 2020 - PRESENT

Tableau Analyst

Tableau