/

SUBHENDU SAHA

adguf2@r.postjobfree.com https://public.tableau.com/pro ile/subhendu.saha#!/ 514-***-**** subhendu-saha-976318126/ Subhendu-Saha

Montreal, Quebec, Canada

SUMMARY

An experienced Data Analyst who recently graduated from Concordia University, having good critical and analytical skills to solve complex problems by using various troubleshooting techniques. My aim is to provide the most insightful information from the data to the decision makers in the form of a story to satisfy business needs. EXPERIENCE

Capgemini Technology Services India Limited, Data Analyst, Mumbai, India Aug. 2017 - Nov. 2018

• Collecting sub-contractors data from the Finance Team of various regions like NAR, US, etc. and preparing and analyzing business transactions of contractors and build reports based on the findings and documented it for future reference.

• Worked in SQL to extract and manipulate insights from large data sets and load them into the system.

• Assessing Data quality issues like accuracy and completeness of the data set using Python and Excel.

• Worked in advanced Microsoft Excel (Pivot Tables, VLOOKUP, Macros) and Python for handling large data sets of Business transactions imported as .csv files and visualizing insights of the data analysis in the form of the dashboard using Tableau to present it to Senior Manager and Stakeholders.

• Managed strategy, optimization & growth initiatives: Defined strategic KPIs for evaluating success by providing strategy to optimize the exceptions during a particular time frame.

• Actively participated in User Acceptance Testing(UAT)/ Functional Unit Testing(FUT)/ System Integration testing of new functionalities incorporated into the VMS SAP Fieldglass application.

• Worked in SOA (Service Oriented Architecture) interface with File Transfer Protocol. INTERNSHIP

KPMG, Data Analytics Consulting (Virtual Internship) June 2020 - July 2020 Market Report for Customer and Product Analysis [Python, Tableau]

•Assessing the quality of client's data; as well as making recommendations on ways to clean the underlying data and mitigate issues.

•Preparing a detailed approach for completing the analysis including understanding the data distributions, feature engineering, data transformations, modeling, results in interpretation and reporting.

•High-value customers are extracted based on customer demographics and attributes, introducing a few calculated fields to solve the problem statement, and finally, the RFM model was developed in this phase.

•Developing a dashboard in Tableau that we can present to the client to visualize the data summary and results of the analysis.

PROGRAMMING LANGUAGES: Python, SQL, SAS, HTML/CSS, OCL VISUALIZATION/BI TOOLS: Tableau, GIS

DATABASE: MySQL, IBM DB2 on cloud, AWS

SOFTWARE AND TOOLS: JIRA, MATLAB, SAP Field Glass(VMS), MS Office, Spreadsheet, Excel, UML PERSONAL DEVELOPMENT: Leadership, Communicative, Creative, Adaptive PACKAGES: Matplotlib, Seaborn, Pandas, Numpy, Sci-kit Learn, Statsmodels PROCESS: Agile methodology, Waterfall

SKILLS

/

EDUCATION

Concordia University Jan. 2019 - Aug. 2020

Master of Engineering Electrical and Computer Engineering 2020 CGPA - 3.61/4.3

Majors in Computer Engineering and Modelling of Telecommunication Networks PROJECTS

Customer Churn Prediction in Banking Sector [Python]

•Performed Exploratory Data Analysis(EDA), Univariate, and Bivariate analysis to gather insightful information on churning customers.

•Build a model to predict Churns (Logistic Regression) and evaluating them respectively. House Sales in King County, USA [Python]

•Coded a python script on IBM Watson Studio and applied data integration, cleaning, exploration, visualization, and predictive modeling techniques to forecast various parameters according to the data.

•Used a linear regression model to predict the 'price' using features that are highly correlated and finally evaluated the model.

Content Delivery Network Design and Implementation [Python, AWS]

•End-users are able to request a specific video and get the video streamed from the replica server selected by the controller.

•Origin servers push videos to selected replica servers (EC2 instance) prior to end-user requests for the videos.

•The controller selects the specific EC2 instances and redirects the end-user requests to the selected replica server based on the traffic.

•Elastic load balancer is used which works on the round-robin algorithm. Exploring the city of Toronto by segmenting and clustering their neighborhoods by using KNN algorithm. [Python]

•Data Pre-processing - Scraping and cleaning the data(Removing duplicates, dealing with missing values, normalization, etc.)

•Modeling and fitting the dataset by using the K-Means Clustering algorithm and visualization of the map using Folium.

Analyzing ACME superstore sales across US [Excel, Tableau]

• Visually represented and analyzed the factors that contribute to the performance of the ACME superstore. Cleaned superstore data in Python and visualized the findings by using Tableau. Captured the key regions across the US and also the profitable items across each region that contributes to the sales.

• Designed ACME superstore customer dashboard and also ACME superstore dashboard to visualize them in the form of a story.

Loan Paid off or not - Best Classi ier [Python]

•Built model using KNN, Decision Tree, SVM, and Logistic Regression algorithms.

•Evaluated the model accuracy by using metrics like Jaccard index, F1-score, and Log Loss methods. AWARD

Meritorious Performer, Capgemini Technology Services India Limited Oct. 2017

•Professional Training conducted by Capgemini, India during the period of 16-Aug-2017 to 30-Oct-2017 (1st rank holder).

•Trained in Software Development Life Cycle(SDLC), Java, Python, MySQL, HTML, CSS, Advanced Microsoft Excel, and Manual Testing (Preparation of System Requirement Specification Document(SRS), Creation of Test Cases and Test Plan).

Contact this candidate