Data Scientist

VIVEKA KUMAR

Data Scientist **+ years experience

Plano, Texas, US +1-512-***-**** ***********@*****.*** Summary

** **** ***** ** ********** in Mathematical/Statistical Modelling Experience in Statistics Analysis, Data Analysis, Data Science using R language and SQL. Strong with ETL, Data warehousing, Data Store concepts and OLTP, OLAP technologies. Experienced in SQL programming and creation of relational database models. Worked with applications like R, Python to develop neural network algorithms, cluster analysis

Worked with packages like ggplot2 and shiny in R to understand data and developing applications.

Worked on Tableau, Quick View to create dashboards and visualizations. Automated recurring reports using SQL and Python and visualized them on BI platform like R Shiny, Excel, and Matplotlib

Strong experience working with memSQL, SQL Server 2008, RStudio. Worked on Statistical models to create new theories and products. Experience working with statistical and regression analysis, multi - objective optimization. Worked on Linear and Non - linear programming models for optimizing industrial supply chains

Experience working with statistical and regression analysis, multi – objective optimization

Worked with R libraries like ggplot, dplyr, rshiny, lubridate, datatable and many more Worked with python libraries like matPlotLib, pandas, sklearn, numPY, keras etc. on Jupyter notebooks

Designed and implemented supervised and unsupervised machine learning models. Identify problems and provide solutions to business problems using data processing, data visualization and graphical data analysis

Developed predictive models using Decision Tree, Random Forest and Naïve Bayes. Sound knowledge of Statistics - hypothesis testing, time series analysis, confidence interval etc. and experience in applying it to technical and research fields. Identifying areas where optimization can be efficient. Worked with clients to identify analytical needs and documented them for further use. Developed predictive models using R to predict customers churn and classification of customers.

Query optimization, execution plan and Performance tuning of queries for better performance in SQL.

Worked on Shiny and R application showcasing machine learning for improving the forecast of business.

Worked on Designing and configuration of the database and back end applications and programs.

Hands on experience with Dimensional tables and Operational Data Store. Excellent communication, team management, analytical & troubleshooting skills. Visa Status - US Citizen

Work experience

Bank of New York, New York, USA

Sr. Vice President- Security Finance Technology May 2021 – till date

• Develop and maintain R, Python, and SQL scripts to support new client onboarding, generate collateral recommendations, and optimize margins across all client accounts.

• Oracle database usage and monitoring in the Linux environment

• Using Scrum Agile Methodology in my work (Daily Scrum Meeting, Planning PIs, Sprint Backlog, 1on1 meeting)

VCARE SOFTWARE SOLUTIONS LTD (T Mobile / SPRINT)

Data Scientist / Program Manager 2014-09 – 2021-04.

• Developed logistical regression model for Churn Prediction using rPart in R

• Build similar models in Python using neural networks but could not achieve significant increase on accuracy.

• Designed and Developed back-end architecture with mySQL & memSQL for customer Usage Analysis

• Developed R scripts for data ingestion for on prep CSV, XML and DATA files

• Developed R based data wrangling, data cleansing and data transformation scripts

• Developed R analytical scripts for statistical analysis and reporting

• Worked on Python to integrated the database for Data Analysis and reporting with CRM

• Developed call analytics solutions for performance monitoring, usage analysis, abusive usage, and call drop rates

• Configuring multi cluster Amazon Workspace for integrating concurrent asynchronous backend services routes with R,mySQL and memSQL clusters

• Developed front end analytical dashboards using R Shiny Front-end dashboard

• Developing multiple user access and authorization protocals for secure and dynamic R shiny dashboards

• Implemented and integrated Elastic Load Balancers and auto scaling groups on AWS with a local caching layer for optimized User experience VCARE SOFTWARE SOLUTIONS LTD (SPRINT / KARMALOOP)

Sr. Data Analyst 2013-07 to 2014-12

• E-commerce Customer Propensity Recommendation Engine

• Designed and Developed data driven products for US telecom

• Developed algorithm for generating CSAT score using R programming.

• Decision tree(rPart) and Random forest(randomForest) Model for segmenting subscriber base with R programming

• Algorithmic optimization of subscriber pools at carrier end to streamline analytical outcomes

Online Marketing Profile Model

• Designed scores to rate customers and hence segment the customer base for various online campaigns using R and Python.

• Brand analysis for procurement purposes using R programming and Excel VBA.

• Total customer analysis and building data visualizations for business management.

• Database design and data E.T.L management

• MySQL/ MemSQL Database design for Telecom data

• Call sentiment analysis model using tm, tidyR, spacyR, stringr with R programming

• Create diverse set of models to predict context of voice data and generate sentiment labels

• Create a corpus for regional voice data and clean voice data to remove redundancy and optimized storage

• Developed custom functions with lean regex to remove stopwords, character redundancy and sparse terms

• Create K-Means cluster and dendrograms to measure word association, cluster estimation

• Voice Data Sentiment Analysis

• Client Engagement and Offshore Team Management

• Achieved 100% client satisfaction

• I always aim at keeping the team motivated to learn the advanced analytics big data and BI tools

Engineering Colleges in Greater, Noida, INDIA

Professor and Head 2010-07 to 2013-05

Managed a Team of 8-10 Faculty members - Organised training and kept them motivated to achieve student satisfaction with good results Responsible for total Result Analysis, Student Master Data Analysis - at University level using Peoplesoft software and Excel. Also reporting the same to Top Management. Research and teaching Mathematics and Statistics to graduate and Post Graduate level Engineering and Technology

students.

MacrosoftInc.USA

Consultant(part-time) 2007-04 to 2010-05

• Analysed the business requirements and systematically designed a database for an client Telecom data for offshore team.

• Developed best practices in creating a complete project schema using Star Schema and Snowflake Schema

• Developed normalized and normalized OLTP tables, entity relationships, stored procedures, views, clustered and non-

clustered indexes and triggers

• Developed and implemented custom stored procedures for import and export of data using XML, CSV.

• Developed automated stored procedure for nightly maintenance and backup job.

• Create stored procedure according to the business reporting in a team-oriented environment.

• Implemented automated workflows for ingestion, cleaning and transformation scripts with R

• Individually authored, installed, deployed and managed reports using Excel and VBA from mySQL database.

Mazoon College for Management and Applied Sciences, Muscat, OMAN Senior Faculty 1998-11 to 2007-02

• Taught Operations Research and Quantitative Techniques which included Advance Statistics, Probability and Linear/

• Nonlinear Programming to Management students.

• Taught Mathematics/Statistics to engineering students. I also designed and coordinated a course of Quantitative Analysis

including Integer Programming, Decision Analysis and Game Theory.

• Implemented e-learning concept of coursework for maintaining lecture records and assignment submission.

• Jury member U.A.E.-Educational IT-Challenge.

• Mathematical modelling related to health and biomedical Delhi University, New Delhi, INDIA

Lecturer 1994-01 to 1998-09

• Working as lecturer in the Delhi University, handled successfully B.Sc. Hons.

(Mathematics)

Education

IIT-DELHI, INDIA

PhD 1990 - 1996

Specialization -Mathematics

Operation Research: 'Optimality Criteria and Duality in Non - Linear Minimax programming' under guidance of Prof. Suresh Chandra.

UNIVERSITY OF ALLAHABAD, INDIA

Masters in Mathematics 1986 - 1988

Stood Ist in the order of Merit. Specialization in Functional Analysis and Complex analysis. CERTIFICATIONS

• Certificate Course in Financial Modelling and Company

• Microsoft Inc. Certified for Professional Excel

• Certificate of Completion - Introduction to Python - Analytics Vidhaya

Contact this candidate