Tejashri Jay Kowly
Mumbai
Summary
Insightful Senior Data Engineer known for high productivity and efficiency in task completion. Possess specialized skills in data modeling, ETL development, and cloud computing solutions. Excel in problem-solving, teamwork, and communication, ensuring successful project outcomes and effective collaboration with cross-functional teams.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Senior Data Engineer | Senior Data Analyst
ICICI Lombard General Insurance
Mumbai
09.2022 - Current
- Lead enterprise data integration and reporting initiatives across policy, claims, and finance domains.
- Designed and optimized complex Oracle SQL/PLSQL queries for large-volume insurance data.
- Managed month-end P&L closure for Policy Mart, RI Mart, and Finance datasets.
- Implemented data quality checks and reconciliation frameworks between core systems (BaNCS/Abacus) and EDW.
- Automated IRDAI regulatory and audit reports, reducing manual effort and turnaround time.
- Supported data migration audits ensuring completeness, accuracy, and traceability.
- Collaborated with actuarial, finance, and IT teams for requirement mapping and issue resolution.
- Mentored junior analysts and led delivery for critical regulatory timelines.
- Developed insurance analytics reports covering premium, claims, commission, and reserves.
- Performed system-to-system reconciliation for policy and claims data.
- Built PL/SQL procedures, functions, and packages for reporting automation.
- Conducted ETL validation and root cause analysis for data mismatches.
- Delivered ad-hoc MIS, audit, and compliance reports for business stakeholders.
Data Management & Integration Lead / IT Analyst
Tata Consultancy Services
10.2015 - 09.2022
- Led enterprise data management and integration initiatives across core insurance systems and EDW.
- Designed and implemented complex Oracle SQL & PL/SQL solutions for policy, claims, underwriting, and finance data.
- Owned month-end and PnL closure reporting for multiple data marts, ensuring accuracy and audit compliance.
- Developed data reconciliation frameworks to validate policy, premium, claims, and accounting data between core systems and EDW.
- Delivered IRDAI regulatory and audit reports, ensuring compliance with statutory requirements.
- Performed data migration audits, identifying mismatches, root causes, and corrective actions.
- Led performance tuning initiatives, optimizing complex SQL queries and improving report execution times.
- Worked extensively on system integration mapping between TCS BaNCS, Abacus, and EDW for new and existing products.
- Implemented data quality checks and exception dashboards to proactively detect data issues.
- Supported production issues, RCA, and data corrections with controlled patch deployments.
- Collaborated with Business Analysts, Finance, Actuarial, and IT teams to translate business rules into data logic.
- Led and mentored a team of 6+ members, providing technical guidance and delivery ownership.
System Engineer
CMC Ltd.
- Involved in requirement analysis, impact assessment, development, and deployment.
- Developed Oracle PL/SQL and VB.NET components supporting insurance operations.
- Performed unit testing, bug fixing, and production deployments.
- Supported policy and claims-related data fixes and enhancements.
- Merged with TCS
Education
Bachelor of Computer Applications -
SNDT University
Mumbai01.2013
Skills
CORE COMPETENCIES
Data & Analytics
- Data Engineering
- Data Analytics & Business Analysis
- Data Modeling
- Enterprise Reporting
- Ad-hoc & Management Reporting
- Data Validation
- Data Reconciliation
- Data Quality Checks
- Control Frameworks
- Exception Handling
- Month-end Reporting
- P&L Reporting
- Finance Reconciliation
- Audit Reporting
- Regulatory & Compliance Reporting
- Data Migration Strategy & Validation
- ETL Validation
- Source-to-Target Mapping
- DWH & Enterprise Integration
- Policy Lifecycle Management
- Policy Administration & Underwriting
- Claims Processing & Analytics
- Accounting & Finance
- Reinsurance
- IRDAI Regulatory Reporting
- Databricks
- Oracle
- MySQL
- SQL
- PL/SQL
- VBNET
- ETL Processes
- System-to-System Integration
- Data Warehouse (DWH) Integration
- Ad-hoc Reports
- Audit Reports
- Compliance Reports
- Finance & Regulatory Reports
- TFS
- Git
- TCS BaNCS
- Genisys Configurator
Key Project Highlights
- Policy & Claims Reconciliation Framework: Automated reconciliation between core insurance systems and EDW, reducing manual effort and audit issues.
- PnL & Finance Reporting: Delivered accurate month-end closure reports across policy and RI marts.
- Data Migration Audit: Validated large-scale migration data and produced audit-ready reports for compliance.
- Performance Optimization: Reduced report runtimes significantly through SQL tuning and indexing strategies.
Technology Stack
Oracle 9i, Oracle 10g, Oracle 11g, Oracle 12c, MySQL, SQL, PL/SQL, VB.NET, DWH Integration, Source-to-Target Mapping, Ad-hoc, Audit, Compliance, Finance Reports, TFS, Git, TCS BaNCS, Genisys Configurator
Accomplishments
Foundation Star in February 2024.
Highflier in June 2024.
Highflier in June 2025.
Highflier in June 2024.
Highflier in June 2025.
Certification
Scrum Master Certification.
Timeline
Senior Data Engineer | Senior Data Analyst
ICICI Lombard General Insurance
09.2022 - Current
Data Management & Integration Lead / IT Analyst
Tata Consultancy Services
10.2015 - 09.2022
System Engineer
CMC Ltd.
Bachelor of Computer Applications -
SNDT University