About Me
Hi, my name’s Archana. I am a recent grad, currently looking for opportunities in business analytics.
I am most skilled in: Tableau, PowerBI, Python, Excel, SQL, TextMining
Projects
Visualizing cricket data
Project LinkVisualize cricket player stats
Worked on Indian Premier League data using Tableau to analyze various stats and top performing players througout the seasons. The analysis was used by one of the advertisement companies in India to write an article for a maganize
Report on Analysis of Avocado Prices
Project LinkAvocado price analysis
I used R Studio to look into the avocado prices in US to determine if there is any price difference between conventional and organic avocados. We have also used Time Series analysis to understand the variation in avocado prices
Heart Stroke Prediction
Project LinkPredict heart stroke chances for a patient
Performed predictive analysis on patients data to determine how likely a person is to get a stroke using Azure ML Studio
COVID-19 Cases Worldwide
Project LinkCOVID-19 cases worldwide (dashboard)
Used Power BI to build visuals to see how did Coronavirus outbreak in US. (I have the screenshot of the work I did instead of PBI link. I was unable to share as the account is not Power BI Pro)
Experience
Data Analyst Intern
- Developing business architecture using requirements such as scope, processes, and risks.
- Writing SQL queries and analyzing the data using Power BI
- Using Python for data pre-processing and text mining to analyze survey data
Business Analyst
- Wrote SQL queries to understand and interpret data and to draw conclusions for managerial action and strategy.
- Collaborated on all stages of systems development lifecycle, from requirement gathering to production releases.
- Worked closely with the client for developing a banking app which in-turn boosted the customer base by 18% in one year.
- Built interactive reports, complex dashboards for clients, writing formulas for created KPIs in Tableau and Power BI.
- Used advanced Microsoft Excel to create pivot tables and pivot reporting, as well as use VLOOKUP function.
- Used statistical techniques to validate data and interpretations
The Sounth Indian Bank Limited
Business Analyst
Jun 2015 – Jun 2018
Marketing Head / Operations Manager
Jun 2015 – Jun 2018
Business Analyst
- Wrote SQL queries to understand and interpret data and to draw conclusions for managerial action and strategy.
- Collaborated on all stages of systems development lifecycle, from requirement gathering to production releases.
- Worked closely with the client for developing a banking app which in-turn boosted the customer base by 18% in one year.
- Built interactive reports, complex dashboards for clients, writing formulas for created KPIs in Tableau and Power BI.
- Used advanced Microsoft Excel to create pivot tables and pivot reporting, as well as use VLOOKUP function.
- Used statistical techniques to validate data and interpretations
Education
University of Washington
Master's in Business Analytics
Jun 2019 - Present
Currently pursuing masters in business analytics
Please See my projects section for the projects I worked on
Vignan Jyothi Institue of Management
MBA, Finance & Marketing
May 2011 - April 2013
Pursued MBA in India
To Be Updated
Jawaharlal Nehru Institute of Technology
Bachelors in Electrical Engineering
May 2007 - April 2011
Pursued bachelors in electrical engineering
To Be Updated
A Little More About Me
Along with my interest in crunching data to provide business insights, I like :
- Reading Blogs
- Cooking
- Playing outdoor sports