We provide IT Staff Augmentation Services!

Sr Oracle Pl/sql Developer Resume

4.00/5 (Submit Your Rating)

Charlotte, NC

SUMMARY

  • Over 8 years of IT experience in System Analysis, Design, Development, Maintenance and Support using Oracle Database 8i/9i/10g/11g, SQL, PL/SQL, SQL * Loader, Query Optimization, Performance Tuning, and Trouble Shooting
  • Experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing technical design specifications.
  • Providing assistance in logical/physical data modeling using ERWIN
  • Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
  • Experience with multiple RDBMS including Oracle 11g/10g/9i/8i/8.x/7.x, SQL server 2008/2005 databases on UNIX, Linux and Windows enterprise platforms
  • Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re - Write and Transportable table spaces
  • Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
  • Developed Complex database objects like Stored Procedures, Packages, Triggers and functions, ref cursors using SQL and PL/SQL
  • Experience in creating cursors, composite data types, collections and exception handling
  • Proficient in working and conceptual knowledge of Oracle Forms 6i/10g, Reports 6i
  • Experienced in performance tuning using SQL Trace - TKPROF and Explain Plan
  • Experienced in working with utilities like SQL*Loader, External Tables, Import, Export to extract and load large volume of data
  • Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables
  • Loaded Data into Oracle Tables using SQL Loader
  • Worked extensively on Ref Cursor, External Tables and Collections
  • Expertise in Dynamic SQL, Collections and Exception handling. Partitioned large Tables using range partition technique
  • Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes
  • Developed various Unix Shell Scripts to manipulate data files, set-up environment variables, custom FTP utility, file archiving
  • Hands on experience with tools like SQL Navigator, Toad, SQL*Plus, Export and Import Utilities along with Oracle Enterprise Manager (OEM)
  • Used bulk binding techniques like BULK COLLECT and FOR ALL to improve performance
  • Experience working with Unix shell, Perl Scripting for ETL Job scheduling using different like Autosys, Control M and Data cleansing processes
  • Extensive experience in integration of data from heterogeneous sources (ERP, RDBMS, Flat Files and Web Applications)
  • Profound knowledge of using Visual Basic, .Net platform, VB.Net, ASP.Net and C#
  • Worked on Production Support, receiving production calls, troubleshooting teh application and resolving bugs.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i/7.x, MS SQL Server 2008/2005, SAP BI BW 7.0

Languages: SQL, PL/SQL, T-SQL, Shell Script, Batch script, ASP .NET, XML

Tools: TOAD 8.5/8.0/7.1, SQL-Developer, PL-SQL Developer, SQL*Plus, SQL*Loader, Import and Export, Explain Plan TKPROF, Quality Center 10.0

Data Modeling Tools: Erwin r7/r4/r3.5, MS Visio 2007/2010

Operating Systems: Windows Server 2003/2000/NT, Windows Vista/ XP/98/95, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr Oracle PL/SQL Developer

Responsibilities:

  • Interacted with Business Users and Business System Analysts to gather teh Requirements.
  • Participated in teh full software development life cycle.
  • Involved in creating Logical and Physical data modeling using ERWIN.
  • Created materialized views on remote source database and automated scheduler of refreshing of materialized view on source side.
  • Created database objects like Tables, Sequences and Constraints as per teh business requirement.
  • Created or Modified teh Sequel Script (.sql file) to point to teh current source.
  • Extracted data from teh source views by writing teh procedures to load teh data into staging tables.
  • Created database views and materialized views.
  • Created database triggers based on business requirement.
  • Developed stored functions, packages based on requirement.
  • Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL. Enhanced it with creating exceptions for error handling.
  • Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER
  • Written complex Oracle SQL queries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators
  • Wrote many simple and complex ad-hoc reports using SQL Plus and TOAD for teh business users. Transformed complex business rules to Oracle PL/SQL
  • Use various SQL Profiler templates for tracking execution time of TSQL Statements.
  • Created indexes on tables and optimized procedure queries.
  • Maintained Database security by authenticating users, using logon triggers.
  • Running explain plan for tuning teh SQL queries.
  • Used Exception Handling extensively for teh ease of debugging and displaying teh error messages in teh application
  • Created test scripts documentation for all teh procedures dat me have created.
  • Involved in production support, like monitoring teh performance of teh Unix jobs.
  • Involved in teh Error Diagnosis, developing test plans to conduct teh Unit and Integration testing
  • Researching and resolving teh problems occurred with teh Jobs and also involved with teh end user to resolve teh problems

Environment: Oracle 11g, PL/SQL, SQL*Plus, PL/SQL Developer 6.0, Toad 9.1, SQL * Loader, UNIX, Shell Scripts, SQL Navigator, Erwin r7, QC 10.0, Windows

Confidential, Phoenix, AZ

Oracle PL /SQL Consultant

Responsibilities:

  • Involved in analysis, design, coding, and implementation
  • Involved in creating Database Design (Physical and logical) as per teh requirement given by business
  • Worked on Erwin Data Modeler for mapping both user-defined and default data types
  • Developed PL/SQL packages, procedures, functions, materialized views, SQL Scripts and triggers to populate teh historic data in teh tables applying business logic
  • Wrote Package containing several Procedures and Functions in PL/SQL to validate before loading into Application database.
  • Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges on OLTP server.
  • Involved in Creation of tables, Partitioning tables, Join conditions, correlated sub queries, and nested queries, views for teh business application development.
  • Created temporary tables and developed SQL*Loader control files to load teh legacy data into teh temporary tables.
  • Wrote Materialized views and complicated queries using SQL.
  • Involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
  • Used teh advanced features of PL/SQL like collections, nested table, array & Dynamic SQL.
  • Merged data files coming from teh customer into teh existing data warehouse.
  • Worked with Oracle Enterprise Manager, Net configuration assistant
  • Written teh SQL Queries to Data Retrieval Tool
  • Wrote SQL sub-queries with join conditions and PL/SQL scripts
  • Involved in performance tuning of SQL queries and Created indexes on tables and optimizing Stored procedure queries
  • Design and developed teh scripts to create table, views, indexes and sequence.
  • Used UNIX scripting to automate teh process by using CRONTAB.
  • Extensively involved in tuning teh queries and applying hints for faster and better performance of teh SQL queries.
  • Created teh Shell Scripts to automate teh execution of teh PL/SQL subprograms and to move teh data to store in historical folders.
  • Used FTP to transfer teh files into different servers as needed by teh business users.
  • Created teh test scripts and complex queries to test teh timesheet application and to quality assurance of teh data.
  • Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
  • Involved in preparing functional document, user document, process flow diagram and flow charts.

Environment: Oracle 10g, PL/SQL, SQL* Plus, SQL * Loader, SQL * Navigator, TOAD, Erwin r4, SQL Server 2008, UNIX, C#, MS Visual Studio.

Confidential, Detroit, MI

Oracle PL/SQL Developer

Responsibilities:

  • Created data mapping to map teh data from different sources to Oracle.
  • Involved in implementing teh data integrity validation checks through constraints and triggers.
  • Developed and modified packages, functions and stored procedures for data conversions
  • Developed PL/SQL procedures to create database objects dynamically based on user inputs.
  • Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data from teh Data repository using cursors and exception handling.
  • Created indexes on tables to improve teh performance by eliminating teh full table scans.
  • Created views for hiding actual tables and to eliminate teh complexity of teh large queries.
  • Worked with Bulk Collections for bulk load processing.
  • Created Records, Objects, Collections to store ordered group of elements for faster assessment of tables
  • Created Error Handling to handle run-time errors in teh PL/SQL code.
  • Involved in code walk through and review sessions with teh development team.
  • Used Oracle Hints and explain plan to fine tune teh queries.
  • Increased performance tuning by rewriting some of teh Queries.
  • Automatic Scheduling of teh jobs are done by Cronjobs.
  • Used Microsoft VSS to version control all teh database scripts.
  • Designed and developed Oracle forms and reports according to user specification.

Environment: Oracle 10g, Oracle Forms and Reports 6i, SQL, PL/SQL, Erwin, UNIX, Windows XP, Microsoft Excel, TOAD, Microsoft VSS

Confidential, Southlake, TX

Senior Database Developer

Responsibilities:

  • Developed severalPackages, Procedures, Functions and Triggers to use in multiple series of other backend programs using PL/SQL.
  • Involved in Logical and Physical Database design and Star Schema design. Identified Fact tables, Transaction tables for small Business and Consumer Markets (SBCM) customers.
  • Written SQL scripts to create database objects like tables, views and sequences.
  • Constant monitoring and performance tuning of Oracle10g database, checking teh most queries.
  • Coded PL/SQL sub-programs and modified teh existing PL/SQL program units for customer Contact Employees (CCE’s) relationships.
  • Customer Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
  • Developed batch programs using UNIX shell scripts to generate reports daily, weekly & monthly for Customers Markets.
  • Created Korn Jobs to perform regular updates to database tables to keep in sync with teh data coming from other sources.
  • Performed review and analysis of deadlocks and database performance tuning.
  • Conducted code walkthrough & internal/peer reviews on application code and other deliverables.
  • Documented teh whole process flow, PL/SQL packages, log files, locations and descriptions, log tables and possible error messages, process codes and descriptions.
  • Involved in teh continuous enhancements and fixing of production problems.
  • Worked closely with teh Application Development teams to identify and implement continuous improvements and effective problem resolution strategies.

Environment: Oracle 10g/9i, SQL, PLSQL, SQL*Loader, KORN Shell script, Erwin, TOAD, Web Logic, HTML, Java, J2EE, Unix.

Confidential

Software Engineer

Responsibilities:

  • Gatheird test requirements by coordinating with Business, design and development team
  • Created Test plans and detailed test cases for functional and integration, performance test phases
  • Coordinated with development team for all teh issues related to deployments, defect tracking.
  • Was responsible for creating both positive and negative test cases.
  • Participated in daily build calls and defect review calls
  • Extensively using SQL Queries for gathering test data and for validating teh data
  • Reporting and tracking teh defects using Clear Quest
  • Regular meetings and updates are made to teh Management team of teh ongoing QA Process.
  • Created test scripts for various testing stages like Functional, Regression, System and End-to End testing
  • Worked with Development team, Requirements team and DBA’s to resolve teh issues encountered.
  • Successfully involved in several Releases to certify them as ready for deployment in a production level environment form QA Perspective.

Environment: Windows XP, Oracle 10g, SQL, HTML UNIX, SQL Developer, Clear Case, and Clear Quest.

Confidential

Software Engineer

Responsibilities:

  • Involved in Functional Requirements review meetings.
  • Involved in to prepare teh test cases according to teh Functional Requirements.
  • Participated in peer reviews with team and with feature developers to review teh test cases.
  • Executed Test Cases to verify teh functionality of teh respective features of teh application.
  • Used Bugzilla to report teh defects found during Regression testing and followed up until it resolves.
  • Worked with developers to resolve and fix teh faults found in testing functionality of teh application.
  • Interacted with users by conducting User Acceptance Test to ensure dat teh total functionality of teh application was met by complying with teh entire business requirements pattern.
  • Environment: Manual Testing, VB, Oracle 7.3, PL/SQL, Windows, UNIX.

Environment: Manual Testing, VB, Oracle 7.3, PL/SQL, Windows, UNIX

We'd love your feedback!