Oracle Developer Resume

OBJECTIVE:

Challenging position that will enable me to utilize, develop, and enhance my skills.

TECHNICAL SKILLS:

Languages: Siebel, Siebel Tools, C, C#, .NET, CENTURA Build, COBOL, Seagate Crystal Reports, Extract, Transform and Load (ETL), FORTRAN, Gupta SQLWindows, LisP, Oracle OCI/OCCI, Visual Basic, Oracle Report, Oracle Forms, Oracle Report, Oracle Discover, Pascal, PL/SQL, T - SQL, PowerBuilder, Prolog, Quick BASIC, HTML, Rbase5000, RPG/400, SDK, shell scripts, SQRW, Oracle 11i, XML, Perl and Unified Modeling Language (UML)

Databases: DB2 (4,5), Gupta SQLBase, Oracle 6, 7, 8, 8i, 9i(9.0-9.2), 10g, and MS SQL Server

Version Control: PVCS, AllFusion Harvest CM, Configuration Management and Version Control (CMVC) and MS SourceSafe

Tools: SQL Navigator, Confidential, SQL*Plus, ERwin, Rational Rose, Visio, Enterprise Manager, DataMirror, PL/SQL Developer and Quest Tools

Operating Systems: AS/400, HP/UX, Window 2000, MS NT, Windows 95/98, XP, Novell, PRIME, Solaris, Linux and VMS

PROFESSIONAL EXPERIENCE:

Oracle Developer

Confidential

Responsibilities:

Configure and customize Oracle Apps 11.5.10, database 10.1. Also participated in PL/SQL development interfacing API’s to load HR data from Legacy Systems. Wrote customize programs (PL/SQL, Korn Shell) to implement as concurrent requests. Developed PL/SQL packages for client reporting, data entry, EDI and file creation between in house application and TMS transportation software.
Developed PL/SQL packages for Confidential Portal which included internal reporting, customer reporting and live tracking of individual or bulk mail pieces.
Developed PL/SQL packages for Oracle Financials implementation.
Developed Help Package for application support team to resolve daily production issues.
Developed Crystal Reports for mail manifest and USPS postage statements.
Develop PL/SQL Scripts for Support Specialist Team.
Responsible for database administration and management by using knowledge of PL SQL programming.
Daily Production Support (Cleaning up bad code, tuning, manipulating data for adhoc reporting, and moving data)

Daily use of Pl/Sql Developer

Confidential

Responsibilities:

Designed and created an interface between custom application and accounting application.
Designed and generated database objects and Oracle Forms, Reports, and Libraries through Oracle Designer.
Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.
Experience in using UNIX platform with shell scripting.
Troubleshooted performance issues and bugs within packages, forms, and reports using dbms output, Forms debugger, explain plan.
Documented business rules, functional and technical designs, test cases, and user guides.
Continuously worked with users to refine processes and business applications.
Migration of the database to new versions.
Using Oracle Warehouse Builder to perform data conversion and migrate legacy DB2 data to Oracle 10G database.
Data modeling included dimensional models using Oracle Warehouse Builder ETL capabilities for Cubes and Hierarchies.
Applying Patches to the database.
Writing tons of Adhoc queries
Cloning and Restoring Databases using hot and cold backups.

Environment: Microsoft (MS) Window XP, and UNIX

Oracle Database Administrator

Confidential

Responsibilities:

Proactively monitor database performance, analyze indicators, recommend and implement improvement actions
Manage highly available, transactional databases with a large volume data set
Utilize knowledge of SQL. PL/SQL and shell scripiting
System programming to automate database backup, monitoring and other DBA function
Perform release upgrades for existing databases
Upgraded 8.1.6 to 9.2.0.6
Test and deploy staging and production database changes, support application testing activities and refresh databases as needed
Provide production and development support
Installs, creates and maintain all Oracle databases and database objects for development, testing, staging and productions environments
Install and configure Oracle Application Server 10g
Implement functions, packages and materialized views
Physical database design and layout - log files, datafiles, rollback segments, and tablespaces
Create project user accounts, grant appropriate privileges
Estimate schema size and trend analysis on tables and indexes, manage space and disk utilization
Solving SQL loader issues for developers

Environment: Microsoft (MS) Window 2000, NT 4, MS XP

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship