Santanu Bagani

Santanu Bagani

Intern

Followers of Santanu Bagani447 followers
location of Santanu BaganiMumbai, Maharashtra, India

Connect with Santanu Bagani to Send Message

Connect

Connect with Santanu Bagani to Send Message

Connect
  • Timeline

  • Skills

    Analytics
    Business Analytics
    C
    C++
    Chatbot Development
    Cross-functional Team Leadership
    Crystal Reports
    Customer Analytics
    Dashboards
    Data Analysis
    Data Management
    Data Warehouse Architecture
    Data Warehousing
    Deep Learning
    Descriptive Analysis
    Digital Transformation
    ETL Tools
    Financial Analysis
    HTML
    Interpersonal Communication
    IT Enabled Business Transformation
    Java
    JavaScript
    Marketing Analytics
    Microsoft Power BI
    Microsoft SQL Server
    MIS
    Mobile Application Development
    MySQL
    Natural Language Processing (NLP)
    Oracle
    Oracle SQL Developer
    Patch Management
    PL/SQL
    Predictive Analytics
    Prescriptive Analytics
    Presentation Skills
    Procurement
    Purchase Orders
    Quality Assurance
    Regulatory Compliance
    SQL
    Statistical Inference
    Tableau
    Team Leadership
    Tender Management
    Time Management
    Trend Forecasting
    Vendor Management
    Web Development
    Algorithms
    Linux
    ASP.NET
    NET
    Python
    Django
    Visual Basic
    Oracle PL/SQL Development
    JSP
    Web Applications
    Java Enterprise Edition
    J2EE Application Development
    CSS
    Business Continuity Planning
    Struts
    PR/Publicity through IT
    Php
    Oracle PL/SQL
    J2EE Application
    Business Continuity
  • About me

    I’m a Certified Analytics Leader and Data Architect with over 13 years of experience in transforming how financial institutions leverage data for strategic decisions and operational excellence. Currently serving as Assistant General Manager – IT at LIC Housing Finance Ltd., I lead enterprise-wide initiatives focused on unified data platforms, cloud-agnostic architectures, and high-impact analytics solutions. My journey has been defined by innovation and impact—whether it's launching the company’s first mobile app for customer onboarding, deploying intelligent chatbots, or building interactive analytics portals that have improved data accessibility and slashed reporting turnaround by 70%. I bring deep hands-on expertise in Power BI, Oracle, SQL, and ETL automation, along with a strong foundation in regulatory compliance frameworks such as IFRS 9 and IND AS. I thrive in agile environments, and as a certified Scrum Master, I enjoy mentoring teams and collaborating across departments to drive performance and purpose. Additionally, I played a pivotal role in formulating the company’s first Business Continuity Plan (BCP), establishing robust IT contingencies and ensuring seamless regulatory adherence. My mission is to lead data-driven transformations - delivering innovative, scalable, and inclusive technological solutions that create measurable value for customers, businesses, and society at large.

  • Education

    • Kendriya Vidyalaya Ballygunge, Kolkata

      2004 - 2005
      Higher Secondary Science (Computers)
    • Mumbai Educational Trust, MET League of Colleges

      2009 - 2012
      Master of Computer Applications - MCA Computer Application

      Activities and Societies: Took an initiative in college to be a part of Computer Society of India for the 1st time and eventually co-ordinated successfully in opening the Student Branch of Computer Society of India(CSI). Secretary of MET-ICS's Student Branch Committee, Mumbai Chapter. Represented institute along with my band called Xound Flu in Zee Business's Reality show called ICICIdirect.com ASPIRE - Music to Money Challenge and won the City Finale and went up till Zonal Rounds. Successfully participated and represented institute in a reality show "ASPIRE - MUSIC TO MONEY CHALLENGE" on Zee Business Channel based on Musical Band performance and Business Quiz. Also actively participated in different singing shows.Participated in Technical events in different colleges' TechFest.Helped institute in successfully introducing CSI (Computer Society of India) Student chapter in college and held seminars.

    • University of Calcutta

      2005 - 2008
      Bachelor of Science - BS Computer Science (Honours)

      Activities and Societies: Participated in Singing Competitions.

  • Experience

    • Homi Bhabha Centre for Science Education (HBCSE), TIFR

      Jan 2012 - Jun 2012
      Intern

      Developed Version Control Module of GNOWSYS (Gnowledge Networking and Organizing SYStem) Studio, a free semantic web knowledge network using Python in Django framework.

    • LIC Housing Finance Limited

      Jun 2012 - now

      • Leading the organization's first unified data management platform as a Project Manager and Data Architect, overseeing the end-to-end project lifecycle—from evaluating technical solutions to stakeholder engagement. Driving the adoption of a cloud-agnostic Data Management Architecture, defining key components, including Data Ingestion, ETL, Data Warehouse/Lake/Lakehouse, BI & Visualization, ML/AI, and Data Governance & Security.• Led the Data Analytics team developing the company's first analytics portal, improving data accessibility and decision-making. Streamlined regulatory reporting, automated processes, and drove cross-departmental collaboration to enhance forecasting and trend analysis.• Supervised teams managing core financial applications and digital platform solutions.• Developed scalable analytical solutions, enhancing efficiency with SQL query automation and reusable ETL components in Oracle DB; Utilized Tableau, Power BI, and Crystal Reports for comprehensive data visualization.• Managed regulatory key metric calculations and financial disclosures, ensuring timely reporting across all legal entities.• Partnered with Accounts to develop IND AS-compliant amortization strategies and analyze ECL provisions per IFRS 9.• Contributed as a key member of the Asset Liability Management Committee (ALCO) support group for 4 consecutive years, providing strategic insights and analysis to optimize financial management and decision-making. Show less • Headed the Data Analytics Team, crafting bespoke analytics, refinance pool evaluations, and regulatory reports tailored to diverse organizational requirements.• Led cross-functional collaboration to oversee Scrum teams on Digital Platforms, ensuring project deliverables met timelines and budget constraints.• Managed vendor Scrum teams, establishing templates and integrating automated reports within a new financial lending application as part of a Digital Transformation initiative.• Oversaw the rollout of a new lending application across the Eastern Region, providing on-site support to 27 offices during implementation.• Designed and implemented backend SQL packages and procedures in Oracle for EHRMS (ERP for Human Resources and Operations Management).• Managed the Board Information System (BIS) in collaboration with the Secretarial Department, catering to senior management and Board of Directors' needs.• Handled administrative responsibilities including drafting internal notes, overseeing purchase orders for specialized IT procurements, and managing corporate social media platforms.• Acted as an authorized signatory, responsible for reviewing Payment Vouchers and Journal Vouchers. Show less • Ensured adherence to regulatory standards and enhanced efficiency within Data Analytics development.• As Project Manager, led five projects and Scrum teams, driving the company's Digital Transformation. Key achievements include:o Developed and deployed the first customer onboarding Mobile App.o Implemented the company's first Chatbot on web and WhatsApp Business platform.o Redesigned and enhanced the Corporate Website, achieving launch within 45 days.o Introduced the Fraud Reporting & Management System (FRMS).o Integrated an Automated Feedback rating system for customer feedback via SMS and web URLs into the CRM application.• Managed multiple Scrum teams to maintain and enhance key applications including the Customer Portal, CRM system, Task Management Portal, Board Information System, and Online Loan Application Module.• Oversaw vendor relationships, including RFPs and Tenders process for procurement and services• Implemented patch development within the core financial application to address retail loan issues. Show less • Automated reporting processes by creating reusable ETL components within Oracle DB.• Designed and implemented web portals for internal users, including functionalities for task management, inventory tracking, and purchase order management.• Developed modules and reports within the Core Financial Lending Application using the Java Struts Framework and JSP.• Led several Scrum teams as Scrum Lead, directing project timelines for initiatives like the Corporate Website, Customer Portal, Online Loan Application Module, and Property Microsite.• Created the company's first Business Continuity Plan, outlining IT systems and process strategies for disruptions.• Managed and enhanced the company's online presence across social media and other platforms as IT Nodal Officer and member of the PR/Publicity Committee.• Managed tape backups for servers housing critical financial and accounting data as part of Data Center Operations.• Supervised a team overseeing IT hardware asset reconciliation across 200+ nationwide offices. Show less

      • Assistant General Manager (IT)

        Feb 2023 - now
      • Manager (IT)

        May 2022 - Feb 2023
      • Deputy Manager (IT)

        May 2017 - May 2022
      • Assistant Manager (IT)

        Jun 2012 - May 2017
  • Licenses & Certifications

    • Professional Scrum Master I

      Scrum.org
      Jul 2023
      View certificate certificate
    • Executive Programme in Business Analytics

      SPJIMR - Executive Education
      Jun 2024
      View certificate certificate
    • Managerial Effectiveness Program

      National Insurance Academy, Pune