Sql Server Data Analysis

KISHORE KARTHIC BALASUBRAMANI

Phone: 469-***-**** Location: Dallas, TX ****************@*****.*** linkedin.com/in/kishorekarthic/ Trailhead: Kaykay1210

EDUCATION:

M.S., Management Science Aug 2021 - May 2023

The University of Texas at Dallas, Richardson, TX GPA: 3.56

B.E., Electronics and Communications Engineering Jun 2015 - May 2019

SSN College of Engineering, Chennai, India GPA: 3.0

SKILLS:

Concepts:

CRM, Big Data, Statistical Analysis, Databases, Collection, Cleaning, Modeling, Validation, Mining, and Visualization

Certifications:

Salesforce Administrator (Trailhead), Python and SQL for Data Analysis (Udemy)

Python & R:

Pandas, NumPy, SciPy, Matplotlib, Seaborn, SciKit Learn, TensorFlow, PyTorch

Databases:

MySQL, NoSQL, Microsoft SQL server, T-SQL, MongoDB, Oracle, MS Access, Db2

Salesforce:

Profiles, Roles, User Management, Process Automation, Security settings, Sharing rules, custom objects, custom fields, Page layouts, workflow, Validation rules, approvals, dashboards, and reports

Statistics:

Regression, Probability, Hypothesis Testing, Classification, and Time Series Analysis, A/B Testing, Forecasting

Analytics Tools:

Tableau, Power BI, Qlik Sense, Google Analytics, Adobe Analytics

Machine Learning:

Regression, Clustering and Classification, Decision Trees, Random Forest, KNN, Predictive Modeling

Other Tech:

Advanced Excel (VBA, Power Query, Macros, Pivot tables, VLOOKUP), SAS Studio, ERP, AWS, ETL, C++, Powerpoint

PROFESSIONAL EXPERIENCE:

Data Analyst Intern - Slesha Inc., Irving, TX May 2022 - Aug 2022

Expertise: Exploratory Data Analysis and Visualization

Collated & integrated data from 20+ databases across 7 systems, synthesizing into a cohesive report to inform strategic decision making.

Leveraged advanced exploratory data analysis techniques - such as descriptive and inferential statistics, data visualization, and cross-tabulation to ensure the accuracy and reliability of the data.

Designed and developed impactful visualizations and views, such as combo charts, stacked bar charts, geographic maps, sparklines, and crosstabs, for documentation purposes and to enable stakeholders to interpret complex data easily and quickly.

Data Center Administrator - Inspirisys Solutions, Bengaluru, India Sep 2020 - July 2021

Expertise: Data Center Administration using VMware

Successfully deployed and configured OS on physical servers, while also overseeing the management of 200 client virtual machines hosted in a high security, raised floor data center environment to satisfy requirement issues.

Ensured 100% system reliability by handling equipment and executing protocols with meticulous attention to detail. Implemented and managed backup/recovery protocols for reliable client data management.

Supervised detailed performance evaluations and continuous monitoring of ESX servers and virtual machines, and skillfully performed manual VMotions to optimize resource allocation and maintain optimal system performance.

PROJECTS:

ANALYSIS OF COVID VACCINE EFFICACY IN TEXAS Nov 2022 – Dec 2022

Tools and Concepts: Excel, Tableau

Related coursework: Data Visualization using Tableau, Spreadsheet modeling and Analytics.

Gathered and Cleansed Texas Vaccine data which comprised of 1.6 million rows and 22 columns using Microsoft Excel.

Visualized vaccine distribution among people based on different criteria such as age, demographic factor, and metro status etc.

Created and presented stories on the efficiency of vaccine in various places of interest within the state of Texas.

SALES MANAGEMENT TOOL Nov 2022 – Dec 2022

Tools and Concepts: Salesforce.com, Lightning App Builder and Reporting

Related coursework: CRM with Salesforce

Developed a custom app to enhance employee engagement and tracking sales opportunities using Salesforce.com.

Executed Chatter, Workflows, Validation rules, added quick actions and created roles and profiles for respective employees.

Collaborated and designed custom Dashboards and Reports to simplify and expedite decision making for managers.

MOVIE RECOMMENDATION SYSTEM May 2022 – June 2022

Tools and Concepts: Python – NumPy, Pandas, SciPy, Seaborn, Matplotlib, Plotly, SciKit Learn

Related coursework: Programming for Data Science, Predictive Analytics

Performed Data Cleaning and Exploratory Data Analysis (EDA) on the raw data using Python.

Implemented a recommendation system to predict rating of 17k+ unrated movies of Netflix data using XGBoost.

Quantified a low Root Mean Square Error of 1.067 between predicted and actual rating using matrix factorization.

STUDENT DATABASE MANAGEMENT SYSTEM Feb 2022 – April 2022

Tools and Concepts: MongoDB, MySQL Workbench – ER Modeling, Aggregate and Grouping, Joins and Subqueries

Related coursework: Database Foundations for Business Analytics

Designed and normalized a data model with 2000 records and 30 variables from scratch using MySQL workbench.

Identified relationships between 16 entities through ER modeling and assigned respective primary and foreign keys.

Executed SQL queries on the final database and validated the same in MongoDB to achieve a faster run time of 16%.

Contact this candidate