SINDHU SOMA

Project: Energy Consumption and Reporting System.

Client: Consolidated Edison, USA

• Architected enterprise database solutions for over 10,000 users, achieving 99.9% uptime and zero data loss incidents.
• Led optimization initiatives, enhancing query performance by 45% and reducing response time by 60%.
• Implemented Always On Availability Groups and disaster recovery protocols to ensure business continuity compliance.
• Designed SSIS ETL pipelines processing of daily energy data.
• Built automated SSRS reporting framework with role-based security, supporting over 500 regulatory reports.
• Established Git-based CI/CD pipelines, cutting deployment time by 70% and eliminating manual errors.
• Engineered high-performance PL/SQL procedures, optimizing data processing efficiency by 40%.
• Mentored over eight developers in advanced PL/SQL programming and database optimization techniques.

• Administered and optimized SQL Server databases for mission-critical energy management applications.
• Developed complex ETL workflows using SSIS, reducing energy data processing time by 35%.
• Implemented automated backup and restore procedures, achieving 99.9% database uptime for critical systems.
• Created comprehensive SSRS reports and dashboards for energy consumption analytics and regulatory reporting.
• Enhanced database functionality through sophisticated PL/SQL procedures for calculations and transformations.
• Executed database performance tuning, index optimization, and query analysis using SQL Profiler.
• Coordinated seamless database deployments across DEV, TEST, and PROD environments with zero downtime.

• Executed day-to-day database maintenance operations, including backups, monitoring, and security updates.
• Developed and maintained PL/SQL stored procedures for energy application support.
• Resolved performance issues through effective database troubleshooting in production environments.
• Optimized PL/SQL queries and supported application development teams with database design.
• Implemented security measures like roles, permissions, and encryption for data protection.
• Maintained comprehensive database documentation and facilitated change management processes.
• Participated in on-call rotation for prompt database support and incident resolution.
• Applied Agile methodologies to enhance efficiency in database development and maintenance projects.