We provide IT Staff Augmentation Services!

Oracle Developer (pl/sql, Unix) Resume

Coppell, TX

SUMMARY

  • Worked as Oracle PL/SQL Developer & Oracle Forms & Reports Developer in all phases of SDLC involving Analysis, Design, Development, Implementation, Testing and Deployment of Business applications using Oracle RDBMS on various platforms
  • Used Cursors, REF Cursors, Exceptions and Hints.
  • Knowledge in RDBMS concepts, with hands on exposure in the development of relational database environment using Oracle 11g/ 10g, SQL, PL/SQL, SQL*Loader, TOAD, SQL*PLUS in many development projects
  • Excellent SQL skills, experience writing complex queries and working with database objects like Tables, Sequences, Synonyms and Views
  • Proficient in Oracle SQL, advanced PL/SQL includes creating Packages, Functions, Procedures,Triggers and materialized views with emphasis on maintaining standards and handling errors in a consistent and robust manner
  • Good experience in writing Test cases, Test scripts and Unit test plans
  • Experience in writing high level test plan for the whole project
  • Experience with normalization, partitioning of data and indexing of partitioned tables
  • Bulk Data Loading using Oracle utilities namely SQL*Loader and External Tables
  • Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collect Feature, Materialized Views, Dynamic SQL, Oracle Hints and Troubleshooting Oracle database issues for better performance
  • DB Design, Oracle Forms and Reports, PL/SQL Development
  • Data Migration, Data Mapping or Table Mapping, Data Loading and exporting by using SQL*Loader and UTL File Utilities
  • Good experience in creating the Project Release Plan for the operations team for deployment
  • Proficient in developing front - end interface using Oracle Forms and Reports Developer suite
  • Developed new screens using forms builder.
  • Extensive knowledge of SQL*Loader and Oracle supplied standard packages
  • Loading test files into unix environment using FTP client using Core FTP
  • Involved in testing files in development and production by running unix shell scripts
  • Involved in Encrypting and Decrypting of files for secure communication using GnuPG
  • Handled ADHOC requests from the Buisness System Analysts
  • Adding a PGP key to the public key ring
  • Updating ACE directories on development and production with the latest data as per USPS and running audits +
  • Scheduled jobs to be run daily in production using Maestro Job Scheduler
  • Handled tasks when an ABEND alert is created on production
  • Involved in data sweeps when BSA requests to update a table
  • Involved in killing jobs when they get stuck and re-running the jobs on CONMAN
  • Worked with BSA’s for doing QC(quality check) after running the audit and update korn shell scripts
  • Worked on Teradata database
  • Worked on SAS Enterprise Guide to pull data from Teradata and Oracle databases
  • Excellent communication skills, interpersonal, strong architecture skills and a good team player

TECHNICAL SKILLS

Programming Skills: Oracle PL/SQL, SQL, HTML, UNIX Shell Script, C, SAP,Teradata,MS Office

Software Tools: SQL Developer, Oracle Forms & Reports Developer Suite, Toad, SQL*Loader, Core FTP, Putty, Maestro, GnuPG (Encrypting & Decrypting Data), IBM Tivoli Work Load Scheduler, Ultra Edit

Databases: Oracle 11g/10g

Operating Systems: Unix, Windows 8/7/XP, DOS

Hardware Tools: Microprocessor (8085/8086/8051 ), FPGA,MAT Lab, Xilinx, OPNET, SIMULINK

Networking protocols: TCP, UDP, DHCP, DNS

PROFESSIONAL EXPERIENCE

Confidential - Coppell, TX

Oracle Developer (PL/SQL, Unix)

Responsibilities:

  • Involved in Development, Implementation, and Testing and Deployment of Business applications using Oracle RDBMS
  • Loading test files into Unix environment using FTP client i.e. Core FTP
  • Involved in working on the requests made by other teams.
  • Involved in manually pushing the files into production as requested by SA Auditors team.
  • Involved in fixing the translate errors before that day’s batch of jobs starts
  • Involved in generating monthly tax report and bag fee report as requested by other teams.
  • Involved in coding as per the change requests.
  • Involved in file transfers to First data client
  • Involved in ON CALL production support 24/7 and fix the jobs which are failed.
  • Involved in using PL SQL techniques to create tables, perform DML’s to load data.
  • Involved in using Unix commands to write and modify scripts on Unix
  • Involved in using Autosys to see job status.
  • Written complex SQL queries using joins, sub queries and correlated sub queries
  • Handled errors using system defined exceptions and user defined exceptions

Environment: Oracle 11g, PL/SQL, TOAD, SQL Developer, Forms 11g and Reports 11g, UNIX, WinSCP, Autosys, SVN, PVCS, Windows XP

Confidential - Richardson, TX

Oracle Developer

Responsibilities:

  • Involved in Development, Implementation, and Testing and Deployment of Business applications using Oracle RDBMS
  • Involved in developing new screens and modifying existing screens on Forms Builder.
  • Involved in creating built-in triggers on Forms Builder.
  • Involved in modifying packages and creating new packages.
  • Involved in creating new triggers.
  • Involved in creating design documents.
  • Involved in creating the new stored procedures and wrappers for execution
  • Written complex SQL queries using joins, sub queries and correlated sub queries
  • Developed / modified Oracle PL/SQL codes like stored Procedures, Functions, Triggers based on technical and functional specification documents
  • Used Joins extensively in stored procedures, packages
  • Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
  • Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases
  • Handled errors using system defined exceptions and user defined exceptions
  • Loaded the data into database tables using SQL*loader from text and excel files
  • Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards.
  • Written test cases on stored procedures
  • Developed Unit Test Plans
  • Developed Unit Test Cases to test the functionality of the procedure
  • Written Test case scripts
  • Developed high level test plan for the whole project
  • Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views and functions as per the business requirements
  • Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plan and Trace sessions for Cost based optimization
  • Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning
  • Tuned SQL queries for new reports for faster response time
  • Tuned the SQL Queries and Stored procedures for better Performance
  • Collaborated with other project teams for performance tuning of queries.
  • Created Oracle Hints and worked on Partition tables in Oracle Database, Dynamic SQL
  • Created the Project Release Plan for the operations team for deployment
  • Worked on Teradata database
  • Worked on SAS Enterprise Guide to pull data from Teradata and Oracle databases

Environment: Oracle 11g, PL/SQL, TOAD, SQL Developer, Forms 11g and Reports 11g, SVN, PVCS, Windows XP

Confidential - Lewisville, TX

Oracle PL SQL & Abinitio Developer

Responsibilities:

  • Involved in Development, Implementation, and Testing and Deployment of Business applications using Oracle RDBMS
  • Involved in getting requirements from the Business.
  • Involved in making amendments on the business requirement document (BRD) based on the developer analysis.
  • Involved in working with the business analysts to document the FSD(Functional system document).
  • Involved in working on ADHOC requests in reporting different types of manual submissions to the Treasury.
  • Worked on the Change Requests requested by the CAB every month.
  • Worked on the mapping documents from source to target in order to load the columns through Abinitio into the target database tables.
  • Worked on modifying packages and creating new packages, creating new stored procedures and wrappers for execution of procedures, views, triggers in development phase of the change requests.
  • Written complex SQL queries using joins, sub queries .
  • Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
  • Worked on documentation for each Change Request i.e Technical Design Document, Unit Testing Document, Impact Analysis Document, Migration Document.
  • Worked on code versioning tool SVN.
  • Worked on creating the approval work flows for the manger on the documentation.
  • Involved in unit testing the developed code before promoting to UAT.
  • Involved in working with the Business Analyst in testing the functional requirement.
  • Involved in creating conditional scripts to create data in order to fall into testing criteria for the Business Analyst.
  • Involved in production support and validating the Change Request at the time of release.
  • Developed number of Ab Initio Graphs across multiple projects based on business requirements using various Ab Initio Component sets like Database, Transform, Partitioning, Translate etc.
  • Developed Ab Initio graphs to extract/load huge amounts of datasets from multiple Databases, used several DML core functions for data type conversions, searching for data in lookup files, performing mathematical computations.
  • Hands on Experience on Tagging of code, supporting the code migrations and usage of AIR commands for importing, exporting objects to and from EME Technical repository.
  • Self-initiative, good team player, excellent problem solving and communication skills, exceptional skills in Agile development and Test driven development.

Environment: Oracle 12.1, PL/SQL, TOAD, SVN, Visio, Ab Initio (GDE 3.2.5.1; Co>Operating System 3.2.5.2), Windows XP

Hire Now