farhanrussel (farhanrussel)

I am an Operations and Data Analyst professional with experience in operational reporting, inventory management, cost analysis, and process optimization across healthcare, construction, and property industries.

I have hands-on experience managing operational data, building reporting systems, monitoring KPIs, and improving business processes using Microsoft Excel and Google Workspace. I also completed Full Stack Data Analytics training at RevoU, where I developed skills in SQL, Tableau, Python, data cleaning, visualization, and business analysis.

My expertise includes:

Data entry & data cleaning
Excel reporting & dashboard creation
Operational & inventory reporting
KPI monitoring & business reporting
Tableau dashboard visualization
Google Sheets & structured reporting
Administrative support

I am detail-oriented, communicative, and committed to delivering accurate work on time.

Administrative Support Data Entry Business Analysis Cashflow Analysis Risk Analysis Statistical Analysis Administration Microsoft Excel Analysis Data Analysis

Hire Me
Make a Private Project

Invite to Bid
Existing Projects

User Name:	farhanrussel
Account Type:	Personal Account
Date Registered:	20/05/2024 05:12:06 WIB
Last Seen:	18/05/2026 14:41:21 WIB
Provinsi:	DKI Jakarta
Kabupaten:	Kota Jakarta Timur
Website:	https://docs.google.com/presentation/d/1OgOOerQ7T-2HsgCp3EzU-fEykAR-lTy9qWx6lSn-xmA/edit?usp=sharing
Online Hours:	15.45
Projects Won:	0
Projects Completed:	0
Completion Rate	-
Projects Arbitrated:	0
Arbitration Rate	-
Current Projects:	0

Ratings & Rankings

As Worker

0.00/10.00
0 Point
No Ranking
0 Projects

As Owner

0.00/10.00
0 Point
No Ranking
0 Projects

As Seller

0.00/10.00
0 Point
No Ranking
0 Sales

As Affiliate

0.00/10.00
0 Point
No Ranking
0 Users

Services

No record found.

Products

No record found.

2026: Customer retention analysis project for Olist e-commerce platform using Python, SQL, and Tableau.

Analyzed 96,000+ orders and 93,300 customers to identify the key drivers of low repeat purchase rates and develop retention improvement strategies.

Key achievements:

* Identified that late deliveries caused a 45% drop in customer satisfaction
* Conducted RFM segmentation to identify 22,350 high-potential customers
* Built retention and geographic performance dashboards
* Developed data-driven strategies projected to improve retention from 3.0% to 6.1%

Tools:
Python, SQL, Tableau, Excel

2026: Loan portfolio risk analysis project using SQL and Tableau to evaluate borrower performance, delinquency trends, and portfolio health.

Analyzed a $2.8B loan portfolio across 176,000+ borrowers through cohort analysis, TKB30 monitoring, anomaly detection, and borrower risk profiling.

Key achievements:

* Portfolio TKB30 reached 98.11%
* Identified 68.5% improvement in DPD30 rate across cohorts
* Performed statistical anomaly detection using z-score analysis
* Produced strategic underwriting recommendations to improve portfolio quality

Tools:
SQL, Tableau, Excel, Statistical Analysis

2026: E-commerce funnel analysis project focused on identifying customer journey bottlenecks and improving conversion performance.

Analyzed customer sessions, events, demographics, and traffic channels from 2019�2022 to evaluate funnel conversion, cart abandonment behavior, and marketing effectiveness.

Key achievements:

* Identified checkout stage as the main conversion bottleneck
* Analyzed traffic channel conversion performance
* Evaluated demographic conversion behavior
* Developed strategic recommendations to reduce cart abandonment and improve conversion rates

Tools:
SQL, Tableau, Excel

2026: Unified dashboard analysis project for OCA Indonesia (Telkom Indonesia) to monitor communication channel performance across WhatsApp, SMS, Email, and Call channels.

Built interactive Tableau dashboards for executives, product managers, campaign operations, and account management teams to monitor delivery rate, revenue performance, customer activity, and operational KPIs.

Key achievements:

* Analyzed 122,000+ transactions across 4 communication channels
* Identified critical 78.1% failure rate in Call channel
* Evaluated channel revenue performance and client concentration risk
* Developed actionable operational recommendations to improve delivery performance and business monitoring

Tools:
SQL (BigQuery), Tableau, Excel

No record found.

Anda harus login terlebih dahulu untuk melihat data ini.

You must login first to see this data.