Rebecca Fang

I am a new grads from McMaster U. My major is information system management  in DeGroote School of Business at Mac. I am opening for work. Welcome to my page😊. I know python/sql/Jmp/tableau and other Microsoft Office apps.

Marketing Specialist                                                                                                                                2022.10  -  Present 

SparkData, Hamilton, ON

• Collect market and industrial data from various sources such as Statistics Canada, Immigration Canada, Monster, Indeed, Glass Door and real estate websites.
• Leverage and analyze data to conduct market evaluation and marketing research such as market segmentation and structure, market size and trends, market growth and competition, SWOT analysis etc.
• Develop market intelligence by key performance variables, map and generate ad-hoc and recurring reports by using Python, SAS, Tableau and Power BI tools.
• Segment and profile customers in terms of demographic information and business behaviors to develop customer insights and marketing strategies.

Data Analyst Intern                                                                                                                                 2022.05  -  2022.08 

SparkData, Hamilton, ON

• Attended the training programs to learn SAS, Python, Hive, Spark programming and statistical analyses. 
• Independently worked on the hands-on projects in financial, telecom and retail industries to perform deep dive customer data analyses and business analytics. 
• Completed the training programs with outstanding achievements, gained keen data sense, business insights, strong skill set for SAS/SQL/Hive/Spark programming and big data analytics. 
• Utilized SAS, Python, Tableau to segment and analyze collected data to study market trends and forecast the seasonality and trends of job postings, real estate listings and prices, Air B&B openings and prices.

Marketing Analyst Intern                                                                           2021.09  -  2021.12              

Hangzhou Qimei Co. Ltd., Hangzhou, China

• Developed SQL queries to extract, cleanse, manipulate and validate data from MySQL and SQL Server databases.
• Leveraged customer and marketing data to study the sales trends, product penetrations and performances, customer distributions and revenue allocations by using SAS, SQL and Python tools.
• Interpret and visualize data, create analytic reports and dashboards by Power BI, Tableau and Excel tools.

 A 4th year student in Commerce at McMaster University with a solid education in business and quantitative data analysis.

• One year of hands-on experience in using SAS, SQL, Python programming and Tableau, Power BI, Excel to query, manipulate, analyze and visualize big data.
• In-depth knowledge and understanding of Customer Relationship Management (CRM), customer insights, database marketing, marketing research, campaign measurement and analysis. 
• A good team player and a quick learner with excellent communication, problem-solving and multi-tasking skills.