We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

Malvern, PA

PROFESSIONAL SUMMARY:

  • Business Processes Supported: Back office services. Personal loans origination, billing and servicing. Mortgages origination, billing and servicing. Electronic data transfers.
  • Oracle and Sybase: More than twenty years of strong experience in Oracle and Sybase relational database development, design, implementation and maintenance (PL/SQL, SQL Query, Performance Tuning, T - SQL), ETL, UNIX shell Scripting. Expert use of PL/SQL to create Packages, Cursors, Records/Collections (Arrays), Bulk Processing, Dynamic SQL, Object Types, Materialized Views, Autonomous Transactions, Partitioning, Functions, Stored Procedures.
  • Software Development Life Cycle (SDLC): Waterfall, SAFe and Agile: Expertise with the entire Software Development Life Cycle (SDLC), programming techniques, and development skills specified in developing applications and SQL databases. Worked on projects using Waterfall, SAFe and Agile development processes including requirements development, business and technical analysis and design, programming, testing, version control, documentation, deployment and maintenance.
  • Six years as a team and technical lead.
  • Performance Tuning: Use of PL/SQL explain plan, sql trace/TKProf for performance tuning and analysis of queries.

TECHNICAL SKILLS:

Languages: Oracle PL/SQL, Sybase and MS T-SQL, Linux/UNIX Shell Scripting, XML, HTML, PowerBuilder w/PFC through v12.1, Java, J2EE

Databases: Oracle 11g, 10g, 9i, 8i,, Sybase and MS-SQL

Tools: Toad for Oracle, SQL*Plus, Oracle SQL Developer, WinSCP3, PuTTY, ERStudio Data Architect 11.0, Eclipse, PVCS, Git, PowerBuilder w/PFC through v12.1, Business Objects, BANNER, SQL-Station v7.04

Operating Systems: Windows7, XP, NT, MS-DOS, Linux, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Malvern, PA

Oracle PL/SQL Developer

Responsibilities:

  • Develop database structural changes
  • Use PL/SQL explain plan for performance tuning and analysis of queries.
  • Work on Agile SDLC including business and technical analysis and design, requirements gathering, programming, testing, version control, documentation, deployment and maintenance.
  • Create and maintain system documentation.
  • Conduct design review meetings to assure the data model and application design met business, technical and performance requirements.
Confidential

Oaks, PA

Oracle Tech Lead

Responsibilities:

  • Support developers for 2 SAFe Agile / scrum teams
  • Enforce company design and coding practices
  • Develop/approve database structural changes
  • Use PL/SQL explain plan for performance tuning and analysis of queries.
  • Work on full project SAFe Agile SDLC including business and technical analysis and design, requirements gathering, programming, testing, version control, documentation, deployment and maintenance.
  • Create and maintain system documentation.
  • Conduct design review meetings to assure the data model and application design met business, technical and performance requirements.

Confidential

Allentown, PA

Oracle Developer

Responsibilities:

  • Designed, Modeled, and Developed using PL/SQL, Toad, Oracle SQL Developer, UNIX shell to maintain, and enhance the PPLSolutions Complex Billing System confidential databases. This is primarily a batch billing application built using UNIX, Oracle, NET, and Linux.
  • Worked on full project SDLC including business and technical analysis and design, requirements gathering, programming, testing, version control, documentation, deployment and maintenance.
  • Reviewed and remediated defects for the on-line production and batch system processes.
Confidential

Wilmington, DE

Oracle Developer

Responsibilities:

  • Designed, Modeled, and Developed using PL/SQL, Toad, C#.NET, to write, maintain, and enhance the PMO Operational Risk databases and C#.NET user interface.
  • Worked on full project SAFe Agile SDLC including business and technical analysis and design, requirements gathering, programming, testing, version control, documentation, deployment and maintenance.
Confidential

West Des Moines, IA

Application Systems Engineer

Responsibilities:

  • Supported, Designed, Modeled, and Developed the system that imports, tracks, update, maintains, reports, and exports mortgage loan data and loan servicing data. The customer facing software is Essbase MS Excel plug-in, Cognos, and Java/browser based, connecting to multiple Oracle 11g databases.
Confidential

Horsham, PA

Oracle Developer

Responsibilities:

  • Reviewed and remediated defects for the UNIX shell and Oracle 11g batch system processes.
Confidential

Princeton, NJ

Oracle Developer

Responsibilities:

  • Designed, Modeled, and Developed using Oracle PL/SQL, PowerBuilder 12.1, and SQL Developer to write, maintain, and enhanced the Operations Department's Test Scoring Suite.
  • Environment: System that imports, tracks, updates, maintains, reports, and exports test scoring data. The customer facing software is PowerBuilder and Java, connecting to multiple Oracle 11g and 9i databases.
Confidential

New York City, NY

Oracle Developer

Responsibilities:

  • Designed, Modeled, and Developed using PL/SQL, Oracle SQL Developer, APEX, and UNIX to write, maintain, and enhance the Finance Department's BANNER installation.
  • Worked on full project SDLC including business and technical analysis and design, requirements gathering, programming, testing, version control, documentation, deployment and maintenance.
  • Environment: System that imports, tracks, updates, maintains, reports, and exports accounting, personnel and student data. The customer facing software is BANNER, connecting to multiple Oracle 11g databases.
Confidential

Columbus, OH

Oracle Developer

Responsibilities:

  • Designed, Modeled, and Developed using PL/SQL, Toad, Oracle SQL Developer, and Essbase to write, maintain, and enhance the Finance Department's OLTP Servicing databases and Essbase front end Reporting data warehouses.
  • Worked on full project SDLC including business and technical analysis and design, requirements gathering, programming, testing, version control, documentation, deployment and maintenance.
  • Responsible for designing, and developing database solutions for several applications.
  • Environment: System that imports, tracks, update, maintains, reports, and exports mortgage loan data and loan servicing data. The customer facing software is Essbase MS Excel plug-in, Cognos, and Java/browser based, connecting to multiple Oracle 11g databases and Essbase cubes.
Confidential

Charlotte, NC

Oracle Developer

Responsibilities:

  • Designed, Modeled, and Developed using PL/SQL, Toad, SQL*Loader, UNIX scripts, and SFTP to maintain, and enhance the Quantitative Risk Department's Reporting and Servicing system.
  • Wrote UNIX scripts to run Oracle processes to synthesize data for internal and external customers.
  • Environment: System that imports, tracks, update, maintains, reports, and exports Derivatives, Credit Valuation Adjustment (CVA) and Counterparty Credit Risk Data. The customer facing software Java/browser based, connecting to multiple Oracle 11g databases.
Confidential

Bethlehem, PA

Oracle Developer

Responsibilities:

  • Designed, Modeled, and Developed using Toad, SQL*Plus, PowerBuilder w/PFC, UNIX scripts, FTP and SFTP, SQL-Station, Eclipse 3.4.2 and SQL*Loader to maintain and enhance the Auto Loan Originations, Reporting, and Servicing system.
  • Worked on full project SDLC including business and technical analysis and design, requirements gathering, programming, testing, version control, documentation, deployment and maintenance.
  • Environment: Object oriented system that originates, imports, tracks, updates, maintains, reports, and exports Auto Loan Data. The customer facing software is PowerBuilder and Java/browser based and runs in Citrix servers and WinXP, connecting to multiple Oracle 11g databases running on HP UNIX servers.
Confidential

 Oradell, NJ

Programmer Analyst

Responsibilities:

  • Designed, Modeled, and Developed using PowerBuilder and, Sybase database to build and maintain the  Confidential System which was packaged and sold by Confidential  to internal and external Electronic Repair and Service Centers throughout Confidential . It allowed the use of electronic instead of paper repair manuals. The SEI system tracked, updated and reported on repair parts sales data. Additionally it allowed the end-user to order parts via fax or e-mail.
  • Worked on full project SDLC including business and technical analysis and design, requirements gathering, programming, testing, version control, documentation, deployment and maintenance.
  • Designed and developed programs to extract, transform and load data from Oracle databases for use in the Sybase database shipped as the center of a local SEI installation.
Confidential

Short Hills, NJ

Programmer Analyst

Responsibilities:

  • Designed, Modeled, and Developed using PowerBuilder and Sybase database to build and maintain the Litigation Management System.
  • Led a team of three in a full project SDLC to gather requirements, analyze, write the documentation, program, performed test, deployment, and post deployment training and supporting of users.
  • Additional duties included troubleshooting user's problems in MS-Word, Excel, WordPerfect, dBase, Report Writer, Windows, DOS and Novell.
Confidential

Basking Ridge, NJ

Programmer

Responsibilities:

  • Generated reports from a dBaseIII+ marketing database for distribution to Product Managers and Field Sales Representatives.
  • Prepared Lotus reporting spreadsheets using data pulled from the marketing database for distribution to management.

Hire Now