Education

HARPREET SINGH

adpwm4@r.postjobfree.com 250-***-**** Vancouver

LinkedIn - www.linkedin.com/in/singhharpreet12

Summary

Driven Data Analyst with 2+ years of experience and extensive training in business administration and marketing, seeking to leverage comprehensive background to take the next career step in a Data Analyst role. Skilled in research, metrics analysis and data collection. Eager to utilize KPI expertise to drive business development.

TECHNICAL SKILLS:

Programming Languages: SQL and Relational Database, Python, R, Apache Spark. Machine Learning Algorithms: Linear Regression, Logistic Regression, Machine learning, Neural Networks, and Natural Language Processing. Tools: AWS, Tableau, Shiny, Anaconda, Git,Google Analytics, PowerBI, Branch, Appsflyer, Optimove, Sensor Tower, CRM, and MS Suite. Master of Data Science (University of British Columbia) [09/2018-07/2019]

• Relevant Couse work: Programming for Data Science, Computing platforms for Data Science, Algorithms and Data Structure, Web and Cloud Computing, Data Wrangling, A/B Testing, Predictive Modeling, Data Visualization and Storytelling. MBA – International Business and Marketing (Delhi School of Economics) [07/2015-08/2017]

• Relevant Course Work: International Market Research, Supply chain Management, Strategic Management, Economics for Managers, General Management, Marketing Management, Corporate Finance, Financial Management, International Trade and Policy Framework. Bachelor of Technology – Mechanical and Automation Engineering (GGSIPU University) [05/2008-08/2012] Relevant Experience

Marketing Analyst

Laal Button Toronto, CA [11/2020-11/2021]

• Executed exploratory data analysis by using MS Excel, Tableau, SQL, and Databricks for the larger data sets and presented insights and regular data delivery updates to clients.

• Built models to address business problems and presented solutions and strategies to solve them.

• Forecasted trends using NLP and Collaborated with the content creation team for creating engaging content to optimise outreach.

• Designed new queries and utilized existing query models to draw relevant customer information for development of financial reports utilized in forecasting, trending, and results analysis. Marketing Data Scientist Internship

SeekersMedia, British Columbia, CA [05/2019-08/2019]

• Forecasted website future traffic using Python Prophet model over time series data and also performed multivariate testing in finding the optimal marketing solution for the target audience.

• Provided Interactive Dashboards for external stake holders for B2B presentations and to monitor performance internally.

• Provided key data insights by using sentimental analysis on social media data using Natural Language Processing models.

• Improved customer engagement by providing an Artificial Intelligence powered chatbot for social media platforms. Trade Marketing Analyst [07/2017-07/2018]

Wrigley India Pvt Ltd Gurgaon, Haryana

• Cleaned and consolidated the data from local Sales Managers for implementation of trade marketing objectives on 25k stores.

• Executed the project by monitoring the deployment process and formulated incentive models for the sales team.

• Collaborated with event management companies for product launch (Wrigley's Double mint) in India. Academic Projects

• R Shiny app for Airline data set visualization.

• Interactive Dashboard for Crime Dataset analytics using Tableau.

• Interactive KPI Management Dashboard in Tableau.

• Visualizing City bike trips using Tableau.

• Interactive Dashboard using Streamlit and Python.

• Marketing Research project on “Impact of Celebrity endorsements on products of CPG category”.

• Predictive Analytics project using TensorFlow and Big Query.