We provide IT Staff Augmentation Services!

Pl/sql Developer Resume

Oklahoma, CitY

SUMMARY:

  • 8+ years of experience in gathering Business Requirements, analysis, design, development, Upgrading, testing, report generation and production support projects in Data ware housing, SQL and PL/SQL
  • Experience in providing technical Support (Analysis, Design, Development, and Testing) and team leadership (planning, collaboration) in the projects involved.
  • Experience in developing projects for Financial, Insurance and Manufacturing Organizations.
  • Hands on experience in developing conversions, interfaces both inbound and outbound using PL/SQL coding
  • Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, Database links, User Defined Data Types, Nested Tables and Collections.
  • Experienced in oracle PL/SQL advanced concepts such as Cursors, Ref cursors, Dynamic SQL, BULK Processing, Exception Handling and Collections such as Varrays, Nested tables and associative arrays.
  • Have good experience in using DBLinks, data loading/unloading (SQL*Loader), import, Export and UTL FILE utilities.
  • Extensive experience in scheduling Oracle PL/SQL Batch jobs using control M, Autosys and DBMS JOBS Scheduler.
  • Hands on experience in Confidential schema, snow flex schema, cubes etc
  • Expertise in creating and optimizing indexes for real time applications.
  • Hands on experience with SSIS and SSRS
  • Hands on experience with oracle ODI
  • Interacted with the business users, collected the requirements, analyze the requirements, design and recommend solutions.
  • Prepared BRS (Business Requirement Specifications) document that gives the detailed information about the requirements.
  • Highly worked on Virtual private databases (VPD)
  • Proficient in developing the Data mart in Confidential Schema and Snowflake Schema, Flat files and building the Data warehouse, Efficient in developing the Logical & Physical Data model, OLTP/OLAP, ER Diagrams and organizing the data as per the Business requirements
  • Knowledge of working in Oracle RAC databases like retrieving data and working on single node
  • Experience in Advanced PL/SQL Concepts such REF cursors, Collections. Extensively used PL/SQL tables and Oracle Bulk Collect to improve the performance.
  • Highly expertise in Advance PL/SQL and SQL coding
  • Implemented features including materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
  • Experience in writing Unix shell scripts.
  • Exception Handling in PL/SQL
  • Experience in Data Migration, data loading from flat files to database tables using SQL*Loader.
  • Worked extensively using TOAD, SQL*Plus, PL/SQL Developer and UNIX utilities.
  • Extensive knowledge on data archiving and purging techniques, applimation tools etc
  • Strong Experience in AP, AR, GL, FA, SCM, OM, HRMS, PA, INV, WIP, Project costing, Project billing modules of Oracle Applications.
  • Hands on experience in O2C and P2P modules of oracle apps.
  • Work with the client-side Functional Consultant on requirement understanding and prepare detail Technical design Documents
  • Analyze and understand the client business processes and functional design document and implement them technically using SQL and PL/SQL in Oracle Financials and SCM modules.
  • Prepare documents like MD70, MD65, MD120, CV40, CV60, CR Document,
  • Knowledge of monitoring and running job in Informatica tool and scheduling jobs in Control-M which call the underlying Informatica jobs or Unix scripts which in turn call Java components.
  • Experience in using PVCS, SVN, TFS, CVS and Oracle Repository for version control.

SKILL:

Tools: SQL*Plus, SQL Developer 1.2, Toad 10.6/9.6, Oracle forms 10g/9i/6i and Reports 10g/9i/6i, Crystal reports 8.5/9/10,SAP BO Reporting, SQL Server Reporting Services (SSRS), Discoverer 9i/4i, Xml/Bi Publisher.

Databases: Oracle 11g/10g/9i/8i, SQL Server 2005,MY SQL, Ms-Access.

Languages: SQL, PL/SQL, C, C++, Java, VBA, HTML, UNIX Scripting.

Web Technologies: HTML, XML, Java Script, AJAX.

ETL Tools: Informatica Power Center

Operating System: Windows 7/Vista/XP/03/2000/NT, UNIX( sun Solaris), LINUX

Other Tools: Data Modelling (Erwin 4.0), Confidential Quality Center, autosys

Oracle Utilities: SQL*LOADER, UTL FILE, Export/Import functionality, Data Pump, FND LOAD

Version Control Software: GIT, Clear case, VSS and PVCS

Applications: MS Office(MS Word, Excel, Access, Power point) and MS Visio

Methodologies: Waterfall Model, AGILE Methodology

PROFESSIONAL EXPERIENCE:

Confidential, Oklahoma City

PL/SQL Developer

Responsibilities:

  • Responsible for exporting data from client’s database and importing in the development environment for the use of developers.
  • Used SQL loader to load the data from the files provided by the interfacing applications.
  • Import and export of tables to load data between different databases.
  • Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
  • Tuned SQL queries which were taking long time to execute.
  • Created partitioned tables and partitioned indexes to improve the performance of the a pplications.
  • Wrote PL/SQL Database triggers to implement the business rules in the application.
  • Created external tables to handle huge volumes of data which is not used frequently.
  • Created INDEXES, VIEWS, CHECK CONSTRAINTS and TRIGGERS for performance improvement.
  • Worked on ODI for data integrations
  • Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
  • Worked on VPD’s to retrieve data from different databases and checking the Duplicates after the data load
  • Loaded and unloaded data sets from or to Oracle Databases using several kinds of tools such as SQL*Loader, Oracle Import/Export Facility.
  • Developed various backend programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL language for the top management for decision making.
  • Using Oracle RAC for maintaining applications
  • Working on SSIS and SSRS
  • Implemented all modules logic by using Triggers and Integrity Constraints.
  • Involved in PL/SQL code review and modification for the development of new requirements.
  • Created materialized views required for the application.
  • Performing Performance Tuning on the SQL Queries using TKPROF utility.
  • Developing the Scripts by Using UNIX Shell Scripting and reviewing Unit Test Plan & Results.
  • Building Data warehouse by summarizing the Data on Yearly Granularity and Populating the Data in Confidential Schema and Snowflake Schema.
  • Maintaining and organizing the Data warehouse Building in Hierarchical level as per the Business R ules of data management.
  • Developed OBIEE drill down reports
  • Worked on inbound and outbound interfaces
  • Involved in Oracle P2P and O2C RICE (Reports, Interfaces, Conversions) technical development

Confidential, Houston, TX

PL/SQL Developer

Responsibilities:

  • Involved in requirement gathering, effort estimation, preparing installation and migration document and also migrating the components.
  • Worked on sev 1 and sev2 issues and COE action items.
  • Developed Interfaces of AP module using Advance PL/SQL. The source system wherein was S3 and different systems
  • Worked for many Amazon web services components.
  • Worked on Oracle RAC for maintaining different applications and also custom applications for retail stores
  • Worked on interfaces like Credit to Invoice, customer creation new logic added, contra cogs interfaces, AR adjustments, component to send emails to customers for each invoice, consolidated linked invoice, landing zone etc using Advance PL/SQL
  • Created DDL scripts for tables, views, constraints and indexes.
  • Developed PL/SQL Procedures, functions, packages and triggers.
  • Used PL/SQL features like PL/SQL tables, Pragmas for error handling, implicit, explicit and Ref cursors for data processing.
  • Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Implemented features including materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
  • Optimized query performance with modification in PL/SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, using Hints, creating useful indexes and Views.
  • Involved in writing SQL*Loader scripts to migrate the data from the text files, Spreadsheet etc. and populated the Staging tables.
  • Executing the scripts and inserting data into the tables.
  • Worked on VPD’s to compare the data from source to target databases after data import is completed.
  • Maintained the data integrity and security using integrity constraints and database triggers.
  • Optimized and enhanced the existing procedures and SQL statements for the better performance.
  • Developing SHELL SCRIPTS to automate the processes.
  • Worked on the production issues and database maintenance.
  • Writing Mappings for Transformation logic.
  • Ensure all Technical Designs and build components are delivered with good quality by meeting object deadlines.
  • Worked with project team and Offshore to resolve defects identified during testing.
  • Adding constraints, tables according to the changes in the design documents.
  • Documentation of Tables and Views.
  • Involved in the complete life cycle of the product from requirements gathering to end of system testing.
  • Have done performance tuning for the complex queries in TOAD.
  • Delivered the objects and respective documents by following Oracle’s AIM methodologies.
  • Worked on Unix scripts for creating tar files and also to download and upload LDT’s
  • Worked on FTP scripts to call concurrent programs internally and also transfer outbound files from desktop directory to noetix server and from noetix to BOA server.
  • Worked on positive pay outbound interface.
  • Involved in P2P related issues and developed components like Suppliers conversion etc.
  • Created payment process profiles for positive pay Outbound interface.
  • Check out the SVN and creating the config files.
  • Involved in migration meetings and project kick-off meetings
  • Involved in migration of components from one instance to another instance.
  • Worked on Stream serve for few reports to get the predefined settings.
  • Developed new profiles used for FTP scripting.
  • Mentored development team with architecture, design, coding guidelines, and testing standards.
  • Unit testing of the component developed.

Confidential

Associate Test Engineer

Responsibilities:

  • Involved in requirement gathering, effort estimation, preparing technical design document, Development, unit testing, preparing the migration document and migrating the components.
  • Involved in performance tuning of Oracle tables & stored procedures .
  • Involved in preparation of MD70s (Technical design documents).
  • Client interaction on a daily basis and user interaction on need basis.
  • Data Conversions - Data mapping between files sent by client on to impact equivalent files.
  • Developed a PL/SQL code to convert the data from legacy systems to Oracle databases .
  • Involved in the PL/SQL code review and modification for the development of new requirements.
  • Developed custom stored procedures and packages to support new enhancement needs.
  • Used PL/SQL features like PL/SQL tables, Pragmas for error handling , implicit, explicit cursors for data processing.
  • Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Optimized query performance with modification in PL/SQL queries , removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, using Hints, creating useful indexes and Views.
  • Worked on Oracle RAC and Virtual private databases .
  • Executing the scripts and inserting data into the tables.
  • Wrote shell scripts that assisted in the migration of data and creation of custom views which served as primary tools for analysis.
  • Involved in writing SQL*Loader scripts to migrate the data from the text files, Spreadsheet etc. and populated the Staging tables.
  • Adding constraints, tables according to the changes in the design documents.
  • Documentation of Tables and Views.
  • Involved in the complete life cycle of the product from requirements gathering to end of system testing.
  • Have done performance tuning for the complex queries in TOAD .
  • Worked with project team & Offshore to resolve defects identified during testing.
  • Involved in O2C(Order to cash) and P2P(Procure to Pay) full life cycle modules
  • Developed components for PA, AP,AP,GL modules and headers details
  • Developed Oracle PL/SQL Alerts, Workflows
  • Unit testing of the component developed
  • Used various kind of SQL queries involving Correlated Sub queries, union, Inner and Outer Joins
  • Migrations of the components from once instance to another instance
  • Scheduling the reports from back end using PL/SQL
  • Enabling profile options and diagnostics.
  • Fully supported Application Management team in addressing post Go-Live issues for the releases.
  • Project is developed in agile methodology. New requirements are implemented based on the regular meeting with all groups.
  • Mentored development team with architecture, design, coding guidelines, and testing standards .

Confidential

Associate Test Engineer

Responsibilities:

  • R eviewing Specification documents and participation in RA (Requirement Analysis) sessions for clarifications.
  • Writing manual Test Cases and executed the same for each iteration.
  • Performing Test Case Review to ensure test coverage of a Product.
  • Performed smoke test and regression tests on release builds as per technical and functional specification.
  • Performed Integration and usability testing of the application after the functionality is frozen.
  • Logged bugs using Bug Host - Defect tracking tool, Understanding the functional requirement specifications.
  • Participated in Writing the Test Cases to validate the Functionality based on Use Case documents.
  • Preparation of Test Data for Various Modules and Involved in self and Peer reviewing of Test Cases.
  • Reviewing the Test cases, Identification and Design of Scenarios/Test Cases.
  • Writing and Executing Test Scenarios/Test cases and Involved in Smoke and Sanity Testing before every build release. Defects were tracked, reviewed, analyzed and compared using Confidential Quality Center (QC). Escalated defects to programmers/developers to resolve the issue to provide bug free product to the client.
  • Performed Integration Testing as development team releases the product.
  • Performed Acceptance Testing to evaluate the system compliance with the business requirements and ready for deliver to the client.
  • Interacted with developers regarding priority of bugs and update the status of bugs once they are fixed. Responsible for preparing Traceability Matrix report.
  • Involved in developing SQL queries and stored procedures to check data integrity. Conducted Data Validation Testing (back-end) using PL/ SQL queries.
  • Defects were tracked, reviewed, analyzed and compared using Confidential Quality Center (QC). Escalated defects to programmers/developers to resolve the issue to provide bug free product to the client.
  • Performed Integration Testing as development team releases the product.
  • Performed Acceptance Testing to evaluate the system compliance with the business requirements and ready for deliver to the client.
  • Interacted with developers regarding priority of bugs and update the status of bugs once they are fixed. Responsible for preparing Traceability Matrix report.
  • Involved in developing PL/ SQL queries and stored procedures to check data integrity. Conducted Data Validation Testing (back-end) using PL/ SQL queries.
  • Integration Testing, Defect Reporting and Participated in documenting the Bug Reports.
  • V-Model is used for Software Testing Life Cycle

Hire Now