Jatin Grover
Vaughan,ON
Summary
Enthusiastic and results-driven Business Intelligence Analyst with a proven track record of leveraging data analytics to drive strategic business decisions. Adept at transforming ambiguous business requirements into actionable insights, I thrive in dynamic environments and excel in developing innovative solutions to complex problems.
Overview
7
7
years of professional experience
Work History
Business Intelligence Analyst
Wasteco
10.2021 - Current
- Developed and maintained business intelligence reports and interactive dashboards using Power BI, providing stakeholders with actionable insights
- Statistical analyzed customer data to identify trends and provide insights to the marketing team
- Designed and developed complex SQL queries and stored procedures for data extraction, transformation, and loading
- Collaborated closely with cross-functional teams to understand ambiguous business challenges and develop customized analytics solutions to address them
- Participated in database backup and recovery activities to ensure data availability and integrity
- Developed and maintained ETL (Extract, Transform, Load) processes to ensure data accuracy, integrity, and accessibility
- Managed and monitored Microsoft Azure cloud infrastructure, ensuring optimal performance and high availability
- Implemented and maintained Azure Virtual Machines, Virtual Networks, and Azure Active Directory services
- Administered Azure SQL Databases and ensured data integrity and security
- Managed IT projects from planning to implementation, ensuring timely delivery and adherence to budget.
IT Specialist
YWCA
01.2021 - 10.2021
- Primarily provides phone and email support to end-users (staff and clients) on software and hardware-related issues; provides in-person support, as required
- Troubleshoots software/hardware for staff and client workstations
- Provides ongoing maintenance of all workstations (e.g., patches, updates)
- Maintains the configuration of workstations to ensure network security
- In conjunction with Senior IT Administrator, administers and supports client control software, troubleshoots network connectivity outages
- Maintains records of upgrades, updates, maintenance repairs and ISP service outages.
Systems Specialist
D4 Logistics Inc
09.2017 - 07.2020
- Enhanced the process of viewing reports in an effective manner by creation of real-time dashboards using MS Power BI tools to identify and analyze the company's KPI
- Delivered data analysis projects using advanced features in MS Power BI, automated ETL DAX functions pipelines on SQL server, leading to increase of business revenue
- Enhanced business and competitive edge by providing Analytics and Reporting Dashboards on customers and drivers data, using SQL, and PowerBI on a MySQL database
- Experience with daily monitoring of Qlik Sense app reloads and familiar with QlikView
- Analyzed data in revenue, profit, opportunity, and risks from different dimensions by time, product, channel, account, etc
- Ensured the quality of analysis and data accuracy and demonstrated results to management
- Streamlined the complex database models and defined relational database, wrote custom queries and calculations to get required data columns
- Created reports, dashboards and connected the report database with SQL Server for real time updates
- Performed database administration, data analysis, advance Excel reporting using formulas and pivot tables.
Internal IT Support (Co-op Internship)
D4 Logistics Inc
05.2017 - 08.2017
- Provided technical solution and level 1 IT support to the team members during office hours
- Inside support for Office 365 for setting up of new profiles, instant messaging, calls, web meetings, sharing documents, managing users, setup permissions and organize e-mails
- Created call flow diagram (flow chart) from existing VOIP call system
- Created workflow related documents and presentations using MS Word and PowerPoint
- Provided functional and technical support, troubleshoot network issues related to TCP/ IP and DNS, based on hardware and software levels.
Education
Advanced Diploma - Cloud Computing For Big Data
Lambton College of Applied Arts And Technology
Toronto, ON08.2017
Bachelor of Science - Information Technology
Punjab Technical University
Punjab, India06.2013
Skills
- Business Intelligence Tools: Power BI, QlikView, Tableau
- Statistical Analysis: Regression Analysis, Hypothesis Testing
- ETL Development and Data Visualization
- Microsoft Azure administration and management
- Ability to translate complex data into actionable insights
- Knowledgeable in IT systems management and implementation, including project management, database administration, and network administration
- SQL Programming
- Problem Solving
- Documentation
References
Available upon request.
Languages
English
Full Professional
Hindi
Native or Bilingual
Timeline
Business Intelligence Analyst
Wasteco
10.2021 - Current
IT Specialist
YWCA
01.2021 - 10.2021
Systems Specialist
D4 Logistics Inc
09.2017 - 07.2020
Internal IT Support (Co-op Internship)
D4 Logistics Inc
05.2017 - 08.2017
Advanced Diploma - Cloud Computing For Big Data
Lambton College of Applied Arts And Technology
Bachelor of Science - Information Technology
Punjab Technical University
Similar Profiles
Devon ToddDevon Todd
Industrial Technician at WasteCoIndustrial Technician at WasteCo
Trevor AntoineTrevor Antoine
Service Technician at WastecoService Technician at Wasteco
Melody TullioMelody Tullio
Sales Consultant Representative at WastecoSales Consultant Representative at Wasteco