TIRUVANAGIRI MOHAN SRAVANTHI

• Took full ownership of Predictive Network Modeling (PNM) platform including support, enhancements, testing, and production deployments, ensuring uninterrupted business operations
• Ensured zero disruption to business-critical workflows post vendor transition by maintaining continuous model execution and reporting reliability
• Acted as code owner and led UAT, SIT, and regression testing, enforcing quality standards and release stability
• Designed AS-IS and TO-BE architecture and drove modernization of PNM platform, improving scalability, performance, and maintainability
• Contributed to building a Unified Enterprise Data Layer by consolidating multiple logistics domains, enabling standardized and enterprise-wide analytics
• Enabled legacy modernization by identifying and migrating Db2/Mainframe datasets to Snowflake, supporting system decommissioning strategy
• Replaced manual CSV-based ingestion with automated Delta pipelines, significantly improving data reliability and scalability
• Reduced runtime of critical workflows from ~1 hour to minutes through automation, eliminating manual effort and improving efficiency
• Built Python-based automation to dynamically create and deploy Databricks workflows across environments, ensuring consistency and reducing deployment drift
• Initiated Talend to Azure Data Factory migration by coordinating across network, platform, and security teams to accelerate modernization
• Designed Unity Catalog migration strategy including compute design, access control, and metadata governance to strengthen platform security and data governance
• Identified and resolved critical stale data issues in production, preventing incorrect downstream reporting and mitigating business risk
• Implemented service principal–based authentication replacing legacy mechanisms, improving security, audibility, and reliability
• Enabled faster decision-making by developing performance metrics frameworks and analytics models for evaluating data and platform outputs
• Delivered self-service analytics capabilities using Snowflake automation, reducing time-to-insight for business users
• Supported supply chain and logistics optimization by delivering scalable, high-quality data platforms and reporting solutions

• Successfully migrated workflows from Informatica to Databricks, improving automation and efficiency in ETL pipelines.
• Utilized Snowflake cloud data warehouse to migrate on-premise synergy data, improving scalability and performance.
• Extensive experience in Snowflake stored procedure development, scheduling tasks, data optimization, and performance tuning. Implemented Snowflake data quality checks for clinical data, ensuring data accuracy and integrity.
• Proficient in CI/CD deployments with GIT and ADO, integrating Databricks and ADF with GitHub and ADO for seamless collaboration and version control.
• Designed and built a SAAS architecture for an analytics platform, enabling customers to schedule appointments, track reports, prescriptions, and doctor notes, and providing a natural language querying interface for data-driven decisions.
• Hands-on experience with Azure Function and ADF for provisioning the ETL/ELT engineered platform.
• Developed caregiver productivity metrics by integrating Power BI with ADO data, utilizing SharePoint and Logic Apps for processing and visualization.
• Designed and implemented a comprehensive security architecture, including role-based access controls, encryption mechanisms, and proactive monitoring, ensuring the confidentiality, integrity, and availability of sensitive patient data.
• Developed a data analytics and business intelligence solution for a healthcare organization, enabling data-driven decision-making, predictive modeling, and real-time dashboards to enhance clinical performance and patient outcomes.
• Provide technical guidance and membership to junior team members, fostering a culture of learning and excellence in data engineering.

• Well experienced with Teradata architecture, Teradata SQL. Worked extensively on query performance, system performance and data profiling issues.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing.
• Knowledge on Wait activity, Validate Activity, Switch Activity, Until Activity.
• Skills with Azure Data Lake, Azure Data Factory, Azure Blob, Storage Explorer, Azure Databricks, Azure Synapse analytics, Power BI.
• Design & implement migration strategies for traditional systems on Azure (Lift and shift/Azure Migrate) worked on Azure suite: Azure SQL Database, Azure Data Lake (ADLS), Azure Data Factory (ADF) V2, Azure SQL Data Warehouse, Azure key Vault, Azure Blob Storage, Key vault, Azure active directory.

• Optimized queries by looking at execution plan for better tuning of the database.
• Performance tuning, including collecting statistics, analyzing explains.
• Viewpoint Alert setup, Administration and Monitoring.
• Using Teradata utilities like TD administrator, SQLA, Index wizard for analyzing the systems and query performance.
• In depth knowledge of Teradata file system, data dictionary, Access rights, Database locks, Join strategies and UNIX commands.
• Knowledge and experience on ETL tool Informatica.
• Writing quick SQL Queries, Stored Procedures, User Defined Functions to implement the business logic.
• Experience in Database objects Management, Database/User Management, Space Management and Security administration.
• Performance tuning, including collect statistics, analyzing explains.
• Using node level debugging tools like puma, amp load, and Linux tools sar, iostat etc. to check server performance.
• Provide diagnostic Workaround to customer DBAs until the fix releases.
• Writing SQL scripts / Macros for collecting the performance data of the system when the issue is happening.