Jerin Baby
Kitchener,ON
Summary
- More than 2 years of experience in Data analysis. The job assignment mainly consists of analysis, design, development, testing, implementation, and support in various projects.
- Having experience in deploying the Power BI reports on Power BI Online Services.
- Experienced in delivering advanced Excel and SQL reporting to plan, design, execute, and evaluate report results.
- Proficient in advanced MS Excel formulas and functions to produce data-driven reports.
- Designing the different types of dashboards using Power BI visualization (Charts, Bubbles, Maps, Slicer, and KPI).
Overview
5
5
years of professional experience
Work History
Data and Reporting Analyst FP&A
Home Hardware Ltd.
04.2022 - 05.2023
- Working closely with stakeholders from different business units to determine reporting and application requirements, perform analysis to create a statement of work, and provide time estimates.
- Scheduled and managed daily/weekly/monthly reports based on the business requirements.
- Developed Power BI reports and dashboards using Microsoft Reporting Platform, Microsoft SQL Server, MS Excel, Pivot tables, PowerPoint, MSWord, and other tools.
- Extract, filter, and aggregate data using MS SQL Serve.
- Consolidated standard reports, eliminated duplicate functionality, and reduced the number of standard reports.
- Prepared different reports to analyze sales, and provide forecasts to management to ensure service levels are met & KPIs are on track in Power BI and Tableau.
- Imported data from SQL Server DB to Power BI to generate reports and dashboards.
Junior Analyst
Seymour Technologies
05.2018 - 09.2019
- Collaborated with business users to understand and meet their reporting needs.
- Assisted senior data analysts in data collection, validation, and reporting activities.
- Develop Tableau reports that provide clear visualizations of various industry-specific KPIs.
- Used MS Excel to clean, transform, process, and manage large datasets.
- Strong analytical skills, ability to present and communicate data, trends, insights, and make recommendations to different stakeholders.
- Conducted basic data analysis, including trend identification and basic statistical tests.
- Utilize SQL to query and extract data from databases, performing complex joins and transformations.
Education
Post Graduate Diploma in Engineering -
Confederation College of Applied Arts And Technology
Thunder Bay, ON09.2021
Bachelor of Science -
MG University
India03.2018
Skills
- Excel ( Vlookup, Conditional Formatting, Pivot Tables)
- SQL (SQL Server, MySQL)
- Microsoft Power BI
- Tableau
- Power Point
- R
- Spreadsheet
- MS Word
Timeline
Data and Reporting Analyst FP&A
Home Hardware Ltd.
04.2022 - 05.2023
Junior Analyst
Seymour Technologies
05.2018 - 09.2019
Post Graduate Diploma in Engineering -
Confederation College of Applied Arts And Technology
Bachelor of Science -
MG University
Similar Profiles
Robert AllanRobert Allan
Director of Paid Media and Monetization at Home Hardware Ltd.Director of Paid Media and Monetization at Home Hardware Ltd.
Aren GazalianAren Gazalian
Floor Associate/Stock Assistant at Home Hardware Ltd.Floor Associate/Stock Assistant at Home Hardware Ltd.
Melissa BezooyenMelissa Bezooyen
Department Head at Coaldale Home Hardware Building CentreDepartment Head at Coaldale Home Hardware Building Centre