About
Highly motivated Data Engineer with 2+ years of experience in developing and optimizing robust ELT pipelines, specializing in Azure Data Factory, Snowflake, and SQL. Proven ability to integrate complex data from diverse sources, automate processes, and enhance reporting efficiency, notably reducing client costs by 30%. Eager to leverage strong analytical and technical skills to drive organizational success in a dynamic data-driven environment.
Work
Accordion India
|Data Engineer 2
Hyderabad, Telangana, India
→
Summary
Led data engineering initiatives for Southern Orthodontic Partners, focusing on ELT development, process automation, and performance optimization to enhance CRM integration and data reporting.
Highlights
Engineered and optimized ELT processes, integrating data from 7 diverse Practice Management Systems (PMS) and Active Campaign CRM into a centralized Data Warehouse using Azure Data Factory, facilitating seamless CRM integration and data-driven reporting.
Automated CRM data management by establishing processes to remove irrelevant contact and deal data, implementing comprehensive exception handling with Azure Logic Apps, Azure Data Factory, and SQL stored procedures for reliable data mapping.
Redeveloped and optimized SQL stored procedures and Azure Pipelines, enhancing CRM integration and dashboard reporting reliability and reducing client costs by 30% by resolving bottlenecks.
Managed and automated daily PMS to CRM data refresh processes for 60 practices, ensuring accurate and timely data delivery within a strict 2-hour window through SQL CI/CD with Microsoft Visual Studio and Azure DevOps.
Delivered client data reporting requirements on time with thorough validation, creating and optimizing reporting workflows for CRM integration and dashboard reporting to provide actionable insights.
Education
Sardar Vallabhbhai National Institute of Technology
→
Bachelor of Technology
Mechanical Engineering
Grade: CGPA: 8.56
Sri Chaitanya Junior College
→
Intermediate
MPC
Grade: Marks(%): 95
Dr. K. K. R's Gowtham School
→
SSC
General Studies
Grade: CGPA: 9.8
Certificates
Microsoft Certified: Azure Data Fundamentals (DP-900)
Issued By
Microsoft
Skills
Programming Languages
Python, SQL.
Cloud Platforms & Services
Azure Data Factory, Azure Logic Apps, Azure Functions, Snowflake, Azure DevOps, Azure Key Vault, Azure SQL Database, Azure Storage.
Data Management & Warehousing
ELT, Common Data Model (CDM), Data Warehouse, SFTP.
Tools & Methodologies
Microsoft Visual Studio, Pycharm, CI/CD, PGPy Encryption, Audit Logging, Exception Handling, Data Mapping.