We provide IT Staff Augmentation Services!

Oracle Developer Resume Profile

SUMMARY

  • Twelve year's experience with all aspects of application support, development, systems analysis, testing,
  • software design, modification and implementation using standard, AGILE and other iterative system
  • development life cycle methodologies
  • Twelve year's experience with Oracle 7.34,8i,9i,10g,11g, Reports 2.5-10g Forms 4.5-9i-10g, PL/SQL, UNIX, HTML, TOAD, SQL Server 2005, SQL Server 2008, Visual Studio 2005 - 2008, TFS, Crystal Reports ver. 10 - XI, C , .Net Framework 2.0-3.5, Windows, SQL, T-SQL, SQL Plus, PL/SQL Developer, Oracle Designer 9i, Clintrial, Business Objects, MS Excel, MS Word, MS Access, Visio, Visual Source Safe, TOAD, SQL Developer
  • Five years technical/end-user support of various .Net Oracle-based applications new development,
  • application support and enhancements
  • Strong documentation skills writing design and functional documents, implementation plans,
  • implementation scripts, test plans, test cases, completed unit and user acceptance testing
  • Strong communication, organizational and problem solving skills

EMPLOYMENT

Oracle Developer

Confidential

  • Support and maintain three manufacturing ERP applications on Oracle 11g - Oracle Manufacturing 11i standard and customized modules, a fully custom and a third party order entry application
  • Develop and enhance PL/SQL packages, procedures, functions and triggers to support system wide changes or resolve trouble tickets
  • Develop and enhance application user interface using Oracle Forms 6i and reports using Oracle Reports R6i
  • Application design using standard and AGILE system development life cycle methodologies
  • Maintain and track version control of all objects across seven database instances using PVCS
  • Troubleshoot, track and resolve software issues on Sharepoint-based ticket system
  • Define, monitor and maintain system processes in Concurrent Manager tool
  • Tuned code changes using Explain Plan, TKPROF and database monitoring tools
  • Write technical design and enhancement documentation
  • Developed UNIX, SQL and PL/SQL scripts
  • Strong written and verbal skills
  • Proficient in the use of TOAD and other database tools SQL Navigator or SQL Developer
  • Microsoft Office Suite Word, Excel, Access and Visio

IT Support Technician

Confidential

  • Troubleshoot PC, PBX and network issues within a 600 station call centerMaintain GPO and security groups for over 350 users in Windows Active Directory
  • Troubleshoot devices with customers assistance via phone in often adverse situations
  • Educate users in usage and general maintenance of computer and telecom equipment
  • Trained and accomplished in the use of network troubleshooting tools and techniques
  • Work in fast-paced, detail-driven technical environment requiring strong listening/communication skills
  • Monitor and update trouble tickets and service requests with Remedy tracking system

IT Manager

Confidential

  • Maintained, configured and troubleshot PCs and servers to support business function
  • Optimized system's performance and provided 24/7 support of systems
  • Installed, configured and administered network technologies
  • Backup Management, Reporting and Recovery
  • Plan and lead training sessions for Windows XP and Office Suite
  • Microsoft Office Suite 2007 - 2010 Word, Excel, Access and Projects 2007

Programmer/Analyst

Confidential

  • Designed, developed, business and systems analysis of a state services client tracking software application
  • Developed PL/SQL packages and procedures in Oracle 10g to process business functions for a .Net front end
  • Design of application used AGILE system development life cycle
  • Developed C classes to cleanse and format checks of data between .Net application and legacy system
  • Processed and tracked trouble tickets to address post-production issues with software
  • Developed .Net classes with Visual Studio 2008 using C to process queries, updates, inserts and deletions
  • Tested and reported on prospective database programming and modeling tools
  • Wrote test plans and test cases to validate software changes per federal regulatory requirement
  • Completed unit and user acceptance testing of changes and documented outcomes per established test plan process
  • Wrote functional and design documents per federal regulatory requirement
  • Technical liaison between state agency and project development team
  • Troubleshot issues via direct interaction with customers/SME to define nature of issue
  • Strong written and verbal skills
  • Proficient in the use of TOAD and other database tools SQL Navigator or SQL Developer
  • Microsoft Office Suite 2007 - 2010 Word, Excel, Access and Visio

Programmer/Analyst

Confidential

  • Designed, developed and analyzed business and system requirements of a state services client tracking software
  • Application using AGILE system development life cycle
  • Developed PL/SQL packages, procedures and triggers to extract and translate data from Oracle 9i then export to an off campus SQL Server 2000 database
  • Developed C classes with Visual Studio 2005 to process XML files
  • Loaded XML files into SQL Server via SFTP
  • Created weekly progress reports and updated project manager ad hoc as a lead programmer analyst
  • Developed scripts to build database objects i.e. tables, constraints, tablespaces and document their use
  • Developed SQL Server stored procedures to cleanse and format data required by Federal regulation
  • Developed test cases and wrote test plans then completed unit testing and user acceptance testing
  • Wrote user requirements, change and implementation documentation
  • Wrote functional and design documents per federal regulatory requirement
  • Tuned code changes using Explain Plan, TKPROF and database monitoring tools
  • Use of TOAD as well SQL Navigator
  • Microsoft Office Suite 2007 - 2010 Word, Excel, Access and Visio
  • Strong Oral and written skills

Oracle Developer

Confidential

  • protection agency incident tracking system
  • Designed, developed and analyzed business and system requirements of user requirements for state food
  • Developed and tested Oracle Forms and Reports 10g
  • Developed PL/SQL Procedures, Functions and triggers in Oracle 10g supporting in-house business requirements
  • of agency software application
  • Completed unit and user acceptance testing of changes and documented outcomes per established test plan process
  • Wrote functional and design documents per federal regulatory requirement
  • Use of TOAD and SQL Developer
  • Strong Oral and written communication skills
  • Use of Windows XP and Microsoft Office Suite 2007 - 2010 Word

Data Warehouse Developer

Confidential

  • Designed, developed and implemented Oracle 10g packages and stored procedures to extract, translate and load ETL large volumes of data using RDBMS techniques, functions and utilities
  • Tuned code using Explain Plan, TKPROF and database monitoring tools
  • Developed, tested documented changes to in-house ETL packages
  • Developed testing environments to successfully test changes to ETL packages
  • Completed unit and user acceptance testing of changes and documented outcomes per established test plan process
  • Wrote functional and design documents, testing plans, implementation guides Visio diagrams such as E/R and data flow diagrams
  • Wrote scripts, change requests and attended Change Control Board review meetings to insure proper implementation of code changes
  • Use of SQL Navigator and SQL Developer
  • Use of Windows XP and Microsoft Office Suite 2007 - 2010 Word, Excel, Access and Visio

Systems Analyst

Confidential

  • Customer support of the Oracle-based application, troubleshot, developed and implemented corresponding changes
  • Developed PL/SQL Functions, procedures and Packages in Oracle 10g
  • Developed, supported and documented database Oracle PL/SQL packages and stored procedures for the Clintrial development tool
  • System analysis of data management requirements for FDA regulated trial studies
  • Troubleshot, processed and tracked trouble tickets/change requests using the Remedy tracking tool
  • Wrote and ran formal test cases and developed, maintained supporting documentation per FDA system validation procedures
  • Wrote test plans, functional and design documentation to support validation of code changes
  • Microsoft Office Suite 2007 - 2010 Word, Excel, Access and Visio

Oracle Designer/Business Objects

Confidential

  • Designed, developed and analyzed business and system requirements in support of various departmental functions
  • Developed Business Object universes to support user-defined and/or ad hoc reports in Business Objects 6.5.1
  • Developed reports in the Business Objects Full Client Reporting tool using Oracle Designer 9i as an object repository and data source
  • Completed unit and user acceptance testing of changes and documented outcomes per established test plan process
  • Wrote functional and design documents, testing plans, implementation guides Visio diagrams such as E/R and data flow diagrams
  • Wrote scripts, change requests and attended Change Control Board review meetings to insure proper implementation of code changes
  • Microsoft Office Suite 2007 - 2010 Word, Excel, Access and Visio

System Analyst

Confidential

  • Designed, developed and analyzed business and system requirements of data warehousing architecture and applications in Oracle Designer 9i
  • Developed PL/SQL packages, procedures and functions in Oracle 9i to populate a Department of Defense DOD financial data warehouse on a UNIX system with Oracle Designer 9i
  • Developed and wrote design level documentation of a large Financial Management System
  • Developed and wrote logical design documentation consisting of context diagrams, data flow diagrams, logical data models and entity relationship diagrams ERD
  • Analyzed and troubleshot end-user problems with DOD financial accounting system
  • Peer reviewed user requirements to develop functional and technical documentation
  • Microsoft Office Suite 2007 - 2010 Word, Excel, Access and Visio

Programmer/Analyst

Confidential

  • Designed, developed and implemented system analysis in support of distribution center's IT requirements at-large
  • Troubleshot and tracked trouble ticket software issues in Oracle Financials version 7 applications generated by in-house help desk
  • Supported, developed, tested and implemented management and user-defined enhancements of in-house third-party Oracle-based applications
  • Developed applications and reports for end users in various Oracle Financials modules such as accounts receivable, accounts payable, order entry, inventory and marketing
  • Developed reports in Oracle Developer 2000 Reports 4.5 on Sun Solaris with UNIX Windows NT client/server systems Developed functions, procedures, packages, triggers report triggers with SQL, PL/SQL
  • Developed UNIX, SQL and PL/SQL scripts
  • Help Desk end-user support of system problems on third-party Oracle-based applications
  • Proficient with T.O.A.D. Tool for Oracle Application Developers

Hire Now