Suresh Karthik Balasundaram
Cincinnati, OH-***** 513-***-**** ********@****.**.*** 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