Sachin Yadav

About Sachin Yadav

As a System Engineer at Infosys, I have been designing and implementing database…

Experience

1. System Engineer

   Infosys

   Jul 2021 — Present · Pune, IN

   As a Software Engineer specializing in data management and reporting, I have undertaken a range of responsibilities to ensure efficient data handling and meaningful insights. Over the experience of 2+ years, my role has encompassed the following:1.Database Design and Development:Designing and implementing complex database structures using SQL and PL/SQL to support various business functions.Developing stored procedures, triggers, and functions to enhance data integrity, consistency, and retrieval efficiency.Collaborating with cross-functional teams to gather and analyze requirements, translating them into effective database solutions.2.Query Optimization:Identifying and resolving performance bottlenecks in SQL queries to improve database responsiveness and overall system performance.Utilizing indexing strategies, query rewriting, and execution plan analysis to enhance query execution times.3.Reporting Solutions (SSRS):Developing interactive and visually appealing reports using SSRS, presenting key performance indicators, trends, and insights to stakeholders.Collaborating with business users to understand reporting requirements, designing report templates, and ensuring data accuracy in reports.4.Data Quality and Integrity:Implementing data validation checks, data cleansing routines, and data quality measures to ensure the accuracy and reliability of information stored in databases.Monitoring data consistency and addressing data quality issues proactively.5.Cross-Functional Collaboration:Working closely with business analysts, data analysts, and other team members to understand business needs and translate them into technical solutions.Participating in discussions to contribute technical insights and proposing innovative solutions to challenges.6.Documentation and Maintenance:Creating and maintaining documentation for database schemas, data dictionaries, ETL processes, and report specifications to ensure clarity and knowledge sharing.