Xosya Salassa

Client Site- Automotive Industry Onsite data operations at a major automotive client, handling market intelligence data across dealers and regions. • Daily ingestion and transfer of police registration, wholesale/retail sales, CBU import/export, and competitor pricing data across multiple dealer networks • Mapped raw regional registration data from multiple provinces into a centralized database, including city, district, and vehicle type mapping • Maintained product master data including new vehicle models, car id, suffixes, and segmentation mappings • Automated data workflows and reporting notifications using Power Automate, Power Automate Desktop, and VBA, reducing manual intervention • Generated market intelligence reports and performed cross-source data validation for accuracy and consistency • Provided ad hoc analysis on market trends, competitor stock, and regional sales performance • Developed automation for product data management and branch notifications, including daily alerts via Microsoft Teams ― SG-EDTS Building and maintaining data pipelines and automation systems for operational and business reporting. • Utilized Airflow, Looker, and BigQuery to integrate external data sources and manage ETL/ELT processes • Regularly updated DAG logic, query procedures, column schemas, and rejection logic to align with evolving business requirements • Built Cloud Run services and report generation pipelines triggered by file uploads and Pub/Sub events • Designed GCS-to-S3 data transfer pipelines with automated scheduling, validation, and audit logging • Maintained data quality across sales, inventory, and store operations through validation and rejection logic • Collaborated with cross-functional teams to deliver data solutions aligned with business needs • Conducted internal knowledge-sharing sessions on monitoring systems and App Script

• Built an automated reporting system that generates over 22,000 reports daily, weekly, and monthly, making operations smoother and more efficient. • Designed and improved 40+ reports using Looker, ggplot, and other BI tools to help teams make better decisions. • Developed 25+ ETL jobs with Airflow, BigQuery, and Cloud Storage to process large-scale data effectively. • Set up logging and tracking systems in GCP (Cloud Run, Pub/Sub, Cloud Build) to keep data pipelines monitored. • Partnered with teams across departments to improve real-time data access and accuracy.

• Conducted segmentation dataset and draw unique insight, including visualization of the transaction volume and assessing the effect of any outliers • Explore correlations between customer attributes, build regression and decision-tree prediction model. • Build some reports after finishing the task to get a structured story of the data

Complete this following courses: • Python for data professional beginners. • Fundamental SQL using select statement & function and group by. • Fundamental SQL using inner join and union. • Exploratory data analysts with Python for beginner. • Fundamental data visualization with Python. • Data visualization with Python Matplotlib for beginner. • Project data analysis for retail – sales performance report. • Project data analysis for B2B retail – customer analytic report.

• Conduct Analysis on client’s transaction dataset and identify customer purchasing behaviors to generate insights and provide commercial recommendations • Extend of analysis to help identify benchmark stores that allow testing the impact of the trial store layouts on customer sales. • Making presentation reports after doing analytics and getting insight from clients transactions for the client Category Manager Tools: Python

• Used Python to load, clean, and analyze large Datasets • Built T Wave Alternans Detection to identify Alternans of T Wave in ECG Signal • Worked with advanced calculation to conclude data found • Presented detailed reports every week to update my progress alongside my apprentice supervisor • Experience with labeling data images for Covid19 Detection • Participated in collecting, organizing, and interpreting data along with colleagues • Created Machine Learning Models with Python and scikit-learn to the classification of position P, QRS, and T Wave on ECG with more than 90% Accuracy • Implemented Detection with Machine Learning algorithm of Signal Processing on the case of T Wave Alternans Challenge Dataset.

Website Handling • Is responsible for the content of the website security website structure content and publishes articles in order to advance education in the field of information technology

• Designed analytical solutions • Executed and validated test cases • Extract necessary data and compile findings for analysis • Analysis Quality of Service WIFI PT Jalin Pembayaran Nusantara using Wireshark • [Project] QOS (QUALITY OF SERVICE) ANALYSIS ON WIFI “JALIN GUEST”AT PT JALIN PEMBAYARAN NUSANTARA.