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 · 5 years

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

<p>Developed and maintained business intelligence reports and interactive dashboards using Power BI, providing stakeholders with actionable insights<br>
Statistical analyzed customer data to identify trends and provide insights to the marketing team<br>
Designed and developed complex SQL queries and stored procedures for data extraction, transformation, and loading<br>
Collaborated closely with cross-functional teams to understand ambiguous business challenges and develop customized analytics solutions to address them<br>
Participated in database backup and recovery activities to ensure data availability and integrity<br>
Developed and maintained ETL (Extract, Transform, Load) processes to ensure data accuracy, integrity, and accessibility<br>
Managed and monitored Microsoft Azure cloud infrastructure, ensuring optimal performance and high availability<br>
Implemented and maintained Azure Virtual Machines, Virtual Networks, and Azure Active Directory services<br>
Administered Azure SQL Databases and ensured data integrity and security<br>
Managed IT projects from planning to implementation, ensuring timely delivery and adherence to budget</p>

IT Specialist

YWCA

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

Systems Specialist

D4 Logistics Inc

<p>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<br>
Delivered data analysis projects using advanced features in MS Power BI<br>
Automated ETL DAX functions pipelines on SQL server<br>
Enhanced business and competitive edge by providing Analytics and Reporting Dashboards on customers and drivers data, using SQL and PowerBI on a MySQL database<br>
Monitored Qlik Sense app reloads daily<br>
Analyzed data in revenue, profit, opportunity, and risks from different dimensions by time, product, channel, account, etc.<br>
Ensured the quality of analysis and data accuracy and demonstrated results to management<br>
Streamlined complex database models and defined relational database<br>
Wrote custom queries and calculations to get required data columns<br>
Created reports, dashboards and connected the report database with SQL Server for real time updates<br>
Performed database administration, data analysis, and advanced Excel reporting using formulas and pivot tables</p>

Internal IT Support (Co-op Internship)

D4 Logistics Inc

<p>Provided technical solution and level 1 IT support to the team members during office hours<br>
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<br>
Created call flow diagram (flow chart) from existing VOIP call system<br>
Created workflow related documents and presentations using MS Word and PowerPoint<br>
Provided functional and technical support<br>
Troubleshot network issues related to TCP/IP and DNS based on hardware and software levels</p>

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?