Data Analyst

• Sep 2021 - Present

Data Analyst

• Feb 2018 - Aug 2021

NGEN Phase4 Instance split- With the expansion in current business in the US, clients opened stores in Canada. To evaluate current performance and future forecast in the recently opened store, it was needed to provide monthly reports for the sales performance of products in each region and forecast the sales in the future to improve business. Data collection from different sources, data cleaning, data understanding, building a model with the data validating that model and finally… Show more NGEN Phase4 Instance split- With the expansion in current business in the US, clients opened stores in Canada. To evaluate current performance and future forecast in the recently opened store, it was needed to provide monthly reports for the sales performance of products in each region and forecast the sales in the future to improve business. Data collection from different sources, data cleaning, data understanding, building a model with the data validating that model and finally deploying the model were the activities in the scope of the project. ➢Tools-My SQL, Python, Power Bi, Ms Excel TC4W Integration (Trunk Club for women) - Enables the shipment of Trunk Club (TC) stylist orders from Cedar Rapids (CR) to the customer. Was involved in Analysis of the business level changes that are required to support the integration, Design and technical documents designing, Designing UTC and unit testing, Supporting SIT and UAT. ➢Tools-Python, Power Bi, Ms Excel Custom data extraction - We work for most pharmaceutical clients in Canada. We provide them with reports based on their demand. We take their data and perform analyses that apply confidentiality whenever competitors data is involved and send the report as per demand. We provide trending and overlapping reports to help them understand the performance of the product and medical representative ➢Tools: Power Bi, Ms Excel Show less NGEN Phase4 Instance split- With the expansion in current business in the US, clients opened stores in Canada. To evaluate current performance and future forecast in the recently opened store, it was needed to provide monthly reports for the sales performance of products in each region and forecast the sales in the future to improve business. Data collection from different sources, data cleaning, data understanding, building a model with the data validating that model and finally… Show more NGEN Phase4 Instance split- With the expansion in current business in the US, clients opened stores in Canada. To evaluate current performance and future forecast in the recently opened store, it was needed to provide monthly reports for the sales performance of products in each region and forecast the sales in the future to improve business. Data collection from different sources, data cleaning, data understanding, building a model with the data validating that model and finally deploying the model were the activities in the scope of the project. ➢Tools-My SQL, Python, Power Bi, Ms Excel TC4W Integration (Trunk Club for women) - Enables the shipment of Trunk Club (TC) stylist orders from Cedar Rapids (CR) to the customer. Was involved in Analysis of the business level changes that are required to support the integration, Design and technical documents designing, Designing UTC and unit testing, Supporting SIT and UAT. ➢Tools-Python, Power Bi, Ms Excel Custom data extraction - We work for most pharmaceutical clients in Canada. We provide them with reports based on their demand. We take their data and perform analyses that apply confidentiality whenever competitors data is involved and send the report as per demand. We provide trending and overlapping reports to help them understand the performance of the product and medical representative ➢Tools: Power Bi, Ms Excel Show less

Data Analyst

• Nov 2017 - Jan 2018

Electrical Engineer

• Oct 2015 - Oct 2017