Prudvi Alla

Assistant Consultant (Application Technical Consultant Team Lead) @Tata Consultancy Services

Hyderabad, IN

Assistant Consultant /Application Technical Consultant/Team Lead Apr 22 – Till DateTCS, Hyderabad, India• Working as Technical Lead and coordinating with the off-shore team in understanding the business requirements and delivering the deliverables to the business users.• Developed PL/SQL triggers and master tables for automatic creation of primary keys.• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.• Implemented CQN’s for transferring data from one environment to another environment.• Implemented JSON and XML attributes according to the application requirements.• Created Virtual columns, Json Indexes, Triggers and Jobs as per client requirements. • Involved in the continuous enhancements and fixing of production problems.• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.• Created indexes on the tables for faster retrieval of the data to enhance database performance.• Optimized Tableau data sources and reports, reducing query times by 50% and improving overall server performance by 30%.• Developed and implemented a new Tableau dashboard for sales team.• Developed interactive visualizations and dashboards in Tableau to provide insights into data.• Designed and developed Tableau workbooks to support business objectives.Solution Environment: Oracle 19c, Oracle PL/SQL, Oracle SQL, WinSCP, github, Toad, Tableau Server.

D J R College of Engineering & Technology, DJR Nagar, N.H.5, Velpur (V), Via Gudavalli, Vijayawada, PIN- 521 104(CC-7K)

Master's degree

VRS & YRN College of Engineering & Technology, Vodarevu Road, Chirala(M)-523157(CC-L1)

Bachelor's degree