Sang Putu Sandhyana Yogi Email & Phone Number

Tangerang, Banten, Id

Jakarta, Indonesia

As a Data Analyst in the Commercial Excellence Division, my key responsibilities encompass:- Conducting comprehensive Exploratory Data Analysis (EDA) and cleaning of Product Master Data,- Stock Data, and Sales Data to ensure data integrity and accuracy.- Developing and implementing customized tabular reporting formats tailored to management’s strategic requirements.- Creating insightful stock reports to monitor slow and fast-moving products across Sales Divisions by extracting data from SAP and streamlining reports using Excel VBA.- Exploring Machine Learning techniques to segment Product Sales Groups for targeted market analysis.- Supporting Product Managers through in-depth market research and product surveys to inform strategic decisions.- Producing monthly Rolling Forecasts (ROFO) for the Ethical Sales Division, evaluating forecast accuracy against historical data, and devising strategies for improved accuracy in future forecasts.- Designing and evaluating product selling scenarios, pricing strategies, and profitability calculations by analyzing key variables such as COGS, distribution fees, and personnel costs.Collaborating with IT to enhance data reporting pipelines, testing and optimizing existing reports using tools like Metabase and SQL Server.- Continuously expanding my expertise in supply chain distribution practices and the pharmaceutical industry through business meetings with Pharmaceutical Distributors.- Assisting cross-functional teams with data cleaning and reporting tasks using Excel to enhance operational efficiency.- Ensuring the proper handling of the company’s confidential data.- Assisting in drafting B2B agreements and collaborating with the legal division on commercial aspects.- Conducting preliminary feasibility analyses for business development initiatives, supporting the new product development pipeline through market data, web research, historical sales analysis, and targeted surveys.

Jakarta, Indonesia

As a Data Analyst for Pharmaceutical Industry, some activities that I have worked on (or recurring tasks) are:- Exploratory Data Analysis mainly on Spreadsheet and Excel, with additional help of Python, (and few use cases requires SPSS for surveys)- Devise tabular data structure / format in spreadsheets and/or google sheets- Formulate data workflow and functions for Manager-level and/or Board of Directors reporting needs in spreadsheets and/or google sheets- Uses Machine Learning / Statistical approach in python for case studies, documented in GitHub- Pharmaceutical Industry comprehension and knowledge, by online and offline trainings and seminars- Maintain and monitor Master Product Data for reporting purposes- Work closely with other departments for data-driven assignments (Reporting, Case Study, Benchmarking, Format Restructuring, Data Cleaning)- Statistical analysis of a given dataset with Spreadsheets, Python, and SPSS- Acts as a Representative for the company as an Account Manager in Kamus Farmasi + Alkes by Kementrian Kesehatan Indonesia & Digital Transformation Office

Jakarta, Indonesia

As a Product Executive Intern in PT Pyridam Farma Tbk, I helped to make sure that my Product Manager(s) can work smoothly and effectively by providing data needed and documents for reporting and evaluation.I also worked on product-related document management and learned to work on pharmacovigilance tasks.

Indonesia

As a Data Analyst Intern, I have been tasked to complete many assignments such as:- Presented "Therapy area and OTC Market Analysis for Pyridam Market" as Internship final project- Competitor price analysis for new product launch benchmarking- Profit margin dataset building for further analysis by the business development department- Clean up master (confidential) spreadsheet dataThis company enables me to use and improve my hard skills, which are:- Tableau for visualizations- Spreadsheet for data analysis and cleanup- Python for exploratory analysis (descriptive statistics, correlation)Not only that, this company provides room for growth of soft skills in:- Professional presentation and communication- Work ethics- Sincerity and openness- Teamwork and interaction- Time management

Indonesia

Enrolled in the Machine Learning track at Bangkit Academy, class of 2021—a prestigious six-month program by Google for students pursuing careers in Machine Learning, Cloud Computing, or Android Development. During this program, I developed a TensorFlow model for classifying five types of Batik as part of a capstone project, achieving a 70% validation accuracy. I collaborated with students from different tracks to build a machine learning-based Android application, where I contributed by designing and training the classification model. Throughout the course, I honed my skills in Python, Bash, Git, and IT support, and participated in workshops focused on career development and resume preparation.

Jakarta, Indonesia

After running as a candidate, I am selected to be the organization's chairman/president.

Jakarta, Indonesia

This year I became an organizational manager (pengurus) after becoming an activist.

I participated as an activist to attend meetings and became a committee for an event.

Bachelor Of Information Systems, Information Systems, 3.74

Activities and Societies: Keluarga Mahasiswa Hindu Bina Nusantara

Science Major

Activities and Societies: Science Club, Basketball