We provide IT Staff Augmentation Services!

Sql Developer Resume Profile

2.00/5 (Submit Your Rating)

Skills

Add or delete rows as necessary.

Skill
  • Oracle10g
  • Oracle Forms 9i
  • Oracle Reports
  • PL/SQL
  • TOAD
  • Change Management Software, preferably Subversion
  • Excellent written and oral communication skills
  • Oracle11g

Employment History

Confidential

Oracle Developer/Programmer

Responsibilities:

  • Involved in creating database objects like tables, views, procedures, functions and packages using Oracle.
  • Improved performance using bulk collect and external tables on the Enterprise Data Warehouse.
  • Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
  • Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plan and Trace sessions for Cost based optimization.
  • Written complex SQLs using joins, sub queries and correlated sub queries.
  • Handled errors using system defined exceptions and user defined exceptions.
  • Loaded the data into database tables using SQL loader from text and excel files.
  • Thrived data model, SQL Queries, SQL Query tuning process and Schemas.
  • Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
  • Thrived SQL scripts, packages, procedures, cursors, tables, views, materialized views and functions as per the business requirements.
  • Worked with Oracle forms 9i and reports 9i.
  • Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
  • Requirement gathering, analysis, design, preferably Subversion, development, testing, implementation, production support, and change management.
  • Data loaded from legacy systems ETL Operations using PL/SQL and SQL Loader.
  • Involved in creating INDEXES to avoid the need for large-table, full-table scans and disk sorts, and for fast retrieval of data from database objects.
  • Tuned the PL/SQL Queries and Stored procedures for better Performance.
  • Optimized the performance of queries by Data Manipulations which includes modifications in PL/SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins and created indexes wherever necessary.

Environment: Oracle10g 11g, PL/SQL, SQL Server, Toad, UNIX, SQL Navigator 6.4, Windows XP.

Confidential

Responsibilities:

  • Interacted with the Business Analysts in understanding the business requirements for the project.
  • Gathered the requirements from the users and analyzed their business needs and created SRS documents.
  • Involved in SDLC including designing, coding and testing.
  • Collaborated with Data Warehouse Architecture in writing PL/SQL scripts, shell programs, and Data Flows.
  • Created database objects like tables, views, procedures, packages using Oracle tools like SQL Plus, PL/SQL and TOAD.
  • Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using SQL Loader.
  • Requirement gathering, analysis, design, preferably Subversion, development, testing, implementation, production support, and change management.
  • Involved in validating the data while data migration by creating PL/SQL Packages, Procedures, Functions, Triggers.
  • Designed and Developed physical and logical database schemas using ERWIN.
  • Worked on performance tuning and used Explain Plan, TKPROF and SQL trace for tuning the queries.
  • Worked with Oracle forms 9i and reports 9i.
  • Created Indexes for faster retrieval of the customer information and enhance the database performance.
  • Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
  • Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
  • Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
  • Handled Exception extensively for the ease of debugging and displaying the error messages in the application.
  • Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.

Environment: Oracle 10g/11g, PL/SQL, Informatica 8.6, DB2, SQL Navigator, UNIX, Windows XP.

Confidential

Oracle PL/SQL Programmer/Developer

Responsibilities:

  • Analyzed the Functional Specs provided by the Architect and created Technical Specs documents for all the mappings.
  • Worked as part of the development team, along with the Systems Analysts/Business Analysts.
  • Analyzed and fixed the data discrepancies between various systems and identified bad data caused due the data migration from various legacy systems.
  • Created PL/SQL Stored Procedures, Functions, Packages, and Triggers extensively used Cursors, REF cursors, User-defined object types, Records, in PL/SQL programming
  • Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects Ref Cursors to improve performance.
  • Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
  • Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER
  • Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and achieve better performance
  • Improved performance by creating Unique and Range Indexes based on the cost returned by EXPLAIN PLAN.
  • Worked with Oracle forms 6i and reports 6i.
  • Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through triggers
  • Effectively used Triggers to track the user profile updates and to send the messages to downstream systems
  • Extensively used Oracle Data Warehousing features such as Materialized views, Bitmap Indexes, Index Organized tables, external tables etc. and DB links for remote instances to retrieve data from other databases
  • Worked with DBA in making enhancements to physical DB schema and coordinated with DBA in creating and managing Tables, indexes, table spaces, synonyms, DB links and privileges.

Environment: Oracle 10g/11g/9i, PL/SQL, SQL Server, Informatica 8.5, Cognos, UNIX Shell Scripting, Toad, ER-Win, Windows XP.

Confidential

Sr. Oracle PL/SQL Developer/Programmer

Responsibilities:

  • Analyzed business requirements and coordinated with the business analyst to develop ETL procedures that confirm to the enterprise standards while maintaining consistency across all applications and systems.
  • Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards. Developed Unit Test Plans.
  • Requirement gathering, analysis, design, preferably Subversion, development, testing, implementation, production support, and change management.
  • Prepared Business Requirement Specification that gives the comprehensive details about the requirements.
  • Developed / modified Oracle PL/SQL codes like stored Procedures, Functions, Triggers etc. based on technical and functional specification documents. Used Sub-queries, Merge statements and Joins extensively in stored procedures.
  • Developed / modified scripts to create tables, views and executed them using SQL Plus.
  • Created SQL Loader control files for moving the data from Flat Files to staging area tables.
  • Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process and Oracle Objects including Collections, Types and creating objects.
  • Prepared the procedures to update the internal structures to reflect the newly loaded data.
  • Used batch scripts to loop from database to database, to perform system-wide functions.
  • Worked under the supervision of a DBA and created database objects such as tables, views, sequences, synonyms, and table/column constraints, indexes for enhancement.

Environment: Oracle 10g/11g/9i, TOAD, SQL Navigator, Erwin, Sybase, UNIX Shell Scripting.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Actively involved in interacting with front end Java developers, and gathered User Requirement and Online System Specification.
  • Created new logical and physical database design to support multiyear conferences for the tables of employees, histories, skills, experience and payroll.
  • Extensively used Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, and user defined data types and functions in SQL Server.
  • Normalized to 3NF to acquire least data repetition required by business.
  • Filtered bad data from legacy system using various PL/SQL, and implemented constraints and triggers into new system for data consistency
  • Worked with Oracle forms 9i and reports 9i
  • Created stored procedures and functions to support efficient data storage and manipulation
  • Reallocated/created database objects on appropriate File groups to ease maintenance and improve data access performance.
  • Implemented security by creating User logins, Roles and granting Users access to the database according to their role.
  • Requirement gathering, analysis, design, preferably Subversion, development, testing, implementation, production support, and change management.
  • Designed numerous ad-hoc and custom reports using SQL Reporting Services for clients, HR, agents.
  • Documented the database objects, procedures, functions for future references and maintenance.

Environment: Oracle 10g 11g, SQL Server 2000/2005, PL/SQL, Visio, Windows XP.

Confidential

Oracle Programmer

Responsibilities:

  • Analyzed the flow of the supplication in reverse engineered the application to oracle.
  • Analyzed the business requirements and Oracle database architecture Erwin , translated these business requirements into functional specification and built a workload report application to summarize employees' workload upgrade Accounting, Human resources, Database, and Performance tuning.
  • Wrote several stored procedures/Triggers in Oracle PL/SQL for the Enterprise Portal Application and data merge.
  • Worked extensively on various kinds of queries such as Sub-Queries, Correlated Sub-Queries, Dynamic SQL and Union Queries and concentrated much on Query tuning.
  • Worked on data migration from SQL Server to Oracle 9i.
  • Involved in daily, weekly and Monthly load of data from Mainframe data set to Oracle database.
  • Worked on Very Large Database Environment in terabytes, and tuned queries for performance.
  • Extensively used ETL to load data from various flat files which involved both fixed width as well as delimited files.
  • Developed and maintained lot of batch scripts in UNIX shell scripts, like scheduled data loading, Create, databases, Tuning and backup and Recovery.

Environment: Oracle 8i,SQL Server 2000/2005, Erwin, PL/SQL, Visio, Windows XP, SQL Plus, PL/SQL, SQL Loader, Unix, TOAD

We'd love your feedback!