Saras AnalyticsSenior Business Analyst
Nov. 2019 - Feb. 2021Hyderabad, Telangana๐ฆ๐ฎ๐ฟ๐ฎ๐ ๐๐ป๐ฎ๐น๐๐๐ถ๐ฐ๐ ๐ถ๐ ๐ฎ ๐ฑ๐ฎ๐๐ฎ ๐บ๐ฎ๐ป๐ฎ๐ด๐ฒ๐บ๐ฒ๐ป๐ ๐ฎ๐ป๐ฑ ๐ฝ๐ฟ๐ฒ๐ฑ๐ถ๐ฐ๐๐ถ๐๐ฒ ๐ฎ๐ป๐ฎ๐น๐๐๐ถ๐ฐ๐ ๐ฐ๐ผ๐บ๐ฝ๐ฎ๐ป๐ ๐๐ต๐ฎ๐ ๐ต๐ฒ๐น๐ฝ๐ ๐๐ผ๐ ๐ฒ๐ป๐ด๐ฎ๐ด๐ฒ ๐ถ๐ป ๐ฎ๐ป๐ ๐๐๐ฎ๐ด๐ฒ ๐ผ๐ณ ๐๐ต๐ฒ ๐ฑ๐ฎ๐๐ฎ ๐น๐ถ๐ณ๐ฒ ๐ฐ๐๐ฐ๐น๐ฒ.
- Worked with an NA-based Restaurants company on BI & Advanced Analytics projects.
- Worked with the largest MENA-based Restaurants & Foods company and accelerated multiple Growth Consulting, CRO, co-directed BI, Advanced Analytics, & systemized SEO projects to achieve a digital revenue of $100M (โฒ55% YoY) across 3 brands & 9 markets. (Client Facing Role)
- Spearheaded the SEO engagement for F|B e-Commerce website in 3 markets in MENA.
- Engineered the reporting database for the QSR chains client from the ground up.
- Programmed Google (Analytics, Search Console & My Business) API based Reporting Automation using Python to statistically flag metrics above or below the desired threshold.
- Built End to End automation of a Playstore reviews' PowerBI dashboard using NLP, Google Cloud Functions, & BigQuery.
- Collaborated with the clientโs Product team to create multi-market customer reviews & ran NLP for the sentiments.
- Automated an Excel Dashboard with PowerBI cube for daily consumption, for data of 22 websites & 8 apps. Teamโs manual toil -> 3~4 hrs/day to 30 mins/day.
- Led the initiative of a new marketing strategy for a clientโs website based on insights from Hotjar user usage video analysis.
Data Tech Stack: Google Analytics, Google Tag Manager, Power BI, Qlikview, Tableau, Google Datastudio, Looker, Python, Google Bigquery, MySQL, pandas, Spark, MS Excel & PowerPoint, Segment, VSCode, Google Ads, Google My Business, Statistics, SEM, SEO, eCommerce, etc.
Show less