Data Analyst

EDUCATION

Robert Morris University, Illinois

July 2018

Master’s in Management

Information Systems

Coursework: Data Analytics, Statistical

Research, Java, Database Design, Data

Warehousing, Advanced Finance, IT

Management Frameworks.

Illinois Institute of Technology

June 2017

Coursework in Computer Science

Visvesvaraya Technological University

(VTU), Karnataka, India

June 2014

Bachelor of Engineering in

Computer Science & Technology

SKILLS

Tools: Microsoft Office, Oracle 9i,

Customer Service, MS Access, MS

Visio, Pentaho, SAS, Google

Analytics, SSRS

BI and Visualization Tools: Tableau,

PowerBI, IBM Cognos, QlikView,

OBIEE, Spotfire.

Programming Languages: C, C++,

Java Script, SQL, PostGRE SQL,

HTML, Oracle, Python (Pandas,

Numpy, SciKIt), R.

Programming Languages: Oracle

DB, MySQL, SQL Server,Hive.

WORK EXPERIENCE

Data Analyst & Graduate Assistant at Robert Morris University September 2017–July 2018

• Automated and published analytical reports for college data across various academic years that contained the total enrollment and retention of students, their ethnicity, their gender, scholarships awarded using SQL, Cognos Report Studio and Tableau.

• Extracted data from administrative systems using Cognos and SQL Developer. Prepared summary reports using MS Access and SPSS.

• Handled large datasets of the university that had over 2 million records by formulating SQL queries in Oracle Database.

• Used SAS a to create several intricate datasets which produced statistics, tables, figures, charts and graphs.

Assistant Systems Engineer/Business Intelligence Elite Software August 2014–November 2015

• Designed and implemented a mechanism to fetch data from the database and trigger an email of all the collected information to the user.

• Performed Data Analysis to give an insight to the product sales and help business to identify growth opportunities.

• Performed data extraction and manipulation over large relational data sets using SQL.

• Prepared ad-hoc tableau reports by making use of filters and calculated fields for internal sales and marketing team.

• Created a story line and advanced interactive dashboards to depict the customer’s segmentation using Tableau.

Financial/Data Analyst Intern Elite Software

January 2014–May 2014

• Generated Excel reports of financial data and collected data from financial statements using Bloomberg.

• Supported analysts in building financial models. Created performance reports and earnings notes.

• Validated financial information assumptions and methodology based on financial concepts.

• Performed analysis and reconciliations of relevant balance sheet account. ACADEMIC PROJECTS AND PRESENTATIONS

Data Analysis for an e-commerce company by using SQL, SAS and SSRS

• Performed data analysis of 100,000+ records consisting of sales data of various products across years.

• Implemented “Affinity Analysis” to discover co-occurrence relationships between products by analyzing customers purchase behavior.

• Performed Regression Analysis and Predictive Analysis using SAS and offered recommendations. Data Analysis of NEISS data using Python, Pandas, Numpy, Seaborn and Tableau

• Executed data analysis of 90,000+ records involving multiple datasets with the details of an injury

• Used Pandas and Numpy to identify the top three injured body parts.

• Calculated the total number and gender percentage of skateboard injuries using Python and Pandas.

• Performed Kernel Density Analysis using Seaborn to find the age distribution and injuries across various races. View additional projects on LinkedIn.

SHREYAS RAMESH 312-***-**** ***********@*****.*** linkedin.com/in/shreyas-ramesh/

Contact this candidate