Power Bi Machine Learning

Sai Tharun Reddy Katha

LinkedIn +1-901-***-**** *********@*****.*** Memphis, Tennessee-38111

Education:

University of Memphis, Memphis, TN - G.P.A: 3.8/4.0 Jan 2023-May2024 Course Work: Business Database Systems, Data Visualization, Fundamentals of Data Analytics, Business Machine Learning, Project Management. Technical Skills:

Programming Proficiency: Python, Vb(.Net) C# (.Net), R, PowerShell, SAS. Databases: MS SQL, MySQL, Oracle SQL, Apache Cassandra, Mongo DB, SSIS, SSRS, NoSQL, Cypher. Workflow Tools: MS-Project, MS-VISIO, MS-Excel, MS-Word, MS–PowerPoint, MS- FrontPage, Google Collab, R Studio Visualization Tools: Power BI, Tableau Desktop, Google Data Studio AWS: S3, EC2, IAM, Power Apps

Python Libraries: Scikit-learn, NumPy, Pandas, Matplotlib, Seaborn CORE COMPETENCIES:

Problem Solving Communication Solid Numerical skills Decision making Adaptability Collaboration Mentoring and Leadership Multi-Tasking. WORK EXPERIENCE:

Graduate Assistant Teaching – Business Database Systems SQL, Normalization, ER diagrams, EER Diagrams, MongoDB Jan 2024-May2024

• Provide technical help to students struggling with database software or programming languages like SQL, Oracle, or MongoDB in the course.

• Offer office hours and additional support sessions to assist students with coursework, assignments, and understanding of complex database concepts. Respond to student inquiries via email or in-person promptly and effectively. Data Analyst– Satyam Ventures Engineering Services Pvt Ltd – Chennai, India C#, Vb.Net, MS SQL, Power BI Jan2020-Dec2022

• Gathered requirements from business users and worked on large datasets in Microsoft SQL and wrote store procedures and views.

• Designed and developed POCs for projects using SQL and Power BI.

• Developed Power BI reports for 15 million records of data by cleaning and converting it, to represent Microsoft sales monthly.

• Designed relational data warehouse with constraints for importing data. Implemented multiple types of database objects such as primary keys, foreign keys, stored procedures, triggers, views, and functions. Academic Projects:

IPL Data analysis Tableau Spring 2023

• Developed interactive dashboards and visualizations in Tableau to illustrate complex data relationships, enhance user experience, and facilitate real-time strategic decision-making.

• Designed and executed a comprehensive data analysis project on Indian Premier League (IPL) statistics using Tableau, focusing on player performances, team strategies, and fan engagement trends.

• Maintained and updated data visualizations regularly, incorporating the latest match data and trends, which supported ongoing strategic adjustments and media presentations.

Python Analysis on Kiva Loans NumPy, Pandas, Matplotlib, Logistic Regression Fall 2023

• Imported and managed a sizable CSV dataset of Kiva loans, employing NumPy operations for comprehensive data preprocessing and preparation.

• Illustrated dataset characteristics through diverse visualization techniques including bar charts, histograms, scatter plots, and other functionalities of Matplotlib.

• Engineered training and test datasets, meticulously evaluating model accuracy rates, and generating confusion matrices utilizing various algorithms from the scikit-learn library.

Demographic Research for Urban Planning Oracle SQL, Mongo DB Spring 2024

• Led a comprehensive demographic study using GIS and statistical software to analyze census data, focusing on migration patterns, housing needs, and demographic shifts for urban planning initiatives.

• Developed detailed GIS maps and visualizations to depict complex demographic trends, improving decision-making processes for city planners and community stakeholders.

• Authored and published a crucial needs assessment report that has become a foundational resource in shaping urban infrastructure projects and policy development.

Consequences of Liquor consumption on Grades of Students SAS Enterprise Miner Spring 2023

• Retrieved data from CDC and loaded the data into SAS enterprise miner and performed stats explore.

• Performed Logistic regression, Linear Regression, Cluster Analysis, Decision tree and other techniques using SAS enterprise miner for predictions. Greenspot Grocer Database Project MySQL Workbench, SQL Scripting, EER Diagram Development Spring 2024

• Expertly utilized MySQL Workbench for both visual and SQL to design, implement, and manage a normalized relational database system.

• Engineered an Extended Entity-Relationship (EER) diagram to visually represent database structures and used it to build a multi-table database.

• Authored SQL scripts to illustrate data integrity, relationships within the database, ensuring design viability through practical query execution. Certifications:

• Complete Professional Program (CPP) (Nov 2023), Data Analysis using Spark SQL (August 2023), Techniques for big data Analytics (August 2023), Data Analytics for management. (Jan 2023-May 2024) LEADERSHIP & ACHIEVEMENTS:

• Director of Social Media in Association for Management Information Systems (AMIS), University of Memphis.

• Volunteer, National Service Scheme, 2015-2018

• Volunteer, International Conference on Smart Cities ICSC’16, 2016.

• Employee of the month award in Jan 2022.

Contact this candidate