🏢 Professional Experience
Data Analyst ( Altice USA,New York ): Sept 2021 - Present
-
Advised a media client on user acquisition, marketing analytics and improved marketing channel ROI.
-
Developed multi-touch attribution data model & established business KPI’s to measure ad campaign effectiveness that helped optimize marketing spend.
-
Performed causal inference using synthetic control generation for incrementality measurement of ad campaigns.
-
Leveraged advanced statistical techniques to analyse trends in viewership behaviour for audience segmentation.
-
Optimized audience matching data pipeline for high dimensional attributes & increased response time by 65%.
-
Worked closely with data scientists to identify data needs and testing supervised machine learning models.
-
Designed & maintained 12 self-serve dashboards that empowered stakeholders to drive real time optimizations.
-
Built necessary data pipelines to power automation that eliminated manual intervention of 3 hours.
-
Led a summer intern towards acheiving their goals and thereby helping them to develop their skills.
Data Analytics Intern ( Lopa Inc,New York ): Dec 2020 - Apr 2021
-
Developing strategies based on insights from podcasts transcriptions and podcast data for host read ads.
-
Text Analytics to derive insights from large podcast episode transcriptions data with Spark big data processing.
-
Built a data collection workflow using Python & Google Cloud (Speech To Text, Cloud Storage, MySQL) for loading data to data store.
-
Implemented web scrapers responsible for extracting relevant information from RSS feeds & web API endpoints.
-
Implemented a relational database model to include information relevant for building analytic data store.
-
Led a team of three , ensuring high quality deliverables and timely work.
Business Intelligence Analyst ( Accenture Solutions,India ): Dec 2016 - Jul 2019
-
Deployed reporting solutions over ~5M active subscriber base for a Telecom client to make business decisions.
-
Designed Business Intelligence reports using SSRS and implemented SSIS ETL pipelines for finance & ad-hoc reporting.
-
Coordinated with client to gather requirements to build BI reports for monitoring revenue and service usage.
-
Analysed the variances in report reconciliations that uncovered 5% of new system issues and fraudulent transactions.
-
Implemented KPI’s to measure performance of system jobs and analyse patterns in defects.
-
Built a Tableau dashboard summarizing customer service performance with case level , individual agent & team level metrics.
-
Optimized SQL queries with window functions that improved turnaround time of a finance reports from 1.5 hours to 30 mins.
-
Automated daily, weekly & monthly financial reporting activity using Python that eliminated manual process of over 1 hour.