Prabhjot Oberoi Email & Phone Number

Toronto, Ontario, Canada

Toronto, Canada Area

• SCIEX is a part of Danaher Corporation, a Fortune 500 science and technology innovator helping solve complex challenges, and improving quality of life around the world. As a BI Analyst, I am responsible for helping the.
• Design & develop data Integrating flows/ETL packages to integrate data from multiple internal & external data sources to remove data silos
• Data Modelling to ensure that the business users have access to the right data for self-service analytics
• Data presentation using next-gen visualization engines such as Power BI and communication of analysis results to the business
• Design & development of organization wide reporting/analytics solution

Toronto, Canada Area

• As a Business Intelligence Consultant, working on a large BI & Analytics solution implementation for Utility One Source, an industry-leading equipment provider that distributes and rents construction equipment, utility.
• Assess and obtain an understanding of business requirements outlined in report specifications and from this, design new table structures and develop new stored procedures and reports
• Model data appropriately in Power BI to meet the business requirements
• Design and develop new Power BI reports/reporting interfaces to build reporting solution flexible enough to meet current and future business needs
• Create new SSIS packages to process data imports and data pushes
• Perform thorough unit tests on new reports and report changes, checking data accuracy and assessing that report functionality and design meet the report specifications

Toronto, Canada Area

As a Data/BI Analyst in the Department of Statistics, responsible for assisting the global organization by providing reports and timely analysis to the Marketing, Sales, Customer Service and Finance Departments by Data Mining, Data Modeling and developing business reports. Accountable for following job functions: Ingesting data from various data marts.

Toronto, Canada Area

Worked on various development/consulting engagements on part-time basis as database developer/reporting analyst/ETL developer. Recently relocated from US to Canada, used the flexibility with part-time work to settle down, dedicate some time towards my newborn, renew my technical certifications and focus on writing (my blog), before getting back into the.

New Jersey, USA

• As a BI developer worked towards achieving following outcomes for the Clients:
• Worked on development of SSIS packages for integrating data from various data sources into data warehouse
• Developed operational and analytic SSRS reports to generate detailed and aggregated data reports by neighborhoods from SSAS tabular model
• Worked on tabular model development to deliver self-service BI capabilities to clients on subset of data from data warehouse

Jalandhar Area, India

• Effective tracking of student information & improving operational efficiencyBOS needed a comprehensive student information system with capabilities that enabled real-time insight to the needs of each student for all.
• Worked on SSIS packages for Integrating Data from different sources and modules which were running in disparate systems
• Worked on creating effective transactional DB solution designed to improve performance
• Developed SSRS reports and dashboards for the business users to help them be on top of the overall functioning of the school
• Used SSRS report subscription functionality to delivery critical updates around student attendance and performance to relevant stakeholders (teaching staff and parents)