Sas Data Analyst
Resume:
Oliver Pitzius
Senior SAS Developer
Saarbrücken, DE • +496*********
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 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 02/2019 - Present SAS Expert
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 08/2018 – 01/2019 SAS Expert
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 2017-07 - 2018-07 Business Analyst/SAS Consultant
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 2015-07 - 2017-06
IT Specialist
Contributed to data management by leading SAS development initiative as subject matter expert and primary point-of- contact 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 P a g e 2 2
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 05/2014 - 06/2015 Software Engineer
Drove 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
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
Contact this candidate