Data Analyst

PRABHU RAMAKRISHNAN

469-***-****

*************@*****.***

www.linkedin.com/in/prabhu-ramakrishnan

SUMMARY

Graduate Student with four years of experience in corporate industry and exploring opportunities in making data driven decisions and building strategies to transform the organization across Technology, E-Commerce, and other sectors.

EDUCATION

The University of Texas at Dallas, Richardson, TX December 2018

M.S., Business Analytics GPA: 3.92

Anna University – College of Engineering Guindy, Chennai, India May 2012

B.E., Electrical & Electronics

TECHNICAL SKILLS

Analytical: Python, R Studio, Base SAS, Linux, Excel - VB Macro, Git, Salesforce, MS Dynamics CRM 365

Web & Visualization: Python (Matplotlib, Seaborn), R-Shiny, Tableau, Power BI, HTML5, CSS, JavaScript

Database: MS SQL Server, MS Access, MS Visio, Sqlite3, Oracle SQL, PL/SQL, SSRS, MongoDB

Big Data: Scala, Apache Hadoop (Map-Reduce, Flume, Sqoop, Storm), Spark, Pig, Hive, Spark SQL, Kafka, Azure

Statistical Models: Data Mining, Machine Learning, Natural Language Processing, Panel – Time Series, Deep Learning

WORK EXPERIENCE

JVCKenwood, Irving, Texas May 2018 – September 2018

Sales Data Analyst Intern

Validating and analyzing sales & customer data using Salesforce, SSRS, Power BI and Documenting the process.

Data Migration & ETL of Dealer Accounts, Contacts & Opportunities from Kenwood Dynamics CRM into EFJ CRM

Mining data of Cities & Counties with Max Population 100k for Predicting and Exploring new Leads & Opportunities.

The University of Texas at Dallas, Richardson, Texas December 2017 - April 2018

Graduate Teaching Assistant

Conducting Analytical labs for undergraduate students in Oracle SQL, Tableau, and Excel VB.

Preparation & Evaluation of Projects/Assignments for graduates in Big Data Tools like Hive, Spark, Pig, Sqoop.

NTPC Ltd., Vindhyachal, India August 2013 - December 2016 Assistant Manager / Data Analyst

Engaged in preparation of daily Gap Analysis report, daily profit report.

Optimized station availability by designing Integrated Frequency Monitoring System (IFMS) - a Logistic Regression Predictive Model thereby increasing profits.

Predicting Scheduled Generation Capacity using Time Series Forecasting.

ACADEMIC EXPERIENCE

Scheduling Analytics, Social Media Analytics, Medicare and Medicaid Analytics, Market Basket Analytics in Python

GitHub Link: https://github.com/prabhuramak91/Prabhu-Projects.git

Extract, Transform, Load(ETL) & Analysis of Los Angeles Crime Data using Sqoop and Pig in Linux Environment to

Import data into HDFS and Aggregating crime by Victim Descent, Gender and Area Name & Street for future insights.

Marketing Predictive Analysis of Hertz Corporation data to analyze Marketing Insights and Increment Revenue

Using Latent Class (LCA) Segmentation, Price Elasticity and Market Basket model with SAS.

Data Analysis of Income of Adults to classify individuals and identify significant factors using Random Forest, Naïve

Bayes and Decision Tree model with R and R-Shiny (for GUI).

ACADEMIC HONORS AND AWARDS

Honors: Dean’s Excellence Scholarship 2017-18, Graduate Teaching Assistant – 2018, Scholar of High Distinction

Certifications: Certificate in Project Management (CIPM), R for Data Science: DAT204X, Google Analytics

Contact this candidate