Divyansh Khare

Experience

• 

  Bharat Sanchar Nigam Limited

  Jun 2019 - Jul 2019

  Network and Telecommunication
• 

  Cognizant

  Jun 2021 - May 2024

  Working in the Integration team under the Retail domain, helping vendors to process goods, purchase orders, Items, Invoices and maintaining ETL workflows. Writing complex queries, Subqueries, Joins, Views, User Defined Functions, StoredProcedures, Triggers using T-SQL.Developing SSIS packages by using different types of control flow tasks , data flow transformations and deploying the packages to Production server. Creating database and schema objects including tables, indexes, views, functions and storedprocedures .Creating ETL jobs for extracting, cleaning , transforming. Show less

  • Associate

    Jul 2023 - May 2024

  • Program Analyst

    Jun 2021 - Jun 2023
• 

  D2K Technologies

  May 2024 - now

  MSBI Developer

  Working on-site under the banking domain (EWS).Writing complex T-SQL queries, including subqueries, joins, views, user-defined functions, stored procedures, and triggers.Managing and maintaining database schema objects, including tables, indexes, views, and functions.Utilising indexing strategies and partitioning to handle large transactional data tables, improving database efficiency and scalability.Monitoring database performance and performing regular maintenance tasks such as rebuilding indexes, updating statistics, and optimizing stored procedures to ensure optimal performance.Leading performance optimization efforts by tuning complex queries, stored procedures, and ETL workflows, resulting in improved data processing times and system efficiency.Implementing data quality checks and validation processes to ensure data accuracy and integrity throughout the ETL pipeline.Supporting critical banking operations by ensuring seamless data integration and workflow management across key areas.Optimizing ETL processes to support large-scale data analytics and reporting, aiding the bank in risk management, fraud detection, and financial performance analysis.Managing and processing high volumes of banking transactions and customer data, ensuring data accuracy and compliance with financial regulations. Show less