novansurya
Data Analyst And Customer Service
I am Novan, a Management graduate with over 3 years of experience in Data Analysis, Data Science, and Data Visualization. I specialize in data processing and statistical modeling using SQL, Python, Spreadsheet, Power BI, Tableau, and Looker Studio. I have extensive experience analyzing advertising data, revenue data, affiliate data, live data, marketplace data, and sentiment analysis. Additionally, I have 1 year of experience in the hospitality industry as a Front Office staff and 1 year in advertising (Meta and TikTok Ads). I am a certified Data Analyst by BNSP.
Experience: 3 years
Yearly salary: $20,000
Hourly rate: $35
Nationality: 🇮🇩 Indonesia
Residency: 🇮🇩 Indonesia
Experience
Data Analyst
PT. Mitra Sukses Bersama Distribusindo 2024 - 2025
Performed revenue forecasting with 85%-98% accuracy using ARIMA/SARIMA algorithms. Increased sales by 50% within 1-3 months through revenue and advertising data analysis. Collaborated with the operations team to optimize Excel formulas, improving stock management coordination. Implemented E-commerce Cohort Analysis for Shopee, TikTok, and Tokopedia on three brands (Tropee Bebe, Royale Bebe, and Noomi) to enhance customer retention.
Digital Marketing (Meta Ads)
PT. Heya Agency Creative 2024 - 2024
Analyzed market trends based on age, interests, and demographics on Facebook and Instagram. Compiled advertising reports for performance evaluation. Managed Meta Ads campaigns focused on Brand Awareness, Lead Generation, and Purchases. Monitored and compared ad campaigns to optimize performance for maximum results.
Data Analyst
PT. Gelora Bintang Sejahtera 2023 - 2024
Performed customer reorder forecasting using Python. Created monthly dashboards in Spreadsheet and visualizations in Google Data Studio. Designed monthly templates in Spreadsheet and developed Key Performance Indicators (KPIs) for employees. Collaborated with the Advertiser, CRM, and Customer Service Coordinator teams to ensure smooth interdepartmental operations.
Front Office
PT. Swasembada Jaya (The Cabin Hotel) 2023 - 2024
Managed guest data, reservations, and daily reports using Spreadsheet. Coordinated social media activities, created content, built engagement, and analyzed content performance. Conducted broadcast messaging and customer communication via phone and chat. Promoted hotel products and collaborated with clients to increase hotel revenue.
Data Analyst
PT. GIT Solution 2023 - 2023
Identified data using data science methodologies, collaborating with project managers, UI/UX designers, and full-stack developers in project design. Presented analytical findings for decision-making and machine learning project implementation. Designed visualizations in Power BI to enhance business understanding.
Data Analyst Bootcamp and Internship
PT. Pintar 2023 - 2024
Explored datasets, performed data cleaning, exploratory analysis, and machine learning modeling. Completed a customer churn case study for a telecommunications company. Gained a deeper understanding of business statistics and variable correlation. Used Python to explore data in-depth and uncover valuable insights.
Data Science – Project-Based Virtual Internship
Home Credit Indonesia 2023 - 2023
Completed a credit default prediction case study using Python in Jupyter Notebook. Analyzed the issues faced by Home Credit Indonesia and solved them using Python. Performed data cleaning, reprocessing, exploratory data analysis (EDA), and statistical modeling.
IT Business Analyst – Internship
Kawan Kerja 2023 - 2024
Analyzed products and discussed findings with product owners. Presented business analysis findings and system documentation (BRD, ERD, Cycle Diagram). Collaborated with the QA team to ensure solutions meet business requirements and are well-tested.
Skills
copywriting
customer-success
data viz
data-entry
digital-marketing
finance
python
sql
data-science
english