Business Analytics student - SQL, Tableau, SAP data expert

LOI LY

513-***-**** • ****@****.**.*** • https://www.linkedin.com/in/loily2103/ • https://rpubs.com/lylp Business Analytics student with strong SQL, R, and Tableau experience, focused on system validation, data integration, and production analytics. Experienced in working with ERP systems (SAP), troubleshooting data discrepancies, and supporting cross-functional manufacturing operations. Strong interest in automation systems, database-driven applications, and industrial software development. Seeking an entry-level technical consulting or automation-oriented role. EDUCATION

University of Cincinnati, Carl H. Lindner College of Business Cincinnati, Ohio Bachelor of Business Administration, Major 1: Business Analytics – Major 2: Operation Management Expected: August 2026

• GPA: 3.82

• Relevant Coursework: Spreadsheet Analytics, Data Mining, Operation Management, Forecast & Risk Analysis

• Certification Google: Foundations: Data, Data, Everywhere; Technical Support Fundamentals; Ask Questions to Make Data-Driven Decisions WORK EXPERIENCE

Supply Chain Co-op Customer Care - Summer/Fall Semester May 2025 - December 2025 Givaudan Taste & Wellbeing Cincinnati, OH

• Validated SAP-generated transactional data and performed SQL-based discrepancy analysis to ensure system accuracy.

• Built structured KPI dashboards (OTDC/OTDR) using Excel and Tableau to monitor production performance.

• Identified data inconsistencies across planning and logistics systems, supporting process correction initiatives.

• Collaborated with Production and Planning teams to troubleshoot operational system exceptions.

• Improved reporting reliability by implementing structured data validation checks. Social Media Marketing – Internship Part-time January 2025 - April 2025 Triquetra Health West Chester, OH

• Analyzed engagement metrics across platforms, increasing viewership by 18% and supporting targeted sales growth initiatives.

• Assisted in developing marketing strategies, scripting key talking points, and mastering product features.

• Managed multiple priorities and communicated business performance and project progress to management and business partners.

• Represented the brand professionally as an ambassador, ensuring alignment with company values and messaging. Operations Management and Production Co-op Full-time August 2024 – December 2024 HH Global Cincinnati, OH

• Directed production workflows and led packout operations, increasing line efficiency by 12% through real-time feedback and coordination.

• Provided real-time and consistent feedback to enhance productivity.

• Monitored work quality to ensure compliance with job specifications.

• Maintained a steady supply of materials to prevent production interruptions.

• Directed the removal of completed displays and ensured production boards were updated. SKILLS

• Computer: R, SQL, Excel (Advanced), SAP, Tableau.

• Machine Learning & Analytics: Logistic Regression, Random Forest, Decision Trees, Predictive Modeling, Time-Series Analysis, Data Preprocessing, Feature Engineering, Model Evaluation.

• Data Techniques: Data Cleaning, Statistical Analysis, Data Transformation, Dashboard Development.

• Business & Systems Knowledge: Operations Management, Forecasting, Risk Analysis, Process Optimization. ACADEMIC PROJECTS

Project: TCCC EDI Route Alignment (Coca-Cola) July - August 2025

• Analyzed data consistency between SAP ERP and EDI platforms.

• Analyzed discrepancies in shipment lead time using structured data analysis.

• Performed system-level validation and troubleshooting of shipment lead-time calculations.

• Documented integration gaps and proposed corrective system adjustments. Final Group Project University of Cincinnati Crime Analysis (Forecast and Risk Analysis) March - April 2025 University of Cincinnati Cincinnati, OH

• Conducted large-scale data cleaning and preprocessing on multi-year public crime datasets.

• Applied time-series forecasting and spatial analysis techniques to identify risk patterns.

• Developed data visualizations and interactive dashboards to communicate model findings.

• Assessed model reliability and trend stability for decision-support applications. Data Mining Group Projects at University of Cincinnati March - April 2024 University of Cincinnati Cincinnati, OH

• Performed data preprocessing, feature selection, and transformation on structured datasets.

• Evaluated model performance using accuracy, precision, recall, and confusion matrices.

• Compared algorithm performance and validated model robustness across multiple iterations.

• Generated actionable insights based on model outputs to support decision optimization.

Contact this candidate