Jagadeesh Raju Konda

• I aspire to align myself with an organization that offers opportunities to share, contribute, and grow, by engaging in a challenging and quality-driven environment where knowledge and experience can be exchanged to enrich both personal growth and the development of the organization.
• 12+ years of experience in software development, maintenance, and enhancement. Hands-on experience with databases Oracle, SQL Server, and Sybase. Basic hands-on experience with PostgreSQL and Netezza databases. Proficient in operating systems Unix, Linux, and Windows. Extensive experience in developing and optimizing complex SQL queries, PL/SQL stored procedures, functions, views, cursors, packages, exception handling, and triggers. Hands-on experience with Azure Data Factory (ADF) and SSIS. Basic knowledge of Python scripting. Functional knowledge and experience in SCM (P2P and O2C). Knowledge of Oracle Apps manufacturing domain (Inventory, BOM, WIP, Purchase, OM). Experience in ADF for creating forms in Oracle Apps. Knowledge of RICE components and report development using XML Publisher in Oracle Apps. Conducted Oracle database and SQL code tuning to improve application performance using Bulk binds, in-line queries, dynamic SQL, analytics, and subqueries. Experience in SQL query performance tuning using tools like Autotrace, Explain Plan, TKProf, and Hints. Expertise in table partitioning and sub-partitioning to enhance performance. Applied knowledge of ER Diagrams, Normalization, Tuning & Optimization in database design. Experience with SQL
• Loader, Import/Export, and External tables for data migration. Sound knowledge of Oracle 12c/11g/10g/9i/8i, PL/SQL, and Sybase programming. Hands-on experience in scripting languages such as Shell scripting and Batch scripting. Strong understanding of automation using UNIX Shell scripting and SQL scripting. Knowledge of database administration, including table creation, maintenance, tablespaces, data files, and data loading. Familiarity with ETL tools like Informatica and Ab Initio. Hands-on experience with data warehouse appliances like Netezza. International exposure: Traveled twice to Japan for requirement gathering. Strong understanding of Software Development Life Cycle (SDLC). Experience in preparing test scripts and executing test cases.

Skilled technical lead successful at marrying technology and business needs in order to meet changing demands and solve diverse problems. Prepared to leverage several years of experience to take on new role with long-term potential and room for professional growth.

Oracle Certified Associate (OCA)

Nationality: Indian

• 12, Software development, maintenance, and enhancement, Databases: Oracle, SQL Server, Sybase, PostgreSQL, Netezza, Operating systems: Unix, Linux, Windows, SQL queries, PL/SQL stored procedures, functions, views, cursors, packages, exception handling, triggers, Azure Data Factory (ADF), SSIS, Python scripting, SCM (P2P and O2C), Oracle Apps manufacturing domain (Inventory, BOM, WIP, Purchase, OM), RICE components and report development using XML Publisher in Oracle Apps, SQL query performance tuning, Table partitioning and sub-partitioning, ER Diagrams, Normalization, Tuning & Optimization in database design, SQL
• Loader, Import/Export, External tables for data migration, Scripting languages: Shell scripting, Batch scripting, Database administration, ETL tools: Informatica, Ab Initio, Data warehouse appliances: Netezza, Software Development Life Cycle (SDLC), Test scripts preparation and execution