Data Warehouse Azure Sql

Gokula Kaveeya Sethuraman

+1-689-***-**** *************@*****.*** LinkedIn

PROFESSIONAL EXPERIENCE

* ***** *** * ****** of experience in –

• Designing, implementing and managing data lake and data warehouse.

• Extract, Transform and Load (ETL) development using Python scripts and Azure Data Factory.

• Data automation using Azure Functions.

Paragon Digital Services Pvt Ltd., Chennai, India Aug 2018 – Mar 2022 Data Engineer

Project: ATP End State Tracker

• Built a financial tool using Python and Azure SQL server to calculate financial expenses of various departments within Dentsu, and to generate monthly reports at global level.

• Created workflows using Microsoft Graph APIs in Python on Azure Functions to notify role-based reviewers for validation of expenses within the stipulated timeframe.

• Automated user management using Okta API’s and Microsoft Graph APIs to control user access to financial data. Project: Vendor Onboarding

• Created Postgres database to load historical vendor data.

• Created applications and workflows in Semarchy for vendor onboarding.

• Created integration views for downstream applications. Project: Business Integration Accelerator

• Created a data platform on Azure Stack for Dentsu markets in France and Switzerland for utilization management.

• Processed files using Python on Azure Functions to load data in Azure SQL database.

• Created data warehouse using Azure SQL Pool to consolidate data from data lakes.

• Created ETL pipelines on Azure Data Factory to ingest data from data lake to data warehouse on incremental basis. Project: YouTube-Sharepoint & DV360 Alert

• Automated Dentsu’ s marketing video uploads to YouTube and video link notifications via Outlook email using Python.

• Used Google APIs and Python to extract data from Dentsu’ s campaign manager and store it in Google Sheets. APA Engineering Pvt Ltd., Chennai, India Jun 2017 – Jul 2018 Trainee Engineer

Project: eBay Dive

• Created tables, views, and stored procedures in MySQL to capture seller’s data from eBay Developer APIs to help identify areas of improvements and remain competitive in the market. SKILLS

• Programming Languages: Python, SQL

• Databases: MySQL, SQL server

• MDM Tool: Semarchy

• Cloud: Microsoft Azure – Azure Functions, Azure Data Factory, Azure SQL Server, Azure Blob, Azure SQL Pool EDUCATION

Anna University, Chennai, India Jul 2013 – Jun 2017 Bachelor of Technology (Branch: Information Technology) REFERENCE

Kristian Kabashi

Former Global Business Process -

Transformation Director

Dentsu International

Email: ***********@*****.***

LinkedIn: linkedin.com/kristiankabashi

Contact this candidate