We provide IT Staff Augmentation Services!

Oracle Cdc Developer Resume

0/5 (Submit Your Rating)

MD

SUMMARY

  • Over 7 years of experience in Analysis, Design, Development, Testing, Implementation and Support of IT systems.
  • Expertise in Oracle 11g/10g/9i/8i and in developing packages, functions, procedures, triggers, clusters, views using SQL and PL/SQL.
  • Extensive programming experience in Oracle 10g/11g Developer suite (Oracle Forms and Reports).
  • Hands on experience developing Master Detail Forms, Query Find Forms, Multiple canvases using forms 11g/10g.
  • Expert in developing Tabular reports, Form - like, Matrix, Matrix with Group, Group left, Group above reports using Oracle 10g/9i/6i.
  • Developed various complex reports. The reports involved complex queries in Data Model, Complex Layouts, used the functionality of Additional default layout, Parameters, Program Units and the use of report triggers.
  • Experience inPerformance AnalysisandSQL query tuning, reducing response time, while designing scalable applications from scratch and maintaining existing ones, usingAWR, Explain Plan and OEM.
  • Good knowledge of key Oracle performance-related features, such asQuery Optimizer, Execution Plans, Hints, Indexes, Clusters, Partitioning.
  • Strong knowledge in Oracle cursor management and exception handling.
  • Hands on experience in design, development of end user screens and reports using Oracle Forms and Reports.
  • Proficient in data loading/extraction using SQL*Loader and Oracle utilities.
  • Worked on in design and deployment of Unix Shell Scripts.
  • Have good Technical and Functional knowledge on Oracle E-Business suite 11i/R12.
  • Skilled in gathering user requirements by performing gap analysis and translating them into functional specifications.
  • Performed various types of testing, such as functional, system, regression and user acceptance testing.
  • Experienced in Training, Documentation and Implementation in a business environment.
  • Knowledge in performing logical database backup and recovery using Oracle’s EXPORT/IMPORT.
  • Improved performance of PL/SQL program units by using Bulk binding with Collections.
  • Hard hand in interacting with business analysts and developers to analyze the user requirements, functional specifications and system specifications.
  • Moved columns of data into and out of database tables using PL/SQL program units by passing collections as parameters.
  • Excellent analytical and interpersonal skills, oral and written Communication Skills.

TECHNICAL SKILLS

  • HP-UX
  • SUN Solaris
  • Windows NT/XP/2000
  • Linux
  • SQL
  • SQL*Plus
  • PL/SQL
  • Pro*C
  • C
  • UNIX Shell Scripting
  • Developer 2000
  • SQL developer
  • Oracle 11g 10g 9i 8i 8 7.3
  • INFORMATICA
  • Toad
  • SQL Navigator
  • SQL*Loader
  • Oracle Reports 6i/9i/10g
  • Oracle EBS(11i/R12)
  • XML Publisher

PROFESSIONAL EXPERIENCE

Confidential, MD

Oracle CDC Developer

Responsibilities:

  • Wrote DDL scripts to create new Database Objects like Tables, Views, Sequences, Synonyms and indexes.
  • Create new Packages, Procedure and triggers to fulfill business requirements.
  • Performance tuning changes to the existing SQL and PL/SQL code.
  • Developed a new environment for the exiting database for testing purpose.
  • Support CDC as a part of US ON call team and to give support WFIS team.
  • Provide production support for the nightly Batch and end of the month Pooling.
  • Work on the Defects and Problem ticket which incurred during the nightly Production batch.
  • Dealt with various data fix on daily basis.
  • Interact with business users on daily basis for the necessity of deliverables.
  • Wrote various small shell scripts to be called from the Main CDC script.
  • Developed a Package for Auditing Purpose for the user which would generate on daily basis after the Batch Completes.
  • Suggested and implemented changes to the existing system.
  • Worked on changing the process of SYNC CDC to ASYNC CDC.
  • Tested ASYNC CDC with various DBA Capture parameters like SPILL THRESHOLD LIMITS and Degree of Parallelism.
  • Worked on Improving the various stream Process for the ASYNC CDC and carried out bench mark test for the same.
  • Implemented various changes to the DDL and PL/SQL for the 2.13 releases.
  • Involved in various bench mark test for the CDC process.

Confidential, IL

Oracle Developer

Responsibilities:

  • Understanding the Business process/requirement by interacting with business users for successful deployment.
  • Wrote DDL Scripts to create new database objects like tables, views, sequences, synonyms, and indexes.
  • Developed SQL Queries to fetch data from different tables using complex joins.
  • Created PL/SQL Packages, Procedures and Functions for implementing the business processes.
  • Gathered Statistics and Analyzed Tables and Indexes for Performance tuning.
  • Tuned performance of existing SQL statements and PL/SQL code by using different methods of performance tuning techniques like Explain Plan and Hints.
  • Developed Static & Dynamic (REF) Cursors, Records & Exception handlers.
  • Worked with large tables and created partitions for managing the large tables.
  • Created audit table to record the Updates and Inserts on the tables by creating database triggers.
  • Involved in loading data using Oracle SQL*Loader.
  • Writing small UNIX shell scripts for automating jobs.
  • Involved in creating data models and object models.
  • Worked with the team members in developing the Test Plan and Test cases for Unit testing for validation of the code.
  • Participation in weekly design reviews and walkthroughs with project manager and development team.
  • Interacting with the Front End Team to in corporate the required functionality for their screens and processes.

Confidential, Florham park, NJ

Oracle Developer/Analyst

Responsibilities:

  • Created stored procedures, functions, packages, collections, triggers, object types to implement complex business functionality.
  • Data optimization, scrubbing and manipulation of staged data using PL/SQL packages.
  • Use of PL/SQL bulk collection and DML (insert/update/delete) methods.
  • Used UTL FILE for exporting data and UTL MAIL to generate E-mails.
  • Extensively used PL/SQL features like collections, nested table, Varray and Bulk collect for high performance of stored procedures
  • Assisted with testing existing code and making necessary enhancements for Oracle 11G upgrade.
  • Created database objects such as tables, indexes, views, materialized views, triggers, sequences, synonyms, etc.
  • Extensively worked on writing complex SQL queries (cursors, ref cursors, sub queries, correlated sub queries).
  • Suggested and implemented improvements to legacy systems.
  • Created various complex reports. The reports involved complex reports and the use of report triggers.
  • Developed multiple reports for IT needs to identify and improve performance.
  • Responsible for SQL tuning using explain plan, TKprof utility, optimizer hints.
  • Participated in code walkthroughs and review sessions with the development team.
  • Worked with multiple vendors to facilitate integration of systems.
  • Effectively documented and archived historical data for future auditing purposes.
  • Responsible for production support and troubleshooting production issues.

Confidential, Itasca, IL

Oracle Developer/Analyst

Responsibilities:

  • Analyze enhancement requests and develop detailed specifications.
  • Worked on requirement gathering, analysis, use case designing and testing.
  • Use SQL*Loader utility to upload data files into tables, Export and Import Oracle Utilities to move tables between Schemas.
  • Developed UNIX shell scripts and generate scripts using SQL*Plus.
  • Performance optimization, procedure definition, queries tuning, database design.
  • Wrote packages, procedures & triggers using PL/SQL to enforce business functionality.
  • Extensively Used PL/SQL to write Cursors for acquiring information to be used in calculations written in stored procedures.
  • Worked with the team members in developing the Test Plan and Test cases for Unit testing for validation.
  • Understand and articulate business requirements from user interviews and then convert requirements into technical specifications.
  • Identified new processes, found out gaps in existing process, and arranged training for new process development and implementation.
  • Developed user manuals, presentations and training manuals as per project specifications and timelines.
  • Conducted technical/non-technical presentations to the management and training workshops for the clients.
  • Created UML diagrams including context diagrams, use case diagrams and sequence diagrams to define business process model.

Confidential, Sandy Springs, GA

Oracle Developer/Analyst

Responsibilities:

  • Extensively worked on requirement gathering, analysis, use case designing and testing.
  • Performance optimization, procedure definition, queries tuning, database design.
  • Complex database programming for triggers, procedure and created integrity constraints and triggers needed to guarantee data Integrity.
  • Designed, created data entry screens to facilitate the business requirements.
  • Involved in creating UNIX shell scripting.
  • Created and executed detailed test plans and scripts to verify software functionality and adherence to business requirements.
  • Change Identification for Shipment specific and Parameters for the general billing.
  • Developed user manuals, presentations and training manuals as per project specifications and timelines.
  • Developing Control files using SQL*Loader to perform bulk data loads into database tables from external data files.
  • Maintaining the Data Base changes according to the client’s requirements.
  • Worked in partnership with project team, functional team leads and functional end-users to identify and document business process improvement opportunities and complete the definition of requirements for system design, implementation & training.
  • Conducted technical/non-technical presentations to the management and training workshops for the clients.
  • Up and Design of Backup and Recovery Strategy for various databases.

Confidential

PL/SQL Developer/Database Designer

Responsibilities:

  • Used Dynamic SQL for DDL commands in PL/SQL.
  • Creating and managing schema objects like tables, indexes, views, synonyms and clusters.
  • Actively involved in detail design, development and testing phases of SDLC and STLC.
  • Interacted with user to identify the user requirement from various groups/level of user and defined Entity relations ship diagram.
  • Used various kinds of control structures including case, decode, if-then-else, for loops, while loops while developing procedures.
  • Wrote Cursors for acquiring information to be used in calculations written in stored procedures.
  • Writing Unit Test Cases and Test Scripts for Manual Testing.
  • Debugging and tuning the PL/SQL code, tuning queries, optimization for the Oracle database

We'd love your feedback!