We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

MO

Summary:

  • Over 7 years’ experience as Oracle PL/SQL Developer in complete software development life cycle with active participation in database design, development, testing and reporting.
  • Involved in system study, design, development, and implementation stages of various projects until the maintenance level.
  • Extensive experience in writing Oracle PL/SQL Packages, Procedures, Functions, Database Triggers and SQL queries.
  • Good knowledge in Relational Database Design and Development using Oracle 8i / 9i /10g.
  • Good knowledge on Toad, SQL Developer, SQL Navigator.
  • Extensively worked in Oracle environment using Oracle SQL developer, SQL*Plus, SQL*loader, UNIX, Toad and Oracle Forms/Reports.
  • Expert in creating PL/SQL Packages, Subprograms, Triggers, Views, Indexes, Constraints, Sequences, Exception Handling, Collection Types, Record Type, Object Type using SQL Developer.
  • Knowledge in UNIX shell scripting.
  • Good knowledge in using Oracle Collections – V arrays, Nested Tables and Index-by Tables together with Bulk collect and cursor to improve the SQL execution.
  • Knowledge in using analytical functions, hierarchical queries.
  • Good knowledge in data flow diagrams, data dictionary techniques, Entity Relation modeling, database normalization.
  • Knowledge in using Oracle Application Express(APEX).
  • Strong experience in end to end SDLC project implementations.
  • Professional in integrating and maintaining code using version control tools PVCS, SVN, and CVS.
  • Knowledge in ETL tools, Informatica and Data Warehouse concepts.
  • Knowledge on Microsoft SQL Server 2008 and Analysis Services (SSAS).
  • Familiarity with Oracle data warehousing features such as star & snowflake data modeling schemas, materialized views, Dimensions, Facts etc.,
  • Extensively used third party tools for FTP like WINSCP, SSH etc.
  • Experience in on-call 24*7 support in production environment.
  • Excellent communication and interpersonal skills and ability to work independently and in a team with minimal supervision to meet the deadlines.

Skillset:

Oracle 11g/10g/9i/8i, Toad for Oracle Expert 12, Microsoft SQL Server 2008,Ultra Edit Professional Text/HEX Editor 20, SQL*Plus, Microsoft Visual SourceSafe, Microsoft Silverlight, Mantis Bug Tracker, TFS, Windows Vista/NT/XP/7, UNIX with Shell Scripting, Oracle Developer Suit, Oracle Enterprise Manager, Developer 2000, Oracle Discoverer, SQL*PLUS , Toad 8.6/8.5/6.0, SQL, TSQL, PL/SQL, XML,HTML,C/C#/C++, Borland C++ Builder 5, JAVA, ODBC/JDBC ,CRM,Putty, Erwin 4.1/4.0/3.5, MS Visio, Hudson , Microsoft Excel, Microsoft Power Point, Microsoft Word, Microsoft Access, Outlook, Crystal Reports, Oracle Forms and Reports 9i/6i, MS Word, Excel, Access, Win SCP, JIRA, JIS, Confluence, Lotus Notes 8.5, Oracle Forms 6i.

Projects Summary:

Confidential Atlanta

Oracle PL/SQL Developer

The project is to develop SQM Dashboard application for Critical Business Services (CBS). This application used for displaying basic ticket to order metrics for the CBS. SQM Dashboard consolidates and correlates business metric data from tools, altering sources, provisioning and other sources to provide a uniform business service oriented representation of operational metrics and KPI(s). By normalizing and correlating event and business metric data, customers/business partners can determine the health of complex enterprise services within a single dashboard in near real time.

Responsibilities:

  • Involved in analysis, design and development phases of the project.
  • Worked with Business Analyst to collect and document business requirements.
  • Created Tables, database links and jobs.
  • Developed packages, procedures, functions and triggers.
  • Created script to pull the data from one source to another.
  • Worked closely with the front end developers in creating configuration tables and summary tables that will be reflected on to the SQM dashboard application.
  • Actively participated in client meetings and made the changes in backend development as per client requirement.
  • Performed data analysis and unit testing.
  • Actively involved in all phases of Unit and System testing.
  • Worked with Database administrator to move objects from Development to Test and Test to Production environment.
  • Solved issues during testing and production phase.
  • Provided on call production support during production roll outs.
  • Involved in root cause analysis, problem solving, issue tracking and support in production.

Environment: Oracle 11g, Toad for Oracle Expert 12, SVN, SQL*Plus.

Confidential, MO

Oracle PL/SQL Developer

OSCA is responsible for providing administrative, business and technology support services to the courts. The office assists the courts include case processing, criminal history reporting, debt collection and judgment enforcement, crime victims' rights, treatment court programming, the implementation of time standards for case disposition.

The project is to develop and modify form within JIS to allow treatment court staff to enter information about treatment court participants at the time they enter the program (age, sex, ethnicity, employment, education , living arrangement). The treatment court forms will use individual screens distinguished by tab labels (Admission, Service History and Exit) to provide efficient navigation through the form.

Responsibilities:

  • Involved in analysis, design and development phases of the project.
  • Developing an application using oracle forms for treatment court.
  • Installed Oracle software and patches.
  • Developed packages, procedures, functions and triggers.
  • Created Indexes to improve the performance of the SQL statements.
  • Pulling the data from the database as per customer request.
  • Wrote SQL script to manipulate data.
  • Developed and modified forms as per user requests.
  • Designed, developed and tested forms.
  • Loaded data from SQL * Loader to Oracle database tables.
  • Worked on Virtual machine (XP) as Windows 7 doesn’t support Forms 6i.

Environment: Oracle 11g/10g/9i, Toad for Oracle Expert 12, JIRA, JIS, Confluence, SQL*Plus, Oracle Forms 6i, Lotus Notes 8.5.

Confidential,PA

Oracle PL/SQL Developer

Confidential designated to help children in their own home, to prevent neglect, abuse and exploitation, to help overcome problems that result in dependency, neglect, or delinquency; to provide, in foster family homes and child caring institutions, adequate home care for any child in need of such services.

The project is to Capture SSI, SSA, and SSP payments from finance. Create workflow, procedures/scripts, Jobs etc. necessary to collect PNC bank data which is in EDI Format from finance group (PNC Bank) to FACTS2(Family And Child Tracking system) and sync with FACTS Legacy. Second project is to automate the process of capturing IVD payments (which are in .csv format) from Pennsylvania government to DHS on behalf of its children.

Responsibilities:

  • Involved in analysis, design and development phases of the project.
  • Extensively used nested tables and PL/SQL tables to code procedures and functions.
  • Extensively used Bulk Collections to improve performance.
  • Developed PL/SQL packages, Procedures, Functions, and Database Triggers to meet the business requirement.
  • Used Explain Plan, Oracle Hints and creation of Indexes to improve the performance of SQL statements.
  • Created PL/SQL packages, procedures and functions with Dynamic SQL.
  • Created tables, views, sequences, synonyms, directories, environment variables and folders to keep control files and logs.
  • Loaded data from SQL*Loader to Oracle database tables.
  • Developed FTP script on the go using UTL FILE.PUT LINE to mget and mdelete.
  • Used database triggers for auditing and error handling.
  • Used Toad and Ultra edit tools for faster application design and developments.
  • Developed error reporting logic that would email the error report in case of job failure or process failure and allow them to correct unmatched or erroneous records.
  • Performed data analysis and unit testing.
  • Actively involved in all phases of Unit and System testing.
  • Solved issues during testing and production phase.

Environment: Oracle 11g/10g, Toad for Oracle Expert 12, Ultra Edit Professional Text/HEX Editor 20, SQL*Plus, Microsoft Visual SourceSafe, Mantis Bug Tracker, TFS.

Confidential, Alpharetta, GA

Oracle PL/SQL Developer

Confidential is a US subsidiary of Confidential a global powerhouse in electronics and electrical engineering, operating across the industry, energy, healthcare and infrastructure and cities sector.

The project is to develop new product called CAMP (Competitive Price and Margin Analyzer). CAMP is a strategy based pricing solution that suggests and assists with pricing decisions, yielding a more predictable and profitable outcome.

Responsibilities:

  • Worked with BA to collect and document database design requirements and do data modeling with DB architect using Erwin.
  • Implement the back end changes in existing product and in designing the database by gathering and understanding requirements from Business / System Analysts.
  • Analyzed the functional specs provided by the data architect and created technical specs for all the projects.
  • Developed Oracle database objects including tables, views, functions, procedures, packages, etc.
  • Written queries using a lot of aggregate functions, joins, sub-queries, etc.
  • Checking execution plan using explain plan.
  • Created Indexes on selective columns to optimize queries.
  • Developed triggers for auditing and error handling.
  • Written Stored Procedures for effective inserts and updates of the data to the tables aimed to reducing the network traffic especially when the application is online.
  • Wrote and modified Oracle PL/SQL statements, Procedures and Functions
  • Used bulk collect and forall to improve performance.
  • Reproduce Oracle schema objects includes tables, temporary tables, views, indexes, triggers and procedures, based on customer requirement.
  • Created test cases and test reports and worked with QA team to validate the data and scenarios.
  • Solved issues during testing and production phase.
  • Provided on call production support during production roll outs.

Environment: Unix, Oracle 11g, Oracle developer 11g, Oracle EBS, ERP R12, Oracle Enterprise Manager , MS SQL server management studio 2008, Toad for Oracle 9.0, PL/SQL, Erwin.

Confidential, Orlando, FL

Oracle PL/SQL Developer

Confidential is a leading package and freight express delivery company. The project concentrates on capturing and uploading of the invoices from different customers to load directly into the CAMS (Commerce Administrative and Management System) database, which is a big multi-applications financial management system database.

Responsibilities:

  • Designed and developed an on-line system which implemented measures as required by CAMS (Commerce Administrative and Management System) database. This was a system that had a web interface written using Oracle Forms and Oracle Application Server to provide access to data stored in a central Oracle database.
  • Designed and generated database objects and Oracle Forms, Reports, and Libraries through Oracle Designer .
  • Data quality checking and interacting with the business analysts.
  • Created and worked with different database objects like Tables, Indexes, Sequences, Constraints as required, Synonyms, and Views.
  • Extensively worked in creating database triggers, exception handlers, cursors.
  • Fine Tuned SQL queries using different strategies like SQL Trace and explain plan, partitioning, hints, Indexes.
  • Developed triggers for auditing and error handling.
  • Created autonomous transactions for error logging and auditing.
  • Used Joins and Sub-queries for complex queries involving multiple tables.
  • Created test cases and test reports and worked with QA team to validate the data and scenarios.
  • Solved issues during testing and production phase.
  • Provided on call production support during production roll outs.

Environment: Unix, Erwin 4.0, Oracle 10g/9i, Oracle Import & Export, IBM Cognos 8.0, PL/SQL, SQL Developer 10, Developer 2000,Discoverer,Oracle designer, Forms 9i, Reports 9i.

Confidential, New York, NY

Oracle PL/SQL Developer

Confidential is a global asset management, treasury servicing, securities servicing company.

The project was in Prime Dealer Services (PDS) group within BNY Mellon. PDS caters to 150 Customers providing Treasury Support Services on various financial products like Treasury Bills, Treasury Notes, Treasury Bonds, TIPS, U.S savings bonds, Mortgage/Asset-backed bonds, Credit Derivatives from FX, Money Markets etc. This project also includes providing the loans and facilities support to some industries and companies as operational capital.

Responsibilities:

  • Created custom table, triggers, stored procedures, functions, packages to modify the existing oracle database
  • Created a series of procedures and functions for loan and facilities transactions
  • Analyzed business functionalities related to back-end database interfaces and utilized PL/SQL developer tool to develop all back-end database interfaces.
  • Involved in daily, weekly and monthly loading of data from Mainframe data sets to Oracle RDBMS.
  • Developed triggers for error handling and to keep track of changes to the fields of tables when changes are made.
  • Worked on the Stored Procedures, Functions and Constraints, Tables, Indexes and Tuned queries for performance.
  • Tuning SQL queries using Explain Plan and SQL Trace.
  • Created views which require complex joins and quick response time.
  • Developed data entry forms using Forms Builder 6i.
  • Carried out technical specification documents for back-end and interface with front-end.
  • Modified Stored Procedures and Packages using PL/SQL.
  • Created and modified Reports using Crystal, Business Objects and Discoverer as per the business requirements.
  • Defined relationships using primary keys and foreign keys for the entities and normalized the entities.

Environment: Oracle 9i, PL/SQL, Toad 8.0, JSP, JDBC, Windows NT, HTML, SQL*Plus, Discoverer, Crystal Reports, Forms & Reports 6i, Test Advisor, Test Director, Business Objects.

Confidential, Kuwait

Application Systems Specialist

Confidential across a uniquely wide range of sectors, offering consumers the latest and best recognized names in Fashion & Footwear, Food, Health & Beauty, Pharmacy, Optics, Home Furnishings, Office Supplies and Leisure & Entertainment.

Responsibilities:

  • Wrote Stored Procedures for effective inserts and updates of the data to the tables aimed to reducing the network traffic especially when the application is online.
  • Worked on Advanced Planning Application for Manhattan project on SUN Solaris Platform
  • Wrote and modified Oracle PL/SQL statements, Procedures and Functions
  • Have basic knowledge on Business Objects.
  • Wrote Stored Procedures for effective inserts and updates of the data to the tables aimed to reducing the network traffic especially when the application is online.
  • Creation of various stored procedures, packages, functions.
  • Facilitated reports generation using Crystal reports and Discoverer.
  • Worked on creating and modifying tables, indexes, views, sequences.

Environment: Oracle 9i, PL/SQL, SQL Navigator, Discoverer, Crystal Reports, Forms & Reports 6i

Hire Now