Santosh Karan
Entry-level data-oriented or operations role
About
Detail-oriented and motivated professional with experience in event operations and email marketing, complemented by strong analytical skills in SQL, Excel, and Power BI. Proven ability to manage deadlines, coordinate cross-functional teams, and optimize processes. Currently seeking an entry-level data-oriented or operations role where analytical and organizational skills can add business value.
Skills & Expertise (23)
Work Experience
Data Analyst
Royal Bank of Canada (RBC)
Mar 2020 - Jan 2021
Imported the required data from SQL Server using SQL Queries. Deep Dive Analysis of the customer churn data for the bank and generating useful visuals from the data which would be advantageous for banks to know what leads a client towards the decision to leave the company. Understanding the pain points by data crunching and building various visuals and KPIs which would have great impact on the business. Used ETL methodology in the POWER Query for the data harmonization using various methods like missing values imputation, appending queries, merge data, custom columns, M Codes, Group by etc. Established relationships, created data model (Star Schema to have a better model performance), and created calculations in the POWER PIVOT. Used Data Analysis Expression language (DAX) extensively to model data. Developed Microsoft Power BI dashboards, visualizations and created multi page reports with important visuals which would have a great impact on the business and foster the growth of the company. Published the reports on POWERBI SERVICE and created useful dashboards and stored in WORKSPACE.
Data Analyst
Shoe Carnival Inc.
Jun 2021 - Jun 2021
Deep Dive Analysis of the sales data for the company and generating useful insights from the data which would help the stakeholder take better decisions to foster the growth. Understanding the pain points by data crunching and building various visuals and KPIs which would have great impact on the business. Used ETL methodology in the POWER Query for the data harmonization using various methods like missing values imputation, appending queries, merge data, custom columns, M Codes, Group by etc. Established relationships, created data model (Star Schema to have a better model performance), and created calculations in the POWER PIVOT. Used Data Analysis Expression language (DAX) extensively to model data. Developed Microsoft Power BI dashboards, visualizations and created multi page reports with important visuals which would have a great impact on the business and foster the growth of the company. Used POWER MAP to showcase the sales data information on Bing Maps for various countries and Geographic Region. Published the reports on POWERBI SERVICE and created useful dashboards and stored in WORKSPACE.
Education
Bachelor of Commerce (B.Com) - School of Open Learning, Delhi University
- 2022 · Afghanistan
