Santosh K Email & Phone Number

United States

Dallas, Texas, United States

• Gather requirements for change requests with the Business team and create design documents. • Create PL/SQL packages for implementing Change Requests for adding new functionality to the application.• Designed and implemented Extract, Transform, Load (ETL) processes using Oracle PL/SQL for efficient data extraction, transformation, and loading into the data warehouse.• Performed SQL and PL/SQL tuning using tools like EXPLAIN PLAN, SQL*TRACE, and AUTOTRACE. • Created and scheduled automated jobs using DBMS_JOB and DBMS_SCHEDULER to handle routine maintenance tasks and batch processing.• Experience in database design, normalization, and optimization to ensure efficient data retrieval and manipulation within APEX applications.• Extensive experience with Oracle REST Data Services (ORDS), providing RESTful web services for Oracle databases. • Developed and optimized RESTful APIs using ORDS to facilitate data access and integration with various systems.• Hands-on experience in Oracle Application Express (APEX), designing and developing web applications.• Proficient in parsing and manipulating JSON data structures using Python libraries such as JSON and pandas, enabling efficient extraction and transformation of data from APIs, web services, and other sources.• Proficient in leveraging pandas to extract data from various sources, including Oracle databases, and perform complex transformations to prepare data for analysis or reporting.• Skilled in integrating Python scripts with Oracle PL/SQL procedures/functions for enhanced data processing capabilities and automation of database tasks.• Integrated XML and JSON data types for seamless data exchange between Oracle databases and web applications.• Extended database functionality through custom scripts, stored procedures, and triggers, optimizing data storage and retrieval processes.• Used APEX components such as forms, reports, charts, and dashboards to create user interfaces.

• Write complex SQL queries with sub-queries, analytical functions, and inline views.• Performed senior-level responsibilities for the overall database architecture, design, installation, configuration, technical support, and maintenance of the Oracle 12c databases.• For the dynamic execution of SQL statements inside PL/SQL blocks, EXECUTE IMMEDIATE was used.• Retrieved user-specific data from PL/SQL blocks using SYS_CONTEXT.• SYS_REFCURSOR was used to implement and maintain complicated database processes, allowing PL/SQL programs to traverse and manipulate result sets more efficiently.• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.• Excellent skills in database Back Up, Restore, Recovery, updating statistics, Rebuilding and Reorganizing indexes, Defrag Tables, Replication, Linked Servers, and Database Maintenance Plan.• Create PL/SQL packages, standalone procedures, and standalone functions.• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.• Utilized GoldenGate replication technology during Oracle Upgrades• Developed and maintained custom applications in Oracle APEX, leveraging its low-code development capabilities. • Implemented interactive reports, forms, and charts in APEX to enhance data visualization and user experience.• Created and implemented a bespoke error and log module for OIC integrations and custom VBCS apps using ATP and PL/SQL for auditing and debugging.• Designed and developed drill-down and Drill through reports with Drop down menu option using SSRS.

• Performed senior-level responsibilities for the overall database architecture, design, installation, configuration, technical support, and maintenance of the Oracle databases.• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.• Performed logical and physical data structure designs and DDL generation to facilitate the implementation of database tables and columns out to the SQL Server, and Oracle DB schema environment.• Conducted physical asset audits, reconciling discrepancies, and ensuring accurate asset records. Implemented depreciation schedules and forecasting tools, enhancing financial planning accuracy.• Design and develop Oracle database applications using PL/SQL language.• Dynamic SQL was modified to manage variable filter conditions, column selections, and table names.• Involved in writing and maintaining many PL/SQL stored procedures and SQL queries for populating the historical and daily data in production using TOAD.

Hyderabad, Telangana, India

• Extensive Experience working with SSIS SQL Server 2008/R2.• Worked in Agile methodology to migrate into modern technology for Application re-architecture projects.• Performed daily backups and developed recovery procedures.• Responsible for design and development, testing, and implementation of database objects.• Developed a Conceptual model using Erwin based on requirements analysis.• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1• Authored various functional specification documents for data migrations, reporting & analyses, systems integrations, and customizations to standard packaged software.• Responsible for Coding/Changing numerous packages, procedures, and functions.• Use Dynamic SQL and Execute Immediate functionality to perform DDL in PL/SQL blocks and procedures.• Design, develop and maintain database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors, and other database objects.• Programming Skills in designing and implementation of multi-tier applications using Java, J2EE, JDBC, JSP, HTML, JavaScript, Servlets, CSS.• Developed Java Server Pages (JSP), PL/SQL Procedures and Functions to perform business transactions.