SQL
Vinoth Kumar
L2 Support Engineeer
Chennai
Summary
To Secure a challenging position in a reputable organization in which take large volumes of complex data, extract data and help solve problems related for production support and have opportunity to fully utilize my skills while making contribution to the success of company.
Overview
3
3
years of professional experience
3
3
Certifications
3
3
Languages
Work History
L2 Support Engineer
Health EC India Private Limited
02.2023 - Current
- Highly proficient in operating MS SQL Server suite of products such as SSMS and SSIS.
- Loading various types of data files into databases using SSIS packages. Comparing and validating the loaded data with the input file and system to determine if the data is distributed correctly. Analyzing issues using SQL commands if data is not moved properly.
- Working on SSIS packages to Extract, Transform, and Load (ETL) data into multiple databases from various data sources such as flat files, Excel, CSV, and XML files.
- Validating data loads by joining multiple tables and using complex SQL queries. Writing complex SQL queries, stored procedures, and functions to support data analysis and reporting needs.
- Using DML commands to insert and update user data in the database based on client requests or ticketing systems.
- Designing, developing, and deploying interactive reports and dashboards in Power BI to visualize data and provide actionable insights.
- Monitoring and troubleshooting ETL processes to ensure timely and accurate data integration.
- Performing data refresh activities to make data visible in the frontend Power BI application.
SQL Support Engineer (SQL Query)
Foxconn Hon Hoi Mega India Development Private Limited
08.2021 - 01.2023
- Analyzing and collecting data from multiple tables using joins and subqueries from the database.
- Cleaning and analyzing data based on user requests after collection.
- Segregating and organizing cleaned data in Excel based on multiple conditions to create simple and useful dashboards.
- Supporting users with data-related queries based on the ticketing system.
Education
Bachelor's degree in Electronics Engineering -
Adhi College of Engineering and Technology, Anna University
Skills
SQL
Power BI
Excel
Python Basics
ETL(SSIS & Power Query)
Certification
DATA ANALYST-Excelr Institute, From 03/2022 to 11/2022
Internshipprojects
AI VARIENT, Bangalore, From 11/2022 to 01/2023, Retail E-Commerce Project, Working on research, analysis, and preparation of project reports., Analyze Retail sales data transactions of e-commerce company & delivered interactive reports and dashboards for monitoring all KPI's like Products, Orders, Sales, Profit, Quantity, Loss etc. on Weekly, Monthly, Quarterly and Yearly basis., Provide performance improvement plan for improving product quality and services in all regions.
Disclaimer
I hereby declare that the above-mentioned information is correct up to my knowledge and I bear the responsibility for the correctness of the above-mentioned particulars
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Software
Python
Power BI
Work Preference
Work Type
Full TimeLocation Preference
On-SiteRemoteHybridTimeline
L2 Support Engineer
Health EC India Private Limited
02.2023 - Current
SQL Support Engineer (SQL Query)
Foxconn Hon Hoi Mega India Development Private Limited
08.2021 - 01.2023
Bachelor's degree in Electronics Engineering -
Adhi College of Engineering and Technology, Anna University