Oliver Pitzius
SAS Expert
Experience
SAS Expert
Freelance
- 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. 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.
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.