DHIVYA PRASANTH MANOHARAN
Software Engineer
Chennai
Summary
Results-driven PL/SQL Developer with a proven track record at Mphasis, specializing in stored procedures development and SQL query optimization. Enhanced application performance through strategic tuning and collaboration with cross-functional teams. Committed to continuous learning and delivering high-quality solutions that drive productivity and meet user needs.
Overview
4
4
years of professional experience
6
6
years of post-secondary education
1
1
Certification
Work History
Power BI Developer
Mphasis
2025.01 - Current
- Used Power Query and DAX efficiently to transform, model, and aggregate data from varied sources with emphasis on performance and accuracy.
- Integrated Power BI with Oracle and Snowflake databases to provide end-to-end, holistic visualizations across enterprise systems.
PLSQL/Snowflake Developer
Mphasis
2021.11 - Current
- Strong background in writing and optimizing advanced Oracle PL/SQL procedures, functions, packages, and views to meet business application and reporting requirements.
- Proficient with optimizing SQL and PL/SQL performance using execution plan analysis, join optimization, query rewrites, and indexing methodologies.
- Developed user-oriented report solutions based on advanced Oracle SQL and Snowflake SQL for scheduled and ad-hoc report generation.
- Proficient in Snowflake SQL development to create databases, schemas, views, and warehouses tailored for analytics with high-performance.
- Prevented data loss and integrity after batch operations by establishing validation scripts and monitoring data quality across modules.
- Facilitated deployment activities across Oracle and Snowflake environments.
- Collaborated with business users to understand reporting requirements and provided on-time, accurate, and actionable data insights.
- Maintained detailed logs for SQL scripts, procedures, change management, and troubleshooting to facilitate future support and onboarding.
- Prioritized the delivery of high-quality, maintainable solutions to align with business goals and compliance requirements.
Education
Post-Graduate Certificate - Data Science & Business Analytics
University of Texas At Austin (
Online 2024.02 - 2025.02
Master of Arts - Defense And Strategic Studies
University of Madras
Chennai 2013.05 - 2015.05
Bachelor of Science - Film Technology
SRM University
Chennai 2010.05 - 2013.05
Skills
Database & ETL: Oracle SQL, Snowflake, Talend (custom ETL framework)
Analytics & Reporting: Power BI
Performance Tuning: Query optimization, data validation, job efficiency improvements
Support & Maintenance: Batch job monitoring, issue resolution, script enhancements
Support & Maintenance: Batch job monitoring, issue resolution, script enhancementsTools & Methodologies: Github, Toad, Datastage
Tools & Methodologies: Agile, Shell Scripting, Git, Documentation
Certification
Snowflake - SnowPro Core certified
Timeline
Power BI Developer
Mphasis
2025.01 - Current
Snowflake - SnowPro Core certified
2025-01
Post-Graduate Certificate - Data Science & Business Analytics
University of Texas At Austin (
2024.02 - 2025.02
PLSQL/Snowflake Developer
Mphasis
2021.11 - Current
Master of Arts - Defense And Strategic Studies
University of Madras
2013.05 - 2015.05
Bachelor of Science - Film Technology
SRM University
2010.05 - 2013.05