Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic

AMRITPAL SINGH

Toronto,ON

Summary

Committed and results-oriented Data Analyst with over 6 years of experience in deriving actionable insights from intricate datasets. Highly skilled in data analysis, statistical modeling, and visualization, utilizing these competencies to drive data-informed decision-making. Experienced in using Python, R, SQL, Tableau, and Excel to develop comprehensive reports, analytics, and data mining solutions. Expertise in creating data visualizations using Python, Power BI, and Google Sheets, tailored to meet business objectives. Mastery in Excel and MS Access for efficient data management and analysis. Adept at data wrangling and analysis using Python libraries such as NumPy, Pandas, Matplotlib, SciPy, and ggplot2. Competent in exploratory data analysis, predictive modeling (Python), and data visualization (Power BI). Extensive hands-on experience with Git, GitHub, Jira, and the MS Office suite. Proficient in MySQL, NoSQL databases, Hadoop, Hive, Spark, and proficient in building ETL pipelines using Apache Airflow. Strong background in AWS and Google Cloud. Experienced in Shell Scripting (Linux) and proficient in using Git for version control. Developed Tableau dashboards for reporting and data visualization, enhancing informed decision-making processes for various stakeholders. Designed, developed, and monitored Key Performance Indicators (KPIs) through dashboards. Successfully translated business requirements into technical specifications, facilitating data aggregation from multiple sources for strategic decision-making. Extensive experience in stakeholder engagement, leveraging strong communication and interpersonal skills. Quick to learn and highly independent, demonstrating effectiveness in working under pressure. Proven ability to adapt and remain flexible when working on large projects with tight deadlines. Strong interpersonal, problem-solving, and analytical abilities, with a demonstrated capacity to influence outcomes. Meticulous attention to detail, with a strong ability to prioritize and validate requirements through effective customer communication. Excellent written and verbal communication skills, essential for facilitating decision-making processes. Highly proficient in working with Microsoft technology tools such as Microsoft Word, PowerPoint, Excel, Teams, and more.

Overview

6
6
years of professional experience

Work History

Sr. Data Analyst

HUDSON BAY
06.2022 - Current
  • Implemented Waterfall methodologies within the SDLC, ensuring strict configuration management and compliance with industry standards
  • Boosted data-driven decision-making through the creation of capacity planning reports using Python's NumPy and Matplotlib
  • Utilized R for statistical analysis, performing hypothesis testing to validate data and deliver precise interpretations
  • Transformed reporting capabilities by designing targeted Power BI dashboards, significantly enhancing data presentation efficiency
  • Managed user-friendly database applications using MongoDB, ensuring enhanced flexibility and scalability
  • Successfully orchestrated the consolidation of data into a SQL Server data warehouse, promoting consistency and accessibility
  • Leveraged advanced Excel functionalities and Power Pivot for statistical modeling, providing valuable insights into outpatient authorization submissions
  • Led the implementation of GraphQL for streamlined querying, optimizing data retrieval processes
  • Designed and implemented an innovative Evaluation Plan, integrating automation tools such as Jenkins for efficient data collection and analysis
  • Adopted DevOps practices by utilizing Docker for containerization and Kubernetes for orchestration, thereby streamlining the deployment process
  • Directed a data quality improvement initiative, establishing data governance practices and conducting regular audits to ensure accuracy
  • Collaborated closely with external vendors, managing data integrations and ensuring seamless interoperability with third-party systems
  • Oversaw the migration of on-premises databases to cloud-based solutions, leveraging Amazon RDS and Azure SQL Database for enhanced scalability and reliability.

Data Analyst

Rogers
06.2020 - 09.2022
  • Developed and implemented a comprehensive data cataloging system, significantly enhancing metadata management and improving data discoverability
  • Led the implementation of a real-time data processing system using Apache Kafka, enabling immediate insights into critical business events
  • Utilized Tableau to clean and analyze extensive pricing and financial datasets, creating visualization reports that extracted actionable insights
  • Supported stakeholders in monitoring business performance and developing effective pricing strategies, resulting in a 15% revenue increase
  • Developed a data cleaning system using Python scripts, streamlining the process and achieving a 30-fold increase in productivity
  • Conducted customer segmentation across five sectors, providing key insights into target markets that drove business growth for stakeholders
  • Performed in-depth statistical analysis on client feedback to efficiently identify operational issues
  • Further refined and trained a machine learning model on current data to automatically flag potential issues
  • Leveraged advanced Python libraries such as Scrapy for web scraping, expanding data sources and enhancing the depth of analysis
  • Designed and delivered both standard and custom report dashboards (Power BI, Excel) for internal and external stakeholders.

Jr. Data Analyst

Sunlife Insurance
05.2018 - 05.2020
  • Led the implementation of advanced SQL queries, optimizing database management for faster data retrieval
  • Applied A/B testing and statistical techniques to refine marketing strategies and enhance data-driven optimizations
  • Directed the development of ETL pipelines using AWS Glue and Apache Spark, streamlining data integration and processing with cost-effective solutions
  • Strategically extracted, transformed, and analyzed data to leverage insights that informed and drove solution-oriented decisions
  • Identified and interpreted complex trends and patterns within intricate datasets, using this analysis to proactively address challenges and optimize outcomes
  • Utilized Power BI to design dynamic dashboards and reports, equipping stakeholders with visually compelling and actionable information
  • Collaborated effectively within cross-functional teams, employing Agile methodologies for efficient project execution.

Education

Post Graduation - Project Management

Humber College
Toronto
04.2018

Bachelors of Technology - Computer Science

Punjab Technical University
04.2017

Skills

  • SQL
  • Python
  • Power BI
  • Azure Synapse Analytics
  • Azure Data Factory
  • SQL Server
  • T-SQL
  • SSRS
  • ETL
  • SSIS
  • SSAS
  • MS Azure Cloud services
  • ASP NET
  • MS Excel
  • Communication Skills
  • Problem Solving
  • Financial Analysis
  • Project Planning
  • Time Management

Timeline

Sr. Data Analyst

HUDSON BAY
06.2022 - Current

Data Analyst

Rogers
06.2020 - 09.2022

Jr. Data Analyst

Sunlife Insurance
05.2018 - 05.2020

Post Graduation - Project Management

Humber College

Bachelors of Technology - Computer Science

Punjab Technical University
AMRITPAL SINGH