Ramachandran Sandhappan
Lead Data Engineer
Manaparai
Summary
Over 18 years experience in IT Industry. Lead Data Engineer with extensive experience designing and delivering enterprise-scale data platforms for Risk Management and Insurance systems. Expert in building high-performance ETL pipelines using PySpark, optimizing SQL/PLSQL workloads, and executing large-scale database migrations to AWS cloud-native architectures. Strong background in Oracle, PostgreSQL, SQL Server, MySQL, and NoSQL systems, with deep hands-on exposure to AWS services and legacy modernization.
- End-to-End Data Leadership: Proven ability to design, build, and lead enterprise-scale ETL and data engineering platforms from legacy on-prem systems to modern cloud-native architectures.
- Deep ETL & Big Data Expertise: Strong hands-on experience in PySpark-based ETL pipelines, handling high-volume, high-velocity insurance data with a focus on performance, scalability, and reliability.
- Database & Performance Specialist: Expert in Oracle SQL and PL/SQL performance tuning, with strong cross-platform skills in Aurora PostgreSQL, SQL Server, MySQL, and MariaDB.
- Cloud Migration Authority: Led multiple database and data platform migrations using AWS SCT, DMS, Glue, S3, RDS, and Aurora PostgreSQL, ensuring minimal downtime and full data reconciliation.
- Legacy Modernization Strength: Successfully modernized Pro*C and batch-driven systems into Python and Spark-based solutions, reducing operational risk and improving maintainability.
- Insurance Domain Expertise: Deep understanding of Risk Management Systems, including policy, claims, exposure, reinsurance, actuarial, and regulatory reporting workflows.
- Multi-Database & NoSQL Proficiency: Strong data modeling and integration experience across RDBMS and NoSQL platforms such as DynamoDB, MongoDB, and Cosmos DB.
- Quality, Governance & Compliance Focus: Strong emphasis on data quality, auditability, reconciliation, and security, aligned with insurance and regulatory standards.
- Technical Leadership & Mentoring: Effective team leader with experience mentoring data engineers, setting coding standards, and driving best practices across delivery teams.
- Problem-Solving Mindset: Known for resolving complex data performance and migration challenges through analytical thinking, optimization, and automation.
Overview
18
18
years of professional experience
1
1
Certification
1
1
Language
Work History
Lead Data Engineer
Riskonnect Services Private Ltd
05.2024 - Current
- Designed and implemented end-to-end ETL pipelines using PySpark for TB-scale insurance risk data processing.
- Optimized indexes and execution plans, reducing batch runtimes from hours to minutes.
- Built incremental CDC-based ingestion pipelines from Oracle, SQL Server, MySQL, and MariaDB to AWS S3 data lake.
- Developed fault-tolerant Spark jobs with partitioning and caching, enhancing performance by 40–60%.
- Implemented data quality checks and audit controls vital for regulatory insurance reporting.
- Tuned complex Oracle SQL and PL/SQL procedures used in actuarial calculations for efficiency.
- Architected cloud-native data solutions utilizing AWS services like RDS and Glue for ETL processes.
- Migrated on-prem Oracle workloads to Aurora PostgreSQL with minimal downtime, ensuring data integrity.
Lead Software Developer
EXTENDED VENTIV RISK SERVICES PRIVATE LIMITED
08.2022 - 05.2024
- Analyzing scope of Jira ticket as Development or Bug fixing or Enhancement.
- Fixing the bug using IntelliJ IDEA or SQL developer and create the story to resolve the issue.
- Trained the team for IRM database using Logical Data model.
- Trained the team for 'How to use SQL developer efficiently for all criteria like Debugging and Short cut Keys.'
- Working with team member to analyze or communicate with onshore team to resolve/clarify the scope of work.
- Resolved severity S1 issues with proper debugging and Analyzed the Impact analysis before providing solution.
- Identified bottle neck of slowness causing issue in Application due to SQL query/Configuration.
- creating ETL Pipeline using in built in data processing ETL Tool.
- Resolving performance issue for ETL Job Taking much time.
- Involved Data Migration from SQL Server to Oracle using ETL tool.
- Production support given for multiple clients facing issue while executing ETL pipeline through JIRA.
Sr. Lead Product Development
Sunbrilo Technologies Pvt Ltd
02.2022 - 07.2022
- Analyzing scope of Jira ticket as Development or Bug fixing or Enhancement.
- Fixing the bug using IntelliJ IDEA or SQL developer and create the story to resolve the issue.
- Trained the team for IRM database using Logical Data model.
- Trained the team for “How to use SQL developer efficiently for all criteria like Debugging and Short cut Keys.
- Working with team member to analyze or communicate with onshore team to resolve/clarify the scope of work.
- Resolved severity S1 issues with proper debugging and Analyzed the Impact analysis before providing solution.
- Identified bottle neck of slowness causing issue in Application due to SQL query/Configuration.
- Environment: Oracle 12c, PLSQL, SQL, IntelliJ IDEA, Java, JavaScript (Angular JS), HTML, SQL Developer –Risk Management Information System(Insurance Domain)
- Clients: Ventiv Technology(USA, Europe)
IT Engineer
AL JURF Development Projects LLC
02.2014 - 01.2022
- Developing ERP product by using Oracle Forms and Reports.
- Involved in developing portal approval system using JSF, Java and Hibernate.
- Expert in tuning the complex queries to reduce the cost of the query, using optimizer Hints, explain plan, trace file and TK prof & Oracle Enterprise Manager.
- Expert in writing complex SQL queries for reports.
- Experienced in Unix Shell Scripting.
- Handling code review part for all procedures/packages/functions and SQL queries.
- Involved in performance fine-tuning of the Queries/ Procedures/ packages/ functions.
- Developed PLSQL procedure/Packages using Java code to resolve complex software functionalities like PDF merging, uploading pdf files and Java mail sending.
- Migrated data from Excel file to Oracle database and Complex SQL query data to excel file.
- Developed MIS reports by using integrated data and Source data.
- Developed ERP product (Finance Module, HR-PAYROLL module, Procurement, Logistics module, Estimation Module, Engineering Module, PMV Module, Workshop Module and Fixed Asset Module) using forms and reports and Java.
- Migrated Oracle forms 6i to Oracle forms 11g/12c.
- Migrated oracle 10g database to oracle 12c database and verified all invalid objects and moved to production.
- Developed ASP.net application (Humming bird & Bizflow) to Construction business needs.
- Gathering New requirements with projects manager and Implemented within time line Using Oracle forms and reports.
- Environment: Oracle 11g, PLSQL, SQL, Developer 2000, Java, JSF, ASP.Net, NetBeans, MS Visual studio and Toad –ERP Product
- Clients: AL JURF Development Projects LLC
Associate
Excelacom Technologies Pvt Ltd
08.2011 - 02.2014
- Involved in Data Model creation for logical, Physical and process model and reverse Engineering.
- Expert in tuning the complex queries to reduce the cost of the query, using optimizer Hints, explain plan, trace file and TK prof.
- Normalization of existing database up to 3rd level.
- Expert in writing complex SQL queries for reports.
- Handling code review part for all procedures/packages/functions and SQL queries.
- Involved in performance fine-tuning of the Queries/ Procedures/ packages/ functions.
- Involved in development of DB using Oracle SQL/PLSQL for telecoms product.
- Migrated data from Excel file to Oracle database.
- Migrated data from one database to another database using packages and procedure.
- Environment: Oracle 11g, PLSQL, SQL, Developer 2000 and Toad –Telecoms Product
- Clients: COM Cost, Reston, USA
Analyst Programmer
ETA InfoTech
07.2007 - 04.2011
- Responsible for Development and Implement in HR Payroll System, Inventory, Account Receivables, Account Payables and General Ledger, Purchase Order, Costing, Fleet Management, Workshop System, Fixed Asset Logistics Management System and Port Management System.
- Responsible for implementation in Interface Program, Error list Generation for SAP.
- Understanding the customer requirements, analysis, design, development and implementation into the system.
- Creating Database, schema, table space, Indexes, Users, user rights, triggers and procedures as per requirement.
- Developing functional flow for ERP, Logistics Management, Port Management, Fleet Management, Workshop
- Developing Screen shots, SRS (system requirement study) for a specific module.
- Developing all screens and reports for related module with team members.
- Get user signoff from every user for every completed bugs.
- Developed Oracle applications using Developer 2000 tool set.
- Responsible for design and development of Interface Programs.
- Designed and developed PL/SQL functions/stored procedures /cursors/ packages/triggers
- Involved in performance fine-tuning of the queries/report using PL/SQL, Toad and SQL Plus
- Involved in writing complex queries to generate reports as per client request as a part of production support.
- Extensively used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL
- Designed and developed GUI front-end using Oracle Forms for user interaction with the database.
- Designed and developed various reports using Oracle Reports.
- Primary tasks accomplished using Designer 9i include: Modeling the business requirements, Diagrammatic representation of business processes, Define and represent entities, functions and flows between the entities, using the transformers to generate initial designs.
- Migrated data from Excel file to Oracle database.
- Extensive knowledge in analyzing business process and identifying opportunities for improvement.
- Environment: Oracle 10g, PLSQL, Developer 2000 and Toad –ERP, Logistics domain, AP, AR, FA, GL, Inventory, Purchasing and Workshop
- Clients: Wafa Logistics L.L.C, Al Nakhla Crusher L.L.C, Gulf Star Minerals and Aggregates, Raknor Private Limited, SAQR Port Authority Ras Al Khaimah and Al Jurf Development Projects Abu Dhabi
Senior Software Engineer
Cherry Tec Software Solution Pvt Ltd
05.2006 - 06.2007
- Understanding the customer requirements, analysis, design, development and implementation into the system.
- Responsible for implementation in HR Payroll System, Inventory, Account Receivables, Account Payables, General Ledger, Asset Module and TDS module.
- Creating Database, schema, table space, Indexes, Users, user rights, triggers and Procedures as per requirements.
- Forms and Reports Developed for MAX, Fincube and AIMS System.MAX is a HR and Payroll system to calculate Employees Monthly payroll and maintain personal information about Employees. Fincube is the Finance system to maintain AP, AR and GL.AIMS is a Inventory System to maintain the information of Purchase, GRN, Receipts, Stocks, Ware Houses and stock issues.
- PRT file created from forms to print cheques, Pay slips, and Bank statements using text IO Packages.
- Migrated Data from Excel file and FoxPro DAT file to Oracle Database.
- Allocating specified module to team members with time frame.
- Working with deadline environment for completing module up to Invoicing.
- Interact with user for new requirements and complete that specified task within time frame.
- Provide solutions based on business requirements.
- Creating Inline view to combine all related tables to generate MIS reports.
- Creating constraints and indexes for all important tables to maintain relationship between tables.
- Performed Defining Users and their Personal Profile Options, Defining Value Sets and Values.
- Responsible for documenting and executing Business scenario, which are being executed after the implementation of Use Cases.
- Perform data conversion and provide data validation support during data conversion.
- Support team members and help to troubleshoot application issues and develop creative solutions to support business needs.
- Involved in developing and adhering to project standards to ensure the delivery of quality deliverables.
- Developed appropriate systems and user documentation to support deployment of applications.
- Environment: Oracle 9i, PLSQL, Developer 2000 and Toad –MAX (HR and Payroll), Fincube (AP, AR, FA, GL), AIMS (Alshaya Inventory Management System)
- Clients: SPIC Limited, Alshaya Co L.L.C. Kuwait
Education
Bachelor of Engineering - Computer Science
Bharathidasan University
IndiaSkills
ETL Pipeline using PYSpark
Certification
Oracle Certified Associate (OCA).
Personal Information
- Passport Number: U 2982239
- Father's Name: M.Sandhappan
- Date of Birth: 30th May 1977
- Marital Status: Married
- ID Type: Passport
- ID Number: U 2982239
Timeline
Lead Data Engineer
Riskonnect Services Private Ltd
05.2024 - Current
Lead Software Developer
EXTENDED VENTIV RISK SERVICES PRIVATE LIMITED
08.2022 - 05.2024
Sr. Lead Product Development
Sunbrilo Technologies Pvt Ltd
02.2022 - 07.2022
IT Engineer
AL JURF Development Projects LLC
02.2014 - 01.2022
Associate
Excelacom Technologies Pvt Ltd
08.2011 - 02.2014
Analyst Programmer
ETA InfoTech
07.2007 - 04.2011
Senior Software Engineer
Cherry Tec Software Solution Pvt Ltd
05.2006 - 06.2007
Bachelor of Engineering - Computer Science
Bharathidasan University