Oliver Pitzius
Freelance SAS Expert
Experience
Freelance SAS Expert
Freelance SAS Expert for different insurance companies
- Migrating SAS Stored Processes from Z/OS SAS database to a new DB2-datawarehouse for Versicherungskammer Bayern in Munich to secure financial controlling and reporting.
- Building a generic reporting system in SAS DI Studio using SAS ODS to replace IBM AS/400 reporting to reduce costs for maintenance and development for CarGarantie Insurance in Freiburg.
- Providing insights through newly designed SAS Visual Analytics reports for Wolfgang Denzel Auto AG car dealership in Vienna.
SAS Expert
Basler Versicherungen
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.
- 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.
SAS Expert
Finanz Informatik GmbH & Co KG
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.
Business Analyst/SAS Consultant
ING Germany
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.
IT Specialist
SaarLB
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 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.
Software Engineer
Finanz Informatik Solutions Plus GmbH
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.
Corporate Tax Data Analyst
Destatis
Healthcare Data Analyst
KV Rheinland-Pfalz
Industries Experience
See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.
Experienced in Insurance (7 years), Banking and Finance (4.5 years), Automotive (3.5 years), and Information Technology (1.5 years).
Business Areas Experience
The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.
Experienced in Business Intelligence (11 years), Information Technology (7 years), Finance (4.5 years), and Project Management (2 years).
Summary
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.
Skills
- Sas 9.4 And Viya (Sas/ Base, Proc Sql, Sas Makro, Sas Graph, Ods Sas Data Integration Studio, Sas Enterprise Guide, Sas Studio Flows)
- Sas Visual Analytics Viya
- Sas Viya Administration
- Microsoft Powerbi
- 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
Languages
Education
Karlstad University
Degree Type in Political Science · Political Science · Karlstad, Sweden
University of Trier
Master of Arts, Political Science, German, Sociology · Political Science, German, Sociology · Trier, Germany
Certifications & licenses
SAS Certified Professional: Advanced Programming Using SAS 9.4
SAS Certified Specialist: Base Programming Using SAS 9.4
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Oliver based?
What languages does Oliver speak?
How many years of experience does Oliver have?
What roles would Oliver be best suited for?
What is Oliver's latest experience?
What companies has Oliver worked for in recent years?
Which industries is Oliver most experienced in?
Which business areas is Oliver most experienced in?
Which industries has Oliver worked in recently?
Which business areas has Oliver worked in recently?
What is Oliver's education?
Does Oliver have any certificates?
What is the availability of Oliver?
What is the rate of Oliver?
How to hire Oliver?
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Freelance SAS Expert
Nearby freelancers
Professionals working in or nearby Saarbrücken, Germany
