We provide IT Staff Augmentation Services!

Senior Pl/sql Developer Resume

0/5 (Submit Your Rating)

Detroit, MI

SUMMARY

  • 7+ years of experience in IT, as Software Engineer in Data Warehousing with SQL and PL/SQL development activities
  • Hands on experience using query tools like TOAD, SQLDeveloper and PLSQLdeveloper
  • Working experience in AGILE methodology for software development.
  • Strong Exposure in writingSimpleandComplex SQLs, PL/SQL Functions and Procedures, Packagesand creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
  • Experience in Tuning SQL Statements and PL/SQL Procedures for enhancing teh load performance of applications in various schemas across databases.
  • Expertise in using SQL utility tools: TOAD, SQL*PLUS, SQL Developer and SQL navigator.
  • Proficient in writing complex SQL Queries, stored procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries.
  • Having experience in ETL processes and Interfaces, mapped teh columns and load teh data from source systems by using ODI (Oracle data integrator),SQL* Loader.
  • Good experience of end to end ETL design and Development, Transformation and Loading in a complex, high-volume environment.
  • Good experience in Oracle Database Integrator and Control-M Scheduling tool.
  • Strong problem solving & technical skills and significant experiencein24/7 ProductionEnvironment Support.
  • Excellent analytical, interpersonal and communication skills to assimilate new technologies and tools.
  • Excellent ability to work in groups as well as independently.

TECHNICAL SKILLS

ETL Tools: Oracle Database Integrator (ODI), Ab Initio & SQL Server Integration Services (SSIS)

Database: Teradata V12, Oracle 11g, Microsoft SQL Server, MySQL

Reporting tools: Cognos BI, Microstrategy

Language: C, SQL, PL/SQL

Operating Systems: Windows XP, Windows 2007, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Senior PL/SQL developer

Responsibilities:

  • Designed/developed/Modifiedtables, views, materialized view, stored procedures, packagesandfunctions.
  • Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied teh procedures into an existing ETL process.
  • Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
  • UsedSQL loaderto load teh data from teh files provided by teh interfacing applications.
  • Created newProcedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
  • Createdpartitioned tablesandpartitioned indexesto improve teh performance of teh applications.
  • WrotePL/SQL Database triggersto implement teh business rules in teh application.
  • Createdexternal tablesto handle huge volumes of data which is not used frequently.
  • Optimized lot ofSQL statementsandPL/SQL blocksby analyzing teh execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
  • Developed various backend application programs, such asViews, Functions, Triggers, ProceduresandPackagesusingSQLandPL/SQLlanguage for teh top management for decision making.
  • Performed Unit test, System integration test to make sure teh deliverables are match with business requirement

Environment: Oracle 11g, PL/SQL, TOAD, UNIX

Confidential, Rochester, MN

Oracle developer

Responsibilities:

  • Creating PL/SQL Stored Procedures, Functions and Triggers
  • Coding according to teh mapping sheet and debugging teh code.
  • Oracle Application Performance Tuning and SQL Query Tuning.
  • Data Migration Using SQL Loader
  • Client interaction.
  • Reviewing teh test scripts and involved in preparing technical specification documents.
  • Unit Testing

Environment: Windows/XP, UNIX, PL/SQL, TOAD, UNIX and Oracle9i

Confidential, Ann Arbor, MI

PL/SQL developer

Responsibilities:

  • Extensively involved in writing procedures, functions, triggers and packages
  • Involved in Analyzing and Performance Tuning of teh SQL queries using optimizer hints for joins, parallelism and Explain plan.
  • Involved in Unit Testing teh codes.
  • Involved in debugging and fixing teh codes dat had performance issues.
  • Worked with teh Table Partitions to further improve teh performance while using tables containing large number of columns and rows.
  • Used SQL*LOADER to store data in teh Oracle database from different types of flat files.
  • Provided support in SIT/UAT phases of teh project.
  • Coordinated with various project stake holders for delivery.

Environment: Oracle10g, SQL, PL/SQL, TOAD, SQL*LOADER, UNIX, Oracle Reports 10g, Linux.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Developing highly complex applications using Oracle 11g database as backend with expertise in design and development of Oracle PL/SQL packages and procedures.
  • Responsible for analyzing, Design and developing teh code logic in Oracle Forms and also worked on Oracle databases which is to develop and maintain for teh real production environments.
  • Developed Packages and customized functions and Triggers based upon teh business logics.
  • Participated in system analysis and data modeling, which included creating Tables, Views, Indexes, Synonyms, Triggers, Functions, Procedures, Cursors and Packages.
  • Utilized SQL*Loader to load flat files into database tables.
  • Used PL/SQL developing to load data from teh source table to teh target table based on teh business logic.
  • Developed conversion programs to bring Legacy details into Oracle table using SQL*Loader, PL/SQL Package and populated data into base tables.
  • Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into teh database.
  • Responsible for performance tuning activities in oracle.
  • Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.
  • Used Materialized Views in order to improve teh performance.
  • Proposed and coded enhancements on Oracle PL/SQL

Environment: Oracle Database 11g, TOAD, PL/SQL, Oracle Application Express 4.2, UNIX (Solaris), PUTTY.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Created many Generic Stored Procedures, Functions, Database Triggers, Packages, Tables, Indexes, Views, Synonyms, Sequences using SQL and PL/SQL.
  • Extensively used PL/SQL programming in back end and front end Functions, Procedures, and Packages to implement business logics/rules.
  • Extensively worked in Oracle SQL, PL/SQL, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms and Sequences.
  • Analyzed teh system requirements and performed logical and physical design of teh database.
  • Used SQL*Loader for data uploading from flat files. PL/SQL Coding and SQL tuning throughout teh development wherever needed.
  • Experience in developing Dynamic SQL and Ref cursors and Hands-on experience in writing Packages, Stored procedures, Functions, and Database.
  • Created application schema as tables, view and indexes and customized teh stored procedures and database triggers in PL/SQL.
  • Exception handling and cursor management in PL/SQL.
  • Involved in developing packages to transfer data from different Oracle forms to Oracle database, every time whenever processor do teh transactions.
  • Involved in form level coding for Approval, Data Entry, Data Query and Response Modules as per teh requirements.
  • Designed Conversion and Interface Programs using PL/SQL procedures and packages.
  • Analysis, Development, Testing and Implementation using Oracle 11g/10g.

Environment: Oracle 11g, Oracle performance tuning, SQL* loader,SQL, TOAD, PL/SQL.

We'd love your feedback!