We provide IT Staff Augmentation Services!

Sr. Oracle Pl/sql Dev Resume

NJ

SUMMARY

  • Oracle Certified Professional with 10+ years of experience in Financial and Healthcare domain.
  • Strong knowledge of Oracle Fusion 11g, Oracle Web Logic Suite 11g, Oracle Database 10g, 11g, Oracle Fusion Middleware, Oracle Enterprise manage, Forms and Reports including installation, deployments, configuration setup and administration..
  • Expertise in Oracle SQL, PL/SQL, Oracle Forms, Oracle Reports, Oracle Applications ERP technology, Oracle Web Logic Server, UNIX Shell scripts and Netezza SQL.
  • Involved in developing various inbound and outbound interfaces to integrate legacy systems, mid - range applications to Oracle applications using ETL, XML, and web services, PL/SQL, SQL Loader, FTP and UTL Files.
  • Substantial development experience in creatingstored procedures, Packages, Triggers, Functions, Indexes and Views.
  • Strong knowledge of OBIEE as a Business Intelligence tool and Data Extraction using Informatica as ETL tool.
  • Proficient in Performance Tuning SQL statements using EXPLAIN PLAN, AUTOTRACE, and SQLTRACE.
  • Worked on Advanced PL/SQL Concepts (PL/SQL Tables, Record type, Bulk Collects and Bulk Binds).
  • Good Experience in using Oracle tools like SQL Navigator, SQL*Loader, Data Loader, FND LOAD, SQL developer, TOAD.Sql * Plus,Oracle Enterprise Manager (OEM)
  • Strong programming experience in creating Procedures, Packages, Cursors, Functions, Triggers and other database objects using SQL and PL/SQL. Proficient in writing and tuning complex SQL statements.
  • Extensively worked on changing teh reports according to client requirements and Optimizing teh Report Performance.
  • Experience in Data Warehousing Concepts like Star Schema, Snowflake Schema Methodologies.
  • Participated in Requirements gathering, preparing Business Specification Documents, Functional Specification Documents, Data Mapping Sheets, Design Reviews and Test Cases for modules.
  • Experience in Development and maintenance of Informatica Repository and OBIEE repository.
  • Used Informatica Client tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager Etc.
  • Expertise in Oracle platform migrations. Worked extensively in migrations from 10g to 11g.
  • Expertise in writing DatabaseStored procedures, Functions, Packages,Triggers, Cursors, Exception Handlers, Dynamic Cursor programs,Native Dynamic SQL.
  • Good experience with teh usage ofBulk Insert,Nested tables,External tables,advanced queuing, Materialized Views, Inline Views, Analytical functionsandREF cursors.
  • Hands-on experience with source control tools likeVisual Source Safe (VSS)
  • Experienced with Full Project life cycle and well versed with scrum, Agile and standard SDLC methodologies.

TECHNICAL SKILLS

Database: Oracle 9i/10g/11g, DB2 10, SQL Server, MySQL

Front-End Application Tools: Oracle Developer Suite - Forms 9i/10g/11g and Reports 9i/10g/11g

Fusion Middleware: Oracle WebLogic Server 11g, Oracle Application Server OC4J

ETL Tools: Teradata, Informatica

Languages: Oracle WebLogic Server 11g, Oracle Application Server OC4J

Tools: /Utilities: SQL Developer, PL/SQL Developer, TOAD, SmartTerm, ClearCase, Microsoft Visual SourceSafe, JIRA, Visual studio, Visio, RAD, Putty

Testing Tools: Manual Testing, Test Directory

Operating Systems: Windows NT, MS-DOS, UNIX, LINUX, AIX

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr. Oracle PL/SQL Dev

Responsibilities:

  • Understanding teh application flow and process. Participate in teh development and implementation of software version and change control processes, policies, and procedures across multiple development teams.
  • Involved in teh Effort Estimation process and Reporting Resource allocation phase
  • Developing of Oracle Forms and Reports to include: interacting with stored procedures, packages, triggers, and materialized views; experience with TEMPeffective debugging; and performance tuning
  • Perform impact analyzes of changes
  • Fine tuning Oracle database tables and queries as and when required and tuning SQLs using Analytical Functions.
  • Solved several show-stopping performance issues to ensure dat we were able to migrate within very tight timescales.
  • Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace reports.
  • Developed UNIX jobs with teh help of Oracle Advance Queue and Scheduler
  • Developed related PowerBuilder objects and GUI for teh new module.
  • Work closely and provide technical support to team members on new and existing Oracle systems.
  • Perform knowledge transfer in teh areas of Oracle SQL and PL/SQL programming, Oracle Developer suite (Forms and Reports).
  • Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract teh data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
  • Developed Informatica Workflows and sessions associated with teh mappings using Workflow Manager.
  • Involved in creating new table structures and modifying existing tables and fit into teh existing Data Model.
  • Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
  • Doing Code review and responsible for all teh deliverables from teh team.
  • Create and execute test plans, to include unit and peer testing, for standard and client-specific benefits requirements.

Environment: Oracle Fusion Middleware, Web Logic Server, Forms (11g), Reports, PL/SQL, SQL, DB2, UNIX Shell scripting, clear Case, Harvest, Informatica, PowerBuilder.

Confidential

Oracle PL/SQL Dev

Responsibilities:

  • Involved in maintenance and enhancement of teh application.
  • Designed/developed tables, views, various SQL queries, stored procedures, functions and Packages to implement teh business logic using PL/SQL.
  • Constructions/Coding of PLSQL programs.
  • Involved in PL/SQL code review and modification for teh development of new requirements.
  • Involved in front end enhancements using PowerBuilder.
  • Designed, architected, and implemented teh system enhancements which utilized PowerBuilder for dynamic front end user interface. Design includes services dat encapsulate all database interaction from teh front end screens.
  • Handling production support activities like resolving L2, L1 and critical tickets within teh SLA.
  • Unit Testing/Peer review of Enhancements.
  • Preparing TA Documents, Unit Test Case, Estimate and Review Report documents for teh enhancements.
  • Used PL/SQL tables, array structures as a part of oracle collections.
  • TEMPEffectively communicate issues and progress to project leads.
  • Providing Application wise and Technical KT to new resources of teh team and bringing them to teh level quickly.
  • Solving day-to-day problems, providing support to teh users.
  • Communicate confidently and proactively with customers throughout teh project lifecycle.
  • Manage multiple client engagements simultaneously.
  • Identify Source tables (OLTP) and Target tables (OLAP) for Data mapping.
  • Participate in Design Reviews of Data model and Informatica mapping design.
  • Assisted in creating Logical and Physical data modeling.
  • Worked on Mapping designer, workflow designer, workflow monitor etc. of Informatica.
  • Examining teh session logs if teh workflows fail and fixing up teh defect.
  • Debugging mappings using Debugger tool in Designer.
  • Participated in testing Data matching between Siebel and OBIEE Databases and Dashboards.

Environment: PL/SQL, SQL, Powerbuilder, Toad 9.7, XML, UNIX Shell scripting, Clear Case

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Involved in requirement analysis, developing and testing Oracle Stored Procedures, Functions and Packages.
  • Writing various form triggers, front end program units and DB program units to realize teh business requirements. Made teh entire frame work related configurations necessary for dat module
  • DevelopedPL/SQL Packages, ProceduresandFunctionsaccordance with Business Requirements for loading data into database tables.
  • CreatedMaterialized Viewsandpartitioning tablesfor performance reasons.
  • Used TOAD, PL/SQL developer tools for faster application design and developments
  • Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
  • Developed Master Detail, Detail reports using tabular and Group above reports.
  • Developed procedures usingDynamic SQL.
  • Developed database objects includingtables, Indexes, views, sequences, packages,triggers and proceduresto troubleshoot any database problems
  • Bugs/issues reported by teh client are simulated and localized in teh local environment and Fixing teh bug reported by teh client.
  • Involved inUnit Testing Stored ProceduresandFunctions.
  • Review of code changes, test procedure, test plans and other deliverables using Clear case
  • Unit level testing and final level testing been done on project.
  • Direct interaction with teh client regarding teh issues and clarification.

Environment: PL/SQL, SQL, Oracle forms (10G), Oracle Reports, TOAD, UNIX, SQL * PLUS, HTML, Java Script, XML, DB2, Netezza SQL, UNIX Shell scripting, Clear Case.

Confidential

Oracle PL/SQL Developer & ETL Tester

Responsibilities:

  • Developing test plan and test strategy.
  • Extensively worked with Teradata utilities likeFast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
  • Analyze and write detailed specifications and Test Requirements using Test Director.
  • Participated in teh planning, development, coordination and presentation of specific testing needs as appropriate to teh quality assurance needs of teh end user.
  • Data TEMPhas been pulled from different DB using Informatica.
  • Did data analysis and data validation for various version changes on different source systems.
  • Providing teh required test data for teh developers in order to fix teh defects.
  • Review of teh test cases written for User Acceptance Testing (UAT), and System Integration testing (SIT).
  • Involved in preparation of teh Test Plans and Test cases.
  • Logged teh defects in Quality Center and maintained track of teh defects throughout teh life cycle.

Environment: Oracle, DB2, PL/SQL, SQL, Informatica, Teradata

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Developing transaction module for quotations, starting from template form till deploying it on teh live server with complete functionalities.
  • Handling of main modules independently which includes in creating of contracts, invoices and matching of purchase contracts with teh sales contracts.
  • Based on teh customer requirements and teh business logic, I has made teh screen design and subsequent organization of blocks, canvas and windows.
  • Writing various form triggers, front end program units and DB program units to realize teh business requirements. Made teh entire frame work related configurations necessary for dat module.
  • DevelopedMaster Detail reportsin Form & Reports to meet teh requirements of end users within teh system.
  • Developeddata entry forms, complex and template forms in Forms 6i.Creation of Pop-up Menus and maintaining Master Detail relation-ship.
  • Used variousLOVS(List of Values) and record groups at various points in runtime.
  • Development of client side program units and sharing them among multiple applications for processing business logic in teh database.
  • Bugs/issues reported by teh client are simulated and localized in teh local environment.
  • Fixing teh bug reported by teh client.
  • Unit level testing and final level testing been done on project.
  • Direct interaction with teh client regarding teh issues and clarification.
  • Designing Forms, Constructions/Coding & Integration of Form Level Validation.
  • Enhancement on main modules was also done.
  • Bugs/issues reported by teh client are simulated and localized in teh local environment.

Environment: Oracle Application Server 10g, Oracle Developer Suite 10g, Oracle Database 10, SQL, PL/SQL, Oracle Forms, Oracle Reports, Toad 8.0, VSS, UNIX.