Luxoft Poland

Overview

Enterprise BI and ETL work on a Nordea engagement while employed by Luxoft. Designed and supported Oracle Business Intelligence solutions and IBM InfoSphere DataStage ETL pipelines, including metadata development, high-availability platform configuration, administration, migrations, deployments, and production troubleshooting.

Oracle Business Intelligence — Repository Development & Metadata

• Developed, maintained, and modified Oracle BI metadata repositories (RPD) using Oracle BI Administration Tool.
• Worked with all three repository layers: Physical Layer, Business Model and Mapping (BMM) Layer, and Presentation Layer.
• Updated metadata relationships and mappings using the Physical Diagram and Business Model Diagram.
• Merged changes from development repositories into production repository versions and supported repository deployment between environments.

Oracle BI — Installation, Clustering & High Availability

• Installed and configured Oracle BI in enterprise clustered environments.
• Created and configured an Oracle BI cluster spanning two data centers, with an active–passive deployment design and a load balancer for high availability.
• Managed Oracle BI cluster components and servers and troubleshot issues affecting application availability and connectivity.

Oracle WebLogic Server — Administration & Security

• Configured and administered Oracle WebLogic Server environments supporting Oracle BI.
• Configured security realms and Active Directory integration via LDAP adapters.
• Managed roles, privileges, and access-related settings.
• Configured ODBC data sources and investigated connectivity and security issues.
• Performed WebLogic patching, cluster/server management, and troubleshooting of network, authentication, and authorization problems.

Oracle BI — Operations, Auditing & Reporting

• Configured Oracle BI auditing and administered reporting platform settings.
• Monitored server workload and investigated suspended sessions, resource-intensive or incorrect queries, and performance degradation.
• Configured SMTP and alerting capabilities.
• Set up Oracle BI Scheduler for automatic report execution and distribution.
• Troubleshot reporting failures, data consistency issues, report delivery problems, and related performance issues.

IBM InfoSphere DataStage — ETL Development

• Designed and built Parallel Jobs and Sequence Jobs from scratch, while maintaining and enhancing existing ETL jobs.
• Used Transformer, Join, Lookup, Sequential File, and Oracle Connector stages for data transformation and integration.
• Configured job parameters, variables, processing sequences, source/target connections, and ETL logic.
• Used DataStage Designer to build and modify graphical ETL pipelines.

DataStage Director — Execution & Monitoring

• Worked with DataStage Director for job compilation, execution, scheduling, monitoring, and review of job logs.
• Investigated warnings, aborted or failed jobs, and execution errors; supported troubleshooting and job reruns.
• Monitored execution status and supported operational recovery of ETL processing.

DataStage Administration & Server Operations

• Administered an existing IBM InfoSphere DataStage installation rather than performing the initial installation.
• Used DataStage Administrator for projects, environment settings, account-related administration, and access permissions.
• Restarted DataStage server-side processes and services during troubleshooting and operational maintenance.
• Investigated service availability issues and supported recovery of ETL processing after interruptions.

Information Server Manager — Deployment, Migration & Metadata Backup

• Used IBM InfoSphere Information Server Manager to migrate ETL objects and project metadata between development, testing, and production environments.
• Performed backups of DataStage project metadata and supported metadata export/import and migration activities.
• Deployed new and updated ETL jobs and components delivered by development teams.
• Supported environment promotion and troubleshooting of deployment or migration issues.

Technology Focus