Junior Business Analyst: SQL & Power BI

Ujwala Gadipudi

+1-734-***-**** ***************@*****.*** linkedin.com/in/ujwala-gadipudi-828b961b0

Summary

Business Analytics graduate with 1 year of experience as a Software Engineer supporting production applications in a banking environment. Skilled in SQL, Power BI, DAX, Python, data analysis, and data visualization, with hands-on experience investigating data and application issues, building dashboards, and communicating with clients and cross-functional teams.

Education

Webster University (St. Louis, MO)

oMaster of Science in Business Analytics (May 2026)

Anurag College of Engineering (Hyderabad, India)

oBachelor of Science in Computer Science Engineering (May 2022)

oGPA: 6.5

Sri Chaitanya Junior Kalasala (Hyderabad, India)

oIntermediate

oGPA: 8.14

Brilliant Grammar High School (Hyderabad, India)

oSSC Board

oGPA: 8.5

Experience

Software Engineer LTI (Chennai, India) May 2022 - May 2023

Software Engineer — LTI CITI Banking Project

Supported a production DataStage application for a banking client, investigating and resolving application and data-related incidents through ServiceNow.

Monitored production jobs and analyzed DataStage logs to identify failures, missing source files, and upstream processing issues.

Used SQL to query databases, join tables, filter and aggregate data, validate records, and investigate missing or duplicate data.

Investigated production incidents by tracing issues across upstream and downstream processes and coordinating with cross-functional teams to restore processing.

Communicated directly with clients regarding production issues, investigation status, resolution, and follow-up actions.

Collaborated with offshore and upstream teams to troubleshoot incidents, rerun failed processes, and ensure required data was successfully loaded.

Projects

Prediction Of Covid-19 Confirmed, Death And Cured Cases In India Using Random Forest Model (Machine Learning)

oDeveloped a model to predict the spread of COVID-19 in India using a Random Forest algorithm.

oAnalysed historical data to identify trends and patterns in confirmed cases, deaths, and cured cases.

oUtilized machine learning techniques to build a predictive model.

Virtual Mouse Operation Using Webcam (Machine Learning, Python)

oDesigned a system that allows users to control a mouse cursor using eye movements via webcam.

oImplemented image processing techniques to detect pupil position and track eye movement.

oDeveloped a Python script to translate eye movements into mouse cursor movements.

Unveiling the Warming World: The Facts and Figures in the Rising World Temperature

oAnalyzed a Kaggle dataset related to global temperature trends using Python.

oPerformed exploratory data analysis to understand patterns and trends in the data.

oApplied linear regression to examine the relationship between relevant variables and temperature trends.

oInterpreted analytical results to communicate findings about changes in global temperature.

Video Game Sales Analysis Power BI

oBuilt an interactive Power BI dashboard using the VGSales dataset to analyze video game sales across years, genres, platforms, and publishers.

oCleaned and prepared the dataset by removing duplicate records and blank values and correcting data types for accurate analysis.

oCreated DAX measures using aggregation functions such as SUM to calculate total sales, including regional sales measures such as North America and Europe sales.

oDeveloped bar charts, line charts, and pie charts to compare sales across games, platforms, genres, publishers, and years.

oAnalyzed sales patterns to identify high-performing games, platforms, and genres and compare sales across regions.

oDesigned the dashboard to provide a visual overview of sales performance and support data-driven analysis.

Skills

Technical Skills: DBMS, Tibco, IBM MQ, SQL, C, C++, Java, Python, SQL, R, Machine Learning, Data Visualisation, Data Analysis.

Tools: Excel, Tableau, PowerBI

Software Development: PHP, HTML, JavaScript

Soft Skills: Communication, Teamwork, Problem Solving

Contact this candidate