Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

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
01.2025 - 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
11.2021 - 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
02.2024 - 02.2025

Master of Arts - Defense And Strategic Studies

University of Madras
Chennai
05.2013 - 05.2015

Bachelor of Science - Film Technology

SRM University
Chennai
05.2010 - 05.2013

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
01.2025 - Current

Snowflake - SnowPro Core certified

01-2025

Post-Graduate Certificate - Data Science & Business Analytics

University of Texas At Austin (
02.2024 - 02.2025

PLSQL/Snowflake Developer

Mphasis
11.2021 - Current

Master of Arts - Defense And Strategic Studies

University of Madras
05.2013 - 05.2015

Bachelor of Science - Film Technology

SRM University
05.2010 - 05.2013
DHIVYA PRASANTH MANOHARANSoftware Engineer