Ganesh Kolla
Bangalore
Summary
Data-driven Business Analyst ready to leverage business knowledge and project management strengths to enact lasting and successful changes to company culture and operational practices. 4 and a half years of experience in Corporate with strong stakeholder management. Interests: Business fundamentals, Sustainable strategies, and Technology driven growth solutions Active in volunteering to help teammates with work prioritization and knowledge sharing.
Overview
4
4
years of professional experience
Work History
Data Analyst
Credit Saison
09.2023 - Current
- Automation of major Collections Reports and regulatory reporting such as Collection Efficiency and Bureau report
- Produced monthly performance reports using advanced Excel spreadsheet functions.
- Utilized data visualization tools - Tableau & Qliksense to effectively communicate business insights.
- Database migrations to Redshift and currently working on Databricks. Built end to end date pipelines for Operations and Collections teams.
- Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
Business Analyst
Axis Bank
08.2021 - 09.2023
- Developed and maintained Central Salary Algorithm aimed at detecting Salary credits in Savings Accounts which is critical to Lending programs for the Bank. Decreased significant risk and improved accuracy by ~10% in recent development.
- Built a Web scraping tool (Python based) capable of scraping the EPFO Portal (with Captcha recognition). Potential to target ~5 Crore retail customer base and ~6 Lakh Corporate Salary relationships. Analytics to categorize and provide specialized Asset offerings to Corporate Employees.
- Automated nudges for Salary customers featuring a range of personalization elements like, age, and demography to improve customer experience. Estimated to increase Salary customer base by ~14%
- Developed Simulators (Excel based) for business teams to help with FY Targets on Salary Business for the Bank.
- Enabled reports (Automation oriented) on Salary Business for Channel teams and Management - Salary Dashboard, Product Penetration dashboard, Grower Eroders dashboard, and Salary Credit Report. (Business Impact - ~240 Cr MDAB)
- Providing support and conducting regulatory activities - Migration of Salary customers (Reduces losses by ~3Cr), T+7 Calling, Salary Winback programs.
Intern
CABS, DRDO
05.2019 - 06.2019
- Developed a MATLAB GUI Code to help with the automation of quantitative analyses of critical flight parameters and Risk Management.
Education
Bachelors - Aerospace Engineering
Indian Institute of Technology
Madras, TN01.2021
Intermediate - MPC
Narayana Junior College
Vijayawada, AP01.2017
X - ICSE
Seventh Day Adventist
Nuzvid, AP01.2015
Skills
- AWS cloud services
- Project coordination
- Stakeholder management
- Financial planning
- Visualization Tools - Tableau, Qliksense
- Python, SQL, Pyspark, Excel
Timeline
Data Analyst
Credit Saison
09.2023 - Current
Business Analyst
Axis Bank
08.2021 - 09.2023
Intern
CABS, DRDO
05.2019 - 06.2019
Intermediate - MPC
Narayana Junior College
X - ICSE
Seventh Day Adventist
Bachelors - Aerospace Engineering
Indian Institute of Technology
HOBBIES
RC Airplane/Drone building and flying, Exploring new places, Outdoor sports