We provide IT Staff Augmentation Services!

Sr.pl/sql Resume

Brea, CA

SUMMARY:

  • Over 8 years of IT experience in System Analysis, Design, Testing, and Development of business applications using Oracle 11g/10g/9i/8i/8/7.i.
  • Experience in logical data modeling, designed ER diagram, created schemas and relations accordingly.
  • Hands on experience of handling large objects (LOB) in Applications.
  • Good programming knowledge in Oracle 11g/10g/9i/8i/8.x/7.x, Developer 2000 (Oracle Forms, Oracle Reports), Discoverer, PL/SQL, SQL*Plus, TOAD, SQL*Loader.
  • Worked with embedded SQL (Pro C).
  • Experience in development of Procedures, Functions, Packages and Database Triggers, Query Tuning using query optimizer.
  • Experience in creating Database Objects and User defined Data types (Abstract Data types), materialized view.
  • Heavily used Crystal reports tool for creating complex reports and supported crystal reports in the BO environment.
  • Experience using SQL/PLSQL for analyzing reports, testing and improving the performance of the reports.
  • Implemented security features for authentication at different levels using the Authentication and authorization schemes in Confidential .
  • Expertise in developing Confidential applications and migrating the forms from 6i version to Confidential and also maintaining them.
  • Experience in developing the new forms and reports using Oracle Confidential for the new business logic.
  • Administration experience using Crystal Reports Server, maintaining, report bursting, managing groups/ users within the Central Management Console (CMS) .
  • Selected by management to train select Customers and Staff in the art of Crystal report writing.
  • Proficient in developing Forms and Reports using Oracle Forms6i/5.0/9i/10g, Reports6i/4.5/9i/10g and developing programs using SQL, PL/SQL.
  • Extensive knowledge of Crystal put to use, making suggestions on what type of reports could best fulfill user's needs.
  • Experience in migration of oracle forms 9i to oracle forms 10g.
  • Experience in using TOAD, SQL*Loader for Export / Import of data.
  • Hands on experience with mod pl/sql, Hypertext Procedures, Hypertext Functions and UTL FILE.
  • Experience in design and development of end user Forms and Reports.
  • Hands on experience in writing Korn Shell Scripting, Perl scripting and job processing in UNIX.
  • Experience in working for Oracle Portal for different releases.
  • Competency in formulation of test conditions/cases/scripts of system specification analysis.
  • Knowledge of Performance Unit Testing and Quality Center Tool.
  • Good Understanding of Java, ASP, JSP, HTML5.
  • Experience in Documentation that involves functional specification, user Manual and technical review.
  • Hands on experience in migrating of T - SQL to SQL.
  • Extensively used MS Word, Excel, and Visio to produce and represent documentation.
  • Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.

TECHNICAL SKILLS:

Web Technologies: HTML, DHTML, Java Script, AJAX, CSS, XML,Oracle Confidential .

Packages: Oracle Forms and Reports (4.5, 6i, 9i, 10g).

Languages: C, C++, SQL, PL/ SQL.

Scripting Languages: UNIX Shell Scripting, PERL

Database Tools: SQL*PLUS, TOAD, SQL*Tool, PL/SQL Developer, SQL Navigator.

Office Packages: MS-Office (Access, Word, Excel, PowerPoint)

Version Control: CVS, PVCS

Databases: Oracle 12c/11g/10g/9i and MYSQL

PROFESSIONAL EXPERIENCE:

Confidential, Brea, CA

Sr.PL/SQL

Responsibilities

  • Worked as a primary point of contact for all Database design and development activities.
  • Involved in implementing business logic with Oracle-stored procedures, functions and triggers using PL/SQL.
  • Involved in walk-through sessions with business users during the Analysis, Design, and development phase, written PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.
  • Created and maintained tables, procedures, functions, and packages, and update, delete, and insert statements and compile them.
  • Responsible for building applications using Confidential (Reports/Forms) to replace the existing legacy system.
  • Implemented custom HTML java scripting and Jquery when building page reports, buttons and templates in Confidential .
  • Making changes to the existing Confidential applications in the production.
  • Contributed with database designs and assisted in increasing response time for Confidential reports.
  • Coordinate, Drive the Confidential SIT testing execution & provide updates to business during stand up & defect calls.
  • Created Cross Tab, Drill Down, Sub Reports and standard reports using Crystal tool.
  • Modified existing Stored Procedure and Crystal reports for the Fore Closure reports.
  • Scheduled Crystal reports and SSIS packages.
  • Designed and Developed Crystal Reports such as List reports, Parameterized, Mail Label, Cross tab Reports using the base tables, Views, Commands, involving Formulas, Subtotals, Running totals and Sub reports.
  • Involved in the Golden Gate setup for bi-directional data replication.
  • Involved in performance tuning (PL/SQL) using SQL Trace, Explain Plan, TkProf, Indexing and Hints.
  • Worked with architects, Business Analysts, ETL developers, and QA testers to translate data requirements into the physical schema definitions for Oracle.
  • Written Custom SQL scripts, Stored Procedures, Functions, Triggers, Views, Cursors, Packages and Exceptions.
  • Code review to ensure that the existing code is complaint with the coding standards.
  • Deployment of the code from IBM Rational Clear case to other environments using IBM Rational Build Forge
  • Bug Fixing and Defect resolution from the code logic using Oracle SQL Developer IDE.
  • Involved in Importing and exporting the Tables, Users, and Schemas.
  • Responsible for Unit Testing and Integration testing of PL/SQL Packages, Procedures, Functions and Triggers.
  • Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
  • Documented the whole process flow, PL/SQL packages, log files, locations and descriptions, log tables and possible error messages, process codes and descriptions.
  • Expertise in DBA concepts like creating tables, table space, Grants to users.
  • Used Clear case tool to manage various versions of the procedures and functions of the application.
  • Provided Production Support, problem resolutions and bug fixing, actively involved in resolving the issues and coordinating with business users and resolving the issues.

Environment: Oracle 11g, Oracle Confidential 5.0, SQL, PL/SQL, SQL Developer, PL/SQL Developer, Toad, Unix, Windows 2007, MS- Excel 2013, IBM Rational Clear case tool, T-SQL, IBM Rational Build Forge, Notepad++,Crystal Reports.

Confidential, Los Angeles, CA

Oracle PL/SQL Developer

Responsibilities:

  • Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • 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.
  • Implemented Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
  • Involved in the continuous enhancements and fixing of production problems.
  • Involved in Change Management Board (CMB) meetings to get the approval for changes made.
  • Implemented industry best practices in coding, naming convention, testing and deployment process.
  • Worked with DBAs to identify and resolve performance issues.
  • Implemented security features for authentication at different levels using the Authentication and authorization schemes in Confidential .
  • Added Oracle Confidential validations and computations as per business rules and requirement. Designed the look and feel of the Confidential forms (User Interface) along with the users.
  • Making changes to the existing Confidential applications in the production.
  • Developed forms in Confidential for internal groups, customer service and Warehouse teams for data entry and also enabled search options from the onscreen functionality.
  • Customized Oracle Confidential themes and templates as per the Graphics team on redesigning the GUI interface
  • Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.
  • Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
  • Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
  • Created indexes on the tables for faster retrieval of the data to enhance database performance
  • Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
  • 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 and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
  • Partitioned the fact tables and materialized views to enhance the performance.
  • Extensively used bulk collection in PL/SQL objects for improving the performing.
  • Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
  • Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
  • Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
  • Implemented Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Implemented advanced SQL functions CUBE, ROLLUP, Grouping BY, Over (), RANK, Dense rank, row number, lead, lag, PIVOT, UNPIVOT for data analysis.

Environment: Oracle 10g,SQL*Plus,PL/SQL,Oracle Confidential 4.2/4.0, T-SQL, Oracle Designer 2000,Toad.

Confidential, Vernon hills, IL

Oracle Developer/Analyst

Responsibilities:

  • Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
  • Designed logical and physical data models for star and snowflake schemas using Erwin
  • Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
  • Oracle Confidential validations (both front-end JavaScript based and PL/SQL and Declarative on back-end) and computations as per business rules and requirement.
  • Created page level and item level validations in Confidential form using JavaScript.
  • Developed and implemented authorization and authentication rules for Application Administrators in order to manage the Oracle Confidential applications, users, and their log activity details.
  • Developed User Form based screens using Oracle Confidential to gather data which require data processing at the back end.
  • Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
  • Upgraded data bases from Oracle 9i to 10g in different environments, implemented new features by retaining the existing business rules.
  • 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.
  • Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
  • Worked on XML along with PL/SQL to develop and modify web forms.
  • Designed Data Modeling, Design Specifications and to analyze Dependencies.
  • Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
  • Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
  • Used Discoverer 2000 to provide end users easy access to data and help in data analysis.
  • Created custom reports and forms for the end users to check the details and errors.

Environment: Oracle 10g, SQL*Plus, PL/SQL, Erwin, Oracle Designer 2000, T-SQL, Windows 2000, Toad, XML.

Confidential, Westbury, NY

PL/SQL Developer

Responsibilities:

  • Involved in complete SDLC (system development life cycle) including system analysis, high level design, detailed design, coding and testing.
  • Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL Loader, SQL* Plus and PL/SQL.
  • Created Custom Triggers, Stored Procedures and Packages.
  • Created PL/SQL Triggers to monitor the database activities and to implement some database constraints.
  • Used SQL *Loader for migrating flat file into the target system.
  • Created numerous web based Forms and Reports using Oracle Developer 6i.
  • Modified existing codes and developed oracle Reports, PL/SQL packages to perform Certain Specialized functions / enhancements on oracle Application.
  • Responsible for Tuning SQL Queries.
  • Involved in problem analysis and resolution, troubleshooting, performance tuning.
  • Using SQL trace facility and TKPROF accurately assessed the efficiency of the SQL statements when application runs. For best results, used these tools with EXPLAIN PLAN.
  • Used joins, indexes, effective where clauses for Query optimization.
  • Used Export and Import to transport data from production to testing and to other databases.
  • Participated in development, testing and migration of oracle objects from development to testing and production environments.

Environment: Oracle 9i/8i, Designer / 2000, Developer/2000 (Forms 6i, Reports 6i), PL/SQL, SQL*Loader, UNIX, WinNT 4.0, TKPROF SQL TRACE, T-SQL, EXPLAIN PLAN.

Confidential, San Marcos, CA

PL/SQL Developer

Responsibilities:

  • Created database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus, PL/SQL.
  • Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
  • Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
  • Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client. Involved in validating the data while data migration by creating PL/SQL Packages, Procedures, Functions, Triggers.
  • Created Indexes for faster retrieval of the customer information and enhance the database performance.
  • Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
  • Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
  • Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 10g, 11g PL/SQL, Windows XP, T-SQL, SQL *PLUS.

Confidential, Indianapolis

PL/SQL Developer

Responsibilities:

  • Involved in complete SDLC (system development life cycle) including system analysis, high level design, detailed design, coding and testing.
  • Ensure conformance to code standards and documentation requirements.
  • Creation of database objects like Tables, Indexes, Views, Stored Procedures, Functions, Packages, Triggers, and Synonyms.
  • Used Dynamic SQL programming technique to build and process SQL statements.
  • Used TOAD, PL/SQL developer tools for faster application development.
  • Performed exception handling.
  • Developed the Shell scripts and Perl scripts for maintain scripts for monitoring, troubleshooting and administration of the databases as well as automation of the processes.
  • Apart from developing, other day to day responsibilities involved supporting production with issues related to day to day data fixes and debugging aborted processes.
  • Documenting procedures and scripting, and eventually be drafting up them into Unit test plans.
  • Used Hyperion SQR to load files into database and creating various feeds as per the requirements.

Environment: Oracle 9i, PL/SQL, SQL *PLUS, TOAD, C, SQL *Loader, T-SQL, Forms 6i, Reports.

Confidential, Houston, TX

PL/SQL Developer

Responsibilities:

  • Developed application and database triggers, functions, procedures, and packages in PL/SQL, Oracle8i as back-end.
  • Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL Loader, SQL* Plus and PL/SQL.
  • Created various SQL and PL/SQL scripts for verification of the required functionalities.
  • Created various Database triggers using PL/SQL.
  • Generated a number of reports for management to review for system functionality as against the old legacy system.
  • Worked with various functional experts to implement their functional knowledge into working Procedures
  • Worked on optimizing existing procedures and functions using PL/SQL.
  • Created various Database triggers using PL/SQL.
  • Involved in the preparation of user Requirements and functional specification of the systems.
  • Used the graphical features (image items, icon, charts etc.) by using the built in packages
  • Developed Stored Procedures, functions, triggers and packages using PL/SQL for incorporating the validations in Oracle database.
  • Responsible for developing PL/SQL Functions, Procedures, Packages, Cursors and Triggers.
  • Developed Unix Shell Scripts and PLSQL procedures to extract and load data

Environment: Oracle7i/8i, Developer 2000 (Forms 4.5, Reports 3.0), Designer 2000, T-SQL, Visual Basic 6.0, SQL * Loader, UNIX, Shell Scripting, Oracle Reports, ETL.

Hire Now