Lead Oracle DataWarehouse & BI Developer Resume

SUMMARY:

Master’s degree, 12+ years of experience developing large scale Oracle Data Warehouses (Exadata)
Possesses in - depth knowledge of database architecture, data modeling, design and tuning
Expertise in complex queries and database optimization (including partitioning, indexing, constraints, optimizer statistics, hints and parallel processing), complex custom ETL-procedures
Mastered in developing, analyzing and debugging code
Skilled in data analysis and presentation tools (Oracle BI & Oracle Essbase & Tableau)
Proficient in Python, R, PowerShell and shell scripting
Experienced in Agile (SCRUM) and Waterfall development methodologies
Retail, Supply Chain/Logistics, HR, Insurance industry experience

TECHNICAL SKILLS:

Languages: PL/SQL, SQL, MAXL, MDX, R, Python, JavaScript, HTML, CSS, XML, JSON, PowerShell, Bash

IDE & Tools: PL/SQL Developer, Oracle SQL Developer, Toad, OEM, PowerDesigner, Erwin, Tableau, Oracle Business Intelligence (OBIEE), ORE, H2O, Informatica

Databases: Oracle 8i-10g, Oracle 11g, Oracle 12c, Oracle Exadata, RAC, Oracle Essbase (Hyperion Essbase), MSSQL, MySQL

OS: Windows, Linux/UNIX/Ubuntu

Versioning tool: StarTeam, git, GitHub

Issue tracking: Bugzilla, JIRA, Confluence

Virtualization: VMWare, Oracle VM VirtualBox, Docker

PROFESSIONAL EXPERIENCE:

Lead Oracle DataWarehouse & BI Developer

Confidential

Responsibilities:

Saved time of gathering and reporting data for supply chain and logistics department by implementing new business area in Oracle Data Warehouse through all stages of SDLC using Oracle PL/SQL (OLAP and star schemas), Oracle Essbase (Hyperion Essbase) (MOLAP), Tableau (MOLAP and ROLAP) and Oracle Business Intelligence dashboards and other web-servers from different Product Order Management and Logistics/Shipping Systems
Reduced complexity of getting data from large-scale Data Warehouse to external development teams by developing Staging server from designing and modeling in PowerDesigner/Erwin to production with ETL-jobs, API with DB Links and administration application for security managers
Increased large-scale Data Warehouse (DWH, Oracle Exadata, 30TB+) performance by troubleshooting production issues and database locks (PL/SQL, SQL, Oracle Enterprise Manager OEM, Toad), analyzing performance issues and providing recommendations based on testing results
Enhanced the accuracy of business forecasts in Oracle Data Warehouse by implying ML-algorithms in R, ORE, Python, H2O
Expanded Data Warehouse to include new data by developing complex custom ETL procedures from various sources and WEB with shell-scripting and Python, sqlldr, external tables and Golden Gate
Advanced data visualization from Oracle Data Warehouse and Oracle (Hyperion) Essbase by developing and maintaining web-application (JavaScript, HTML, CSS, XML, JSON, MDX, MAXL, PowerShell), Oracle BI dashboards and Tableau workbooks with MOLAP and ROLAP

Senior Oracle DataWarehouse & BI Developer

Confidential

Responsibilities:

Elaborated new business areas of Data Warehouse with logical/physical data design (data modeling and data architect with ERD diagrams) using Relational Database Design in PowerDesigner, Erwin, Quest SQL Navigator and Oracle SQL Developer with ETL processing using PL/SQL stored procedures, functions, packages
Advanced reporting application from Oracle Data Warehouse to MS Excel with complex sql queries (analytical functions, hierarchical, aggregate queries), performance tuning and query optimization by index tuning, partitioning and hints, explain-plans, optimizer statistics, parallelization and Exadata InMemory option
Developed a system for load testing of Oracle Essbase (Hyperion Essbase) using HP Load Runner

Software Developer

Confidential

Responsibilities:

Enhanced reporting layer of the internal ERP by developing new modules and reports (Oracle, object oriented analysis and design (OOAD), large objects (LOB), Delphi, Excel OLE) through all stages of software development life cycle (SDLC) (analysis requirements, design, development, documentation, deployment, testing and maintenance, verification, validation, support) with developing and maintaining Oracle database objects like stored procedures, functions, packages, triggers, views, materialized views, and indexes using PL/SQL Developer with performance tuning using indexing and hints

Software Developer

Confidential

Responsibilities:

Reduced complexity of reports in Human Resource department by providing new applications (using Delphi, MSAccess, Excel) based on SDLC

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship