G Shubhankar Reddy

Experience

• 

  ICICI Bank

  Sept 2019 - Jul 2020

  Value Banking Officer

  Customer Assistance: Offered prompt and courteous assistance to around 350+ customers regarding their banking needs, including inquiries about accounts, transactions, products, and services.Cross Selling & Upselling: Identified cross-selling and upselling opportunities to strengthen customer relationships and accomplish sales targets, promoting additional bank products and services as per client requirements.Troubleshooting: Investigated & resolved customer complaints or issues promptly, escalating complex issues to higher authorities when necessary for resolution. Show less

• 

  Self Employed

  Oct 2020 - May 2023

  Financial Consultant

  Provided in-depth analysis of cross-sector data, delivering actionable insights that supported critical business decisions and optimized performance outcomes.Developed customized data solutions, including dashboards and reporting tools, to streamline risk management and enhance data-driven strategies.

• 

  Self-employed

  Aug 2023 - now

  Analyst

  1. Air Quality for 26 Indian Cities Python Predictive Model-Analyzed air quality data for 26 Indian cities (2015-2020) using Python (Pandas, Seaborn, Matplotlib, Scikit-learn) and developed a Linear Regression model, using exploratory data analysis (EDA), time series analysis, and predictive modelling.-Revealed essential pollution trends and patterns, such as for the period of 2015 to 2020 Ahmedabad is the most polluted city and Bengaluru has the highest average increase in pollution. Moreover, winter months from November to January are the most polluted months and PM 2.5 is the major pollutant.2. Vrinda Apparel Store Sales & Customer Trends Excel & Power BI Analysis-Cleaned and analysed dataset of 31,000+ rows & 21 columns using pivot tables, charting, VLOOKUP in Microsoft Excel-Uncovered significant trends, including the highest number of sales are via Amazon and Kurta Set in size M is the best selling product.-Built an interactive Power BI dashboard allowing users to visualise trends by apparel category, size, seasonality, gender, sales channel, etc.3. Credit Card Transaction Report PostgreSQL and Power BI Analysis-Refined data via PostgreSQL and developed an interactive Power BI visual dashboard from 10,000+ rows & 20 columns utilizing DAX queries.-Identified that married businessmen are the key customers and major revenue comes from expense bills followed by entertainment via swipe method.4. Netflix Insights Titles & Viewer Engagement SQL Analysis-Refined dataset of 5000+ rows & 8 columns via MS SQL Server, using COUNT(), SUM(), AVG() and conditional aggregation with CASE statements.-Devised key metrics including the most watched genre is Crime/Thriller followed by Science Fiction and there is a weak positive correlation between IMDB scores and number of votes. Moreover, the most watched content form is Series/shows. 5. Data Visualization via Tableau- Understanding Retail Payment Behavior- Bank Fraud Detection Analysis Show less

• 

  Accenture

  Apr 2024 - Apr 2024

  Data Analyst

  -Conducted an audit of Social Buzz's big data practice, assessing data cleaning, and analysis techniques via pivot tables and COUNTIF in Microsoft Excel.-Developed recommendations for a successful Initial Public Offering (IPO), including market analysis and strategic planning.-Identified 16 distinct content categories. Out of which Animals and Science are the most popular ones, followed by technology, healthy eating and food. -The most preferred content form is Photo followed by video. Moreover, the month of May has the highest number of posts. Show less