Digital Marketing Data

POOJA BHANSALI

Sunnyvale, CA 408-***-**** LinkedIn Email Address

SUMMARY

I am passionate in Data Analysis, Data Mining, Business Metrics & Reporting, Statistical Analysis. Experience in analytical support to issues through root-cause analysis. Strong in project management skills & Problem solving skills. SKILLS: SQL, Python, R, SPSS, SAS (JMP), AWS (Redshift), Tableau, PowerBI, CRM, Salesforce, Google Analytics. EXPERIENCE

Business Operation Analyst, ZypMedia Inc, San Francisco CA — (02/2020 – 05/2020)

Advanced Analytical data infrastructure to run ad-hoc operations, Analyze trends KPIs, digital marketing campaigns pacing performance metric, analyze fraud clicks, monitoring performance KPIs through reporting 5+ dashboards.

Extracted & cleaned 4M+ unstructured data from multiple data sources, audience segmentation & A/B testing to drive optimize marketing campaign SMS, retargeting, analyzing trends using advanced SQL queries for product improvement, CTR, data analysis procedures through coding in R & Python for repeat use, improving team analytical efficiency by 60%, using Python, R, SQL, Excel (Pivot Tables, VLookups), VBA, PowerBI, Datorama, Dataxu, Jira, Notion. Business Analyst, lettrs llc, New York — (12/2015 - 01/2017)

Insight data-driven product conclusions using Mongodb, established new users forecast methodology for web analytics, identify opportunities for improvement to collaborate with teams to QA & troubleshooting to enrich impact end user rate.

Lead in generating quick users’ feedback on mobile app to improve efficiency to track record business metrics. Human Resources Intern, Bombardier Transportation ltd, India — (09/2012-05/2013)

Focus on employee records & maintain up-to-date employee holidays record, decision making in Excel, SAP, SPSS.

Contributed recruiting ATS, research on measuring health & safety provided by bombardier to their employees. EDUCATION

California State University East Bay, California: Master of Data Science in Business Analytics, May 2020

Maharaja Sayajirao University, India: Master’s in human resources management, May 2013

Maharaja Sayajirao University, India: Bachelors in commerce (Statistics), May 2011 RESEARCH PROJECTS

Database Foundation for University: LINK

Develop physical integrity relational databases table schemas, product roadmap, loaded fully complex Data warehouse.

Attribution redundancies to 3NF & Enhanced entity relationship diagram, execution SQL queries, ERP, ETL, Tableau. Predicting Best Technical Company Based on Employees Reviews: LINK

Perform end to end structured data gathering requirement, Extract data, manipulation, transformation data quality predicting model for Google, Apple, Netflix, Microsoft, Amazon, Facebook to help Business strategy accuracy by 87%. Business Analysis Strategy Data on Glassdoor Job Skills Sets: LINK

Use Url to get the APIs to collect data id allows to request job detail by skills, pull data sets integrity into JSON format.

Data science to visualization large datasets, fetching employee data to gather business insights to employee job detail.

Use Python, Pandas, Numpy, BeautifulSoup, matlab, Scikit-learn, scipy, TensorFlow, Matplotib, Pycharm, Seaborn. Online eBay Auction Brand Business Performance: LINK

Analytic to execute strategic optimization: Linear regression, integer, simulation, queuing models in Excel Solver. Sentiment Data Analysis on letgo.com cars: LINK

Scrape data contain listing car sales on Big data Hadoop Map Reduce, Quantitative Analysis: KNN, PCA, Naive Bayes. A model Chatbot - ‘Vira’ for Alaskan Airlines: LINK

Chatbot has been developed with an intent to help Alaska airlines customers by answering covid-19 related questions.

Chatbot has tested with random questions, ensure accuracy regression Analysis, NLTK, tf-idf, cosine similarity, tkinter. Gateway for Health Disease control and Prevention: LINK

Data to implement Artificial Neural Network 89%, Decision Tree 87% models to classify the outcome of disease to help pregnant women grow to early detect diabetes, delivering prototype for diabetes risk prediction business requirement issues predicting modeling of healthcare operations.

Contact this candidate