We provide IT Staff Augmentation Services!

Sql Developer Resume Profile

5.00/5 (Submit Your Rating)

SUMMARY OF QUALIFICATION

  • Eight plus years of IT experience as an Oracle developer, PL/SQL developer, System Analysis, Design ,Development Support of Oracle Database 9i,10g and 11g in Production, Staging, Development environments.
  • Proficient working experience with SQL, PL/SQL, Stored Procedures, Functions, Packages, DB Triggers and using the latest features to optimize performance Bulk Binds, Inline views, Global Temporary Tables, Flashback .
  • Extensive Experience with Oracle tools like SQL, PL/SQL, SQL PLUS, Oracle Enterprise Manager, SQL Developer, Oracle9i/10g Developers suite Reports.
  • Proficient in advance features of Oracle 9i for PL/SQL programming like Using cursor variables, Ref. cursors, varrays, nested tables and Dynamic SQL.
  • Excellent experience with performance tuning, normalization and denormalization, partitioning of data and indexing of partitioned tables.
  • Experience in application fine-tuning and database fine-tuning using Explain Plan, SQL Trace and TKPROF.
  • Experience in working high transacted OLTP systems.
  • Strong experience with Oracle utilities like SQL Loader, Export/Import and data pump utilities like EXPDP/IMPDP.
  • Well Versed with Crystal Reports 8.5/10/11 and using TOAD 8.5/8.6/9 in secure databases.
  • Extensive knowledge of using DBMS Oracle supplied package like UTL FILE, DBMS JOBS and DBMS SCHEDULER.
  • Expert in UNIX Shell scripting Bourne, Korn .
  • Hands on experience with Crontab in UNIX environment for scheduling routine tasks.
  • Extensive experience with all phases of the Software Development Life Cycle including analysis, Physical and Logical design, Resource Planning, code development, testing, implementing and maintenance.
  • Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
  • Knowledge of Relational Database Management System RDBMS .
  • Clear communication and documentation of technical specifications.
  • Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. Strong interpersonal and communication skills in dealing with customers.
  • Expert Skills in time management, prioritizing tasks.

TECHNICAL SKILLS

Databases

Oracle 11g,Oracle 10g,Oracle 9i, MS-Access, MySQL, MS SQL Server

Environment

UNIX Sun Solaris, HP-UX, AIX , Windows NT/2003/2000/XP/98

Utilities

SQL Loader, Export / Import, Expdp / Impdp, Explain Plan, Oracle Wrap, FTP,SFTP, Cute FTP

Languages/

Editor

SQL, PL/SQL, Shell Programming, C, HTML, XML, Vi Editor.

Tools

Oracle Form Builder, Advance Query Tool AQT , TOAD 9.5/8.5, Oracle Enterprise Manager, Putty, AutoSys, PL/SQL Developer 7, Oracle Developer 2000/ Oracle Developer Suite 10g, SQL Loader, iSQL Plus, ERWIN 4.14/4.0, Dreamweaver, MS-FrontPage, MS Office Suite, Oracle JDeveloper 10.1.3.3, Crystal reports 8.5

Operating Systems

UNIX, Linux, Sun Solaris 5.8, 5.9, HP-UX, IBM AIX 5.2/5.3 Windows NT, Windows NT/20X/9X, Windows XP, Windows Server 2003

Project Management:

Microsoft Office Project, Excel, PowerPoint

PROFESSIONAL EXPERIENCE

Confidential

Application Developer

Responsibilities:

  • Involved in Analyzing a system, creating Design Documents, Coding, Development, Unit testing and Implementation.
  • Creating and enhancing Oracle database objects, develop Pl/Sql packages/procedures and forms/Reports, perform application tuning using Oracle tools and utilities.
  • Created new forms, modified existing forms for the user to use as a front end of application
  • Created tables, Functions, Triggers, procedures for different projects.
  • Creating and monitoring CA Workload/Autosys control center jobs used for automation of various processes.
  • Providing efficient solutions by developing documentation, flowcharts, layouts, diagrams etc.
  • Extending support to the production environment in providing solutions to issues there by reducing the impact.
  • Utilizing knowledge of scripting languages which provide access to UNIX, Linux systems.
  • Performing technology upgrades to enhance the performance of the applications. .
  • The Skillset required to perform the job duties include expertise in Oracle Pl/Sql, Oracle forms 10g/11g,
  • Oracle Reports 10g/11g, Linux, Pro C along with few other Financial Insurance applications.
  • Upgraded the oracle database from 10g to 11g and also changed the platform from HP to AIX and then Linux.

Environment: TOAD 8.5, Oracle Forms Builder 11g, Oracle Reports Builder 11g, Putty, AutoSys, PL/SQL Developer 9, SQL Plus, MS Office Suite, Oracle JDeveloper 10.1.3.3, Crystal reports 8.5

Confidential

Oracle PL/SQL Report Developer

Responsibilities:

  • Involved in Coding, Data conversion, Development and Implementation.
  • Created SQL codes to generate the reports according to requirement of the front users.
  • Created tables, Functions, Triggers, procedures for generating some complex reports.
  • Encrypted the PL/SQL code using wrappers.
  • Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.
  • Involved in writing test cases to ensure that requirements are met in the developed application.
  • Created Korn Shell scripts for automating tasks.
  • Performance tuning of the application programs using EXPLAIN PLAN and SQL TRACE.
  • Used the rollup and cube operators to generate summaries.

Environment: Oracle 11g/9i, Advance Query Tool, SQL Developer, SQL PLUS, SQL, PL/SQL, UNIX, Windows XP, Oracle Reports, MS Office 2010.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
  • Loading of customer data from flat files using SQL loader.
  • Created tables, Functions, Triggers, procedures and packages for implementing complex database intensive business rules.
  • Encrypted the PL/SQL code using wrappers.
  • Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.
  • Involved in writing test cases to ensure that requirements are met in the developed application.
  • Created Korn Shell scripts, Bourne Shell Scripts and Bash Shell for automating tasks as well as for creating extracts.
  • Performance tuning of the application programs using EXPLAIN PLAN and SQL TRACE.
  • Used the rollup and cube operators to generate summaries.
  • Created SQL codes to generate the reports according to requirement of the front users.

Environment: Oracle 10g/11g, Solaris 5.8, UNIX, Windows XP, PL/SQL, SQL PLUS,

Oracle Reports, SQL Developer.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Analyzed of customer specifications and custom design of applications successfully and
  • implementing designs in new/existing application using PL/SQL.
  • Developed PL/SQL-Packages, SQL Scripts and Database Triggers to populate the historic data in the tables applying business logic.
  • Used to extract data from external source s and transform and load into data warehouse.
  • Developed database objects like tables, views, indexes, triggers, stored procedures.
  • Used SQL Loader scripts to load the flat files into the Oracle Database.
  • Performed application SQL Tuning using SQL Trace Explain plan for better performance.
  • Created various simple and complex by joining more than two tables views.
  • Involved in coding and designing of the Transaction Module using PL/SQL Procedure.
  • Used various SQL Expressions and Conditions in standalone procedures and functions.
  • Used File Transfer Protocol FTP tool to transfer files from one server to other.
  • Implemented Export/Import Oracle utilities to move data to different testing environments.
  • Developed Oracle Reports to displayed sales margins for daily, weekly, monthly, and
  • quarterly totals along with detailed inventory information.
  • Worked on Unix Shell Scripting for Scheduling Batch Jobs using Crontab.
  • Wrote complex SQL scripts and was responsible for Performance tuning of SQL Queries.

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL PLUS, Informatica, TOAD, UNIX

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Gathered the requirement from different clients and translated user requirements
  • into data flows, detail technical specifications and database requirement.
  • Created stored procedures, packages, triggers.
  • Used Wrappers for code security.
  • Used cursors, exception handling methods along with pragma exception init in
  • order to associate our own created exception names.
  • Monitored indexes and analyzed their status for performance tuning and query optimization.
  • Created the Temp tables in the stored procedure for different applications.
  • Automation of process to keep the systems up to date and to reduce manual errors by developing shell scripts and using CRONTAB in UNIX.
  • Involved in Performance Tuning for the SQL, PL/SQL scripts using EXPLAIN PLAN, HINTS to tune queries for better performance and also extensive Usage of Indexes.
  • Loaded data from flat files into Database using SQL loader.
  • Created UNIX scripts for automated process.
  • Used DBMS JOBS package for job scheduling.

Environment: Oracle 10g, Solaris 5.8, UNIX, Windows XP, SQL Developer, Crystal

Reports.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Good understanding on high level business scenario of the company's financial functional structure.
  • Created SQL codes to generate the reports according to requirement of the front users.
  • Created tables, Functions, Triggers, procedures for generating some complex reports.
  • Involved in the development of database objects.
  • Involved in Oracle User creation assigning Roles Privileges.
  • Writing Tuned SQL queries for data retrieval involving complex join conditions.
  • Wrote stored procedures, functions, Packages, Triggers.
  • Involved in writing cursors and handling exceptions.
  • Used Import/Export utilities of Oracle.
  • Created and managed primary data base objects such as Tables, Views, Indexes, Sequences and Synonyms.
  • Preparation of Pre and Post test cases.
  • Unit testing of developed components.

Environment: Oracle 10g/9i, MS Access, SQL/PL SQL, UNIX, Oracle Reports 6i Windows NT/98.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Involved in all the phases of System Development Life cycle.
  • Creation of storyboard.
  • Loading flat files using SQL Loader.
  • Used to extract data from external source s and transform and load into data warehouse.
  • Created various database objects like tables, views, indexes, triggers, sequences, synonyms.
  • Created PL/SQL procedures, functions, packages required for the application.
  • Writing the queries to get the data from different sources
  • Tuning application using tools like SQL Trace, Analyze, and Explain Plan.
  • Partitioning of tables for faster data retrieval.
  • Helped in the creation of summary tables.
  • Use of DBMS JOBS package to automate jobs.

Environment: Oracle 9i, Unix, MySql, Informatica, SQL, SQL Developer

We'd love your feedback!