We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume Profile

5.00/5 (Submit Your Rating)

Irving, TX

SUMMARY:

  • Over 8 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling Logical and Physical , and Implementation of Business Applications using the Oracle Relational Database Management Systems.
  • Extensively worked in Client-Server application development using Oracle 11g/10g/9i, SQL SERVER CE, FORMS 10g/6i, REPORTS 10g/6i, Oracle Import/Export Utilities.
  • Experience in PL/SQL programming developing packages, stored procedures, triggers and functions in Oracle database.
  • Extensive experience with various states of Software Development Life Cycle, including requirements gathering amp analysis, development, unit testing, QA testing, production migration, and production support.
  • Extensively involved in Oracle SQL, PL/SQL tuning in OLTP and DWH applications using STATSPACK, Explain Plan, TKPROF.
  • Experience with Data Modeling using ERWIN 4.0/3.5.2, SQLServer, MSAccess, SQL, PL/SQL, SQL Plus, Toad, and MS SQL Server, Query Analyzer.
  • Proficient in PL/SQL programming Stored Procedures, Functions and Packages, SQL tuning, and creation of Oracle Objects Tables, Views, Materialized Views, Triggers.
  • Experience of work in AGILE development environment by making customer satisfied by rapid delivery of useful software and welcoming changing requirements, even late in development.
  • Hands-on experience with Oracle Reports, SQL, PL/SQL, Open Interfaces, and APIs.
  • Good Understanding of GUI using JavaScript, HTML, DHTML, XML,COLD FUSION 8.0
  • Used Advanced PLSQL concepts, PL/SQL tables and Dynamic SQL for DML operations for better performance.
  • Extensively worked on the Extraction, Transformation and Load ETL process using PL/SQL to populate the tables in database using DB Links.
  • Strong Data Cleansing experience using PL/SQL, SQL Coding, and UNIX Shell Scripting.
  • Proficient in Oracle Tools and Utilities such as SQL Loader, Import/Export, TKPROF and SQL Navigator v.4.5.
  • Experience with DBA activities like creating Tablespace, granting and revoking privileges on database objects.
  • Hands on extracting source data and loading it into target using INFORMATICA.
  • Expertise in Tuning of Procedures, Oracle Reports developer Oracle developer suite 10g/AS
  • Expertise in Database Performance Tuning and Optimization of SQL statements using Oracle Hints, Explain plan, Tkprof, SQL Trace and Table partitioning.
  • Identified several SQL and PL/SQL bottlenecks using PL/SQL Profiler package DBMS PROFILER , explain plan, auto trace.
  • Participated in collecting the requirements, analyzing the System Requirements.
  • Proficient in Microsoft Office Suite to include PowerPoint, Visio, Project, SharePoint and Access
  • Experience in Installing Software's and Configuring Databases.

TECHNICAL SKILLS:

Databases: Oracle 10g, 9i, 8i, SQL server 2000/2005.

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

Tools/Utilities: SQL Plus, SQL Loader, SVN, Telerik WebUI test studio, SoapUI, QTP, CodedUI, Bugzilla, MS Office, MS Excel

Languages: SQL, PL/SQL, MYSQL, PHP, JAVA, UNIX Shell Script,

Database/Development tools: TOAD, SQL Plus, SQL Loader, Work-flow, SQL Navigator. D2K Forms amp Reports Builder 6i/10g

Case Tools: Rational Rose

Scripting/markup languages: UML, HTML, JavaScript, XML

GUI: Oracle Pl/SQL Developer Suite, Reports 9/10

PROFESSIONAL SUMMARY:

Confidential

Role: Oracle PL/SQL Developer

Environment: Oracle9i/10g, TOAD, SQL Loader, Windows XP, UNIX, Erwin.

Responsibilities:

  • Understanding Account Aggregation and Asset Classification, Bonds, Stock, Mutual Funds and other financial domain terminology.
  • DesignedTechnical Design Documents based on business requirements and followed standards designed by the company.
  • Involved in the design and implementation of the process for loading the monthly loads coming from S P into staging tables in the Oracle Database using Shell scripts.
  • Developed packages for processing data in the staging tables according to the Clients requirements
  • Wrote Packages, Stored procedures and functions for accessing, inserting, modifying and deleting data in the database from GUI.
  • Used Refcursors and Collections 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.
  • Optimized existing queries for better performance and less impact on database.
  • Used Materialized views in places where the data does not change very frequently.
  • Created various UNIX Shell Scripts for scheduling and loading process.
  • Maintained the batch processes using Unix Shell Scripts.
  • Validated customer credits and adjustments by writing procedures.
  • Identified undefined accounts, invalid transaction and handled them through exceptions.
  • Extracted source data and loaded into target after applying required transformation using INFORMATICA.
  • Worked on workflow creation and verifying records through INFORMATICA

Confidential

Role: Oracle PL/SQL Developer

Environment: Oracle10g, Oracle FORMS/REPORTS 10g , Designer10g,APEX 4.1, TOAD, Oracle ApplicationServer 9i and UNIX Shell Scripting.

Responsibilities:

  • Developed PL/SQL Packages, Procedures and Functions for Various Extract Process run through UNIX Jobs.
  • Coded PL/SQL Packages and Procedures using Bulk Binding, for all Statements, Dynamic SQL and Cursor Variables.
  • Tuned PL/SQL Packages and Procedure to manipulate large no of data using collections like nested tables and arrays.
  • Tuned Large Complex Queries and Improved Performance of PL/SQL procedures.
  • Created Schema Objects like Tables, Views, Materialized views, Sequences, Constraints, Indexes.
  • Developed and Deployed Traders Oracle REPORTS in Oracle Application Server 9i.
  • Generated Oracle FORMS and REPORTS using Designer 6i.
  • Designed and Developed Reports using Oracle Discoverer 9i.
  • Improved Performance of Discoverer Reports using Materialized views.
  • Developed UNIX Shell Scripts for Autonomous Jobs.
  • Experience in developing logical and physical database design, data modeling using Erwin.
  • Designed, Developed and Tested application in UAT environment and Deployed in Production.
  • Provided Productions supports and ongoing user supports for the application.
  • Used APEX 4.1 in building some of the data intensive websites.
  • Some of the common web applications used in the web browsers are done using APEX 4.1
  • Designed Development Documentation and Support Documentations.

Confidential

Roles: Oracle Pl/Sql Developer

Environment:Oracle 10g, SQL, PLSQL, SQL Loader, UNIX Shell script, TOAD, Oracle Forms 10g, Reports10g.

Responsibilities:

  • Created SQL Loader control files for loading the data from flat files to staging area tables.
  • Worked on designing and developing a data warehouse for providing business intelligence on the data gathered by the OLTP server.
  • Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
  • Involved in the Analysis, Design, Coding and Testing of the application.
  • Developed SQL scripts to create database objects like tables, views and sequences.
  • Used SQL Loader to load bulk data from various flat files.
  • Developed SQL and PL/ SQL scripts for migration of data between databases.
  • Designed and developed complex reports to meet end user requirements and deployed using Oracle Report 10g.
  • Tune SQL statements using hints for maximum efficiency and performance, create and maintain/modify PL/SQL packages, mentor others with the creation of complex SQL statements, perform data modeling and create/maintain and modify complex database triggers and data migration scripts.
  • Developed complex triggers in reports before/after for validation of user input.
  • Designed and developed user interfaces using Oracle Forms 10g.
  • Involved in logical and physical database design, Identified Fact Tables, Transaction Tables.
  • Proactively tuned SQL queries and performed refinement of the database design to leading significant improvement of system response time and efficiency.
  • Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN, DBMS PROFILER, etc.
  • Developed UNIX shell scripts in VI Editor with embedded SQL Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
  • Created Bitmap indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
  • Design and development of conversions, interfaces, customizations, Custom Forms, Reports and all Technical design and solutions.
  • Implemented Application Infrastructure policies, procedures and standards, and ensured their continual compliance.

Confidential

Role: PL/SQL Developer

Environment: Windows XP, Oracle 9i, UNIX shell scripting, SQL Plus, SQL Developer, Java, JDK, JSP, JMS,JDBC, HTML, XML.

Responsibilities:

  • Analyzed database design requests and Created databases according to client needs
  • Developed PL/ SQL modules such as Packages, Triggers, Procedures and Functions.
  • Heavily involved in Performance Tuning at the application level.
  • Developed Front end using SERVLETS, JSCRIPT and HTML
  • Developed the backend using Servlets, Java Beans and JDBC.
  • JMS messaging method is used for communication between software applications
  • Extensively utilized XML and SOAP for the data transfer between web clients and server
  • Developed UNIX Shell scripts that will interact with the PL/ SQL Objects.
  • Documented and performed unit testing for all components prior to migrating them to production.
  • Maintained existing applications.

We'd love your feedback!