Sr. Oracle Pl/sql Developer Resume
Raleigh, NC
SUMMARY
- 7 years of total experience in Analysis, design, development, and testing of various business applications using Oracle SQL and PL/SQL.
- Worked extensively on various RDBMS like Oracle 11g/10g/9i, SQL Server 2008/2005.
- Extensive working experience in writing various modules likes functions, stored procedures, cursors (Implicit, Explicit, REF), packages, triggers and creating tables, views and materialized views using Oracle SQL and PL/SQL.
- Proficient in Oracle tools and utilities such as TOAD, PL/SQL Developer, SQL Developer.
- Experience in Data Warehouse design, Data Modelling and Schema Design.
- Strong understanding of data warehouse design methodologies, data structures, data modelling and RDBMS concepts.
- Extensive experience in performance monitoring and tuning in Oracle/MS SQL Server.
- Experience in optimization of SQL statements using SQL Trace, TKPROF and Explain Plan.
- Experience in performance Tuning using various types of Hints, Partitioning and Indexes.
- Good knowledge of the RDBMS concepts advanced Oracle queuing and Oracle Workflow.
- Deep understanding of Software Development Cycle (SDLC) and implemented various models like Spiral, Agile (XP, SCRUM) and Iterative models.
- Interacted with Clients, Project Managers to gather the Business Requirements and developed the technical specification document.
- Having Good knowledge of UNIX, and Shell Scripting.
- Implemented various Error/Exception handling methods using system defined exceptions and user defined exceptions.
- Excellent experience in creating Test Cases, Test Plans, Technical Design Documents and Functional Design Documents.
- Experience in production support, fixing production bugs and handled continuous enhancements requested from business users.
- Good communication, Analytical and presentation skills. Ability to provide timely solutions and work within specific time frames.
TECHNICAL SKILLS
Databases: Oracle 9i, 10g, 11g, SQL Server 2000/2005, MySQL, Microsoft Access.
Operating System: Windows NT/2000/2003/XP/VISTA, Linux, UNIX.
Programming Languages: C, C++, VB, SQL and PL/SQL.
Version Control Tools: CVS, Clear Quest, Clear Case, Subversion (SVN)
Tools: TOAD, SQL Developer, SQL * Loader, SQL navigator.
PROFESSIONAL EXPERIENCE
Confidential, Raleigh, NC
Sr. Oracle PL/SQL Developer
Responsibilities:
- Involved in Analysis, design, development, implementation and support of the enterprise data warehouse.
- Interacted with Business stakeholders, subject matter experts and Business Analyst to gather the Requirements and Business logics and mappings on scheduled basis.
- Involved in source data analysis and creating ETL design document along with the enterprise architects.
- Developed major ETL packages by implementing various business transformation logics to load the data into different stages in Data Warehouse.
- Created stored procedures, Functions to facilitate the functionality for various complex modules. And used the oracle Pipeline functions to improve the performance.
- Created Oracle Virtual Private Databases (VPD) to enforce security and control data access by creating security policies on PII data elements.
- Designed and Developed and maintained the complex oracle scheduler chains for the load process.
- Involved in creating data marts, views to load the data into application databases.
- Involved in documentation of User requirements and Testing of developed modules.
- Created the production release and migration scripts/documents, worked closely with Data Base Administrators on production deployments.
- Supporting the production environments 24/7, fixing the defects and high priority bugs.
- Analyzed the data needs for the customized reports, identified the Mapping and generated transmitted the reports by creating various Stored Procedures, Functions and Packages.
- Developed SQL scripts to create database tables, synonyms, sequences, and created users, roles, and granted privileges to them.
- Performed unit testing, integration and regression testing for various applications developed in data warehouse.
- Responsible for performing code reviews and code fixing after identifying the Defects.
- Optimized and fine - tuned the SQL queries by using Explain plan and Quest SQL optimizer.
- Involved in helping the application teams to rewrite and fine-tuned the existing applications.
- Worked closely with team members to share the work and helping them to resolve the issues.
- Played an important key role in decision-making and provided valuable ideas and inputs for the success of the project.
Environment: Oracle 11g R2, TOAD 11.x, SQL PLUS, SQL Developer, UNIX, Windows 7.
Confidential, Peoria, IL
Oracle PL/SQL Developer
Responsibilities:
- Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
- Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
- Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
- Implemented Security by creating different Users, and assigning Roles to Users.
- Created Data Structures including Tables and Views, and applied referential integrity.
- Participated in designing of data conversion/interface with the use of SQL*Loader.
- Created Form level objects i.e. Libraries, property classes.
- Created Triggers, Stored Procedures, Packages and SQL Scripts.
- Developed SQL*loader scripts to load data in the custom tables.
- Developed PL /SQL code for updating payment terms.
- Involved in documentation of User requirements and Testing of developed modules.
- Worked in the Production Support team and fixed high priority bugs.
- Developed SQL scripts to create database tables, synonyms, sequences, and created users, roles, and granted privileges to them.
- Performed unit testing and integration testing for various development applications in ORACLE 10g.
- Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
- Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
- Used external tables to manipulate data obtained daily before loading them into the tables.
- Developed UNIX Shell scripts to automate repetitive database processes.
- Designed reports that had complex SQL, PL/SQL code and stored the procedures. The filter conditions for the Queries were dynamic in nature and included lexical parameters.
- Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Forms Developer 10g.
Environment: Oracle 10g, PL/SQL, SQL*LOADER, SQL PLUS, TOAD 9.X, Forms 10g, Reports 10g, Windows XP, UNIX shell scripting, Oracle Applications.
Confidential, Fairlawn, OH
Oracle PL/SQL Developer
Responsibilities:
- Developed PL/SQL Stored Procedures, Functions, Packages and Triggers to implement business rules into the application.
- Designed and created all the required tables, indexes, sequences and views using SQL*Plus and Toad.
- Written Procedures to Load Data into data warehouse system.
- Involved in developing Object data types and collections.
- Developed various Complex Queries, Views for Generating Reports.
- Used Hints to Achieve the Performance and Tuned SQL Queries and Stored Procedures, improved the performance of the reports.
- Written SQL scripts for implementation and mentored the end users
- Responsible for Study, Analysis, Design, Development/Customization and Testing/debugging of the reports.
- Written Shell Scripts, control files to load data into staging tables and DW tables.
- Developed and Tested applications for loading inventory data into database tables.
- Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
- Involved in Unit testing PL/ SQLStored Procedures andFunctions.
- Perform analysis of key requirements and transfer knowledge accordingly to the end users
- Extensively used PL/SQL Procedures and Functions to transform data before the loading process.
- Involved in quality assurance of data, automation of processes, programming for data manipulation validation of programming, andpresentation of results.
- Created SQL reports, data extraction and data loading scripts for different databases and schemas.
- Loading data from flat files into database tables using SQL* Loader
- Developed UNIX Shell scripts to automate repetitive database processes.
- Optimizing database objects and streamlining applications.
ENVIRONMENT: Oracle 10g, Windows XP, SQL, PLSQL, SQL*Loader, KORN Shell script, TOAD.
Confidential, Winston Salem, NC
Oracle PL/SQL Developer
Responsibilities:
- Developed and modified database triggers, cursors, procedures, functions and packages to meet business requirements.
- Developed back-end PL/SQL code to implement business rules through triggers, procedures, functions, and packages using SQL*Plus Editor or TOAD.
- Optimized and tuned PL/SQL to reduce the loading process - Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
- Created and maintained development environment, resolved Production and validated Environment problems.
- Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Forms Developer 11g.
- Developed and deployed the Reports using Oracle Reports 11g.
- Detected and Corrected bugs during system integration and user acceptance testing.
- Involved in direct discussion with the Functional/End-Users to study the system requirement and develop Functional and Technical specifications to meet their requirements.
- Involved in Planning, Implementation, Testing, and Documentation.
- Mapped the source and target databases by studying the specifications and analyzed the required transforms.
- Responsible for the development and maintenance of end-user documentation.
- Detected and Corrected bugs during system integration and user acceptance testing.
Environment: Oracle 9i/10g, Oracle Reports & Forms 6i/9i/10g, PL/SQL, ERWIN, MS Access, MS Excel, C++, SQL*Loader, CVS, TOAD, Dynamic SQL, Eclipse, EXPLAIN PLAN, TKPROF, MS Visio, UNIX.
Confidential
SQL Developer
Responsibilities:
- Worked on converting the date from existing legacy system into oracle.
- Developed PL/SQL Packages, stored procedures, and functions to extract, transform and load data from Legacy systems into Oracle database.
- Involved in uploading of the data from flat and external files into relational Database tables using SQL*Loader and validated the data.
- Worked on performance issues while conversion of data.
- Created PL/SQL objects such as tables, views, synonyms, sequences, triggers and database links as well as custom packages tailored to business requirements.
- Worked on scheduling programs on a nightly basis using DBMS JOB SCHEDULING.
- Developed automated scripts to schedule the load of flat files on daily, weekly and monthly basis.
- Involved in unit and integration testing and documentation.
Environment: Oracle 9i, Windows XP, SQL Server 2005, Oracle SQL developer, SQL * Loader, PL/SQL, SQL*PLUS.