Suresh Karthik Balasundaram

Cincinnati, OH-***** 513-***-**** ac5s1p@r.postjobfree.com LinkedIn - sureshkarthik90 Github - sureshkarthik90 SKILL SETS

Tools/Technology: SQL, Tableau, R, PL/SQL, Python, SQL developer, IBM SPSS Modeler, SAS, Toad, Excel, Visio, SVN, GitHub, Oracle EBS (Project Management)

Machine Learning: Linear and Logistic regression, Decision trees, Neural networks, Association rules, Linear discriminant analysis, Support Vector Machines, K-means, KNN

Data Management: Database Modeling and Design (ER Modeling), Process Modeling EDUCATION

Master of Science in Information Systems, University of Cincinnati GPA: 3.8/4.0 Available: May 2018 Data Analytics Graduate Certificate

Bachelor of Engineering, Electrical and Electronics, Anna University GPA: 8/10 April 2012 PROFESSIONAL EXPERIENCE 4.5 years

Senior Project Engineer – Wipro Ltd, Bangalore, India August 2015 – June 2017 Analyzed and automated business reports related to Budget allocation and Utilization % of employees for Cisco using SQL, PL/SQL and Excel. Implemented alert notifications for under/over utilization of resources and cost

Slashed manual effort by 100% using SQL for a Job monitoring console which monitors backend programs

Collaborated with BI Team to generate budget and compliance reports using SQL and Tableau

Designed comprehensive Excel template for cost expenditure using pivot tables and VLOOKUP function

Improved efficiency of project by automating fix for repetitive issues, reducing issue count by 70%

Reduced dependency on senior associates by 50% through recommending and implementing KMS

Led and mentored a 4-member team on querying, analyzing and presenting business reports to clients Project Engineer – Wipro Ltd, Bangalore, India January 2013 – July 2015

Implemented complete data migration for Cisco from 11i to R12 Oracle Projects ERP using PL/SQL & SQL

Designed Stored procedures and packages, functions, triggers, views, indexes and tables using TOAD

Prepared technical & functional specification documents as per requirements as a part of SDLC cycle PROJECTS UNDERTAKEN ( https://github.com/sureshkarthik90 ) Predicting Resale value of cars using R

Predicted 4-year resale value using Linear, Generalized additive, Neural network, Decision tree models

Determined best model based on best in-sample and out-of-sample average SSE values of above models Market Basket Analysis using R – Cincinnati zoo data

Analyzed food transactions by performing Clustering analysis with K-means & Associations using Apriori

Validated clusters using within-group SSE, Silhouette and Dunn index, Hierarchical clustering methods Study of Cincinnati Heroin Overdose incidents Tableau Viz

Built Tableau dashboard to visualize seasonality patterns and police response time of heroin overdose Seasonality and Social media impact on Movies using R TMDB_Movies_Analysis

Performed data cleaning using ‘tidyr’, ‘dplyr’, ‘DT’, ‘jsonlite’, ‘knitr’, ‘readr’ packages in R to prepare data

Visualized relations between rating, cost and ROI of movies using ‘ggplot2’, ‘ggpubr’ and ‘plotly’ packages Delivery speed impact on Customer Retention using R

Predicted QVC Retail’s customer repeatability with Logistic, SVM, Neural network & Decision tree models

Compared above models using AUC and Accuracy (confusion matrix) metrics to determine the best model ACHIEVEMENTS

Runners up - Case Study competition for mitigating risks in online transactions, Centric Consulting 2018

Pursuing Data Scientist with R career track certification in DataCamp (completed 70%), 2018

Mesh – Excellence award by Cisco Business Unit for the successful implementation of Automation, 2015

Transformer award by Cisco Business Unit for exceptional performance in R12 Re-Implementation, 2014

Contact this candidate