Summary
Work History
Education
Skills
Generic

SURESH R

DWH Engineer

Summary

Technical Analyst with 9+ years of experience specializing in Application Support and Data Warehousing. Proficient in ETL processing and monitoring SQL & server performance, utilizing tools like MS SQL, SolarWinds, SQL Sentry, and MS Office. Skilled in Cube technology for data modeling and analysis, with a strong understanding of data warehousing concepts and methodologies. Experienced in production support, troubleshooting technical issues, and documenting workflows and procedures. A collaborative team player with excellent analytical, communication, and interpersonal skills.

Work History

Technical Analyst

Computacenter India Pvt Ltd.
5 2022 - Current
  • Utilized SQL Server Analysis Services (SSAS) for multidimensional data analysis and worked with Cube technology (tabular models, dimensions) to monitor ETL processes from data extraction to cube availability, ensuring smooth data flow and identifying process bottlenecks.
  • Analyzed delays in the ETL workflow, providing insights and recommendations that enhanced process efficiency and improved forecasting capabilities.
  • Developed and maintained comprehensive ETL documentation, including workflows, procedures, and performance metrics, ensuring consistent knowledge transfer and optimized process execution.
  • Used MS SQL for querying and analyzing SLA availability and runtime increase to support critical decision-making.
  • Managed failover clusters, handling active nodes and performing failovers to ensure high availability and minimize downtime.
  • Monitored system performance and SQL performance using SolarWinds SQL Sentry, proactively identifying performance issues and optimizing the ETL process and overall system efficiency.
  • Provided production support by troubleshooting and resolving technical issues, significantly reducing system downtime and improving user experience.
  • Involved in OS and SQL patching activities on all Data Warehouse (DWH) servers, ensuring system stability and security

Senior Support Engineer

Prizma Technologies India Pvt Ltd.
08.2015 - 05.2022
  • Installed and configured MS SQL Server (versions 2005, 2008, 2012, and 2014) to meet organizational database requirements.
  • Created databases and managed user permissions to ensure secure access and data integrity.
  • Installed Prism software and facilitated the setup process, ensuring all modules were operational.
  • Conducted training sessions for users on all software modules, enhancing user proficiency and satisfaction.
  • Managed integration with Swiggy and Zomato through UrbanPiper to streamline food delivery operations.
  • Provided technical support for current and previous software releases, addressing issues and improving system functionality.
  • Responded to support tickets promptly, ensuring timely resolution of user issues.
  • Wrote SQL queries for updating, modifying, and deleting data, ensuring database accuracy and integrity.
  • Performed software updates to the latest versions, maintaining system security and performance.
  • Conducted backup and restoration of databases to ensure data protection and recovery.
  • Connected client stores to the centralized Head Office database using linked servers to manage data and generate reports from a single location.
  • Managed multiple stores from the Head Office, ensuring consistent operations and data accuracy across locations.

Education

B.E - Computer Science

Vel Tech Hightech Dr.rangarajan Dr.sakunthala Engineering Colleg
Chennai
08.2011 - 05.2015

Skills

ETL Process Monitoring & Optimization

SURESH RDWH Engineer