Manager
Icici Bank
Total years of experience :16 years, 10 Months
Provide end to end analytics support for given business lines with an objective of increasing campaign revenue/marketing efficiencies/customer value or improving risk management.
Build predictive models / behavioral segments / event triggers for cross sell / activation / retention / attrition control models to enhance core operating profits.
Responsible for analysis of the portfolio through detail analysis to drive lead identification, credit policies / pricing strategies / portfolio management strategies.
Using statistical tools to interpret data sets, paying particular attention to trend and patterns that could be valuable for getting insights that can be used for developing business strategies.
Work with business / functional stakeholders to understand objective / problem statements,
generate hypothesis to solve the objective / problem and run data driven analysis to validate the same.
Regular interaction with business / product / functional team.
Building analytics capabilities of the team and managing projects to ensure timeline deliveries.
Attrition Analysis utilizing SQL: identify the key factors which affects on the customer churn from iMobile application for UPI related activities. The factors like, gender, marital status, profession, area, life style, account vintage etc. affects on customers’ churn.
Interpreting data, analyzing result using statistical technique and provide ongoing reports
Developing and implementing database, data collection system, data analytics and other strategies that optimize statistical efficiency and quality
Analyzing data from primary/secondary data sources and maintain database/data systems
Identifying, analyzing, and interpreting trends or patterns in complex data sets
Building and leveraging advance visualization and data analysis skills, to create the foundations for sound business recommendation
Creating analytical solution modeling logic within a variety of analytics tools and on a variety of big data platforms as required by the bank, creating robust documents of solutions and underlying design decision
Acting as analytic translator, communicating complex data related requirements between business and IT stakeholders
Utilizing a hypothesis-driven problem-solving approach to design, construct, and rapidly test/iterate exploratory analytics that will reveal insight and opportunities for the business
Generating efficient data marts, analysis and reports on large data sets, building basic automations to reduce manual interventions for reported analysis and data updates
Working with management to prioritize business and information needs
Processing large amounts of structured & unstructured data, including integrating data from multiple sources
Collaborating with analytics and business teams to improve data models that feed business intelligence tools, increasing data accessibility and fostering data-driven decision making across the organization
Implementing processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it
Performing data analysis required to troubleshoot data related issues and assisting in the resolution of data issues
Developing python codes, modules, generic functions and deliver the same
Partnering with Digital Business, IT, and external suppliers to ensure the company’s data science needs are met and issue are resolved
Collaborating with different teams in data management and extraction of insights
Mobile Banking Dashboard utilizing Qliksense: dashboard which will help to analyze Demographic (Zone, Region, Area and Age-Wise) visualizations of register users, Mobile banking usages trend and more;
Customer Insights Dashboard utilizing Qliksense: dashboard which will help to analyze different kinds of visualizations such as Demographic, Quarterly Balance-wise, Age-wise and Account opening mode-wise visualizations
Bank Insights Dashboard utilizing Qliksense: dashboard which will help to analyze total volume of transaction with facet; demography, branch size; along with financial and non-financial transactions, customer walk-in
Network Node Monitoring Dashboard utilizing Qliksense: dashboard which will help to analyze multiple incidences with facets demography, categories, timeframe
Teams Dashboard utilizing Qliksense: dashboard which will help to analyze Adoption rate, Active user stats, other activity on team application
Adi Bot Dashboard utilizing Qliksense: dashboard which will help to analyze Bot performance; Total session, Avg. conversation per sessions; user engagements; avg. duration per chat, conversion type, user interest
Preparing timely, reliable and relevant analysis to stakeholders
Studying and comprehending market scenarios, developing new business analytics to improve business and overcome the existing challenges
Managing large database management; improving the database handling and automating the reports utilizing excel VBA
Performing data analysis to provide the business insights to clients, to acquaint about the flaws in the existing business practice
Regularly reviewing market trends to comprehend new business trend, build the strategy to overcome new challenges and seek new opportunities
Developing forecasting model for various projects
Key Projects:
Forecasting Ocean Freight Cost: To develop the model on the basis of independent variables like container counts, container book volume, container book weight and fuel cost (regression model)
Performed data analysis of researches, interpreted and delivered presentation of the respective studies
Analyzed prevalent market environment, identify business risks & implement effective mechanisms to mitigate the same
Mapped client requirements and implemented strategies to achieve client satisfaction including tracking market dynamics and initiating reinforcements to neutralize competitors' moves
Created Project Analysis, prepared Techno-Economic Feasibility Reports, Market Survey Analysis, Valuation Analysis
Performed research and data collection; conducted analysis to determine client’s technical and strategic needs
Maintained timely MIS & database reflecting the trends & developments of the company regarding business development, vendor reconciliation for budgetary & strategic review to enhance the business of the company
Cancellation Analysis: To identify reasons for order cancellation, investigate the model that has more frequency for order cancellation and provide the counter majors
Market Penetration Analysis: Analyzed TIV data and classified market penetration for the brand, for segment and find the cause that affect for reduction in market share
Performed data analysis of researches, interpreted and delivered presentation of the respective studies
Analyzed prevalent market environment, identify business risks & implement effective mechanisms to mitigate the same
Mapped client requirements and implemented strategies to achieve client satisfaction including tracking market dynamics and initiating reinforcements to neutralize competitors' moves
Created Project Analysis, prepared Techno-Economic Feasibility Reports, Market Survey Analysis, Valuation Analysis
Performed research and data collection; conducted analysis to determine client’s technical and strategic needs
Maintained timely MIS & database reflecting the trends & developments of the company regarding business development, vendor reconciliation for budgetary & strategic review to enhance the business of the company
Cancellation Analysis: To identify reasons for order cancellation, investigate the model that has more frequency for order cancellation and provide the counter majors
Market Penetration Analysis: Analyzed TIV data and classified market penetration for the brand, for segment and find the cause that affect for reduction in market share
Successfully managed the entire gamut of activities pertaining to Size Scale Analysis of Sales and Sales Forecasting using Trend Analysis or Regression.
Accountable for performing analysis of the sale trend on the basis of average sale of 10 stores, publishing 10 reports on weekly basis.
This is course which gives insight about the predictive and forecasting technique.
