Akansh Rastogi
Mumbai
Summary
Data Analyst with 4+ years of experience in the BFSI sector, skilled in analyzing financial and customer data to support business growth. Proficient in Python, R, SQL, SAS, and data visualization tools like Power BI, and Tableau. Experienced in developing predictive models, monitoring delinquency, and collaborating with cross-functional teams to deliver actionable insights, and drive data-driven decisions.
Overview
9
9
years of professional experience
Work History
Senior Manager
Axis Bank
Mumbai
08.2022 - Current
- Created various weekly and monthly reports for the stakeholders, and shared the insights through presentations and automailers to make business decisions and build strategies.
- Automated these reports in tools like BDL, Power BI, Excel, and PySpark.
- Developed, executed and tracked customer-level campaigns and nudges focused on cross-sell, engagement, and deepening customer relationships with the help of SQL, Big data lake and Pyspark.
- Implemented a Delinquency Tracking System to monitor borrower behavior, and support credit risk model analysis and performance validation.
- Streamlined the campaign management system to improve the turnaround time of the Go-Live date.
- Identified the next best product that can be sold by the channel through the random forest and Apriori algorithm.
- Changed the project lifecycle from Waterfall to Agile through Jira for the team.
- Conducted daily stand-up meetings with the team, and also reviewed calls with the stakeholders.
- Collaborated with cross-functional teams, including marketing, product, and data engineering, to drive data-driven strategies and deliver business impact.
- Identifying the factors of high attrition rates, and finding the actionables to reduce attrition through a decision tree.
- Streamlined the calls by identifying the best customers to call for various products, to increase the overall revenue of the bank.
- Identified areas of improvement within existing operations through process analysis and benchmarking studies.
- Independently managed individual tasks while leading a team to ensure timely and accurate delivery of project deliverables.
Consultant Data Analyst
EXL Services
Delhi
11.2021 - 08.2022
- Generate business insights and analyse data to create targets.
- Created frameworks for weekly, monthly, quarterly, and adhoc requests.
- SPOC for the loyalty team of a retail client for analyzing customer behavior.
- Developed complex and optimized SQL queries for data retrieval.
- Created documents to identify various possible challenges and their data-centric solutions for the retail industry.
Trainee Apprentice Leader
Musigma
New Delhi
08.2020 - 11.2021
- Handled teams of decision scientists and trainee decision scientists.
- Managed end-to-end project, starting from gathering client needs to delivering outcomes.
- Delivered business insights using visualization and predictive modeling.
- Collaborated with internal stakeholders, identifying and gathering analytical requirements for customer, product, and projects needs.
- Developed SQL queries to research, analyze, and troubleshoot data and created business reports.
- Optimized the manual supply chain processes using analytical tools for an Oil and Gas company.
Project Manager
Innoraft Solutions
Jaipur
03.2019 - 07.2020
- Extracted data from GCP and created Digital Marketing plans for more visibility.
- Successfully delivered websites for LTTS, Dhiomics, Knowledge Base using Agile methodology.
- Created SRS documents for various projects to gather the requirements for the technical team.
- Built healthy relationships with clients by using analytical and consulting methods.
- Conducted company-wide Learning and Development sessions.
Senior Business Development Manager
FACE
Pune
07.2016 - 12.2018
- Worked at FACE for 2 years and 6 months, 9 months as a trainer, and 1 year and 9 months as a Business Development Manager.
- A team player who has worked consistently with teams (team size 5-40 people) on different projects and has experience of training in various parts of the country.
- Experience in Content Development (Corporate/College level), evaluation, and training.
- Good managerial skills especially in building rapport with the client, evaluating the post-training assessments, and submitting the report to the clients.
- Single-handedly managed the sales of the whole Gujarat and Nashik regions and achieved the targets.
Education
Post Graduate Certificate of Higher Education - Analytics and Decision Science
T. A. PAI MANAGEMENT INSTITUTE
ManipalBTech - Information Technology
Swami Keshvanad Institute of Technology Management
JaipurSkills
Technical skills
- Programming and data languages: Python, R, SQL, PySpark
- Data analytics and BI tools: Power BI, Tableau, SAS Enterprise Guide (SAS EG), SAS Viya
- Project and workflow management: JIRA, Agile methodology
- Data analysis
- Business intelligence
- Data visualization
- Credit risk analysis
- Campaign management
- Customer relationship management (CRM)
- Data-driven decision making
- Stakeholder Engagement
- Cross-functional team collaboration
Accomplishments
- Star Award, Axis Bank – Q4 FY 24
- Team Builder Award, Axis Bank – Q4 FY23
- Emerging Sales Champion of the Year 2017, FACE
Timeline
Senior Manager
Axis Bank
08.2022 - Current
Consultant Data Analyst
EXL Services
11.2021 - 08.2022
Trainee Apprentice Leader
Musigma
08.2020 - 11.2021
Project Manager
Innoraft Solutions
03.2019 - 07.2020
Senior Business Development Manager
FACE
07.2016 - 12.2018
Post Graduate Certificate of Higher Education - Analytics and Decision Science
T. A. PAI MANAGEMENT INSTITUTE
BTech - Information Technology
Swami Keshvanad Institute of Technology Management
Similar Profiles
Lakshay SharmaLakshay Sharma
Deputy Manager at Axis Bank (On Payroll Of Axis Bank)Deputy Manager at Axis Bank (On Payroll Of Axis Bank)
Preethi VPreethi V
Relationship Associate at Axis Bank - Axis Max Life InsuranceRelationship Associate at Axis Bank - Axis Max Life Insurance
Prodip SahaProdip Saha
Collection Officer at HDFC Bank, Bajaj Finance, Axis Bank, IDFC BankCollection Officer at HDFC Bank, Bajaj Finance, Axis Bank, IDFC Bank
ANIL BASAKANIL BASAK
Sales Manager at Axis Max Life Insurance Co. LTD With (AXIS BANK)Sales Manager at Axis Max Life Insurance Co. LTD With (AXIS BANK)
Suraj SethSuraj Seth
Assistant Manager – Direct Tax at CBV & Associates LLPAssistant Manager – Direct Tax at CBV & Associates LLP