
Santanu Bagani
Intern

Connect with Santanu Bagani to Send Message
Connect
Connect with Santanu Bagani to Send Message
ConnectTimeline
Skills
AnalyticsBusiness AnalyticsCC++Chatbot DevelopmentCross-functional Team LeadershipCrystal ReportsCustomer AnalyticsDashboardsData AnalysisData ManagementData Warehouse ArchitectureData WarehousingDeep LearningDescriptive AnalysisDigital TransformationETL ToolsFinancial AnalysisHTMLInterpersonal CommunicationIT Enabled Business TransformationJavaJavaScriptMarketing AnalyticsMicrosoft Power BIMicrosoft SQL ServerMISMobile Application DevelopmentMySQLNatural Language Processing (NLP)OracleOracle SQL DeveloperPatch ManagementPL/SQLPredictive AnalyticsPrescriptive AnalyticsPresentation SkillsProcurementPurchase OrdersQuality AssuranceRegulatory ComplianceSQLStatistical InferenceTableauTeam LeadershipTender ManagementTime ManagementTrend ForecastingVendor ManagementWeb DevelopmentAlgorithmsLinuxASP.NETNETPythonDjangoVisual BasicOracle PL/SQL DevelopmentJSPWeb ApplicationsJava Enterprise EditionJ2EE Application DevelopmentCSSBusiness Continuity PlanningStrutsPR/Publicity through ITPhpOracle PL/SQLJ2EE ApplicationBusiness ContinuityAbout 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 - 2005Higher Secondary Science (Computers)
Mumbai Educational Trust, MET League of Colleges
2009 - 2012Master of Computer Applications - MCA Computer ApplicationActivities 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 - 2008Bachelor of Science - BS Computer Science (Honours)Activities and Societies: Participated in Singing Competitions.
Experience
%2C%20TIFR.webp)
Homi Bhabha Centre for Science Education (HBCSE), TIFR
Jan 2012 - Jun 2012InternDeveloped 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 - nowManager (IT)
May 2022 - Feb 2023Deputy Manager (IT)
May 2017 - May 2022Assistant Manager (IT)
Jun 2012 - May 2017
Licenses & Certifications
- View certificate

Professional Scrum Master I
Scrum.orgJul 2023 - View certificate

Executive Programme in Business Analytics
SPJIMR - Executive EducationJun 2024 
Managerial Effectiveness Program
National Insurance Academy, Pune
Languages
- enEnglish
- hiHindi
- beBengali
Recommendations

Ady toumah, cams
Customer Service Officer @ Housing Bank for Trade and Finance | Very good (82.14) in BankingIrbid, Jordan
Ariany daniela chollett l.
Engagement Concierge at Pwc Acceleration CentersArgentina
Gee vochten
coaching, training, selectie VZW WEBWestmalle, Flemish Region, Belgium
Adam mason
Founder / Investor / Problem SolverLondon, England, United Kingdom
Cid lopes matos
Atendimento ao cliente na SABOROSOAvelar, Rio de Janeiro, Brasil
Aditi krishna
ChefChennai, Tamil Nadu, India
Eniola k.
Assistant Director @ Federal CARES Support Unit | Nonprofit, Fundraising, Social ProtectionAbuja, Federal Capital Territory, Nigeria
Miguel estrada
Customer Success Manager at TEKsystems, Team Leader, Data Nerd.Charlotte, North Carolina, United States
Linus fischer
Porsche Operations Intern | Recovery Engineer @ UCI Rocket Project | Nanotech ResearcherPorsche Consulting
Byron escobar
Gerente de Operaciones Postventa en Grupo Cofiño StahlGuatemala
Sherrie bedford
CEO & Founder of Striving For Excellence LLCFlorence, Arizona, United States
Mario ibacache estay
Innovación, Pro.Play, Gestión de Procesos, Gestión de Cambio, Gestión ISO, Entrenamiento.Chile
Ruth reynolds
Technology Director at Havas Media GroupUnited Kingdom
Tara kamal ahmadi
Transportation Analyst Planner at MBTAGreater Boston
Brian barr
Member Representative II (Insurance Agent)Madison, Wisconsin, United States
Paulina godziszewska
PROCESS EXCELLENCE / LEAN / COACHING & MENTORING / CHANGE MANAGEMENTIzabelin, Mazowieckie, Poland
Jaibhan singh gaur
Full Stack Developer @ Jio | Python Developer | FreelancerMadhya Pradesh, India
Harsh trivedi
Logistics Analyst/Planner at Stabilis SolutionsGreater Houston
Sheryl b. simangan, cpa
Accounting ManagerTuguegarao, Dolina Cagayan, Filipiny
Curtis brown
Associate Director / Professionals Division / Professionals Contract Specialist日本 東京都
...