Karthigeyan S

2+ years of experience as Data Analyst in Production & Development (E2E Cycle of BI). Strong in Data warehousing concepts and Analytical skills.

• Experience on ETL (Data Extraction, Transforming and Loading) in BIDS (Business intelligence development studio) using SQL Server Integration Services (SSIS) • Expertise in writing SQL Queries using joins, Sub queries in MS SQL Server.

• Manipulating, Cleansing & Processing of data using SQL, Access and Excel.

• Expert in SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from different file formats • Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.

Monitored and Tuned MS SQL Server databases with tools like LogicMonitor and Windows Performance Monitor for optimal Performance.

• Experience in troubleshooting and resolving SQL database problems, including data integrity, blocking and deadlocking, replication and regression tests.

• Deploying SQL code in test and production environment using TeamCity.

• Generate and debug the reports in MicroStrategy data warehouse reporting tool.

• Responsible for monitoring scheduled, running, completed and failed sessions during windows production patching and maintenance using SolarWinds monitoring tools • Providing login permissions in MS SQL/Windows and also perform backup/restore operations.

• Experience in AWS(S3)

4 years as data analyst

Be electronics and communication engineering