Reporting für Baufinanzierung/ Automatisierung
Reporting MS SQL Server von SSIS über SSAS bis SSRS
[Name auf Anfrage]
Senior SAS Developer Saarbrücken, DE ? [Rufnummer auf Anfrage]
[E-Mail-Adresse auf Anfrage]
Tech savvy and highly analytical professional with versatile experience in various facets of statistical analysis, IT support, and software engineering. Credible success improving overall functionality and performance by developing and deploying software solutions.
Proven track record of creating scalable application, correcting coding errors, resolving technical
issues, streamlining development workflows, implementing reporting systems, driving data integration, and improving customer satisfaction.
Adept at managing and maintaining databases containing large quantities of information. Skilled
at developing and enhancing existing reports and data interfaces using SAS. Expert at creating automated regional reports by using ESRI ArcGIS. Ability to analyse data and statistics to find market trends, discover demographic breakdowns, and locate other relevant business information. Excel at co-ordinating with high-performance teams at all levels to achieve established goals across complex and evolving environments.
Technical Proficiencies
SAS 9.4 (SAS/ Base, Proc SQL, SAS Makro, SAS Graph, ODS SAS Data Integration Studio, SAS Enterprise Guide) | SAS
Visual Analytics Viya |SAP Business Objects WebI |Tableau |Automic/ UC4 |IBM SPSS| Python| Microsoft Office Suite
|Git |Subversion |ESRI ArcGIS 10 |MS SQL Server 2012 (SSIS, SSAS, SSRS) |MS T-SQL |C# |MS Visual Studio |ERWin
|Unity
Career Experience
Basler Versicherungen, Bad Homburg, Germany
SAS Expert 02/2019 - Present
Enrich client-side experience as well as enhance overall functionality and performance by developing software solutions in co-ordination with multi-faceted design teams. Drive data extraction, evaluation, as well as retrieval and indexing by identifying, designing, and deploying scalable applications. Deliver insight on computer programming to project team members by serving as subject matter expert. Correct faults or improve performance by maintaining current application, while designing and delivering new applications. Leveraged Automic Automation to develop and schedule SAS DI Studio
ETL Jobs.
? Rectified coding errors and optimised overall performance by amending prevailing SAS Macros.
? Evaluated historization process for new SAS data warehouse and setting the guidelines for new data warehouse.
Finanz Informatik GmbH & Co KG, Frankfurt am Main, Germany
SAS Expert 08/2018 ? 01/2019
Owned control over development of SAS Base Code, SAS Macros under Z/OS. Enabled fulfilment of client requirements
for improved functionality, scalability, and performance by designing and creating robust solutions through steering of
collaborative efforts with software development and testing team members. Track record of application development
project status, new project proposals, and software-related technical issues by co-ordinating with internal customers on
regular basis. Supported software creation process by streamlining development workflows through roll out of Jira ticket
management.
? Slashed operating costs by migrating SAS Jobs from Z/OS to Unix
ING Germany, Frankfurt am Main, Germany
Business Analyst/SAS Consultant 2017-07 - 2018-07
Captured more information about risk management objectives and performance measures by creating scorecards for
risk management in the field of construction loans. Co-ordinated entire facets involved in development of SAS Base
Code, SAS Macros, and automated SAS reports. Gathered all technical information needed to access the data by
developing data sources and reports with SAP Business Objects WebI. Drove data trends assessment and
forecasts/data evaluation by creating Tableau reports for different stakeholders.
? Decreased licensing costs by swapping proprietary SAS scheduling Tool with standard software Automic.
SaarLB, Saarbruecken, Germany
IT Specialist2015-07 - 2017-06Contributed to data management by leading SAS development initiative as subject matter expert and primary point-ofcontact for project management staff. Monitored and managed jobs and workflows to support critical business
requirements by assessing and deploying new scheduling tool Jams Scheduler. Delivered project tasks quickly, efficiently, and accurately by communicating computer programming subject matter knowledge to project team members. Optimised operational efficiency by designing, developing, and testing systems through co-ordination with
product management.
? Enhanced storage capability of large amounts of data by redesigning new SAS data warehouse.
Finanz Informatik Solutions Plus GmbH, Frankfurt am Main, Germany
Software Engineer05/2014 - 06/2015Drove cleansing and validation of information through data Integration by effective utilisation of SAS Base, SAS Macro, SAS Data Integration Studio. Tracked performance, identified trends, analysed data, and aligned performance to overall
goals by deploying new reporting system by leveraging Microsoft SQL Server, MS SSIS, SSAS, SSRS.
? Pitched and implemented Microsoft SQL Server based reporting solution for local bank.
? Reduced operating costs and improved functionality by revamping, modularising, and updating old code bases to modern development standards.
Additional Experience
Corporate Tax Data Analyst
Destatis, Wiesbaden, Germany
Healthcare Data Analyst
KV Rheinland-Pfalz, Mainz, Germany
Education
Master of Arts: Political Science, German, Sociology
University of Trier - Trier, Germany
Degree Type in Political Science
Karlstad University - Karlstad, Sweden
Professional Training
SAS Programming 1 ? 3
SAS Macro 1 & 2
SAS Advanced ODS
SAS Data Integration Studio 1 & 2
SAS Proc SQL 1 + 2
SAS Statistics I: Introduction to ANOVA, Regression, and Logistic Regression
Designing, Tuning, and Maintaining SAS OLAP Cubes
SAP BO Web Intelligence 1 & 2
Automic/ UC4 Design 1 & 2
Automic/ UC4 Script 1
The complete C# Masterclass
Complete Python programming Python Basics to Advanced Python
erwin Data Modeler
Certifications
SAS Certified Specialist: Base Programming Using SAS 9.4
SAS Certified Professional: Advanced Programming Using SAS 9.4
Languages
German, Excellent
English, Excellent
Japanese, Good
2005 - 2006
Auslandssemester mit Studium der Politikwissenschaft in Schweden
Karlstad University
07/1992 ? 06/2001:
Abitur (Allgem. Hochschulreife)
Albert Schweitzer Gymnasium Dillingen
Qualifikationen und Zertifikate
Kenntnisse
07/2022 - heute
Freiberuflicher SAS- und BI-Experte mit Scrum-Projekten
bei der LBS SüdReporting für Baufinanzierung/ Automatisierung
Reporting MS SQL Server von SSIS über SSAS bis SSRS
[Name auf Anfrage]
Senior SAS Developer Saarbrücken, DE ? [Rufnummer auf Anfrage]
[E-Mail-Adresse auf Anfrage]
Tech savvy and highly analytical professional with versatile experience in various facets of statistical analysis, IT support, and software engineering. Credible success improving overall functionality and performance by developing and deploying software solutions.
Proven track record of creating scalable application, correcting coding errors, resolving technical
issues, streamlining development workflows, implementing reporting systems, driving data integration, and improving customer satisfaction.
Adept at managing and maintaining databases containing large quantities of information. Skilled
at developing and enhancing existing reports and data interfaces using SAS. Expert at creating automated regional reports by using ESRI ArcGIS. Ability to analyse data and statistics to find market trends, discover demographic breakdowns, and locate other relevant business information. Excel at co-ordinating with high-performance teams at all levels to achieve established goals across complex and evolving environments.
Technical Proficiencies
SAS 9.4 (SAS/ Base, Proc SQL, SAS Makro, SAS Graph, ODS SAS Data Integration Studio, SAS Enterprise Guide) | SAS
Visual Analytics Viya |SAP Business Objects WebI |Tableau |Automic/ UC4 |IBM SPSS| Python| Microsoft Office Suite
|Git |Subversion |ESRI ArcGIS 10 |MS SQL Server 2012 (SSIS, SSAS, SSRS) |MS T-SQL |C# |MS Visual Studio |ERWin
|Unity
Career Experience
Basler Versicherungen, Bad Homburg, Germany
SAS Expert 02/2019 - Present
Enrich client-side experience as well as enhance overall functionality and performance by developing software solutions in co-ordination with multi-faceted design teams. Drive data extraction, evaluation, as well as retrieval and indexing by identifying, designing, and deploying scalable applications. Deliver insight on computer programming to project team members by serving as subject matter expert. Correct faults or improve performance by maintaining current application, while designing and delivering new applications. Leveraged Automic Automation to develop and schedule SAS DI Studio
ETL Jobs.
? Rectified coding errors and optimised overall performance by amending prevailing SAS Macros.
? Evaluated historization process for new SAS data warehouse and setting the guidelines for new data warehouse.
Finanz Informatik GmbH & Co KG, Frankfurt am Main, Germany
SAS Expert 08/2018 ? 01/2019
Owned control over development of SAS Base Code, SAS Macros under Z/OS. Enabled fulfilment of client requirements
for improved functionality, scalability, and performance by designing and creating robust solutions through steering of
collaborative efforts with software development and testing team members. Track record of application development
project status, new project proposals, and software-related technical issues by co-ordinating with internal customers on
regular basis. Supported software creation process by streamlining development workflows through roll out of Jira ticket
management.
? Slashed operating costs by migrating SAS Jobs from Z/OS to Unix
ING Germany, Frankfurt am Main, Germany
Business Analyst/SAS Consultant 2017-07 - 2018-07
Captured more information about risk management objectives and performance measures by creating scorecards for
risk management in the field of construction loans. Co-ordinated entire facets involved in development of SAS Base
Code, SAS Macros, and automated SAS reports. Gathered all technical information needed to access the data by
developing data sources and reports with SAP Business Objects WebI. Drove data trends assessment and
forecasts/data evaluation by creating Tableau reports for different stakeholders.
? Decreased licensing costs by swapping proprietary SAS scheduling Tool with standard software Automic.
SaarLB, Saarbruecken, Germany
IT Specialist2015-07 - 2017-06Contributed to data management by leading SAS development initiative as subject matter expert and primary point-ofcontact for project management staff. Monitored and managed jobs and workflows to support critical business
requirements by assessing and deploying new scheduling tool Jams Scheduler. Delivered project tasks quickly, efficiently, and accurately by communicating computer programming subject matter knowledge to project team members. Optimised operational efficiency by designing, developing, and testing systems through co-ordination with
product management.
? Enhanced storage capability of large amounts of data by redesigning new SAS data warehouse.
Finanz Informatik Solutions Plus GmbH, Frankfurt am Main, Germany
Software Engineer05/2014 - 06/2015Drove cleansing and validation of information through data Integration by effective utilisation of SAS Base, SAS Macro, SAS Data Integration Studio. Tracked performance, identified trends, analysed data, and aligned performance to overall
goals by deploying new reporting system by leveraging Microsoft SQL Server, MS SSIS, SSAS, SSRS.
? Pitched and implemented Microsoft SQL Server based reporting solution for local bank.
? Reduced operating costs and improved functionality by revamping, modularising, and updating old code bases to modern development standards.
Additional Experience
Corporate Tax Data Analyst
Destatis, Wiesbaden, Germany
Healthcare Data Analyst
KV Rheinland-Pfalz, Mainz, Germany
Education
Master of Arts: Political Science, German, Sociology
University of Trier - Trier, Germany
Degree Type in Political Science
Karlstad University - Karlstad, Sweden
Professional Training
SAS Programming 1 ? 3
SAS Macro 1 & 2
SAS Advanced ODS
SAS Data Integration Studio 1 & 2
SAS Proc SQL 1 + 2
SAS Statistics I: Introduction to ANOVA, Regression, and Logistic Regression
Designing, Tuning, and Maintaining SAS OLAP Cubes
SAP BO Web Intelligence 1 & 2
Automic/ UC4 Design 1 & 2
Automic/ UC4 Script 1
The complete C# Masterclass
Complete Python programming Python Basics to Advanced Python
erwin Data Modeler
Certifications
SAS Certified Specialist: Base Programming Using SAS 9.4
SAS Certified Professional: Advanced Programming Using SAS 9.4
Languages
German, Excellent
English, Excellent
Japanese, Good
2005 - 2006
Auslandssemester mit Studium der Politikwissenschaft in Schweden
Karlstad University
07/1992 ? 06/2001:
Abitur (Allgem. Hochschulreife)
Albert Schweitzer Gymnasium Dillingen
Qualifikationen und Zertifikate
Kenntnisse
07/2022 - heute
Freiberuflicher SAS- und BI-Experte mit Scrum-Projekten
bei der LBS Süd