Still Struggling with Tech Hiring? Discover Olibr's Solution Now!
Login / RegisterDeveloperClient
Login/Register

Satish Chatta

Cluster Manager

  • Bangalore Urban, KA
  • 9 years
Notice Period: 60 Days

    Candidate's About

    With 9 years of experience as a Team Leader and Individual contributor in IT and Finance, I specialize in Business Intelligence, Statistical analysis, and Data Visualization using SQL, SSRS, SAS, Tableau, and Power BI. Proficient in Azure data warehouse, DAX expressions, and Tableau dashboards for real-time business tracking.

    Work & Experience

    C

    Cluster Manager

    May 21 - PRESENT

    Technology

    • Icon
      SQL
    • Icon
      Python
    • Icon
      Excel
    • Lead the Data Science unit and oversee the team's activities.
    • Collaborate with cross-functional teams to define data science projects and objectives.
    • Develop and implement data-driven strategies and models to support business decision-making.
    • Analyze and interpret complex data sets to derive actionable insights and recommendations.
    • Stay updated with the late...
    Read More

    Super APP & Payments Data Science Unit

    Cluster Manager

    • Handling BIU & Data scient team of Bajaj APP & Payments Business
    • Supports end to end activities of App Engagement, App Retention and App Performance
    • Supporting Payments business of BBPS/BFL Wallet and UPI
    • Perform analysis and provide insights to Payments Business by using inhouse data.
    • Support end to end data management activities like handling unstructured data to prepare data model for Power BI Dashboards
    • Creating SPs, Jobs to provide data for campaign on real time to increase the campaign efficiency through SSRS and maintains the campaign efficiency above the AOP range
    • Responsible for data enrichment and data analysis for Payments Business.
    • Created Calculated Column and Measure and calculated Tables using DAX Expressions in Power BI Dashboards
    • Worked on Creation of KPI and Dashboards using which Enhances the visualization for Stake holders of their Business using Power BI
    • Developed various Dashboards like APP engagement, Retention, BBPS Transactions, UPI Setup & Activation, wallet setup & Activation dashboards.
    • SQL
    • Python
    • Power BI
    • Tableau
    • Excel
    View Details
    S

    Senior Unit Manager

    May 18 - Apr 21

    Technology

    • Icon
      SQL
    • Icon
      Python
    • Icon
      Excel
    • Icon
      Tableau
    • Worked as a BPS Analyst at Tata Consultancy Services (TCS) in Bangalore, fulfilling various roles and responsibilities in the past.
    • Conducted analysis of business processes and identified areas for improvement and optimization.
    • Collaborated with stakeholders to gather requirements and define project scopes.
    • Assisted in designing and implementing solutions for proces...
    Read More

    Insurance Data Science Unit

    Sr Unit Manager

    • Performed analysis and provided insights to Insurance Business using in-house data.
    • Supported end-to-end data management activities for Insurance business.
    • Utilized SSMS to work on big data for customer segmentation in various insurance campaigns (Health/Motor/Life/Assistance).
    • Created Stored Procedures and Jobs to provide real-time data for campaigns through SSRS, maintaining campaign efficiency above AOP range.
    • Developed a Lead generation model to track HOT/WARM leads post-campaign and shared it with the call center team to increase business penetration.
    • Automated reports for digital channels business to monitor customer digital footprints.
    • Responsible for data enrichment and analysis for Insurance Business.
    • Built propensity models using statistical tools to increase insurance business penetration and reduce cancellations (5% business impact observed).
    • Performed Cancellation Analysis using decision trees with ANGOS.
    • Built Propensity models using Random Forest in Python to identify digital-savvy customers for Email Campaign.
    • Conducted customer segmentation for pre-approved Life insurance using ANGOS.
    • Created Calculated Columns, Measures, and Tables using DAX Expressions in Power BI Dashboards.
    • Developed KPIs and Dashboards in Power BI to enhance visualization for stakeholders.
    • Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
    • Developed Tableau visualizations and dashboards using Tableau Desktop.
    • Created various Dashboards like Penetration and Business Dashboards for Insurance Business.


    • Tableau
    • Power BI
    View Details
    D

    Deputy Manager

    Aug 16 - May 18

    Technology

    • Icon
      SQL
    • Icon
      Excel
    • Deputy Manager at Bajaj Finserv with various responsibilities.
    • Managed and led a team to achieve business objectives and targets.
    • Conducted performance reviews and provided feedback for team members' development.
    • Collaborated with cross-functional teams for process improvements and operational efficiency.
    • Participated in strategic planning to support busines...
    Read More

    CD RISK (BIU )

    Deputy Manager

    • Generated SQL queries with necessary join conditions and efficient use of indexes for superior query performance.
    • Modified existing stored procedures and report dataset queries as per user requirements.
    • Created indexes on tables to enhance database performance and enable faster data retrieval.
    • Developed stored procedures, views, functions, and tables when needed.
    • Participated in technical decisions for business requirements, collaborating with Business Analysts and BIU Team.
    • Monitored risk metrics, highlighted stress/trends, and simulated historical data for projected impact of proposals.
    • Managed risk pool, including dealer performance, insurance cancellation framework, and ORM, leading to 25% lower losses than AOP.
    • Provided timely feedback to management on portfolio trends and concerns in monthly Risk Reviews, along with periodic reporting of MIS and Dashboards.
    • Conducted monthly analysis of marginally riskier segments and suggested corrective actions to senior management.
    • Engaged in routine interactions with stakeholders, including Business Heads, Credit, Risk Control Unit, Operations, and IT, for process optimization.


    • SQL
    • SAS
    • Excel
    View Details
    B

    BPS Analyst

    Oct 13 - Aug 16

    Technology

    • Icon
      SQL
    • Icon
      Power BI
    • Icon
      Python
    • Icon
      Tableau
    • Performed analysis and provided insights to the Insurance Business using in-house data.
    • Supported end-to-end data management activities for the Insurance business.
    • Worked on big data using SSMS to segment customers for different insurance campaigns (Health/Motor/Life/Assistance).
    • Created stored procedures and jobs to provide real-time data for campaigns through SSRS...
    Read More

    Nielsen Market Research (Analytics & Insights)

    BPS Analyst

    • Performed analysis and provided insights to the Insurance Business using in-house data.
    • Supported end-to-end data management activities for the Insurance business.
    • Worked on big data using SSMS to segment customers for different insurance campaigns (Health/Motor/Life/Assistance).
    • Created stored procedures and jobs to provide real-time data for campaigns through SSRS, maintaining campaign efficiency above AOP range.
    • Developed a lead generation model to track HOT/WARM leads post-campaign, shared with the call center team to increase business penetration.
    • Automated reports for digital channels business to monitor customer digital footprints.
    • Responsible for data enrichment and data analysis for the Insurance Business.
    • Built propensity models using statistical tools to increase insurance business penetration and reduce cancellations by 5%.
    • Conducted cancellation analysis using decision trees with ANGOS.
    • Built a propensity model using Random Forest to identify digital-savvy customers for Email Campaigns, conducting analysis in Python.
    • Performed customer segmentation for pre-approved Life insurance using ANGOS.
    • Created calculated columns, measures, and calculated tables using DAX expressions in Power BI Dashboards.
    • Worked on creating KPIs and Dashboards to enhance visualization for stakeholders using Power BI.
    • Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
    • Developed Tableau visualizations and dashboards using Tableau Desktop for Insurance Business and Risk domain.


    • Python
    • Tableau
    View Details

    Education

    J

    Bachelor's in pharmacy

    Jawaharlal Nehru Technological University
    2008 - 2011
    I

    MBA

    IIM
    2017 - 2019

    Achievements

    • Hero Award - For supporting Insurance and investment Mart development
    • Spot Awards - for RISK Deck delivery