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.

• 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.

• 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.

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