Stanislav Salnikov

Working on a DWH project with BCS Bank- Developing and optimizing ETL processes for an SQL server-based Data Warehouse Big projects: * Developed a system to parse manually entered fields, validate for data quality issues, and integrate the cleaned data into the datamart, which reduced workload on analysts and improved the report quality * Refactored a legacy data collection process — originally based on a web service — into a streamlined, SQL-based pipeline, improving performance and maintainability

- Developing data load processes in Greenplum-based Data Vault data warehouse with dbt

- Worked on DWH projects for Unicredit Bank- Used SAS and Oracle technologies for data integration and transformation, working across diverse file and database-based input formats - Led the integration of a new data source into the warehouse, coordinating schema alignment and transforming raw inputs for consistency across existing systems - Designed and implemented several large-scale ETL pipelines for Unicredit Bank’s data warehouse, supporting new business reporting needs

- Worked in the RnD and Architecture group - Developing interactions between different databases and data sources- Fixing problems and optimizing the existent problematic ETL processes in our business - Technologies used: Oracle (BI, ODI), Postgresql, Greenplum, Mysql, python, bash, linux, whatever else they decide to ask me to do

- Developed scripts for the automatic reports download - Developed the automated campaign creation and ad data upload to Google Ads / Bing Ads scripts based on product structure - Automated the ETL processes, moving data between the company’s databases, Google Ads, Bing Ads - Managed ad activation/deactivation and bids via scripts - Technologies used: SQL, Python, Google Bigquery, Postgresql, Google Adwords and Shopping API, Bing Ads API, bash

- Duties included designing tables, cubes and datamarts in the database, optimizing the data manipulation and access methods for performance and accuracy, setting up automated ETL processes - Main project involved user profile data gathering and analysis, setting up raw data aggregation processes for several large datamarts and optimizing them for the timely delivery. - Technologies used: SQL, PL/SQL, Toad, Oracle ODI, OBIEE, Python, bash.

- Developed demo examples using the company's software - Developed report forms and participated in database development for analytical systems produced by the company - Developed the course materials, examples and documentation - Taught the courses for the company's developers, partners and clients - Software used: BI-applications (data warehousing, administration, reports). Relational databases (Oracle, MS SQL.) Programming languages used: SQL, Fore, Fore.Net, ASP.NET, Java