SAMPATH SAKKHARI

Designed and executed comprehensive test plans, cases, and regression suites for complex ETL pipelines, leveraging SQL and Snowflake to validate data integrity across staging and target Data Warehouses.

Analyzed diverse source systems, staging areas, and DWH tables (Fact and Dimension) to identify data discrepancies and ensure accurate data transformation, maintaining high data quality standards.

Authored detailed Test Strategies and Test Plans, alongside comprehensive Test Cases, standardizing testing protocols for complex ETL workflows to enhance accuracy and efficiency.

Utilized expertise in SQL to effectively query and test various RDBMS (Oracle, MS SQL Server), ensuring robust data quality and optimal performance for critical data pipelines.

Provided critical support for AutoSys job monitoring and troubleshooting, resolving failed data pipelines to minimize downtime and ensure continuous data flow and operational continuity.

Led the successful deployment of multiple software programs and web applications, standardizing deployment practices across projects to significantly enhance efficiency and consistency.

Managed comprehensive software inventory and executed proactive patch management, ensuring all systems were up-to-date with the latest security patches and minimizing vulnerability risks.

Resolved complex deployment issues through collaborative efforts with cross-functional IT teams, including Networking and Security, ensuring seamless project execution and system stability.

Developed automation scripts for critical deployment tasks, such as application installations and user migrations, reducing manual effort and accelerating project timelines.

Conducted detailed workflow analysis and cost comparison studies, providing data-driven insights that optimized resource allocation and informed strategic system upgrade decisions.