Gartner employee worked on implementing PowerBI dashboards for the Snowflake database using Airflow and dbt.

In addition to this, they were responsible for architecting data consumption from various public data sources such as Google, Facebook, LinkedIn, etc.

They also created proof-of-concept tests of different tools and methods.

Worked as a senior data transformation engineer at PepsiCo, the global leader in the snacks and sodas industry

Designed transformations to retrieve data from various sources and combined them in the Snowflake model

Required strong data engineering knowledge and understanding of data warehouses, data pipelines, and data quality concepts

Performed a migration of an Oracle database to SQL Server using best practices, latest technology, and design patterns over seven months.

Redesigned the database and introduced new features such as partitioning, compression, data checks, and extensive logging, making it more robust and easy to use.

Significantly decreased processing time and provided real-time reporting on each data load, bringing significant operational and data quality benefits to the client.

Utilized a wide technology stack, including Excel/VBA, Access, SQL database, Salesforce, and Qlik in the development and analysis project for Johnson & Johnson.

In the reporting department, assessed the existing setup, proposed improvements, and developed modules for new marketing and sales requirements.

Updated the reporting/database solutions and minimized the use of Excel in daily business operations.

Created migration scripts for SQL Server database transfer and installation

Provided detailed documentation for user guidance on simple modifications

Developed a proof-of-concept for utilizing Azure PowerBI over Excel reporting

Worked as the data warehousing expert on the 'Life Church' project, specializing on the SQL Server

Designed data warehouse tables and was ultimately responsible for their design

Implemented and optimized the ETL processes using SSIS and SQL, improving data warehouse loading procedures

I wrote a SDLC guide for a software company

The company needed to formally map its development processes

The project was a part of my role as a Technical Writer for Project Management

Leading the migration of an existing web application

Ensured successful migration of Oracle database to new SQL Server

Handled processes from analysis to implementation, testing, and final cutover procedures

Data warehouses enable companies to uncover valuable insights from their extensive data collections.

The author, a domain expert, shares fundamental principles and applications of data warehouses.

These principles and applications are critical knowledge for modern managers.

Transactional data, which holds crucial business information, is most vulnerable when in transit between the server and client. The traditional method of securing this data involves encrypting it on the server and using the SSL-enabled HTTPS protocol.

A more secure approach is to send data in an encrypted format over the communication line, which can then be decrypted only by clients possessing valid certificates, making man-in-the-middle attacks much more challenging.

Microsoft's solution to this issue is Always Encrypted, which allows encrypted data to be sent over the pipeline and decrypted only by clients with valid certificates. This article provides guidance on setting up and using Always Encrypted.