working in office
Working

Bu​siness Analyst & PMO

I am a seasoned Agile Business Analyst with over ​seven years of experience in business analysis and ​project management. I have led numerous ​successful projects in the banking and finance ​sectors and have been recognized for my ​exceptional performance and dedication. Currently, ​I contribute to digital education initiatives for ​underprivileged children through an NGO.

Bhavna

Gautam

A Woman Looking at the Drawing on the Paper

©2024

About Me

Hello, I'm Bhavna Gautam, a seasoned Agile Business Analyst with ​over seven years of experience in business analysis and project ​management. I have excelled in the banking and finance sectors, ​leading numerous successful projects and being recognized for my ​exceptional performance and dedication.


Currently, I am involved with an NGO, contributing to digital ​education initiatives for underprivileged children. I hold ​certifications from the International Institute of Business Analysis ​(IIBA) and have a strong background in Agile methodologies.


Outside of work, I enjoy nature walks, hikes, yoga, and meditation. ​These activities help me stay balanced and foster a sense of well-​being. My passion for delivering innovative solutions and driving ​organizational success motivates me in every project I undertake.



Buildable Instagram UI Plus Icon

MY ​​TECHNOLOGY ​​VOYAGE

Learning

Bachelors of Engineering in ​Electronics and ​Communication from GLA ​Unive​rsity, Mathura

Wo​rking

Strategic Business Analyst at ​Soch NGO

Business Analyst at Infosys ​(Client: Citi Bank), Bristol

Business Analyst at Infosys ​(Client: Capital Group )

Business Analyst at Infosys ​(Client: Morgan Stanley)

Ce​rtifications

International Institute of

Business Analysis (IIBA) - Agile

Analyst Certified

Fundamentals of Business

Analysis ​- Udemy

Ag​ile Fundamentals - Infosys

Portfolio

Highlights

01

Real estate US SQL and Power BI analysis


Empowering ​change through ​agile solutions. ​Business analysis ​is not just my ​profession; it's my ​passion.

Buildable Instagram UI Plus Icon
Plant in Decorative Vase
A Person Drawing on White Paper

Real estate In USA : SQL and Power BI ​analysis


The Main goals of this project were to:


  • To clean the dataset from Kaggle about real estate ​in the United States using SQL


  • Explore data in Bigquery,


  • Group and prepare data for visualization in Power BI


  • Create comprehensive dashboards, including ​interactive property stats, the price calculator that ​can count average prices by given parameters, and ​a dashboard that shows the quantity of sold ​properties in different states and the sales ​distribution among the months in the year for ​effective data exploration.
cat shadow glyph icon

Code and Files : https://github.com/bhavnagautam17/business-analyst-portfolio

Buildable Instagram UI Plus Icon

Real estate In USA : SQL and Power BI ​analysis


Skills: analytical thinking, data cleaning, data analysis, ​data vizualization


Hard skills: Bigquery SQL, Power BI, Dashboards


Results: Data was cleaned (which reduced the ​amount of data by about nine times), explored in ​Bigquery, imported into Power BI, transformed, and 3 ​dashboards were created.

Buildable Instagram UI Plus Icon

get in touch

navigation pointer

Li​nkedIN

https://www.linkedin.com/i​n/bhavna-gautam/

Email Icon

Email

gautambhavna17@gmail.com

Books and Decorative Ornaments on a Center Table
Two People Trying to Solve Different Puzzle Puzzle