We provide IT Staff Augmentation Services!

Sr. Oracle Pl/sql Developer Resume Profile

Ann Arbor, MI

Professional Summary

  • Over 8 years' experience as a Software Programmer and Oracle PL/SQL Developer/Programmer in Application Development and Production Support.
  • Proficient in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
  • Strong in using tools such as TOAD, Benthic, SQL Plus, SQL Developer and SQL Loader.
  • Experience using Bulk processing, ETL operations using ODI Oracle Data Integrator , REF cursors, collections, DBMS packages.
  • Extensive experience in Analysis and Design of Database. Created ER Diagrams on ERwin, Microsoft Visio.
  • Experience in schema structure design and involved in estimation and optimization of data storage.
  • Experience in utilizing External Tables, merge statement, Pipelined functions.
  • Expert in Performance Tuning Query Optimization of SQL statements using EXPLAIN PLAN, SQLTRACE, TKPROF, HINTS, Index.
  • Comfortable with working with Composite Data Types.
  • Experience in Debugging, Testing, and Deploying the Applications.
  • Experience in different phases of Software Development Life Cycle which include Analysis, Design, Development and Testing.
  • Developed business Reports using Cognos, APEX
  • Successfully utilized performance enhancements features of Oracle to optimize the batch processes.
  • Strong technical aptitude, ability to rapidly assimilate and design practical applications of new technology.
  • Good team player and ability to work independently.
  • Excellent logical and analytical skills, enthusiastic, excellent interpersonal communication skills.
  • Commitment to excellence proven by an outstanding career track.

Technical Skills

  • Databases: Oracle 10g/11g, SQL Server, MS-Access.
  • Database Tools: Toad, Oracle SQL Developer, SQL Plus, Benthic.
  • Reporting Tools: Cognos 8.0
  • ETL Tools: ODI 11.x, Informatica 7.x, 8.x, Datastage
  • OS: Windows 7, Windows XP professional.
  • Unix: Putty, WinSCP
  • Web Design Tools: Adobe Dreamweaver CS3, Eclipse, XML, Notepad.
  • Management Tools: MS Project 2007, Visual Project Maps, HP PPM, DAPtiv.
  • Documentation: MS Office 2010.
  • Other tools: Microsoft Visual Studio 2003/2005, Microsoft Visio.

Professional Experience

Confidential

Role: Sr. Oracle PL/SQL Developer

Software: Oracle 11G, Oracle SQL Developer, Subversion, Tortoise SVN, UNIX, Sharepoint, Agent Ransack.

Responsibilities:

  • Attended weekly meetings and interacted with client to gather business requirement.
  • Performed extensive requirement analysis using source to target mapping documents.
  • Created external tables to load data from various files supplied by data supplier.
  • Created tables, constraints, indexes and synonyms
  • Created oracle pl/sql packages, procedures, functions, triggers, cursors.
  • Used Bulk processing to load large data. Used Bulk collect collections and FORALL
  • Wrote complex Oracle SQL code containing materialized view logs, analytical functions, Regular expressions, sub queries, joins, dblinks to publish data from source to target.
  • Worked with Architects, Lead Developers, DBA's, and end users in specifications, design, development, testing and implementation of the project
  • Performed performance tuning by analyzing query plans. Suggested partitions, index, optimizer hints, multi-table inserts.
  • Used scheduler to run chain of jobs based on dependency.
  • Strong unit, integration and system testing skills.
  • Played Major role in the planning, testing, and implementation of system improvements and conversions.
  • Identified bugs and logged them for tracking and auditing purposes.
  • Performed End-to-End testing on the release version using Subversion.

Confidential

Role: Oracle PL/SQL Developer with ODI oracle data integrator

Team Size: 30

Responsibilities:

  • Preparation of documentation Business functionality, Process, Technical system Design
  • Performed extensive requirement analysis including data analysis and GAP analysis
  • Performed moderately complex development tasks following SBS system development life cycle.
  • Created data models/mappings/packages/Scenarios/load plans in Oracle Data Integrator, wrote underlying Oracle SQL code containing views, analytical functions, Regular expressions, sub queries, joins, flashback tables, dblinks to publish data from source to target.
  • Created tables, constraints, indexes, sequences, synonyms
  • Created oracle pl/sql packages, procedures, functions, triggers to load data from legacy database to raw tables.
  • Worked with Architects, Lead Developers, Data Analysis, DBA's, and end users in the specification, design, development, testing and implementation of publishing services
  • Researched and understood the business and technical requirements for a publishing process/system, including target environment and performance criteria suggested technical approaches to management on projects
  • Major role in the planning, testing, and implementation of system improvements and conversions.
  • Involved in code review.
  • Strong unit, integration and system testing skills.
  • Developed steps for Unit Testing and Test scenarios / Test Plans with QA Team
  • Performed End-to-End testing on the release version using AccuRev for the software application and detected track bugs using JIRA.
  • Identifying the bugs and logging them for tracking and auditing purposes
  • Used to APEX for reporting.

Confidential

Role: Oracle PL/SQL Developer

Team Size: 12

Software: Oracle 10g, Toad, Cognos 8.0, VAX, Jira.

Responsibilities:

  • Involved in requirement gathering and analysis phase.
  • Created Database Objects such as indexes, functional based indexes, sequences, synonyms, views and materialized views.
  • Developed PL/SQL packages, stored procedures, functions and triggers to business requirements.
  • Extensively used oracle collections like nested tables and associative arrays.
  • Utilized Oracle's bulk processing techniques like Bulk Collect and FORALL.
  • Conducted extensive performance tuning using Explain Plan and TKPROF utilities.
  • Excellent is using Oracle Analytical functions.
  • Wrote Pipelined functions to migrate data from the External files into the oracle Database.
  • Utilized Dynamic SQL to build SQL statements dynamically at runtime.
  • Sub-queries and joins were extensively used in stored procedures.
  • Analyzed the whole process flow, PL/SQL packages, log files, error files, locations and descriptions.
  • Involved in Code Review and User Acceptance Testing UAT of the application.
  • Tested new enhancements and fixed various bugs before Deployment into the Production environment.
  • Developed business Reports using Cognos 8.
  • Creating automated jobs to perform the task using VAX.
  • Involved in preparing System documentation such as Technical Specifications, functional specifications, release notes, Unit Test Plan, Data Flow Diagram using MS-Word, Visio and other documentation.
  • Understanding the process and Interacting with functional team to resolve the issues in the given objects.
  • Used Jira to manage task and to view project deadlines.

Confidential

Role: Oracle PL/SQL Developer

Team Size: 20

Software: Oracle 9i, SQL Developer, Informatica 8.1, UNIX, Putty, WinSCP, CA Workflow Automation Tool, HP Overview Service Desk, Version Control Tool PVCS , HP PPM.

Responsibilities:

  • Created Database Objects such as indexes, sequences, synonyms, views and materialized views.
  • Developed PL/SQL packages, stored procedures, functions and triggers to business requirements.
  • Conducted extensive performance tuning using Explain Plan and TKPROF utilities.
  • Involved in the Analysis and Data Modeling of Logical to Physical data models.
  • Wrote Pipelined functions to migrate data from the External tables into the oracle Database.
  • Analyzed the whole process flow, log files, error files, locations and descriptions, PL/SQL packages, process codes and descriptions.
  • Developed various reports using UNIX.
  • Involved in Code Review and User Acceptance Testing UAT of the application.
  • Tested new enhancements and fixed various bugs before Deployment into the Production environment.
  • Creation of incidents using HP Overview Service Desk.
  • Creating automated jobs to perform the task using CA Workload Automation.
  • Involved in creating System documentation such as Technical Specification, Unit Test Plan, System Flow Diagram and Data Flow Diagram using MS-Word, Visio.
  • Involved in preparing functional specifications, release notes and other documentation.
  • Used HP Project and Portfolio Management Center module to manage task and to view project deadlines.

Confidential

Role: Software Developer

Team Size: 10

Software: SQL Developer, Benthic, Siebel, Argus safety 6.0, Windows XP, Lotus Notes and MS Office.

Responsibilities:

  • Developed various PL/SQL packages, procedures functions tailored to business requirements.
  • Involved in the process of creating database objects such as tables, views, materialized views, synonyms, indexes and sequences.
  • Worked on ER Diagrams ERD , Data flow diagrams based on the requirement.
  • Extensively worked with Ref Cursors to support .Net code.
  • Used Dynamic SQL to create procedures to match required functionalities.
  • Successfully utilized performance enhancements features of Oracle to optimize the batch processes.
  • Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
  • Used Pre Post Stored Procedures for Source/Target to perform additional checks before loading the data with respect to table size check and recreating indexes.
  • Involved in extensive server side and client side validations.
  • Involved in the continuous enhancements and fixing of production problems.

Hire Now