We provide IT Staff Augmentation Services!

Oracle Pl/sql Application Developer Resume

3.00/5 (Submit Your Rating)

SUMMARY:

  • Oracle PL/SQL Developer with almost 5 years of extensive experience in analysis, designing, developing, implementing and maintaining database applications and solutions, primarily using Oracle database technologies.
  • Expert in writing efficient SQL and PL/SQL code (Stored Procedure, Functions, Triggers, Autonomous Transactions and Packages) on TOAD to analyze very large data sets.
  • Expert data integration. Import export from raw data file to database and database to dat/txt/csv file.
  • Hands - on experience using Oracle tools like SQL *PLUS, SQL Developer, PL/SQL Developer and TOAD in many development projects.
  • Good knowledge on Pro*C coding.
  • Complete understanding of Oracle architecture including SGA(Database Buffers, Redo Log Buffers, Shared Pool) Log writer, Achiever, PMON, SMON, PGA, Listener services, Data dictionary Views
  • Expertise in system integrations and client interactions in preparing functional designs.
  • Experience on Oracle Collections and Oracle Partitioning.
  • Expertise with Oracle Analytic functions.
  • Good knowledge on performance tuning activities.
  • Expertise with concepts of referential integrity and constraints.
  • Experience in working on Regular Expressions.
  • Excellent Analytical skills to understand the business process and Functionality, Requirements and to translate them to system requirement specifications.
  • Experience in working on SQL Loader.
  • Extensive experience in Performance Tuning (both SQL Tuning and PL/SQL Tuning) using TKPROF, SQL TRACE, TIMED STATISTICS & Explain Plans, DBMS PROFILER.
  • Good knowledge with Unix Shell Scripting.
  • Good knowledge of Data Modeling and creation of Entity Relationships Diagrams.
  • Knowledge of Data warehouse and ETL.
  • Expertise in requirements gathering, software requirements specifications, systems development, testing (unit, performance), reporting, application maintenance, application / production support.
  • Good domain knowledge of Banking, Retail and Financial institutions.
  • Excellent documentation and presentation skills, great verbal and written communication skills
  • Analytical thinker, quick learner and proficient problem-solver who envisions business and technical perspectives to develop workable solutions.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i

Languages: SQL, PL/SQL, HTML, PRO*C, UNIX Shell Scripts

Tools: SQL Loader, Import/Export, Oracle Developer Suite. SQL * Plus, Toad,WinSCP,Putty

Repositories: VSS,Clear case(Version Controlling tools)

Reporting Tools: Business Objects (Crystal Reports)

Operating Systems: UNIX, Linux, Windows 2000/XP/NT

Productivity Applications: MS Office, Edit plus, Visio, Visual Studio, .NET

PROFESSIONAL EXPERIENCE:

Confidential

Oracle PL/SQL Application Developer

Responsibilities:

  • Creating complete end-to-end software solutions by developing, testing, rolling out and supporting systems, reports and services
  • Worked on design/ development of Customer Integration system.
  • Developing program specs based on Functional specifications.
  • Wrote procedures to import raw data into oracle database instead of using SQL*Loader.
  • Wrote procedures to extract data into excel/csv/dat/txt format for interfacing.
  • Wrote procedures to identify possible duplicate to staging table.
  • Wrote procedures to load data from different tables for mapping table.
  • Created the role level security for database and tables.
  • Modified existing forms and reports, designed new forms and reports as per business requirement.
  • Extensively used of PL/SQL Stored Procedures, Functions, Triggers, Cursors and Packages
  • Creating SQL, PL/SQL database objects.
  • Wrote Views, PL/SQL packages, procedures and function for processing business logic in the database.
  • Developed and modified a number of SQL, PL/SQL, stored procedures, functions, packages and reports.
  • Responsible for following up bugs reported by various users and suggesting possible patches to be applied.
  • Enhanced the performance of legacy PL/SQL packages by using Oracle 10g new features like FORALL and BULK COLLECT.
  • Written the Interface Stored Procedures for Data Transformation
  • Used PL/SQL developer tools for faster application design and developments
  • Developed procedures using Dynamic SQL, UTL FILE.
  • Involved in Testing (Both Unit and Integration Level) and Implementation.
  • Tested the entire application in testing environment and exported to Production.
  • Wrote PL/SQL packages, procedures, triggers and function for processing business logic in the database.
  • Developed and modified a number of SQL, PL/SQL, stored procedures, functions, packages and reports.
  • Involved in Designing of Data Modeling the, Design Specifications and to analyze Dependencies.
  • Responsible for creating and maintaining the packages, stored procedures, triggers functions and cursors.
  • Involved in Unit level testing, Module level testing and System testing.
  • Involved in preparing functional specifications, release notes, & documentation using MS-Office.

Technologies: Oracle10g/11g(SQL*PLUS,PL/SQL),MS-Office,SQL*Loader,TOAD,Windows,ClearCase, WinSCP,Putty, Development, Testing and Production environment, Windows, UNIX, Visio

Confidential

Oracle PL/SQL Application Developer

Responsibilities:

  • Creating SQL, PL/SQL database objects.
  • Involved in data maintenance for static tables.
  • Involved in preparing test datas for testing.
  • Worked on checking log files on UNIX while working on support for production environment.
  • Worked in SQL Loader for loading data from various sources like flat file, excel etc. into tables.
  • Involved in developing PRO*C batch programs.
  • Attending client meeting to discuss functional design for conversion programs.
  • Worked Extensively on Oracle Analytical functions like partition over by, rank, dense rank, lead, lag.
  • Created database tables, indexes and partitioned existing tables.
  • Worked on Bulk loader utilities like Sql loader for moving data from external files into the Oracle database.
  • Extensively used of PL/SQL Stored Procedures, Functions, Triggers, Cursors and Packages
  • Worked Extensively on Collections (Varrays, Associative arrays and Nested tables).
  • Created database tables, indexes and partitioned existing tables.
  • Performed unit, system and Integration testing.
  • Developed FTP process to extract data from Flat files received from various systems.
  • Used PL/SQL developer tools for faster application design and developments
  • Developed procedures using Dynamic SQL, UTL FILE.
  • Involved in Testing (Both Unit and Integration Level) and Implementation.
  • Tested the entire application in testing environment and exported to Production.
  • Done the documentation and provided on-site production support.

Technologies: Oracle 9i, PL/SQL, Pro *C, SQL Plus,Visual Source Safe,Pl/Sql developer,Toad,Putty, Windows 2000 and UNIX

We'd love your feedback!