Hsin Ping Wang Email & Phone Number

Taiwan

1. Provided analytical support by coordinating data extraction from various databases and interpreting it using MSSQL:• Designed and implemented data integration procedures, resulting in a 30% reduction in data processing time.• Developed dynamic Excel reports by linking Excel with SQL data integration processes, increasing report accuracy by 25%.• Constructed SQL Server Reporting Services (SSRS) web reports, leading to a 20% improvement in report accessibility and usability.2. Established a brand financial reporting ETL pipeline from scratch, addressing manual report generation issues and rebuilding connections between various tables to enable the brand marketing department to track data consistently on a quarterly basis. This initiative reduced reporting time by 40% and increased data accuracy by 35%.3. Supported multiple system migration processes, identifying management requirements, and coordinating with outsourcing partners to ensure system stability. Provided training to frontline sales staff, resulting in a 50% decrease in system-related errors post-migration.4. Assisted the CRM department in resolving customer data integration issues and validating data accuracy, enabling the brand to customize products and communication, fostering stronger customer relationships, and increasing satisfaction and loyalty. This initiative led to a 15% increase in customer retention and a 20% improvement in customer satisfaction scores.Skills:• Proficient in MSSQL, Excel, and SQL Server Reporting Services (SSRS).• Experienced in ETL pipeline development.• Skilled in data analysis and interpretation.• Proficient in business process improvement.• Strong team collaboration abilities.• Expertise in CRM data management.

台灣 台中市

‧Provided data forecasting and strategy to clients/government for making a strategic decision on urban planning/environmental protection/preservation.‧Acted as a business analyst to acquire clients' needs, initiated planning and utilized the cutting edge of methodologies in the field to improve the quality of the data analysis model.‧Used Python programming skills to process data cleaning and build a machine learning model by IBM Modeler as ETL to reduce 80% time of the manual process.‧Acted as a data scientist to lead the team to complete data model building with sufficient machine learning algorithms knowledge, to have an eye to capture abnormal numbers in the reports to assist the team in having well fit on the model training.‧Acted as a project manager to lead several cross-functional teams for 4 big projects. Applied team-working skills to coordinate between the teams and clients, provided value-add suggestions/feedback when the obstacles faced to the team.Project types include:• Geospatial Data Analysis (GIS)• Web/App Development• AI Model Prediction→ Environmental Pollution Exploration(RNN), Image Classification(BPP)

Taichung City, Taiwan

Taichung

Master'S Degree, Urban Planning And Spatial Information, 4

Activities and Societies: Student association of department, Poster presentation at Asian Conference on Remote Sensing (ACRS 2015) •.

Bachelor'S Degree, Urban Planning And Spatial Information, 4

Activities and Societies: • Graduated in third • Making GIS relevant project every semester • Leading the team to complete the analysis.