Data Sales

PREKSHA GOPALAKRISHNA

www.linkedin.com/in/preksha-gopalakrishna

**************@*****.*** Mobile: 313-***-****

EDUCATION

Oakland University, Rochester, Michigan Aug 2019 - Present

Master of Science in information technology & Management – Major in Business Analytics GPA: 3.97/4.0

Visveswaraya Technological University, Bangalore, India Aug 2011 - Jun 2015

Bachelor of Engineering – Computer Science GPA: 3.6/4.0

TECHNICAL SKILLS

Programming/Scripting Languages: Python, Excel-VBA, UNIX Shell Scripting

Data Mining Tools: SAP Enterprise Miner, JMP

Data Visualization: Power BI, Tableau

Database: Oracle, Microsoft SQL server, Microsoft Access

Hadoop technologies: Hive, Impala and Basic Pig

Query Languages: SQL, MySQL

Microsoft Office: Excel, Word, PowerPoint, Project, Visual Studio Enterprise

Web Analytics: Google Analytics 360 suite, hotjar, Google AdWords, Google Tag Manager, Google Optimize

SAP: EHP7 FOR SAP ERP 6.0, SAP EHP2 FOR SAP NETWEAVER 7.0(ECC), Solution manager 7.1 & 7.2, SAP BW, SAP CRM, SAP HCM

WORK EXPERIENCE

OAKLAND UNIVERSITY Aug 2019 – Apr 2020

Graduate Research Assistant

Research on how the impact of emotion inherent in a product review from Amazon.com affects the product ratings

oWeb scraping from Indeed website to get the job listings of different companies using Python

oExtracted the product reviews from Amazon.com to get the dataset.

oImputation of the missing values in the dataset for Data Cleaning

oCombined the required variables into a single excel as Data Integration using VBA code

oApplied the different Data Mining techniques such as MLR and evaluated patterns and found the accurate model for the dataset which predicts the emotion inherent in a product review on the Amazon website.

oThe model predicts if a verified/helpful product review affects the product rating

Tools/Technologies: Python, Excel VBA, JMP

Research on Injury Severity patterns and accidents at Highway Rail grade crossings

oUnderstood the different set of variables in the data set

oImputing the dataset for missing values as a part of Data Cleaning

oJoined the required variables into one single table from multiple files as part of Data Integration using SQL queries.

oApplied various Data Mining Techniques to find the accurate model

Tools/Technologies: SQL, MySQL, JMP

Assisted Seasonal adjustment for unemployment data series

oRetrieved the historical data series for unemployment based on Industry

oPerformed Seasonal adjustment of the data series using EViews

Tools/Technologies: Excel, EViews

SAS STUDENT SYMPOSIUM COMPETITION

Published a paper for the SAS Student Symposium Competition on Text Analysis of Yelp customer reviews using SAS Enterprise Miner

oConversion of the json files to csv using Python

oUsed the Text Rule builder, to analyse the customer reviews of the restaurants and to understand if the restaurants had been closed due to the negative reviews on Yelp

oSentiment Analysis is done based on the customer ratings. This could be used by the owners to concentrate on areas to improve in a restaurant

Tools/Technologies: SAS Enterprise Miner, Python

CAPGEMINI INDIA PVT. LTD Jul 2015 - May 2019

Associate Consultant, Bangalore, India

Manage the database that support performance improvement activities

Query the database - SQL to produce reports and analyze the database

Build monthly and weekly reports and dashboards

Wrote SQL queries to change the Oracle parameters and ABAP parameters

Wrote Cron jobs to check the system status and update the user it’s performance

Daily system monitoring and solving the issues observed.

Oracle SBP update, Kernel upgrade, Hana Revision Patch update, SPAM/SAINT update, IGS Update

Linux/windows patching on monthly basis.

System copy Oracle and HANA

SSFS configuration, Operation modes, Central User Administration.

Background Job Administration, User Administration.

Client Administration like Client copy, Client Export and Import, Remote Client Copy.

COURSEWORK

Introduction to Database Management

Business Analytics

Advanced Database and Big Data Management

Software Project Management

Introduction to Data Science

Web Analytics

Quantitative methods for Managers

Practical Computing with Data Analytics with R and Python

ACADEMIC PROJECT

Retail Store Data Warehouse

oPerformed ETL services for loading the data from the three sources onto the created Data Warehouse in SQL server

oCreated a Multidimensional Cube for analyzing the sales data among the different stores and the Revenue data across the different states and years.

oUsed SSRS to build the reports to view the sales of the different products category-wise and year-wise, Revenue of the Retail store month-wise

oPerformed Market Basket Analysis to see which two products were often bought together

oUsed Tableau for Data Visualization and analyzed the Sales, Revenue across the states, month, Season & year and Quantity per Product Categories sold per Season

Tools/Technologies: SQL, SSIS, SSAS, SSRS, Visual Studio, Tableau

Loan Prediction Based on Dollar Amount

oAnalyzed whether the loan (high, medium, low) was approved for a customer based on customer variables such as gender, education, marital status, applicant income, credit history etc.

oData Preprocessing by imputing the missing variables

oAnalyzed correlations among different variables and used Principal Component Analysis – PCA to check if variables can be excluded from the model.

oApplied various data mining models such as Logistic Regression, MLR, Decision tree, KNN

oChose the best model by comparing the different models and validating the dataset.

Tools/Technologies: Excel, JMP

US Census Data

oDeveloped an application using EXCEL-VBA that allows the user to view demographics, Income, Means of Transport, Ethnicity of Population, Employment of the population by the user’s choice of state and year in the drop down. Also created an application for comparing the most densely populated states across the years.

oA home page which consists of all the buttons that a user can navigate to, for accessing the different applications by the VBA code

oCreated dynamic charts for displaying the statistics, which change as and when the raw data is changed.

oUsed Tableau for a more interactive visualization of the demographics, employment, poverty, ethnicity of population, means of transport across the different states and years

Tools/Technologies: Excel – VBA, Tableau

Supermarket Sales

oNormalized the data and loaded the data into the SQL Server

oPerformed analysis using Power BI for various types of customers, products brought frequently and analysis of branch for knowing the highest sales

oSales analysis showing total sales across the year and quarterly ranges, days of the week and time in which most sales have been made

oProduct Analysis which says which categories of products have been bought the most

oCustomer analysis based on type and gender, Rating of the customer based on gender and payment

Tools/Technologies: SQL, SQL server management studio, PowerBI

Contact this candidate