We provide IT Staff Augmentation Services!

Senior Oracle Pl/sql Developer Resume

5.00/5 (Submit Your Rating)

Waltham, MA

SUMMARY

  • Over 7 years of experience in Database development using Oracle, SQL, PL/SQL and Oracle Developer Forms and Reports.
  • Experience with Software Development Life Cycle (SDLC) process, performing detailed analysis, collecting requirement, coding, integration and system testing.
  • Proficient in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
  • Experience in developing PL/SQL Stored Procedures, Functions, Packages, Database Triggers using features like cursors, collections, Exception Handling and good in developing Developer Forms and Reports.
  • Experience in Database design using Normalization and ER Diagrams.
  • Experience in loading data from sub systems using SQL * Loader, External tables and UTL FILE.
  • Worked with various performance tuning techniques using tools provided by Oracle like EXPLAIN PLAN, SQL Trace, TKPROF, Oracle hints, DBMS PROFILER, DBMS STATS.
  • Experience with Client interaction, adherence to client specifications, system enhancements, understanding business data flow, data relations and Level3 Production system support.
  • Good understanding of Relational database design and developed various data models using Erwin.
  • Extensively worked with third party database tools like TOAD and SQL Developer
  • Ability to program UNIX shell scripts in applications that schedule, validate flat file data, Execute SQL, archive files or FTP files.
  • Expertise in Creating and Maintaining Database objects like Tables, Indexes, Views, synonyms etc.
  • Expertise Knowledge on Extraction, Transformation and Loading process (ETL).
  • Experienced in Unit testing and Integration testing with excellent debugging skills.
  • Knowledge in design and setup of Backup and Recovery Strategy for various databases.
  • Experienced in Performance Tuning and Optimization of SQL statements.
  • Knowledge in Test Scripts, Test Cases, and SQL QA scripts to perform Unit testing, System Testing and Load testing.
  • Working knowledge of Migration of Code from Development to Testing, UAT and Production.
  • Excellent analytical and communication skills those are required effectively to work in the field of applications development and maintenance.
  • Strong individual contributor and a good team player with proven abilities to interact negotiate and communicate with peers and clients.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i, Oracle Application Express, Microsoft SQL Server 2008, My SQL

Languages: SQL, PL/SQL, C, C++, HTML, XML, UNIX Shell Scripting, T - SQL, SAS

Tools: Rapid SQL, Informatica Power Center, SQL * Loader, TOAD, SQL * PLUS, SQL Navigator, Autosys, UTL FILE, ODI

Designing/Others: MS- Office, MS-Visio, VI Editor, WebEx, Erwin, SVN, CRM, Crystal Reports, Oracle Forms and Reports

Operating Systems: Windows, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential - Waltham, MA

Senior Oracle PL/SQL Developer

Responsibilities:

  • Involved in requirements gathering, attended meetings with the users to gather requirements along with the business analyst.
  • Worked with External Tables to access and import the required information.
  • Developed the user interface using theOracleAPEXdepending on the requirements and built custom applications.
  • Created PL/SQL Tables, Collections, Records, Partitions and Used Dynamic SQL and triggers for faster data access and to in corporate business logic.
  • Worked on Table partitioning and Index creation to improve the performance of the query.
  • DevelopedPL/SQLtriggers and master tables for automatic creation of primary keys.
  • Worked on tasks like file frequency, where an email fromoraclehas to be sent when there is any delay in receiving the file from dealer and also check the status of the file.
  • Involved in Requirement Gathering, High Level Design, Low Level Design, Development, Unit testing & Integration Testing of Data Migration process using ETL Methodology.
  • Created mappings and workflows for data migration using Informatica Power Center.
  • Used Authorization Schemes functionality ofAPEXto set up security on the screens in the application based on user roles.
  • Optimized theOraclePL/SQL queries by Performance Tuning.
  • Report the project status and generate milestone reports.
  • Developed ETL jobs using ODI tool for data migration operations.
  • Communicate with developers, database administrators, project managers, Systems analysts and senior management about the issues that impact the project's success.
  • Created a risk plan and listing all the mitigations.
  • Involved in Facilitating and documenting the post implementation results in the form of closure reports.
  • Involved in the ETL process of developing new tables from the existing views and materialized views.
  • Extensively used the advanced features ofPL/SQLlike Records, Tables, Object types and DynamicSQL.
  • Participated in requirements review, application design review and test plan reviews

Environment: Oracle application Express,Oracle 11g/10g, SQL,PL/SQL,SQL*Plus, Shell Scripts,SQL Plus, Informatica 9.x,SQLDeveloper, UNIX, Windows 7, Windows XP

Confidential - Eden Prairie, MN

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
  • Involved in designing ER diagram using Erwin, to set the logical and physical relationships of database.
  • Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
  • Involved in creation of Conceptual Modeling covering all the business requirements.
  • Loaded the data into database tables using SQL*loader from text and excel files.
  • Developed data model, SQL Coding, SQL Query tuning process and Schemas.
  • Created SQL*plus reports as per client's various needs, and developed business objects.
  • Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
  • 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.
  • Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
  • Worked on UNIX k-shell to start and monitor the CRON jobs on the server.
  • 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 custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
  • Developed Master Detail, Detail reports using tabular and Group above reports.
  • Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
  • Developed Shell Scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
  • 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.
  • Developed UNIX Shell scripts to automate table creation, execute procedures.
  • Created some oracle objects for OLAP.
  • Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 11g, SQL, PLSQL, SQL*Loader, KORN Shell script, Erwin 4.1.4, SQL developer, Oracle Forms 10g, Reports10g.

Confidential - Ada, MI

Sr. PL/SQL Developer

Responsibilities:

  • Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements.
  • Co-ordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • Implemented Complex Business Logic as per the client requirement in procedures, functions, packages.
  • Involved in data modeling team for identifying tables and relations between them.
  • Built complex queries using SQL and wrote stored procedures using PL/SQL.
  • Responsible for data migration from MS Access to Oracle 11g.
  • Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.
  • Creation of database objects like tables, views, Indexes on tables, synonyms, materialized views, Stored procedures, packages using oracle tools like SQL* plus.
  • Used Ref cursors and Collectionsfor accessing complex data resulted from joining of large number of tables.
  • Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
  • Used PL/SQL tables, pragma autonomous transaction to avoid mutating problem in database trigger.
  • Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
  • Involved in moving the data from flat files to staging area tables using SQL * Loader.
  • Worked onSQL Loader control file for flat file data from other departments and scheduled them in UNIX to load every night in Production Environment.
  • Extensively used for all and bulk collect to fetch large volumes of data from table.
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
  • Performed performance tuning using the DBMS PROFILER package, this checks the run time behavior.
  • Involved in data migration from Production to test and created test data for analyzing problems, providing solution.
  • Worked closely with Production Support team to Troubleshoot and fix any production issues.
  • Managed problems, enhancement, and new functionality requests to meet changes in the business needs.

Environment: Oracle 11g, SQL, PL/SQL, TOAD, ERWIN, SQL*Loader, SQL*Plus UNIX, Windows XP.

Confidential - Irving, TX

PL/SQL Developer

Responsibilities:

  • Studied user requirements and functional specifications.
  • Converted User Requirements into formal Functional specification and Interfacing with client.
  • Designed, Partitioned, Developed and Maintained the database.
  • Worked to define the project implementation strategies.
  • Developed Entity Relationship diagrams/Dimensional Diagrams for business requirements using ERWIN.
  • Designed and developed Oracle Forms & Reports using Forms10g and Reports 10g. Including Forms based on stored procedures.
  • Developed ETL processes for Data Extraction, Data Mapping and data Conversion using SQL, PL/SQL and various shell scripts in Data stage.
  • Involved in writing Oracle PL/SQL functions, procedures and packages in Oracle RAC environment.
  • Written Bash Shell scripts that were used for staging, transformation and loading of the data into base tables.
  • Used CRONJOB for job scheduling on UNIX as well as tools like Autosys to run regular day to day administration scripts and setting up batch scripts.
  • Developed the stored procedures using PL/SQL Tables and records to generate the output in XML format and pull data from Web services and from XML format and parse it and load it into tables.
  • Enhancing the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
  • Used Bulk processing for performance enhancement.
  • Created UNIX shell scripts using SQL*Loader, SQL*Plus and PL/SQL programs that run as nightly interfaces.
  • Worked on generating EDI for STA, ASN segments and few custom based invoices belonged to Invoice, Status and Entry and Generic EDI for most of the customers for the EMS application.
  • Written shell scripts and executed them on UNIX.
  • Was responsible for development and testing of conversion programs for importing data from text files into Oracle database utilizing SQL *Loader.
  • Conversion of forms 6i to forms 10g along with Data conversion (legacy system to oracle).
  • Loading the Target Warehouse Using Process Flows and viewing Data in the Data Viewer
  • Managing Metadata Using the Dependency Manager and administering the Warehouse Using the Repository Browser
  • Created and modified SQL*Loader scripts for migrating flat file data into target.
  • Involved in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes.
  • Generated DDL statements for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures. Developed Database Triggers to enforce security also used ref cursors.
  • Involved in conversion/migration of database from Access, SQL Server, DB2, flat files to Oracle data warehouse. Wrote PLSQL and T-SQL blocks, Procedures, Functions, Packages for Migration of flat files and to transfer in exact format in Database Tables.

Environment: Oracle 10g/11g, PL/SQL, SQL Plus, Erwin 7.3,SQL Navigator, XML, Shell Scripting, SQL*Loader, Shell Scripting, AIX, SQL developer, Data stage, Reports 10g/6i, CSS, DBMS JOB, UTL FILE, UNIX.

Confidential

Oracle Developer/Data Analyst

Responsibilities:

  • Involved in Database Design and Analysis.
  • Analyzed and Created Partitions on the tables to improve the performance and enhance parallel processing.
  • Design and Developed data validation, load processes using PL/SQL, Stored Procedures, Functions, and Triggers using Oracle 9i.
  • Created Control Files and used SQL* Loader to upload bulk data into database from external files.
  • Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.
  • Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages
  • Involved in Code Standardization and Documentation.
  • Involved in Logical and Physical Database design and Star Schema design. Identified Fact tables, Transaction tables.
  • Used for all and bulk collect to fetch large volumes of data in PL/SQL objects.
  • Involved in database Performance Tuning and monitoring.
  • Designed Report output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
  • Developed complex triggers in reports before/after for validation of user input.
  • Coordinated between management, users and technical teams for Requirement Gathering
  • Involved in various activities like preparation of Technical Documentation, Client Discussions for purposed solution and User Acceptance Testing.

Environment: Oracle 9i, SQL*Plus, SQL, PL/SQL, MS Office, MS Access, UNIX, Windows XP.

We'd love your feedback!