Power BI
Years of professional experience
Satender Kumar
Data Analyst
London,ON
Summary
🔐"Certified Data Analyst | Python, SQL, R | Excel, Power BI & Tableau Specialist | Transforming Data into Actionable Insights | Proven Efficiency Booster | Data-Driven Decision | 📊 👨🏻💻
Skills
- Programming: Python (Pandas, NumPy, Matplotlib, Seaborn, SciPy, NLP, NLTK, XAI), SQL (MySQL, PostgreSQL, Oracle Database, AWS), R (ggplot2, dplyr, tidyr), SAS, SPSS
- Data Visualization Tools: Power BI, Excel, Tableau, Cognos Analytics
- Statistical Analysis: Hypothesis Testing, Distributions, Regression (EDA, CDA)
- Business Acumen: Strong understanding of business objectives and aligning data insights with organizational goals
- Leadership: Experienced in leading teams, mentoring analysts, and fostering a data-driven culture
- Certified: Microsoft (DP-900, DP-300, PL-300), CompTIA Data, LinkedIn, IBM, Tableau Specialisation, MS-Office
- Additional Skills: Git/GitHub, Cloud Platforms (Azure), Data Lakes, Data Warehouses
- Core:- Partner with organizations to leverage data as a strategic asset, Solve complex business challenges through data-driven insights & Collaborate to build data-driven solutions that deliver results
Overview
2
2
50
50
Certification (Microsoft, Google, Coursera, IBM)
10
10
Certified: Microsoft (DP-900, DP-300, PL-300), CompTIA , More
47
47
Certification on LinkedIn
8
8
Projects on Profile (LinkedIn)
Education
Diploma in Business Marketing - Business Analysis And Process Management
Fanshawe College
London, ON 01.2021 - 04.2023
Associate of Applied Science - Advanced Computer Applications And Programming
Hartron Skill Center
India 08.2018 - 07.2019
Certified - Data Analytics
Microsoft, Google, Coursera, IBM, Linkedin
Canada07-2024
Work History
Security Operations
Paladin Security - Workplace Safety and Insurance Board (WSIB)
London, Ontario
10.2023 - Current
- Utilized C-Cure 9000 to effectively oversee front desk operations and access management while reinforcing security protocols and optimizing anomaly tracking.
- Automated data collection and executed ETL processes, boosting efficiency by 20% and ensuring high-quality datasets for analysis.
- Employed advanced Excel functions (VLOOKUP, pivot tables) and utilized Power BI and Google Workspace to streamline workflow, create reports, and analyze security data.
- Optimized SQL queries, reducing processing times by over 50% and improving database efficiency, contributing to a 30% increase in overall operating efficiency.
Data Analyst Intern
McKinsey & Company
London, Ontario
01.2023 - 10.2023
- Reduced product return rates by 24% through data-driven analysis and corrective actions. Implemented customer segmentation strategies using SQL and Excel, improving stock clearance and sales efficiency.
- Led market trend analysis for over 50 brands, driving a GMV increase of 27 million dollars through strategic insights. Conducted inventory analysis using Excel to optimize stock levels, resulting in a 12% revenue growth.
- Automated performance tracking dashboards with Viz, supporting a 17% revenue boost through enhanced reporting. Streamlined SQL queries resulting in more than 50% decrease in processing times and enhanced database performance.
- Conducted TD discount analysis to boost inventory liquidation by 27% and enhance ad campaign ROI by 9% through data analysis and advertising campaigns across platforms ( AppNexus and Google DBM) increasing ROI and campaign efficiency.
- Created automated KPI reports in Excel and Power BI, boosting efficiency by 20%. Executed ETL processes, including data cleaning and preprocessing with Python and SQL, ensuring high-quality datasets for analysis and decision-making, and increasing customer engagement.
Technical Support Associate
Lenovo India
Dehradun, Uttarakhand, India
01.2017 - 02.2019
- Delivered 99.9% expert support for hardware, peripherals, and software, resolving internet connection issues, and invoice difficulties. Provided technical assistance to over 2,000 Plus systems, ensuring high standards of service.
- Handled 20+ support tickets daily with a 99.8% success rate, implementing best practices that reduced resolution time by 30%.
- Created and assigned tickets for integration issues, bugs, and defects. Investigated, documented and tested unusual behavior to ensure quality assurance in QA, pre-production and live environments.
- Designed and launched an online query tool that enabled remote troubleshooting, reducing technician travel costs by 40%. Suggested and supported IT hardware and accessory procurement, cutting unnecessary purchases by 60%. Provided remote support using TeamViewer, VNC Server, Ammyy Remote Software, and remote desktop tools.
Certification
- IBM Data Analyst Specialization
- Microsoft Power BI Data Analyst (Business) - PL-300
- Tableau & Cognos Analytics Specialization
- Master - Python SQL,Power BI, Excel ( LinkedIn L)
- CompTIA A+, Data, IFC+
- Microsoft - DP-900, DP-300,
Accomplishments
Project 1 :- Enhancing Sales Performance Insights with Tableau - California University - (May 2024)
- Developed interactive dashboards for sales performance.
- Integrated data from CRM and sales databases.
- Increased operational efficiency by 20%.
Skills: Tableau, Data Visualization, Data Integration, Dashboard Design
Project 2:- Market Trend Analysis - McKinsey & Company ( March 2023)
- Conducted regression analysis and hypothesis testing on market trends.
- Enhanced strategies for 50+ brands, boosting GMV by $27M.
Skills: Python, SQL, R, Data Cleaning, Statistical Analysis
Project 3:- Customer Segmentation & Campaign Tracking - McKinsey & Company (July 2023 )
- Segmented customers and tracked campaign performance with Power BI.
- Increased revenue by 17% and campaign ROI by 9%.
- Used Microsoft Excel to develop inventory tracking spreadsheets.
Skills: SQL, Excel, Power BI, Data Segmentation, Performance Tracking
Affiliations
- Authored over 10 blogs on data analysis industry trends on LinkedIn, reaching an audience of 80,000+ professionals.
- Delivered 80% presentations at industry conferences, improving engagement rates by 30% through effective communication.
Languages
- English
- Hindi
- Punjabi
References
References available upon request.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Work Preference
Work Type
Full TimeWork Location
On-SiteRemoteHybridImportant To Me
Career advancementWork-life balanceCompany CultureFlexible work hoursPersonal development programsTeam Building / Company RetreatsWork from home optionQuote
Business opportunities are like buses, there’s always another one coming.
Richard Branson
Software
Tableau
Jupyter Notebook
Microsoft Excel
Python
SQL
SAS & SPSS
Alteryx
QlikView
Interests
Data Science and Machine Learning
Data Visualization and Reporting
Business Strategy and Intelligence
Statistical Analysis
Database Management and Optimization
Automation and ETL Processes
Data-Driven Decision Making
Timeline
Security Operations
Paladin Security - Workplace Safety and Insurance Board (WSIB)
10.2023 - Current
Data Analyst Intern
McKinsey & Company
01.2023 - 10.2023
Diploma in Business Marketing - Business Analysis And Process Management
Fanshawe College
01.2021 - 04.2023
Associate of Applied Science - Advanced Computer Applications And Programming
Hartron Skill Center
08.2018 - 07.2019
Technical Support Associate
Lenovo India
01.2017 - 02.2019
- IBM Data Analyst Specialization
- Microsoft Power BI Data Analyst (Business) - PL-300
- Tableau & Cognos Analytics Specialization
- Master - Python SQL,Power BI, Excel ( LinkedIn L)
- CompTIA A+, Data, IFC+
- Microsoft - DP-900, DP-300,
Certified - Data Analytics
Microsoft, Google, Coursera, IBM, Linkedin
Similar Profiles
MANOELA DIASMANOELA DIAS
Case Manager - Short Term at WSIB - Workplace Safety and Insurance BoardCase Manager - Short Term at WSIB - Workplace Safety and Insurance Board
Suzannah ChristensenSuzannah Christensen
Administrative Clerk/Mail Machine Operator at Workplace Safety & Insurance Board, WSIBAdministrative Clerk/Mail Machine Operator at Workplace Safety & Insurance Board, WSIB
DIANNA DARWINDIANNA DARWIN
Nurse Consultant at Workplace Safety & Insurance Board, WSIBNurse Consultant at Workplace Safety & Insurance Board, WSIB