Gowtham S

ETL and Report Developer

Role
Sql Database Developer and Administration at Cognisive
Location
Coimbatore, TN, IN
LinkedIn followers
500 followers

About Gowtham S

A competent software professional with 3+ years of experience in the field of Database and Business Intelligence Solutions using Microsoft Technologies in SQL SERVER 2012/2014/2016. Hands on experience in database design, development and implementation of Business Intelligence using Integration Services(SSIS) in Visual Studio 2013 and 2015.Worked on complete Agile environment process for cloud based supply chain process.Good at automation on MIS reports and delivering them as per the SLA.Experienced in Extracting, Transforming and Loading (ETL) from heterogeneous Data sources like Oracle, Flat file, Raw file, XML, Excel and OLE DB to Flat file, XML, Excel, OLE DB Destinations using various Connection managers.Experience in analyzing and fixing the production issues by creating break fixes for the complete Legacy processes.Experience in deployment of created reports in various sources like Web Services URLs.Experienced in creating Database Models and Objects like Tables, Stored Procedure, Functions, Triggers, Views, Indexes and Common Table Expressions (CTEs) using Transact SQL in SQL Server Management Studio (SSMS).Expertise in analysis of troubleshooting the production issues from client ETL tools and escalating more complex problems to other technical staff whenever necessary.Identifying the nature and cause of the problem and determining the most appropriate solution using the Standard Operating Procedure.Experience in writing complex T-SQL queries, Subqueries and joins, and better performance tuning – Execution plan, Performance Monitor and checking the resources.Easily collaborate with other team members for in-depth understanding of project flow.Handled both OLTP and OLAP in database/warehouse environments.Worked on both BI Implementation and trading partner development teams for fixing the solutions to production processes from lower environments.Worked on all phases of the Data warehouse development life cycle, from gathering requirements to testing,implementation, and support single-handedly.Created SQL Jobs to execute SSIS packages and publish data on the web server.

Experience

  1. Sql Database Developer and Administration

    Cognisive

    May 2022 — Present · Coimbatore, IN

Education

  • PSG College of Technology

    Bachelor's degree

    2012 — 2015

Find verified contacts for anyone on LinkedIn

Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.

Free plan included · No credit card required

This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.

Gowtham S — Sql Database Developer and Administration at Cognisive in Coimbatore, TN, IN | Unifers