Marketing Data Analyst

SIDDHARTHA SHARMA

Address: **** **** **, ***********, ** L5N 7H6, Canada Email: **************@*****.*** Visa Type: Permanent Resident Mobile: +1-647-***-**** LinkedIn: https://www.linkedin.com/in/siddharthash10 SUMMARY

Data Analytics professional with 3 years of experience interpreting and analyzing data in order to drive successful business solution. Proficient knowledge in ETL, marketing effectiveness and product analytics. Excellent understanding of business operations, predictive modelling and tools for effective analysis of data. TOOLS

SQL, Hive, Teradata, Adobe Analytics, Google Analytics, MS Office, R, Python, Tableau, JIRA and Confluence WORK EXPERIENCE

Senior Associate – Analytics Apr 2018 – Feb 2019

Factspan Inc. San Francisco Bay Area, CA, USA

• Applied Hive, Unix, Oracle, Adobe Analytics, R and Tableau to map business goals into optimal marketing programs through the incorporation of digital analytics, visualizations & attribution modelling

• 30% increase in efficiency and accuracy of deliverables using Agile methodologies for business processes

• Analyze the effectiveness of marketing campaigns for paid, search & email using Adobe Analytics

• Adopted recency, frequency, monetary values (RFM) to segment email customers and increase click- through rate (CTR) using tailor-made email campaigns for different customer buckets

• Built customer lifetime value model (LTV) and help business develop propositions for cross-selling & up- selling strategies and personalized experience for a targeted audience

• Forecasted financial impact of strategic decisions using multiple linear regression and time series models Associate – Analytics Mar 2016 – Mar 2018

Factspan Inc. San Francisco Bay Area, CA, USA

• Built and executed complex queries to extract big data sets using Hive and Oracle database

• 50% reduction in turnaround time of analyzing various retail products and its benchmarks by automating measurement process

• 25% decline in processing time in R using clustering of variables for existing predictive models

• Developed methodologies and automated the process to measure various KPIs and state their statistical significance for over 60 experimentation in 9 months

• Developed a model to quantify the influence of online browsing to store purchase and help optimize the investment to marketing channels

• Predicted future product that customer will shop next using logistic regression and random forest in R EDUCATION

• University at Buffalo, The State University of New York Feb 2016 Master of Science in Industrial Engineering (Specialization: Operations Research) Thesis: Data Driven Optimization of Railway Track Inspection and Maintenance Using Markov Decision Process

• National Institute of Technology Jamshedpur May 2013 Bachelor of Technology in Production and Industrial Engineering

Contact this candidate