We provide IT Staff Augmentation Services!

Lead Pl/ Sql Developer Resume

Jersey City, NJ

PROFESSIONAL SUMMARY:

  • Oracle PL/SQL developer with almost 12+ years of experience in Application Development of experience in Oracle APEX.
  • Proficient in Oracle Applications HRMS Module, SQL, PLSQL programming, Oracle Application Express (APEX).
  • Technical strengths include solid working knowledge of: Unix, C, SQL Server 2000/2005, Oracle 9i/10g/11g/12c, MYSQL, SQL, PL/SQL, T - SQL, Developer 2000/6i/9i, Unix Shell Scripting, SQL*Loader, Erwin, ASP.Net, C#, Toad, SAS, BO Crystal Reports 7.0/8.0/9.0, Congo’s 10 Framework Manager, Visual C++ 5.0/6.0; SQL Server BI, SSIS.
  • Working experience in C#.Net, ASP.Net, VB.Net and ADO.Net.
  • Knowledge areas include Oracle applications- Financials, Purchasing, Service contracts, Form Personalization, Report customization and XML/BI Publisher.
  • Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.
  • Experienced in developing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
  • Hands on experience in WCF.
  • Excellent in development of Interfaces and conversion Programs to integrate Oracle Applications modules to import data into Oracle Applications using Data Load, SQL * Loader, PL/SQL, UTL File Utility.
  • Experience in designing and development of Oracle Forms 9i/10g/11g and Reports 9i/10g/11g.
  • Excellent SQL skills, expertise in writing Complex SQL queries, PL/SQL Stored Procedures, Functions and Packages for business needs.
  • Proficient in advance features of Oracle for PL/SQL programming like using cursor variables, Ref. cursors, Arrays, nested tables, DB Links, collections and exceptional handling.
  • Worked on creating SQL*Loader control programs, PL/SQL validation scripts for validating and pre-import of legacy data from feeder systems to Oracle.
  • Very Strong skills and clear understanding of requisites and solutions to various issues in implementation and upgrade throughout the Software Development Life Cycle(SDLC) which include Analysis, Design, Development and Testing.
  • Experience in advanced PL/SQL concepts like Bulk collect, PL/SQL tables and for better performance.
  • Strong in using tools such as TOAD, SQL*Plus, SQL Developer
  • Proficient in Oracle 11g/10g/9i/8i, PL/SQL back end applications development Toad, SQL Plus, and PL/SQL Developer.
  • Experience in Debugging, Testing, and Deploying the Applications
  • Highly organized, self-learning and independent; able to effectively coordinate tasks to accomplish projects with timeliness and creativity.
  • Well-versed with various stages of Software Development Life Cycle (SDLC
  • Excellent planning, analytical, written Communication and Interpersonal skills.

TECHNICAL SKILLS:

Database: Oracle 7.x,8.x, 9.x, 11g,12c, MS SQL SERVER 2005,2008,2012, PostgreSQL and MS Access.

Development tools: SQL, PL/SQL, Oracle utilities.

Designer tools: Oracle Forms, Oracle Reports, BI Publisher, Tableau 9.x,10.3, Oracle Database Designer, SQL Data Modular, Mongo DB 3.4. Erwin and MS-Visio, MS office

ETL Tools: SQLLDR and UTL Packages, Informatica, SSIS, SSRS Cognos 10.3

OLAP Tools: Microsoft Analysis Services, Business Objects

Database tools: SQL Developer, PLSQL Developer, DB query tool & TOAD, Oracle APEX

Job Schedulers: ORACLE Schedulers / SQL agent

Operating Systems: Windows, Unix, Open VMS

Web Technologies: Asp, JavaScript, VB Script, HTML, XML, VB.NET, ASP.NET, C#.NET, Python Programming

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

Lead PL/ SQL Developer

Responsibilities:

  • Develop database objects, table design and create scripts.
  • Development of packages, procedures, functions and triggers using PL/SQL programming language.
  • Conduct until testing and Release level testing of database components.
  • Deploy the code in production during the Weekly and Monthly Enterprise releases.
  • Expertise in Dynamic SQL, Bulk Collections and Exception handling.
  • Development of PL/SQL Packages, Procedures, Functions, Views and Triggers.
  • Analyze existing PL/SQL code, Debug, Test and enhance the package codes.
  • Involved in the continuous enhancements and fixing of production problems.
  • Resolved different kinds of tickets issued to us, which involved in UNIX shell scripting, modifying database tables, hands on UI changes using HTML5.
  • Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Used to create Classes using VB.Net to implement high-level business logic based on the Requirement document.
  • Developed PL/SQL triggers on master tables for automatic creation of primary key values.
  • Created scripts for new tables, views, queries for new enhancements in the application using TOAD/SQL developer.
  • Responsible for new database interface development using PL/SQL Database Programming Language
  • Created indexes on the tables for faster retrieval of the data to enhanced database performance.
  • Upgraded Oracle 11g to 12g software in different environments for latest features and tested databases.
  • Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
  • Performance tuned the interfaces, queries through use of indexes, ranks, Oracle hints, exchange partitions etc.
  • Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
  • Created tickets to other development teams for supporting applications.
  • Involved with users to understand the problem they have and train them with work around for similar issues.
  • Hands-on experience working as Production DBA and working with Oracle Support by raising SR.
  • Worked on performance and tuning on SQL queries wherever it is required.
  • Expertise in Reading SAP IDOC segments from data files and process them by loading into oracle database using SQL Loader.
  • Database design, SQL tuning, Index management & analysis, Analyze Schema, rebuild Indexes.
  • Worked in Oracle jobs and Crontab Scheduler.
  • Expertise in SQL Loader, logical backups and data pumps - expdp/impdp.
  • Creation and Maintenance of materialized views for data replication in distributed environments.
  • Database design, SQL tuning, Index management & analysis, Analyze Schema, rebuild Indexes.
  • General database administration including the management of tablespaces, temp space, datafile maintenance, and schema management.
  • Enforces and maintains database constraints to ensure integrity of the database.

Environment: Oracle 9i, 10g, 11g, Unix, SQL *Loader, SQL*Plus, Data Pump, RMAN, Toad, VB.Net, SQL Navigator, Putty, WinScp, SQL Developer, WinFTP, Visual Source Safe, SharePoint.

Confidential, Jersey City, NJ

Lead PL/SQL Developer

Responsibilities:

  • Analyzed, designed, developed, tested, deployed and implemented the applications.
  • Developed application and database triggers, functions, procedures, and packages in PL/SQL, Oracle12g as back-end.
  • Designed, developed, tested and reviewed ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
  • Developed advanced SQL queries to extract or manipulate the data staged in different domains.
  • Perform data verification, validation, and transformations on the Input data from different sources before loading into target database.
  • Developed ETL processes to load data from different source systems such as Oracle and Flat Files into target systems i.e. Oracle and Flat files. Extracted the data from Oracle10g, Netezza, XML, Flat files, DB2 load the data in to Oracle warehouse.
  • Used to create Classes using VB.Net to implement high-level business logic based on the Requirement document.
  • Supported the applications in production environment based on Oracle Forms, Reports, Oracle database and the UNIX server.
  • Experienced working with messaging using ORACLE AQ and ORACLE MQ.
  • Developed UNIX Shell Scripts to execute procedures and publish the files.
  • Perform back-end testing on the Oracle database sources as well as targets by writing SQL queries
  • Created various SQL and PL/SQL scripts for verification of the required functionalities.
  • Created Records, Tables, Objects, Collections (Nested Tables and Varrays), Table Partitioning, Error Handling, External Tables, Primary Key, Composite Key.
  • Worked on optimizing existing procedures and functions using PL/SQL.
  • Worked on modifying various existing packages, procedures, functions and triggers per the new business needs.
  • Developed triggers and packages to delete stored session data from various tables.
  • Developed ad hoc queries/reports per the user requirements.
  • Developed, modified tested and implemented UNIX Shell Scripts to execute procedures and publish the files.
  • Created, modified and tested SQL scripts.
  • Worked on Dynamic SQL and PL/SQL block in PL/SQL.
  • Wrote various kinds of SQL queries involving Correlated Sub queries, UNION, Inner and Outer Joins (using ANSI SQL)
  • Involved in Performance Tuning.

Environment: SQL, PL/SQL, Unix Shell Scripting (ksh), Oracle 11g, SQL*Plus, SQL*Loader, VB.Net, SQL Developer, DVO 9.6, Tkprof, PUTTY, AutoSys, Clear Case, Edit Plus, Ultra Compare.

Confidential, New York, NY

PL/SQL Developer

Responsibilities:

  • Preparing Pseudo code documents for complex business logic.
  • Writing Packages, Stored Procedures, Functions using SQL and PL/SQL in Oracle packages for entire business logic.
  • Writing Packages, Stored Procedures, Functions using SQL and PL/SQL in Oracle packages for entire business logic.
  • Used to write VB.Net classes to call PL/SQL Packages, procedures, Functions.
  • Implemented and deployed the data conversions for Payroll Back feed using HR Data pump engine, Pictures Migration, Documents Migration, Contracts Migration and Qualification Migration
  • Application development of OIM using the Oracle Application Express (HTML DB) technology
  • Implementation of BI Publisher reports in Oracle Application Express
  • Successfully implemented the new Business plan prototype and Tool kits as required by the User.
  • Successfully incorporated all the enhancement requests as requested by the user
  • Implemented data conversion for Assignment, Phones, Person EIT and Forms Personalization
  • Retrofitted the code components such as reports, customizations and interfaces to R12
  • Compilation and release of code.
  • Documentation of Technical, Test and Installation Documents.
  • Involved in design and development complex scripts include Triggers, Procedures, Functions, Synonyms, Packages to extract the big data from different sources and load data into Staging, Dimension and Fact tables, improve the performance of data migration.
  • Involved in tuning of SQL queries and Unix shell scripts
  • Automated the user reports
  • Developed and implemented complex data models and logical database designs.
  • Defined database requirements and designed data model.
  • Tuned complex stored procedures for faster execution and developed database structures per the requirements.
  • Bug fixes after the production deployment
  • Manual updates to avoid critical incidents
  • Pushing the orders manually in production where the logic created was not in the discussion scope.

Environment: Oracle Applications R12, Oracle 11g/10g, Toad, VB.Net, Forms and Reports builder, SQL*Plus, SQL Developer, UNIX Shell Scripting.

Confidential, New York, NY

PL/ SQL Developer

Responsibilities:

  • Design and develop PL/SQL packages, Procedures and Functions, Cursors, Ref Cursors and Triggers for the Web Services.
  • Handling application DBA activities.
  • Performed application Query tuning using utilities ADDM, AWR, explain Plan, SQL Tuning Advisor and suggested the best access path for the SQL queries.
  • Scheduled maintenance plans like daily & weekly backups, rebuild indexes, update stats
  • Developed complex scripts for automating batch processes which manage critical processes of the CRM system.
  • Used to create Classes using VB.Net to implement high-level business logic based on the Requirement document.
  • Migrating database and applications to new releases and implemented changes to the Data Model.
  • Worked Closely with Data Architect team to design and create scripts for objects such as tables, indexes, views, sequences, object types and collection types.
  • Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment using PL/SQL and SQL*Plus.
  • Designed Data Flow Diagrams (DFD’s) using Visio
  • Assisted with required data analysis, interpretation, correction and document presentation for various assignments
  • Used Ref Cursors, dynamic sql and bulk collect concept in the packages/APIs.
  • Developed complex scripts for automating batch processes which manage critical processes of the CRM system.

Environment: Oracle(11g), PL/SQL, TOAD, VB.Net, MS VISIO, Unix, HP Quality Center, PVCS, AWR.

Confidential, Monroeville, PA

PL/ SQL Developer

Responsibilities:

  • Developed RDBMS including PL/SQL database backend programming with stored procedures, Functions and packages.
  • Worked on data export and import wizard to transfer data between different schemas in oracle using TOAD.
  • Worked with various complex queries, sub queries and joins to check the validity of loaded and imported data.
  • Worked on data transformation and retrieval from mainframes to oracle, using SQL loader and control files.
  • Worked and developed many procedures and functions according the requirement, and developed brand new packages with cursors.
  • Involved in creating stored procedures, functions, triggers and developed monthly and weekly reports.
  • Good knowledge in database links, worked on tables, several types of views like inline and materialized views in different databases by linking the databases.
  • Worked with advanced PL/SQL concepts like collections, PL/SQL objects and records used them in building procedures and functions.
  • Developed, enhanced, maintained and supported the Web for Student, the Web for Faculty and Internet Native Banner Forms using Oracle, PL/SQL Web Toolkit, SQL, PL/SQL, Oracle Forms and a third-party product called SunGard SCT Banner.
  • Extensive knowledge in performance tuning the queries and development, built indexes as part of tuning and optimization.
  • Worked with Export and Text IO packages and wrote many Stored Procedures in many Forms and Reports. Worked with UNIX shell scripts and PERL scripts to generate daily reports.
  • Worked with dynamic SQL, developed many procedures and function with dynamic SQL.
  • Worked in resolving the production issues. Developed lot of new scripts and changed few existing scripts to solve the issues.

Environment: SQL Server, UNIX, MS Project, Oracle, Web Logic, SOX Compliance, Microsoft Office Suite 2010, Excel, Windows 2007 Enterprise, TOAD, ETL, SDLC, Waterfall, Agile methodologies.

Confidential, Horsham, PA

PL/SQL Developer

Responsibilities:

  • Developed and enhanced several components using Oracle PL/SQL for extracting data. Implemented solutions for outbound interfaces from oracle to external systems using oracle utilities like UTL FILE and transferred to external systems using file transfer protocol.
  • Developed modules running on Sun Solaris platform using Toad. Used PERL scripts for performing regular expression checks and for generating XML reports. Created Wrapper scripts using Unix korn shell utilizing common system functions run various jobs through crontab.
  • Created scripts for automation using UNIX shell scripting (AWK and SED). Experience performing operational support of Oracle applications.
  • Experience creating ETL jobs to load massive quantities of data and perform transformation operations to meet business requirements.
  • Designed, built, developed, and implemented Oracle Application solutions and custom software solutions for different modules using PL/SQL and ETL processes on Oracle 10g system.

Environment: SQL Server, UNIX, MS Project, Oracle 10g, Web Logic, SOX Compliance, JavaScript, HTML, Microsoft Office Suite 2010, Excel, Windows 2007 Enterprise, TOAD, HTML, XML, CSS, SDLC.

Hire Now