Digital Analyst

BHAVYA AHUJA

Halifax, Canada 902-***-**** ******.*****@*****.*** LinkedIn

Self-motivated professional proficient in providing optimal data-based solutions through advanced tools, technologies, root cause analysis, and deep-dive analysis on large data sets. Well-versed in digital analytics implementation, marketing campaign optimization, visualization tools, project management, and solving challenging problems. Effective team player empowers personnel to improve performance and overall organizational growth. Demonstrates a strong commitment to staying ahead of the curve by continuously learning and adapting to new technologies and data analysis tools to enhance business growth.

Key Core Competencies:

Solution provider to deliver cost-effective data-driven solutions per business needs to overcome challenges.

Expertise in data analysis, business analysis, documentation, reporting, and process improvement.

Hands-on experience in digital platforms, implementing analytics solutions, and data collection processes.

Capable of providing actionable insight to enhancing decision-making, business performance, and operational efficiencies.

Proficient in data analysis, data modeling, data visualization, data extraction, data mining, and reporting.

Completed various projects while managing plans, schedules, risks, resources, and deadlines in an agile environment.

Collaborative team player and communicate effectively within a team in a fast-changing environment.

Possess written & verbal communication, presentation, analytical thinking, decision-making, and problem-solving skills.

High sense of accountability, professional integrity, and strong Interpersonal skills with the ability to work independently and quickly digest new information.

Technical Skills

Python JavaScript SQL HTML Google Tag Manager Google Analytics GA 360 GA4 Matomo Analytics

Tableau MySQL Looker Studio MS Excel MS PowerPoint Tag Management Web Analytics Data Layer

Professional Experience

Sr. Digital Implementation Specialist Questrade INC, Toronto May 2023 - Nov 2023

Spearheaded projects across the life cycle and digital platforms by translating business needs into measurable digital KPIs, analytics implementation, and data collection processes automation to achieve a productivity of 40%.

Performed data manipulation, interpretation, and analysis of complex data sets, led to a 30% improvement in driving actionable insights regarding online tools and websites & digital marketing campaign performance.

Managed all aspects of project planning, requirements gathering, execution, and implementation, as well as established milestones per resources, strategic goals, and business initiatives that accelerated project completion by 60%.

Produced data, models, analytics, and reports per project requirements that enhanced the decision-making process.

Led the migration process of the QuestMortgage section to GA4 from GA 360 using project management strategies, streamlined data collection and tagging architecture, and created comprehensive GTM tracking documentation.

Collaborated with cross-functional teams to understand business requirements & processes and translate them into technical specifications to define analytics requirements, resulting in an improvement in delivery effectiveness.

BI Technical Specialist Resulta, Bedford Nov 2019 - May 2023

Transformed business requirements into technical specifications and standardized reporting within Google Analytics to drive insight to present business leaders and improved quality metrics that enhance business growth by nearly 50%.

Identified trends & opportunities within large data sets and made recommendations for improvement in analytics.

Implemented and managed Google Tag Manager for over 150 client websites, automating data collection and increasing efficiency. Trained technical specialists on best practices to enhance team performance and processes

Leveraged Looker Studio and Excel to generate reports, valuable insights, and data visualization on digital marketing campaign performance to optimize digital experiences and inform business decision-making.

Utilized HTML and JavaScript to elevate tag management and data collection processes through innovative tag implementation and data layer solutions that boosted a 70% improvement in digital asset tracking.

WordPress Developer Green Apple Solutions PVT LTD, India Mar 2017 - Sep 2018

Built client websites with WordPress, HTML, CSS, PHP, and Bootstrap 3 framework and enhanced code if required.

Implemented WooCommerce platform and integrated PayPal, PayU Money, shipping, and invoicing to boost functionality.

Analyzed business requirements and client needs to deliver cost-effective solutions to meet client’s expectations.

Projects

Data Integration Project Predicting Absenteeism at Work Present

Utilized Python in Jupyter Notebooks to perform data preprocessing and cleaning of employee working hour data.

Performed data migration from Jupyter Notebook to SQL Workbench and exported it as a CSV to build a Tableau dashboard to visualize the outcomes for business case analysis.

Predicted employee number of hours absenteeism in a workday that enhanced workplace productivity and efficiency.

Salary Equity Analysis across Departments Used SQL & Tableau Present

Analyzed salary data up to 2002 to assess compensation equity between male & female employees across all departments.

Developed an SQL stored procedure to compute average salaries categorized by gender within user-defined salary ranges.

Utilized Tableau to create double bar charts for comparative analysis to visualize the average salary differentiation by gender across departments by years.

YouTube Audience Analysis Project Used Python & Jupyter Notebook Present

Conducted analysis of YouTube comments to analyze audience sentiments and emojis on videos with data visualization.

Identified trends in engagement metrics across video genres and used linear regression models to deliver valuable insights.

Stock Price Analysis Used Python & Jupyter Notebook Present

Conducted stock price analysis movements to determine long-term trends & patterns for effective trading decisions.

Utilized correlation analysis by comparing prices of related stocks to identify performance and investment opportunities.

Monthly Sales Analysis Used Python & Jupyter Notebook Present

Analyzed monthly sales data using various tools to generate insights that support optimizing business models.

Evaluated data to identify the highest sales volume product and examined sales improving factors than other products.

Twitter Data Project using Airflow, Python and AWS Present

Utilized Python for data preprocessing, including data extraction, data cleaning, and data manipulation.

Transformed data, deployed the code on Airflow/EC2, and stored the final results on Amazon S3 to build a data pipeline.

Education

Master of Science, Computing and Data Analytics Saint Mary's University Sep 2018 - Dec 2019

Related Coursework: Database Management Systems Business Intelligence UI/UX Design Web, Mobile and Cloud App Development

-Participated in a Data Visualisation competition organized by the University of New Brunswick.

-Visualised the flood-prone areas of New Brunswick using Tableau and made recommendations based on the intensity of flood in each area, e.g. installing a small hydropower plant.

Contact this candidate