Oracle Developer Analyst Resume Victoria CA - Hire IT People

SUMMARY

Strong 17+ years of IT experience
Certification and expert knowledge of Oracle Application Development tools including Oracle Forms, Oracle Reports, BI Publisher, Oracle Designer
Expert knowledge of SQL and PL/SQL. Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes, Views, Inline Views, Global Temporary Tables, Export/Import Utilities.
Tuning of SQL Queries to improve performance of a system. Identify root causes and resolve problems related to system functionality.
Logical and Physical Database Design
In - depth knowledge of Oracle DBA 7.3 to 12g and Oracle Certifications (OCP) in Oracle DBA 7.3 to 9i
Relational and Star Schema Data Modeling
Linux, Unix, Shell scripting
Redwood Cronacle (JCS) development and administration
Developer, maintenance and troubleshooting experience in Oracle Financial modules, including General Ledger (GL), Account Payable (AP), Account Receivable (AR)
Expertise in analyzing business requirements and converting business requirement into code
Extensive knowledge of creating Business Requirement and Technical Documentation
Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production support on various platforms
Excellent communication and interpersonal skills. Ability to work effectively as a team member and individually.
Experience working in Agile environments: SCRUM and KANBAN

TECHNICAL SKILLS

Oracle Database 12c / 11g / 10g
Oracle EBS
Oracle ADF
Oracle Forms 10g to 12c
Oracle Reports 12c
Apex 5.1.4
SQL
PL/SQL Developer
Redwood Cronacle
Eclipse with Java / C / ProC development plugin
Notepad++
TIBCO Spotfire
Atlassian Jira
TortoiseSVN
Merant PVCS
WinSCP
Putty
NetScaler running in Windows
Linux and UNIX environments

PROFESSIONAL EXPERIENCE

Confidential, Victoria CA

Oracle Developer Analyst

Responsibilities:

Responsibilities included collaborating with Business Users and Business System Analysts in business design and specification. Developing and modifying Oracle Forms and Reports, BIP Reports, SQL and PL/SQL code, batch processes, in the development, test, and production environments.
As a member of the Operations team utilized my extensive knowledge of the corporate production systems and strong analytical and problem solving skills to provide ongoing operational support.
Responsibilities included: in cooperation with Business Analysts performed data analysis and delivered SQL and PL/SQL scripts in response to problem resolution and data management requests.
As an Oracle BI Publisher developer participated in Retirement Management System development project. Retirement Management System (RMS) and Integrated Pension Administration System (IPAS) are the two custom-built core application systems that lay the foundation of BC Pensions functions and services.
Responsibilities included working in Agile (Scrum) team designed, created and maintained 20+ BIP reports, including complex SQL queries and PL/SQL modules and supporting documentation.
As a Redwood Cronacle (JCS) backup administrator performed Database Environment migrations, including Redwood Licensing and post-migration tasks, users support and troubleshooting.

Confidential, Victoria CA

Database Analyst

Responsibilities:

Responsibilities included: working in contact and cooperation with other team members and Oracle Support, performed pre- and post- migration tasks, implementation and troubleshooting of pre- Production releases as well as the final Production release. Areas of responsibility included among others Oracle Financials security and roles, data migration and data load through the Oracle APIs.
Provided customization and Application support of Oracle Financial modules, including AP, AR, GL, FA.
Responsibilities included troubleshooting and resolving Functional Issues. Performing fundamental administrative tasks including registering applications and reports, defining users, profiles, menus and setup value sets.
Provided ongoing application support of the BCBC mission critical Oracle systems.
Responsibilities included: RICE development. Modifying Oracle Forms and Reports, including Client Agreement, Billing, and Client Request modules. Performing unit and system testing to meet the business and technical design functionality, creating and updating supporting documentation including Logical and Physical Data Models and Technical System Design documents.
Investigated, in cooperation with the client’s DBA team, the incidents of an ORA-600 error in Production and Development environment.
Responsibilities included: Analyzing Oracle server alert and trace files, performing system and dependency analysis, Metalink research, prototype developing and system design, creating System Analysis and Troubleshooting documentation.

We provide IT Staff Augmentation Services!

Oracle Developer Analyst Resume

Victoria, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship