Sushma Vishnoi
Noida
Summary
Results-driven Data Analyst with expertise in Google BigQuery and advanced Excel, previously at Ekanek Networks. Successfully enhanced e-commerce performance through data-driven insights and predictive modeling. Proven ability to collaborate with cross-functional teams, delivering actionable reports and dynamic dashboards that improved decision-making and drove growth initiatives.
Overview
5
5
years of professional experience
Work History
Data Analyst
Ekanek Networks Private Limited
Delhi
05.2024 - Current
- Analyzed large datasets using Google BigQuery for frontend data and PostgreSQL for backend data, identifying trends, patterns, and insights to drive e-commerce performance improvements.
- Utilized Google Analytics 4 (GA4) extensively to track user behavior across digital touchpoints, build custom event funnels, and analyze cohort performance for improved engagement and retention.
- Monitored and analyzed key performance indicators (KPIs), such as conversion rates, average order value, and customer retention, generating detailed reports for stakeholders using Looker, GA4 custom reports, and advanced Excel dashboards.
- Conducted a comprehensive analysis of customer behavior and purchasing patterns to enhance personalization and targeted marketing strategies.
- Created and maintained dynamic dashboards and visualizations using Looker and advanced Excel Pivot tables, translating complex data into clear, actionable insights.
- Utilized Firebase for app debugging and fetching real-time data, enhancing the responsiveness and accuracy of data-driven decisions.
- Designed and analyzed A/B tests to assess the impact of new features, promotions, and website changes, providing data-driven recommendations for optimization.
- Managed and integrated data from front-end and back-end sources, ensuring accuracy and consistency across the e-commerce platform.
- Applied predictive modeling techniques to forecast sales trends, inventory needs, and customer behavior, supporting strategic decision-making.
- Partnered with marketing, category, and operations teams to align data insights with business objectives, and drive growth initiatives.
Data Analyst
Whizzard Logistics
Hyderabad
09.2023 - 11.2023
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
- Designed and developed data pipelines to acquire, clean, and process data.
- Developed and maintained data warehouses and data marts to support business operations.
- Created data models to support decision-making processes.
- Collaborated with stakeholders to identify business needs and data sources.
- Developed customized reports, summarizing and presenting data in a visually appealing format.
- Extracted and interpreted data patterns to translate findings into actionable outcomes.
- Identified, analyzed, and interpreted trends or patterns in complex data sets.
- Developed data mining algorithms to identify and classify patterns in data.
- Created dashboards to monitor and track key performance indicators.
- Deployed predictive analytics models to forecast future trends.
- Developed an ETL pipeline to streamline data ingestion and processing for analysis, resulting in an 80% reduction in processing time.
Data Analyst
Mankind Pharma
Manesar
09.2020 - 04.2023
- Developed research proposals, identified research objectives, and created research plans.
- Determined areas of research to increase knowledge in a particular field.
- Identified sources of funding to prepare research proposals, and submit funding applications.
- Developed data collection strategies, and monitored data quality for optimal research results.
- Analyzed and interpreted patterns and trends.
- Synthetized data and wrote detailed reports to present research findings to stakeholders.
- Sorted data into well-organized formats and transformed it into figures.
- Interpreted data analysis results to draw inferences and conclusions.
- Collaborated with cross-functional teams to identify and resolve research-related issues.
- Collected and analyzed primary data through a series of experiments, resulting in new insights that informed the development of a new product.
Education
PGP - Data Science & Business Analytics
Great Lakes institute of Management
Gurgaon07.2023
Master of Science -
Jiwaji University
Gwalior06.2017
Bachelor of Science -
Shahu Ji Maharaj University
Kanpur06.2014
Skills
- Looker
- PostgreSQL
- Python
- Advanced Excel
- BigQuery
- Power BI
- SQL
- Tableau
- Web scraping
- Google Analytics
Languages
- English, Fluent
- Hindi, Native speaker
Timeline
Data Analyst
Ekanek Networks Private Limited
05.2024 - Current
Data Analyst
Whizzard Logistics
09.2023 - 11.2023
Data Analyst
Mankind Pharma
09.2020 - 04.2023
PGP - Data Science & Business Analytics
Great Lakes institute of Management
Master of Science -
Jiwaji University
Bachelor of Science -
Shahu Ji Maharaj University
Similar Profiles
Ishita SharmaIshita Sharma
Project Manager at Ekanek Networks Pvt LtdProject Manager at Ekanek Networks Pvt Ltd
Ashwini AvhadAshwini Avhad
Proposal & Tender Executive at Ascent Networks Private LimitedProposal & Tender Executive at Ascent Networks Private Limited
Raja Nandini BhavanamRaja Nandini Bhavanam
Software Engineer at Learnedze Networks Private LimitedSoftware Engineer at Learnedze Networks Private Limited
Sunil BhatSunil Bhat
Business Head IDBI Vertical at Ageas Federal Life Insurance Company LtdBusiness Head IDBI Vertical at Ageas Federal Life Insurance Company Ltd
Chetna SinghChetna Singh
Assistant Manager-Strategic Bid Management at HCL TECHNOLOGIES LTD.Assistant Manager-Strategic Bid Management at HCL TECHNOLOGIES LTD.