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.
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.
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.
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.
Horsham, PA
Oracle Developer
Responsibilities:
- Reviewed and remediated defects for the UNIX shell and Oracle 11g batch system processes.
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.
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.
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.
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.
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.
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.
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.
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.