Stanis Dulko Email & Phone Number

New York, Ny, Us

Customer:Financial Data Providers (S&P, Preqin, GfK, FactSet, BigByte, ConsumerEdge, etc…) Project: Creation of Data Marketplace based on financial data from Financial Data ProvidersTools, Techs and Languages: Spark SQL, Python, NiFiNotable Tasks:• Delivered custom-tailored solution for Standard & Poor’s - named entity recognition, data API extraction, file schema change and SFTP delivery (Python), ML• Developed ELT for company’s data marketplace to bring in financial data in (NiFi/Python) with custom ETL/ELT solution (Oasis/Spark SQL) • Enhanced Ticker recognition and drafted long-term solutions for system improvement

Newtown, Pa, Us

Customer:Consumer ReportsProject: Building from ground up infrastructure, DataLake, ELT, visualizations for a brand new analytical product. Tools, Techs and Languages: SQL, Tableau, AWS, PySpark, PandasNotable Tasks:• Management, design and development of visualization security and architecture (ELT to Publishing)• Design and Development of Tableau dashboards• Verification and analyze of business needs, requirements directly with BA/VP• Numerous modifications based off customer's feedback• Counseling best practices across the board

Newtown, Pa, Us

Customer:Consumer ReportsProject: Transfer and improvement of legacy Oracle DWH to a new AWS + RedShift one. Tools, Techs and Languages: Oracle SQL, Postgres / RedShift, Python, VBA, AWS, RPDM, RegExpNotable Tasks:• Design and development of ETL (SQL, RPDM) for Inbound/Outbound feeds• Complex legacy code migration (Oracle to Redshift)• SQL/ETL analysis, tuning, enhancement• Data Modeling, prototype design and development• Coordination between Dev, Business and vendors

Newtown, Pa, Us

Customer: Merck & Co.Project: Transfer from old DWH to a new one. Cognos dashboard based on DM fact tables. From start to finish within a month.Tools, Techs and Languages: Oracle SQL, PL/SQL, IBM Cognos AnalyticsNotable Tasks: • Autonomous DE• Proof-of-Concept Framework prototype• Layer-to-Layer, STG-DM, DM-KPI SQL scripts based on procedures’ code

Newtown, Pa, Us

Customer: Wolters KluwerProject: DWH dedicated to storage of xml events. Transition from DWH to DWHaaS ( Kafka + Spark + AWS ).Tools, Techs and Languages: SSIS, SSMS, Apache Kafka, Apache Spark, Apache Drill, Bash, AWS, XML, Xpath, RegExpNotable Tasks: • Autonomous DE• Frequent communication with customer’s Dev and BA teams.• Reporting templates enhancement and improvements.

Newtown, Pa, Us

Customer: GroupMProject: Support of 11 customer’s systems based on the same framework. Analysis, development and deploying of P4 - P1 incidents including but not limited to connection issues, report issues, database and ETL issues.Tools, Techs and Languages: SSAS, SSIS, SSMS, T-SQL, VBANotable Tasks: • Autonomous DE• Performed incident analysis: connection, report, ETL issues• Created complex (Cursor, Dynamic SQL) SQL scripts for regression coverage: datatype scripts, data transfer scripts, report calculations scripts• Communication with incident-raisers, business users, Customer’s BA and Support teams• Participation in debugging• KT to the team and handover sessions during project transition• Technical Team management

Newtown, Pa, Us

Customer: ExpediaProject: Refinement of Raw business data for storage and report creation. Apache Hive/Hadoop + AWS.Tools, Techs and Languages: Bash, Python, Apache Hive, Apache Hadoop, AWSNotable Tasks: • Development and scripting done via Shell using Apache Hive ( SQL-like ) syntax • Custom data sync Powershell / .sh scripts to increase data transfer and team downtime

Newtown, Pa, Us

Customer: GroupMProject: Development of tender-winning SQL Server + Cube + KPI Reporting for one of the largest advertising companies.Tools, Techs and Languages: MDS, SSAS, SSIS, SSMS, T-SQL, VBA Notable Tasks: • Autonomous DE• In-depth requirements analysis • System design • SSIS packages development, debugging• Data consistency throughout entire process including but not limiting to MDS, ODS, reports via automated T-SQL and/or VBA scripts including manual checking• Complex (Cursor, Dynamic SQL) SQL scripts for regression coverage: datatype scripts, data transfer scripts, report calculations scripts

Newtown, Pa, Us

Customer: Canadian TireProject: Extract, Transformation and generating output of customer's data via T-SQL procedures / SSIS. Daily flow of different types of input files. Tools, Techs and Languages: SSIS, SSMS, T-SQLNotable Tasks: • Daily backup and sync jobs written in T-SQL• Complex SQL Scripts templates

Nicosia , Nicosia District, Cy

Customer: Deutsche Bank - Global banking and financial services company.Project: ETL of customer's Data across several DWH. 5 different sources into DWH w/ complex transformations via Java. Source included DBLINK, XML ( stored as CLOB in DB ). Tools, Techs and Languages: Oracle SQL, PL/SQL, Groovy, XML, Xpath, RegExpNotable Tasks: • In-depth technical analysis/whitebox testing via Oracle SQL, XML and Xpath • SQL scripts with complex transformations: window functions, nested cte, hints• Automation regression testing via third-party tool written in Groovy