SUMMARY:

I have over 10 years of experience with cooperate America with the last 5 years focused on oracle business intelligence and database related projects. My skills and area of specialties includes: Installation and Configuration, Database performance & Tuning, Backup and Recovery, OBIEE RPD creation and review, OBIEE dashboard creation, links, rename, modification, Oracle SQL Developer. I am a Self - starter with capability to acquire new skills autonomously. I have solid written and verbal communication skills to drive projects to successful conclusion. Also experienced in setting up and maintaining, Oracle Data Guard, database security modeling, and how to use it effectively to restrict data access. I have strong experience in Oracle financial applications. With my accounting degree, I bring to the table a rare skill of deep understanding of business and technology.

TECHNICAL SKILLS:

DATABASE: Oracle, MS Access and SQL Server

OPERATING SYSTEMS: Windows, UNIX, LINUX

TOOLS: SQL*Plus, RMAN, RAC, OEM Grid Control, Patch Management, ODBC, Oracle Developer, TOAD.

PERFORMANCE TUNING: SQL Tuning, Explain Plan, SQL Trace.

PROFESSIONAL EXPERIENCE:

Confidential, Fort-Worth, TX

OBIEE Developer

Responsibilities:

• Responsible for Oracle install, support, monitoring and regular maintenance
• BI Publisher Report Developer
• Performed OBIEE RPD creations and reviews
• Physical and presentation layer creations.
• Proficient Oracle's BI Publisher developer
• Experience with OBIEE 12c Client Tools Installer
• Created XML data templates in BI Publisher
• Created report layout templates in BI Publisher
• Knowledge of Oracle ERP
• Knowledge of Extraction, Transformation and Load process (ETL)
• Knowledge of Data Modeling, Snowflake, Star Schema, Format, Physical layer
• Adequate proficiency in tuning the SQL, PLSQL code for optimum performance
• Good understanding of OBIEE ad-hoc reports development process
• OBIEE dashboard Creation, dashboard links, rename, dashboard Analysis modification
• OBIEE 12c reports development work experience including RPD
• Ability to create different kinds of views such as Graphs, Pivot Tables, Performance tiles, Column Selector & view Selector in OBI Answers.
• Performed Installation, Configuration, Upgrade and Migration.
• Oracle SQL basic queried languages and Reports.
• Performs all other related duties

Confidential, Irving, TX

OBIEE Developer /Oracle Database

Responsibilities:

• Responsible for Password grant, reset, and revoke.
• BI Publisher Report Developer
• OBIEE dashboard Creation, dashboard links, rename and modification
• OBIEE 12c reports development work experience including RPD
• Query Writing, Data manipulation, memory management, and table partitioning
• Backups and recovery database files
• Created different kinds of views such as Graphs, Pivot Tables, Performance tiles, Column Selector & view Selector in OBI Answers.
• Knowledge of Extraction, Transformation and Load process (ETL)
• Upgrades and manage services experience in Application in R12 and Database 11g, 12c
• Managed user accounts, creating, disabling, modifying of permissions.
• Oracle 12c, Enterprise Manager installation in Window 7, and LINUX environment
• Experience with Red Hat Enterprise Linux Installation
• Created XML data templates in BI Publisher
• Experience with Tools for Oracle Application Development (TOAD)
• Performed Installation, Configuration, Upgrade and Migration.
• Performed all other related duties
• Documented trouble tickets in detail, by documenting the impact to the customer, and assigned the appropriate priority level.

Confidential, Irving, TX

Oracle Database Administrator

Responsibilities:

• Responsible for Database creation and maintenance
• Managed user accounts, creating, disabling, modifying of permissions.
• Oracle database performance and tuning
• Oracle install, support, monitoring and regular maintenance
• BI Publisher Report Developer
• Created database objects and different kinds of views such as Graphs, Pivot Tables, Performance tiles, Column Selector & view Selector in OBI Answers.
• Physical and presentation layer creations.
• Created XML data templates in BI Publisher
• Oracle 12c, Enterprise Manager installation on Window 7,10, and LINUX environment
• Knowledge of upgrades and manage services experience in Application in R12 and Database 11g, 12c
• Performed all other related duties assigned
• Documenting of trouble tickets in detail, by documenting the impact to the customer, and assigned the appropriate priority level.

Confidential, Dallas, TX

Accountant /Oracle DBA

Responsibilities:

• Responsible for processing invoices for payment in Oracle environment
• Oracle database performance and tuning
• Database creation and configuration
• Password grant, reset, and revoke.
• Processed all new travel card applications and cancellations and Expense Report
• Uploaded payment from Excel to Oracle Environment with (FTP) File Transfer Protocol
• Utilized Oracle Suite to upload entries, process accounts payable, and prepare reports
• Assisted with month end closing
• Maintained general ledger by transferring subsidiary accounts and posting reconciling entries.
• Resolved issues and concerns with Vendors and Customers
• Processed monthly accruals and Journals
• Entered invoices into the system for payment
• Responsible for journal entries
• Reconciled accounts with bank records
• Performed all other related duties