Experienced Software Engineer with Expertise in Python, SQL, and Data Modeling for OLTP and OLAP Solutions In this role, Roles and Responsibilities: Database Development: Proficient in designing, developing, and maintaining databases using SQL queries, stored procedures, subqueries, and index functions to ensure efficient data retrieval and manipulation. Performance Optimization: Utilize query optimization techniques, including query analysis, indexing strategies, and execution plan analysis, to enhance database performance and scalability. Data Integration: Experienced in utilizing SSIS (SQL Server Integration Services) to extract, transform, and load data from various sources into the database, ensuring data accuracy and consistency. Report Generation: Proficient in creating interactive and visually appealing reports using SSRS (SQL Server Reporting Services), providing valuable insights to stakeholders and facilitating informed decision-making. Data Modeling: Skilled in designing and implementing database schemas, tables, views, and relationships, ensuring data integrity and normalization principles. Troubleshooting and Debugging: Expertise in identifying and resolving database-related issues, including performance bottlenecks, query optimization, and data inconsistencies. Object-Oriented Programming: Knowledge of object-oriented programming (OOP) concepts, including encapsulation, inheritance, and polymorphism, enabling efficient database design and development. Collaboration and Teamwork: Effective communicator and team player, collaborating with cross-functional teams to understand business requirements and deliver database solutions that align with organizational goals. Continuous Learning: Dedicated to staying updated with the latest advancements in database technologies, attending webinars, workshops, and industry conferences to enhance skills and knowledge. Email ID - adityaswain8924@gmail.com