Deepak Devarapalli
About Deepak Devarapalli
Deepak Devarapalli is a Senior Oracle Database Developer with extensive experience in optimizing SQL query performance and managing large datasets. He has worked for various companies, including WealthEngine, Verizon Business, and CNSI, and holds a Bachelor's degree in Computer Science Engineering and a Master's degree in Computer Science and Information Technology.
Work at WealthEngine
Deepak Devarapalli has been employed at WealthEngine as a Senior Oracle Database Developer since 2011. In this role, he has focused on managing large datasets and optimizing database performance. He developed a normalized data model in ERWIN to effectively manage production and sales data for WealthEngine's product line. His responsibilities include utilizing Oracle predefined packages and employing advanced techniques for data handling.
Previous Experience in Database Development
Prior to his current position, Deepak worked at various organizations in similar roles. He served as a Senior Oracle Database Developer at Verizon Business from 2009 to 2010 and at sanofi-aventis for five months in 2009. He also held a position as an Oracle Developer at CNSI for a total of 16 months across two tenures from 2006 to 2009. Additionally, he worked at IFMC for five months in 2008.
Education and Expertise
Deepak holds a Bachelor's degree in Computer Science Engineering from GKM College of Engineering and Technology. He furthered his education by obtaining a Master's degree in Computer Science and Information Technology from the University of Detroit Mercy. His educational background supports his extensive expertise in database management and optimization techniques.
Technical Skills and Specializations
Deepak possesses extensive experience in optimizing SQL query performance using tools such as Explain Plan, TKPRF, and AWR. He is proficient in loading large datasets with SQL*Loader and External Tables. His skill set includes using Oracle packages like UTL_FILE, DBMS_SCHEDULER, and DBMS_AQ. He specializes in handling large volumes of data through techniques like Bulk Collections and Table Partitions, and he is experienced in scheduling jobs with Crontab and DBMS_SCHEDULER.
Database Administration Activities
In addition to development, Deepak has expertise in database administration activities. He manages database storage space and is skilled in reclaiming unused space. His experience includes writing Unix Shell Scripts for automation tasks related to database management, enhancing efficiency in operations.