Sql Server Power Bi

MULAGANI SAI SANDEEP REDDY

+1-718-***-**** Indianapolis, IN

***********************@*****.*** www.linkedin.com/in/sai-sandeep-reddy-mulagani-670643267 SKILLS

• Languages: Python, R, SQL, SAS, HTML, CSS, JavaScript

• Tools: R Studio, Tableau, Power BI, Excel, Jupyter Notebooks, SQL Server Management Studio (SSMS), MySQL Workbench, phpMyAdmin.

• Technologies and Platforms: Big Data Technologies (Hadoop, Spark),Linux, Cloud Platforms (AWS, Azure, Google Cloud Platform), Database Management Systems (MySQL, PostgreSQL, SQL Server), Data Visualiza- tion (MATLAB, Tableau, Power BI, Matplotlib, Seaborn), Machine Learning (TensorFlow, Keras, PyTorch)

• Soft Skills: Time Management, Teamwork, Communication, Problem Solving, Leadership, Accountability PROJECTS

Hospital Data Analysis Python, HTML, CSS, MYSQL Workbench, phpMyAdmin

• Created a Flask backend to handle HTTP requests and manage data flow between the frontend and the MySQL database.

• Retrieved data from MySQL database to display information about medical centers, employees, physicians, patients, appointments, and pharmacy details.

• Implemented a structured database schema in MySQL Workbench for storing comprehensive healthcare data.

• worked on phpMyAdmin for web-based MySQL database management, facilitating data manipulation and query execution.

Sales Data Analysis and Visualization Python, SQL Server Management Studio (SSMS),Jupyter Notebooks, Tableau, Excel.

• Utilized SQL Server Management Studio (SSMS) to design and manage the database schema for storing sales data, ensuring efficient data organization and retrieval.

• Using Python within Jupyter Notebooks for data cleaning, pre-processing, and exploratory data analysis, lever- aging libraries like Pandas for data manipulation and Matplotlib for initial visualizations.

• Created comprehensive and interactive Tableau dashboards to visualize key sales metrics and trends, allowing stakeholders to gain insights and make informed decisions.

• Used Excel to compile final reports, integrating data visualizations and summaries to provide a clear and concise overview of the sales analysis results.

Student Budget Analysis Python, Jupyter Notebooks, MySQL,Linux, Tableau, Excel, Power BI

• Collected budget data from student surveys and integrated it into a MySQL database using Python scripts for automated data extraction and ETL processes.

• Cleaned and preprocessed the budget data using Pandas in Jupyter Notebooks, addressing missing values, standardizing data formats, and creating new features for in-depth analysis.

• Conducted exploratory data analysis (EDA) to identify spending patterns and trends, and created detailed visualizations using Matplotlib and Seaborn, as well as interactive dashboards in Tableau.

• Generated comprehensive reports and actionable insights to help students better manage their finances, utilizing Power BI for interactive reporting and Python for additional data analysis. New York Life Insurance Linux, Big Data Technologies, Azure, Data visualization, Servicenow

• Managed and monitored over 3,200 servers for an insurance client using Linux-based systems, ensuring high availability, performance, and security. Utilized ServiceNow for incident management and automated workflows, improving response times and reducing downtime.

• Implemented Big Data technologies such as Hadoop and Spark to process and analyze large volumes of data generated from the client’s servers. This enabled the extraction of valuable insights and patterns that informed strategic decisions.

• Leveraged Microsoft Azure to deploy and manage scalable cloud solutions, optimizing resource usage and cost- efficiency. Migrated critical workloads to Azure, enhancing the infrastructure’s flexibility and resilience.

• Created interactive and insightful dashboards using data visualization tools like Tableau and Power BI. These visualizations provided stakeholders with real-time insights into server performance, usage patterns, and key metrics, facilitating data-driven decision-making. WORK EXPERIENCE

System Engineer TCS Feb 2020 - Aug 2024

Production Engineer YSI Aug 2019 - Jan 2020

EDUCATION

Master’s Degree in Computer and Information Science, Purdue University May 2024 Bachelor’s Degree in Mechanical Engineering, Vignan Institute of Technology and Science June 2019

Contact this candidate