
Kurzvorstellung
Ich biete
- C#
- Microsoft Business Intelligence (BI)
- Microsoft Power BI
- Microsoft SQL-Server (MS SQL)
- Microsoft SQL Server Analysis Services (SSAS)
- Microsoft SQL Server Integration Services (SSIS)
- Microsoft SQL Server Reporting Services (SSRS)
- mySQL
- PostgreSQL
- PowerShell
Projekt‐ & Berufserfahrung
Großhandel
5/2019 – 12/2019
Tätigkeitsbeschreibung
Build and improve ETL processes. Design new integration based on minimizing locks and data auditing and error handling.
- Build automated processes and integration between data warehouse and SalesForce
- Monitoring and daily schedule of BAUs jobs.
- Optimize the whole solution for scalability and modularity
- Azure deployment
Work with: MS SQL 2017, SSIS, DBAMP, Azure;
Microsoft SQL Server Integration Services (SSIS), Microsoft SQL-Server (MS SQL), Microsoft Azure
1/2019 – 2/2019
Tätigkeitsbeschreibung
Build the POC for new Data Solutions for the PowerBI and the Tabular Cube.
- Redesign existing architecture and processes to improve performance, autonomous and modularity of models
- Design and execute Power BI model with
- a SQL base layer
- PowerBI reports
- Design and help with logging and auditing processes.
- POC and possibility of the ETL and data load into Tabular Cube
- Optimize the whole solution for scalability and modularity
Work with: MS SQL 2014, SSIS, SSAS, SSRS, DAX
Microsoft Power BI, Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Reporting Services (SSRS), Transact-SQL (T-SQL), Microsoft SQL Server Integration Services (SSIS)
2/2018 – 7/2018
Tätigkeitsbeschreibung
Work on back-end OLTP development for internal application.
- Plan and model application architecture for high and low-level
- Design and create data models and SQL objects.
- Design and help with logging and auditing processes.
- Implement user security management.
Work with: MS SQL 2012, SSIS 2012, GitHub.
Microsoft Business Intelligence (BI), Microsoft SQL-Server (MS SQL)
Gesundheitswesen
1/2018 – 2/2018
Tätigkeitsbeschreibung
Clear a backlog of SQL tasks. Develop new ETL processes for data warehouse and reports.
- Design and create SQL objects and ETL process
- Design and Implement new data marts
- Develop SQL reports.
Work with: MS SQL 2012,SSIS, TFS.
Microsoft SQL-Server (MS SQL)
Handel
11/2017 – 12/2017
Tätigkeitsbeschreibung
Help client with current BAU, reports, ETL processes, and TSQL. Train and guide permanent staff about the best practices for data processes and security.
- Design new architecture and data model for the Data Warehouse with the ETL processes
- Build POC for new SSIS logging/ auditing error handling
- Introduce new data incremental data load
- New high-level design of the data warehouse as a data vault
- Help design data model and reports for Power BI
Work with: MSSQL 2012, SSIS 2012, unit test, SharePoint 365, C#, Power BI.
Microsoft Business Intelligence (BI), Microsoft Power BI
Handel
7/2017 – 11/2017
Tätigkeitsbeschreibung
Build the Power BI and SSRS’s reports and dashboards for a newly migrated AX 365 data platform. Create SQL and SSRS objects through the AOS (Application Object Service).
- Plan and model solution’s architecture for high and low-level
- Design and build Kimball Data Warehouse through Entity Store
- Design and execute a data model in the PowerBI
- Create SSRS and Power BI reports and dashboards
- Build custom SSIS solutions
- Integrate SSRS and Power BI reports with AX
Work with: MSSQL 2016, SSIS 2016, SSRS 2016, AX Dynamics 365, TFS, Microsoft Azure.
Microsoft Business Intelligence (BI), Microsoft Power BI, Microsoft Dynamics AX, Microsoft Azure
Legal
3/2017 – 6/2017
Tätigkeitsbeschreibung
Design and execute the Power BI and SSRS’s reports and dashboards for a newly migrated AX 365 data platform, build objects through the AOS (Application Object Service).
- Plan and model solution’s architecture for high and low-level
- Design and execute a data model in the PowerBI
- Add row-level and model data security
- Greenfield project for the data layers (Kimball Data Warehouse) within AX Dynamics 365
- Create SSRS and Power BI reports and dashboards
- Build custom SSIS solutions
- Integrate SSRS and Power BI reports with AX
Work with: MSSQL 2016, SSIS 2016, SSRS 2016, AX Dynamics 365, TFS, Continuous Integration (CI), Microsoft Azure.
Microsoft Business Intelligence (BI), Microsoft Power BI, Microsoft Dynamics AX, Microsoft Azure
Logistikdienstleister
1/2017 – 2/2017
Tätigkeitsbeschreibung
Create ETL solution to bring multiple Excel Files data together. Clean data and prepare new obsolete datasets for the CRM AX NAV.
- Design and build SSIS solution which creates one ultimate data view for CRM.
- Liaise with business users to ensure that process specifications are accurate and complete
Work with: MSSQL 2016, SSIS 2016, SharePoint 365, SSIS external plugins CozyRoc, Pragmatic Works.
Microsoft Business Intelligence (BI), Microsoft Dynamics NAV
Gambling
8/2016 – 11/2016
Tätigkeitsbeschreibung
Develop ETL processes for the new data warehouse and migration to SQL Server 2016, data integration with the Salesforce CRM and build custom operation reports.
- Design, build, UAT test, include error tracking, process logging and data auditing system with reports.
- Design and create SQL ETL process to integrate data with new data warehouse
- Create ETL/ SQL solution for Salesforce integration.
- Develop SQL reports.
- Present and coach staff on MSSQL 2016 and PAAS, SAAS Azure capabilities and functionalities.
Work with: MS SQL 2016, TFS, Azure.
Microsoft Business Intelligence (BI), Microsoft Azure
Dienstleistungsbranche
1/2016 – 4/2016
Tätigkeitsbeschreibung
Build business intelligence solution which automates data feed the AX Dynamics 365 CRM and data integration with the system on Microsoft Azure cloud.
- Build, test and integrate SSIS solution with AX Dynamics’ API in the Azure. Process include data quality checks, errors and processes logging.
- Create customize SSRS automated reports for users and customers.
- Assists with the ad-hoc request and task around SQL, SSIS, and SSRS.
Work with: MS SQL 2012, SSIS 2012, SSRS 2012, TSQL, C#, Microsoft Azure, AX Dynamics 2012
Microsoft Business Intelligence (BI), Microsoft Dynamics AX
Versicherungen
10/2015 – 12/2015
Tätigkeitsbeschreibung
Work closely with the client to implement changes in current data processes, the feed of the data warehouse and enhance their KPI’s reports. Upgrade data migration/ integration with the data warehouse.
- Enhance and improve business reports
- Advice with future design as well as best utilization of Microsoft technology.
- Ad-hoc business support, build user reports SSRS
Work with: MS SQL Server, SSIS, SSRS, TSQL 2008R2, 2012.
Microsoft Business Intelligence (BI)
Dienstleistungsbranche
7/2015 – 10/2015
Tätigkeitsbeschreibung
Design and build new enhancement for Data Warehouse feed. Delivering a fully working BI solution.
- Develop and fully test an automated self-healing ETL process which integrates data warehouse with external APIs (REST services for Spotify, Apple).
- Build easy and comprehensive control for ETL as well as auditing and error handling process.
- Build custom reports in Tableau
Work with: MS SQL Server 2012, TSQL, SSIS, Tableau, C#, REST services, API, PowerShell, XML, JSON, UAT test.
Microsoft Business Intelligence (BI)
Braoatcaster
5/2015 – 7/2015
Tätigkeitsbeschreibung
Delivering business intelligence enhances for internal clients.
- Create and maintains various ETL solutions in SQL, SSIS, and C#.
- Retrieve business processes from legacy systems and analyze for further upgrade and quality check.
- Implement and fully test an ETL migration between multisource environments in the rich and complex data system. Ensuring data mapping and applied business logic are correct.
Work with: MS SQL Server 2008 R2, SSIS, SSRS, TSQL, PLSQL, Team Foundation, C#, Oracle 11g.
Microsoft Business Intelligence (BI), Oracle Database
Dienstleistungsbranche
12/2014 – 4/2015
Tätigkeitsbeschreibung
Work closely with management on the delivering POC for the new data architecture, exploring PAAS Azure and SQL Server 2012 capabilities.
- Build a business case for new database structure and processes to achieve optimal API load and utilize the potential of SQL Server 2014 and Windows Azure. Eliminate the current architecture’s limitation by implementing sharding and In-Memory tables for better load balance. Improve data and DB security and data warehouse access control.
- Presented concept of the incremental data warehouse, which feeds reports to the business and crucial information to the transactional system with a minimum time lag.
- Build SSIS solution to interrogate Azure storage and file system.
- Liaise with business users to ensure that report specifications are accurate and complete, and where necessary guide as to the potential options available, or equally where pitfalls may occur
- Build custom reports in Excel and SSRS
Work with: MS SQL Server 2014, TSQL, SSIS, SSRS, GIT, Erwin, VBA, C#, Excel Tabular, PowerShell, Red Gate, Microsoft Azure.
Microsoft Business Intelligence (BI), Microsoft Azure
Handel
1/2013 – 11/2014
Tätigkeitsbeschreibung
Delivering various Business Intelligence projects and POCs cover MSSQL, SSIS, SSRS and data warehouse.
- Develop key business intelligence reports for one of the main marketing program for a better recognition and evaluation of customers (Bond Triggers), longitude analysis.
- Any projects required data understanding so include data investigation, profiling with the delivering of the report/ dashboards. Close liaise with stakeholder and other team members to keep projects on track in agile methodology.
- Optimize a SQL and ETL processes for high volume data loads (structure and non-structure data sources Amazon Hadoop) for a Kimball data warehouse and enhance it with data quality auditing and error handling.
- Build and test a working POC for:
o Report schedule utilize only SQL and SSIS (without .Net)
o Incremental load of the Data Warehouse from multi legacy systems with a standardized test for TSQL, BIML and CozyRoc
- Data analysis include complex customer segmentation, build and translate logical and physical models.
- Set up a model for Continues Integration (Team City with Red Gate Tools) for all projects.
- Mentoring and teaching more junior colleagues on database design, T-SQL optimization and defending coding.
- Liaise with business users to ensure that report specifications are accurate and complete, and where necessary guide as to the potential options available, or equally where pitfalls may occur
Work with: MS SQL 2008 R2, SSIS, SSRS, Team Foundation, Red Gate SQL tools, MySQL 5.6, PostgreSQL 9.1, .Net (C#, VB.NET), VBA, T4, BIML, CozyRoc, TeamCity, Continuous Integration, XML, JSON, Excel Tabular
Microsoft Business Intelligence (BI)
Logistikdienstleister
3/2012 – 1/2013
Tätigkeitsbeschreibung
Delivering a bespoke invoice system for business from the AX Dynamics 2008.
- Design from scratch and implement bespoke and automated invoice system for delivery-handling. Fully automatically process generated invoices and informed about data quality problems. Building pricing module required understanding a complex model for the weight, size, amount and post type.
- Create universal ETL data import SSIS packages for various sources.
- Keeping internal and external stakeholders informed through the automated business dashboard with KPI and ad-hoc analysis.
- Explore with stake owner available information to enhance trends in sales and KPIs.
- Liaise with business users to ensure that report specifications are accurate and complete, and where necessary guide as to the potential options available, or equally where pitfalls may occur
- Build custom reports in SSRS
Work with: MS SQL 2008 R2, SSIS, SSRS, AX Dynamics 2009, XML, SharePoint and BizTalk.
Microsoft Business Intelligence (BI)
Dienstleistungsbranche
5/2011 – 1/2012
Tätigkeitsbeschreibung
Develop bespoke, automated solution for insurance comparison and benchmarks’ purposes.
- Build POC and fully working system for processing and validating phantom customer profiles of all insurance types.
- Incorporate extremely complex data quality rules for ad-hoc processes as well as for automated system.
Working with: MySQL 5.6, scripts in C# and ETL, unit test.
mySQL
Dienstleistungsbranche
2/2011 – 5/2011
Tätigkeitsbeschreibung
Help client with Database migration.
- Design from the whiteboard and execute the main ETL migration process for transactional data.
- Incorporate full control of frequency, quantity, and quality of send data on both ends.
- Ad-hoc reports and ETL solution
- Build custom reports in SSRS
Working with: MS SQL 2005, SSIS, SSRS.
Microsoft Business Intelligence (BI)
Manchester Geomatics Ltd, Manchester
Details anzeigen
Dienstleistungsbranche
6/2006 – 12/2009
Tätigkeitsbeschreibung
A key member of the small team, responsible for databases and their content (data quality and geo-accuracy) for online services (SaaS).
- The main project where to prepare and validate data feeds for online council systems. Services present actual geo facilities as well as various statistic data and longitude analysis as charts, maps or raw datasets for various geographic units.
- Worked with bespoke projects where I prepared data for a scoring system which better reflex complex housing situation.
- Identify the difference in the three major addresses gazetteer for one master dataset of the UK addresses for the Census 2011.
- Build informative reports (segmentation, clustering) for external clients for patterns and trends in time and space for the area. For many analyses, I liaised with the client directly and worked out their needs and through data discovery process I build new or enhance existing reports.
- Close cooperation with manager and customer let to full transparency of project progress according to SLA. Responsible for design and execution processes required close work with .Net developers.
- Liaise with business users to ensure that report specifications are accurate and complete, and where necessary guide as to the potential options available, or equally where pitfalls may occur
Work with: MySQL 4.x, 5.x, MS SQL 2005 Excel, MapInfo, ASP.Net, .Net, Geo-coding data, segmentation, longitude analysis, unit test.
Datenanalyse, Microsoft Business Intelligence (BI)
Ausbildung
(The Salford University)
Ort: Greatern Manchester
Qualifikationen
- Microsoft SQL Server, SSIS, SSRS 2005, 2008 R2, 2012, 2014, 2016 and MySQL 4.x & 5.x.
- Custom reports, data longitude analysis, data profiling, exploring trends and patterns
- Optimizing T-SQL, index strategies and mentoring younger colleagues
- Design and normalization of DB schema, create indexing, constraints, jobs/ schedules, maintain replication, DB migration, DB/ table partitioning, error tracking and solving, user permission management.
- Produce KPIs and reports (SSRS) as requested by the business according to SLA.
- Experienced with Kimball and Inmon models of Data Warehouse
- Data cleansing, removing duplication, ETL process, and data quality.
- Good eye for details, analytical approach.
- Red Gate SQL tools, source control with Microsoft Team Foundation Framework, Continuous Integration TeamCity
- Working with spatial data in MapInfo and ArcGIS, Surfer etc.
- Experienced user of MS Access (SQL code), Excel VLOOKUP’s, pivot tables and other functions.
- General knowledge of VBA, HTML, XML, JSON and .Net., R, Python, DAX
- Unit test/ Test Driven Development
Über mich
Persönliche Daten
- Englisch (Fließend)
- Polnisch (Muttersprache)
- Deutsch (Gut)
- Europäische Union
- Schweiz
Kontaktdaten
Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.
Jetzt Mitglied werden »