We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

2.00/5 (Submit Your Rating)

Brentwood, TN

SUMMARY

  • 11 years of experience in the field of information technology, proven ability to leverage technology to improve business processes, with special expertise in requirements analysis, database development, debugging, problem solving and user support.
  • Proficient in Database/Infrastructure support, monitoring and performance tuning, data modeling, development of stored procedures, packages, triggers etc.
  • Self - motivated, resourceful and result oriented Team Player. Having good communication and interpersonal skills, a clear understanding of business rules and the ability to work well as a part of project team.
  • Proficient in writing SQL queries in Oracle proprietary standard.
  • Very strong in writing simple and complex SQL queries using DML, DDL, Group functions, grouping sets (Cube, Rollup), Grouping functions, Analytical functions, Connect by for hierarchical queries, Partition by clause towards Reports and Application development.
  • Experience in data extraction using complex SQL queries using various joins.
  • Experience in Generating Dynamic SQL and running them at run time.
  • Written complex SQLs using joins, sub queries and correlated sub queries.
  • Worked extensively on PARTITIONS to enhance performance and archiving of a DW.
  • Used MERGE statement to conditionally insert or update data depending on its presence
  • Extensively experience in designing and developing pl/sql subprograms.
  • Implemented packages to achieve modularity, easier application design, information hiding, and better performance.
  • Developed PL/SQL procedures for business rule validations, applying transformations, interfaces to UI screens, and for processing data.
  • Explored Bulk Loading and Batch Processing features of PL/SQL.
  • Extensive experience in utilizing Collections to boost performance in PL SQL block.
  • Proficient in using Cursors, Ref-Cursors, Table Functions, Functions, SQL Types and Sequences.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Sound knowledge and experience in developing Triggers on various database events.
  • Effectively made use of Bulk Collect, Multi Table inserts, Merge, PL/SQL tables & Nested tables.
  • Made use some of the oracle standard packages such as DBMS OUTPUT, DBMS ALERT, DBMS MVIEW, DBMS DDL, UTL FILE etc.
  • Designed and developed the Extraction, Transformation, and Loading (ETL) program to move data from source to target, mapping source data attributes to target data attributes.
  • Experience in Bulk Data loading using Oracle utilities namely SQL Loader, External Tables and Oracle utilities
  • Experience in application development like Bulk Collect, For all, Dynamic SQL, Autonomous Transactions, Global Temporary Tables.
  • Developed Test cases for Unit testing and user interface testing.
  • Performed unit and integration testing for the front end application.
  • Proficient in Query optimization using cost based optimization techniques using explain plan, Proficient in tuning PL/SQL programs using DBMS PROFILER and TKPROF, Auto trace & SQL Trace.
  • Proficient in creating and managing Indexes, optimizer Hints, Table Partitions, Initialization parameters and instance tuning.
  • Worked on performance tuning of many applications. The most successful project decreased run time of the SQL package for application with complex data extraction from multiple large tables from 30 minutes to 10 minutes.
  • Proficient in automating administration tasks and applying data patches using, SQLPLUS scripts and shell scripts.

TECHNICAL SKILLS

Databases: ORACLE 11g/10g9i, SQL Server 2005,DB2,AS/400 and Sybase

Programming languages: Oracle PL/SQL, JAVA and UNIX shell.

Web Technologies: Java Script, XML and HTML/HTML5.

Operating systems: Win Xp, Vista, Win 7, UNIX (Linux and UNIX) and Mac Os.

Development Tools: TOAD, SQL Developer, BMC SQL Developer, SQL*loader, SQL*plus, Putty Oracle Enterprise Manager (OEM), Eclipse, SQL Navigator, AutoSys, Erwin, Informatica Power Center and Talend.

Other Tools: ServiceNow, Jira, SalesForce,CVS, subversion, PVCS and VSS

PROFESSIONAL EXPERIENCE

Confidential, Brentwood, TN

Oracle PL/SQL Developer

Responsibilities:

  • Write the complex quires to find out and fix the various issues on behalf of the store systems issues like Store Balancing, Detail Errors, Terminal Error, Store/Xcenter/Backroom not closed.
  • Used DDL and DML to writing triggers, stored procedures to handle the bopis orders.
  • Old packages are enhanced/modified as and when new requirements come across.
  • Implementation of new packages as per requirements.
  • Created newProcedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
  • Prepare the unit test cases for all new development objects.
  • I am the responsible for Extract, Transform and Load the data from various inventory sources into Oracle data warehouse for Remedy Change Management requirements.
  • Performed ad set, daily price changes, cleanliness of store, and open box inventory.
  • Managed and organized incoming inventory to quickly locate merchandise in warehouse and store front
  • Effectively managed items of approximately 60,000 skus to prevent stock outages while decreasing obsolete inventory to a value of under $1M.
  • Create the new Functional and Technical design documents.
  • Worked with Remedy or other ticketing software’s (ServiceNow, Salesforce and Jira).
  • Reviewing requirements in the JIRA and Confluence for production issues and provides time estimates for task completion.
  • Escalates the issues/Requests through Gateway/ServiceNow software tools.

Environment: Oracle 11g, SQL, PL/SQL, SQL*plus, SQL*Loader, Java/J2EE, SAP, Informatica, PVCS Tracker, PVCS Version Manager, JIRA, TOAD, PL/SQL Developer tool, BMC tool and Talend Job.

Confidential, Miami, FL

Lead Oracle PL/SQL Developer

Responsibilities:

  • Interacting with the system analysts, business users for design & requirement clarifications.
  • Participated in the daily SCRUM meetings to produce quality deliverables within time. created the triggers for advanced queuing process
  • Developed the batch jobs for 6months/12 months/anniversary and ad-hoc reward points.
  • Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
  • Created Indexes for faster retrieval of the customer information and enhance the database performance.
  • Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
  • Worked with Bulk Collects to improve the performance of multi-row queries.
  • Used Exception Handling extensively for the ease of debugging and displaying the error messages.
  • Used Quality center for defect creation and tracking purpose
  • Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects Ref Cursors to improve performance.
  • Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.

Environment: Oracle 11g, SQL, PL/SQL, HP QC, Java/J2EE, SAP, Informatica, PVCS Tracker, PVCS Version Manager, JIRA, TOAD, PL/SQL Developer tool, BMC tool and Talend Job.

Confidential, Winston Salem, NC

Lead Oracle PL/SQL Developer/Systems Quality Assurance Analyst

Responsibilities:

  • Oracle PL/SQL Developer/Systems Quality Assurance Analyst responsible of the Quality Assurance and Test Planning Strategy for an enterprise level Operational Data Store for a Fortune 100 financial services company.
  • Writing simple and complex SQL queries using DML, DDL, Table joins and Group functions based on the ILMD (Integrated Layer Mapping Document/Mapping Document).
  • Made use of advanced features such as Analytical Functions
  • Using Common Table Expression (With clause) while writing the queries.
  • Lead Offshore / Onshore test teams..
  • Responsible for setup and implementation of RAC on Linux in 10g and 11g R2.
  • Created and maintained Test Cases in HP Quality Centre (HPQC) according to the Business Requirements.
  • Wrote and executed test cases in HP Quality Center for System Testing and User Accepting Testing (UAT).
  • Adept at Bug Tracking and Defect Reporting using HP Quality Center.
  • Design and Develop scripts for uploading data from flat files and XML files into database, performing business validations on the data using PL/SQL Procedures.
  • Involved in various Requirement, Design phase development and Configuration meetings along with business and development teams.
  • Executed manual and automated regression test cases after the bug fixes as per test scenarios.

Environment: HP QC, ORACLE, Oracle 11g, SQL, PL/SQL, Informatica, TOAD, PL/SQL Developer tool.

Confidential, Camp Hill, PA

Oracle PL/SQL Developer

Responsibilities:

  • Writing stored procedures under tight schedules for successful production data-fixing.
  • Analyzing the AWR reports with DBA's and SQL tuning to maximize performance Tune.
  • Reviewing requirements in the JIRA for production issues and provides time estimates for task completion.
  • Converted Oracle reports into Extensible Markup Language(XML) output for use in Microsoft Excel
  • Created database reports to get open enrollment and enrolled list reports weekly, monthly and yearly
  • Fine-tuned SQL queries using functional indexes, hints for maximum efficiency and performance.
  • Supporting all aspects of production, QA, and development Databases (versions 9i and 10g) on Solaris andLinux
  • PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
  • Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.

Environment: Oracle 11g, SQL, PL/SQL, SQL*plus, SQL*Loader, Shell Scripting, Informatica, PVCS Tracker, PVCS Version Manager, JIRA, TOAD, PL/SQL Developer tool and BMC tool.

Confidential, Nashville, TN

Oracle PL/SQL Developer

Responsibilities:

  • Verify in the db and fixing UI issues by running each students' individual or organization score reports and providing to Customer.
  • Import Customers, User, Organizations, Schools and Student data into the data base using SQL*Loader, Plsql dev tool and Little Informatica.
  • Write the complex quires to find out and fix the various issues on behalf of the production support.
  • Used DDL and DML to writing triggers, stored procedures to check the test sessions entry and student result verification
  • Old packages are enhanced/modified as and when new requirements come across.
  • Implementation of new packages as per requirements.
  • Created newProcedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
  • Ad-hoc scripts update daily with a report.
  • Analyze information to determine, recommend and plan installation of a new system or modification of an existing system.

Environment: Oracle 10g, SQL, PL/SQL, SQL*Loader, Informatica power center, SQL Developer, SQL Navigator, TOAD, UNIX/LINUX, Windows.

Confidential, Malvran, PA

Oracle PL/SQL Developer

Responsibilities:

  • Creating Oracle objects like tables, types, context, packages, procedures and functions to Add, Maintain, Updates and Deactivates Firms, Desk, Users that can View, Modify and Trade.
  • Automated sql loader using shell scripting.
  • Reviewed the UI validations and added required validations to the packages to ensure the ideal data population into the tables.
  • Involved in development, enhancement and maintenance of PL/SQL interfaces such as defining packages, developing procedures and functions.
  • Develop the Shell scripts to automate the finance billing file
  • Defined Views and Materialized views for simplifying reporting queries and performance
  • Performed Query optimization and PL/SQL tuning to maximize performance
  • Developed PL /SQL code for updating payment terms
  • Developed TOAD, SQL*loader scripts to load data in the custom tables.

Environment: SQL, PL/SQL, SQL*plus, SQL*Loader, Oracle 11g, java, Shell Scripting, Informatica. Toad, BMC sql developer tool, Sales force for issues.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Developing packages, procedures, functions, and triggers for the application.
  • Using UNIX environment for performing the testing
  • Performing the tests on the newly coded procedures and documenting the same.
  • Writing technical documents using the functional specifications
  • Writing PL/SQL code using the technical and functional specifications
  • Creating Oracle objects like tables, types, context, packages, procedures and functions.
  • Automated sql loader using shell scripting
  • Involved in Development of the Server side applications.
  • Understanding the requirements using functional documents and client specified documents
  • Optimized the queries to improve the performance of the application

Environment: ORACLE 8i, PL/SQL, Developer 2000, Java, Servlets, JSP, Struts, JDBC, UNIX, SQL*loader, Unix Shell scripts, Oracle 9i, Unix, Windows, PVCS Tracker, PVCS Version Manager.

We'd love your feedback!