AISHANI SAHU
Gurugram
Summary
Experienced Data Analyst skilled in automating reports, optimizing workflows, and generating insightful analyses using Power Query, Power BI, and advanced Excel. Proficient in project management software and adept at translating data into actionable recommendations to drive efficiency and revenue growth. Expertise in Google Analytics, Zoho CRM, and Google Tag Manager for website data analysis and optimization.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Sr. Data Analyst
Decision Point Pvt Ltd.
Gurugram
11.2023 - Current
- Automated Engagement Managers report using Power Query and Power BI, facilitating efficient communication with stakeholders regarding resource utilization and project allocations across the company.
- Generated comprehensive Projects Health Scorecard to provide the CEO with insights into project statuses, identifying delays and revenue leakage issues.
- Created Gross Margin report with Gantt charts and waterfall charts on a quarterly and monthly basis, enabling strategic decision-making.
- Utilized PRM software for project management purposes, optimizing workflows and enhancing project efficiency.
- Developed fully automated Project Report using Power Query and Power BI, improving data accuracy, and streamlining project management processes.
- Leveraged advanced Excel functionalities, including Power Query and M language, to manipulate data and optimize workflows, resulting in a remarkable 35% increase in overall project efficiency.
- Managed project discrepancies and ensured meticulous data accuracy, enhancing project management processes.
- Initiated biweekly updates with the leadership team for effective communication and project alignment.
- Proactively resolved 85% of project issues, contributing to smoother project execution and operational efficiency.
- Implemented innovative strategies to identify and optimize underutilized talent, driving a measurable 15% increase in resource efficiency and project productivity.
- Spearheaded the creation of insightful reports and visually appealing dashboards using Excel, enhancing decision-making processes by 25%.
• Translated data insights into actionable recommendations, improving stakeholder satisfaction by 30% and facilitating informed decision-making.
• Developed customer service management analysis reports, including CHS, NPS, and CSAT, to provide insights into customer satisfaction and drive improvements.
Data Analyst
Real Time Data Services
Gurugram
11.2022 - 11.2023
- Leveraged Google Analytics to conduct in-depth analysis of website data, resulting in a remarkable 55% increase in website traffic.
- Extracted actionable insights that informed strategic decisions, leading to a 20% improvement in conversion rates.
- Implemented data collection and management procedures on Zoho CRM, achieving an outstanding 90% improvement in data accuracy.
- Streamlined tracking accuracy through Google Tag Manager and custom event tracking, ensuring 95%+ data accuracy.
- Successfully implemented and configured Google Analytics 4 (GA4) for accurate and comprehensive data tracking across multiple platforms and devices.
- Developed customized event tracking and enhanced measurement strategies, capturing user interactions for a holistic view of user behavior.
- Transformed data into captivating dashboards using Data Studio & Power BI, leading to a 7% increase in top-line revenue, a 25% decrease in the sales cycle, and a 15% increase in customer positive sentiment.
- Integrated A/B testing strategies to optimize website traffic, user behavior, landing pages, and conversions.
- Utilized Mouseflow analysis to gain insights into user behavior and enhance user experience, resulting in a 50% surge in website traffic.
- Implemented data-driven strategies to optimize marketing campaigns, resulting in a 7% increase in conversion rates, a 20% reduction in acquisition costs, and a substantial $4000/month boost in recurring revenue.
- Conducted customer segmentation analysis to identify target audience segments.
- Identified key areas for product and service improvements based on customer feedback.
- Proficient in Google Analytics, conducting detailed analysis to transform raw data into actionable insights. Specialized in BigQuery for GA4 data analysis, efficiently linking to GA4 for comprehensive insights.
Assistant Analyst
Spend Cubes LLC
Delhi
10.2021 - 11.2022
- Conducted thorough Invoice Audits using Excel and MySQL, leading to identifying revenue leakage of $2.5 Million Annually, reduce in Associated Cost by 65%, and yielding Annual Savings of $1.2 Million
- Utilized Predictive Analytics techniques to identify potential Cost-Saving opportunities for clients, leading to an increase in Client Satisfaction and Retention
- Developed Compelling Tableau Dashboards, delivering Insightful Data Representations, Actionable Insights & Personalized Recommendations
- Streamlined telecom billing analysis, invoice auditing, and payment tracking processes, reducing errors and discrepancies.
Education
High School Diploma -
Jugal Devi Saraswati Vidya Mandir
01.2014
MBA - Marketing Communications & Business Analytics
Fortune Institute of International Business
New Delhi06-2021
MCOM - Marketing
Vikramajit Singh Sanatan Dharma College
Kanpur05-2019
BCOM - Finance
Vikramajit Singh Sanatan Dharma College
Kanpur06-2017
Skills
- Data Analysis - MySQL, R Studio, Power Query
- Data Visualization - Tableau, Power BI
- Data Management - Collection, Cleaning, Munging
- Google Analytics 4 & Google Tag Manager
- Business Intelligence - Big Query, Data Studio
- Market Research - Market trends and analysis
- Project Management - Project Planning, Resource Allocation, Project Management
- Customer Service Management - Feedback Analysis, Behavior Analysis
- Power Query
- Predictive Analytics
- Advance Excel
- SPSS
Internship
- Business Development, Tekie, Mar 21 - May 21, Identified Target Audience Segments & Developed Impactful Marketing Strategies, Executed Social Media Campaigns & Collaborated on Fundraising Events
- Corporate Internship, Peer Spot, Apr 20 - June 20, Strategized Digital Presence and expanded Consumer Base
- Social Internship, Friend & Smile Foundation, Sep 19 - Oct 19, Leveraged Digital Marketing to Enhance NGO's Online Presence
Certification
- The Business Intelligence Analyst Course 2023
- SQL - MySQL for Data Analytics and Business Intelligence
- Master Google Analytics 4 Reports and GTM Basics in 2023
- Excel Power Query like an Expert from the Start! Solve Difficult Data Analysis Problems.
- The Complete Python Bootcamp From Zero to Hero in Python.
- Skills for Microsoft PL-300 certification using the free Power BI Desktop. Power Query, DAX, M, more
Project
- Led comprehensive analysis of business opportunities presented at CAGNY conference.
- Collaborated with cross-functional teams to identify key trends and insights from presentations.
- Synthesized findings into actionable recommendations for strategic decision-making.
- Presented insights to senior leadership, guiding discussions on potential growth areas and investment opportunities.
- Contributed to the development of company's long-term growth strategy based on CAGNY insights.
- Demonstrated strong analytical skills and strategic thinking in evaluating industry developments and their impact on company's business.
- Highlighted ability to communicate complex ideas effectively and influence decision-making processes.
Timeline
Sr. Data Analyst
Decision Point Pvt Ltd.
11.2023 - Current
Data Analyst
Real Time Data Services
11.2022 - 11.2023
Assistant Analyst
Spend Cubes LLC
10.2021 - 11.2022
High School Diploma -
Jugal Devi Saraswati Vidya Mandir
MBA - Marketing Communications & Business Analytics
Fortune Institute of International Business
MCOM - Marketing
Vikramajit Singh Sanatan Dharma College
BCOM - Finance
Vikramajit Singh Sanatan Dharma College
- The Business Intelligence Analyst Course 2023
- SQL - MySQL for Data Analytics and Business Intelligence
- Master Google Analytics 4 Reports and GTM Basics in 2023
- Excel Power Query like an Expert from the Start! Solve Difficult Data Analysis Problems.
- The Complete Python Bootcamp From Zero to Hero in Python.
- Skills for Microsoft PL-300 certification using the free Power BI Desktop. Power Query, DAX, M, more
Similar Profiles
Shubhanshu ManiShubhanshu Mani
Data Engineer at Decision Point AnalyticsData Engineer at Decision Point Analytics
ASEER JESAN AASEER JESAN A
Senior Data Engineer at Decision PointSenior Data Engineer at Decision Point
Jithesh JanardhananJithesh Janardhanan
Analytics Consultant at Decision Point AnalyticsAnalytics Consultant at Decision Point Analytics