Pradeep Sangwan

Experience

• 

  Indian Air Force

  Feb 1997 - Feb 2017

  Developed and maintained PL/SQL codebase to support critical business operations, including stored procedures, triggers, and functions Accounts Department

  • Military

    Mar 2014 - Feb 2017

  • Military

    Feb 1997 - Feb 2014
• 

  Magna Infotech - A Quess Company

  Nov 2017 - Mar 2019

  Technical Consultant

  Collaborated with cross-functional teams to analyze requirements, design database solutions, and optimize SQL queries for performance and scalability. Implemented database schema changes and data migrations while ensuring data integrity and minimizing downtime. Conducted thorough testing and debugging of PL/SQL code to identify and resolve issues, improving application stability and user experience

• 

  Election Commission of India

  Apr 2019 - Oct 2021

  Senior Technical Consultant

  Led initiatives to optimize database performance, resulting in significant reductions in query execution time and resource utilization. Implemented database schema changes and data migrations while ensuring data integrity and minimizing downtime. Conducted thorough testing and debugging of PL/SQL code to identify and resolve issues, improving application stability and user experience. Participated in code reviews and knowledge-sharing sessions to foster a culture of continuous learning and improvement within the development team. Provided technical guidance and mentorship to junior developers, fostering their growth and development in PL/SQL programming Show less

• 

  CCS

  Nov 2021 - now

  Senior Technical Consultant

  Leveraged expertise as a PL/SQL Developer to design, develop, and maintain robust database solutions, including stored procedures, triggers, and functions, ensuring optimal performance and data integrity.Collaborated closely with data engineering teams to design and implement scalable data pipelines, ETL processes, and data warehouse solutions, integrating disparate data sources for comprehensive analytics.Utilized advanced SQL skills to optimize complex queries, enhancing query performance and reducing processing time for critical business applications.Played a key role in database architecture design and optimization, implementing best practices to support efficient data storage, retrieval, and manipulation.Led initiatives to automate data processes and workflows, increasing operational efficiency and reducing manual intervention in data management tasks.Participated in cross-functional teams to analyze business requirements, propose data solutions, and deliver actionable insights through data modeling and visualization techniques.Actively contributed to the adoption of emerging technologies and methodologies in database development and data engineering, staying abreast of industry trends and best practices.Provided mentorship and technical guidance to junior developers and data engineers, fostering their professional growth and development within the organization. Show less