We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

5.00/5 (Submit Your Rating)

Boston, MA

SUMMARY:

  • Over 10.5 years of extensive experience in the entire software development life cycle in analysis, design, development, enhancement, implementation, troubleshooting, coding, testing, production support using Oracle 9i/10g/11g SQL PL/SQL, ETL, Data warehouse & Unix projects. ETL experience using Informatica Power Center 8.x. Over 5+ years of extensive experience in leading production support team for banking and financial applications involving development, enhancement, vendor coordination, problem resolution, impact analysis of autosys/unix/database/Websphere/Windows patching and upgrades. Experience in production support, Disaster recovery testing, Sun OS migration, Oracle 11g migration, SFTP/FTP/NDM set up, data analysis, root cause analysis, automation of manual error prone activities and status reporting to direct client and business users. Have very good interpersonal, analytical and communication skills.
  • Extensive experience in Oracle SQL, PL/SQL Programming and various schema objects like Stored Procedures, Functions, Packages, Triggers, Materialized Views and Views to implement business logic.
  • Hands on experience in implementing concepts in PL/SQL like Ref Cursors, Dblinks, PL/SQL Collections, VARRAYS etc.
  • Experienced in working with many complex SQL queries with joins, Analytic functions, date functions, inline functions, sub - queries and co-related sub-queries to generate reports or data analysis.
  • Proficient in using Database utility for loading the raw data feed into Oracle database tables using SQL * Loader.
  • Experience in working on extracting data using Ref Cursors to the csv or flat file and transfer the report to internal and external clients via email, sftp, ftp or ndm.
  • Tuning of SQL statements using Explain Plan to improve the performance or by getting the query optimizer recommendations to create index on columns.
  • Hands on experience in using Informatica Power Center tool to design data conversions from wide variety of source system.
  • Experienced on UNIX Shell scripting, vi editor, commands, disk memory and free space analysis, file handling.
  • Interaction with Business users to understand business processes /requirements and translating them into technical requirements.
  • Interaction with 3rd party vendors, downstream and upstream application team to plan the production release of new code and business checkout, day of plan discussion, role and responsibility assignments.
  • Planning of code release time, batch dependencies to put on hold, validation of code review post distribution of new code in production environment and provide database, shell script difference of before and after code merge to SQA for proof of successful deployment.
  • Worked with other application developer teams and QA teams for getting issues resolved and successful test case execution to get SQA sign off.
  • Excellent exposure for supporting applications, bug fixing & testing in SIT and UAT environments
  • Working experience in both development and Production Support.
  • Exposure to Financial and Insurance domains.
  • Experience in automation of adhoc report request transfer to email ids using python script.
  • Automated the manual static data update for client on-boarding by writing a Oracle stored procedure and call it via shell script and scheduling the job in autosys.
  • Minimized the production incident by fixing manual work around of file copy, date modification on US or UK holidays.
  • Identified the root cause of repetitive incidents and fixes them permanently to stabilised the production SLA and availability.
  • Created application maintenance window during weekend to restart the application servers to free up the memory and archiving the logs to increase the durability of the production application.

TECHNICAL SKILLS:

OS: UNIX LINUX Sun Solaris, Windows XP/2000/NT

Database: Oracle 9i, 10g, 11g, SQL server 2008, MS Access

Database Tools: SQL* Loader, Toad, SQL *Plus, Oracle SQL DeveloperSQL Server 2008 Management Studio

ETL: Informatica 8.6 (Power Center, Server ManagerWorkflow Manager, Designer and Repository Manager)

Languages: SQL, PL/SQL, UNIX Shell Scripts, Python 2.x/3.6

Bug Tracking Tool: Rational Clear Quest, Jira, ISM, ServiceNow

Tools: Rational Clear case

Reporting Tools: Actuate Birt, Actuate E-spreadsheet, Jasper.

Scheduling Tools: Control-M, Autosys.

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Oracle PL/SQL Developer

Responsibilities:

  • Maintain the production application to make sure the daily batch cycles are running uninterruptedly and meets daily business readiness SLA based on its geographical timezone around the world.
  • Gathered the requirements from the users and analyzed their business needs.
  • Involved in application design of the project and preparing of design document, technical specs and test cases.
  • Created daily and monthly Extract/Transform/Load process to source data.
  • Written Shell scripts to move the feed file from staging directory to processing directory, rename the feed file, assess the business date logic based on weekend or weekday and pass the parameter values to execute the Oracle stored procedures and sql loader to load the feed file data into staging table.
  • Wrote PL/SQL functions, stored procedures, cursors, packages, triggers to implement business logic as part of transformation of data from staging table to dimension or fact tables.
  • Created table partitions for the monthly date range and rebuild indexes to gather the statistics for performance tuning.
  • Created PL/SQL stored procedures to archive the historical data & partitioned tables to archive schema by moving the partitions of the table to different schema and tablespace.
  • Created new tablespaces in Oracle for storing the application data based on the utilization.
  • Worked as SME for enhancements for this project & provided input to the new agile team for upcoming enhancement projects.
  • Developed batch processing using autosys scheduler for running the load process on a daily basis based on the file arrival day & time from Monday to Friday.
  • Developed weekend maintenance jobs using autosys to stop & start the application Websphere servers, archive the logs and free up the disk utilization.
  • Scheduled the weekend job via Autosys to run on weekend time after the regular daily file load process completes.
  • Created new sftp, ndm & ftp setup for new inbound or outbound report transfer.
  • Worked closely with users and developers of team to resolve issues.
  • Responsible to review the new code developed by the team before deployment to production.
  • Prepared Test Bed for System Integration and User Acceptance Testing.
  • Created database scripts for deploying the code to production.
  • Executed test cases in unit testing, bug fixing and impact analysis of the new functionality or change of existing functionalities.
  • Successfully tested the disaster recovery of application on DR server.
  • Modified shell scripts as part of Sun OS migration & changes the firewall rules for white listing the client servers.

Environment: Oracle 10g/11g, SQL * Plus, Toad, SQL, PL/SQL, SQL Loader, UNIX, Shell Scripting, Autosys, ISM, ServiceNow, IBM Rational ClearCase, Python.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Created New ETL mapping for loading various type of feed files such as fixed width text file, csv file to Oracle staging tables.
  • Created new Oracle PL/SQL stored procedures, functions, packages, triggers to load the data & implement the business validation from staging table to core tables .
  • Created daily and monthly Extract/Transform/Load process to source data.
  • Written Shell scripts to create parameter files for Informatica workflow.
  • Created Partitioned tables and Parallel Indexing to improve performance of queries.
  • Wrote queries to extract the data from the Oracle database tuned queries and PLSQL procedures to handle performance issues.
  • Created views using complex Oracle sql by grouping, joining various fact & dimension tables tables to provide simple results to the user and downstream application.
  • Extensively worked on create new & recompiling the existing PL/SQL objects on Oracle 10g to complete the migration project.
  • Involved in unit testing, Integration testing and supported User Acceptance Testing.
  • Created database scripts for deploying the code to production.
  • Created new Control-M jobs based on the existing autosys jobs and scheduled them to run as per the feed arrival and SLA timeline.

Environment: Oracle 10g, SQL * Plus, Toad, SQL, PL/SQL, SQL Loader, Informatica 8, UNIX, Shell Scripting, Autosys, Control-M.

We'd love your feedback!