We provide IT Staff Augmentation Services!

Sr Oracle Pl/sql Developer Resume

0/5 (Submit Your Rating)

Redlands, CA

SUMMARY

  • About almost 8 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Development of client/server and multi tired applications using teh Oracle Relational Database Management System(RDBMS), SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX and Linux.
  • Good experience of Performance AnalysisandSQL query tuning, while designing scalable applications from scratch and maintaining existing ones, using Query Optimizer, Indexes, Execution Plans, Hints, Explain Plan, And Tk - prof.
  • Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.
  • Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
  • Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, PL/SQL table, Cursors, Nested tables, V arrays, Records, Types and Dynamic SQL for DML operations for better performance.
  • Proficient in Oracle 11g/10g/9i/8i/7.3, PL/SQL back end applications development Toad, SQL Plus, and PL/SQL Developer.
  • Experience with data flow diagrams, data dictionary techniques, Entity relation modeling and design techniques, database normalization theory.
  • Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof and Table Partitioning.
  • Experience in creating SQL loader scripts to load data from flat files into teh database and also creating External Tables to manage data which is store at teh OS level.
  • Assist in design and development of large-scalePerlapplications and scripts usingDBI/DBDfor data extraction
  • Providedbackend supportfor various Perl based applications.
  • Worked on Oracle Forms10g/9i/6i Reports10g/9i/6i.
  • Well-versed with different stages of Software Development Life Cycle (SDLC).
  • Extensively used PL/SQL to build Oracle Reports 10g and views for processing data, enforcing referential integrity and needed business rules.
  • Experienced in Tuning Queries for better performance with large volume of data.
  • Extensive experience in developing applications using Oracle Forms / Reports. Experience in almost all teh versions of Forms/Reports.
  • Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of teh Business Engineering, Quality Assurance and other teams involved with teh System Development Life cycle.
  • Decent noledge on Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
  • Expertise in implementing ETL (extract, transform and load) by using Oracle Warehouse Builder (OWB).
  • Experience in migration of source code using version control system (CVS, Arch, Visual source safe, TFS).

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g/9i, MS Access

GUI’S: Oracle Forms 4.0, Reports 4.5

LANGUAGES: SQL, PL/SQL, HTML, XML

ADMINISTRATION: SQL*Loader, Export, Import.

TOOLS: TOAD,SQL*PLUS, SQL*NAVIGATOR, SQL DEVELOPER, Putty, Forms Builder, Reports Builder, Procedure Builder, Graphics Builder, Import & Export utility, Erwin

OPERATING SYSTEM: Windows 8/ NT/2000/98/95, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Redlands, CA

Sr Oracle PL/SQL Developer

Responsibilities:

  • Collaborated with teh Business analysts and teh DBA for requirements gathering, business analysis, testing and project coordination
  • Created and managed many objects in large Oracle Databases containing GIS related records.
  • Coded and debugged teh Stored Procedures, Packages, Views and Materialized Views in Oracle Databases.
  • Extensive use of SQL Query, Joining tables, SQL functions in Queries, PL/SQL with teh use of Cursors, REF Cursors and loops.
  • Fine Tuned procedures for teh maximum efficiency in various schemas across databases using Oracle Hints, Explain plans, profiling and Trace sessions for Cost based Optimization.
  • Created database objects like tables, views, synonyms, indexes and sequences.
  • Used SQL*Loader and UTL FILE for moving teh data from flat files to staging area tables.
  • Developed PL/SQL procedures and functions to migrate data between Oracle Databases.
  • Used shell scripting to change and modify data.
  • Optimized SQL statements and PL/SQL blocks by analyzing teh execute plans and collecting statistics.
  • Created and modified Oracle Database objects to make sure all SQL statements could be executed in teh most efficient ways.
  • Involved in Unit testing and Integration System testing.

Environment: Oracle 11g, PL/SQL, TOAD, SQL Developer, Shell scripting, SQL*loader, Oracle Forms 10g, reports 10g, Stored Procedures/Triggers.

Confidential, Johns Creek, GA

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Involved in Requirement Analysis, System Design, Preparing Functional Specifications, preparing design.
  • Validating extracted data from Legacy system.
  • Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
  • Created SQL*Loader scripts to load data into teh temporary staging tables.
  • Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
  • Involved in uploading of teh data from flat files into Databases and validated teh data with PL/SQL procedures.
  • Tuned complex Stored Procedures for faster execution and Developed database structures, according to teh requirements.
  • Developed various complex stored procedures, packages, interfaces and triggers in PL/SQL.
  • Created various SQL and PL/SQL scripts for verification of teh required functionalities.
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Developed complex SQL queries for data retrieval from various database objects including tables and views.
  • Worked on various backend Procedures and Functions using PL/SQL.
  • Involved in Requirement gathering and creating Dataflow Diagrams, ER diagrams and database diagrams using Oracle Designer.
  • Wrote shell scripts to automate teh loading, balancing and extraction process
  • Performance tuning using Explain plan, TkProf and Statspack.
  • Executing ftp, telnet for remote access between UNIX systems.
  • Check teh functionality of data in teh front-end whether it is displaying properly or not.
  • Extensively involved in UNIX shell scripting for writing Wrapper scripts, SQL Execution scripts in ETL processes
  • Managing Version Control Tool like Clear Case and Start Team.

Environment: Oracle 9i, PL/SQL, SQL*Loader, TOAD, Java, HTML, HP-UX 11i, MS Visual Source Safe, Star Team, Clear Case PL/SQL Developer.

Confidential ., NY

Oracle PL/SQL Developer

Responsibilities:

  • Involved in developing Data models, Data dictionaries, mapping documents and cross functional documents across systems for all teh ETL needs.
  • Worked on designing, coding, testing and maintaining database objects, tables, views, packages, functions, procedures, indexes, sequences and triggers using Oracle PL/SQL.
  • Created complex relational database queries/SQL, dynamic SQL, consistency reports.
  • Developed teh ETL mappings in PL/SQL via packages, procedures, functions, views and triggers.
  • Extensive use of performance tuning.
  • Performed reverse engineering of physical data models from databases and SQL scripts.
  • Built physical data structures like tables, views, constraints & Indexes.
  • Loaded teh data into database tables using SQL*loader from text and excel files.
  • Usage of Unix commands for transferring files to merchants.
  • Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
  • Involved in Performance tuning, which included creating indexes, providing Hints, modifying tables, analyze tables and estimate stats using explain plan utility
  • Reviewed modifications to existing software to improve efficiency and performance.
  • Involved interfacing with teh following tools: PL/SQL, Oracle Forms, Oracle Reports, Crystal Reports, and generated physical and logical data modelsusingErwin
  • Part of a development team for creation and maintenance of custom apps/reports.
  • Created database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus, PL/SQL and TOAD
  • Performed query optimization using Explain Plan & TK Prof utility.

Environment: Oracle 11g, Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, MS Access, UNIX Shell script, TOAD, UNIX, Windows XP/2000.

Confidential, Sacramento, CA

Oracle PL/SQL Developer

Responsibilities:

  • Involved in designing ER diagram usingERWIN and VISIO. To set teh logical and physical relationships of database.
  • DevelopedStored Procedures, Functions, Packages and SQL ScriptsusingPL/SQL.
  • Developed data model,SQL Coding,SQL Query tuning processandSchemas.
  • Migration of dbms jobs tocontrol M.
  • Scheduling jobs incontrol Mand handling them.
  • Usedtortoise svn versioncontrol for changing teh codes.
  • Making changes to teh existingapexapplications in teh production.
  • CreatedSQL*plus reportsas per client's various needs, and developed business objects.
  • DevelopedSQL Scripts, Packages and Proceduresfor Business rules check to implement business rules.
  • Providedbackend supportfor various perl based applications.
  • UsedBulk Collections, Indexes, and Materialized Viewsto improve teh query executions.
  • UsedRef cursorsandCollectionsfor accessing complex data resulted from joining of large number of tables in PL/SQL blocks and even has experience with exception handling..
  • Atomized routine jobs usingDBMS JOB.On completion of these jobs an email will be sent out automatically with teh halp of UTL MAIL.
  • Involved in SDLC including designing, coding and testing.
  • DevelopedSQLandPL/SQLscripts to transfer tables across teh schemas and databases.
  • Developed UNIX shell scripts in VI Editor with embedded SQL*Loader calls and PL/SQL statements to extract data from teh legacy application in teh form of flat files and load teh extracted data into teh new application.
  • Archived many applications in teh existing system and retrieval of necessary data from them.
  • Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.

Environment: Oracle 10g/9i/11g, SQL, PL/SQL, SQL*Loader, UNIX Shell script, MS Access, TOAD, Oracle Forms 10g, Reports10g, Oracle Designer, UNIX, JAVA, Windows XP/2000.

Confidential, West Des Moines, IA

Oracle Developer

Responsibilities:

  • Actively involved in interacting with front end Java developers, and gathered User Requirement and Online System Specification.
  • Created new logical and physical database design to support multi-year conferences for teh tables of employees, histories, skills, experience and payroll.
  • Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in SQL Server.
  • Normalized to 3NF to acquire least data repetition required by business.
  • Created PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
  • Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.
  • Experience with building application using Oracle APEX, worked on Korn shell scripts on UNIX platforms
  • Created stored procedures and functions to support efficient data storage and manipulation.
  • Implemented security by creating User logins, Roles and granting Users access to teh database according to their role.
  • Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
  • Converted all Oracle ETL Packages to Informatica Mappings and created workflows/sessions.
  • Used UTL JOB to automate teh PLSQL procedures and packages.
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF and AUTOTRACE
  • Developed scenarios for Unit, Integration testing to ensure that all teh components work correctly when integrated.

Environment: Oracle 10g/9i/11g, SQL, PL/SQL, SQL*Loader, UNIX Shell script, MS Access, TOAD, Oracle Forms 10g, Reports10g, Oracle Designer, UNIX, JAVA, Windows XP/2000..

Confidential, FL

Oracle Developer

Responsibilities:

  • Developed and modified PL/SQL code for complete process of conversion from mainframes database to oracle database.
  • Coded and debugged teh Stored Procedures, Packages, and Views in Oracle Databases using SQL and PL/SQL, which were called by user-oriented application modules.
  • Extensive querying using SQL * plus / TOAD to monitor quality and integrity of data.
  • Design and prepared Data Flow Diagrams and mapping documents for existing PL/SQL code.
  • Involved in coding of data extraction scripts as per technical specifications.
  • Designed database tables as per technical specifications.
  • Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
  • Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
  • Involved in Performance tuning which included creating indexes and modifying tables using explain plan utility.
  • Created SQL Loader script generator application using PERL shell scripting and PL/SQL
  • Optimized SQL statements and PL/SQL blocks by analyzing teh execute plans and statistics of SQL statements and created and modified some Oracle Database objects to make sure all SQL statements could be executed in teh most efficient ways.
  • Involved in Batch Operations.
  • Developed automating reports by validating converted data.
  • Involved in production support and resolved many critical issues by providing emergency cleanup scripts.

Environment: Oracle 9i/10g, OAS 9i (Oracle Application Server), PL/SQL, TOAD, SQL*Loader, Informatica 8.x, SQL Server 2000/2005, UNIX, PERL, WINDOWS, HP 9000 server HP-UX.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Worked on teh project that involved development and implementation of a data warehouse.
  • Created Store Procedures, Functions, Triggers, Indexes and Views using T-SQL in all teh environments for SQL Server 2000.
  • Developed DTS Packages to transfer teh data between SQL Server and other database and files.
  • Created report form with Stored Procedure using T-SQL
  • Wrote and optimized Triggers, Stored Procedures and Queries in T-SQL.
  • Created database objects like tables, views and indexes.
  • Created and modified stored procedures, triggers and cursors.
  • Designed, developed and modified various Reports.
  • Handled and managed customer relationship management system with Core Banking Solutions.
  • Designing and modeling database according to Requirement. And made changes according to it.
  • Designed, developed, and tested queries for Reports distribution.
  • Built and performed user acceptance testing on modified reports.

Environment: Oracle 8i, PL/SQL, SQL * Plus, SQL Navigator, Oracle Designer 6i, Windows 2000

We'd love your feedback!