We provide IT Staff Augmentation Services!

Sql Developer Resume Profile

2.00/5 (Submit Your Rating)

  • Over 8 years of experience in developing and implementing database applications and solutions as ORACLE PL/SQL DEVELOPER.
  • Excellent skills in designing and development of applications using Oracle 11g/10g/9i, SQL, PL/SQL, Oracle Forms 10g/9i/6i, Reports 10g/9i/6i, UNIX Shell Scripting.
  • Good knowledge on Oracle tools like SQL, PL/SQL, SQL PLUS and used TOAD in many development projects.
  • Highly proficient with Oracle applications development tools within a client/server environment.
  • Excellent SQL skills in designing and development of applications using Oracle 11g/10g/9i, SQL, PL/SQL, Shell Scripting.
  • Expertise in managing software implementation projects involving Client interactions, Requirements and Gap Analysis, Customization Enhancements, Testing, Documentation and On-time Delivery.
  • Expertise in creating Oracle objects like Tables, Synonyms, Triggers, Indexes, Views, Materialized Views and Table Partitions.
  • Proficient in advance features of Oracle for PL/SQL programming like using Cursor variables, Ref. cursors, Varrays, nested tables and Dynamic SQL.
  • Documentation included the preparation of High Level Design Documents, Low Level Design Documents during the Requirement Analysis phase. Post Development during the Testing phase included preparation of Unit Test Plans Capturing the Unit Test results.
  • Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing and Load Testing.
  • Experience in designing and development of Oracle Forms and Reports.
  • Experience in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, SQL Trace, Explain Plan, Bulk Collect feature, FORALL statements, and Troubleshooting Oracle database issues.
  • Worked in various levels of SDLC System Development Life Cycle which involves Analysis, Design, Development, Testing, Implementation and support with extensive exposure in database.
  • Possess excellent interpersonal, communication and analytical skills with demonstrated abilities in customer relationship management.

TECHNICAL SKILLS:

  • ributing a vast amount of reports for many banks.
  • Developing Oracle 9i/10g PL/SQL codes packages, stored procedures, functions and database triggers for data extraction, transformation and loading processes.
  • Writing PL/SQL codes using collections, bulking techniques and partition to increase performance and efficiency of already existing reports and various programs.
  • Developing databases for a vast number of client records, which required self-initiation and excellent time-management.
  • Using various Built-In PL/SQL packages based on requirements.
  • Set up export and import schema and wrote data conversion scripts using Oracle.
  • Involved in design, coding, test and document processes of LSBank5, LSBank6 and LSFinance projects under C Builder6 and Oracle backend development.
  • Received technical assignments and

WORK EXPERIENCE:

Confidential

Responsibilities:

  • Created many Generic Stored Procedures, Functions, Database Triggers, Packages, Tables, Indexes, Views, Synonyms, Sequences using SQL and PL/SQL.
  • Extensively used PL/SQL programming in back end and front end Functions, Procedures, and Packages to implement business logics/rules.
  • Extensively worked in Oracle SQL, PL/SQL, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms and Sequences.
  • Analyzed the system requirements and performed logical and physical design of the database.
  • Experience in performance Tuning using Explain plan and hints. Experience with Query Optimization procedures using SQL Advisors.
  • Used SQL Loader for data uploading from flat files. PL/SQL Coding and SQL tuning throughout the development wherever needed.
  • Experience in developing Dynamic SQL and Ref cursors and Hands-on experience in writing Packages, Stored procedures, Functions, and Database.
  • Created application schema as tables, view and indexes and customized the stored procedures and database triggers in PL/SQL.
  • Exception handling and cursor management in PL/SQL.
  • Involved in developing packages to transfer data from different Oracle forms to Oracle database, every time whenever processor do the transactions.
  • Involved in form level coding for Approval, Data Entry, Data Query and Response Modules as per the requirements.
  • Designed Conversion and Interface Programs using PL/SQL procedures and packages.
  • Analysis, Development, Testing and Implementation using Oracle 11g/10g.
  • Used Oracle Forms and Reports as GUI for Oracle Applications and development of high performance technical solutions to meet the challenging business demands to the clients.

Environment: Oracle 11g/10g , PL/SQL, Oracle Performance Tuning, Forms Reports 9i/6i, PL/SQL Developer, TOAD, Query Analyzer.

Confidential

  • Developed new PL/SQL Stored Procedures to load and pull the respective data for those Loans eligible to be processed based on various business criteria.
  • Developed new Packages to load eligible Vendor Order Request into the Target table based on various business criteria using the MERGE Statement.
  • Involved in writing DDL and DML operations.
  • Worked very closely with functional team to understand their Development related requirements.
  • Written complex SQL queries with complexity using Inner/Outer joins, Union All, Intersect Minus set operators.
  • Extensively used DBMS Scheduler package in order to schedule the refreshment of the Materialized Views on a periodic fashion.
  • Designed and developed several views like Materialized View for data retrieval for the reports.
  • Created a package to generate the Trace file for the Materialized View Groups using DBMS SUPPORT Package.
  • Responsible for Tuning of application with the help of Other Team Members Oracle Support.
  • Created Table structures along with Triggers, Indexes like Bitmap and Function based Indexes.
  • Tuned SQL queries to enhance performance, using the method Explain Plan both at backend and in Toad.
  • Created test scenarios for created code and distribute across to the QA along with Knowledge transfer.
  • Used Power Designer to read Data Models.
  • Extensively used TOAD tool to increase the productivity and application code quality.

Environment: Oracle 10g, SQL developer, PL/SQL, Windows 7

Confidential

Responsibilities:

  • Responsible for transforming the Business requirements into Functional specs and technical design documents.
  • Creating and maintaining database objects like Tables, Views, Indexes, Constraints, Sequences, Indexes, Triggers, grants and Synonyms.
  • Creating packages, stored procedures, and functions to meet the requirements. Maintaining and supporting all the database changes throughout the lifecycle.
  • Involved in various data conversions that are necessary for the application using PL/SQL advanced topics like Bulk Collect, For All.
  • Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN and DBMS PROFILER
  • Involved in writing appropriate Cursors, Ref cursors, Collections, Records for accessing complex data resulted from joining of large number of tables.
  • Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Worked with SQL loader, Created control file scripts to dump the data in to the mapping tables and process the data accordingly.
  • Worked with UTL FILE to write the files. Involved in generating new files, modifying or updating the existing files as needed and monitoring them if they are successful during.
  • Thoroughly involved in unit testing, creating unit test documents and involve in peer reviews, code reviews, follow ups and status updates to closely monitor the development throughout its life cycle.
  • Validating all the database changes with validation scripts when the changes are moved to different environments and supporting them.
  • Adapt to multiple roles by assisting business teams in Oracle, Java, power builder and mentoring team members.

Environment: Oracle 10g/11g, TOAD, PLSQL Developer, UNIX, Forms 10g, Reports 10g, Windows XP and SQL Plus.

Confidential

Responsibilities:

  • Design Technical Specifications from Functional Specification Detail Design documents.
  • Use SQL Loader/Perl Script to load data from various sources into an Oracle database.
  • Wrote PLSQL programs required to retrieve data from the Data repository using Cursors, UTL File I/O and Exception handling.
  • Wrote PL/SQL Packages, Functions and Procedures to implement the Business Logic.
  • Involved in Integration testing, System testing and Implementation.
  • Proficiently developed test cases in Quality Center.
  • Extensively developed complex PL/SQL packages for Pricing.
  • Written complex SQL using joins, sub-queries and correlated sub-queries.
  • Developed UNIX shell scripts to process file feeds.
  • Used debugger to test the mapping and fixed the bugs.
  • Applied Performance Tuning logic to optimize session performance.
  • Attended business user sessions to make changes in warehouse loads.
  • Involved in production support during deployment.
  • Developed shell scripts for batch processing and database transactions.
  • Tuning SQL Statements, PL/SQL Packages, Triggers, Functions and Procedures.
  • Application Testing and Documentation in the upgrade of Oracle 9i to 10g.
  • Involved in Database performance tuning using Explain plan.

Environment: Oracle 9i/10g, Oracle Application Server 10g, PL/SQL Developer, TOAD, MS-Windows Vista

Confidential

Responsibilities:

  • Written stored procedures and packages on ORACLE Database Server.
  • Involved in the production support and solved critical issues.
  • Loading the flat files using SQL loader into ORACLE tables.
  • Written SQL DDL, DML, DCL and database triggers.
  • Developed and maintained scalable data warehouse and business intelligence platforms/infrastructure.
  • Created indexes on tables for optimization.
  • Extensively used back-end procedure, SQL Queries, standard modules, and Database Triggers.
  • Extensively worked on cursors for manipulating row-by-row for oracle database.
  • Created the Materialized views for the base tables of other databases in order to avoid redundancy of data.
  • Entered the bugs into Quality Center and resolved based on priority.

Environment: SQL Server, Oracle 10g PL/SQL, SQL, Windows, Toad.

Confidential

Responsibilities:

  • Involved in Creation of tables, Join conditions, nested queries, views, sequences, synonyms for the business application development.
  • Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
  • Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.
  • Created dynamic SQL to support dynamic nature of front to end applications.
  • Utilized SQL Loader to perform bulk data loads into database tables from external data files.
  • Used DBMS Supplied packages like DBMS PROFILER, DBMS JOB, etc.
  • Used the Crontab in UNIX for Automatic Tasks like loading data into Tables, Importing and Exporting data.
  • Wrote complex queries to generate reports as per client request as a part of production support.

Environment: Oracle 9i, Windows XP, PL/SQL, SQL PLUS, SQL Developer, UNIX

Confidential

Responsibilities:

  • Designing, developing and distributing a vast amount of reports for many banks.
  • Developing Oracle 9i/10g PL/SQL codes packages, stored procedures, functions and database triggers for data extraction, transformation and loading processes.
  • Writing PL/SQL codes using collections, bulking techniques and partition to increase performance and efficiency of already existing reports and various programs.
  • Developing databases for a vast number of client records, which required self-initiation and excellent time-management.
  • Using various Built-In PL/SQL packages based on requirements.
  • Set up export and import schema and wrote data conversion scripts using Oracle.
  • Involved in design, coding, test and document processes of LSBank5, LSBank6 and LSFinance projects under C Builder6 and Oracle backend development.
  • Received technical assignments and developed the entire Deming Cycle for the appropriate departments of these Financial Establishments.

Environment: Oracle 9i, 10G, PL/SQL, C Builder6, Windows XP.

We'd love your feedback!