We provide IT Staff Augmentation Services!

Sr. Oracle Pl/ Sql Developer Resume

Bridgewater, NJ

PROFESSIONAL SUMMARY:

  • Over 7+ years of experience in analysis, design, development, testing and deployment of software applications using Oracle8i/9i/10/11g.
  • Strong experience with developing Shell, Oracle and UNIX based applications.
  • Expertise includes evaluation of Data Warehouse, Oracle 10g/9i/8i, and MS Access databases on UNIX and Windows environment PL/SQL.
  • Extensive experience in building Client Server Applications using Oracle, PL/SQL, Stored Procedures, Packages and Database Triggers and working with partitions
  • Expertise in UNIX shell scripting and job scheduling.
  • Expertise in design, development and deployment of end user screens and reports using Oracle tools, Oracle Forms 10g/9i/6i/4.5, Reports 10g/9i/6i/2.5.
  • Experience in developing applications using Oracle APEX 3.2/4/4.2
  • Proficient in oracle tools and utilities such as SQL Loader, SQL developer and TOAD.
  • Involved in the design of Dimension Models, Star Schemas and Snowflake Schemas.
  • Proficient knowledge of Oracle PL/SQL (Stored Procedures, Packages, Functions, Triggers, etc) and Oracle SQL.
  • Involved in Unit Testing, Integration testing and Performance Testing.
  • Experienced in interacting with Business users, Business Analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
  • Good experience with Informatica mappings.
  • Proven ability to plan, coordinate and implement SDLC and Agile software development and maintenance projects.
  • Strong experience in SQL, SQL*PLUS, PL/SQL, back end programming using Packages, Functions, Stored Procedures, Exception handlers, Database triggers, Views, Ref Cursors, Record Types, UTL FILE and other built in packages.
  • Able to work within an aggressive and demanding project schedule and environment.
  • Highly motivated & conceptually strong individual with outstanding oral and excellent communication, analytical and interpersonal skills.
  • Excellent communication and interpersonal skills, excellent team organizing skills.

TECHNICAL SKILLS

Operating System: HP - UNIX, Linux, Windows 2003

RDBMS: Oracle 10g/9i/8i, MS Access 7.0/2000

Data Warehousing: SQL Developer ETL Processes, InformaticaPowerCenter9.1

Data Modeling: Star-Schema Modeling, Snowflakes Modeling

Programming: C, C++,PL/SQL and UNIX Shell Scripting

Tools: MS Access Reports, Oracle APEX 3.2,4,4.2, MS Office

Version Control: CVS, PVCS

Scheduler: Control M, DBMS

Web Technologies: HTML, APEX 3.2,4,4.2

Other Products: SQL*Loader, TOAD, FTP, TKPROF

WORK EXPERIENCE:

Confidential, Bridgewater, NJ

Sr. Oracle Pl/ Sql Developer

Responsibilities:

  • Provided application support for report server performance monitoring
  • Wrote loader scripts using SQL Loader/External tables to load large tables.
  • Responsible for developing and modifying several PL/SQL packages, procedures, functions, views and triggers using PL/SQL.
  • Wrote customized UNIX shell scripts used to provide additional monitoring of production servers.
  • Build custom commercial and system applications, and servers for Linux.
  • Created database triggers for data validations in Oracle.
  • Developed Shell scripts and SQL control files to load data through SQL*Loader
  • Provided SQL and PL/SQL code tuning to improve database response time and performance for several applications
  • Developed Oracle Stored Procedures, Functions and Packages to effectively incorporate Business rules
  • Worked extensively with Composite data types, Cursors and Dynamic SQL
  • Worked with Dynamic SQL, Global Temporary Tables
  • Worked onSQL*Loaderto load data from flat files obtained from various facilities every day. Created materialized views, Inline Views & normal views where business requirements needed
  • Worked in Oracle reports and forms version 6i and 10g.
  • Extensively usedbulk collectionin PL/SQL objects for improving the performing
  • Developed stored procedures and packages. Extensive work in PL/SQL.
  • Developed Reports and forms using Oracle Designer.
  • Worked with development of packages and procedures using PL/SQL and functions using ETL and PL/SQL.
  • Involved in analysis, development, testing, and 24 x 7 production support.
  • Resources are needed to help support additional applications that will be acquired by our team.

Environment: UNIX, Oracle 11g, PL/SQL, SQL*Plus, SQL*Loader, Microsoft Excel,TOAD, PL/SQL Developer, SQL*Loader, Reports6i, Toad

Confidential, Chicago, IL

Oracle PL/SQL Developer

Responsibilities:

  • Collaborated on the development of a high-level transition plan to re-platform OFF in a UNIX/Linux environment
  • Defined business requirements and developed Technical Design Document for programming
  • Designed and Developed back-end routines using Oracle PLSQL, Stored procedures/Packages, Triggers and SQL*loader.
  • Wrote UNIX Shell scripts to generate daily reports for credit class updates of customers.
  • Automated jobs through Autosys for creating Mass Adjustment Files to find customer accounts to be charged for late payments.
  • Worked on range partitioning of history tables in order to improve batch performance.
  • Implemented modifications to the existing code to add a memo to a customer account through API.
  • Worked on Pro C* programs and sql scripts to generate full extracts of large tables.
  • Created daily reports of customer accounts which needed to be notified for adding a memo.
  • Used advanced SQL and analytical functions in various queries.
  • Used package like DBMS JOB to determine if there are any jobs that are to be performed, or any changes are made to the program or procedure.
  • Created Parameterized Reports and Customized Existing Reports for presentations using Cross-Tab reports and Sub-reports and Running Totals/Formulas in crystal report.
  • Used for all and bulk collect to fetch large volumes of data in PL/SQL objects.
  • Automated repetitive processes by writing shell scripts.
  • Worked on accessing the application interface that integrates the internal applications with the billing system.
  • Developed complex procedures to handle errors and exceptions at the database level using PL/SQL.
  • Tested application in Unit Test and deployed applications into the production server.
  • Consistently coordinated with production support and also responsible for estimating the time factor for several jobs depending upon the data volume size.
  • The role required extensive interactions with Business Managers and Users

Environment: UNIX, Oracle 9i/10g, PL/SQL, SQL*Plus, SQL*Loader, TOAD, PL/SQL; SQL; SQL LOADER, Toad, Oracle database 10g; Oracle Application Server 10g

Confidential, Bellevue, WA

Oracle Developer

Responsibilities:

  • Reviewed and provided feedback on Requirements, Functional Specifications, Data Models, and Design Documents. to ensure the quality of SDLC deliverables and the quality of tests to be developed from the Preparation.
  • Created design documents to be reviewed by architect.
  • Worked on the bulk uploading of huge amounts of statistical data to the database.
  • Responsible for developing and modifying several PL/SQL packages procedures, functions, views and triggers using PL/SQL to effectively incorporate Business rules.
  • Analyzed data integrity problems and provided assistance in giving solutions.
  • Worked extensively with Composite data types, Cursors and Dynamic SQL
  • Worked with Dynamic SQL, Global Temporary Tables, materialized views, Inline Views & normal views
  • Created many batch scripts using Unix KSH scripting and scheduled in Cron Tab
  • Fine tuned database procedures and Oracle PL/SQL scripts for performance tuning.
  • Knowledge of Oracle reports and forms version 6i and 10g.
  • Extensively usedbulk collectionin PL/SQL objects for improving the performing
  • Extensively worked in the performance tuning of ETL mappings and sessions.
  • Extensively used transformations like lookups (connected and unconnected), Update Strategy, Joiner, Router, Sorter, Aggregator, Expression, Rank, Sequence Generator and others.

Environment: UNIX, LINUX, Oracle 11g, PL/SQL, SQL*Plus, SQL*Loader, Microsoft Excel,TOAD, Java, Cron Tab, SQL, PL/SQL Developer, SQL*Loader

Confidential

Software Engineer

Responsibilities:

  • Developed procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements
  • Monitoring existing code and doing performance tuning if necessary.
  • Wrote database triggers for audit and data validation.
  • Wrote SQL Statements, Stored Procedures, Functions, and Packages to accommodate the new business requirements, business rules, and changes using SQL Navigator, SQL* Plus, and TOAD.
  • Developed a debug methodology for tracing the payment details using Stored Procedures and Functions
  • Developed Laureate Custom Forms and integrated with Banner Forms and Banner Database.
  • Developed Forms using Oracle Forms 10g for Laureate Employee Training Application (LMS) which also involved analysis, design, development and migration to UNIX box and deployment on web.
  • Expertise in PLSQL attached libraries, Functions, Triggers in Forms.
  • Involved in writing low-level specifications for screens designed

Environment: Oracle 9i, Developer/2000, Windows, SQL*Plus, PL/SQL

Hire Now