Mitsu Kansagara
Data Engineer @Delta Dental of Missouri
Signup · Get unlimited contacts
WORK HISTORY
Data Engineer @Delta Dental of Missouri
St Louis, MO, US
Building in-house EDI (Electronic Data Interchange) Gateway to securely transfer health records for 900+ clients in insurance industry, incorporating data governance controls to ensure compliant and auditable data transfer.• Implemented Python-based Azure Function App with CI/CD pipelines in DevOps to automate deployment and version control• Developed Snowflake stored procedures containing the core business logic for data validation and parsing (EDI, flat, non-flat) files• Drove advanced analytics during UAT testing, formulating Snowflake queries to uncover data-driven insights for high-priority clients, reducing manual effort by 90%• Built Reverse ETL to sync 900+ client profiles from warehouse to downstream application database, enabling automated refresh• Automated ETL for hourly rejection data from Snowflake to Blob Storage, delivering reports and cutting processing time by 80%• Debugged Function App using KQL (Azure Monitoring Logs), validating reliable execution of critical business logic• Configured monitoring and alerts for Azure Data Factory pipelines, reducing response time to less than 15 minutes• Designed Azure Change Data Capture (CDC) pipelines to incrementally load and transform data from data warehouse into data mart utilizing Mapping data flows, reducing data processing time by 75% and ensuring near real-time analytics availability• Led Power BI dashboards reporting initiative that saved 10+ hours weekly, leveraging VNet Gateway to access private data sources• Engineered semantic models with DAX, implementing Row-Level Security to provide user-based access and ensure data compliance• Managed 200+ JIRA tickets, driving project success through meticulous user story creation, sprint planning and progress tracking
EDUCATION
Dharmsinh Desai University
Bachelor of Technology - BTech, Information Technology
W. P. Carey School of Business – Arizona State University
Master of Science - MS, Information Systems Management Specialization: Data Analytics
ABOUT MITSU KANSAGARA
Domain Level Skill Set - • Data Engineering: ETL/ELT pipeline development, Data…
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.