oracle pl/sql developer

Singdha

Sr. Oracle PL/SQL Developer

Phone-469-***-****

Email- **********@*****.***

Professional Summary:

8+ years of extensive experience in Oracle development, Support and Migrations projects on different domains.

Expertise in Software Development Life Cycle (SDLC) of client implementations including Requirements Gathering, Business Analysis, System Configuration, Design, Development, Testing, Technical Documentation and Support.

Well versed in developing various database objects like Packages, Stored Procedures, Functions, Triggers, and Tables, Indexes, Constraints, Materialized Views, and others in Oracle 19c/12c/11g/10g /9i database.

Expertise in developing and customizing Oracle Forms and Reports using Oracle Forms 12c/11g/9i/6i, Reports 12c/10g/9i/6i, XML Publisher and developing concurrent programs using SQL, PL/SQL.

Strong experience in providing technical documentation and status reports of the applications as per the requirement.

Experience in using UNIX Shell Scripting to automate the processes. Proficient with

Data Modelling concepts like ER Diagram, UML, Working Experience in Data extraction, Transmission and Loading (ETL).

Experience on writing oracle PL/SQL stored procedures, Functions, Packages, DB Triggers, Indexes, DB Views for building and maintaining an application.

Prepare/Maintain documentation on all aspects of ETL processes, definitions, and mappings to support knowledge transfer to other team members.

Wrote stored procedures and UNIX scripts as a part of ETL Process.

Worked on building ETL Processes with sources from Flat Files, Mainframes, SQL Server, and Oracle, and played a vital role in the Team to get the things done.

Expertise in design, development and deployment of end user screens and reports using Oracle tools, Oracle Forms and Reports.

Worked in debugging and tuning the PL/SQL code, explain plan, tuning queries, and optimization for the Oracle database.

Loaded Data into Oracle Tables using SQL Loader.

Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

Prepare/Maintain documentation on all aspects of ETL processes, definitions, and mappings to support knowledge transfer to other team members.

Automating data loading, extraction, reports generation using UNIX Shell scripting.

Worked on oracle database upgrade from 12c to 19c.

Experience in handling very large data files using Export-Import Utilities and SQL*Loader.

Solid experience in writing complex SQL queries and PL/SQL procedures to extract data from various source tables.

Continuous delivery/ Continuous Integration for various applications by integrating various tools like GitHub, Jenkins, Urban code deployment, Harbor and Concourse.

Proficient in loading data from flat files into database tables using SQL*Loader scripts.

Worked with Arrays, Records, Dynamic SQL, and Exception Handling.

Involved in Performance Tuning which included creating indexes, partitioning tables, providing Hints, modifying tables using Explain Plan, SQL trace and TKPROF.

Worked with tools like PL/SQL Developer, SQL Developer, SQL*Loader, TOAD, SQL plus.

Efficient in creating Test cases and performed data validation and process testing for application moving into production.

Knowledge of Principles of Data Warehouse using Fact Tables, Dimension Tables and Star/Snowflake schema modeling.

Have worked in Agile and Kanban environment.

Highly organized and efficient to prioritize and manage multiple tasks.

Proven ability to work efficiently in both independent and teamwork environments.

Technical Skills:

Languages SQL, PL/SQL, UNIX, Shell scripts

Databases Oracle 18c/12c/11g/10g/9i/8i, MS SQL Server 2008/2005, DB2 v8.1

Operating Systems UNIX, Linux, Windows (95, NT, 2000), MS-DOS, Z/OS

Reporting Tools Oracle Forms and Reports, Jasper Server, Crystal Reports, SQL Server Reporting Services, BI Publisher

Tools & Utilities Informatica, DataStage, Expeditor, Lotus Notes, Insync, Win Runner, load runner, FTP, MQ-Series, SAR Report, JIRA

ETL Tools: Informatica Power Center 9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server)

Web Technologies JAVA, XML, HTML, UML, ASP Server, Java Script

Data Modeling tools: Erwin, MS Visio

Testing Tools QTP, WinRunner, LoadRunner, Quality Center, Test Director

Professional Experience:

Credit Acceptance, Southfield MI Feb 2022 - Present

Sr Oracle PL/SQL Developer

Roles & Responsibilities:

Works in Software Development Life Cycle (SDLC) of client implementations including Requirements Gathering, Business Analysis, System Configuration, Design, Development, Testing, Technical Documentation and Support.

Meetings with Business Analysts and Business Objects team to understand the requirements and translate the requirement into technical specifications.

Worked in Kanban methodology and participated in daily stand-up meetings.

Used JIRA as part of Kanban to move tasks from one activity to another.

Wrote stored procedures and UNIX scripts as a part of ETL Process using informatica.

Strong experience in providing technical documentation and status reports of the applications as per the requirement.

Upgrade to oracle 19c from 12c for multiple applications.

Worked on re-compilation of the procedures and oracle forms for 19c upgrade project.

Configured the INI files to point to oracle 19c database from 12c database.

Developed Shell Scripting in Unix environment to call the ESP batch jobs and database packages.

Experience in working on DevOps operations process and tools area (Build & Release automation, Environment, Service).

Worked on developing PL/SQL store procedures and packages to automate various systems and tasks (e.g., automating code builds and deployments) using Jenkins, Git.

Expertise in developing and customizing Oracle Forms and Reports using Oracle Forms/Reports, and developing concurrent programs using SQL, PL/SQL.

Developed and maintained the build environment from the source code control system and managed build packages using Jenkins.

Implemented an automated test strategy for testing the functionality of services using Concourse-Ci and Rancher.

Automated, consistent deployments and rollbacks of applications.

Create a CI/CD pipelines using Jenkins for automation project.

Knowledge on creation and working process of Harness, Concourse-CI and Rancher for CI/CD.

Create a mapping using Informatica power center.

Extensively used cursors, ref cursors, User defined object types, Records in PL/SQL Programming.

Used Quest SQL optimizer for oracle to optimize the query for the performance tuning.

Built and maintained SQL Scripts, Indexes, reports and queries for data analysis and extraction.

Involved in Code Reviews and business testing reviews meetings.

Provided support to the Business.

Environment: Oracle 19c,12c, Oracle Forms 12c, Oracle Reports 12c, Windows 11,10, SQL Developer, Toad, Unix Shell Scripting, CA workstation (ESP), Informatica Power center, GitHub, Concourse, Rancher.

Amex, New York, New York Dec 2020 – Feb 2022

Oracle PL/SQL Developer

Roles & Responsibilities:

Worked in agile environment and participated in Daily status meetings to update the status of work.

Worked on Design, Development and Testing of Conversions, Interfaces, Workflow and Reports.

Meetings with Business Analysts and Business Objects team to understand the requirements and translate the requirement into technical specifications.

Involved in writing SQL queries, PL/SQL programming and created new packages and procedures and modified and tuned existing procedure and queries using TOAD.

Widely used PL/SQL tables and Bulk Collect for processing the load on tables and retrieving into Oracle.

Developed Perl program to call database package jobs run successfully.

Developed SQL queries to update the data in the database tables.

Developed complex SQL queries to perform the back-end testing of the Oracle database using UNIX shell commands.

Developed Oracle forms using oracle forms builder to add buttons, triggers, exceptions, and items as per the business requirement.

Developed Oracle reports using oracle report builder and to create a new oracle report as per the business requirement.

Editing the existing oracle reports using oracle report builder by using report editor function.

Changing the layout of the oracle reports by using layout function of the oracle report builder.

Running test flows in the test environments with prod data file to fulfil business needs.

Monitoring the jobs using CA workstation.

Developed complex SQL queries and export to excel sheet to display them for the business requirement and audit purpose.

Tuned Informatica mappings and sessions for optimum performance.

Assisted the other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.

Created PL/SQL Stored Procedures, Functions, Packages and Triggers, extensively used cursors, ref cursors, User defined object types, Records in PL/SQL Programming.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Extensive querying using SQL*plus / TOAD to monitor quality and integrity of data.

Proficient in advance features of Oracle 12c for PL/SQL programming like using cursor, variables, Reference cursors, Varrays, nested tables, Dynamic SQL, and Bulk Binds.

Built and maintained SQL Scripts, Indexes, reports and queries for data analysis and extraction.

Worked on Scheduler to schedule Jobs/Packages for running.

Involved in Code Reviews and test Reviews to make a second opinion.

Conducted the review meetings with business before the implementation scope lock.

Provided support to the User/Customer incase if they have any questions on running the Reports.

Used GitHub, Jenkins, and Urban Code Deployment to deploy code to production.

Involved in 24/7 production support as per the iteration basis.

Environment: Oracle Database 11g/12c, Windows 7/10, SQL Developer, java 1.8, Oracle Form Builder, Oracle Report Builder, Toad, PLSQL, Informatica, Unix Shell Scripting, CA workstation

Safeway, Pleasanton, California Jan 2020 – Nov 2020

Oracle PL/SQL Developer

Roles & Responsibilities:

Involved in Design, Development and Testing of Conversions, Interfaces, Workflow and Reports.

Collaborated with Business Analysts and Business Objects team to understand the requirements and translate the requirement into technical specifications.

Coordinated with the front-end design team to provide them with the necessary stored

Procedures and packages and the necessary insight into the data.

Involved in writing SQL queries, PL/SQL programming and created new packages and procedures and modified and tuned existing procedure and queries using TOAD.

Strong knowledge of Extraction Transformation and Loading (ETL) processes using

UNIX shells scripting, SQL, PL/SQL, and SQL Loader.

Widely used PL/SQL tables and Bulk Collect for processing the load on tables and retrieving into Oracle.

Developed complex SQL queries to perform the back-end testing of the Oracle database using UNIX shell commands.

Used Oracle hints like parallel to execute the query in parallel which therefore increased the performance.

Created PL/SQL Stored Procedures, Functions, Packages and Triggers, extensively used cursors, ref cursors, User defined object types, Records in PL/SQL Programming.

Worked on Tuning of the SQL queries, which takes long time to process the request using Explain Plans to reduce the response time.

Extensive querying using SQL*plus / TOAD to monitor quality and integrity of data.

Extensively worked in performance tuning of programs, ETL procedures and processes and used debugger to troubleshoot logical errors.

Proficient in advance features of Oracle 11g for PL/SQL programming like using cursor, variables, Reference cursors, Varrays, nested tables, Dynamic SQL, and Bulk Binds.

Built and maintained SQL Scripts, Indexes, reports and queries for data analysis and extraction.

Participated in Daily status meetings to update the status of work.

Worked on Scheduler to schedule Jobs/Packages for running.

Performed Unit Testing and Integration Testing of the Application. Involved in preparing documentation and user support documents.

Proactive tuning of SQL /PLSQL issues.

Involved in Code Reviews and test Reviews and participated in Quality Audits.

Developed complex SQL queries to perform the back-end testing of the Oracle database using SQL and UNIX shell commands.

Worked on job scheduling using DBMS_SCHEDULER.

Provided support to the User/Customer incase if they have any questions on running the Reports.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Worked extensively on different types of transformations like expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator, Normalizer, and joiner.

Involved in 24/7 production support as per the need basis.

Environment: Oracle Database 10g/11g, Windows 8, PL/SQL Developer, Toad, XML, SQL, PLSQL, Unix Shell Scripting.

Capital one, Mclean, VA Oct 2018 – Dec 2019

Oracle Developer

Responsibilities:

Analyze the Business Requirements (BRD) and convert them into Technical Specification (Technical Design Document).

Worked with Business Analysts, Business users, IT leads and system Analysts to understand the requirements and translate the requirement into technical specifications.

Involved in all phases of Design, code, test, and debug programs of varying levels of complexity.

Prepared technical documentation, create test plans and perform testing.

Created PL/SQL Stored Procedures, Functions, Packages and Triggers, extensively

used cursors, ref cursors, User defined object types, Records in PL/SQL Programming.

Expertise in developing Forms and Reports and developed PL/SQL Packages, Stored procedures, Triggers, Tables, joins, Indexes, and sequences.

Involved in writing SQL queries PL/SQL programming and created new packages

and procedures and modified existing procedure and queries using TOAD.

Involved in the generation of User Interface using oracle forms by extensively creating forms as per the client requirements.

Developed and customized existing reports and forms as per client specific requirements using Oracle Reports and Forms Builder 11g.

Involved in Updating PL/SQL Functions, Procedures, and Packages, Cursors, for validation and loading of data based on current requirement.

Involved in Unit testing, integration testing and supporting testing during QA and UAT phase.

Customized Forms and Reports by changing size of the fields adding new fields into the display, changing the layout of the Report and forms appropriate.

Developed and customized existing reports as per client specific requirements using Oracle Reports Builder 11g.

Created layout wizard and data block wizard in Oracle forms.

Monitored database performance using Oracle Enterprise Manager (OEM).

Used EXPORT/IMPORT to move csv's from salesforce to Oracle and vice versa.

Successfully performed data migration from Exadata servers to Oracle servers.

Migration of existing data from MS access to Oracle.

Created new reports for generating automatic weekly/Monthly Reports as per user requirement in production Support.

Fixing bugs, Client Feeds setup and maintenance, Data loads and Data migration support.

Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.

Developed Procedures for efficient error handling process by capturing errors into user managed tables.

Involved in Unit testing, code reviewing and preparing design specification document.

Analyzing the issues, performing extensive defect fixing in Production support through HP Service Manager.

Involved in database development by creating PL/SQL Functions, Procedures, and Packages, Cursors, Error handling and views.

Debugging and Fixing Production Data.

Involved in production release and support of PL/SQL, Oracle Forms and Reports.

Environment: Oracle Database 11g, Windows 8, UNIX, SQL Developer, Toad, XML, SQL, PLSQL, Unix Shell Scripting, Forms Builder 11g, Reports builder.

GGK Technologies Jun 2013 - Jul 2017

PL/SQL Developer

Roles & Responsibilities:

Involved in all phases of software development including gathering requirements, creating specifications, development of database objects, developing code and validating programs.

Extensively developed PL/SQL Packages, Stored procedures, Triggers, and finely tuned them for performance. Extensively used PLSQL tables and Bulk loader programs for processing data and loading into oracle tables.

Wrote generic PL/SQL code modules (PL/SQL Libraries) for Reports to handle data manipulations on client.

Developed back-end interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections and Triggers.

Designed and implemented client-server application using Oracle Forms Builder.

Involved in the generation of User Interface using oracle forms by extensively creating forms as per the client requirements.

Developed Data Analysis for Erwin Logical and Physical model design, Oracle (PL/SQL packages, triggers) development, UAT for Oracle objects.

Proactively tuned SQL queries leading to significant improvement in system response time and efficiency.

Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.

Performed various activities like creating, debugging, and modifying data base objects and User defined functions and finely tuned them for performance.

Developed complex SQL queries to perform the back-end testing of the Oracle database using SQL and UNIX shell commands.

Created and monitored the Oracle DBMS JOBS as a part of weekly tasks.

Involved in fixing bugs within Packages and Stored Procedures.

Involved in Tuning Database & Application performance using Explain Plan.

Involved in the Daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.

Performed Unit Testing and Integration Testing of the Application. Involved in preparing documentation and user support documents.

Involved in 24/7 production support as per the need basis.

Environment: Oracle Database 10g, Windows 7, UNIX, SQL Developer, XML, SQL, PLSQL, Unix Scripting, Perforce, Putty.

Education:

Bachelors in Computer Science from JNTU H.

Masters in Data Analytics from George Mason University, VA.

Contact this candidate