Satya Mohan Samanthakurthi
Summary
Azure Data Engineer with 3+ years of Cognizant experience building cloud data pipelines, Azure Databricks workflows, PySpark transformations, Azure SQL datasets, BI reporting layers and Microsoft Fabric learning projects across healthcare and finance domains. Experienced in SQL migration, SSIS/SSRS modernisation, Power BI reporting, data validation, RPA with UiPath, HIPAA-aware data handling and GDPR principles.
Professional Experience
Cognizant - Azure Data Engineer / Associate Engineer
Client: Optum Finance / UnitedHealth Group | Jul 2024 - Dec 2024
- Built Azure Databricks pipelines using Apache Spark, PySpark, Spark SQL, Azure SQL and Databricks Jobs for finance datasets across 5+ business units.
- Migrated 50+ SQL scripts into configuration-driven Databricks notebooks while preserving business rules, joins, filters, reconciliation logic and report output structures.
- Designed PySpark transformations for joins, aggregations, deduplication, schema alignment, NULL handling, audit columns and row-count checks across 20+ datasets.
- Improved pipeline execution performance by 25% through Spark SQL refactoring, partition-aware transformations and notebook parameterisation.
- Built Power BI dashboards and DAX measures on curated finance datasets, enabling stakeholders to monitor 10+ KPIs and reduce manual Excel reporting by approximately 30%.
Cognizant - Cloud Migration Engineer / Associate Engineer
Client: CareSource - BI Reporting 2.0 | Oct 2023 - Jun 2024
- Delivered a cloud migration POC from on-premises SSIS/SSRS to Azure Databricks and Power BI, improving report performance by 30% and securing client sign-off.
- Re-engineered legacy SSIS ETL logic into modular Databricks SQL and PySpark ELT pipelines with reusable transformations and workflow-level scheduling.
- Reconciled 10M+ records between SQL Server, SSIS outputs and Databricks datasets using row counts, aggregate comparisons, exception reports and source-to-target rules.
- Rebuilt 10+ SSIS/SSRS workflows as cloud-native Databricks pipelines while maintaining HIPAA-aware data handling.
Cognizant - Programmer Analyst, Data Engineering and BI
Client: CareSource Reporting | Nov 2021 - Sep 2023
- Developed 200+ T-SQL stored procedures, views, functions, indexed views, triggers and constraints for healthcare finance, claims, provider and member reporting.
- Built and supported 120+ SSIS workloads integrating SQL Server, flat files, Excel, ODBC and OLE DB sources.
- Designed 30+ SSRS paginated reports with drill-down views, matrix layouts, grouped tablix regions and parameterised filters.
- Improved average query performance by 20% through indexing, execution-plan review, join optimisation and stored procedure refactoring.
Education and Academic Projects
MSc, Artificial Intelligence for Business - National College of Ireland
Jan 2025 - Jan 2026
- Developed a Hybrid Ant Colony Optimisation model for last-mile delivery using the LaDe dataset with 1.4M+ delivery trajectories; KNN-ACO achieved a 2.46 km best route, 73.85% improvement over random initialisation and 68.46% Hit Rate @ Top 3 across 30 test routes.
- Designed a UiPath RPA proof-of-concept for Student Leap Card application triage using rule-based validation, CSV audit reports and email notifications.
- Built CORDIS Research Explorer, a live Next.js and Supabase research discovery application using cleaned CORDIS data.
B.Tech, Electronics and Communication Engineering - SRIN College, India
Jun 2016 - Nov 2020
Skills
Cloud: Azure Data Factory, Azure Databricks, Microsoft Fabric, Lakehouse, OneLake, Azure SQL, Delta Lake, Spark SQL, Databricks Jobs, Fabric Data Pipelines.
BI and Data Engineering: T-SQL, SQL Server, SSMS, SSIS, SSRS, Power BI, DAX, Power Query, ETL/ELT, Medallion Architecture, audit logging, data quality rules, source-to-target mapping, reconciliation and performance tuning.
Programming and AI: SQL, PySpark, Python, KQL, NumPy, Pandas, Matplotlib, Scikit-learn, TensorFlow, NLP, ANN, DNN, Keras, optimisation algorithms and UiPath RPA.
Tools: VS Code, Git, Jira, Confluence, Agile, TFS, CI/CD release controls, DEV/INT/CRT/UAT/EUAT/PRE-PROD/PROD environments.
Certifications
- Microsoft Certified: Azure Fundamentals (AZ-900)
- Microsoft Certified: Azure AI Fundamentals (AI-900)
- Microsoft Certified: Power BI Data Analyst (PL-300)
- Microsoft Certified: Fabric Data Engineer Associate (DP-700)
- DeepLearning.AI Machine Learning Specialization courses
- Oracle Cloud Infrastructure AI Foundations Associate
Awards
- Best Employee of the Project - CareSource MDP Migration, Cognizant, 2024
- Emerging Talent Award, Cognizant, 2023
- Working as One Award, Cognizant, 2022