P Jagannath

Jagannath P Senior Manager Email:-Address: AM75 Surya Apartments, 14th Main Road, Anna Nagar, Chennai, Tamil Nadu, India Phone: - Sex: Male | DOB:- | Nationality: Indian LinkedIn: www.linkedin.com/in/jagannath-panneerselvam Technical Leader for the Risk Analytics team at EY, building applications and data engineering solutions for internal audit and regulatory reporting in banking and insurance, leveraging AI for advanced risk analytics. PROFILE ❖ 12+ years of experience in app development, data engineering, AI-driven analytics, and team leadership across banking, insurance, and financial services domains. ❖ Expertise in internal audit analytics, regulatory reporting, risk assessment, and compliance solutions, with a proven track record of delivering scalable, high-impact solutions. ❖ Proficient in developing Gen AI-based apps using RAG-based LLMs (GPT and Llama3) for advanced data analysis, risk assessment, and compliance, enhancing audit effectiveness. ❖ Strong background in system architecture, software development, and deployment, with hands-on experience in designing dynamic web applications. ❖ Skilled in data visualization using Power BI and Tableau, enabling data-driven decisionmaking and actionable business insights. ❖ Extensive knowledge of ETL tools (Informatica, SSIS, NiFi, Airflow) for data extraction, transformation, integration, and pipeline automation. ❖ Hands-on experience with GCP and Azure, including cloud storage, serverless computing, virtual machines, container management, databases, identity management, CI/CD pipelines, log monitoring, and AI services. ❖ Comprehensive understanding of banking/financial operations, credit concepts, and enterprise application procurement. KEY COMPETENCIES App Development & Maintenance Internal Audit & Reg Reporting Reporting & Data Visualization Team Utilization Data Engineering & Management Advanced Analytics (GenAI, Voice) Project & Stakeholder Management Talent development TOOLS & TECHNOLOGIES Frameworks / Libraries Programming Languages Database Cloud Platforms BI Tools ETL Tools DevOps GenAI Django, Flask, AngularJs, HTML, AJAX Python, SQL, Java, C++ SQL Server, Postgres, BigQuery Google Cloud Platform (GCP), Microsoft Azure Power BI, Tableau Informatica, Apache Airflow, Apache NiFi Docker, Kubernetes, Terraform Langchain, ChromaDB, LlamaIndex, OpenAI EDUCATION Bachelor of Engineering, (Electronics and Communication), Vel Tech, Chennai, India. (Apr 2012) Jul 2008 – Apr 2012 CERTIFICATIONS Oracle SQL Certified Expert Certified Scrum Master (CSM) Microsoft Certified: Data Analyst Associate Oracle PL/SQL Developer Certified Associate PROFESSIONAL EXPERIENCE Jun 2022 – Present Senior Manager at EY, India | BFSI Domain 1) Client: HSBC, India & Hongkong (Aug 2024 – Present) Project: Regulatory Data Mart & Reporting Automation Role: Tech Lead • • • • Led a cross-functional team to build a Regulatory Data Mart (RDM) on BigQuery. Responsible for developing EY ART reporting tool (Django, Angular) and deploying it on GCP VM with Cloud SQL. Created optimized data pipelines using Airflow sensors, parallel task execution, and Cloud Run for automation. Delivered 4 of 20 planned regulatory reports, with ongoing enhancements and maintenance. 2) Client: ABSLI, India (Oct 2023 – Present) Project: Controls Monitoring Tool Enhancement & Product Review Automation Role: Tech Lead • • • • • Managed a team of Data Analysts and Application Developers to enhance and deploy a Controls Monitoring Tool (Django, Angular) on Windows on-prem VM with SQL Server. Designed project plan & implementation strategies for automating product reviews across identified products. Oversaw the development of SQL scripts for product reviews, exception identification, and their integration into the tool. Directed App Developers in implementing scheduling automation, case management, system enhancements, and Python-based ETL scripts for automated data ingestion. Collaborated with key stakeholder teams through daily/weekly cadence meetings to ensure milestone achievement and timely delivery. 3) Client: Prudential, USA (Jun 2022 – Present) Project: Internal Audit DA Support and Digicube Tool Implementation Role: Data Analytics Manager • • • • • • • Executed data analytics for multiple audits using SQL, Python, Excel VBA, Tableau, and Power BI, collaborating directly with business and Internal Audit teams. Automated audit report generation with a GenAI-based RAG pipeline, integrating key audit documents. Led a 4-member team to enhance and deploy a Controls Monitoring Tool (Django, Angular) on Azure VM with SQL Server, adding Power BI for visualization. Implemented Continuous Monitoring for a US financial insurer, integrating SQL-based risk control scenarios and automating reporting in Power BI. Developed a Voice Analytics Engine for call analysis, leveraging speech-to-text APIs, speaker diarization, and deep learning for sentiment and risk insights. Supported international audit teams (Mexico, Japan, Argentina) by translating and analyzing non-English audit data. Conducted training sessions for client DA teams on internal audit analytics and advanced Python techniques. Sep 2020 – Jun 2022 Senior Officer at TIIC, India | Finance Domain Client: Internal Role: Team Lead • • • • • • Oct 2016 – Sep 2020 Led a team of technical and functional professionals in developing a new financial product to replace the legacy Loan Management System. Developed complex SQL queries and stored procedures for generating regulatory reports and handling ad hoc enhancements such as COVID-19 interest moratorium implementation and front-end interest subsidy processing. Designed and maintained in-house web applications using Django, HTMX, and JavaScript, streamlining internal operations. Created Power BI dashboards to analyze branch performance metrics, providing data-driven insights to optimize loan scheme parameters. Managed data cleaning and enrichment for monthly CIBIL reporting, ensuring compliance and data accuracy. Oversaw project budgets and vendor payments, ensuring cost-effective solutions and timely financial management. Assistant Manager at Canara Bank, India | Banking Domain Client: Internal Role: Digital Banking Officer • • • • • • Feb 2013 – Jul 2016 Acted as a digitally enabled banker, leveraging technology platforms to enhance customer service, streamline loan sourcing, and improve operational efficiency. Appraising loan proposals by thorough scrutinizing and processing of financial statements of companies/individuals - Income Statement, Balance Sheet, Cash Flow Statement, Ratio Analysis etc. and the credit worthiness of the borrower. Collaborated with technology vendors to implement digital banking solutions aimed at improving customer engagement and internal workflows. Worked on digital campaign analytics for select bank products, providing insights that helped drive targeted marketing and conversions. Effectively managed post sanction part of loans in terms of recovery and regularisation using MIS data systems. Ensured regular audit and compliance readiness of the branch, maintaining records and processes in line with regulatory standards. Systems Engineer at TCS, India | Insurance Domain Client: United States Automobile Association, USA Project: ICD-10 Reporting Transition & Claims Transformation Role: Developer • • • • • Analyzed and implemented system changes to transition from ICD-9 to ICD-10 standards, ensuring compliance with new reporting requirements. Developed and optimized COBOL & Easytrieve programs to handle batch processing and business logic in legacy systems. Designed and implemented REST web services by coding business logic in C++, Mastercraft, and Java to replace legacy salvage and document comment components. Developed frontend pages using html, javascript, css and handled all client side validations. Collaborated with QA teams, conducting Developer-Driven Testing to ensure smooth implementation and system stability.