Senior Oracle Power Bi

EXPERIENCE

Wells Fargo Bank **/** – **/**

Senior Oracle Consultant

Maintenance and support of ZELLE Oracle based system.

Liquibase Pilot project: setup, configuration, testing and process design.

Refactoring, performance tuning, installation scripts, testing, installation support for BDDM project.

Use of all Oracle objects: views, triggers, constraints, etc.

Performance tuning of PL/SQL, SQL.

Gainwell Technologies 11/21 – 03/22

Senior Oracle Consultant / Development DBA

OEM Setup and monitoring; AWR, ADDM.

Database RMAN, Restore Points.

Installations of updates to custom software. DevOPS.

User/security maintenance.

Use of views, triggers, constraints, etc.

Performance tuning of PL/SQL, SQL. Erwin for documentation and reverse engineering.

Work with off shore teams.

Warner Music 06/17 – 10/21

Senior Oracle Consultant / Development DBA

OEM Setup and monitoring; AWR, ADDM.

Database RMAN, Restore Points.

Application Database upgrades, and installations. DevOPS.

Maintenance and enhancements of Oracle based applications. Batch loading: weekly, daily, real-time using PL/SQL.

Maintenance and enhancements of MySQL based application. Use of views, triggers, constraints, etc.

Data modeling: Logical and Physical design of new tables and processes. Databases: Oracle and MySQL. Performance tuning of PL/SQL, SQL, and T-SQL. Erwin.

Release management and installations. Backup and disaster recovery of changes and new processes.

Power BI; Datawarehouse development; dimensions; daily; weekly jobs; PL/SQL; working with Cognos and Power BI teams.

LA Care Health Plan 09/14 – 05/17

Senior Oracle Consultant

Support for implementation of JAVA / Oracle 11g based OLTP application for release into production. Debugging of applications and databases. PL/SQL, functions, procedures, triggers, shell scripting.

Maintenance of Linux Oracle 11g databases. Cloning of databases and schemas of Prod/Dev/Test environments. Monitoring of system events and proactive adjustments. Performance tuning of SQL, PL/SQL, partitioning and system parameters.

Automation of comparison of Schemas in same database and different databases. Reporting differences.

X12 EDI 820, 274, 824 mapping, modeling and testing. Generation of data sets for transmission.

Intuit 01/14 – 08/14

Senior Oracle Consultant / Development DBA

Credit Card processing system: AMEX, MC, VISA, ACT-0010, Captures, Sales, Chargebacks, Retrievals; Mnemonics; RISK – maintenance, new developments and tuning.

Oracle 11G. Design, documentation, PL/SQL coding, tuning, sizing, implementation, maintenance of database and processes for legacy and new databases: OLTP and Data warehouse.

Maintenance of RISK SQL Server Database with T-SQL transformations using Tables, Views, Triggers, Indices, Stored Procedures, User Defined Functions, Dynamic SQL.

Pacific Gas and Electric 06/13 – 04/14

Application Architect, Consultant

Smart Meter Hourly Foundational Repository and Validation / Aggregation Engine.

Oracle 10G. Design, documentation, coding, tuning, sizing to fit on a laptop, implementation, maintenance and user training.

Work closely with Electrical and Gas Engineers. Heavy use of analytical functions and partitioning.

ValueClick 08/07 – 04/13

Oracle DBA / Developer

Managing a PL/SQL reporting system, which produces files and/or reports 24x7? Using multiple servers and databases for data selection with terabytes of data. Use of materialized views and partitioning. Referential integrity, lookups and external tables. Triggers and auditing. Tuning of SQL, PL/SQL. Scheduling of DBMS_JOBs and scheduler jobs (in thousands).

Reporting based on SQL Server data. Crystal Reports, T-SQL, VBA, Access, Excel, MySQL.

Accenture 12/04 – 09/06

Oracle Developer / Data Architect

Supported Digital Asset Management system. Implemented Oracle Text for efficiently querying of free texts and tables and wrote sudo-code requirements for GUI implementation by 3rd-party Company. Setup of Oracle Jobs to collect data, sync, index and rebuild index. Data modeling for Web Portal. SQL tuning. Transfer of knowledge and training of team members.

SDLC development for multiple projects: Database Design, Installation, Tuning and Optimization, Documentation, ETL, and Source Control. Support of development and support teams. Troubleshooting of real-time problems.

EDUCATION

BS / MS Computer Engineering Moscow Aviation Institute, 2001

SUMMARY

10+ years of Oracle Development in Onsite and AWS.

5+ years of MySQL Development

Logical/Physical Data Modelling

ETL, data cleansing and mining.

OLTP and Data Warehouses.

Performance tuning of SQL, PL/SQL

EDI x12 transaction 850, 857, 810, 820, 274, 824.

Contact this candidate