Vinay Kumar Chennupati

Chicago, Illinois, ***** • 312-***-**** • adees2@r.postjobfree.com

https://www.linkedin.com/in/vinay-kumar-chennupati-753357105 https://www.github.com/vinay173

SKILLS

• Programming languages: SQL, Python, Java, PL/SQL, Object Oriented Programming, JavaScript, CSS, JSON, HTML,

• Business Intelligence and Visualization: Qlik, Domo, ETL, Data Analysis, Data Preprocessing, Data Warehousing, Dimensional Modelling, Tableau, Microsoft Power BI, SQL Server Integration Services (SSIS), Oracle Business Intelligence (OBI), Operational Data Store (ODS).

• Data Analysis: DataOps, Google Big Query, Pandas, NumPy, Matplotlib, MYSQL, Excel, SQL Server Analysis/Reporting Services (SSAS)

• Applications/ Tools: Snowflake, Oracle Cloud Services, Looker, Jira, AWS Cloud, Oracle Data Integrator (ODI), Oracle E-Business Suite, Hadoop, Oracle Analytics Cloud, Informatica, Online Transaction Processing (OLTP), Online Analytical Processing (OLAP),IBM Datastage, jupyter Notebook EXPERIENCE

Rosendin Electric San Jose, CA, USA

Business Intelligence Developer - intern May 2019 - Aug 2019

• Developed interactive KPI dashboards and reports that aided marketing and allied teams by providing high-value information to respond to trends and make data-driven decisions.

• Analyzed complex user patterns, and performed churn analysis using Data Mining, Predictive Analytics models to make quantitative business decisions.

• Performed data preprocessing by profiling large sets of unstructured data from different sources using SQL merged it and extracted usable information using advanced data mining techniques.

• Forecasting by Trend Analysis of Revenue & various attributes by Division, Industry, and margin, generated various comparison graphs. Forsys Inc Hyderabad, India

Data Warehouse -ETL Developer April 2017-Jul 2018

• Designed and implemented data warehouse and data marts using Confirmed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema.

• The project involves ETL part where the Extraction is done from oracle EBS source tables, Transformed and Loaded into Staging Oracle database.

• ODI extraction jobs were developed to extract data from oracle EBS source tables and loaded into Oracle database. Various business logics, Transformation and mapping jobs are applied to the data and then loaded to the target data warehouse.

• Involved in enhancement, maintenance and Support of ETL jobs, routines, UNIX scripts and writing PL/SQL procedures and in calling them through ODI. Gitam University Hyderabad, India

Big Data Sep 2017 – April 2018

• One of 50 students selected to participate in the prestigious IBM program to learn big data analytics.

• Developed Map Reduce programs for applying Business rules on the data and executed hive queries for Denormalizing the data.

• Solved performance issues in Hive with an understanding of joins, Groups, and aggregation, and MapReduce jobs.

• Developed pig scripts to transform the data into a structured format and Hive queries for Analysis across different banners.

• Loaded the data from different sources like Oracle Database and Microsoft SQL Server into HDFS using Sqoop and loaded into Hive tables. Gitam University Hyderabad, India

Research Assistant June 2016 – Jan 2017

• Paper published in International Journal of Science Technology & Engineering, (IJSTE)

• “Survey on Big Data Analytics and Hadoop Tools”, Volume 3 Issue 07 ISSN: 2349-784X, page: 186 - 191. (January 2017) EDUCATION

Chicago State University Chicago, IL

Master of Science in Computer Science (GPA: 3.83/4) May 2020

• Relevant Coursework: Advanced Database Design and Implementation, Cloud Computing, Big Data Analytics, Data Visualization, Data Mining

• Honors: Awarded a merit-based graduate scholarship Gitam University Hyderabad, India

Bachelor of Technology in Computer Science and Engineering (GPA: 3.82./4) April 2018

• Relevant Coursework: Artificial Intelligence & Machine Learning, Data Mining, Cloud Computing, Probability & Statistics PROJECTS

Stock Market Analysis and Visualization Oracle Analytics Cloud Oct 2018 - Jan 2019

• Stock Market Analysis and visualization using data provided by Google Finance analyzing the change in the price of the stock over time. And visualize the correlation between different stocks closing prices and daily returns. Sales Trend Analysis Business Intelligence and Data Warehousing Sep 2018 – Dec 2018

• Built the SSIS package and Dimension and Fact tables using TSQL.

• Designed Tableau dashboards for assessing the product sales by day of the week and recommended a strategy for improving sales by, 40%. Online Book Store Web Application Feb 2018 – July 2018

• Designed and developed an online book store application. It is used by users to search for desired books and various categories.

• Cart of books selected is maintained in session and email is sent to user’s email ID.

• History of all the books brought by a user is maintained. Movie Recommendation System Jupyter Notebook Oracle Oct 2017 – Dec 2017

• Engineered an automated Web application applying Machine Learning algorithms, Item Based Collaborative Filtering.

• Mined Data sets deploying Python for deriving Similarities and correlations among the users.

• Recommended Movies close to user's choice based on reviews and past browsing history. UNICEF Country Data Analysis Tableau MS-Excel April 2017 – Sep 2017

• Performed an elaborated analysis over UNICEF's study on global sustainable development Goal (SAD) Targets for children under 5 Years old age in the USA, Canada.• Monitored Mortality rates and causes of death in these regions and visualized results in Tableau, post to data cleansing (Excel).

Contact this candidate