We provide IT Staff Augmentation Services!

Sr. Oracle Pl/sql Developer Resume

SUMMARY

  • Having 7+ years of IT industry experience in fully engaged in Software Development Life Cycle (SDLC) which includes gathering and analyzing business requirements for business Intelligence, functional/technical specifications, designing, developing, testing, deploying the applications and providing production support.
  • Large Scale experience in Packages, Stored Procedures, Functions, Triggers, Cursors, Ref Cursors, Constraints, Indexes, Views, Materialized Views, Sequences, Synonyms, and Global Temporary tables, Cursor management, Exception handling etc. by writing Oracle SQL and PL/SQL code.
  • Extensively involved in writing SQL Queries (Sub queries and Join conditions), PL/SQL subprograms and Query Level and application level (Explain Plan) Performance tuning.
  • Proficient in Data Analysis, Data Validation, Data Lineage Data Cleansing, Data Verification and identifying data mismatch in data loading process.
  • In - depth experience in Client-Server application development using Oracle 19c/11g, PL/SQL, SQL *PLUS, TOAD, SQL *LOADER.
  • Strong understanding of end-to-end project management, SDLC methodologies of Waterfall and Agile.
  • Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
  • Exposure in using Tools like TOAD, SQL Developer and SQL*Plus for writing PL/SQL Programs.
  • Experience in creating complex triggers or generate packages and indexes to increase performance and complex SQL queries for joining multiple tables.
  • Extensive experience developing External tables and using Oracle utility tools like SQL*Loader, Import and Export programs.
  • Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
  • Developed Test Scripts, Test Cases and SQL QA Scripts to perform Unit Testing, System and Load Testing.
  • Experience with data migration using BULK COLLECT.
  • Strong SQL Server DDL, DML skills with expertise in writing efficient queries and troubleshooting complex queries.
  • Knowledge in the design and development of interactive data, data visualizations, graphical dashboards and reports using any tools like Tableau.
  • Extensive Knowledge on Tableau Desktop, Tableau Public, Tableau Reader and Tableau Server.
  • Data integration and migration specialist with extensive experience in leading the conversion of multiple legacy data systems from different sources into Oracle databases.
  • Experience in installation of Agents on Hosts in both OEM12c & OEM 13c, Database Health checkup & Performance tuning running AWR report taking backups creating users by OEM 13c
  • Comfortable with advanced tableau topics such as complex calculations, table calculations, Filters, parameters, data blending, extract optimization.
  • Knowledge in Designing & Formatting Dashboards using Tableau.
  • Excellent skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Cursors, DDL/DML Triggers, Temporary tables, User Defined Data types (UDF) and Functions.
  • Quick learner, excellent communication skills and good performer both in team and independent job environments. Never missed the deadline of any projects.

TECHNICAL SKILLS

Operating Systems: Windows 98/NT/2000/XP/2003, MS-DOS, UNIX

Languages: SQL, PL/SQL, Shell Scripting, XML, C, C #, HTML, PERL, Python

RDBMS: Oracle 9i/10g/11g/19c, MS Access

GUI: Oracle Forms 6i/9i/10g, Oracle Reports 6i/9i/10g, XML Publisher, Oracle APEX

Utilities: Toad, SQL*Plus, SQL*Loader, PUTTY, MS Office, WinSCP, SQL Developer, Autosys.

Data Warehousing/ETL: IBM Data Stage 8.5,8.1.1, 8.1, 8.0.1 /7.5.1 , Quality Stage 8.1, Informatica Power Center, SSIS.

MDM: IBM InfoSphere MDM 9x/11x

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Created database objects like packages, procedures, and functions according to the client requirement.
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
  • Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
  • Created custom PL/SQL procedures to read data from flat files to dump to oracle database using SQL Loader.
  • Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
  • Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
  • Creation of database objects like tables, views, materialized views, procedures, packages using Oracle tools like SQL Loader.
  • Used bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
  • Involved in the continuous enhancements and fixing of production problems.
  • Coordinated and delegated work to Offshore team.
  • Reviewed the deliverables from offshore and communicated changes to developers.
  • Actively participated in Clarification Meetings with the Clients.
  • Design and develop PL/SQL packages.
  • Extracted data from existing data stores and perform ad - hoc queries.

Environment: Oracle 11g/19c, Erwin, SQL*Plus, Solaris, PUTTY, DB2, Git, svn, python, Jenkins, MAN.

Confidential

PL/SQL Developer

Responsibilities:

  • Interacting with business analysts and participated in user requirement sessions to analyze and gather business requirements.
  • Wrote Loader scripts using SQL Loader/External tables to load large tables.
  • Coordinating with the front - end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • Designed and developed the classes using core Java for thread safety in money transactions using Multithreading.
  • Worked on the bulk uploading of huge amounts of statistical data to the database.
  • Responsible for developing and modifying several PL/SQL packages, procedures, functions, views and triggers using PL/SQL.
  • Optimized a lot of SQL statements and PL/SQL blocks by analyzing the execute the plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
  • Actively involved in troubleshooting database issues.
  • Provided SQL and PL/SQL code tuning to improve database response time and performance for several applications.
  • Developed Oracle Stored Procedures, Functions and Packages to effectively in corporate Business rules.
  • Worked with Dynamic SQL, Global Temporary Tables.
  • Created materialized views, Inline Views & normal views where business requirements needed.
  • Extensively used bulk collection in PL/SQL objects for improving the performing.
  • Developed stored procedures and packages. Extensive work in PL/SQL.
  • Developed Reports and forms using Oracle Designer.
  • Worked with development of packages and procedures using PL/SQL and functions using ETL and PL/SQL.
  • Worked on developing/supporting Oracle APEX applications.
  • Resources are needed to help support additional applications that will be acquired by our team. They will need to provide run the engine and production support.
  • They will also be asked to perform risk assessments and add needed controls to close any control gaps.
  • Extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing and Documentation.
  • Wrote Unix shell scripts to process the files daily like renaming the file, extracting the date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.

Environment: Oracle 11g/10g,Erwin, SQL*Plus, TOAD, Autosys, Unix, PUTTY, Data stage, Siebel, HP life cycle, Star Team, Java RTC, Sql Server.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Created materialized views on remote source database and automated scheduler of refreshing of materialized view on source side.
  • Extracted data from the source views by writing the procedures to load the data into staging tables.
  • Created SQL Loader script generator application using UNIX shell scripting and PL/SQL.
  • Created the tables and sequences for the experimental data load capture.
  • Importing data from different varieties of sources like a flat file, excel file or Oracle dump file into oracle database source schema tables using SQL Loader.
  • Wrote Packages to store the business rules and exceptions and wrote PL/SQL code to load data from staging tables to the target schema.
  • Enhanced it with creating exceptions for error handling.
  • Written complex Oracle SQL queries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators.
  • Database security by authenticating users, using logon triggers.
  • Created indexes on tables and optimized procedure queries.
  • Prepared UNIX Shell Scripts and these shell scripts will be scheduled in AUTOSYS for automatic execution at the specific timings.
  • Analyze and debug complicated PL/SQL procedures for permanent fix job failures.
  • Code PL/SQL procedures, functions, packages etc. as part of the enhancement requirement.
  • Responsible for Unit, System and UAT testing the data and provided the test evidence reports.
  • Populating the database, exporting and importing data, and creation of packages, triggers, functions and stored procedures for implementing the business logic and database intensive logic.
  • Writing and modifying Oracle SQL statements and PL/SQL procedures and functions that are called in the Java methods to implement microservices.

Environment: Oracle 11g/10g,Erwin, SQL*Plus, TOAD, Autosys, Unix, PUTTY, MS Office, SSIS.

Confidential

Database Developer

Responsibilities:

  • Experience with Data Analysis, Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques
  • Created the DB-Links pointing to the remote database to access the source materialized views.
  • Created or Modified the SQL Script (.sql file) to point to the current source.
  • Extracted data from the source views by writing the procedures to load the data into staging tables.
  • Work as part of a development team and establish close working relationships with stake holders, quality assurance, architects, as well as management
  • Work with the database developers, software developers and Development Lead, to architect and implement new features and solutions for customers
  • Created the tables and sequences for the experimental data load capture.
  • Developed UNIX Shell scripts to automate table creation, execute procedures.
  • Extensively used database monitoring tool to monitor servers for deadlocks, long runtime queries, stored procedures and performance tuning as necessary
  • Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.
  • Developing test automation scripts in Oracle PL/SQL and Review of test queries and results
  • Writing SQL queries to analyze data consistency
  • Data analysis to make sure the logical and physical conversion of data is correct.
  • SPOC of Quality processes in the project.

Environment: Oracle 10g, SQL*Plus, PUTTY, MS Office

Hire Now