Location
PolandRate
Years of experience
9+About
As a seasoned Data Engineer and Technology Consultant with over 11 years of experience, I specialize in data analytics, business intelligence, and data warehousing. My expertise includes developing ETL processes, data integration, and automation, with a strong proficiency in SAS 4GL and advanced SQL. I have a robust background in creating interactive dashboards, optimizing SQL queries, and managing large datasets across various industries, including banking and telecommunications. In my current role as an Enterprise Data Warehouse Senior Developer at SDC A/S, I focus on ETL development, SQL script creation, and solution testing within an international, Scrum-driven environment. Previously, I served as a Data Engineer at SCS Expert, where I contributed to key projects for clients like Play and ING Hubs Poland, developing data warehouses and marketing data marts. My technical skills are complemented by an academic foundation in big data engineering and international economic relations. I am also passionate about cloud solutions, Python programming, and continuous professional development.Tech Stack
SAS programming, Data Analysis, Data Management, Database, Git, Jenkins, MS SQL, Oracle, Salesforce, SQL, TeradataExperience
- Developed and optimized ETL processes for data warehousing and business intelligence solutions.
- Created complex SQL scripts for Oracle, Teradata, and Greenplum databases, including DDL, DML, and query optimization.
- Programmed in SAS 4GL and SQL, handling large datasets and enhancing data processing efficiency.
- Designed and implemented interactive dashboards using Qlik Sense for data visualization and reporting.
- Conducted manual and automated testing of developed solutions, ensuring data quality and accuracy.
- Analyzed business requirements and prepared technical documentation for various projects.
- Led the automation of reporting processes using VBA and advanced Excel functions.
Employment history
• Development of ETL processes in SAS Data Integration Studio, proper
implementation jobs and user written codes using SQL pass-through facility
• Creation SQL scripts for Teradata database: DDL and DML, initial data loads,
optimization of SQL queries and stored procedures
• Manual and automatic testing of developed solutions
• Comparison verification of proof of concept scripts and deployed codes
• Code review and preparation of technical documentation
• Develop ETL processes in SAS Data Integration Studio, create custom transformations and SQL scripts for Oracle and Greenplum databases.
• Program in SAS 4GL and macro language, execute advanced SQL queries, manage large datasets, and optimize data processing.
• Create Analytical Base Tables (ABT) for credit risk modeling, including PD, LGD, EAD, IFRS9, and IRB calculations.
• Test solutions, perform manual and automatic data quality checks.
• Analyze business requirements and prepare technical documentation.
• Contribute to key projects, including data warehouse development for Play and SAS development for ING Hubs Poland.
• Manage the end-to-end analytical process: requirements, data preparation, integration, implementation of business logic, visualization, and presentation to stakeholders.
• Create Qlik Sense dashboards, develop complex SQL queries, program in SAS 4GL and macro language, and write MS SQL Server database scripts.
• Administer and develop the management information system (MIS), including the
Market Communication System (SFA) and other Samsung partner systems.
• Automate data extraction processes from SAP ERP using VBA scripts.
• Develop software automation robots with WinAutomation (RPA) for various tasks.
• Automation of reporting process with VBA and advanced excel functions
• Data collection, cleaning and integration from various sources (internal
systems, Excel files, GfK data, flat files)
• Preparation of sales and marketing analysis: market share, customers
segmentation, shelf share, product availability, category management
Education history
We’ve helped 83 clients with IT recruitment and software development.
Read about a few of them below...