Ramakrishna KNV

Software Engineer

Capgemini

11.2022 - Current

Implemented database migrations from SQL Server 2012 to SQL Server 2019 and SQL 2022, resulting in improved performance and scalability.
Upgraded Oracle databases from version 2012 to 19c, enabling optimized queries and improved data management.
Enhanced database architecture to streamline data retrieval, reducing query latency and improving reporting efficiency.
Ensured high data integrity by validating consistency and accuracy across distributed database environments.
Collaborated with cross-functional teams to optimize stored procedures, indexes, and query performance.
Designed and maintained robust ETL pipelines to automate data extraction, transformation, and loading processes, reducing manual effort by 40%.
Integrated database pathways with reporting servers, significantly enhancing report generation speed and data availability.
Refactored Azure DevOps pipelines to improve CI/CD workflows, achieving a 30% reduction in deployment time.
Monitored and debugged ETL workflows, ensuring consistent data ingestion and transformation accuracy.
Upgraded SSRS Report Server (2012 → 2019), improving real-time reporting accuracy and visualization.
Configured and optimized real-time dashboards, ensuring accurate reporting based on time, date, and location.
Established data connections between Itron Enterprise Edition (IEE), Meter Data Management (MDM), and Open Way Collection Engine, enhancing data flow and accessibility.
Developed scalable analytics models to derive actionable insights from Smart Grid metering data.
Transformed raw datasets into analytical reports using advanced SQL queries and aggregations, enhancing business intelligence capabilities.
Documented ETL frameworks and data workflows, facilitating smooth handovers and efficient issue resolution.
Performed full-spectrum data validation and integration testing to ensure 100% stability and compliance of deployed systems.
Diagnosed and resolved data inconsistencies, system bugs, and latency issues, improving end-user satisfaction and system reliability.
Maintained regular one-on-one interactions with clients to gather requirements, provide progress updates, and deliver technical walkthroughs, reinforcing trust and transparency.
Delivered detailed status reports and proactive communication to stakeholders, facilitating timely resolution of issues and alignment with business goals.