Letztes Update: 05.03.2024
Build and support existing custom automated ETL solutions. Work with various business departments on T-SQL delivery.
Help 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.
I build and implement reports with the Power BI. Working closely with 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.
I design and develop new incremental ETL processes. Automated, incremental data integration between data warehouse and Salesforce.
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.
I worked on back-end OLTP development for the internal application. Work closely with business on collecting and understanding requirements.
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.
Help 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.
I work on the implementation report suit for AX 365 for the accounting and finance department based on SSRS and Power BI. I was involved with collecting business requirements, understanding rules and full development lifecycle.
Design and develop the Power BI and SSRS reports and dashboards for AX 365 data platform. Build objects in the AOS Application Object Service. Work closely with the business on requirements specification and testing.
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.
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.
Build an ETL solution which automates the data feed of the AX Dynamics 2012 CRM and data integration with the Azure cloud.
Work closely with the client to implement changes in current data feed processes for one of the subsystems and data warehouse.
Design and build a new ETL feed for the Data Warehouse, collecting information about artists and royalties fees. Delivering a fully working BI solution based on SSIS, C# and T-SQL. Close align with business on solution delivery.
Delivering solutions and PoCs for the data warehouse (DWH). I was involved with the full project/ code lifecycle, cooperating with various business teams: accounting, operations, marketing and procurement. Responsible for the design, development, test and deployment of an SSIS, T-SQL and SSRS code. Often I had to act as Developer DBA and work on T-SQL and process optimization.
