We provide IT Staff Augmentation Services!

Pl/ Sql Developer Resume

Herndon, VA

SUMMARY:

  • Over 6+ years of experience in Application Development using Oracle 10g/11g, PL/SQL, and Developer Forms 6i/11g and Reports 6i/11g.
  • Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.
  • Strong Knowledge on Oracle Architecture and Database Design.
  • Solid experience in developing client - server applications using Oracle 11g/10g/9i/8i, SQL & PL/SQL, SQL*Plus, SQL*Loader and Toad.
  • Experience in Database design using Normalization and E/R Diagrams.
  • Rich experience in writing SQL Queries, Views, Materialized Views, PL/SQL Procedures, Functions, Packages, Triggers, Cursors, Collections, Ref Cursor, Cursor variables, System Reference Cursor, Dynamic SQL, Exceptions.
  • Experience in designing business requirements and modeling using oracle designer.
  • Experience in developing External Tables, Joins, Indexes and sequences.
  • Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
  • Extreme Use of Exception Handling methods along with Pragma Exception init in order to associate our own created exception names.
  • Experience in using several built-in database packages such as DBMS JOB, DBMS OUTPUT, UTL MAIL, UTL FILE, and DBMS SQL to name a few.
  • Experience in using DBMS SCHEDULER to run jobs in parallel to improve time-constrained performance.
  • Have experience on archive platform that provides high performance and highly scalable archiving support.
  • Experience in Dynamic SQL, Oracle supplied Packages, Records, PL/SQL Collections and Exception handling.
  • Expertise in loading data from legacy systems using SQL*Loader.
  • Good knowledge in front end development using Oracle Forms/Reports6i/9i/10g.
  • Hands on experience PostgreSQL database by shadowing senior DBA's with extensive knowledge of PostgreSQL versions 7 and 8.
  • Experience in Developing Forms based on Views, Tables and Procedures in tabular and form layouts.
  • Experience in developing both Web Layout and Paper Lay out Reports in various styles based on the user requirements.
  • Extensively worked with third party database tools like TOAD & PL/SQL Developer.
  • Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
  • Good in creating users and maintaining their roles and responsibilities.
  • Experience in writing Technical Design Documents and Developing Unit Test Documents.
  • Experience working on different applications using UNIX shell-scripting.
  • Had working experience with .net and java developers.
  • Had experience working and good understanding on jdbc and LINQ for front end to back end connectivity.
  • Had experience in front-end back-end web site development, website conversion to java j2ee
  • Had working experience with jdbc.
  • Good knowledge and experience working in Java using jdbc, HTML, XML.
  • A Self-starter with a positive attitude, willingness to learn new concepts and accept challenges.
  • Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.

TECHNICAL SKILLS:

Databases : Oracle 11g/10g/9i/ 8i, DB2, Teradata v2r5

Scripting : SQL,UNIX, and PERL.

GUI: Oracle Forms 10g/9i/6i/5.0/4.5& Reports 10g/9i/6i/3.0/2.5, OWB

Languages : SQL, PL/SQL, C, PostgreSQL, HTML, XML, java script, CORE JAVA, UNIX.

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

OS : Windows7/ VISTA/NT/2000/98/95, DOS 6.0/3.0, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Herndon, VA

PL/ SQL Developer

Responsibilities:

  • Involved in designing ER diagram using oracle designer, to set the logical and physical relationships of database.
  • Created complex stored procedures to collect, analyze, and report on data across multiple functional and line of business systems in response to customer requirements.
  • Loaded the data into database tables using SQL*loader from text and excel files.
  • Developed data models, SQL Queries, SQL Query tuning process and Schemas.
  • Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
  • Migration of dbms jobs to control M.
  • Migrated data to and from production Oracle databases in PostgreSQL databases.
  • Used tortoise svn version control for changing the codes.
  • Making changes to the existing apex applications in the production.
  • Created SQL*plus reports as per client's various needs, and developed business objects.
  • Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
  • Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
  • Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in pl/sql blocks and even have experience with exception handling..
  • Used numerous techniques to help clients extract, transfer, and load their production data from other database systems, such as Oracle and MS SQL Server, and use it in their PostgreSQL environments.
  • Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
  • Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
  • Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
  • Archived many applications in the existing system and retrieval of necessary data from them.
  • Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
  • Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
  • Converted T-SQL to PL/SQL or vice versa to report data consistency across multiple databases and created business rules to report all expected missing/defect data.
  • Developed UNIX Shell scripts to automate table creation, execute procedures.
  • Used ORACLE sql DEVELOPER for creating PL/SQL (trigger, sequence, stored procedure).

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

Confidential, Columbus, OH

PL/ SQL Developer

Responsibilities:

  • 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 the ETL mappings in PL/SQL via packages, procedures, functions, views and triggers.
  • Involved in developing Data models, Data dictionaries, mapping documents and cross functional documents across systems for all the ETL needs.
  • Developed Packages, Functions, Stored Procedures and SQL Scripts using PL/SQL.
  • Worked on SQL*Loader to perform bulk data loads into database tables from external data files.
  • Used Explain Plan, SQL*TRACE, TKPROF for tuning the SQL statements by creating indexes.
  • Worked for client’s needs using SQL*plus reports and developed business objects.
  • Used Oracle packages like DBMS STATS to collect statistics of many different kinds as an aid to improve the performance and UTL FILE to read and write operating system text files.
  • Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
  • Extensively used Bulk Collections to insert and update huge amount of data into target databases.
  • Created SQL and PL/SQL scripts to detect data defects/anomalies in systems.
  • Developed Control files, SQL*Loader scripts, migration and backup of Oracle data
  • Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 6i and Oracle Forms builder 6i respectively.
  • Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
  • Using Swing Concepts in Java Front End Forms are designed.
  • Using Oracle developer Database tools to write triggers and procedures, Function.
  • Archived many applications in the existing system and retrieval of necessary data from them.
  • Worked with java developers to fix production issues and improved processing time through code optimizations and indexes.
  • Performed administration of all database objects and performance tuning of user applications.
  • Using perl script for database connectivity using DBI which connects to backend database drivers.
  • Developed UNIX Shell scripts to run SQL scripts daily, execute procedures.
  • Extensively used PL/SQL to implement cursors, triggers and packages and to develop stored procedures, functions.

Environment: Oracle 11g/10g, SQL, PL/SQL, TOAD 9.1/10.5, VI editor, Unix Shell Script, MKS, FileZilla FTP tool, SQL loader, JAVA.

Confidential, Pataskala, Ohio

PL/ SQL Developer

Responsibilities:

  • Involved in analysis, Design, Development phases of the project.
  • Designed ER diagram using Erwin, to set the logical and physical relationships of database.
  • Involved in walkthrough sessions with business users during Analysis and Designing phase. Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.
  • Involved in implementing the data integrity validation checks through constraints and triggers.
  • Extensive use of XML.
  • Writing SQL reports and scheduling these reports from UNIX scripts.
  • Created SQL*Loader control files for moving the data from flat files to staging area tables.
  • Worked on performance issues and used EXPLAIN PLAN for tuning the queries
  • Worked with Bulk Collections for bulk load processing. Involved in code walk through and review sessions with the development team.
  • Involved in the migration project to load data from mainframe systems into oracle database.
  • Involved in Troubleshooting Performance issues and bugs within packages and stored procedures using dbms output and Explain Plan.
  • Performance of the queries is enhanced by executing optimization techniques such as Index Creation, Table Partition and Coding Stored Procedures.
  • Involved in developing data conversion programs using SQL *Loader, PL/SQL and UNIX Shell Scripts.
  • Developed Master Detail reports in Reports 6i to meet the requirements of end users within the system.
  • Developed Data Entry Forms, complex and template forms in Forms 6i.Creation of Pop-up Menus and maintaining Master Detail relation-ship.
  • Development of client side program units and sharing them among multiple applications for processing business logic in the database.

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

Confidential, New York

PL/ SQL Developer

Responsibilities:

  • Developing SQL and PL/SQL scripts for problem solving.
  • Generating reports using Report builder
  • Establish onsite/offshore communication between onsite users and offshore project teams.
  • Tracking and ensuring timely deliveries as per SLAs committed to the client.
  • Interacting with the client and project teams to ensure issue resolution and to provide technological and business solutions to the clients.
  • Interacted with the Business Analysts in understanding the business requirements for the project.
  • Gathered the requirements from the users and analyzed their business needs and created SRS documents.
  • Involved in SDLC including designing, coding and testing.
  • Created database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus, PL/SQL and TOAD.
  • Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
  • Using associative array from perl programming for indexing and performance issues in unix environment.
  • Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
  • Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
  • Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.

Environment: Oracle9i, Windows XP/2000, SQL, PL/SQL, SQL*PLUS, UNIX, SQL*Loader, UNIX Shell script, TOAD, Java.

Hire Now