Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Projects
Domainknowledge
Timeline
Generic

Shakthivel B

Chennai

Summary

Adept Data Engineer with a proven track record at IQVIA, specializing in developing scalable data warehouse solutions and enhancing data quality. Excelled in leveraging Snowflake and Power BI to create dynamic KPI dashboards, demonstrating strong analytical skills and a commitment to accuracy. Skilled in collaborating effectively with stakeholders to meet organizational objectives.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Data Engineer 2

IQVIA
Chennai
01.2016 - Current
  • Designed and developed scalable data warehouse solutions to support business intelligence and reporting
  • Collaborated with business and IT stakeholders to align data strategies with organizational objectives
  • Conducted data profiling, identifying trends and improving data quality across multiple sources
  • Engineered integration workflows for multi-source datasets and created comprehensive mapping documents
  • Developed dynamic KPI dashboards using Power BI, enhancing real-time decision-making capabilities
  • Leveraged SQL, Snowflake, and Amazon Redshift for ETL processes and complex data analysis
  • Gained proficiency in pharma datasets such as IQVIA, Symphony: Xponent, Plan Trak, NPA, and others
  • Managed Git workflows for version control, ensuring seamless collaboration and code integrity

Business Executive

CMA CGM Shared Service Center
Chennai
01.2014 - 01.2016
  • Processed and indexed shipping instructions received from shippers, freight forwarders, and front offices
  • Ensured accuracy and compliance in manifesting Bill of Lading documentation

Education

Bachelor of Engineering - Computer Science & Engineering

Alpha College of Engineering
Chennai
06.2012

Skills

  • Snowflake
  • Amazon Redshift
  • SQLITE
  • SQL
  • C#
  • Power BI
  • Excel
  • Data warehousing
  • Data modeling
  • Data profiling
  • Extracting
  • Transforming
  • Loading data
  • Git
  • Ensuring accuracy
  • Consistency of datasets

Certification

SnowPro Certification

Accomplishments

  • Reduced data processing time by 40% by optimizing ETL workflows using Snowflake and Amazon Redshift.
  • Developed Power BI dashboards that enhanced executive decision-making, reducing report generation time by 30%.
  • Received the Impact Award at IQVIA for delivering a unified projection tool for patient data across multiple teams.
  • Spearheaded the deployment of a healthcare data platform, integrating actionable insights from diverse pharma datasets.

Projects

Abbvie Custom Implementation Project, Data Engineer, Developed a unified solution to project patient counts for multiple tumors, integrating unique methodologies for patient claim data., Collaborated with stakeholders from various tumor teams to align methodologies into a comprehensive tool., Utilized SQL and Snowflake to implement accurate and scalable projection logic., Conducted extensive coding and led stakeholder meetings to ensure clarity and alignment., Delivered a tool ensuring 20% improvement in patient count accuracy and fostering collaboration., Maintained data quality and governance throughout the project lifecycle., Received the Impact Award for exceptional stakeholder management and project execution.

Domainknowledge

  • Life Sciences & Pharma Data: IQVIA
  • Symphony
  • Plan Trak
  • NPA
  • DDD
  • LAAD
  • FIA
  • Formulary data
  • Prescriber Dynamics
  • Payer data
  • Digital Interaction data
  • Veeva CRM
  • Call Activity data

Timeline

Data Engineer 2

IQVIA
01.2016 - Current

Business Executive

CMA CGM Shared Service Center
01.2014 - 01.2016

Bachelor of Engineering - Computer Science & Engineering

Alpha College of Engineering

Similar Profiles

CREATE PROFILE
Shakthivel B