We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer With Dba Resume

4.00/5 (Submit Your Rating)

NJ

SUMMARY

  • Broad experience in design and analysis of application systems. Involved in all phases of the Software Development Life Cycle, including system analysis, design, development, testing, debugging, documentation and implementation
  • Experience working as Team Lead with Business Analysts and QA Analysts, Offshore / onsite development and production teams
  • Experience working with complex large databases with many tables and large data volume, resolved extensive Debugging and Troubleshooting problems
  • Experience in solving performance analysis and tuning issues
  • Extensive working experience with Oracle 11g and PL/SQL (writing packages and stored procedures, database triggers, etc.), experience in writing complex queries for the purpose of Data Analysis using Oracle ANSI SQL
  • Migration experience from Oracle 6i to Oracle 10g and from Oracle 11g to Oracle 12c
  • Use Agile development experience
  • Hands on experience working in Linux environment including writing of Shell scripts
  • Experience with Bitbucket / GIT Server (Stash) and Jenkins

TECHNICAL SKILLS

Programming Languages: COBOL, PL/me, FORTRAN, JCL, PRO*C, C

Databases and Database Tools: ORACLE 11g, 12c, Oracle PL/SQL, Oracle SQL*Plus, Oracle SQL*Loader, Import/Export utility, TOAD for Oracle, Oracle SQL Developer, Oracle SQL Navigator, Oracle PL/SQL Developer, PeopleSoft, Oracle Forms 10g, Oracle Reports 10g, DB2, MS SQL Server 2000/2003/2008/2014 , TOAD for MS SQL Server, MS SQL Server Management Studio 17, MS Access 2013, Visual Studio 2017

Miscellaneous Tools and Utilities: FTP, PVCS, SVN, Clear Case, Clear Quest, SharePoint, Microsoft Office 2013, Autosys, UC4, Tivoli, Quality Center QA tools, Jira, ALM, Bitbucket (GIT), PuTTY, ITSM, Jenkins

Platforms: MS Windows® 2000, MS Windows NT/XP/Vista/7/8, Dec Open Alpha, Unix/Linux

PROFESSIONAL EXPERIENCE

Confidential, NJ

Oracle PL/SQL Developer with DBA

Responsibilities:

  • Team leader on the Pharmacy System
  • Involved in all phases of the Software Development Life Cycle, including system analysis, design, coding, testing, debugging, documentation and implementation
  • Production release in Oracle 12c
  • Designed, coded, tested and implemented processes, stored procedures, functions and data base triggers for the Pharmacy System by using Oracle ANSI SQL, Oracle PL/SQL, Linux Shell scripts
  • Designed, coded, tested and implemented Linux Shell scripts for the Pharmacy System feeds. Scheduled all of them
  • Maintenance and production support the Pharmacy System feeds by using Oracle and Linux tools
  • Developed and sent daily the Health Check report by using Oracle SQL, Oracle ANSI SQL, SQL*Plus, SQL Developer, PL/SQL, Tivoli Scheduler, xlsm files executing Macros
  • Submitted corresponding batch processes in Oracle by using Tivoli or PLV System, Linux Shell
  • Designed and developed Ad - Hoc and On-Line Reports by using Oracle tools by business requests
  • Resolved extensive Debugging and Troubleshooting problems of the Pharmacy System
  • Fully responsible for performance analysis and tuning of application
  • Provided support for business users
  • Fully responsible for Root cause analysis (RCA)

Confidential, NY

Sr. Database Lead Developer with DBA

Responsibilities:

  • Team leader on SAA CDM feed systems (There were 4 developers in my team)
  • Involved in all phases of the Software Development Life Cycle, including system analysis, design, coding, testing, debugging, documentation and implementation
  • Production release in Oracle, MS SQL Server DBs by using Jenkins
  • Designed, coded, tested and implemented processes, stored procedures, functions and data base triggers for the SAA CDM feed systems by using Oracle ANSI SQL, Oracle PL/SQL, Linux Shell scripts
  • Designed, coded, tested and implemented Linux Shell scripts for the SAA CDM feed. Scheduled all of them
  • Involved in migration from Oracle 11g to Oracle 12c
  • Maintenance and production support all the SAA CDM feed systems by using Oracle, MS SQL Server, MS Access DBs and Linux tools
  • Developed and sent daily the SAA CDM feed report by using Oracle SQL, Oracle ANSI SQL, SQL*Plus, TOAD for Oracle, PL/SQL, MS SQL Server, Toad for MS SQL Server
  • Submitted corresponding batch processes in Oracle, MS SQL Server and MS Access databases by using AutoSys, SQL Server Agent, Linux Shell and Power Shell scripting
  • Designed and developed Ad-Hoc and On-Line Reports by using Oracle tools by business requests
  • Resolved extensive Debugging and Troubleshooting problems of the systems
  • Fully responsible for performance analysis and tuning of applications
  • Fully responsible for Bulk Update and loading data
  • Designed, coded, tested and implemented processes for the SAA CDM feed by using MS SQL Server SQL and Power Shell scripts
  • Provided support for business users
  • Fully responsible for Root cause analysis (RCA)
  • Created documentations for the SAA CDM feed
  • SMTD and Understanding documents
  • User Interface
  • Designed and created Data Flow Diagrams
  • Entity Relationship Diagrams and narrative of procedures

Confidential, NYC, NY

Sr. Database Developer

Responsibilities:

  • Technical Leader on the Saks Inventory and Merch OPS Systems
  • Involved in all phases of the Software Development Life Cycle, including system analysis, design, coding, testing, debugging, documentation and implementation
  • Designed, coded, tested and implemented ETL processes, stored procedures, functions and data base triggers for the Saks Inventory and Merch OPS Systems by using Oracle ANSI SQL, Oracle PL/SQL, Linux Shell scripts
  • Designed, coded, tested and implemented 9 Informatica ETL processes based on PL/SQL
  • Maintenance and production support different parts of Saks Inventory and Merch OPS Systems by using Oracle, DB2 and Linux tools
  • Developed and Implemented reports by using Oracle SQL, Oracle ANSI SQL, SQL*Plus, PL/SQL
  • Submitted corresponding batch processes and reports by using UC4 software, Linux Shell scripting
  • Designed Ad-Hoc and On-Line Reports by using Oracle tools
  • Resolved extensive Debugging and Troubleshooting problems of the systems in Oracle and DB2 databases
  • Fully responsible for performance analysis and tuning of applications in Oracle and DB2 databases
  • Fully responsible for Bulk Update and loading data
  • Designed, coded, tested and implemented processes for PIM (Product Information Management - Informatica) by using Oracle SQL, SQL*PLUS, PL/SQL and Linux Shell scripts
  • Provided support for over 30 end-users
  • Fully responsible for Root cause analysis (RCA)
  • Created documentations for the Saks Inventory and Merch OPS Systems
  • SMTD and Understanding documents
  • User Interface
  • Designed and created Data Flow Diagrams
  • Entity Relationship Diagrams and narrative of procedures

Confidential, Bedminster, NJ

Sr. PL/SQL Developer

Responsibilities:

  • Technical Leader on Inventory Management System
  • Involved in all phases of the Software Development Life Cycle, including system analysis, design, coding, testing, debugging, documentation and implementation
  • Designed, coded, tested and implemented programs, stored procedures, materialized view and data base triggers for the CATS Inventory management System by using Oracle PL/SQL, Oracle ANSI SQL
  • Maintenance and production support different parts of the CATS Inventory management system by using Oracle and Linux tools. Provided support for over 100 end-users
  • Developed and Implemented On-Line programs for VerizonWireless by using Oracle ANSI SQL, Oracle SQL, SQL*Plus, PL/SQL
  • Submitted corresponding batch processes by using Autosys and Linux Shell scripting
  • Designed Ad-Hoc and On-Line Reports by using Oracle SQL*PLUS, and MS Office tools
  • Resolved extensive Debugging and Troubleshooting problems of the systems
  • Researching interface transaction errors between PSFT and CATS, pulling report data from the application using Oracle ANSI SQL, SQL and PL/SQL and working with the System Administration team and the vendor to resolve code defects
  • Fully responsible for performance analysis and tuning of applications
  • Provided support for over 200 end-users
  • Fully responsible for Root cause analysis (RCA)
  • Created documentations for the CATS & PSFT Inventory management system
  • SMTD and Understanding documents
  • User Interface
  • Designed and created Data Flow Diagrams
  • Entity Relationship Diagrams and narrative of procedures
  • CATS & PSFT objects

Confidential, Boston, MA

Sr. PL/SQL Developer

Responsibilities:

  • Team leader on all applications involved in
  • Involved in all phases of the Software Development Life Cycle, including system analysis, design, coding, testing, debugging, documentation and implementation
  • Designed, coded, tested and implemented programs, stored procedures and data base triggers, functions and materialize view for COTT, OMAC, SOLAR Systems by using Oracle PL/SQL, MS SQL Server, DB2
  • Maintained and supported different parts of the client system (COTT, OMAC, Solar Systems) and provided support for over 100 end-users
  • Developed and Implemented On-Line and Batch programs by using Oracle SQL, SQL*Plus, PL/SQL
  • Submitted corresponding batch processes by using Oracle DBMS JOB package, Linux Shell scripting and AutoSys
  • Designed User Interface as well as Ad-Hoc and On-Line Reports (Tabular, Master Detail, Form, Form Letter, Matrix reports) by using Oracle ANSI SQL, Oracle SQL*PLUS, Oracle Reports 10g
  • Resolved extensive Debugging and Troubleshooting problems of the systems
  • Fully responsible for maintenance and production support by using Oracle, DB2, MS SQL Server and Linux tools
  • Worked closely with offshore team to provide production support
  • Fully responsible for performance analysis and tuning of applications in Oracle, DB2, MS SQL Server databases
  • Fully responsible for loading data
  • Fully responsible for Root cause analysis (RCA)
  • Provided support for over 150 end-users
  • Coordinated and performed Disaster Recovery test on all applications involved in
  • Designed and created Data Flow Diagrams, Entity Relationship Diagrams and narrative of procedures, SOP, and Understanding documents, Disaster Recovery test documents for each application involved in

Confidential, Edison, NJ

Sr. Programmer Analyst

Responsibilities:

  • Team leader on all the projects involved in since 2001
  • Involved in all phases of the Software Development Life Cycle, including system analysis, design, development, testing, debugging and documentation
  • Involved in migration from old version of Oracle to new one (twice) in 2001 and 2008
  • Converted Pro*C programs into PL/SQL
  • Fully responsible for design and coding of Billing, Import, Documentation, Wharfage, Brokerage, AMS applications
  • Fully responsible for maintenance and production support by using Oracle and Linux tools
  • Designed, coded, tested and implemented programs, stored procedures and data base triggers for a shipping company
  • Resolved extensive Debugging and Troubleshooting problems of the systems
  • Developed several shell scripts to schedule batch processes
  • Loaded Mainframe’s data from DB2 to ORACLE database by using Oracle SQL* Loader, Oracle Export/Import utility, FTP, and developed Ad-Hoc reports
  • Developed Import, Documentation, Billing, Wharfage, Brokerage, AMS, and Archive projects:
  • Developed background processes for corresponding projects by using Oracle SQL, Oracle ANSI SQL, SQL*PLUS, PL/SQL (Created Oracle PL/SQL Packages that include Oracle PL/SQL Procedures and Oracle PL/SQL Functions)
  • Submitted corresponding batch processes by using Oracle DBMS JOB package
  • Developed reports (Tabular, Master Detail, Form, Form Letter, Matrix reports) for corresponding projects by using Oracle 6i, Oracle 9i, Oracle 10g, Oracle 10g Reports
  • Developed front ends for corresponding projects by using Oracle 6i, Oracle 9i, Oracle 10g, Oracle 10g Forms
  • Performed Y2K modification on 50% of all existing applications in the system
  • Fully responsible for design and coding of more than ten background processes that include numerous data base packages
  • Fully responsible for performance analysis and tuning of applications
  • Designed, developed, coded, and maintained security for all applications
  • Fully responsible for loading data
  • Worked closely with offshore development team on all projects involved in
  • Provided support for over 100 end-users
  • Designed and created Data Flow Diagrams, Entity Relationship Diagrams and narrative of procedures, SMTD, SOP, and Understanding documents for all applications involved in

We'd love your feedback!