Siddartha Varma Danthuluri

• Developed daily reports consisting of visualizations for effective communication.
• Contributed to risk assessment activities by identifying potential issues and suggesting mitigation strategies.
• Enhance and maintain databases.
• Assisted in formulating marketing strategies based on data insights.
• Contributed to data driven initiatives and aligning the data analysis with prevailing market trends.

• Performed data quality issue analysis Snow SQL by building analytical warehouses on Snowflake.

• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.

• Created and using Stored Procedures, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.

• Redesigned the views in snowflake to increase the performance.

• Validated the data from SQL Server to Snowflake.

• Expert in data Extraction, Transforming and Loading (ETL)using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), creating Dynamic packages for Incremental Loads.

• .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
• Gathered functional requirements, analyzing, and writing the technical specifications.
• Written Triggers, Stored Procedures, Functions, define User Defined Data Types, TSQL, and Create and maintain physical structures.
• Worked with Dynamic Management Views, System Views for Indexing and other Performance Problems.
• Enhance existing stored procedures, views, functions, database objects to meet additional requirements of latest releases.

.

• Reduced processing time for ETL tasks through the implementation of parallel execution strategies.
• Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
• Developed mappings, conducted unit testing, and addressed Business change requests on existing codes.
• Led end-to-end processes, understanding business requirements, and independently creating new interfaces.
• Managed TWS jobs performance, conducted failure fix analysis, and provided prompt resolutions.
• Created automation sheets for daily reporting on load statuses to clients.
• Conducted data analysis for failure jobs, including back-tracing tables from target to source and optimizing source query performance.
• Worked on shell scripts, parameter file modifications, code migrations, and updated Autosys job JIL.

• Implemented data-driven decision-making to enhance the effectiveness of CRM operations.
• Delivered exceptional results consistently, exceeding set targets for both individual and team performance.
• Cultivated strong relationships with key stakeholders to ensure smooth collaboration on various projects.
• Oversaw daily operations, monitoring team activities to ensure adherence to company policies and procedures.
• coaching on a weekly basis for team members.
• Process development projects and report making.
• Insights generation