Data Science Analyst

RAJARSHI MAITI

Mumbai, India

913-***-**** • ***********@*****.*** Github

Portfolio

PROFILE

Detail-oriented professional with 4+ years of experience offering expertise in Cross functional duties, hands on experience in Cloud, Microsoft 365 Technologies and Unified Communications. Comes with good experience in Telecommunications and M365 Cloud.

EDUCATION

Lambton College, Ontario May 2022 - December 2023

Big Data Analytics, GPA - 3.56 (Dean’s Honor’s Award)- (Minor in Python, PowerBi & Statistics) SRM University (India) June 2014 - May 2018

Mechanical Engineering

CERTIFICATIONS

Full Stack Developer Certification

Python Basic Certificate- HackerRank

SQL Basic Certificate - HackerRank

Power BI – PWC Case experience - PWC

Data Science & analytics – BCG

Certified Data Scientist – ExcelR Academy

SKILLS

Programming Skills: Python, SQL, JavaScript, HTML, CSS Databases: MySQL, MongoDB

Data Science: NLTK, NumPy, Matplotlib, Pandas, ScikitLearn, ETL, Matplotlib. Reporting & Analytics: MS Excel, Pandas, Seaborn, Sales Analytics, ETL, Data Story Telling. Cloud Technologies: Microsoft SharePoint Online, Exchange Online, Microsoft Teams, Skype for Business, Intune, Security and Compliance, PowerApps, Salesforce.

Data Visualization: PowerBI, Microsoft Excel, Tableau, Looker Studio, Statistical Modelling, Data Mining. Advanced Mathematics: Geometry, Calculus, Number Theory, Statistics, Probability, Regression. WORK EXPERIENCE

OTIP (Ontario Teachers Insurance Plan), Canada August 2024 - Present Telephony Administrator Data Analyst – UCaaS & CCaaS Project: Migration of Phone System to NICE & Microsoft Teams Direct Routing; & Analytics of Telephone Systems Data (VOIP/PBX).

• Use PowerShell scripting to add restrictions to calling based on dial patterns as per policies/regulations enforced by the organization.

• Salesforce Integration with NICE CXOne Cloud. Collaborate with salesforce admin and technical account managers for API integration, change in code from salesforce server, and initiate infrastructure change

• Manage data sets for billing (telephone services); call received data; service providers/vendor invoicing; and system configurations data.

• Change or enhance of script(s) in NICE Studio as per the Business Requirements

• Recreate or change the design of existing script for the call flows to make sure it matches the requirements and testing it in lower environments before implementing the change in Production.

• Use Excel (v-lookups, pivot tables, index-match, data validation); HALO; and PowerShell to extract and analyze telephone/communication related data.

• Analyzing reports finding out the number of Dead Air Calls and help in analyzing the scam calls upto 50%. HCL Technologies Limited, India September 2021 - May 2022 Senior Engineer Business Data Analyst – Unified Communications Project: Worked with a telecom client on a unified communication and collaboration M365 project.

• Developed PowerBI dashboard to visualize core business KPIs (Monthly Recurring Downtime), saving 10 hours per week of manual reporting work.

• Collaborated across Team for SharePoint Online issue, Microsoft Teams, Power Apps, Microsoft Flow and troubleshooting to save efficiently and solving issue 2 times faster.

• Worked with analysis of data such as real time network downtime; area parameters affected during timeframes; start and end of duration down times.

• Translated business needs to technical requirements for delivery teams, identifying opportunities for process improvement and further documenting them.

• Querying data from MySQL to checking records and Analyzing Data using Excel for further analysis further helping Project manager to conclude results quickly.

• Analyzed data from 25000 active users and used outputs to guide strategies; increased engagement time for the applied licenses, 15% decrease in licensing budget and submitting a report which helps in building strategy for the company.

• Pulled reports from Admin center, analyzing the Data in Excel and Visualizing it in Power BI to identify the areas of improvement by increasing productivity by 7%.

• Understanding customer’s requirements and accordingly giving the best suggestion in terms of cost effectiveness and backing up with the real time data.

• Report findings, resolutions, and suggestions (cost effectiveness, improvements) were presented to senior management and project directors.

Convergys India Services Limited, India January 2020 - February 2021 Subject Matter Expert Reporting Analyst – Contact Center Ops Project: Downtime Loss and Department effectiveness KPI data analysis and reporting.

• Acted as a SME to manage business user reported tickets, closing 71% of total tickets in SLA period.

• Using Customer reports to analyze the loss due to downtime and possible ways to reduce the downtime loss which helped project to increase revenue by 4%.

• Conduct analysis and prepare supporting documentation to be used in the department’s analysis and presentations.

• Evaluating business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing solutions.

• Conducting research and analysis to identify business problems and suggesting the possible solutions for improved performance saving time per issue by 50%.

• Lead the Team with analyzed report to make them understand the business KPI’s and where the Team can improve.

• Analyzing the downtime report and Created Power BI dashboards to the Management Team with conclusions drawn for the scope of improvement in the project. Wipro Limited, India July 2018 - January 2020

Technical Consultant Data Analyst – Internal Systems Project: Built an in-house portal website used for Registering purposes, User login and customer data storage

• Analyzed data from 25000 active users and used outputs to guide strategies; increased engagement time for the applied licenses, 15% decrease in licensing budget and submitting a report which helps in building strategy for the company.

• Performing Network Performance analysis from the previous data and from the analysis suggesting the Project Manager for scope of improvement.

• Experience conducting performance/quality monitoring and testing, trend analysis and suggesting ways of Improvement in Infrastructure by 4%.

• Manage and monitor KPIs/metrics to continually improve processes and improved product performance by 5%.

• Holding experience with JavaScript for building internal portal website and Registering, Login of users using MySQL database.

• Worked side by side on a development project which involved rectifying website using backend Node.js and database MySQL.

DATA PROJECTS

Sales Analysis of Diwali

Improved Customer experience by identifying potential customers across different states, occupation, gender and age groups.

Improved sales by identifying most selling product categories and products, which can help to plan inventory and hence meet the demands.

Performed Exploratory Data Analysis (EDA) using Pandas, matplotlib and seaborn libraries. Customer Churn Prediction of Telecom Dataset

Exploratory Data Analysis and creating a correlation matrix with all parameters with indicating parameters.

Applying different ML models like Logistic Regression, Random Forest, Support Vector Machine, Naïve Bayes to find which was better accuracy.

Comparing all the models performance using AUC score and ROC curves to get the more visual comparison. Healthcare Data Wait List Dashboard (Power BI)

Creating different slicers explaining different department with their Waiting list.

Displaying the number of Outpatients based on the range of months.

Detailed view of Specialty level and age profile analysis with Average & Median Waiting List. Order Reports of Dashboard Using Looker Studio

Generated Insights of Orders when Categorized by Region, Category, Segment by Order.

Generating Insights of the Sales for Trends for the Year and Month.

Evaluating Regional Performance by understanding which states and cities contribute the most to sales. Data Analysis of Hotel Bookings

Data Analysis performance, profiling, cleaning up data, data wrangling and visualization of data.

Detailed Explanation of the data and the steps used to explain the Data model used in the Python Code. Mobile Data Analysis using MySQL

SQL Query for finding out the price of 5 most expensive phones.

Query for finding out the price of 5 most cheapest phones. Customer Complaints Tableau Dashboard

Finding out the Total Number of Complaints based on different departments.

Showing the Year Trend with the number of complaints and finding which request type had the maximum complaints.

Seeing the increase in trends for complaints every year and showcasing complaints state wise. Mental Health and Lifestyle Habits

Exploratory Data Analysis of all the parameters to understand which parameter affect the Mental Health.

Grouping of Age Category to create a separate column for easy analysis of Data and drawing conclusions at the end.

Using Random Forest to find the relation after grouping of age groups. Hotel Review Analysis with ML Model and Power BI Dashboard

Exploratory Data Analysis with Data Cleaning and Data Preprocessing with Visualization of the Data.

Using Bag of Words, TF-IDF and Word Embeddings to find out which provides better accuracy among ML Models.

Applying Different Machine Learning Models such as Random Forest Classifier, Logistic Regression, Support Vector Machine to find which model provides better accuracy.

Looked at the datasets of hotel services and their booking cancellation data. Provided problem solving suggestions such as consumer discounts; room pricing strategies; campaign/marketing approach changes; and quality in service and hotel premises.

E Commerce Sales Dashboard

Created Interactive PowerBI Dashboard to track and analyze online sales data.

Used Bar chart, Pie Chart, Donut Chart, Clustered bar chart, scatter chart, line chart, slicers to depict sales according to each Quarter.

Created connections, joined tables and used parameters for visualizing efficiently. Attrition Rate Power BI Dashboard

Relating Attrition of a Company with various factors and Creating a Power BI Interactive Dashboard.

Creating a dashboard which relates Count of Employee, Attrition, Attrition Rate, Average Age, Average Salary, Average Years and finding out insights about Attrition with all other factors related.

Visualizing Attrition by Education, Age, Salary Slab, Years at Company and Job Role.

Contact this candidate