VISHAL SHUKLA

I have total 13 years of experience in SQL performance tuning, Query optimization, Oracle Database Development, Data analysis and software development. I hold a Certification in Power BI and Oracle Pl/Sql for development and Scrum Master certifications. Deep knowledge of Oracle architecture, including memory structures (SGA, PGA), background processes, and storage structures. Experience in ETL.

1. Expert in Oracle Performance Tuning 2. Understanding the System: • Deep knowledge of Oracle architecture, including memory structures (SGA, PGA), background processes and storage structures. • Strong knowledge of Oracle optimizer, it’s behavior, * Conducted in-depth analysis of customer behavior, market trends, and product performance to inform strategic decision-making and drive business growth. * Designed and implemented data collection processes and systems to ensure the accuracy and completeness.

*Collaborate with cross-functional teams including business analysts and QA testers to gather requirements, define project scope, and prioritize tasks. *Develop complex PL/SQL code for stored procedures, functions, triggers, and packages to support business processes and application functionality. *Optimize database performance through query optimization, indexing strategies, and database tuning techniques. Conduct code reviews and provide technical guidance and mentoring to junior developers to enhance.

• Creation of package, procedure, trigger, indexes, table type, Materialize view , partitioned table and various performance tuning technique. Conducted in-depth data analysis to identify trends, opportunities, and risks, contributing to a increase in revenue. • Implemented data quality and governance processes, ensuring data accuracy and reliability across the organization. Conducted in-depth data analysis to identify trends, opportunities, and risks, contributing to a increase in revenue.

Done research and thesis on 'Ant Colony Optimization' under Artificial Intelligence algorithm

Information technology algorithm and analytics