Sri Sai Vivek Cherukuri

**** ********* ****, ******, ** 75252 469-***-**** adbq56@r.postjobfree.com www.linkedin.com/in/vivek-cherukuri https://public.tableau.com/profile/vivek7405#!/

TECHNICAL SKILLS

Database

Programming languages

Data Integration

Visualization Tools

: MySQL; SQL Server; MS Access; Mongo DB

: Python(NumPy,Pandas,Scikit-Learn,Keras,Matplotlib); SQL; R

: SSIS; SSAS; SSRS; Alteryx

: Power BI; Tableau; Qlik View; Lumira; Crystal Reports Statistical Techniques : Linear Regression Analysis; Hypothesis-testing; ANOVA; T-testing; A/B-testing Business Intelligence : Tableau, Microsoft Excel (Pivot tables, V-Lookup); Google Analytics; Google AdWords; SAP BusinessObjects; MS VISIO

Big Data tools : Apache Hadoop, Hive, Spark

EDUCATION

The University of Texas at Dallas, Richardson, TX Expected May 2020 M.S., Information Technology and Management

• Relevant Courses: Designing Database Architecture and Business Intelligence, Business Data Warehousing, Programming for Data Science, Data Visualization, Predictive Analytics, Statistical Modelling, Machine Learning Vellore Institute of Technology, Vellore, India April 2013 – May 2017 B.E., Electronics and Communication Engineering

• Relevant Courses: C, Data Structures and Algorithms, Computer Architecture and Organization, Java, Economics EXPERIENCE

Data Analyst Intern, Cooperative Processing Resources, Dallas Sept 2019-Present

• Extracted data using SQL and created interactive dashboards in Power BI to help visualize incoming order.

• Designed OLAP cubes using SSAS on top of the Data Warehouse and used SSRS and Excel for reporting.

• Constructed SSAS Cubes using Star Schema with 10+ fact and 50+ Dimension tables to facilitate the new BI platform.

• Automated the ETL process using SSIS Packages and T-SQL scripts which improved overall time efficiency by 40%.

• Developed use cases, flowcharts, business process models, ER data model and star schema using MS Visio to communicate application design specifications.

Data Analyst, Smartgen Software Solutions Private Limited, India June 2017 - June 2018

• Created T-SQL scripts and used SSIS to automate ETL process for a Data warehouse.

• Collected, organized and integrated membership data from website and social media platforms to design master database using Microsoft SQL server.

• Investigated and conducted study on forecasts, demands, & capital for products using Tableau,SQL and summarized statistics of key performance metrics.

ACADEMIC PROJECTS

Extract Transform and Model GBI Sales Data SAP LUMIRA, Crystal Reports Jan 2019 – April 2019

• Created a data store object, data flow objects and loaded it with transaction, master data, star schema for GBI sales and financial data in SAP BW.

• Visualized the data using SAP LUMIRA to analyze the simulated business data and created a formatted report based on live sales and financial data using SAP design studio.

• Modelled and implemented a dashboard with identified KPI’S, built a mobile application based on data from the warehouse and used SAP Predictive Analytics tool to analyze and forecast scenarios. Vehicle Rental Database Management System MySQL Aug 2018 - Dec 2018

• Led user story and ER diagram development with logical and physical design as per business meta-data and appropriate data schemas with database architecture for an online vehicle rental system which supports high level commands.

• Architected and implemented mission critical, high performance transactional SQL database and optimized query processing and data retrieval.

• Established back-end connection with SQL server and generated internal reports on rental details, reporting user dashboards for a company, role, skill-based search in Tableau.

Contact this candidate