We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

Keene, NH

SUMMARY:

  • Having 8+ years of experience in programming as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
  • Implementation and technical expertise in Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
  • Exposure to Data - Modeling Techniques using Data-Modeling Tools.
  • Good Knowledge on Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
  • Experience working in AGILE environment.
  • Good exposure to all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
  • Proficient in Service-Oriented Architecture and its related technologies like BPEL, Web Services, WSDL, SOAP, XML, XSD, XSLT and Web Service Security including outing, transforming and validating of applications using Web services.
  • Extensive Experience in Customization of forms and reports and development of Conversions, Interfaces.
  • Strong knowledge in Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Query Re-Write and Transportable table spaces.
  • In depth knowledge and experience in features like Bulk Collect, Bulk Bind, Merge, Case and PL/SQL supplied packages.
  • Handled different kinds and elements of GUI buttons and Graphics.
  • Experience in Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
  • Extensive experience in SQL, PL/SQL, Developer 2000(Forms 6i/9i/10g, Reports6i/10g), PowerShell Scripts, SQL* Loader, XML Publisher and Oracle 8.x/9.x/10g.
  • Proven track record meeting with management and executives as the subject matter expert in SOA.
  • Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
  • Transferred and retrieved data to and from FTP Servers to Oracle Database.
  • Extensive experience in writing stored procedures, triggers and very strong in PL/SQL.
  • Having good Experience materialized views for data replication in distributed environments.
  • Expertise in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables and Dynamic SQL, Collections and Exception handling.
  • Extensive experience in Performance Tuning of SQL queries & Views using Explain Plan, SQL Trace and TKPROF utilities
  • Expertise in developing PL/SQL Stored Procedures, Packages, Functions, Triggers, Indexes, PowerShell scripting, Performance Tuning.
  • Implemented SQL*Loader to load data into tables and also used Dbms Utility package.
  • Experienced in Performance Tuning and analyzing using TKPROF, SQL Trace, and Explain Plan.
  • Performed unit testing, system testing and UAT testing.
  • Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
  • Immense knowledge in ITIL.
  • Strong familiarity with AIM standards and worked on MD50, MD70, CV60 and CV80.
  • Experienced in Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
  • On-site coordination experience and worked with offshore team during knowledge transfer and development support.

TECHNICAL SKILLS:

Databases: Oracle 9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers, JOINS), Oracle FORMS/Reports 6i/9i, MS SQL SERVER 2000/2005/2008, DB2/UDB, RDBMS, Teradata and MS Access.

Operating Systems: Windows, Linux, Embedded Linux, UNIX, HP-UX, Windows NT/98/95/2000/XP, Outlook, Sharepoint.

Data Modeling: Erwin 3.5.2/4.0

Web Technologies: JSP, XML, XSLT, XQuery, CSS, DHTML, JSF, JSTL, Struts and Ajax.

Languages/Utilities: SQL, PL/SQL, UNIX Shell Scripts, Web LOGIC, WEB Services, SOA, XML,Oracle Application Express (APEX)4.0, ad-hoc, Oracle Forms 6i/9i, Oracle Reports 6i/9i.

PROFESSIONAL EXPERIENCE:

Confidential, Keene, NH

Oracle PL/SQL Developer

Responsibilities:

  • Involved in SDLC gathering requirements from end users. Participated in system analysis and data modeling.
  • Participated in code walkthroughs and review sessions with the development team.
  • Co-ordinated with off-shore team by providing knowledge transfer, walkthrough development documents with off-shore team.
  • Developed stored procedures and triggers to facilitate consistent data entry into the database. Written Stored Procedures using functions and cursors for common utilities. Developed views to facilitate easy interface implementation and enforce security on critical customer information.
  • Worked extensively on the entire financial module of the company which involved various AR Invoice, AR Payment, AP Purchases, Billing and Job cost modules.
  • Developed applications using Visual Basic as front end and Oracle database as back end.
  • Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages. Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
  • Extensively Used the DBMS XMLGEN and DBMS XMLSTORE package to generate and insert XML files in Oracle 11g.
  • Monitored Indexes (XMLType: XMLIndex) and analyzed their status for performance tuning and query optimization.
  • Designed/developed tables, views, materialized view, stored procedures, packages and functions.
  • Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance. Developed Installation scripts for all the deliverables.
  • Automated scripts by scheduling control-M jobs, by using PowerShell scripts and windows scripting for improvement in performance of reporting.
  • Excellent working experience on Scrollbars, GUI Buttons and Graphics.
  • Involved in performance tuning on SQL using AUTO TRACE, EXPLAIN PLAN, TKPROF utilities.
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
  • Created Oracle forms components such as object groups, property classes and visual attributes
  • Created and manipulated stored procedures, functions, packages and triggers using TOAD. Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
  • Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
  • Created materialized views using different clauses like FAST, COMPLETE, FORCE, ON COMMIT.
  • Experience in working with IMPLICIT CURSORS, EXPLICIT CURSORS, and REF CURSORS.
  • Worked on oracle PL/SQL collections VARRAYS, NESTED TABLE, and ASSOCIATIVE ARRAYS with INDEX BY VARCHAR2.
  • Designed and created complex source to target mappings (STTM) using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Forms, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
  • Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
  • Ensure that the best practices and standards are followed in PL/SQL.
  • Supported unit testing, system testing and UAT testing.
  • Track the development of the project and review the code to maintain good quality.
  • User training and post-production support.
  • Encapsulated error handling and use of autonomous transaction for logging. Used UTL FILE for exporting data and UTL MAIL to generate E-mails.

Environment: Oracle 11g, PL/SQL, JOINS, C, SSIS, SSRS and Data Models, SOA, Web Services, SQL *Plus, RDBMS, Toad 9.7.2, Erwin 4.0, UNIX PowerScripts, SQL Loader, Oracle reports 10g, Teradata, AWR reports, ADDM reports, Oracle Forms 10g.

Confidential, Boston, MA

Sr. PL/SQL Developer

Responsibilities:

  • Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Designed/developed tables, views, materialized view, stored procedures, packages and functions
  • Automated routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically (UTL MAIL).
  • Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF to tune SQL queries.
  • Wrote complex PLSQL/SQL scripts to populate various tables and views used for reporting purposes. Written complex SQL using hints, indexes for fast performance for reporting and ad-hoc purposes.
  • Experience in debugging, design, development, testing and implementation of Visual Basic for Application environment.
  • Designed and developed Oracle forms & reports generating up to 60 reports.
  • Experience developing PL/SQL scripts to load invoice data from external system into AP interface tables.
  • Automated the processing of Banking functions like Creation of New Accounts, Deletion of Accounts, Daily transactions like deposit and withdrawal on money using various means like cash or check using Oracle Forms and Reports and generated various reports like the monthly account statement, daily transaction report etc.
  • Used Crystal Reports to track logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.
  • Involved in Registration/Migration of concurrent programs, executables (.fmx), Source form (.fmb), Creation of Responsibilities, request Groups, Menus, Library Files (.pll ) and executables (.plx), value sets, Request Sets, Forms and Functions in System Administration & AOL.
  • Imported Requisition Details (Requisition Import) using SQL* Loader and PL/SQL. Wrote programs to insert update and validate values into the PO requisition Interface tables for each requisition line.
  • Created lexical parameters, bind parameters, formula columns, summary columns and place holder columns in reports.
  • Extensively Used the XML SQL Oracle (Extract,ExistsNode, ExtractValue, XMLSequence, AppendChildXML) functions to generate, insert and manipulate XML files in Oracle 11g XML-DB.
  • Extensively used triggers like Report triggers, Layout triggers, Data triggers in reports.
  • Worked on Report Triggers (Before Parameter Form Report, After Parameter Form Report, Before Report Trigger, Between Pages Trigger, After Report Trigger).
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
  • Created Value sets for report parameters and registered in application
  • Writing several PL/SQL subprograms (stored procedures, functions and packages) using PL/SQL records, PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
  • Activities also involved migration of deliverables such as PL/SQL packages, LDTs, RDF, and RTF templates to various environments using UNIX shell scripts and FNDLOAD.
  • Developed Unix Shell scripts to automate repetitive database processes and maintained shell scripts.
  • Experience in customization of XML Publisher reports for Oracle Purchasing
  • Prepared test cases helped and QA team in running various test cases during Integration and System testing.
  • Designed and customized reports like New Customer Setup report and Contract Price List report using Discoverer 10g.
  • Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shellscripts to automate repetitive database processes.
  • Involved in troubleshooting issues, fixing bugs, and fulfilled the new business requirements.
  • Interacted with users to resolve any issues during development, production, and enhancement phases.

Environment:: Oracle 11g, Pl/SQL, JOINS, Oracle Forms 6i, Oracle Reports 6i, Data Models, AWR reports, ADDM reports, MS Excel, SQL*Navigator, Teradata, SQL *Plus, ad-hoc, TOAD, Power Builder, PowerShell scripting.

Confidential, Dallas, TX

Oracle PLSQL Technical Consultant/Developer

Responsibilities:

  • Extensively worked on Performance tuning by using Explain plans and various hints.
  • Wrote Shell Scripts for Data loading and DDL Scripts.
  • Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
  • Built SQL statement on the fly using pull-down menus and check boxes in a Visual Basic 6.0 as front-end to query an Access97 database.
  • Worked on table partitioning (Range and List) and deploying local indexing on portioned tables.
  • Involved in the design, data modeling and development and testing phases of various projects and enhancements.
  • Extensively worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries).
  • Wrote Stored Procedures, Functions, Packages in SQL*Plus.
  • Written many database triggers for automatically updating the tables.
  • Worked in creation of Sequences for automatic generation of voucher numbers.
  • Used UNIX Shell scripts (KORN) for Extracting and Parsing data from the files.
  • Used stored procedures in Oracle for retrieving the data from the database for solving complex queries.
  • Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application.
  • Created Stored Procedures, functions and Packages in Oracle 9i using SQL and PL/SQL for the Audit Trail using Oracle 9i as backend.
  • Performed the uploading and downloading flat files from UNIX server using FTP.
  • Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
  • Ensured that weekend data loads, end-of-month & end-of-quarter processing ran successfully and completely, transparent to user community.
  • Developed Custom Packages, Procedures for validating the Summary balances and Detail Transactions from the legacy system, imported them into interface table and submitted the Journal Import program to populate base tables.
  • Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
  • Used Shell scripting for host concurrent programsand migration scripts for deployment.
  • ModifiedPL/SQL procedures, functions, and packages for data population and manipulation as per user requirements.
  • Developed Data Conversions and Interface Programs. Used SQL * Loader to load data into Oracle Database.
  • Wrote PL/SQL packages for different validations, for processing data in order to create valid POs and Receipts to populate the PO interface tables and invoked seeded import programs to populate the base tables.
  • Proficient in generating Forms using Oracle Forms to satisfy business needs.
  • Modified Forms to accommodate new functionality such as adding buttons and texts.
  • Improved the performance of the application by rewriting the SQL queries.
  • Experience in Performance Tuning using Oracle Explain Plans.
  • Creating Test scripts for the generated final Reports.
  • Designed and developed Oracle forms & reports generating up to 60 reports.
  • Developed UNIX Shellscripts to automate repetitive database processes
  • Involved in data migration from SQL Server to Oracle 9i.
  • Good working knowledge of PL/SQL and UNIX in Production Support.
  • Post production support, Performance tuning and Query optimization for Reports and Interfaces using Explain plan.

Environment:: Oracle 10g, SQL, PL/SQL, SQL Loader, Visual Basic 6.0, Windows XP, TOAD 9.7.2, JOINS, Oracle Forms 10g, Oracle Reports 10g.

Confidential, Dallas, TX

Oracle Developer

Responsibilities:

  • Understand the data flow of the financial module in the old 2000 system, which is migrated to the new Oracle system.
  • Developed Various Oracle packages with procedures, functions, cursors, ref-cursors.
  • Used Data Pump and Cold backup to backup and recovery of the Database and exporting data between Databases.
  • Worked on creating External Tables, temporary tables in different schemas for data export and import.
  • Utilized Visual basic in code for massive updating of records.
  • Extensively worked with Sql*Loader for data import into the new Oracle 11g from the 2020 system.
  • Used Oracle Packages UTL SMTP, UTL MAIL and UTL FILE for writing out data to files and emailing the files as attachments to vendors.
  • Performance Tuning: Tables are partitioned and SQL queries are tuned using Explain Plan and TkProf.
  • Wrote complex PLSQL/SQL scripts to populate various tables and views used for reporting purposes. Written complex SQL using hints, indexes for fast performance for reporting and ad-hoc purposes.
  • Written Packages, functions and procedures for Oracle reports.
  • Worked on both web and paper source of the reports for various output formats like the Spreadsheet, text and PDF formats.
  • Involved in HTML and XML coding in the web source of the Oracle reports for Excel output.
  • Involved in Oracle Discoverer 10g for building workbooks, modifying existing workbooks.
  • Used most of the Discoverer features for the Management Analysis. Such as pivoting and drilling up and drilling down data.

Environment: Oracle 10g/11g, Toad 9.0.1, SQL: Developer, SQL Plus 10.2, Visual Basic 6.0, SQL*Loader 10.1.0, JOINS, ad-hoc, HP-Linux 4.5, Putty 0.60, WinSCP 4.1.9.

Confidential

PL/SQL Developer

Responsibilities:

  • Analyzed and understand the business flow of Verizon Business (VzB) and Verizon Telecom (VzT) according to the business requirement.
  • Responsible for the analysis, designing and coding of the database.
  • Used Toad for development and production environment that supports our Oracle 10g database.
  • Wrote PL/SQL store procedure and function based upon the business requirement.
  • Involved in a Unit testing framework activities of different modules.
  • Modified and optimized the existing VEC packages and user base data types for getting correct customer status in outbound tables.
  • Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
  • Debugged an errors in their existing database by using Toad 9.6.1
  • Used RCS(Revision Control System) for getting SQL files from their Unix box by using Putty 0.62

Environment: Oracle 10g, Toad 9.6.1, JOINS, Putty 0.62, RCS, Windows 7, SQL*Plus, Unixand HP QCclient with Win 7.

Confidential

Oracle PL/SQL developer

Responsibilities:

  • Analyzed the business requirements for the enhancements needed in the contract Administration application and related policy modules.
  • Documented the detailed requirements and prepared DLD for the new enhancements.
  • Performed several DDL, DML and TCL operations.
  • Created huge database packages with related functions and procedures.
  • Created views by joining multiple cash flow tables to show output as a report to the user.
  • Extensive PL/SQL programming including Development of new backend packages, procedures and functions to in corporate advanced modules.
  • Worked on BULK COLLECT for bulk loading the data into various transaction tables.
  • Used UTL FILE to load the data into oracle tables from FLAT, CSV and Text files.
  • Added database triggers to some history tables of the database.
  • Used file handling in Oracle to read and write into files associated with the modules.
  • Refresh the development and test databases using export/import utilities.
  • Provided 24*7 on call support to production environment.
  • Implemented various automated UNIX shell scripts to invoke pl/sql anonymous blocks, Stored PROEDURES/FUNCTIONS/PACKAGES using SQL PLUS session in silent mode.
  • Worked on inline and correlated sub queries based on business context.
  • Implemented various customized Oracle reports using different techniques in Oracle sql/pl-sql.
  • Extensive and in depth analysis of the problem tickets to dig out the root cause for the problems.
  • Involved in Impact analysis of the defects to the associated functionalities and modules in the Production environment.

Environment:: Oracle 10g, PL*SQL, SQL Developer, SQL*Loader, Export & Import Data, JOINS, UNIX, Toad.

Hire Now