Dhanalakshmi Sugumaran
Tustin,USA
Summary
Experienced Database Developer with 9+ years of experience in database development, application integration, and performance optimization. Have knowledge of development, .NET/C# integration, and ETL processes, with a proven ability to design, optimize, and maintain scalable database solutions. Adept at collaborating with application teams, troubleshooting complex production issues, and ensuring database security and compliance.
Overview
19
19
years of professional experience
Work History
Senior Consultant
Kasadara InfoTech Solutions
08.2025 - Current
- Designed and developed scalable RESTful APIs using .NET / ASP.NET Core to support real-time management of distributed energy resources.
- Implemented business logic and workflows for device onboarding, approval processing, and capability validation.
- Integrated APIs with PostgreSQL databases using Entity Framework Core, optimizing queries for performance and reliability.
- Developed and consumed Kafka-based event streams, enabling asynchronous, event-driven processing of device telemetry and system events.
- Implemented secure API access with proper validation, error handling, and tenant isolation.
- Built batch and asynchronous processing mechanisms to handle high-throughput device data.
- Added structured logging and monitoring to improve observability and troubleshooting in production environments.
- Wrote unit tests to ensure API correctness, stability, and backward compatibility.
- Collaborated with cross-functional teams (DevOps, QA, Product) to deliver production-ready microservices.
- Supported CI/CD deployments, bug fixes, and ongoing maintenance of backend services.
- Itron provides hardware and software solutions to utilities and cities to improve energy, water and city services
- API Developer | .NET Backend Engineer
- Project: LV DERMS (Low Voltage Distributed Energy Resource Management System)
Developer
Cognizant Technology Solutions
04.2015 - 09.2016
- Designed and developed a web-based financial application to automate discount accrual and data management.
- Optimized SQL stored procedures and queries for high-volume CRUD operations and financial reporting.
- Built Power BI dashboards to analyze discounts, trends, and project performance metrics.
- Integrated Tableau and Snowflake to enable advanced analytics and enterprise reporting.
- Collaborated with business stakeholders to translate financial requirements into technical solutions.
- Discount Accrual System
- Key Achievement: Streamlined discount management processes, enabling faster and more accurate decision-making.
Developer
Cognizant Technology Solutions
01.2013 - 03.2014
- Developed a timesheet tracking application with SQL-based reporting and validation.
- Automated batch jobs and database-driven reminders to ensure timely timesheet submissions.
- Integrated leave management functionality, maintaining data consistency across systems.
- Improved reporting accuracy to support payroll and resource management teams.
- Timesheet Tracker
- Key Achievement: Reduced administrative overhead and simplified payroll processing.
Project Team Lead
Cognizant Technology Solutions
01.2010 - 12.2012
- Designed relational database schemas to support large-scale financial automation.
- Implemented complex ETL workflows using SSIS for capital and payment data processing.
- Developed and optimized SQL stored procedures for financial calculations and validations.
- Used ADO.NET for efficient data access and system integration.
- Led technical design discussions and mentored junior developers.
- Capital Automation System
- Key Achievement: Automated monthly payment calculations with high accuracy and reliability.
Project Associate
Cognizant Technology Solutions
01.2008 - 12.2009
- Developed SQL stored procedures, views, and SSIS packages for automated payment data processing.
- Built SSRS reports for month-end payment reconciliation, tracking, and invoicing.
- Ensured data accuracy and completeness across financial reporting systems.
- Supported production deployments and issue resolution.
- Payment Mapping Automation
- Key Achievement: Improved accuracy and efficiency of payment processing and reporting.
Programmer Analyst
Cognizant Technology Solutions
01.2007 - 12.2007
- Developed a revenue forecasting system using optimized SQL queries and reporting logic.
- Created ad-hoc financial reports to support budgeting and strategic planning.
- Partnered with finance teams to validate forecasting models and assumptions.
- Revenue Forecasting System
- Key Achievement: Enabled accurate 12-month revenue forecasting for finance teams.
Education
Bachelor of Engineering - Computer Science and Engineering
Skills
- SQL Server Architecture & Database Design
- MS SQL: Procedures, Functions, Triggers, Packages
- Query Optimization & Performance Tuning
- Indexing Strategies & Execution Plan Analysis
- ETL Development (SSIS)
- Reporting (SSRS, Power BI, Microsoft Fabric)
- NET / C# Database Integration (ADONET)
- API & Middleware Integration
Timeline
Senior Consultant
Kasadara InfoTech Solutions
08.2025 - Current
Developer
Cognizant Technology Solutions
04.2015 - 09.2016
Developer
Cognizant Technology Solutions
01.2013 - 03.2014
Project Team Lead
Cognizant Technology Solutions
01.2010 - 12.2012
Project Associate
Cognizant Technology Solutions
01.2008 - 12.2009
Programmer Analyst
Cognizant Technology Solutions
01.2007 - 12.2007
Bachelor of Engineering - Computer Science and Engineering
Key Responsibilities & Expertise
- Database Development
- Designed, developed, and maintained MS SQL procedures, functions, triggers, and packages to support business-critical applications.
- Created and optimized complex SQL queries for application functionality, reporting, and analytics.
- Application Integration
- Collaborated closely with .NET/C# application teams to integrate SQL databases with enterprise applications.
- Developed and supported middleware components and APIs to enable seamless data exchange between systems.
- Performance Tuning
- Conducted query optimization, execution plan analysis, and indexing strategies to improve performance.
- Implemented database health checks, monitoring, and proactive performance tuning best practices.
- Maintenance & Support
- Performed database upgrades, patching, and migration activities across environments.
- Troubleshot and resolved complex production database issues, ensuring high availability and data integrity.
- Security & Compliance
- Ensured compliance with database security standards.
- Implemented role-based access controls, permissions, and data protection best practices.
- Documentation
- Maintained detailed technical documentation for database architecture, processes, and operational procedures.