Konnatee Kitticharoenwong
Bangkok,10
Summary
As an engineering graduate with over a year of data analyst experience, I excel at transforming complex data into actionable insights. Proficient in end-to-end data analysis with SQL, Python, Power BI, and Tableau, I have contributed to projects ranging from manual reports to fully automated dashboards. I specialize in creating ETL automation processes using Python, Batch Scripts, and Linux Command Lines, turning raw data into polished dashboards and developing automated email systems. Additionally, I independently manage and organize datamarts. With strong communication and storytelling skills, I deliver compelling presentations and thrive both independently and as part of a team. My technical expertise and proactive approach make me a valuable asset in any data-driven environment.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Data Analyst and Automation Process Specialist
Bizcuit Solution
09.2023 - Current
- Developing end-to-end automated dashboards with daily automated email distribution to over 20,000 recipients
- After completing the development of dashboards (Tableau and Power BI), batch scripts are utilized to extract, refresh, export images, and publish the dashboards daily
- Python scripts are then employed to send the images to the recipients
- All these processes are scheduled to run daily using Linux command lines
- After the whole process is done, it requires no human intervention
- Organizing and modifying MySQL datamarts, with periodic automated extraction, transformation, and loading of data to the datamarts using SQL scripts and Python
- Engaging with corporate-level company clients by giving presentations, handling the clients, gathering requirements, managing projects, and supporting clients in decision-making
- Initiating new projects and introducing new automation ideas to reduce work time and convert manual processes into automated ones
- Transforming raw data into insightful reports and dashboards, including both regular and ad-hoc reports
- Performing quality assurance (QA) tasks to ensure the accuracy of data presented in dashboards and reports.
Data Analyst (Internship)
Mitsubishi Motors (Thailand)
06.2022 - 08.2022
- Introducing Power BI automated dashboards with user interaction for executives: Developed interactive Power BI dashboards that allow executives to engage with the data
- Created dashboards to showcase the performance of each Mitsubishi Motors (Thailand) dealer, leading to a first-place award in an internship student project
- Creating customized reporting tools using MS Excel formulas and functions: Developed tailored reporting tools utilizing advanced MS Excel formulas and functions to meet specific data analysis and reporting needs.
Education
Suankularb Wittayalai School
03.2019
King Mongkut's University of Technology Thonburi (KMUTT)
Skills
- SQL
- Python (Pandas, Numpy, SMTPLIB, Pyspark, etc)
- Basic HTML
- Power BI
- Tableau
- Linux Command Lines
- Batch Scripts
- Power Automate
- Microsoft Office (Proficient in Excel, Word and PowerPoint)
- Eager to learn and a quick learner
- Team-Working
- Good communication skills and a great speaker
- Problem solving skills
Certification
- Certificate and trophy for winning the best internship project award (Mitsubishi Motors Thailand).
- Excel for Data Analysis
- Data Visualization and Dashboards
- What is Data Science?
- Tools for Data Science
- Data Science Methodology
- Python for Data Science, AI & Development
- Databases and SQL for Data Science with Python
- Onramp
- Simulink
- Image Processing
Additionalprojects
- Participated in PTT's project, science project competition (me and my team submitted ideas about recycling PCB)
- Manufacturing project (Manufacturing and transportation process designing)
- Python project (Image processing AI for choosing a haircut that suits you the most)
- Arduino project (Intelligent mailbox, automatic pet feeder)
- CU Startup Thailand League, designed of an application that allowed the users to travel anywhere using VR technology (Qualified the last 10 teams from over 90 teams of total participants)
- Enrolled CU Fintech (Financial technology model competition)
Personalities
- Entertainer, love making people laugh.
- Love working with people.
- Generous and empathy.
- Ambitious and eager to learn new things.
Personal Information
Date of Birth: 07/07/00
Timeline
Data Analyst and Automation Process Specialist
Bizcuit Solution
09.2023 - Current
Data Analyst (Internship)
Mitsubishi Motors (Thailand)
06.2022 - 08.2022
Suankularb Wittayalai School
King Mongkut's University of Technology Thonburi (KMUTT)
Similar Profiles
STELLA.B STELLA.B null
Human Resources Intern at Accevia Global Solution Private SolutionHuman Resources Intern at Accevia Global Solution Private Solution
Girish Kant AryaGirish Kant Arya
Control Room Engineer at M/S O&M Solution M/S O & M SolutionControl Room Engineer at M/S O&M Solution M/S O & M Solution
Abiodun Dele AkinlabiAbiodun Dele Akinlabi
Project Manager at Advanced Quest & Solution Concept Solution LimitedProject Manager at Advanced Quest & Solution Concept Solution Limited