Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic

VIJETHA VINAY VARAD

Toronto

Summary

With over 3+ years of expertise in data analytics, I am proficient in SQL, Excel, BigQuery, and Python, consistently delivering actionable insights. I excel in data manipulation, statistical analysis, and creating visually compelling dashboards using Tableau, Power BI, QlikView, and Looker. My skills in Power Query and DAX enable seamless data integration and transformation, while VBA automation drives operational efficiency. Experienced in utilizing SSIS and SSRS for data workflows and reporting, I also implement machine learning solutions with Scikit-learn and TensorFlow for predictive analytics. My advanced SAS programming capabilities, ERP system integration expertise, and cloud infrastructure management on GCP enhance data accuracy and performance. I am committed to Agile methodologies, ensuring efficient project delivery and continuous improvement.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Data Analyst

Google, Canada
01.2023 - Current
  • Acquired data from primary or secondary data sources and maintained databases/data systems, identified, analyzed, and interpreted trends or patterns in complex data sets
  • Developed analysis trends along with visualizations for customer data analytics, showing insights to improve future revenues using SQL, Python
  • Composed complex SQL queries utilizing various features such as joins, aggregate functions, subqueries, and set operations to retrieve and manipulate data
  • Performed data management projects and fulfilled ad-hoc requests according to user specifications by utilizing data management software programs and tools like Google Sheets and SQL
  • Executed the design, development, and maintenance of ongoing metrics, reports, analyses, and dashboards, using Tableau to drive key business decisions
  • Developed and transitioned from Google Sheets to data-driven dashboards in Looker Studio, enabling stakeholders to track key performance indicators and make informed decisions to enhance application performance
  • Assessed the quality, accuracy, and bias of the generated output. Made sure that the generated output aligned with the respective product policies and evaluation metrics.
  • Utilized Google Cloud Platform’s Big Query database to construct SQL statements for querying datasets, facilitating in-depth data analysis, and delivering actionable insights to stakeholders.
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
  • Utilized data visualization tools to effectively communicate business insights.
  • Developed data mining algorithms to identify and classify patterns in data.
  • Collaborated with stakeholders to identify business needs and data sources.
  • Generated standard and custom reports to provide insights into business performance.
  • Developed and implemented data governance policies and procedures.
  • Designed and developed data pipelines to acquire, clean and process data.
  • Created dashboards to monitor and track key performance indicators.
  • Developed complex dashboard and reporting tools to track business performance metrics.
  • Identified patterns and trends in large data sets and provided actionable insights.
  • Developed and maintained data warehouses and data marts to support business operations.
  • Analyzed data to identify root causes of problems and recommend corrective actions.
  • Implemented business intelligence solutions to increase operational efficiency.
  • Developed customized reports, summarizing and presenting data in visually appealing format.
  • Assisted with creating data cubes and OLAP models to improve data analysis.
  • Used statistical methods to analyze data and generate useful business reports.

Power BI Analyst

Canada Life, Canada
02.2021 - 01.2022
  • Delivered the analysis of complex datasets using Power BI, SQL, Excel, and Python, worked on data cleaning, and unlocked invaluable insights, to increase operational efficiency
  • Developed dynamic, visually compelling reports and dashboards in Power BI, becoming the cornerstone for data-driven strategic decisions and improving decision-making efficiency
  • Optimized SQL queries to significantly improve execution speed, enhancing the efficiency of data extraction from various databases.
  • Involved in defining key performance indicators KPI and developing BI strategies, in designing and developing dashboards, alerts, and reports.
  • Responsible for measuring, developing, and monitoring reports on key performance metrics to support the planning and execution of assessments and compliance audits
  • Designed and improved ETL processes within the data warehouse, significantly enhancing data integration efficiency and supporting continuous data management optimization
  • Worked on ERP system integration and optimization, improving data analysis and reporting accuracy, and facilitating strategic decision-making and operational enhancements
  • Worked on advanced Excel functionalities, including pivot tables and DAX Data Analysis Expressions, to analyze and visualize complex data, enabling informed decision-making and process optimization
  • Provided technical support for troubleshooting analytics and reporting issues.
  • Optimized data access and storage to improve performance of analytics systems.
  • Analyzed data to identify root causes of problems and recommend corrective actions.
  • Collaborated with stakeholders to identify business needs and data sources.
  • Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
  • Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.
  • Created data analysis tools to allow teams to query acquired information for unique details.
  • Designed customized data collection models for specific visualization tasks.
  • Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes.

Education

MBA - Finance and Marketing

Acharya Bangalore Business School
India
12.2020

B. Tech -

BV Bhoomaraddi College of Engineering
India
06.2018

Skills

  • Data Visualization: Tableau, Power BI, Looker
  • Programming & Scripting: SQL, Python, VBA, SAS
  • Spreadsheet Proficiency: Advanced Excel, VLOOKUP, Pivot Table, Macros
  • Data Analysis & Modeling: Num Py, DAX, Pandas, Power Query, Machine Learning Models
  • Data Management: SSIS, SSRS, Snowflake, MS SQL Server
  • Customer Relationship Management: CRM Software
  • Enterprise Resource Planning: ERP Systems/ SAP
  • Data Transformation: ETL Tools, Azure
  • Atlassian tools: Jira, Confluence
  • A/B testing
  • Problem-solving
  • MS Excel
  • Database programming and SQL
  • Tableau

Certification

  • PL-300 Microsoft Power BI Data Analyst Associate Certification
  • TDS-C01 - Tableau Desktop Specialist Certification

Timeline

Data Analyst

Google, Canada
01.2023 - Current

Power BI Analyst

Canada Life, Canada
02.2021 - 01.2022

MBA - Finance and Marketing

Acharya Bangalore Business School

B. Tech -

BV Bhoomaraddi College of Engineering

Similar Profiles

CREATE PROFILE
VIJETHA VINAY VARAD