We provide IT Staff Augmentation Services!

Senior Oracle Developer Resume

Fort Collins, CO

SUMMARY:

More than ten years of experience as an Oracle database developer and architect with advanced understanding and experience in SQL, PL/SQL, Oracle APIs, Confidential and data modeling.

WORK EXPERIENCE:

Senior Oracle Developer

Confidential, Fort Collins, CO

Responsibilities:

  • Worked as Database Developer on application development team for the Confidential
  • Modernized and migrated legacy application for tracking Forest Service activities.
  • Created application data model
  • Created application data interface using SQL, PL/SQL, views, materialized views, synonyms etc.
  • Created ETL processes in PL/SQL and SQL
  • Implemented virtual private database (VPD) for row level security
  • Interfaced with Oracle Internet Directory (OID) to tie together users, roles, and VPD for security

Senior Oracle Developer

Confidential, Denver, CO

Responsibilities:

  • Developed Oracle Confidential (apex) solutions
  • Developed application and data models that stored reference information for disparate reports and reporting systems (Tableaux,BI Publisher, Lookr, Cognos etc.)
  • Created front end which enabled browse and search capabilities for business intelligence related content.
  • Customized Dynamic Actions were used to enhance responsiveness.
  • Developed PL/SQL utilities for ETL and application processing.

Manager Database Development

Confidential, Lafayette, CO

Responsibilities:

  • Within an Oracle/Unix environment created data application for client that took data from flat file extracts and transformed it through various stages into a customer facing data warehouse.
  • Tools used were Korn Shell, SQL, and PL/SQL
  • Developed ETL/ELT architecture for data migration
  • Analyzed and defined data flow requirements.
  • Documented technical specifications.
  • Prepared and implemented data verification and testing methods.
  • Was responsible for performance and tuning of ETL/ELT processes.
  • Maintained development standards in conjunction with team architects.
  • Worked with project team to plan, design, develop, and implement application systems and/or
  • Reviewed and assessed code of other developers.
  • Performed data modeling, data normalization and other relevant data manipulation.

Oracle Apex Developer

Confidential, Fort Collins, CO

Responsibilities:

  • Worked on Oracle Apex application that monitored and reported on the Confidential 's purchase and acquisition of telecom products
  • Developed PL/SQL packages and procedures to support application lotic
  • Designed forms, reports, and informative web pages for multiple applications.
  • Documented system development and changes
  • Supported and fixed bugs
  • Implemented user requirements

Database Developer

Confidential, Denver, CO

Responsibilities:

  • Wrote, maintained, and modified code to process client data
  • Determined problems with existing process and proposing solutions
  • Documented end user requirements
  • Documented developed solutions
  • Assisted in the evaluation of platforms to redesign existing system on • Developed data model and programmatic architecture

Oracle Technology Consultant

Confidential, Englewood, CO

Responsibilities:

  • Architected and implemented data driven web applications utilizing a variety of programming languages and technologies such as Javascript, HTML, XML, SQL, PL/SQL and Oracle Confidential (Apex)
  • Provided custom application development and Oracle optimization in a wide variety client and industry settings such as Oil and Gas, government, power transmission, ecommerce, retail, financial, and geospatial.

Programmer Analyst

Confidential, Greenwood Village, CO

Responsibilities:

  • Front end development of reporting applications using Oracle Confidential.
  • Involved in all aspects of the development life cycle including, architecture, development, testing, training, implementation and support of reporting applications
  • Developed back end oracle data marts for Business Intelligence, Reporting and Analytics.
  • Designed and developed of SQL and/or PL/SQL packages.
  • Optimized existing queries and processes.

Programmer Analyst

Confidential, Englewood, CO

Responsibilities:

  • Designed an Oracle Apex application that worked as an assortment planning solution to track sales trends.
  • Collaborated on data modeling design decisions and overall system design, and worked directly with users to understand requirements.
  • Migrated a business - developed Microsoft Access system under the Information Systems (IS) Department including building a system abstraction layer using Access, VBA, and SQL Server, which enabled the treatment of 70+ databases as one.

Data Analyst

Confidential, Denver, CO

Responsibilities:

  • Worked on a team of developers to automate testing surrounding a data migration project for client Used Access to validate data extracts from old and new systems in order to compare for accuracy
  • Prepared reports on validations
  • Used Access, Excel, and VBA to create data analysis tools for reading and extracting data from both textual and binary files.

Commodity Pricing Analyst

Confidential, Broomfield, CO

Responsibilities:

  • Oversaw the pricing of semiconductor components.
  • Supported commodity price negotiations using reports and data from data warehous
  • Performed data analysis and reporting using Access, Excel and VBA.

Hire Now