Dhanesh K R

- Led comprehensive Data Warehousing and Data Modelling initiatives for supply chain data, orchestrating the entire process from requirement gathering, solutioning and mapping document preparation with calculation logics.

- Designed and released data entities for various subject areas including sourcing, inventory and finance by closely collaborating with business stakeholders and data architects to ensure alignment with functional requirements and enterprise data standards.

- Developed and optimized over 30 database objects, including stored procedures, tables, and views, tailored to meet 100% of new requirements and diverse intakes. This initiative improved data processing be efficiency, accelerating responses times for business queries and enhancing overall decision-making.

- Designed and implemented data pipelines using Spark SQL and Azure Databricks, ensuring robust ETL workflows and data quality.

- Leveraged python in Databricks to perform data analysis, build reusable notebooks and support data driven decision making.

- Contributed to a major banking data integration project following the acquisition, Played a critical role in consolidating and aligning the data structures across both entities into a unified reporting and analytics environment

- Developed and maintained SSIS packages to automate ETL workflows for ingesting, transforming, and loading customer, account, and transactional data across core banking systems.

- Worked on multiple data intakes and onboarding requests, writing custom SQL scripts to integrate and reconcile new data feeds with the target data warehouse schema.

- Executed monthly data refreshes and production deployments for diverse clients, maintaining proactive communication throughout, resulting in heightened client satisfaction and project success.

-Diagnosed and resolved critical file, data, and system issues during ETL refresh cycles, preventing downstream delays and system outages.

-Proactively tackled and resolved file/technical issues during data refresh cycles, showcasing strong troubleshooting skills. Compiled a knowledge base document, boosting team efficiency by 40% for future challenges and fostering a culture of continuous improvement.

-Performed detailed post-deployment data validation and quality checks, reducing reporting inconsistencies and ensuring compliance with business rules.

- Pioneered the automation of US healthcare data flow from SFTP to SQL server, employing a robust approach of cleaning, transforming, integrating, and populating data into dimension and fact tables using SSIS. Leveraged the database objects , including Stored Procedures, Functions and Triggers.

- Collaborated with the reporting team to enable real-time dashboarding and data visualization readiness, ensuring availability of accurate data for clinical and operational insights.

-Created detailed data flow diagrams and technical documentation, supporting compliance audits and facilitating better cross-team collaboration.

- Actively engaging in scrum calls and tracking projects efforts through Jira.

-