Profile

Information Technology Management Master's graduate from Oakland University, skilled in data analysis and business intelligence. Proficient in SQL, ETL, and Excel. Collaborative team player with a track record of translating data into strategic business insights. Seeking a role as a Data Analyst or Business Analyst to apply analytical expertise and contribute to organizational success. Education

Master's in Information Technology Management, Oakland University 09/2022 – 12/2023 Rochester, USA

Bachelor's in Computer Science Engineering,

Sreenidhi Institutte of Science and Technology

08/2017 – 09/2021

Hyderabad, India

Skills

Databases: SQL MySQL MS-Access Data

Modeling Data Mining ETL Packages Reporting

Services

Analytics: Descriptive Perspective Predictive

Logical Thinking Multitasking

Programming: C Java Python HTML Data

Structures SAS.

Tools: MS-Excel Excel VBA Power Point Word

Access Database Google Suite Tableau Scrum

Use Case Story Agile Project Management

Sequence Diagrams Visual Basic

Data science and ML: Linear Regression Decision

tree Apriori Algorithm Market Basket Analysis

KNN

Projects

NeuroFuel Company DataWarehouse, Intern

•Designed and implemented a data warehouse using SQL Server Management Studio and ETL process for NeuroFuel, a mental strength training app for athletes

•Project Deliverable Detail: Data Warehouse Design and ETL Process Utilized SQL Server Management Studio to construct a data warehouse from provided .csv files. Implemented a two-step process, converting data to a staging database before creating distinct Snowflake Schema (dimUser, dimTeam, dimOrganization, dimCategory, dimSection, dimSession, dimTime, FactUserSessions) and Star Schema (dimUser, dimSession, dimTime, FactUserSessions) data warehouses. Implemented ETL processes for efficient loading of data into the respective databases.

07/2023 – 12/2023

•Created and published two Power BI dashboards to provide data-driven insights into app usage and engagement by user, team, and organization

•Analyzed and evaluated the database and the reports, identified challenges and learnings, and suggested future work for improving the project

•Utilized SQL language to query and manipulate data from various sources and create calculated measures and columns

•Applied data visualization best practices and techniques to create interactive and user-friendly reports with various charts, filters, and slicers Sai Surya Teja Kona

ad21hs@r.postjobfree.com 248-***-**** Auburn Hills, MI https://www.linkedin.com/in/sai-surya-teja-kona-2325401a1/ CO2 Emissions, Using SAS

•Conducted comprehensive data exploration, revealing insights into variables influencing CO2 emissions.

•Analyzed correlations and built three predictive models—multiple regression, classification and regression tree (CART), and neural network. Identified CART as the most accurate model, emphasizing its relevance for automotive manufacturers.

09/2023 – 12/2023

•Concluded with practical implications, highlighting the potential for optimizing vehicle design to minimize carbon footprint and inform decisions on fuel types and efficiency.

Language Translation with LSTM- RNN

•Developed a deep learning project utilizing recurrent neural networks (RNNs) and long short-term memory (LSTM) layers to translate English to Hindi1.

•The ANKI dataset of 2979 sentence pairs was used, and data preparation techniques such as tokenization, padding, and one-hot encoding were used. 09/2023 – 12/2023

•Using TensorFlow and Keras, I experimented with multiple model topologies, parameters, and training settings to get high-quality translation output. Gravity Book Store. Oakland University

The data originated from GitHub and then processed in MS Excel in order to focus on cleaning and analysing the data.

Developed an ETL package to extract data from the source (15 excel files) and construct a Dimension table and Fact Table for the destination 01/2023 – 04/2023

• source - SQL server.

•A Visual Basic Cube and Report created based on the data in MSSM (Microsoft SQL Server Management) to produce the desired output.

Big Chemical Inc. Oakland University

Created a database in MS-Access to track employees, employees' education, badges, doors, building access at the office, and the types and

• numbers of sensors installed in the buildings.

09/2022 – 12/2022

Wrote SQL queries to build tables and required outputs, such as creating a report with employee details such as complete details, education,

• and drug test results.

Creating a Web Server application with Database tables, Relationships between tables, Forms which assist in the addition, modification, and deletion of data in the tables, Data Validation Rules and Procedures, and Access Database Reports. Delivered a safe and efficient MS-Access

•database.

Stock Market Analysis. Oakland University

•Utilizing Kaggle, I gathered daily stock data for five firms, processed it in MS Excel for evaluation and stock trajectory prediction.

•Excel macros automated data visualization. Employed Tableau for creating dynamic graphics to forecast the Stock Market, generating trend lines, candlestick, bar, and line graphs.

09/2022 – 12/2022

•Implemented dashboard filters for time-series analysis. Developed two dashboards for comprehensive stock analysis, focusing on volume, share gain, share decline, and total quantity of shares from previous stock data. Certificates

Introduction to Data Analysis

using Microsoft Excel

Contact this candidate