We provide IT Staff Augmentation Services!

Sr. Oracle Developer Resume Profile

Merrimack, NyC

SUMMARY:

  • Over 12 years in Oracle Database Development System Design/Analysis experience in the areas of Client Server and three tier applications.
  • Experience in working on Oracle database server 8i/9i/10g/11g.
  • Experience in developing PLSQL stored packages, procedures, functions, triggers, and views.
  • Experience in installing Oracle Fusion middleware 11g and configuration Dev /QA and Prod environment.
  • Experience in Deploying Oracle 11g forms/reports Application in Fusion middleware.
  • Have good experience in Oracle application server web application deployment.
  • Expertise in Developer2000 Forms 3.0, 4.5, 5.0, 6.0, 6i/9i/10g/11g , Reports 2.5/6I, Designer 2000/6.0/6i/11g, Discoverer 3.1/3.3/4i /10g, Oracle Portal 10g.
  • Experience in creating SQL loader script to load the table and stored procedure for SQL loading using Oracle 10g.
  • Create Complex report using Reports 11g like invoice, adjustment, reconciliation and various customized reports.
  • Have sound experience in TOAD / SQL navigator.
  • Involved in Oracle Forms design, Report design, PL/SQL design and Project Plan.
  • Involved in Performance tuning and Tkprof.
  • Solid experience in using Oracle development tools such as PLSQL, SQL Loader.
  • Generating XML file using PL/SQL package and interface with web application.
  • Developed Discoverer reports on oracle applications CRM modules such as Oracle Sales Online and Oracle Customer Online, Marketing.
  • Experience in Requirements Gathering, Business Analysis, Business Process Redesign and Mapping, Testing User training, Documentation of activities, processes, test scripts and results and Client/user interaction.
  • Involved in Bug fixing for applications using the Teamtracker.
  • Knowledge of ETL tools like Oracle Warehouse builder and BI tools.
  • Knowledge in BI Publisher.
  • Sound knowledge in drill down manage link report, forecasting, condition, parameter reports.
  • Extensive experience in ERD.
  • Extensive experience in Application and Database Designing.
  • Created UNIX shell scripts procedures, functions, packages, triggers for automation.
  • Involved in Unit testing and fixing the problem that occurred in UAT User Acceptance Testing .
  • Have good experience in deploying dashboards discoverer graphs, gauges, Table report into oracle portal.
  • Created Ad-hoc reports for end users using Oracle Discoverer tool.
  • Extensive Experience in development of reports using Oracle Discoverer and deployed into oracle portal.

TECHNICAL SKILLS:

  • Database: Oracle 8.X, 9.X, 10g,11g PLSQL
  • Development Tools: Forms 4.5/5.0/6.0/6i,10g,11g,Report 6i, 9i, 11i, Toad 8, Sql Navigator
  • BI Tools: Reports2.5/3.0/6I,11g Discoverer 11g, Discoverer Administrator 11g 10.1.2.00.00 , Oracle Portal 10g
  • Operating Systems: MS DOS, Windows 9x / NT / 2000, XP
  • Web/App. Servers/Middle ware: Oracle 9iAS, Oracle web DB, Oracle Portal 9i,11g ,weblogic , oracle Fusion Middleware 11g
  • Languages: Java, c

PROFESSIONAL EXPERIENCE:

Confidential

Role: Sr. Oracle Developer

Responsibilities:

  • Loading the DSM and DFP Application flat file into FXCRM application and automated the process using SQLLDR.
  • Involved in Oracle Forms web Configuration.
  • Handling Fusion Middleware admin Control, Installation and Configuration.
  • Migration forms 6i/Reports 6i to Forms 11g/Reports 1g OAS web based
  • Migration Discoverer 3i to 11g.
  • Handling Change Control logic in DSM and DFP load.
  • Handling with 8 schemas like XAR, XDSM, XOE, XSYS, XCC and XIMP, Xaudit.
  • Understand the User requirements in the fast pace project to deliver the required task.
  • Worked with Customer, Contracts, Online Adverting,.
  • Creation of FXCRM Adhoc Discoverer 11g reports such as Sales, Invoice, DSM, FXCRM Invoice Report, FXCRM Adjustments Report, and FXCRM Order Details Reports for XCRM Applications.
  • Compose, Test, and Implement along with support documentation procedures driven by UNIX Shell Script, advanced PL/SQL, stored procedures and triggers
  • Created UNIX Shell scripts to perform and report the status of the automated backups, file manipulation, transfers and archives.
  • Customization of Custom Oracle Reports such as Invoice Report and Adjustment Report for online customers generated by PL/SQL package.
  • Customized XAR Product Configuration form to add product specific fields and create and LOV for Product Categories for fox news to be used in FXCRM Application.
  • Involved in Bug fixing for FXCRM applications using the Test Director 8.0.
  • Altered Triggers in XAR and XOE Schemas to support Username functionality. This helped in fixing some of Bugs in Audit reports.
  • Customized XAR Product Configuration form to add product specific fields and create and LOV for Product Categories for Dow Jones Corporation to be used in XCRM Application.
  • Involved in Unit testing and fixing the problem that occurred in UAT User Acceptance Testing .

Environment: Oracle 11g, Forms and Reports 11g, Discoverer 11g, SQL Plus, PL/SQL, Unix, Shell script

Confidential

Role: Technical Consultant

Responsibilities:

  • As a lead developer of CAST development team, primary responsibility has been to address the User enhancement requests and post production issues for the systems.
  • Designed and created data models using Erwin.
  • Converted reports created using C and Pro C to oracle reports.
  • Created Object libraries, PL/SQL libraries and Template Forms.
  • Customized and developed Forms, Reports and Libraries to accommodate new enhancements.
  • Troubleshooting and Debugging Forms, Reports, Stored Packages and Procedures.
  • Used PL/SQL extensively for developing Stored Procedures, Functions and Packages.
  • Created Views and Materialized Views for complex data structures.
  • Optimized several queries and data structures using Hints, DBMS STAT and Explain Plan.
  • Developed complex queries, nested queries for different business logic and faster access of the data retrieval.
  • Used Bulk features, WITH clause, MERGE and CASE statements in PL/SQL code for better performance.
  • Used DBMS packages like UTL FILE and UTL SMTP for creating log files and sending e-mails.
  • Using Advanced Queuing AQ / DBMS PIPE created interface PL/SQL package between TIPS and Blackboard system.
  • Developed Package with various functions using DBMS RLS package to implement FGAC Fine Grained Access Control on MARS schema.
  • Using PL/SQL and ETL tool Informatica extracted ratings and CUSIP information from Bloomberg and FTID feeds and loaded into RPT staging area. After applying required transformations moved the data to MARS and MIDAS systems.
  • Written Shell scripts for compiling Oracle Reports and to run report batch jobs in UNIX environment.
  • Pioneered the feasibility of Oracle 10g Migration project and submitted project plan to Architecture committee for the same.
  • Responsible for Unit Testing and generating Unit Test Reports for production releases and SOX Compliance.

Confidential

Role: Sr. Oracle Developer Discoverer/Forms 6i/Reports 6i/Plsql .

Responsibilities:

  • Creating the interface for People soft Using PLSQL package.
  • Creating interface DB between XCRM and warehouse DB.
  • Loading the Dashboard Application flat file into XCRM application and automated the process using DBMS JOB and PL/SQL package.
  • Migration forms 6i/Reports 6i to Forms 10g/Reports 10g OAS web based
  • Migration Discoverer 3i to 10g.
  • Creation XML for Contract Hub using PL/SQL package and interface with Contract hub DB.
  • Handling with 11 schemas like XAR, XADV, XOE, XSYS, E2, AIMS, SERVICES, XDW, XCC and XINT.
  • Creating the Data warehouse files for the Warehouse report using PLSQL automated.
  • Creating the invoice file in XML file for people soft / creating the adjustment file in xml for people soft using PL/SQL interface with web based.
  • Understand the User requirements in the fast pace project to deliver the required task.
  • Worked with Customer, Contracts, Online Adverting, People soft Interface and licensing Applications.
  • Creation of XCRM Adhoc Discoverer 10g reports such as Sales, Invoice, Dashboard Deal Reports, Dashboard Server Logs Reports, Dashboard Accounts Report, Dashboard History Reports, Dashboard Missing Deals Lines Reports, XCRM Invoice Report, XCRM Adjustments Report, and XCRM Order Details Reports for XCRM Applications.
  • Compose, Test, and Implement along with support documentation procedures driven by UNIX Shell Script, advanced PL/SQL, stored procedures and triggers
  • Created UNIX Shell scripts to perform and report the status of the automated backups, file manipulation, transfers and archives.
  • Creating the XML publisher using the templates.
  • Customization of Custom Oracle Reports such as Market Watch Invoice Report and Market Watch Adjustment Report for online customers generated by PL/SQL package.
  • Coordinated with Team in making code changes for people-soft billing interface. This interface is to support online customer's information to be loaded into People soft.
  • Customized XAR Product Configuration form to add product specific fields and create and LOV for Product Categories for Dow Jones Corporation to be used in XCRM Application.
  • Involved in Bug fixing for XCRM applications using the Test Director 8.0.
  • Altered Triggers in XAR and XOE Schemas to support Username functionality. This helped in fixing some of Bugs in Audit reports.
  • Created Custom application forms such as E2 customer lookup form which provides an advanced Look up screen for the user to manually link an XCRM customer With an E2 Customer based on E2 Customer Information like Customer Name, Customer relationships etc.
  • Customized XAR Product Configuration form to add product specific fields and create and LOV for Product Categories for Dow Jones Corporation to be used in XCRM Application.
  • Involved in Unit testing and fixing the problem that occurred in UAT User Acceptance Testing .

Environment: Oracle 9i, Forms and Reports 6i, Discoverer 10g, SQL Plus, PL/SQL, Unix, Shell script

Confidential

Role: Sr. Oracle Developer

Responsibilities:

  • Involved in developing the report using Discoverer 10g.
  • Worked on tuning the SQL Queries for better performance and troubleshooting development problems
  • Developed back end interfaces using PLSQL packages, stored procedures, functions, Collections, Object types specifically for financial reporting.
  • Created tables, temporary tables, materialized views, constraints, managing triggers, stored procedures, indexes, cursors, synonyms, sequences and overloading procedures.
  • Did Design, quality, SQL and PLSQL reviews, making specific recommendations to optimize performance and reliability of applications.
  • Performed subsequent alterations using SQL, PLSQL to make any changes on adhoc requirements.
  • Created test plans and test scenarios for functionality and performance testing
  • Integrating Discoverer reports with Oracle Apps.
  • Involved in designing test plan and run test cases for manual testing which is basically targeted for regression testing and functional testing of these applications.
  • Migrating training instance to testing instance.
  • Responsible for Set up of Quality Management profile options.
  • Set up and find action codes, grades, hold reasons, test classes, test units, sampling plans, and quality system parameters.
  • Created UNIX scripts to perform and report the status of the automated backups.
  • Understanding The Business Process right from getting the Cement Projects to Requisition, Quotation, Procurement Planning and Expediting of the Projects.
  • Imported large amounts of invoices debit memos and credit memos from legacy system into Oracle Receivables module using Auto Invoice. PLSQL programs for data validation and Sql Loader.

Environment: Oracle sql, plsql, 9iAS Forms 6.i, Oracle Reports 6.i, Toad, Discoverer, Unix, Shell Script

Confidential

Role: Oracle Report Developer/Analyst

Responsibilities:

  • Writing Technical documents and custom version control software for tracking application design changes.
  • Creating and running the DDL data definition language .
  • Developing Object oriented relational Databases.
  • Designed code libraries using PLSQL.
  • Designed, developed, and implemented deposit management system using Oracle Designer 6.0 that generated Oracle Forms and Oracle Reports.
  • Designing and creating test development and production databases.
  • Developing system Triggers and stored Procedures to implement business rules.
  • Creating Reports by using Oracle Discoverer 3.1 for the MIS Team

Environment: Oracle 8.0, Forms 6.0, Oracle Reports 2.5 and Discoverer 3.1

Confidential

Role: Lead PLSQL Developer.

Responsibilities:

  • Analyses the business requirements of the project by studying the Business Requirement Specification document.
  • Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PLSQL, SQL Plus, SQL Loader and Handled Exceptions.
  • Prepared program specifications for PLSQL Procedures and Functions to do the data migration and conversion
  • Designed the front-end interface for the users using discoverer.
  • Involved in database development by creating Oracle PLSQL Functions, Procedures, Triggers, Packages, Records and Collections.
  • Develop and test UNIX Shell Scripts. New scripts were also required to automate and drive the procedural execution of applications for efficiency and troubleshooting purposes
  • Fine Tuned procedures for the maximum efficiency in various schemas across databases
  • Optimized critical queries to eliminate Full Table scans reduce Disk I/O and Sorts.
  • Run batch jobs for loading database tables from Flat Files using SQL Loader.
  • Participated in Performance Tuning using Explain Plan.
  • Involved in Technical Documentation, Unit test, Integration test and writing the Test plan.

Environment: Oracle PLSQL, 9iAS, Oracle Portal, Forms 6i/10g, Oracle Reports 6i/10g, Toad, Discoverer 10g.Shell Script, UNIX.

Hire Now