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.
• 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.
• 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.
• 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.
• 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

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

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.
• 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.
• 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