Shiva Shankar Pagidala
About Shiva Shankar Pagidala
Shiva Shankar Pagidala is a Data Engineer with extensive experience in cloud-based data solutions and big data technologies. He has worked at Advance Auto Parts since 2019 and has held various roles in notable organizations, including The World Bank and TracFone Wireless.
Work at Advance Auto Parts
Shiva Shankar Pagidala has been employed as a Data Engineer at Advance Auto Parts since 2019. In this role, he focuses on data conversions and migrations from legacy systems to Oracle systems, utilizing SQL Loader and external tables. His work contributes to the company's data management and analytics capabilities, supporting the overall business objectives.
Previous Experience at TracFone Wireless
Prior to his current position, Shiva worked at TracFone Wireless as a Senior Oracle PLSQL Developer from 2017 to 2019. During his two years in the Miami/Fort Lauderdale Area, he specialized in enhancing query performance by minimizing context switches between PL/SQL and SQL engines through advanced techniques such as TYPES, Collections, and BULK COLLECT.
Background at The World Bank
Shiva Shankar Pagidala served as a Senior Oracle Developer at The World Bank from 2011 to 2015. His four-year tenure in the Washington D.C. Metro Area involved leveraging his expert-level experience in PL/SQL, including advanced features like Cursors, Ref-cursors, and Oracle Supplied Packages.
Education and Expertise
Shiva earned a Bachelor of Technology (B.Tech.) in Electrical and Electronics Engineering from SSJ Engineering College, studying from 2002 to 2006. His educational background supports his extensive experience in database normalization and de-normalization techniques, as well as proficiency in big data technologies, including creating PySpark programs and HiveQL queries.
Career Progression and Skills
Shiva's career includes roles at Barnes & Noble, Inc. as a Senior Oracle Consultant from 2015 to 2017, and at TCS as an Information Technology Analyst from 2008 to 2011. He has developed strong skills in scheduling and managing UNIX cronjobs and Oracle Scheduler jobs, indicating his capabilities in automation and task management.