SARANSH KANSAL
Assistant Manager Analytics
Gurgaon
Summary
Dynamic and results-driven professional with 3.5 years of experience in data analytics and data science, seeking to leverage expertise in statistical analysis, machine learning, and data visualization to drive actionable insights and strategic decision-making in a challenging data-centric role. Proven track record of transforming complex data into meaningful insights to optimize business processes, enhance operational efficiency, and drive revenue growth. Proficient in Python, SQL, and data visualization tools such as Tableau and Power BI. Eager to contribute analytical skills, problem-solving abilities, and a passion for data-driven decision-making to a forward-thinking organization dedicated to innovation and excellence in data analytics
Overview
3
3
years of professional experience
19
19
years of post-secondary education
Work History
Assistant Manager Analytics
Nexxbase marketing (Noise)
2 2023 - Current
- Successfully extracted data from multiple sources, including Google Sheets connected to BigQuery, and combined them into comprehensive datasets for analytics and model building, in line with business requirements.
- Applied fundamental statistical concepts, including ANOVA and regression analysis, to analyze marketing campaign performance and customer behavior. Designed and conducted A/B tests to evaluate the effectiveness of marketing strategies, ensuring statistically significant results.
- Developed high-quality, scalable Python code modules to support various analytics tasks. Created and maintained Power BI dashboards and reports, providing actionable insights to cross-functional business teams.
- Developed clear visualizations that support the data story, using inclusive design principles. Automated repeated measurement and reporting tasks, building scalable dashboards to cover various scenarios (geo, web, and apps).
Business Analyst
Purplle.com
03.2022 - 02.2023
- Worked closely with product managers, data engineers, and data scientists to support product management and development. Communicated project goals, methodologies, and conclusions to both technical and non-technical audiences effectively.
- Improved click share of brand banners on the homepage from 20% to 30% by analyzing and optimizing placement and design.
- Increased market share of private brands Good Vibes and NY Bae from 5% to 8% in the skincare and makeup categories respectively, by providing targeted insights and recommendations.
- Reduced cost per order (CPO) from 500 to 250 for Facebook and Google campaigns through the development of an effective attribution model.
- Empowered stakeholders by training them to pull data from automated dashboards or scheduled reports. Promoted data democracy by providing training on basic analytics tools and solutions.
Business Analyst
Tata Consultancy Services
01.2021 - 03.2022
- Responsible for partnering with the stakeholders to ensure requirements are optimized and implemented, efficiently, effectively, and in accordance with business objectives
- Creating dashboards through Tableau/Power BI for tracking business metrics.
Education
MBA - Business Management
Narsee Monjee Institute of Management Studies
Hyderabad, India 04.2001 - 04.2020
B. Tech - Textile Engineering
Uttar Pradesh Textile Technology Institute
Kanpur, India05.2018
Skills
Python
SQL
Big query
Powerbi
Pandas in Python
Numpy
Seaborn
matplotlib
Linear/logistic Regression
A/B testing
ANOVA, basic probability theorems
SciPy, Statsmodels
Websites
Timeline
Business Analyst
Purplle.com
03.2022 - 02.2023
Business Analyst
Tata Consultancy Services
01.2021 - 03.2022
MBA - Business Management
Narsee Monjee Institute of Management Studies
04.2001 - 04.2020
Assistant Manager Analytics
Nexxbase marketing (Noise)
2 2023 - Current
B. Tech - Textile Engineering
Uttar Pradesh Textile Technology Institute
Similar Profiles
Rohit SoniRohit Soni
Asst. Manager at Noise (Nexxbase India Pvt. Ltd.)Asst. Manager at Noise (Nexxbase India Pvt. Ltd.)
Shantanu ChauhanShantanu Chauhan
Director - Marketing at NoiseDirector - Marketing at Noise
Chaz WashingtonChaz Washington
Remote Graphic Design Intern at Noise À Noise RecordsRemote Graphic Design Intern at Noise À Noise Records