Summary
Overview
Timeline
Work History
Education
Accomplishments
Skills
Certification
Interests
Work Availability
Hi, I’m

HSIANG WEN

Arlington,VA
HSIANG WEN

Summary

Demonstrated exceptional proficiency as a Data Analyst, excelling in advanced data analysis, data migration, optimization of data storage structures, and machine learning. My expertise includes executing sophisticated data mining techniques, developing and implementing machine learning models, ensuring data integrity through comprehensive cleansing processes, and deploying strategic solutions for database environment issues. My tenure at CODICE is marked by a commitment to safeguarding confidential data and enhancing IT operations efficiency. My work showcases a deep understanding of data science applications, from predictive modeling in reproductive physiology to leveraging statistical methods and machine learning algorithms for actionable insights at Weble International Corp. My ability to communicate complex findings effectively positions me as a valuable asset in data-driven decision-making environments.

Overview

3
years of professional experience

Timeline

Data Analyst
CODICE
08.2022 - Current
Data Science Practicum - Giant Panda Reproductive Physiology and Pregnancy Diagnosis
American University
02.2022 - 06.2022
Data Analyst Intern (Remote)
Weble International Corp
06.2021 - 08.2021
American University
Master of Science from Data Science
Chinese Culture University
Bachelor of Arts from Public Administration And Management

Work History

CODICE
Washington, DC

Data Analyst
08.2022 - Current

Job overview

  • Directly reporting to the Chief Information Officer (CIO), providing key insights and data-driven recommendations to inform strategic planning and execution.
  • Utilized data visualization for DC curbside parking solution, delivering comprehensive reports on parking revenue using tools like Tableau and Power BI, enhancing stakeholder understanding and decision-making capabilities.
  • Analyzed parking meter and Park Mobile data, contributing to the new parking solution and revenue streams across Washington D.C.
  • Optimized new data model for curbside parking solution using SQL Server and implemented machine learning algorithms to predict parking demand and usage patterns.
  • Participated in a data migration project for a new District Department of Transportation (DDOT) permitting system, enhancing city-wide operational efficiency.
  • Maintained and secured the database for CodicePay, the company's financial product, ensuring high data quality and system stability.
  • Utilized robust data cleaning techniques and Python-based preprocessing for client data to ensure precision and readiness for system integration within CodicePay.
  • Restructured and streamlined data formats and schemas, improving data efficiency and system compatibility for ongoing business operations.
  • Collaborated with IT and business teams to facilitate the successful deployment of new data systems, aligning technical solutions with business objectives and integrating machine learning models for enhanced decision-making.

American University
Washington , DC

Data Science Practicum - Giant Panda Reproductive Physiology and Pregnancy Diagnosis
02.2022 - 06.2022

Job overview

  • Used machine learning techniques to analyze reproductive biomarkers in Giant Pandas, leading to innovative breakthroughs in the field of predictive analytics for wildlife conservation.
  • Discovered a previously unknown pattern in Giant Panda reproductive physiology, establishing a new paradigm for studying and understanding their breeding behaviors.
  • Utilized complex statistical models to interpret large datasets of biological information, enhancing the accuracy of predictions regarding Giant Panda mating and birthing cycles.

Weble International Corp
Taipei, Taiwan

Data Analyst Intern (Remote)
06.2021 - 08.2021

Job overview

  • Employed advanced statistical methods to analyze customer datasets, significantly enhancing data segmentation and profiling which improved targeted marketing strategies and customer satisfaction.
  • Delivered insightful presentations to clients and internal teams, detailing analytical findings and project milestones, which facilitated informed decision-making and project alignment with strategic objectives.
  • Developed custom data models to forecast trends and behaviors, driving improvements in customer engagement and business outcomes through predictive analytics.

Education

American University
Washington, DC

Master of Science from Data Science
05.2022

University Overview

GPA: 3.73

Chinese Culture University
Taipei, Taiwan

Bachelor of Arts from Public Administration And Management
06.2019

University Overview

Study Abroad: The first exchange student from Taiwan to represent Chinese Culture University at Zhejiang University of Technology.

Accomplishments

Accomplishments

Project Experiences

D.C. Department of Transportation (DDOT) - Modernized Permitting System (MPS) - 01/2024 - Now

  • Collaborated with the Project Manager and Engagement Director to develop the entire project timeline using Microsoft Project.
  • Responsible for generating timeline reports and tracking deliverables for CEO review.
  • Analyzed the legacy database system to identify and address data quality issues, providing recommendations for improvement to the client.

DC Department of General Services (DGS) - 07/2023 - 03/2024

  • Assisted DGS in coordinating with vendors to address issues across all DC public schools.
  • Utilized Salesforce Cloud to manage work tickets, extracted data from Salesforce, and visualized it with Tableau for the management team.
  • Created visualizations to highlight the volume and geographic distribution of issues and forecasted future ticket volumes to aid in resource planning.
  • Developed predictive models using machine learning techniques to forecast future ticket volumes, aiding in resource planning and allocation.

HMS Gainwell Technologies - Medicaid Billing - 02/2023 - Now

  • As a Billing Manager, played a key role in the Medicaid Recovery project for the DC Department of Healthcare Finance.
  • Extracted claim data from the database using Teradata Studio and assigned it to the Customer Service Representative (CSR) team.
  • Utilized the reclamation process via the provider's portal and trained the team on its application.

D.C. Department on Disability Services (DDS) - Transaction Management and Data Integration - 03/2023 - Now

  • Maintained CODICEPay to efficiently manage and store transaction records in a structured database.
  • Performed thorough data cleansing using Python to ensure compatibility and enhance data accuracy.
  • Successfully extracted payment information and automated the process of generating and printing checks, significantly improving data management efficiency, reducing errors, and streamlining the payment process.

D.C. Department of Transportation (DDOT) - Next Generation Curb Management Concept 11/2022 - 03/2023

  • Created an innovative, data-driven platform designed to optimize curbside asset management by harnessing real-time data.
  • Utilized SQL Server for efficient large-scale database management, integrating and analyzing parking records against payment data to uncover insights.
  • Developed machine learning models to predict parking occupancy and optimize asset turnover.
  • Led the data visualization efforts, creating compelling visuals using Python libraries such as matplotlib and seaborn that allowed clients to compare current parking data with historical meter data, driving strategic decisions.

American University - Spotify Music Recommendation - 09/2021 - 12/2021

  • Personalized music discovery by applying various machine learning techniques and regression models using Python libraries such as scikit-learn, NumPy, and pandas to analyze user playlists and predict musical preferences.
  • Contributions included data preprocessing, feature engineering, and selecting the most effective models to ensure recommendations were both relevant and diverse.
  • Enhanced user engagement and demonstrated the potential of machine learning in creating tailored experiences in the digital music domain.

Skills

Technical Skills

  • Statistical Analysis: Strong ability to apply statistical methods to gather, review, analyze, and draw conclusions from data
  • Programming Languages: Proficient in programming languages like Python, R, SQL, and SAS for data manipulation, analysis, and developing machine learning models
  • Machine Learning: Experienced in applying machine learning algorithms and techniques, such as regression, clustering, and classification, using Python libraries like scikit-learn, TensorFlow, and Keras
  • Data Visualization: Skilled in using tools such as Tableau, Power BI, and Python libraries like matplotlib and seaborn to create visual representations of data to aid in understanding and decision-making
  • Database Management: Understanding of database technologies like MySQL, PostgreSQL, and MongoDB, with the ability to perform queries, updates, and data transformation operations

Analytical Skills

  • Critical Thinking: Ability to question assumptions, evaluate arguments, and synthesize information from various data sources to solve complex problems
  • Quantitative Skills: Strong quantitative skills to analyze numerical data and determine core insights
  • Attention to Detail: Precision and a keen eye for spotting discrepancies and patterns in data sets
  • Problem-Solving: Capacity to approach complex data challenges systematically and come up with effective solutions

Soft Skills

  • Communication: Ability to communicate technical data insights to non-technical stakeholders clearly and effectively through reports and presentations
  • Project Management: Skills in managing projects, including setting timelines, meeting deadlines, and coordinating with team members and stakeholders
  • Team Collaboration: Ability to work effectively in teams, understanding and integrating into the broader business context
  • Adaptability: Flexibility to adapt to new tools, technologies, and evolving business needs

Certification

  • Microsoft Office Specialist: Excel Associate (Excel and Excel 2019) - Credential ID: PVYa-uSRY
  • Google Data Analytics Professional Certificate
  • IBM Machine Learning Professional Certificate - Candidate

Interests

Baseball

Table Tennis

Cooking

Availability
See my work availability
Not Available
Available
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Similar Profiles

CREATE PROFILE
HSIANG WEN