Data Analyst Social Media

Nabanita Ghosh

adkfqd@r.postjobfree.com 331-***-**** LinkedIn GitHub Portfolio

SKILLS

Languages: Advanced SQL, Python (NumPy, Pandas, Scikit-learn, Matplotlib, TensorFlow), R (dplyr, ggplot, tidyverse), SAS Tools & Technologies: Tableau, Power BI, SPSS, Google Analytics, Hadoop, Spark, Advanced Excel, SharePoint, AWS Statistical Techniques: Regression, Forecasting, Classification, Clustering, A/B Testing, Neural Networks PROFESSIONAL EXPERIENCE

Umbrella Technologies Aurora, IL, USA

Marketing Data Analyst Sep 2020 – Feb 2021

• Build robust data framework to automate extraction, cleansing and loading (ETL) of Security services revenue data into Salesforce using Excel, SQL and Python

• Designed and built reporting dashboards in Tableau to monitor marketing KPIs, visualize user profiles, and understand the customer lifecycle

• Optimized the website performance using SEO strategies to drive organic traffic and increased conversion rate by 6% Intone Networks Inc Iselin, NJ, USA

Data Scientist June 2020 – Aug 2020

(3 months project)

• Translated business needs to analytical requirements by collaborating with Project Managers for improved feature development

• Developed forecasting model in R to analyze IT Consulting Programs, supporting yearly planning and partnership goals

• Built a data regression model in Python and analyzed employee turnover metrics achieving 87% modeling accuracy Umbrella Technologies Aurora, IL, USA

Digital Marketing Intern May 2019 – Aug 2019

• Increased user engagement by 15% for various security service categories by recommending KPI improvement strategies

• Supported email campaigns, launched social media marketing campaigns, ran Google Ads on specific services and carried out A/B test to optimize conversion rate; analyzed Google Analytics data and improved sales by 12% with a 15% drop in price

• Constructed choice models in SAS to predict customer choices and analyzed price sensitivity for 14 attributes Accenture - Telecom Client: TELUS Canada Oct 2014 – July 2018 Application Development Analyst

• Led a team of 5 for project delivery for a big-ticket client and recognized for back-to-back delivery of 12+ releases from client

• Developed Tableau dashboards and reports on wireless number portability fallout scenarios and performed competitive analysis

• Succeeded in developing business requirement changes using SQL and Java, executed Quality Assurance (QA) activities and responsible for batch testing in Selenium, manual testing using SoapUI, JIRA for 10+ releases Associate Software Engineer

• Accelerated build process by 40% by analyzing, documenting business requirements and prototyping solutions by collaborating with stakeholders

• Automated production cleanup reports for daily failed BI jobs reducing reporting efforts by 80%

• Ensured all incidents are resolved against Service Level Agreements (SLAs); reported trends and deviations to leadership ACADEMIC PROJECTS

Predicting Loan Default

• Performed data exploration, data cleaning and feature engineering on 26 explanatory variables using Random Forest in Python

• Created Logistic Regression model to predict loan default, achieving 99% precision and 97% recall Predicting Death Rate on Cancer Dataset

• Executed Regression model on cancer data where each observation is a county in the US for predicting death rate using R

• Achieved an accuracy of 73.9% by utilizing lasso regression Real Estate Data Analysis (Course project in collaboration with Pahroo Appraisal & Consultancy – Chicago, IL)

• Optimized SQL queries to analyze 25K real estate data and perform due diligence on leads to buy or sell properties

• Predicted the house prices in Chicago with Regression model in Python, saving 50% of manual effort in property value estimation EDUCATION

Illinois Institute of Technology 2018 - 2020

Master of Science, Marketing Analytics (Specialized in Data Analytics & Data Science) GPA – 3.63 West Bengal University of Technology 2010 - 2014

Bachelor of Technology, Information Technology GPA – 3.22 ACHIEVEMENTS

• Awarded Certificate of Appreciation from the client for demonstrating a key sense of accountability and ownership for the processes that impacted the quality within the TELUS account at Accenture.

• Awarded with Stewardship award for helping team members at Accenture.

Contact this candidate