We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

0/5 (Submit Your Rating)

Charlotte, NC

SUMMARY

  • 7 Years of IT industry experience as a developer/analyst in multiple technologies and different roles.
  • Experience in Oracle Development.
  • Extensive experience in developing PL/SQL Procedures, Functions, Packages, Triggers.
  • Experience in Analysis of Query EXPLAIN PLANS and performance tune SQL SELECT Queries.
  • Experience using SQL * Plus editor for older oracle versions.
  • Possess good knowledge and fair amount of experience in other performance tuning concepts like EXTERNAL tables, partitions and Indexes.
  • Possess good Logical /Physical database design principles and Normalization concepts.
  • Experience working with OLAP functions.
  • Experience in JAVA and C Programming languages with good Procedural and Object Oriented Analysis Skills.
  • Experience in web technologies like XML, HTML5.0 and Java Script.
  • Experience in Data Warehouse Environments and related technologies.
  • Experience in Requirements capturing, System analysis, Logical and Physical data modeling, Development and Implementation of software applications.
  • Experience working in OLTP and Data warehouse Environments.
  • Experience in using SQL server Management Studio
  • Proven experience using Oracle 8i/9i/10g/11g, Oracle forms and reports 9i/10g/11g, SQL, PL/SQL, SQL* Plus.
  • Experience in advanced PL/SQL concepts like BULK COLLECT, BULK LOAD and FOR - ALL.
  • Experience in creating and working with CTE for the implementation of Recursive and Hierarchical queries in T-SQL/ORACLE.
  • Experience writing JAVA test cases using testing API’s like JUnit, Apache Camel test kit.
  • Experience using version control software’s like CVS and SVN.
  • Solid understanding of data structures and algorithms using C/JAVA
  • Possess excellent oral/written communication and interpersonal skills.
  • Good ability to quickly grasp and master new concepts and technologies.
  • Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.

TECHNICAL SKILLS

Roles and Responsibilities: SQL, PL/SQL Developer, Java Developer

Platforms: Windows NT/2002/2007, UNIX

Databases: Oracle 8i/9i/10g/11g, SQL Server 2005/2008

Programming Languages: C/C++, T-SQL, SQL, PL/SQL, UNIX and SHELL Scripting, J2SE, J2EE (Servlets & JSP), HTML, PHP, C#.Net

Development/Productivity Tools: SQL*Plus Editor, Microsoft Management Studio, Oracle Developer, TOAD, iSQL*Plus,, Visual Studio 2008, TURBO C++ IDE,ANT, Informatica, Eclipse, Struts, Spring, WebServices - SOAP, REST Services

Application Packages: MS Word, MS EXCEL, MS Outlook Express, MS One Notebook

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Oracle PL/SQL Developer

Responsibilities:

  • Analysis of different layers of the legacy transaction server code in C.
  • Conversion of the transaction server code to new open source architecture frame work built using JAVA and other open source technologies
  • Testing, building and deployment of applications in development environment.
  • Prepare documents based on the analysis for the business flows under conversion for future and development purpose.
  • Publish transaction messages, check message queues and compare the data processing on both legacy and modern servers as part of the integration testing.
  • Developed Materialized Views and partitioning tables for performance reasons.
  • Designed and developed forms for the application using Oracle forms
  • Developed reports for the client with the help of Oracle reports
  • Analyze Integration testing data for breaks executing backend SQL queries.
  • Extraction of data from different sources like OLTP server, flat files, excel and legacy.
  • Analyze stored procedures to move code other than business logic to JAVA.
  • Analyze stored procedures for slowly changing data to cache in Application Server (JBOSS) cache reducing back end calls and network calls/data transfers.
  • Analysis and conversion of database procedure calls to JBOSS CACHE and XML reducing database calls and increasing performance.
  • Extensive experience in building Data Warehouses/Data Marts using ETL tools Informatica Power Center (9.0/8.x/7.x).
  • Worked on Webservices as a part of Informatica and obtained the successful connection of the external Webservice call.
  • Writing scripts to automate the message publishing process for testing and reconciliation on different transaction servers.
  • Knowledge about Data Mappings and Datawarehousing.
  • Use of variuos reporting tool such as Qlikview.
  • Knowledge of various data modelling tool such as ERwin.
  • Build, Migration and Deployment of application JAR files in DEV environment.
  • Running Database Scans to fix back-end issues and improve the query performance after analyzing query plan as part of business support for Book keeping business flow.
  • Running database scans on Production and QA environments as per requests from business users and clients.
  • Involved in the client support handling priority tickets and productions support issues.

Environment: C, JAVA, JUnit 4.0, Hibernate API, Spring 3.0, Apache Camel Integration API, Oracle 10g/11gOracle forms and reports 10g/11g, Eclipse 4.0/Aqua Data Studio, Putty, TOAD, SQL* Plus, LINUX/UNIX, RESTful webservices

Confidential, Buffalo, NY

Oracle PL/SQL Developer

Responsibilities:

  • Maintenance of the company web site hosted on remote IIS server 7.0.
  • Generated Managerial level reports using SQL server SSRS.
  • Wrote stored procedures/functions implementing business activities.
  • Wrote SQL scripts to fix back end related issues.
  • Modified existing procedures and functions implementing best techniques to improve the performance.
  • Wrote C# code to extend the functionality of the community site using third party API like Telligent 5.6.
  • Involved in the system upgrade activities to new versions.
  • Design and development of multiple drilled down/drill through reports to integrate summary and detail data alongside using SSRS Report Designer.
  • Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team
  • Created Filtered reports using report parameters, stored procedures & cascading parameters.
  • Extraction of data from different sources like OLTP server, flat files, excel and legacy databases
  • Analyze Oracle SQL query plans using EXPLAIN PLAN command.
  • Gather Database and User Level Statistics and Analyze Overall System Performance.
  • Organize and participate in company annual events.
  • Writing test cases for the code analysis and bug issues before deployment on to the production server.
  • Maintain company network, user accounts and fix any software and desktop related issues.
  • Scheduling and running jobs in the background, and taking regular backups of the systems and recover data during failures.

Environment: C#.Net/TELLIGENT community API, HMTL 4.0 and Java Script, SQL Server 2005, Oracle 10g/11g, Struts Visual Studio 2010, Management Studio 2008, Microsoft Business Intelligence studio and Oracle Developer, IIS server 7.0, web services

Confidential

Senior Oracle PLSQL Developer

Responsibilities:

  • Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
  • Created Materialized Views and partitioning tables for performance reasons.
  • Worked on various backend Procedures and Functions using PL/SQL.
  • Writing JAVA test cases using JUnit 4.0 API, Apache Camel test kit API.
  • Modifying the existing stored procedures or functions to improve the performance.
  • SQL Query Performance Tuning with the creation of Partitions/Indexes after analysis.
  • Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
  • Written C# code to extend the functionality
  • Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
  • Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements.
  • Involved in Integration testing and load testing of the message layer and transaction data persistence layer.
  • Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team
  • Used Build tools like ANT and MAVEN
  • Used TOAD, ORACLE developer tools for faster application design and development.
  • Developed procedures using Dynamic SQL.
  • Prepared reports using Qlikview.
  • Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems
  • Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements

Environment: JAVA/J2EE, Oracle 9i/10g, C#,TOAD, SQL * Plus, SQL * Loader, SQL * Plus editor, Eclipse 3.0, log4j, UNIX shell scripting, AJAX, IBM/AS400, MAVEN, ANT

Confidential

PL/SQL developer

Responsibilities:

  • Writing stored procedures/functions according to the business requirements and organize them into packages.
  • Installation, Creation and support of Oracle database environments.
  • Involved in the maintenance and enhancement of the application.
  • Maintaining Logical and Physical structure of the database.
  • Creating table spaces, tables, views, scripts for automatic operations of the database activities.
  • Coded various stored procedures, packages and triggers to in corporate business logic into the application.
  • Used the technical document to design the database tables.
  • Gather Database and User Level Statistics and Analyze Overall System Performance.
  • Designed/developed tables, views, various SQL queries, stored procedures, functions.
  • Monitor database and system backups, developed Oracle Stored procedures, functions, packages, and triggers that pull data for reports.

Environment: Oracle forms 9i and reports 9i, Oracle 9i/10g, TOAD, SQL * Plus, SQL * Loader, SQL * Plus editor, UNIX, Weblogic Server.

We'd love your feedback!