Senior Oracle Consultant Resume
SUMMARY
- Over 12 years of experience in the Information Technology with good knowledge and experience in Oracle Database Client Server Architecture.
- Technically proficient in Implementation, Data Migration and Production Support.
- Extensive experience on Oracle Database 8i/9i/10g/11g on Windows and Unix/Linux environment.
- Extensive Experience on Procedures, Functions, Packages, Triggers, Materialized views, SQL* Loader, Data Loader, UTL FILE, Forms6i, Reports6i, Interfaces, Conversions Unix Shell Scripting, CRON scheduling.
- Extensive Experience with Data Extraction and Data loading through multiple applications/ Databases.
- Extensive Knowledge on DBA Activities like Backup/Recovery, load Balancing, Tuning the applications, Space management, Table Partition, Schema/Table level gather stats.
- Experience in tuning of complex SQL statements using Oracle Hints(Hash & Nested Loops), Explain plans, Bulk collects, bulk binds, Parallel Process, TKPROF, SQL Trace, SQL Profiler and Indexing, Verifying AWR reports, SQL PLAN and histories, Gather Stats.
- Extensive experience on Oracle Advance Technologies Oracle Advance Queuing, OLTP, OLAP, External Tables and Table Functions.
- Extensive Knowledge on Dataware house and ETL tools.
- Extensive experience with front end applications (Java,.Net, VB,D2K).
- Extensive experience with AIM Documentation.(Technical and Functional Specifications, Unit Test Case and Installation documents).
- Involved in User Acceptance Testing,data validation, data integrity, functional testing, and system testing.
- Worked on large databases over ~1TB of data. Actively involved in creating database objects and deploying them through forms applications.
- Experienced in full life cycle of project development especially with SDLC (System Development Life Cycle) methodology.
- Participation in the analysis, development, debugging, modification and enhancement of forms and reports.
- Experience with reporting tools XML Publisher, Discoverer and Business Objects.
- Used SQL*Navigator, SQL Developer, TOAD and PL/SQL Editor.
- Used Wincvs, PVCS, Clear case and STAT, Celar Quest, Migration/version Control tools.
TECHNICAL SKILLS
ORACLE TOOLS: Oracle 7.x/8.1.7/9i/10g,Oracle Forms 4.5/6i, Oracle Reports 2.5/6i, PL/SQL, SQL*PLUS, SQL*loader, Toad 7.2/8.0.2
RDBMS: Oracle 7.x/ 8.x/8i, MS Access
Front End Tools: Developer 2000, Visual Basic,.NET, Java
LANGUAGES: SQL, PL/SQL, C++, HTML
TOOLS: Toad, SQL Navigator, PVCS, Clear case, SQL Navigator, Wincvs, Winscp, WS FTP
OPERATING SYSTEMS: Windows 9x/NT 4.0/2005, Unix
PROFESSIONAL EXPERIENCE
Confidential
Senior Oracle Consultant
Responsibilities:
- Designed and developed the interface of Groupings (BO/SF/F/A), Instruments, Positions, and stress data, regulatory/house calc output data .
- Developed the database objects like Tables, Sequences, Synonyms, Indexes, Procedures, Functions, Packages, collection types, Materialized views etc.
- Data loaded using SQL* Loader, External Tables and extraction done using UTL FILE (.txt, .csv).
- Created new schemas using schema refreshes for testing and development purposes.
- Used the Advance technologies like Table functions, Bulk Bind, Bulk collect, Collections (Varrays and Nested tables), Partition Tables and Materialized View.
- Prepared common utility package for total project it includes (messaging, partition creation and table/partition level gathering statistics).
- Supported the Quality Assurance, User Acceptance test and live phases.
- Guided technically to other team members of my team.
- Performed performance tuning the oracle objects using partition tables, global temporary tables, bulk binding, Indexes etc.
- Responsible for deployment process like code management, check in and deploying into different environments.
Environment: Oracle 11g, Java, PL/SQL Developer, SQL* Loader, Triggers, Unix, Clear Case.
Confidential
Senior Oracle Consultant
Responsibilities:
- Designed and developed the Pricing list conversion.
- Designed and developed the data base object like procedures, functions, packages, staging tables, Synonyms, Sequences, Indexes, Temporary Tables.
- Used the Advance technologies like Table functions, Bulk Bind, Bulk collect, Collections (Varrys and Nested tables), Partition Tables and Materialized View.
- Designed and developed Initial Order Shipment Confirmation email notification.
- Performed scheduling jobs in Unix and implemented complex shell scripts.
- Performed performance tuning (Partition Tables, Materialized view, Parallel Process, TKProf, SQL Trace, Oracle HINTS( HASH and Nested Loops) and Explain Plan).
- Developed Synonyms, constraints and indexes.
- Prepared Technical Design and Installation Documents.
- Working on multi - tasking for different branches and different customers.
- Prepared and ran script for creating tables, indexes etc.
Environment: Oracle 11g, Java, PL/SQL Developer, SQL* Loader, Triggers, Unix, Clear Case.
Confidential
Senior Oracle Consultant
Responsibilities:
- Developed the database objects like Tables, Sequences, Synonyms, Indexes, Procedures, Functions, Packages, collection types, Materialized views etc.
- Data loaded using SQL* Loader, External Tables and extraction done using UTL FILE (.txt, .csv).
- Created new schemas using schema refreshes for testing and development purposes.
- Used the Advance technologies like Table functions, Bulk Bind, Bulk collect, Collections (Varrays and Nested tables), Partition Tables and Materialized View.
- Prepared common utility package for total project it includes (messaging, partition creation and table/partition level gathering statistics).
- Supported the Quality Assurance, User Acceptance test and live phases.
- Guided technically to other team members of my team.
- Performed performance tuning the oracle objects using partition tables, global temporary tables, bulk binding, Indexes etc.
- Responsible for deployment process like code management, check in and deploying into different environments.
Environment: Oracle EBusiness sutie R12, Oracle 10g, Java, PL/SQL Developer, SQL* Loader, Triggers, Unix, ClearCase and Clear Quest.
Confidential
Senior Oracle Consultant
Responsibilities:
- Involved in the FDERS Account Data Conversion.
- Designed and developed Packages for Amortization, Merchant, Mass and batch letters, and Recovery.
- Designed and developed tables and triggers for Amortization, Mass and batch letters.
- Developed database objects Procedures, Functions, Packages, Synonyms, Constraints, Indexes, and External Tables.
- Performed performance tuning (TKProf, SQL Trace and Explain Plan).
- Prepared Complex Unix Shell Scripts.
- Prepared Technical Design and Installation Documents.
- Working on multitasking for different branches and different customers.
- Data loaded from flat file to tables using SQL* Loader from legacy applications.
- Data Extracted to flat file using UTL FILE.
- Involved in day-to-day database maintenance, Partition tables, Unix Job Scheduling.
- Prepared and ran script for creating tables, indexes etc.
Environment: Oracle 10g, Java, PL/SQL Developer, SQL* Loader, Triggers, Unix.
Confidential
Senior Oracle Consultant
Responsibilities:
- Performed performance tuning (TKProf, SQL Trace, Oracle HINTS(HASH and Nested Loops) and Explain Plan).
- Used the Table functions in Packages to improve the performance.
- Data loaded from flat file to tables using SQL* Loader.
- Designed and developed Un Invoiced Late Procedure.
- Designed and developed Sales Tax PL/SQL Report.
- Designed and developed Stamp Duty PL/SQL Report.
- Designed and developed Partial Payments Late Interest Package
- Designed and developed Sales Orders Conversion Package.
- Designed and Developed AR Invoices Conversion Package.
- Used for materialized view for the customer data.
- Designed back end tables structures.
- Prepared unix shell scripting programs.
- Working on multitasking for different branches and different customers.
Environment: Oracle EBusiness sutie R12, Dataware house/ ETL tools, Oracle 10g, PL/SQL, SQL*Plus, SQL* Loader, Triggers, Unix, TOAD, SQL Developer, STAT (Migration TOOL), SVN(Version Control Tool)
Confidential
Senior Oracle Consultant
Responsibilities:
- Performed database design (Views, Database triggers, Materialized views, packages, functions, and procedures).
- Performed performance tuning(TKProf, Explain plan).
- Data extraction using UTL FILE.
- Involved OLTP database design.
- Scheduled the nightly jobs using DBMS Scheduler.
- Implemented Advance Queing for message transmission between different programs.
- Developed control scripts for SQL*Loader for loading data from flat file to Oracle.
- Involved in taking the backups from day to day and make sure of the servers maintenance.
- Prepared unix shell scripting programs.
- Running script for creating table spaces, tables, indexes etc.
- Developed Packages to extract data and populate tables in CSV format for reporting.
- Involved in developing packages to convert data from legacy to Oracle.
Environment: Oracle EBusiness sutie 11.5.10, Oracle 10g, PL/SQL, SQL*Plus, OLTP, SQL*Loader, Unix, TOAD
Confidential, TX
Team Lead
Responsibilities:
- Interacting with business user to gather requirements and object wise clarifications.
- Arrange meetings with team members.
- Reviewing the objects of team members.
- Performed performance tuning(TKProf, Explain plan).
- Attending conference calls with business users and team members for clarifications.
- Objects estimation.
- Daily/weekly status reports.
- Involved in developing Views, Database triggers, packages, functions, and procedures
- Working on multitasking for different branches and different customers.
- Prepared Technical Design Document and Installation Document for the project.
Environment: Oracle EBusiness sutie R12, Oracle 10g, PL/SQL, SQL*Plus, SQL*Loader, Unix, TOAD.
Confidential
Offshore Technical Lead
Responsibilities:
- Receive the objects from on-site and review the objects.
- Estimation of the objects.
- Allocation of the objects to team members.
- Attending conference call with business users for objects clarifications.
- Daily/weekly status reports.
- Creation of users, managing privileges.
- Resolving user’s day-to-day issues.
- Supported several developers with Oracle related support for database access and Performance tune applications.
- Performed SQL tuning, analyzing and optimization.
- Used Wincvs version control to check in and check out files
Environment: Oracle EBusiness sutie 11.5.3, Oracle 9i, PL/SQL, SQL*Plus, SQL*Loader, Unix, TOAD, Wincvs.