Python,R,SQL,SAS, Tableau software, Regression analysis,TensorFlow

Somshankar Banerjee

Cell: +** - 762-***-****.

Email: **********.********@*****.**

Address: ***/***, ******** ********** ****, Basak Bagan, Behala, Kolkata, West Bengal – 700034.

Professional Summary:

Experienced technical support executive attentive to sales data, apart from assisting users with technical issues

(hardware and software). Recently completed a 6 months certificate course on Data science and looking for a job in analytics or related domains.

Skills:

Knowledge in Microsoft Excel.

Programming in R.

Programming in Python.

Knowledge in SQL

Tableau Software

SAS Programming

Achievements/Certifications/Projects:

Completed Data Science Pro-degree (DSP) course from Imarticus Learning in collaboration with Genpact (November 2019 – May 2020).

Received “Revenue Star of the Segment” award in Dell for over achieving sales targets for consecutive 3 quarters.

Dell Certified Hardware/Software technician.

Participated in ESSL Biometrics quiz competition in 2015 within the organization.

Participated in Robotics and Artificial intelligence workshop “Asimov” conducted jointly by TECHNEX, IIT (BHU) and EXODIA (IIT MANDI) at Siliguri Institute of technology in 2013.

Pursued Cisco Certified Network Associate (CCNA) course from Indian Institute of Hardware technology, Kolkata in 2014.

Projects undertaken:

Completed a project using R and python, where linear regression was used to create models to predict the property selling prices based on different predictors related to the properties. Data cleaning was performed in the beginning followed by imputations in the dataset, filtering predictors based on parameters like Vif scores, P-Values to reach to the final model with the maximum multiple R squared value and least number of predictors.

Completed a project using R and python, where logistic regression was used for Bank Credit Card Default Prediction based on different predictors related to the customers. Predictors were filtered based on parameters like Vif scores, P-Values to reach to the final model with the maximum overall accuracy rate and Area under Curve with least number of predictors. The final model was trained using training data and later tested on the testing data set.

Completed a project using R and python, where decision tree concept was used for Bank Credit Card Default Prediction based on different predictors related to the customers. The dataset used was different from the one in Logistic Regression. Predictors were filtered to reach to the final model with the maximum overall accuracy rate and Area under Curve with least number of predictors being used. Then boosting was performed with different number of trials to check for further improvements in the final results.

Completed a project using R, where Linear Discriminant Analysis (LDA) was used for Bank Credit Card Default Prediction based on different predictors related to the customers. This was done to compare the results with the respective Logistic Regression and Decision Tree models built earlier. Then LDA was used to predict the species of different flowers in inbuilt R dataset “iris”. Final model had maximum overall accuracy rate with minimum errors. The classifications were clearly visualized using scatter plots.

Completed a Case Study project using SAS Retail Store Analytics, to understand the basic concepts of SAS. Data was imported, cleaned and transformed to use it for various reporting’s such as generating maximum sale day report, report of most loyal customers etc. Tables were queried using SQL to get required results. Various conditional statements and SAS functions were used throughout the project.

Completed a capstone project using SAS, to understand and evaluate banks credit card system. Missing data and faulty columns were adequately treated before the data could be properly analyzed. Data exploration was carried out and Bank’s Profit from Credit Card was calculated using relevant calculations using SAS codes. Finally reports were generated as asked in the project, such as age group spending highest amount, most profitable segments, etc.

During my tenure in Essl India Pvt Ltd, I had been a part of the IoT team in designing and demonstrating a Video Door Phone (VDP) device, through which a visitor can be properly verified and then allowed entry through the main gate. The verification could be done by audio visual interfaces within the device through which a person inside the home could see and first talk to the visitor outside the gate using a microphone. Then he may allow him entry by pressing a switch that automatically opens and closes the gate lock. The device was built to be sold to Indian and overseas markets.

I have built a basic water level detector circuit at home that automatically lights up a led bulb that acts as an alarm, as soon as the water reaches a particular level in the tank. Water being a good conductor of electricity helps in closing the circuit as soon as it touches the legs of the Led bulbs. The project needed few 5 mm Led bulbs, an old cell phone adapter (power supply), wires, a 70 ohm resistor, soldering iron, soldering flux and a digital multimeter. Professional Experience:

Technical Support Engineer, 06/2015 to 06/2016

ESSL India Private Limited, Bangalore, Karnataka.

Time and attendance software troubleshooting within operating system.

Resolved hardware issues of biometric locks, attendance systems, turnstiles and other security devices

Provided base level IT support to non-technical personnel within the business and worked as a part of an IoT project of designing a video door phone, within the company.

Provided training to end users in Biometric door lock systems, turnstiles and CCTV camera installation and usage.

Hands on experience in working of biometrics, time and attendance, simple access control, bio locks and hotel locks.

Assisted in developing and testing new product offerings such as essl etimetracklite, essl smart office etc.

Testing and diagnosing hardware issues of electronic security devices and upgrading system firmware’s

Created tickets for damaged, lost or displaced packages.

Handling government and private tenders of security product requirements and converting them to sales.

Identified potential sales and cross selling opportunities.

Provided on call support for critical issues to customers in a polite and professional manner.

Participated in Job related trainings and attended seminars on security products across India.

Created reports using excel and other internal tools as needed by the management. Senior Client Technical Support Executive, 06/2016 to 04/2018. Dell International Services, Bangalore, Karnataka.

Software troubleshooting within operating system.

Resolved technical issues of dell products.

Conducted research to address customer concerns by complying with company policies.

Provided base level IT support to non-technical personnel within the business.

Evaluated and responded to incoming sales leads and requests for technical support assistance.

Worked as a part of the core sales team involved in selling spare parts for out of warranty dell products

Up Sold products and services to increase company revenue.

Activated accounts for clients interested in new services.

Led internal product trainings for dell systems.

Appropriately documented all transactions using excel and internal dell tools.

Participated in various incentive programs and contests within dell.

Accesses client’s profiles and aligned them with best possible products and services to meet their needs and maintained and studied database of the same.

Developed and tested new product offerings (such as Delta, Dell Tech Concierge).

Remained up to date on latest technologies and solutions applicable to company products.

Identified and solved technical issues with a variety of diagnostic tools.

Participated in job related trainings and certifications.

Created reports using excel as needed by the management. Education:

B.Tech: Electronics and Communication Engineering, 2014 with 73.2% marks. West Bengal University of Technology, West Bengal, India. ISC: Pure Science, 2010, with 72% marks.

National Gems Higher secondary School (ICSE Board), Kolkata. ICSE: Science, 2008, with first 86% marks.

National Gems Higher Secondary School (ICSE Board), Kolkata. Personal Strengths:

Flexible to learn new technologies.

Highly motivated, positive and goal oriented professional.

Good communication and interpersonal skills.

Declaration:

I hereby declare that the above information is correct to the best of my knowledge and belief. Place: Kolkata Somshankar Banerjee

Contact this candidate