Oracle Analyst/developer Resume
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.