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