Software Engineer - Python, SQL, Java - BI & Data Pipelines

Wencheng Li

Cleveland, Ohio ● *************@*****.*** ● 216-***-****

EDUCATION

The Ohio State University Columbus, Ohio

Bachelor of Science in Computer Information Science May 2023

• Recipient of the College Now and Say Yes Scholarship Programs

• Relevant Coursework: Software Development and Design; Principles of Programming Languages; Design, Development, and Documentation of Web Applications; Data Structures and Algorithms TECHNICAL SKILLS

• Programming Language: Python, Java, JavaScript, SQL, HTML/CSS, JSONata

• Database & BI: SQL Server, MySQL, Plex (ODBC), PostgreSQL, Power BI, Fuuz

• Tools & Dev: AWS, BigQuery, REST APIs, Git, VS Code, Eclipse, Postman, Linux, Excel PROFESSIONAL EXPERIENCES

McGregor Metal Springfield, Ohio

Software Developer June 2024 –August 2025

• Designed and developed end-to-end software solutions, including data extraction, schema design, data flows, and internal UI/dashboard development.

• Built the Gross Margin Report dashboard with Power BI and automated SQL Server refresh/export jobs, reducing reporting time from hours to minutes.

• Implemented ETL pipelines and testing using Python and Plex ODBC, ensuring reliable, maintainable, and user-friendly reporting systems

• Collaborated with cross-functional teams under Agile practices to deliver scalable, user-friendly reporting solutions.

Paris Banh Mi Columbus, Ohio

Software Developer November 2022 – February 2024

• Redesigned payroll system (Java, MySQL), automating workflows and halving processing time, improving efficiency by 40%.

• Engineered a dynamic, user-engaging website with React.js and MySQL React.js + MySQL site with real- time updates, reservation features, and feedback, increasing engagement by 30%.

• Collaborated cross-functionally using Agile to deliver high-quality features on tight schedules. Projects

Spotify Top 200 Data Pipeline

• Built Python web scraper (Selenium, BeautifulSoup) to extract and transform chart data.

• Stored structured datasets in BigQuery for scalable querying and analytics. Morning Report Automation System

• Engineered automated financial reporting pipeline using SQL, Python, Plex ODBC, and Fuuz.

• Cut daily reporting time from 2 hours to 5 minutes via scheduled job automation and JSON-based data transformations.

• Implemented automated email distribution for daily executive reporting. Sales Analytics API Service

• Built a RESTful API using Python and FastAPI to query BigQuery transactional data and compute analytics with Pandas.

• Connected API outputs to Power BI to create interactive dashboards and visualizations for business insights.

• Optimized BigQuery queries with partition filtering to improve performance and reduce costs.

Contact this candidate