Kumar Patel
About Kumar Patel
Kumar Patel is a PL SQL Developer and Analyst with over 10 years of experience in software design and development, specializing in Oracle technologies. He currently works at Intuites in Wisconsin, where he focuses on database management and performance optimization.
Work at Intuites
Kumar Patel has been employed at Intuites as a PL SQL Developer & Analyst since 2011. Over the course of his 13-year tenure, he has contributed significantly to various projects involving Oracle technologies. His role encompasses the design, development, and implementation of software solutions, with a strong focus on database management and optimization.
Education and Expertise
Kumar Patel possesses extensive expertise in several key areas of database management and software development. He is skilled in Oracle DBA, SQL, PL/SQL, Data Stage (ETL), Informatica (ETL), and Oracle Data Integrator (ODI). His knowledge extends to writing shell scripts in Unix and Perl environments, enhancing his capabilities in data processing and automation.
Background
With over 10 years of experience in software design, development, and implementation, Kumar Patel has developed a robust skill set focused on Oracle technologies. He has experience handling large database tables, exceeding 500 million rows and 100 GB in size, which demonstrates his ability to manage substantial data volumes effectively.
Achievements
Kumar Patel has demonstrated proficiency in performance monitoring and optimization techniques using Oracle Hints, Explain plans, and table partitioning. He has also designed database schemas utilizing entity relationship modeling and database normalization principles. His experience includes debugging and testing PL/SQL packages, procedures, and functions, as well as creating DataStage jobs using various stages such as Transformer, Aggregator, Sort, Join, and Lookup.