We provide IT Staff Augmentation Services!

Oracle Analyst/developer Resume

3.00/5 (Submit Your Rating)

SUMMARY

  • Around 10 years of analyzing, designing and developing applications using Oracle PL/SQL.
  • Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, and User Defined Data Types.
  • Extensive experience in design, analysis and development of full life cycle Software.
  • Focus on customer requirements, as well as analysis and development of Oracle applications.
  • Knowledge about software development life cycle methodologies such as SCRUM and AGILE.
  • Proficient in Oracle 11g/10g/9i/8i, PL/SQL back end applications development using Toad, SQL Plus, and SQL Developer.
  • Migrated various reports from Oracle Reports Builder 6i to 10g.
  • Experience in advanced PL/SQL concepts like Bulk collect, Materialized Views, PL/SQL tables, Cursors and Dynamic SQL for DML operations for better performance.
  • Experience in developing Oracle Forms using Forms Builder 10g/11g.
  • Created Complex Master Detail Reports, with calculations, format triggers, Programming Units and Report triggers.
  • Extensively monitored various jobs for data staging, processing and loading data.
  • Used version control tools for maintaining the different versions of files and implementing the code changes like Clear Case, WinCvs.
  • Created Test cases for Unit Test, System Test and Integration Test to check the data quality.
  • Self-taught, adaptable to any technology or update, with a short learning curve.
  • Skilled in software debugging and trouble-shooting.

TECHNICAL SKILLS

ERP: Oracle EBS 11i & 12, Banner

Operating Systems: Windows XP/7/10

Software: Microsoft Project, Visio, Clear Quest, Clear Case, Harvest, TIBCO, Oracle WF, Putty, WINSCP, XML Publisher, Remedy, Oracle Forms, Oracle Reports, WinCvs, FileZilla.

Soft Skills: Teamwork, Time management, Adaptability, Process analysis, Leadership, Good communication, Focus on results, willingness to learn.

Programming Languages: PL/SQL, SQL, JS, CSS, HTML, XML.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Analyst/Developer

Responsibilities:

  • Analyze and clarify user requirements and/or needs.
  • Define report’s scope.
  • Create new reports, forms, packages, procedures, functions, objects etc.
  • Create test cases for testing.
  • Control different code versions.
  • Modify, fix, tune codes, reports, forms and recreate issues.
  • Research about existing issues, provide options to solve them and fix them.
  • Provide support to users.
  • Script’s creation.
  • Development of full life cycle Software

Technologies: Oracle DB 12c, PL/SQL, TOAD, Oracle Forms 11g, CVS, Putty, FileZilla.

Confidential

Oracle Developer

Responsibilities:

  • Analyze and clarify user requirements.
  • Create Stored Procedures, Functions, Packages, Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, and User Defined Data Types
  • Create test cases for testing.
  • Control different code versions.
  • Modify, fix, tune codes and recreate issues.
  • Research about existing issues, provide options to solve them and fix them.
  • Provide support to users.

Technologies: Oracle DB 10g, PL/SQL, SQLDeveloper, Oracle Forms 10g.

Confidential

Oracle Developer

Responsibilities:

  • Worked in Requirement Analysis, Design, Development, Integration and Testing, Implementation and Maintenance phases of the projects.
  • Communicated with client for technical and business requirements and release manager / team.
  • Used Clear Case and Harvest for version controlling.
  • Applied partial business logic writing Stored Procedures, Functions and Triggers using PL/SQL in Oracle 10g.
  • Participated on the decision making process for selecting the appropriate technologies for the project based on requirements and the user’s needs.
  • Worked with agile development in order to achieve the user’s needs on time.
  • Analyze and clarify user requirements and/or needs.
  • Define report’s scope.
  • Write, modify and/or removed requirements according to user’s expectations.
  • Raise real and possible issues.
  • Database tuning.
  • Create new reports, forms, etc.
  • Create test cases for testing.
  • Provide support to users.
  • Control different code versions.
  • Modify, fix, tune codes, reports, forms and recreate issues.
  • Research about existing issues, provide options to solve them and fix them.
  • Define expected delivery dates.
  • Script’s creation.

Technologies: Oracle DB 10g,11g, PL/SQL, SQLDeveloper, Oracle Forms 11g, Oracle WF, Clear Case, Harvest, JS, CSS, SQLPlus.

Confidential

PL/SQL Developer

Responsibilities:

  • Implementation of Reports.
  • Development applications for a distribution center using Oracle Database for all electronic billing of Brazil, returns, donations, logistics, maintenance.
  • Rotate shifts on Saturday to make sure the system in all Latino America work without problems.
  • Analyze user needs.
  • Analyze data to make the application useful and accurate.
  • Analyze processes.
  • Design of systems.
  • Create software according to the specifications and needs.
  • Testing application.
  • Support.
  • Optimization of processes.
  • System migration.

Technologies: PL/SQL, HTML, CSS, Java Script, Oracle Reports, TIBCO, XML.

Confidential

Oracle Developer

Responsibilities:

  • Analyzed data to make the application useful and accurate.
  • Created documents for the software specifications.
  • Created software according to the specifications.
  • Interfaces for uploading information to the database from files.
  • Testing application.
  • Implementation of on line credit card payment for UNIT University.

Technologies: PL/SQL, HTML, Java Script, BANNER.

Confidential

Oracle Developer

Responsibilities:

  • Implementation of Reports and templates for generating checks, invoices, purchase orders, etc.
  • Created documents for the software specifications.
  • Created software according to the specifications.
  • Interfaces for uploading information to the database from files.
  • Worked in a team project and managed source code versioning applications to develop.

Technologies: PL/SQL, Oracle Reports, XML Publisher, EBS.

We'd love your feedback!