Support the business with new and existing BI processes, data models and SQL.

• Build and maintain data models (star schema) for data warehouse (DWH) and data marts.
• Develop and maintain SQL code, transformation and integration.
• Support and alter Tableau reports and SQL data sources

Build and support existing custom automated ETL solutions. Worked with various business departments on T-SQL delivery.

• Maintenance metadata-driven ETL solution based on T-SQL, SSIS and .NET
• Transfer data between Data Warehouse and data marts
• Build and maintain data models
• Create and maintain SSRS reports
• Support T-SQL code and process, suggest code optimization, index strategy and user management (Development DBA)

Build reports and dashboards for project management with the Power BI. Close cooperation of data requirements and expectations.

• Design and develop a star-schema  data model
• Incorporate DAX calculation with M-language transformation for process flat files

Help the client to review the current data model and advise on process optimization. Recommend redesigning process, build PoC for a new optimized process for volume and smooth user experience.

• Design a new simplified star model for Power BI
• Remove complex DAX joins (many-to-many), smoothing report responsiveness
• Move some logic to the T-SQL layer
• Incorporate row-level security

I build and implement reports with the Power BI. Working closely with the business advising best approaches, methods and code optimization to meet strict SLA times for reports. Cooperate with other teams to reach the most streamlined, efficient data delivery process.

• Based on Tableau reports build the Power BI reports with DAX
• Work closely with data analysts to understand, verify and test processes and results
• Delivery of various complex visuals which use geo-referencing, nested data and longitude analysis
• Implement data model and security

I design and develop new incremental ETL processes. Automated, incremental data integration between data warehouse and  Salesforce.

• Optimize the whole solution for scalability and modularity
• The ETL process includes error logging with data and process audit, focusing on low data latency and parallelism
• Build and maintain data models
• Azure deployment

I advised the customer on rebuilding current processes and presented a few PoCs for new data solutions covering: ETL, incremental build, T-SQL, Power BI and AX 2012.

• Redesign existing architecture and processes to improve the performance, autonomy and modularity of the model
• Design new Power BI data model with and without a cube (solely based on T-SQL or Tabular Model)
• Design and help with logging and auditing processes
• Optimize the whole solution for scalability and modularity

I worked on back-end OLTP development for the internal application. Work closely with businesses on collecting and understanding requirements.

• Plan and model application, high and low-level architecture, data modelling conceptual and physical
• Development of new T-SQL objects, implement user security management
• Design and help with logging and auditing processes
• Build and maintain data models

Help business with current BAU tasks and speed up the development of backlog tasks. Closely cooperate with business owners to understand their needs and requirements. Involved with the full development life cycle.  

• Create new and enhance existing T-SQL and ETL processes for a DWH
• Data modelling conceptual and physical, design and Implementing new data marts
• Develop T-SQL reports

Help the client with the current design of the DWH and reports. Build PoC for new DWH and suggest best practices, improvements and optimisations to the processes.  Work closely with the business to understand their needs and expectations.

• Act as a solution architect and design new architecture based on data vault methodology, data modelling for the Power BI reports and dashboards
• Build PoC for new ELT based on the SSIS and T-SQL which include data logging, auditing error handling, self-healing, incremental load
• Help design data models and reports for the Power BI

Create an ETL solution to bring multiple data into a customer single view. Clean data and prepare new obsolete datasets for the CRM AX NAV.

• Design and build an ETL, T-SQL solution
• Liaise with business users to ensure that process specifications are accurate and complete

Develop ETL processes for the new Kimball data warehouse. Data migration to SQL Server 2016, data integration with the Salesforce CRM and building custom operation reports.

• Acting as a solution architect involves the design, data modelling, conceptual and physical
• The development covers the full code life cycle and UAT test, error tracking, process logging and data auditing system with reports
• Design and create a T-SQL and ETL process for DWH and  Salesforce
• Develop T-SQL reports
• Present and coach staff on MSSQL 2016 and PAAS, SAAS Azure capabilities and functionalities

Build an ETL solution which automates the data feed of the AX Dynamics 2012 CRM and data integration with the Azure cloud.

• Build, test, and integrate SSIS solution with AX Dynamics' API in Azure. The task includes data quality checks, errors, and process logging
• Create customised SSRS automated reports for users and customers
• Assists with the ad-hoc and BAU request and tasks around T-SQL, SSIS, and SSRS

• I work closely with the client to implement changes in current data processes: data feed to data warehouse and enhance their KPI?s reports
• Refresh business logic to reports as well as provide ad-hoc business support
• Share knowledge and advice with future design as well as the best utilization of Microsoft technology

• I design and build new enhancements for a DWH feed
• I act as a solution architect, plan and model solution?s architecture
• Develop and fully test an automated self-healing ETL process that integrates data warehouse with external APIs (REST services for Spotify, Apple, high volume)
• Together with data integration, I introduce ETL control (through SQL), auditing and error handling processes
• Operational KPI?s were in Tableau

• I deliver business intelligence enhances for various business clients
• Create and maintain ETL solutions in T-SQL, SSIS, and C#
• Validate and analyze the business process for further upgrade and quality checks
• Implement and fully test an ETL migration between environments in the rich and complex data system
• Ensuring data mapping and applied business logic is correct