Jatin Grover

Jatin Grover

Business Intelligence Analyst
Canada
English, Hindi

About Me

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 acti…

Experience

Business Information Analyst

Wasteco
Oct 2021 - Present · 4 years 8 months

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.

Business Intelligence Analyst

Wasteco
Present

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

Primarily provided phone and email support to end-users (staff and clients) on software and hardware-related issues
Provided in-person support, as required
Troubleshot software and hardware for staff and client workstations
Provided ongoing maintenance of all workstations (e.g., patches, updates)
Maintained the configuration of workstations to ensure network security
Administered and supported client control software in conjunction with Senior IT Administrator
Troubleshot network connectivity outages
Maintained records of upgrades, updates, maintenance repairs and ISP service outages

Systems Specialist

D4 Logistics Inc

Enhanced the process of viewing reports 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
Enhanced business and competitive edge by providing Analytics and Reporting Dashboards on customers and drivers data, using SQL and PowerBI on a MySQL database
Monitored Qlik Sense app reloads daily
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 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, and advanced Excel reporting using formulas and pivot tables

Internal IT Support (Co-op Internship)

D4 Logistics Inc

Provided technical solution and level 1 IT support to the team members during office hours
Provided support for Office 365 for setting up 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
Troubleshot network issues related to TCP/IP and DNS based on hardware and software levels

Skills

Computer Science Data Evaluation ETL Data Integration and Transformation (ETL) Information Organization Project Leadership SharePoint Administration Ad-Hoc Reports Business Information Operational Process Computer Information System Data Quality Test Cases User Interface Visio Tableau Power BI QlikView Regression Analysis Hypothesis Testing ETL Development Data Visualization SQL Programming Problem Solving Documentation Microsoft Azure administration and management IT systems management Project management Database administration Network administration SQL Microsoft Azure Azure Virtual Machines Virtual Networks Azure Active Directory Azure SQL Databases Qlik Sense MySQL SQL Server DAX Excel Office 365 TCP/IP DNS VoIP Microsoft Word PowerPoint
Report this Profile?