We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

Warren, NJ

PROFESSIONAL SUMMARY:

  • 9 years of experience in analysis, design, development, testing and implementation of application software as Oracle PL/SQL developer.
  • Expertise in SQL and PL/SQL programming and strong Knowledge on oracle architecture and database design.
  • Solid experience in vertical segment Retail, Banking, Financial management system and Health Care.
  • Expertise in using tools such as TOAD, SQL developer, PL/SQL developer.
  • Strong knowledge of Oracle 9i/10g/11g, PL/SQL.
  • Oracle Import/Export Utilities &SQL*Loader.
  • Strong understanding of Data modeling in data warehouse environment such as star schema and snow flake schema.
  • Experience in Migrating Data to Oracle database.
  • Excellent Analytical, conceptual and root cause analysis and problem solving skills.
  • Strong Experience in designing and developing oracle objects Tables, Views, Indexes PL/SQL Packages, Functions, Stored Procedures, and Triggers.
  • Strong knowledge in Oracle Cursor management, Exception Handling, REF Cursors
  • Worked on advanced PL/SQL constructs like Oracle supplied packages, Collections, Nested Tables, VARRAYS, Records, Types, and Dynamic SQL and Analytical functions.
  • Experience as an Applications DBA including creating and managing schemas, tables, constraints, indexes, and materialized views and managing database.
  • Experience in PL/SQL collections, Bulk collections and Exception handling.
  • Extensively worked with various SQL scripts for relational databases.
  • Experience in Oracle Application server for the Forms and Reports, Crystal reports application in various projects.
  • Involving in creating the Command line, Box and File watcher jobs using the scheduler tool AutoSys 4.0 and AutoSys r11.3 versions.
  • Extensively worked on PL/SQL features like Forms, Triggers, Data blocks, Report Layout, Parameter forms, Report Triggers.
  • Experience in designing and developing various reports using Oracle Reports
  • Good understanding of Oracle Data Dictionary, RDBMS and Normalization techniques.
  • Experience with database query optimization and performance tuning using Explain Plan, SQL - Trace, TK-Prof oracle utilities and creating relevant system and users documentation
  • Extensively worked on Triggers for implementing complex data integrity checks and for auditing tables.
  • Experience in Database modeling and database object definitions using tools like Oracle Designer.
  • Experienced in Unit testing and Integration Testing with excellent debugging skills.
  • Developed and Modified PL/SQL packages, functions, Procedures as per customer requirement to make new enhancements or to resolve problems.
  • Worked on Agile methodologies
  • Worked with SQL QUIRES advanced DML and DDL
  • Strong knowledge in oracle apps modules, Finance(AP,AR,GL) and SCM (PO,OM,INV)
  • Working experience in data extraction, transformation and loading operations into oracle using SQL Loader, Export/import and UTL FILE to read and write the files.
  • Ability to program UNIX shell scripts in applications that schedule, validate flat file data, execute SQL, archive files or FTP files.
  • Great Team player with Strong interpersonal skills, communication skills and documentation skills

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Java, SQL Server

Scripting Languages: Unix Shell Scripting

Markup Languages: XML, XSLT

XML Technologies: XML, XSL (XSLT, XPATH)

Database: Oracle 12c, 11g, 10g, 9i

Database Tools: Toad, SQL Developer, PL/SQL Developer, SQL * Plus

Version Control: Poly Version Control System(PVCS)

Reporting and oracle Tools: RDF Reports 6i/9i/10g/11g,XML Publisher Reports, Crystal Reports and Forms 6i/9i/10g

Data Migration Tools: SQL Loader, Multiload

ETL Tool: Informatica

Operating Systems: Windows 8, Windows 7, Windows 2008/2003/2000/ NT/XP

PROFESSIONAL EXPERIENCE:

Confidential, Warren, NJ

Oracle PL/SQL Developer

Responsibilities:

  • To interact with business community and gather requirements based on changing needs.Incorporated identified factors into Informatica mappings to build Data Warehouses.
  • Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer 8.6 to extract the data from multiple source systems that comprise databases like SQL Server 7.2, flat files to the Staging area, EDW and then to the Data Marts.
  • Involving in creating the Command line, Box and File watcher jobs using the scheduler tool AutoSys 4.0 and AutoSys r11.3 versions.
  • Involve in the data analysis for source and target systems and good understanding of Data Warehousing concepts, Staging Tables, Dimensions, Facts and Star Schema, Snowflake Schema.
  • Involving in redesign of the Application according to the new business requirements by creating the Partitioned tables and indexes for better performance of application.
  • Involving in tuning SQL queries by using EXPLAIN PLAN.
  • To use Oracle Golden Gate OGG systems on Oracle 11g RAC environments Back-end: Oracle
  • Exadata X4 Full Rack .
  • Developing many process improvements using the Bulk Collect and FORALL (Bulk Bind) methodology and also by using hints for queries.
  • Involving in developing UNIX shell scripts for Loading Database Tables, running SQL files,Packages and Procedures.
  • Design and develop UNIX shell scripts to schedule jobs. Also write pre-session and post-session shell scripts, Write PL/SQL scripts for dropping, rebuilding indexes.
  • Perform Configuration Management to Migrate Informatica mappings/sessions/workflows from Development to Test to production environment.
  • Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and Reporting system and also to successfully implement business logic.
  • Use Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.

Environment: Oracle/PL/SQL, ETL informatica, Unix, TOAD, SQL*Plus, SQL*Loader, Shell Scripting,oracle 11g/12C

Confidential, Baskin Ridge,NJ

Oracle PL/SQL Developer

Responsibilities:

  • Developed PL/SQL Stored packages, Procedures, Functions, Collections, Object Types, Triggers.
  • Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines
  • Developed PL/SQL blocks using Collections like Nested Tables and VARRAYS, Cursors, Bulk collections and Exception handling.
  • Responsible for SQL tuning and optimization using Explain Plan and optimizer hints
  • Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
  • Extensively worked on Physical Inventory like cleaning inventory files, creating snap shots, loading tag count adjustment between Physical Inventory and Perpetual Inventory
  • Designed and developed oracle plsql reports generating up to 8 reports
  • Monitoring Jobs and running SQL queries to fix invalid SKU’s and fixing the orders struck in Ecom
  • Loaded the data into database using the SQL*Loader from various sources.
  • Developed new reports (Inbound receipts, Receiving - Carton Controlled Boxes) in report2web.
  • Worked on Open orders report for IORL in report2web.
  • Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
  • Worked on scripts and created Shell Scripts for invoking SQL scripts various IT Requests for IMS .
  • Developed Complex SQL queries using various Joins, Sub-Queries, Analytical and Group Functions and developed various dynamic SQL’s thorough out the projects.
  • Created packages to identify the duplicate customer numbers and updating the customer with new values
  • Developed PL/SQL Procedures Confidential the database level that were used in the mappings through Stored Procedure Transformation.
  • Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
  • Extensively used bulk collection in PL/SQL objects for improving the performing
  • Developed UNIX shell scripts functions to convert from dos to UNIX scripts
  • Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
  • Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.
  • Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
  • Worked Used SQL*Loader as an ETL tool to load data into the staging tablesTest case/data preparation, execution and verification of the test results.

Environment: Oracle/PL/SQL, Unix, TOAD, SQL*Plus, SQL*Loader, Shell Scripting.

Confidential, Atlanata, GA

Oracle PL/SQL Developer

Responsibilities:

  • Developed various PL/SQL stored procedures and functions
  • Wrote PL SQL scripts and used couple of metadata tables to do Data Profiling, Referential Integrity and Data Quality before loading data into staging area.
  • Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
  • Implementing logical and physical data modeling with STAR schema using Erwin in Data Marts in Data warehousing.
  • Knowledge in Data warehousing for creating of fact tables
  • Development of the Mappings, Lookups, reusable components, Sessions, Workflows
  • Coordinated with DBA in creating and managing Tables, Indexes, Table spaces, Triggers, DB Links and Privileges
  • Developed back end interfaces using PL/SQL Stored packages, Procedures, Functions, Collections, Object Types, Triggers.
  • Developed PL/SQL Procedures Confidential the database level that were used in the mappings through Stored Procedure Transformation.
  • Responsible for SQL tuning and optimization using Explain Plan, TKPROF utility and optimizer hints
  • Utilized SQL*Loader to load flat files database tables.
  • Handled various exceptions to troubleshoot PL/SQL code.
  • Formulated procedures, functions and packages; ensured that the quality, programming and project management standards were met.
  • Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table
  • Used Bulk Collect feature to improve performance.
  • Created indexes on tables for fast retrieval of data.
  • Developed Complex SQL queries using various Joins, Sub-Queries, Analytical and Group Functions and developed various dynamic SQL’s thorough out the projects.
  • Worked with SQL QUERIES advanced DML and DDL
  • Used PL/SQL programming to develop Stored Procedures, Functions and Database Triggers including standard packages like DBMS SQL, DBMS XPLAN, DBMS PROFILER, DBMS JOB, and UTL FILE.
  • Designing and rebuilding indexes for faster overall data processing.
  • Gathering the requirements through meetings with the Business Users
  • Tuned Report performance by exploiting the Oracle’s built-in functions and rewriting SQL statements.
  • Worked closely with end-users and team members to understand business requirements that drive the analysis.
  • Test case/data preparation, execution and verification of the test results.
  • Responsible for documentation of all the project developments and modulations as per the standards defined and the system requirements.

Environment: Oracle 11g, TOAD, SQL * Loader, Windows XP

Confidential, Herndon, VA

Oracle PL/SQL Developer

Responsibilities:

  • Developing highly complex applications using Oracle 10g database as backend with expertise in design and development of Oracle PL/SQL packages and procedures.
  • Involved in the design of Data-warehouse using Star-Schema methodology and converted data from various sources to oracle tables.
  • Responsible for analyzing, Design and developing the code logic in Oracle Forms and also worked on Oracle databases which is to develop and maintain for the real production environments.
  • Developed Packages and customized functions and Triggers based upon the 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.
  • Created PL/SQL based ETL process to transfer data from sources.
  • Used PL/SQL developing to load data from the source table to the target table based on the business logic.
  • Developed conversion programs to bring Legacy details into Oracle table using SQL*Loader, PL/SQL Package and populated data into base tables.
  • Created PL/SQL blocks using Cursors, REF Cursors, Collections - Nested Table, various Complex Triggers
  • Designed and developed Web-enabled Oracle Forms & Reports.
  • Worked on Forms Triggers, Alerts, Data Blocks, LOVs, Parameters and Program Units by using PL/SQL procedures and functions
  • Analyzed data, designed and developed Oracle forms, layout, report triggers, parameter form, data models
  • Developed complex triggers in reports before/after for validation of user input on the application system.
  • Developed UNIX shell scripts to provide a user interface to Oracle Forms and Reports.
  • Worked on Oracle Web Apache Server for configure of upload and download with the required Oracle forms refers to a class of systems that facilitate and manage transaction-oriented applications, typically for data entry and retrieval transaction processing.
  • Tested the Forms, debugged and fixed it after the testing
  • Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
  • Responsible for performance tuning activities in oracle.
  • Involved in designing numerous Oracle Forms and Reports by interacting directly with End Users and Business Analyst.
  • Worked and developed different forms and reports

Environment: UNIX, oracle forms10g,oracle Reports, Oracle Database 10g, TOAD,PL/SQL, Oracle Developer Suite 10g, PUTTY.

Confidential, Richmond, VA

ORACLE DEVELOPER

RESPONSIBILITIES:

  • Designed and developed the interface program to Import item master using SQL*Loader,
  • PL/SQL package and Import through Concurrent program.
  • Involved in customization of Oracle Forms, Oracle Reports.
  • Created views, procedures, and functions, packages in the Oracle Database using PL-SQL, SQL/PLUS, and TOAD.
  • Designed and developed several mappings to load data from Source systems to ODS and then to Data Mart.
  • Involved in the design of Data-warehouse using Star-Schema methodology and converted data from various sources to oracle tables.
  • Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.
  • Used Materialized Views in order to improve the performance.
  • Worked on queries using SQL and wrote stored procedures using PL/SQL in Various API’s in Java, Oracle and Access.
  • Experience with ETL involving large amount of data, in particular XML parsing and loading into Oracle, Oracle XML Packages.
  • Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.
  • Worked with SQL QUERIES advanced DML and DDL
  • Test case/data preparation, execution and verification of the test results.
  • Responsible for documentation of all the project developments and modulations as per the standards defined and the system requirements.
  • Made Forms customization on various existing forms.
  • Developed many complex reports using Oracle Reports 6i
  • Maintained and developed user requested features to a web based Warehouse Catering
  • Designed and developed front-end applications using Oracle Forms 6i.
  • Extensively used SQL Developer for database access and PL/SQL Development.
  • Developed XML reports as per the requirement in Oracle Reports.
  • Worked on Agile methodologies
  • Process payments automatically and manually in case of exceptions.
  • Involved in developing test plans and test cases based on high-level and detailed designs.
  • Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: Oracle/PL/SQL,Unix, TOAD, SQL*Plus, SQL*Loader, Shell Scripting.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Developed various PL/SQL stored procedures and functions
  • Involved in Forms personalization with addition of extra information through Descriptive Flex-fields
  • Created and customized output format in XML, new templates for XML/BI Publisher to display the reports in client requirement format.
  • Upgraded Oracle reports and BI publisher reports for financials (AP, AR, GL).
  • Developed custom reports using oracle reports 10g.
  • Developed a custom Customer Statement rtf Report using BI publisher.
  • Loaded data from Existing database schema to new schema using Oracle Packages.
  • Used PL/SQL programming to develop Stored Procedures, Functions and Database Triggers including standard packages like DBMS SQL, DBMS XPLAN and UTL FILE.
  • Utilized SQL*Loader to load flat files database tables.
  • Involved in Writing, debugging and optimizing PL/SQL code.
  • Involved in migrating database from Oracle 9i to 10g database.
  • Involved in the ETL process of developing new tables from the existing views and materialized views.
  • Developed PL/SQL blocks using Collections like Nested Tables and VARRAYS, Bulk collections and Exception handling.
  • Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
  • Worked in SQL, PL/SQL development and database support as well as maintenance.
  • Developed and implemented various migration scripts for various schema objects migration.
  • Worked on complex queries PL/SQL packages, functions, stored procedures, triggers, views
  • Performing Unit, Integration and System testing, and setting up UAT for the project modules.
  • Used EXPLAIN PLAN, TKPROF to tune SQL queries.
  • Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
  • Worked closely with end-users and team members to understand business requirements that drive the analysis.
  • Responsible for requirements gathering from Clients and implement the back end changes in existing product and in designing the database.

Environment: Oracle 9i,10g, Oracle forms 6i/10g, Oracle Reports 6i,Crystal reports, EBS, Unix, TOAD, SQL*Plus, SQL*Loader, XML Publisher, Shell Scripting.

Confidential

PL/SQL Developer

Responsibilities:

  • Developed the SQL*Loader script, and most of PL/SQL stored procedures, Triggers, and views
  • Created database Triggers for the security purposes.
  • Loaded the data into database using the SQL*Loader from various sources.
  • Creating SQL, Object Views, and PL/SQL database objects. Developed the stored procedures for data transformation purposes.
  • Tuned the SQL Queries with the output of Oracle Tools like Explain Plan, TKPROF.
  • Fixing bugs according to the software change requirement.
  • Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.
  • Worked with SQL QUIRES advanced DML and DDL
  • Involved in Data warehouse design with star schema.
  • Developed test plan documents for all back end database modules.
  • Responsible for unit testing, and documentation of the interfaces.

Environment: Oracle database 9i, PL/SQL, SQL Plus, SQL*LOADER, Windows 2000 Professional, and UNIX.

Confidential

PL/SQL Developer

Responsibilities:

  • Requirements and Analysis: Understanding the requirements of client development of source code, unit testing of report and peer to peer review.
  • Interacting with the onsite team to clarify any queries regarding the functionality etc.
  • Coding required functionality using PL/SQL Procedures, Functions, Views,Triggers, Package and advanced SQL queries
  • Reviewing code of other team mates
  • Involved in test cases development, document test results, unit and integration testing

Environment: Oracle 9i, Oracle PL/SQL, Toad, ERWIN.

Hire Now