Prabhahar N

As a Software Engineer, I bring a calm and meticulous diligence to every project, patiently crafting high-quality solutions. I thrive in collaborative settings, leveraging empathetic communication to build robust systems that align with ideal outcomes and foster collective success.

Experience

Software Engineer

Inspirisys Solutions Limited (a CAC Holdings Group Company) · Mar 2026 – Present

Not yet confirmed

• • Developed and optimized complex SQL queries, PL/SQL procedures, functions, packages, and triggers, improving query performance by 30% and supporting business reporting and data processing.
• • Analyzed, cleansed, validated, and reconciled large datasets using Oracle SQL, improving data accuracy by 25% and reducing manual validation effort.
• • Generated SQL based and ad hoc reports by extracting and analyzing transaction data, reducing report generation time by 35% and enabling faster business decision-making.
• • Collaborated with business stakeholders and cross-functional teams to gather reporting requirements and deliver data driven solutions, achieving 95% on-time delivery while maintaining high data quality.

A

Software Engineer

Aroha Technologies · Feb 2024 – Feb 2026

Not yet confirmed

• Designed and implemented ETL pipelines using Oracle SQL, PL/SQL, Python, ODI, and Talend to integrate data from multiple sources into a centralized data warehouse.
• Developed and optimized complex SQL queries, stored procedures, functions, packages, and triggers, improving query performance by 30% and supporting efficient data processing.
• Processed and transformed large datasets using Python (Pandas, PySpark), performing data cleansing, validation, and preparation for analytics.
• Applied data warehousing concepts, including fact/dimension modeling and SCD implementation, to support scalable reporting and analytical systems.
• Built interactive Power BI dashboards using DAX, filters, and slicers, reducing report preparation time by 35% and enabling data driven decision making.
• Supported cloud based data workflows on AWS, integrating data from CSV, Excel, and relational databases, reducing data integration time by 25%.