Data Analyst

Keneel Shah

************@*****.*** 226-***-**** Toronto, ON github.com/keneelshah1

linkedin.com/in/dakeneel

PROFILE

•Analytical and detail-oriented Data Analyst, excelling in deriving meaningful insights from complex datasets. Skilled in data analysis, statistical modeling, and visualization.

•Proficient in programming languages and tools such as Python, SQL, Power BI, and Excel.

•Specializes in developing various reports, analytics, and data mining solutions, generating data visualizations with Python, Power BI, and Google Sheets. Extensive experience using Excel and MS Access for data dumping and analysis based on business requirements.

•Well-versed in a Python-based environment, encompassing data analytics, data wrangling, and Excel data extracts, with familiarity in libraries such as NumPy, Pandas, Matplotlib, SciPy, and ggplot2. PROFESSIONAL EXPERIENCE

Data Analyst

Walmart Canada

May 2023 – present

•Gathered and documented business requirements from stakeholders, defining key metrics and KPIs for analytics projects. Maintained a comprehensive data dictionary and job aids for team use.

•Developed detailed inventory and digital marketing dashboards in Power BI, providing stakeholders with actionable insights into key metrics, which significantly improved decision-making accuracy.

•Utilized Python, SQL, and R to analyze extensive datasets, identifying trends, patterns, and insights.

•Collaborated in the implementation of advanced SQL queries, optimizing database management for faster data retrieval.

•Provided ad hoc analytics support, maintained automated dashboards, and implemented enhancements, ensuring stakeholders had timely and accurate insights for informed decision-making.

•Automated inventory management reporting by extracting, transforming, and loading data from Snowflake using SQL, enabling real-time tracking and optimization of inventory metrics.

•Streamlined digital marketing reporting by automating data extraction from Snowflake, preprocessing with SQL and Python, and visualizing campaign effectiveness through dynamic Power BI dashboards. Data Analytics Co-op

Bell Canada

Jan 2023 – Apr 2023

•Utilized advanced Python libraries such as Scrapy for web scraping, expanding data sources and enriching analyses.

•Developed standard and custom report dashboards using Power BI and Excel for both internal and external stakeholders.

•Leveraged Power Query (ETL) to extract data from diverse sources including XLSX, CSV, TSV, and databases.

•Created dashboards and reports to illustrate differences between actual and target production using KPIs in Power Pivot.

•Provided recommendations for tactics and strategies based on data insights derived from key results and findings.

•Developed simulation models for operational facilities to optimize production processes.

•Created data visualization reports and presentations for management decision-making

•Monitored and evaluated reservoir performance.

EDUCATION

Masters of Applied Computing

University of Windsor

May 2023

Bachelors of Computer Science

Gujarat Technological University

Jul 2021

SKILLS

•Data Cleaning, Data Manipulation, Data Mining, Data Extraction, Data Reporting, Data Visualization, Data Wrangling, Data Modelling, Ad Hoc Report, EDA

•ETL, Data Pipelines Design and Development, SQL & NoSQL Database Design and Development

•Data Warehousing, Data Lake Development & Implementation

•Analytics, Business Intelligence

•Communication Skills, Problem Solving, Financial Analysis, Project Planning, Time Management TOOLS AND TECHNOLOGIES

Programming Languages: C, C++, C#, Java, Python, JavaScript, SQL, PL/SQL Reporting tools: MS Project, MS Office, MS SharePoint, MS Visio, MS Word Visualization Tools: Tableau, Power BI, Microsoft Excel Database: MS SQL, MySQL, MongoDB, NoSQL

Frameworks: ASP .NET MVC, Django, Bootstrap

Platform: Google Cloud Platform (GCP), Microsoft Azure, AWS (EC2, S3, RDS), Google analytics Methodologies: Agile Software Development, Waterfall, SDLC Analysis: Cost/benefit analysis, GAP analysis, Risk analysis, Impact analysis, SWOT analysis Testing: Apache JUnit, Postman

Other Tools: Git, JIRA, Microsoft Office Suites, Apache Kafka Operating Systems: Windows, MacOS, Linux

Contact this candidate