Bishnu Shrestha

Cell :403-***-**** E-mail : ac8sz3@r.postjobfree.com Calgary, AB

Profile

Data Analyst/Quality Assurance Analyst experience in gathering business requirements, extracting data from various sources, loading data into data mart and developing Business Intelligence dashboards and reports through excel and power BI. Seeks the opportunity to join a data analysis challenge and work cross-functionally to design, develop and deploy strategies for business intelligence environment

Skills

Advance knowledge of Power bi, DAX

Proven ability to Extract, Transform, analyze data and disseminate substantial amount of information using Power BI

Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables

Advanced SQL development skills and ability to extract, transform, and load data from different data sources.

Experience working with complex data structures

An understanding of Power BI administration, licensing, security, and deployment

Working knowledge of Kimball Data Warehouse Methodologies

Excellent attention to detail and organizational skills

Ability to work in a fast-paced environment and meet tight deadlines

Excellent customer service, verbal and written skills, detailed oriented and hard-working person

Advance knowledge of excel, word and PowerPoint.

Experience creating test plan, test cases

Proficient in all levels of testing, including functional, smoke, load, UAT, regression, performance and exploratory testing

Experience and Knowledge of Software Test Automation (HP UFT, Selenium IDE/ Web Driver) and Working knowledge of relational databases

Database testing

Knowledge of machine learning with python and R.

Technical skills

Programming languages: Python, R, Java, C#asp.net, C, C++

Scripting languages: Ruby, java script and Perl

Operating system: windows, Linux (Ubuntu)

Web Technologies: HTML, XML, CSS

Tools and software: Jira, Microsoft BI tools (SSIS, SSAS, SSRS), Microsoft sql server 2016, Microsoft sql server management studio 2016, Power BI, R-Studio, Tableau, T-sql, Microsoft office 365.

Databases: SQL, MS Access

Test Automation tools: selenium, UFT, Web Load, LoadRunner

Related Educational Qualification

BUSINESS INTELLIGENCE: DATA ANALYSIS & REPORTING May 2018 - Aug 2018

Southern Alberta Institute of Technology (SAIT), Calgary, Alberta

Designed dashboards and reports for the business using Power BI, developed BI solutions for Maximum Miniature Inc. using Microsoft Business Intelligence tools and underlying technologies like SQL Database, SSIS, SSRS, SSAS Excel Services, gained knowledge about Business Analysis for BI Applications, ETL (Extract, Transform, Load), Dimensional Modelling, Architecture & Design, Reporting & Analytics, Data Backup and Recovery, Data Warehouse Design & Mining, Database Management Systems, Online Analytical Processing (OLAP)and T-sql.

SAIT MINOR PROJECTS AND CASE STUDIES

Worked in team to develop BI solution to solve the inventory management problem for a company called people mover

Used Microsoft Azure Cloud to build a VM, SQL server with DB

Worked on open data source Calgary crime statistics, Calgary waste recycle collection schedule, and stock market trend analysis on different sectors and created dashboard using Power BI to fulfill the requirements provided by instructor and team mates

Worked individually on tabular and multidimensional projects.

Work Experiences

Marketing Coordinator (Shaw flooring, Costco Wholesale) Dec 2018 - present

Exhibit Floor Design ltd.

Generating lead by collecting information about the interested Costco customer in Shaw flooring

Direct communicating with the Costco customer and giving information about different Shaw products like hardwood, laminate, vinyl, tiles and carpets.

Training and leading new flooring staffs

Preparing reports by collecting, analyzing, and summarizing sales data

Data Analyst at Cardel Homes Aug 2018 – Nov 2018

Gain knowledge about the sales simplicity software used by the company.

Gather and analyze users’ business requirements and ensure users satisfaction

Acquire and transform raw data from the various sources such as excel, sql server database, load data into Power BI, clean data and create data models in Power BI

Work with the IT team to identify data sources and develop SQL queries to extract accurate data

Create reports and dashboards using Power BI to communicate accurate findings with the sales departments and verified values of reports using sales simplicity software and sql.

Major Accomplishment:

Created visually impactful reports and dashboards using Power BI pro of Calgary data for business users.

Created more than 50 dashboards.

This saved time and improved decision making for management team.

Bi Analyst at Maximum Miniature Inc (SAIT Academic project) June 2018 – Aug 2018

Developed a BI solution for a company that required a Data warehouse because it could not analyse its data and needed to remain competitive in the market industry.

We successfully gathered the business requirements from VPs of Sales, Production, Marketing, performing Gap analysis between Organizational requirements and existing Procedures

Extracted Data from the various OLTP sources, transformed the data and loaded it into a Datawarehouse.

Created a Business intelligence sematic Model for analysis (created multidimensional and tabular models with metrics, KPI and Perspective) and created visualised reports and Dashboards for the top Management using Power BI. This solution was deployed using Agile Methodology)

Software Tester, U Test, http://www.uTest.com/ Dec 2015 – Feb2017

Tested mobile and web applications using IOS and android mobiles

Performed functional, exploratory, regression testing of various iOS and android web application and websites.

Technologies: Apple iPhones 4s and 5s, Samsung Galaxy S5, Samsung Galaxy S5 Neo, iPad Air 2 and windows 8.1.

Software Tester (Readium Foundation, http://readium.org/) USA Oct 2015 – Jan 2016

Project: Worked on Readium for Chrome browser extension an open source reading system and JavaScript Library for displaying EPUB publications in Web Browsers and Readium Cloud Reader online eBook.

Analyzed specifications and design documentation

Performed Compatibility testing (cross Browser, devices) on different browsers (IE, FF, Chrome, Opera and Safari)

Reported bugs and performed verification of fixed bugs using Elementool bug tracking system

Technologies: JAVA, JIRA, MS Office

Software Tester (manual and automated training) Feb 2015 -Sept 2015

Iriol Software Ltd, Vancouver, BC http://iriol.ca

Project: Loan Management System is a web based bank loan prequalification system that consolidates many different functions of a loan management processes into a single integrated solution.

Performed ad hoc testing, reported bugs using Elementool defect tracking system and verified bug fixes

Developed test plans and generated test cases for different parts of application

Performed various types of testing, such as Functional, Regression, System, Smoke

Performed Compatibility testing of web application on different browsers such as IE, Firefox, Opera, Chrome

Technologies: HP UFT, HP QC, Selenium, Test Link, Subversion, MS Office, Elementool, Java, HTML, VBScript

Asst. Professor January 2012 - Dec 2013 Cosmos College of Engineering and Management, Nepal.

Instructor for Digital logic, Instrumentation, Computer Organization, Computer Architecture etc. for bachelor level students.

Supervisor for different kind of project works and research activities of students.

Keep records of number of students present in class, number of pass or fail students in different subjects and create visualization through excel to give insights to management team about the progress of students in projects and labs.

Lecturer

Pokhara Engineering College Feb 2005 – Dec 2007

Instructor for Digital logic, Instrumentation, Analog Communication for Diploma level students.

Other Educational Qualification

EDUCATION BUSINESS INTELLIGENCE: DATA ANALYSIS AND REPORTING 2018 Southern Alberta Institute of Technology (SAIT), Calgary, Alberta

SOFTWARE QUALITY ASSURANCE AND SOFTWARE TESTING 2015

Hitek Computer School, Canada

MASTER’S IN COMPUTER ENGINEERING 2012

Pokhara University, Nepal (Canadian Equivalent Degree through IQAS)

BACHELOR OF SCIENCE DEGREE IN ELECTRONICS ENGINEERING 2004

Pokhara University, Nepal (Canadian Equivalent Degree through IQAS) PROFESSIONAL DEVELOPMENT/CERTIFICATION ISTQB certified Foundation level, CSTB, CANADA 2017

Python and R for data science(udemy.com) 2018

Datawarehousing (ssis, ssas, ssrs, t-sql, DW) (udemy.com) 2018

Machine learning with python and R(udemy.com) 2019

Contact this candidate