Summary
Overview
Work History
Education
Skills
Certifications:
Project
Timeline
Generic

Shakthivel B

Chennai,tamilnadu

Summary

Adept and results-oriented Data Engineer with 9 years of experience in data warehousing, Snowflake development, and analytics. Proven expertise in building scalable data pipelines, developing advanced Snowflake features (Snowpipe, Streams, Tasks, Time Travel, Cloning), and leveraging SQL for complex data transformations. Experienced in integrating healthcare datasets and delivering actionable insights using Power BI. Recognized for improving data processing performance and driving stakeholder collaboration.

Overview

11
11
years of professional experience

Work History

Data Engineer II

IQVIA
01.2016 - Current
  • Designed and developed scalable data warehouse solutions supporting business intelligence needs.
  • Built and optimized Snowflake-based ELT pipelines using Snowpipe, Streams, and Tasks.
  • Utilized Time Travel and Cloning features for QA testing and data restoration across environments.
  • Created clustered materialized views to enhance performance on high-volume transactional data.
  • Engineered integrations and mapping workflows from diverse pharma datasets including IQVIA, Plan Trak, and NPA.
  • Developed dynamic KPI dashboards with Power BI, enhancing real-time executive insights.
  • Led cross-functional SQL and data visualization training sessions to improve team collaboration by 40%.
  • Managed Git-based version control for SQL scripts and pipeline logic.
  • Reduced ETL processing time by 40% via optimized Snowflake pipelines.
  • Created a procedure to automate table creation by inferring schema directly from staged files in Snowflake.
  • Won the Impact Award for creating a unified projection tool for oncology datasets.

Business Executive

CMA CGM Shared Service Center
01.2014 - 01.2016
  • Processed and indexed shipping instructions for manifesting Bill of Lading documentation.
  • Ensured accuracy and compliance across international freight documentation.

Education

Bachelor of Engineering - CSE

Alpha College of Engineering
Chennai
06.2012

Skills

  • Snowflake
  • Amazon Redshift
  • SQL Server
  • SQLite
  • Snowpipe
  • Streams
  • Tasks
  • Time Travel
  • Cloning
  • ETL development
  • Materialized Views
  • Auto-clustering
  • SQL
  • Python
  • Data Profiling
  • Data Quality
  • Transformation
  • Integration
  • Git
  • Power BI
  • Excel
  • Dimensional Modeling
  • Star/Snowflake Schema

Certifications:

  • Snowpro Core Certification

Project

Immunocore – Snowflake-Based CRM & Sales Analytics Platform for Power BI 

  • Client/Domain: Biopharmaceuticals
  • Tools: Snowflake: SQL, Power BI
  • Data Sources: Salesforce CRM, 867 EDI Sales Data, ICS 3PL, Email & Call Activity Logs
  • Designed and implemented a robust data pipeline in Snowflake to support Power BI commercial and sales reporting.
  • Unified multi-source data to deliver a 360° view of HCPs, HCOs, and sales performance across geographies.
  • Integrated Snowpipe for real-time ingestion and implemented SCD Type 2 logic using Dynamic Tables.
  • Delivered Power BI dashboards that reduced report turnaround time by 30%.


Abbvie Custom Implementation Project | Role: Data Engineer 

  • Client/Domain: Oncology
  • Tools: Snowflake, SQL, Power BI
  • Data Sources: Patient treatment history, Claim data
  • Developed a unified solution to project patient counts for multiple tumors.
  • Consolidated logic across tumor teams into a scalable tool.
  • Built accurate projection logic in SQL and Snowflake.
  • Led stakeholder sessions for alignment and clarity.
  • Achieved 20% improvement in count accuracy.
  • Ensured data quality and governance throughout.
  • Awarded the Impact Award for execution and communication.

Timeline

Data Engineer II

IQVIA
01.2016 - Current

Business Executive

CMA CGM Shared Service Center
01.2014 - 01.2016

Bachelor of Engineering - CSE

Alpha College of Engineering

Similar Profiles

CREATE PROFILE
Shakthivel B