Kamlesh Patel

Experience

• 

  CGI

  Sept 2015 - Jan 2018

  Database Administrator

  •Developed SQL queries to extract, analyze, and present data for decision-making purposes.•Defined Functions and Triggers to store data into appropriate tables as data arrives and implemented indexes to improve query performance, especially for tables with minimal updates.•Collaborated with cross-functional teams to identify data requirements and provide insights to drive business strategies.•Created and maintained data visualization tools to track key performance indicators and trends.•Leverage advanced data visualization techniques to communicate complex data insights in a compelling and easy-to-understand manner, facilitating data-driven decision-making across departments.•Implement advanced SQL techniques to optimize data retrieval and ensure efficient data processing, ultimately improving overall database performance and scalability.•Utilize advanced SQL development skills to optimize database performance and automate data extraction processes, ensuring efficient and accurate data retrieval for informed decision-making across CGI departments.•Utilize machine learning algorithms to analyze and predict data patterns, providing valuable insights for strategic decision-making and business growth.•Proactively identify opportunities for process improvement within data extraction, analysis, and visualization, contributing to increased efficiency and accuracy in decision-making processes for CGI.•Develop and implement data governance policies and procedures to ensure data accuracy, integrity, and security, aligning with CGI's data management strategies and regulatory requirements.•Collaborate with IT teams to integrate data analysis tools and platforms, ensuring seamless data flow and interoperability for efficient decision-making processes within CGI. Show less

• 

  Expedia Group

  Feb 2018 - Jan 2020

  SQL Developer

  •Implementing optimized SQL queries to improve performance and efficiency of database operations, ultimately enhancing user experience on Expedia's platforms.•Optimizing SQL queries to improve database performance and efficiency, ensuring faster data retrieval for improved.•Customer experiences and business operations.•Analyzing data trends and providing insights to support Expedia's decision-making process in creating personalized customer experiences and optimizing sales strategies.•Developing innovative data models and algorithms to analyze customer behavior and preferences, enabling Expedia to personalize user experiences and optimize marketing strategies.•Developing innovative data visualization techniques to present complex data insights in a user-friendly and impactful manner, enhancing Expedia's decision-making process and customer experience.•Collaborating with cross-functional teams to integrate SQL solutions into Expedia's existing systems and applications, ensuring seamless implementation and minimal disruptions to business operations.•Collaborating with cross-functional teams to identify and address performance bottlenecks in SQL queries, ensuring seamless operations across Expedia's platforms.•Created, debugged, and modified Stored Procedures, Triggers, Tables, Views, and User-Defined Functions. Show less

• 

  Welkin Technologies LLC

  Jul 2020 - Dec 2023

  Senior SQL Developer

  • Developed and implemented complex SQL queries to extract data from multiple databases.• Optimized existing queries by analyzing query plans and execution times.• Performed database tuning activities such as indexing, partitioning and performance monitoring.• Implemented automated processes for loading, unloading data into, from the databases using SSIS packages.• Provided technical support to users in resolving database related issues and errors.• Assisted in troubleshooting application issues related to database objects or performance bottlenecks.• Developed database dictionaries and schemas.• Worked closely with systems analysts, engineers and programmers to understand limitations, develop capabilities and resolve software problems. Show less