We provide IT Staff Augmentation Services!

Oracle Developer Resume

Manhattan, NY

SUMMARY:

  • 6+ years of IT experience in Implementation, Design and Development of Client/Server & Web - server applications using Oracle on UNIX & Windows Platforms.
  • Expertise in Oracle 12c/11g/10g/9i/8i, SQL, PL/SQL, and UNIX shell scripting.
  • Experience in application software analysis, design, development, implementation, maintenance, and documentation of commercial applications through out various phases of project life cycle.
  • Proficiency in analysis, design, development, testing, implementation, and maintenance of applications in Oracle Forms and Reports and client/server configurations.
  • Experience with Database developmen Confidential , ETL, OLTP and OLAP analysis and reporting processes.
  • Interacting with Business users, gathering and analyzing requirements.
  • Experienced in System Analysis, design and implementation . Logical and physical data modelling . Monitor database performance & Tuning
  • Good understanding of Oracle data dictionary and normalization techniques. Experienced in Oracle 10g/9i/8i/8.x/7.x systems, SQL*Loader, Export, Import and SQL*Plus.
  • Proficient in Oracle Data base design with relational models and very good experience in entity and attribute identification and developing the Entity-Relationships.
  • Hands-on experience with Oracle Forms and Reports 11g/10g.
  • Writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
  • Experience in writing Stored Procedures, Functions, Database Triggers and Packages using PL/SQL. Enforcing data integrity using integrity constraints & database triggers.
  • Experience in generating customized Forms and Reports using Oracle Forms and Reports.
  • Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.
  • Enforcing security by creating roles, granting system and object privileges on the tables, stored procedures. Loading data from flat files into database tables using SQL*Loader.
  • Automating data loading, extraction, reports generation using UNIX Shell scripting (Bourne shells).
  • Wrote and modified Oracle PL/SQL, Sql statements procedures and functions that are called in the Java Scripts
  • Knowledge of database architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
  • Experience in developing applications using forms (11g/10g/9i/ 6i) and reports (11g/10g/9i/ 6i) . Well experienced in backend programming (Triggers, Procedures, and Functions) using Oracle 11g/10g/ 9i/8i/8.x and web enabled application development and deployment using Oracle application server.
  • Experienced in loading data using SQL *loader and using SQL *Plu s.
  • Actively involved in capacity planning, creating views, materialized views, partitioning tables and creating indexes etc. for optimization process.
  • Expertise in Performance tuning and improved Reports performance in Tableau using extracts and context filters and custom SQL
  • Experience with Performance Tuning for Oracle RDBMS using Explain Plan
  • Developed Data Mapping and Data Conversion scripts using SQL, PL/SQL.
  • Written complex SQL’s using joins, sub queries and correlated sub queries.
  • Wrote Test cases and performed data validation and process testing for application moving into production. Excellent in problem solving, logical and analytical abilities.
  • Team Player with Analytical skills, ability to quickly adept to new environment and available as needed for .
  • Ability to work independently and as part of a team, deliver under pressure and tight deadlines.

TECHNICAL SKILLS:

RDBMS & software: Oracle 12c/11g/10g/9i/8i, Developer 11g/10g/9i/6i suite (Forms 11g/10g/9i/6i, Reports 11g/10g/9i/6i), Oracle Designer 2000/6i, SQL*PLUS, Server Manager/SQL*DBA, Export/Import, SQL*Loader, JIRA, Tortoise SVN, Erwin, Toad, Oracle Enterprise Manager Informatica Power Center 9.5/9.1, Flat Files, Excel Files and reports.

Languages: SQL, PL/SQL, Unix shell scripting (Bourne shells)

Windows: 2000/NT/98/95, Red hat Linux, MS-DOS

Languages and Web Technologies: SQL, PL/SQL, Java, XML, HTML/XHTML.

WORK EXPERIENCE:

Confidential, Manhattan, NY

Oracle Developer

Responsibilities:

  • Involved in all stages of software lifecycle development. Analyze, design, develop, testing and production release for data base objects.
  • Interacted with business users to understand the business requirements and explained them what to do in technical point of view for requirement.
  • Developed database objects for integrating the Gas Work Tracker user interface application which was developed by Oracle Forms.
  • Involve in all phases of software development life cycle like gathering the requirements, designing the technical document, developing the oracle objects and testing it before going to live.
  • Developed Stored Procedures, Functions, Packages and SQL Scripts for database transactions using PL/SQL in Oracle 11g and Java.
  • Created interface screens and reports using Oracle Forms 11g/12c and Oracle Reports 11g/12c .
  • Migrated the Oracle forms and Reports from 11 g to 12c .
  • Developing PL/SQL Procedures Confidential the database level that were used in the mappings through Stored Procedure Transformation.
  • Created new project in TFS for Python programming to get the latitude and longitude based on location using google maps API.
  • Developed Python code using UI for Geocoding process to get the latitude and longitude depends on address with Google API.
  • Developed new database objects like materialized views and created database links to get the latest permit information from one system to another system.
  • Performed query tuning and System Performance tuning of Oracle Databases and User applications. working on Advanced PL/SQL techniques including Collections, Materialized views, external table and Bulk Collect for batch transition process.
  • Generated reports on weekly and monthly basis as data is loading into target tables correctly or not. wrote a shell script for deleting backup files and repeated files in land directory for every object.
  • Working on SQL, PL/SQL development and database support as well as maintenance.
  • Developing Oracle DB modules, database triggers, cursors, stored procedures Utilized SQL*Loader to load flat files database tables.
  • Working on SQL, PL/SQL and Java API development and database support as well as maintenance.
  • Prepared and execution of test plans for unit & system testing.
  • Analyzing advanced code with Oracle concepts and query plans, query tuning, partitioning and optimizer hints.
  • Coordinate code builds between environments.
  • Monitoring the scripts and batch jobs in lower environments to check the performance and result. Monitor the system performance and tuning the SQL codes by reading the explain plans.

Environment: Oracle 12c/11g, Oracle forms 12c/11g, Oracle Reports 12c/11g, SQL, PL/SQL, UNIX, Oracle Sql developer, Toad, TFS, Python 3.2, shell Scripts, SQL*Loader, Windows.

Confidential, Monroeville, PA

Oracle PL/SQL Programmer

Responsibilities:

  • Working on SPARCS application and making existing changes and developing new code to enhancing the functionality of the application.
  • Developed a process for transitioning patient information and prescription information from legacy Oracle Forms Application to New Oracle database schema tables.
  • Wrote stored procedures to parse and analyses CLOB data for business needs.
  • Developed a process of sending prior authorization for refund transaction for credit card payment transactions.
  • Developed Oracle forms to select the type of payment to pay for specialty drugs.
  • Developed many stored procedures and functions to suit business needs and accomplish business objectives
  • Development of database triggers, cursors, packages, procedure & functions using PL/SQL & SQL.
  • Working on merging anthem patients to SPARCS application.
  • Worked on end to end flow in Data Warehouse.
  • Involved in transition patients from SPARCS to SPRx application which is built on Java UI.
  • Maintain the Packages and Procedures version of changes in SVN.
  • Documenting the modifications and enhancements made to the application systems and databases as required by the project.
  • Providing support in end to end integrations.
  • Developed SQL*loader scripts to load data in the custom tables.
  • Developed PL /SQL code for updating payment terms.
  • Prepared Handbooks for the application.
  • Preparation and execution of test plans for unit & system testing.
  • Analyzing the test results and recommending modifications to the applications to meet project specifications
  • Developing and implementing the test validations of the applications specifications
  • Monitored performance and optimized SQL queries for maximum efficiency.
  • Performed unit testing and integration testing for various development applications in ORACLE 12c/11g.
  • Supported project application which is built on Informatica mappings and transformations.
  • Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
  • Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
  • Used external tables to manipulate data obtained daily before loading them into the tables.
  • Developed UNIX Shell scripts to automate repetitive database processes.
  • Experience in UNIX shell scripts in writing deployment code for migrations.
  • Developed PL/SQL Procedures Confidential the database level that were used in the mappings through Stored Procedure Transformation.
  • Creation of interface screens and reports using oracle forms and oracle reports.
  • Handled various exceptions to troubleshoot PL/SQL code.
  • Created indexed views, and appropriate indexes to reduce the running time for complex queries
  • Monitoring the system performance and tuning the SQL codes by reading the explain plans.
  • Experience in scheduling the jobs in Tivoli.
  • Coordinating code builds between environments.
  • Used ETL to load the data from various sources into EDW.
  • Analyses the warehouse data provided reports for the same.
  • Involved in Code Review, Code Walk Through, and Unit Testing.

Environment: Oracle 12c/11g, Oracle forms 11g, Oracle Reports 11g, SQL, PL/SQL, UNIX, Oracle Sql developer, Toad, TFS, shell Scripts, SQL*Loader, Windows.

Confidential, Mclean, VA

Oracle PL/SQL Developer

Responsibilities:

  • Analyzing the new Requirements and preparing the design documents.
  • Worked on migration of 4G LTE data from multiple legacy systems to EDW for better decision making.
  • Developed Oracle Extracts scripts to extract the data and created the staging tables to transform (to map) the data and load into target tables using Unix load scripts .
  • Analyzed data, designed and developed Oracle forms 11g queries, layout, report triggers, parameter form, data models etc.
  • Developed new codes for data load and modified the existing load scripts to load data into Data Warehouse from different sources as per the requirement.
  • Developed Stored Procedures, Functions, Packages and SQL Scripts for database transactions using PL/SQL.
  • Development of database triggers, cursors, packages, procedure & functions using PL/SQL & SQL.
  • Worked on end to end flow in Data Warehouse.
  • Documenting the modifications and enhancements made to the application systems and databases as required by the project.
  • Created Triggers, Stored Procedures, Packages and SQL Scripts.
  • Developed PL /SQL code for updating payment terms.
  • Preparation and execution of test plans for unit & system testing.
  • Analyzing the test results and recommending modifications to the applications to meet project specifications
  • Developing and implementing the test validations of the applications specifications
  • Wrote efficient stored procedures for the optimal performance of the system
  • Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
  • Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling
  • Worked in debugging and tuning the PL/SQL code, explain plan and tuning queries for the Oracle database
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
  • Generated context filters and used performance actions while handling huge volume of data.
  • Used external tables to manipulate data obtained daily before loading them into the tables.
  • Experience in UNIX shell scripts in writing deployment code for migrations.
  • Developed PL/SQL Procedures Confidential the database level that were used in the mappings through Stored Procedure Transformation.
  • Creation of interface screens and reports using oracle forms and oracle reports.
  • Loaded the data into database tables using SQL*loader from text and excel files.
  • Utilized SQL*Loader to load flat files database tables.
  • Handled various exceptions to troubleshoot PL/SQL code.
  • Formulated procedures, functions
  • Created indexed views, and appropriate indexes to reduce the running time for complex queries
  • Monitoring the system performance and tuning the SQL codes by reading the explain plans.
  • Experience in scheduling the jobs in Autosys
  • Coordinating code builds between environments.
  • Used ETL to load the data from various sources in to EDW.
  • Tested the various ETL processes that were developed to fetch data from various feeds coming from Admin System
  • Analyses the warehouse data provided reports for the same.
  • Involved in Code Review, Code Walk Through, and Unit Testing.

Environment: Oracle 11g, SQL, Oracle Forms & reports 11g, Informatica Power Center, PL/SQL, Explain Plan, Microsoft Excel, UNIX, Toad, Oracle Sql developer, shell Scripts, SQL*Loader.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Developed Oracle forms, database triggers, cursors, stored procedure
  • Developed PL/SQL Packages, Functions. Utilized SQL*Loader to load flat files database tables.
  • Utilized PL/SQL developer tool in developing all back-end database interfaces
  • Worked on responsible for performing code reviews.
  • Developed user documentation for all the application modules. Also, responsible for writing test plan documents and unit testing for the application modules.
  • 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 UTL FILE.
  • Utilized SQL*Loader to load flat files database tables.
  • Involved in the ETL process of developing new tables from the existing views and materialized views.
  • Implemented Advanced PLSQL Concepts for better performance of PLSQL Applications
  • Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
  • Creating SQL, Object Views, and PL/SQL database objects. Developed the stored procedures for data transformation purposes.
  • Fixing bugs per the software change requirement.
  • Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.
  • Worked in SQL, PL/SQL development and database support as well as maintenance.
  • Involved in performance tuning - analyzing query plans, query tuning, partitioning and optimizer hints.
  • Created database scheduler scripts and applications using UNIX shell scripts, SQL *Plus script.
  • Upgraded, maintained and troubleshooter for Oracle Forms and Reports.

Confidential

PLSQL Developer

Responsibilities:

  • Worked with team leader, Business Analyst to achieve the company goal.
  • Gathered requirement documents coordinating with Business Analyst and other team members.
  • Analyzed the Business Requirements Specification Documents and Source to Target Mapping.
  • Created different types of object like table, store procedure, Index, Views etc.
  • Documents and identified the test requirements.
  • Tested the ETL process that loaded the data into target database after performing all the transformations according to the business requirements
  • Pull data on regular basis for business user

Environment: Oracle 9i, PL/SQL, SQL Plus, SQL*LOADER, Windows, UNIX, Explain Plan.

Hire Now