Headline

Principal Data Engineer @ Elanco

Location

Bengaluru

AI stack

antigravity

codex

hermes agent

hugging face

langchain

mcp

Work experience

Principal Data Engineer at Elanco, Dec 2024 - Present · 2 yrs, Bengaluru, Karnataka, India

Data Architect at ITC Infotech, Jul 2021 - Nov 2024 · 3 yrs 5 mos

Lead Consultant at ITC Infotech, Jan 2019 - Jun 2021 · 2 yrs 6 mos, London Area, United Kingdom, - Responsible to build Data Lake / Modern Data Warehouse on Azure using PaaS services including HDInsight - Spark/Hive, Databricks, Azure Data Factory, Azure SQL DB, Azure Data Warehouse, Key Vault, Azure Cosmos DB, VNet, Subnet, Logic and Function Apps, Monitoring - On-premises to Cloud Application Migration (Lift and Shift) - Defined DevOps for Application development and infrastructure deployment - Azure Automation using PowerShell, CLI and ARM template

Associate Consultant IS2 at ITC Infotech, May 2017 - Jan 2019 · 1 yr 9 mos, Bangaon, West Bengal, India, - Responsible to build Modern Data Warehouse on Azure using PaaS services including HDInsight - Spark/Hive, Databricks, Azure Data Factory, Azure SQL DB, Azure Data Warehouse, Key Vault, Azure Cosmos DB, VNet, Subnet, Logic and Function Apps, Monitoring - Created End-to-End workflow to load and extract the data from the unstructured EDIFACT sources to Azure Analysis Service by using Azure Data Factory - Worked on Hive Activity, Spark Activity, Stored Procedure and Copy Activity in Azure Data Factory - Developed the ETL framework in Spark/Scala for data cleansing and transformation - Worked on Azure Power Shell scripting to automate the deployment of the Azure resources - Worked on Security, Alerting and Monitoring of Azure PaaS services - Worked on Power BI interactive dashboards and reports to visualize the data as per the business requirement

Data Engineer at Publicis Sapient, Jun 2016 - May 2017 · 1 yr, Gurugram, Haryana, India, - Worked with Microsoft team to configure HDInsight cluster on Microsoft Azure to leverage Spark and Hive - Worked with the Facebook team to understand the Atlas clickstream data and reduce the time taken by report generation - Monitoring, Optimizing and performance tuning Hive Services - Collaborated with the data scientist to prepare data for use in his advanced analytical models - Worked on Linux/Unix & PowerShell scripts to automate the process - Utilized Spark & Hive on this dataset for further insights - Responsible for writing Spark/Scala code and Hive queries to analyze the data

Software Engineer at Aon Hewitt, Jul 2013 - Jun 2016 · 3 yrs, Noida, Uttar Pradesh, India, - Worked with Business Analysts and Business users to understand the user requirements, layout and look and feel of the application to be developed - Implemented Data Blending and generated interactive dashboards - Created ad hoc reports to users by creating various data sources - Developed Tabular, Parametrized (single, multi), Drill Through & Drill Down, Map, Gauge, Matrix, and Sub Reports in SSRS with PDF, XLS, and CSV Formats - Worked on MDX, stored procedures and T-SQL to enhance and automate the process and to develop the new modules - Identified the dimension, fact tables and designed the data warehouse using Star Schema - Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS) - Developed Aggregations, partitions, and calculated members for the cube as per business requirements - Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.

Education

Bachelor of Technology (BTech), Computer Science, Rajasthan Technical University, Kota

Senior Secondary, 12th, Science, Agra Public School, Agra