Mag. Mariusz Sil

In BWI I’m working as a DataStage ETL developer. Through analysis of PL SQL code in source, Staging area, and Presentation area. Development is organized into Test, Int, PROD environments My activities are converting most complex customer data sources into DataStage jobs. INDUSTRY TYPE: Army/Resource, Ticket, Asset Management • ETL modules: Designer, Director, Quality Stage • Development jobs and workflows • Data import/export to inhouse reporting RWH • Oracle 11g/12c PL SQL and DB2 analysis

In RSA I’m working as an SSIS Developer, and SQL Server dwh admin, integrating data into Teradata. Fixing ETL bugs/workflow optimization and technical issues. UpSert strategy in SSIS, Sort transformation optimization and executed DEV, UAT, PRD env migrations • SSIS/CDC ETL development • SQL Server 2014 database admin,sql • Teradata; writing SQL analysis, creating tables, views and validating data • Analysing data quality; writing automated scripts • Fixing ETL mapping, sessions, and workflows bugs

In FOX Broadcasting Corp I’m working as an Informatica 9.x Developer. ETL activities was to maintain and develop mappings in Informatica for NAT GEO channel for data load, Data quality and customer support. I also optimized exsiting SQL Server scripts to meet performance requirements through using Indexes and incremental load methodologies. INDUSTRY TYPE: TV Broadcasting • Informatica ETL development • Fixing ETL mappings, sessions, and workflows bugs • Analysis of DQ issues for TV, VOD, HULU, Foxnow data

In Diageo I’m working as ETL datastage developer, and adivisng on dwh model. My activities were focused on early stages of data extract from sources thrugh running extraction jobs scheduled automatically. I also designed staging area tables and build target tables from business report requirements. Some activities also includes detailed documentation. INDUSTRY TYPE: Alcoholic Beverages, Retail • ETL: Designer, Director, Quality Stage • DataStage: Building jobs and workflows • Analysis of dwh model

In Shoppers Drug Mart I’m working as an SSIS Developer, and DWH Admin, integrating multi-source systems using SSIS ETL. Often searching for ETL bugs/workflow optimization and fixing technical issues. I proposed solution for Upsert strategy in SSIS, Sort transformation optimization and executed DEV, UAT,PRD SSIS environment migrations INDUSTRY TYPE: Retail/PharmaceuticalSSIS ETL development • SQL Server 2012 database admin,sql • Analysing data quality issues • Fixing ETL mapping, sessions, and workflows bugs

In Lucky Brand I’m working as a SSIS Developer, and Database Administrator, integrating several universes into MicroStrategy reporting system. Often searching for ETL bugs and fixing reporting/dat issues. I proposed solution for Slowly changing dimension in SSIS, and developed DEV vs PROD delpoy INDUSTRY TYPE: Retail • SQL Server 2012 database admin,sql • SSIS ETL development, best practices • Analysing data quality issues • Fixing ETL mapping, sessions, and workflows bugs

In Lloyds Pharmacy I’m working as an DataStage ETL data extract solution proposal and POC for building PDC algorithm within MicroStrategy tool Database developer/MicroStrategy Architect. I analysed and imported 3rd party data internally, and. I also did some ETL import to inhouse dwh INDUSTRY TYPE: Retail/Pharmaceutical • ETL: Designer, Director, Quality Stage • DataStage: Building jobs and workflows • Data import to inhouse reporting • SQL Server 2012/Oracle dwh model development

In DFW Dallas Airport I’m working as an Informatia Developer, and Database Administrator, integrating several universes into MicroStrategy EDW system. Apart from regular ETL I’m also involved in designing and running sql script for Source, Staging, and Terget tables. Often searching for ETL bugs and fixing reporting/dat issues. INDUSTRY TYPE: Airport Services • Informatica 9.0 ETL development • Oracle Database Administrator • Analysing data quality issues • Fixing ETL mapping, sessions, and workflows bugs

DESCRIPTION: In MuniServices I’m working as an MicroStrategy Schema expert and Pentaho ETL developer. The MicroStrategy Platform was build on Cloud, and installed locally. I also took big part in Reports/Documents/Dashboards development and introdueced several user training sessions for MuniServices Senior BI staff. INDUSTRY TYPE: Finance (Taxation Services) • MicroStrategy Schema development • Pentaho ETL development, loading Mockup Data • MicroStrategy Reports/Dashboards development

I’ve created a fully automatic ETL process, for populating GDC Consultants DWH in MySQL. Data was fetched from files (Excel files). ETL process is fully incremental, after refreshing historical data, ETL loads delta information to DWH. INDUSTRY TYPE: Workforce ETL system • ETL development of fully automatic system to extract data from XLS files and load to MySQL database • Remote Access of Job execution configuration • Complete documentation, FAQ and instructions for users creation

DESCRIPTION: I’ve created fully educational workshop with Pentaho 4 PDI ETL tools in order to explain/teach new, existing employees on Pentaho features. Workshop contains basic and complex ETL exercises i.e. simple file/file, db/file loads, expressions, lookups, joins, filters, insert/update strategies, sorters, switch/router, normalizes, denormalizes, aggregation, sequence generator, workflow control INDUSTRY TYPE: ETL Workshop • Completed workshop for educational purposes

• Supporting Oracle aviation DWH • QA, reference data issues resolving • Participating in analysis changes DWH model • Developing ETL logic (JDATA, Pentaho) • J2EE app. (report tool for users) development, troubleshooting • On-demand modifications, configuration management • First Line technical user support • Serving as liaison between database admin, developers and end users • Creating system schemas, data-flows, references • Database model (Power Designer, CorelDraw, MS Visio), documentation creating

Mutlimedia IT Techniques and Artificial Intelligence