We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

Hartford, CT

SUMMARY

  • 11+ years of professional experience in Design and Development, System Analysis, Enhancement and service Support Projects for Insurance, Sub - Servicing Mortgage Banking, Time Share,Travel and Hospitality Industry and Fleet services domain applications in Oracle 10g/11g using SQL, PL/SQL in Windows 9x/2000/XP and UNIX environments. Knowledge in Oracle Architecture, Data Dictionary and DBMS Packages.
  • Excellent exposure to SQL, Oracle PL/SQL as primary skill and UNIX shell scripting
  • Extensive experience in Database query tuning, Performance tuning using Explain Plan, AWR report, SQL Hint and troubleshooting Oracle Application issues.
  • Experienced in requirement analysis, design, and coding, testing, implementing and executing projects.
  • Expertise in creating stored procedures, Packages, Triggers and Functions. Strong knowledge in cursor management and exception handling, PL/SQL logging.
  • Expertise in Developing Views, Materialized views, DB link, Bulk Collect, FORALL clause, REF cursor, SQL Loader, Analytical functions, Hierarchical function, Dynamic SQL, Execute immediate etc
  • Used Oracle Analytical functions like rank(), Lag(), Lead(), row number(), dense rank(), lstagg(), ntile(), pivot() etc
  • Have good exposure to software tools like Toad, PL SQL Developer, SQL*Loader, Mercury Quality Center, SVN, Autosys
  • Have worked on Smartview, Ingress database and OSQ language.
  • Excellent team player and proven track record working in various team sizes performing cross-functional roles.
  • Excellent in problem solving, project management, good leadership skill and organizing and prioritizing the tasks.
  • Designed and deployed UNIX shell script to automate Oracle Jobs using PL SQL procedures.
  • Substantial knowledge on Advance PL/SQL.
  • Provided 24X7 supports for any production issues.
  • Ability to quickly learn programming languages and other applications/software.
  • A capable and resourceful team member who also possesses excellent written and verbal communication skills

TECHNICAL SKILLS

Development Technologies: PL/SQL, SQL, DIBOL, UNIX Shell Scripting

Operating Systems: Window 9x/2000/XP, UNIX SUN Solaris 10

Databases: Oracle 10g/11g/12c, Ingress, Essbase

Tools: Putty, DB Visualizer 7.0.7, PL/SQL Developer, SQL Developer, Toad, Editplus, Assyst, Microsoft Visio, Autosys, Remedy, Smartview, Tortoise SVN, VSS, SCCS

PROFESSIONAL EXPERIENCE

Oracle PL/SQL Developer

Confidential, Hartford, CT

Responsibilities:

  • Responsible for requirements gathering from Clients and implementing the back-end changes in existing products and in designing the database.
  • Develop PL/SQL, Stored subprograms, package, function, Cursors and Triggers.
  • Involved in Performance tuning of complex queries using Explain Plan and AWR report and indexing strategy.
  • Optimizing query by based on the Explain Plan generated .
  • Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
  • Developed objects like Partitions, Materialized views, Views, Indexes.
  • Relational database activity such as indexes, primary and foreign keys, and constraints
  • Dynamic Sql, and BULK COLLECT and FOR ALL, SYS REFCURSOR, SYS CONTEXT
  • Review of code changes, test procedure, test plans and other deliverables.
  • Develop UNIX Shell scripts as per user requirements and to automate the processes.
  • Created scripts for load data using SQL * Loader.
  • Monitoring job using Autosys utility, fixing any job failure.
  • Involved in DBA activities.
  • Test case/data preparation, execution and verification of the test results. Resolving defects reported during QA and UAT testing.
  • Develop various business reports.
  • Provided support for one of the file transfer migration project from RAFT (Random Access File Transfer) to MFT(Manage File Transfer)
  • Providing 24X7 supports for Production issues.

Environment: Oracle 11g/12c, PL/SQL, UNIX Shell Scripting, Mercury Quality Center, Tortoise SVN, PL SQL Developer, Toad, Autosys, Putty.

Oracle - Data Analyst

Confidential

Responsibilities:

  • Developed complex SQL script to generated OPS report metrics using analytical functions like rank(), row number(), dense rank(), lstagg(), ntile(), pivot() etc.
  • Using with() clause for writing complex queries.
  • Developed Script for spooling of data and generate the reports.
  • Develop PL/SQL, Stored subprograms, package, function, Cursors.
  • Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
  • Develop DOS Shell scripts as per user requirements and to automate the processes.
  • Test case/data preparation, execution and verification of the test results. Resolving defects reported during QA and UAT testing.
  • Involved in Production deployment activities and providing support during implementation.
  • Review of code changes, test procedure, test plans and other deliverables.
  • Develop queries for various business reports.
  • Maintaining code version using SVN.

Environment: Oracle 11g, PL/SQL, Excel VBA Code, SQL Developer, Tortoise SVN, Toad, Excel

Onsite Team Lead- Oracle PL/SQL Developer

Confidential

Responsibilities:

  • Follow the complete SDLC life cycle of the project.
  • Involved in the initial discussion of the projects to gather requirement and proposed solution during JAD and JRP’s
  • Performing Impact analysis and estimation for the projects depending on the requirement gathered.
  • Develop code in PL/SQL, Stored subprograms, package, function and Cursors.
  • Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
  • Created SQL*Loader scripts to load data into temporary staging tables
  • Wrote extensive Exception handling procedures to handle exceptions.
  • Wrote DDL Scripts to create new database objects like tables, views, sequences, synonyms, and indexes.
  • Prepared High level and Low level designed documents in MS word and Flow diagram using MS Viso,
  • Review of code changes, test procedure, test plans and other deliverables.
  • Develop UNIX Shell scripts as per user requirements and also to automate the processes.
  • Test case/data preparation, execution and verification of the test results. Resolving defects reported during QA and UAT testing.
  • Maintaining code version using SVN.
  • Develop various business reports.
  • 24x7 support on production issue

Environment: Oracle 10g, PL/SQL, UNIX Shell Scripting, Mercury Quality Center, PL SQL Developer, Toad, Putty, VSS, Assyst, SVN, DB Visualizer, Microsoft Visio

Offshore Team Lead- Oracle PL/SQL Developer

Confidential

Responsibilities:

  • Follow the complete SDLC life cycle of the project.
  • Involved in the initial discussion of the projects to gather requirement and proposed solution during JAD and JRP’s
  • Performing Impact analysis and estimation for the projects depending on the requirement gathered.
  • Develop code in PL/SQL, Stored subprograms, package, function and Cursors.
  • Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
  • Created SQL*Loader scripts to load data into temporary staging tables
  • Wrote extensive Exception handling procedures to handle exceptions.
  • Wrote DDL Scripts to create new database objects like tables, views, sequences, synonyms, and indexes.
  • Prepared High level and Low level designed documents in MS word and Flow diagram using MS Viso,
  • Review of code changes, test procedure, test plans and other deliverables.
  • Develop UNIX Shell scripts as per user requirements and also to automate the processes.
  • Test case/data preparation, execution and verification of the test results. Resolving defects reported during QA and UAT testing.
  • Maintaining code version using SVN.
  • Develop various business reports.
  • 24x7 support on production issue

Environment: Oracle 10g, PL/SQL, UNIX Shell Scripting, Mercury Quality Center, PL SQL Developer, Toad, Putty, VSS, Assyst, SVN, DB Visualizer, Microsoft Visio

Hire Now