We provide IT Staff Augmentation Services!

Sr. Oracle Pl/sql Developer Resume

New York, NY

PROFESSIONAL SUMMARY:

  • Oracle PL/SQL Developer with around 9+ years of professional experience in Design, Development and Implementation of enterprise Oracle databases applications in both OLTP and Decision Support systems.
  • Vast experience in BFSI, SCM, Pharma and Banking Regulatory Reporting domain.
  • Expert in designing, developing, testing, and implementing PL/SQL triggers, cursors, stored procedures, packages, functions at database level and reporting level.
  • Expertise in Data Modeling using ERWIN, Data mart and OLAP for business analysis using Star & Snowflake schemas for faster and effective querying.
  • Experienced in Data Extraction, Transformation and Loading (ETL) processes using SQL Loader, PL/SQL procedures and Informatica PowerCenter.
  • Adept at SQL and PL/SQL programming, developing complex code units, database triggers and using the latest features to optimize performance (Bulk Binds, Materialized views, Inline views, Global Temporary Tables).
  • Extensive knowledge and understanding of Data Modeling concepts, UML diagrams and various types of Design Patterns.
  • Involved in design, development, implementation, data migration, data conversion, testing and documentation of business applications using Oracle technologies.
  • Proficient in Dynamic SQL, UNIX shell scripting, Performance Tuning and Query Optimization
  • Expertise in Tuning Queries for better performance with large volume of data.
  • Performed logical database backup and recovery using Oracle’s EXPORT/IMPORT.
  • Adept in key Oracle performance - related features such as Query Optimizer, Execution Plans, Hints, Indexes, Clusters, Partitioning.
  • Worked as ORACLE DBA at times.
  • Experience in development of complex query reports according to user requirement using Oracle Reports.
  • Quick learner with ability to master new concepts and applications.
  • Experienced in, Documentation and Implementation in a business environment.
  • Extensively experienced in interacting with business analysts and developers to analyze the user requirements, functional specifications and system specifications.
  • Hands-on experience in developing Master Detail Forms, Query Find Forms, Multiple canvases using Oracle Forms.
  • Performed various types of testing, such as functional, system, regression and user acceptance testing.
  • Excellent communication, interpersonal, analytical skills and strong ability to perform as an individual or as part of a team.

BUSINESS/TECHNICAL SKILLS:

Oracle 12c/11g/10g/9i/8i, SQL, PL/SQL, TOAD for Oracle, PL/SQL Developer, SQL Navigator, Erwin Data Modeler, Microsoft VSS, Oracle Forms and Reports 10g/9i/6i, TFS, WinCVS, VersionOne Sprint tracking, XML, Unix Shell Scripts, Powershell scripting, Control-M, HP ALM 12.5, JIRA, Tortoise SVN, Tortoise Git, Jenkins, Confluence, Apache Impala, MS Office Suite, C, C++, Unix, Linux, Windows.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Basel III and Basel IV regulatory reporting application development to bring and trade data from upstream and provide processed results to downstream applications
  • On-site lead for BMR Data Mart application
  • Requirement gathering and analysis along with application design to meet regulatory reporting expectations
  • Document technical and business specifications on intranet Confluence pages
  • High level data flow architecture design for big data migration
  • Coordination with different teams for data and reporting related issues
  • Technical and functional review for the new requirements with the business
  • Database Performance tuning using different techniques including hints, partitioned tables and explain plans
  • Participate and follow Agile Methodology practices such as Sprint Planning, scrums and coordinating with QA.
  • Solution Development using Oracle SQL and PL/SQL by building different database objects including Stored Procedures, Functions, Packages, Views, Sequences, Ref Cursors and Collections
  • Unix Shell scripting for batch scheduling and file transfers among different applications
  • Application performance and data analysis
  • On-site/Off-shore coordination
  • Production support on business critical issues

Tools: and Technologies: Oracle 11g, PL/SQL, UNIX, Toad for Oracle v11.6, Control-M, HP ALM 12.5, JIRA, Tortoise SVN, Tortoise Git, Jenkins, Confluence, Apache Impala

Confidential, Morristown, NJ

Sr. Oracle PL/SQL Developer

Responsibilities:

  • FDA Transparency reporting application development to present accurate spending information by clients on Health Care Practitioners (HCPs) which comes via CSVs and provide processed results to users for reporting
  • Requirement gathering and analysis along with application design to meet regulatory expectations
  • Coordination with users and business for data and reporting related issues
  • Technical and functional review for the new requirements with the business
  • Database Performance tuning using different techniques including hints and explain plans
  • Solution Development using Oracle SQL and PL/SQL by building different database objects including Stored Procedures, Functions, Packages, Views, Sequences, Ref Cursors and Collections
  • Powershell scripting for scheduling file processing
  • Application performance and data analysis
  • Production support on business critical issues

Tools: and Technologies: Oracle 12c, PL/SQL, Powershell, Toad for Oracle v11.6, Job Scheduler, Confluence, JIRA, TFS

Confidential, New York, NY

Sr. Oracle PL/SQL Developer/Data Tech Lead

Responsibilities:

  • Interacting with end users to gather requirements for features and enhancements which involves building a web-based global analytical tool that allows Credit Rating Analysts at S&P to generate committee packages efficiently for reviews, demonstrate the link between criteria and analysis, work in collaborative manner.
  • Solution Development using Oracle SQL and PL/SQL by building different database objects including Stored Procedures, Functions, Packages, Views, Triggers, Sequences, Ref Cursors and Collections.
  • Performance Tuning of PL/SQL objects and Views using Indexes and Explain Plan.
  • Resolution of defects and incidents raised by end users and client.
  • Database Objects’ Migration and movement to different environments along with Production rollout activities.
  • Generating XML parsing data from database for Publishing environment using DBMS XMLGEN package.
  • Actively participate and follow Agile Methodology practices such as Sprint Planning, coordinating with QA testing and Product owner acceptance.
  • Participating in Story sizing and effort estimation sessions and providing inputs.
  • Coordinating with offshore team for on-time and quality deliverables.
  • Responsible for coordination with the teams whose applications are integrated with the application under development.
  • Coordinate with Product owners for user management related issues.
  • Communicate with project managers the progress of application development; generate application performance and user usage reports for analysis done by senior management; work with other developers and infrastructure resources.
  • Responsible for producing technical documentations and test case documents.

Tools: and Technologies: Oracle 10g/11g, PL/SQL, Erwin, Toad for Oracle v11.6, HP Quality Center v10, XML, VersionOne Sprint Tracking, WinCVS.

Confidential, Somerset, NJ

Sr. Oracle Developer

Responsibilities:

  • Gathered the requirements and documented high level documentation for the project.
  • Involved in the business requirements gathering and analysis, understanding client’s Data Warehousing requirements and system analysis.
  • Designed Logical data model and Physical conceptual data model using Erwin.
  • Performed database design, tuning using Oracle Job Scheduler, Oracle Advanced Queuing.
  • Applying constraints and writing triggers to apply the business rules.
  • Involved in handling Errors and Transaction Processing in the Procedures.
  • Created Records, Tables, Objects, Collections (Nested Tables and Arrays), and Error Handling.
  • Performed Data Migration using SQL* Loader from flat files into database tables.
  • Extensively involved in Writing PL/SQL Stored Procedures, Triggers, Functions, and Packages to meet the business requirements.
  • Created custom partition tables for reporting.
  • Responsible for SQL tuning using explain plan and optimizer hints.
  • Used Ref-cursors and Collections for accessing complex data resulted from joining of large number of tables.
  • Handled exceptions for the ease of debugging and displaying the error messages in the application.
  • Performed code reviews and acceptance testing of the application.

Tools: and Technologies: Oracle 10g/11g, Oracle Forms 10g, Oracle Reports 10g, PL/SQL, Erwin, UNIX, Shell scripting, SQL*Loader, Oracle SQL Navigator, Toad for Oracle.

Hire Now