About us - IB Pastor
Your expert for IT und Business Intelligence
Ingenieurbüro Pastor
meine
Main menu:
About us
About us
We are IT-experts
with much experience in the IT-area. We offer broad knowledge in various areas of
software programming and communication technology, which we acquired from many
years of dedicated and hard work. Whether you want the implementation of a
large scale
project or other kinds of projects, with us the project will be carried out
properly and successfully.
References
Intel Mobile Communications GmbH; Project ESIB Business Intelligence solutions. 2015-2016
Operation, maintenance, development and testing of ETL (PL/SQL) for the data of chip-testers, product verification, handling of problem tickets and calculation of costs.
Consolidation and aggregation of data for BI-analysis and reporting. SQL Performance Tuning. Design and implementation of new reports with QlikView and Business Objects Web Intelligence (Webl).
Software: Oracle, SQL, PL/SQL, MS SQL, QlikView 11, 10, Nprinting, SAP BO 4.1, Oracle SQL Developer, PL/SQL Developer, MS SQL Server Management Studio, Subversion
Operation, maintenance, development and testing of ETL (PL/SQL) for the data of chip-testers, product verification, handling of problem tickets and calculation of costs.
Consolidation and aggregation of data for BI-analysis and reporting. SQL Performance Tuning. Design and implementation of new reports with QlikView and Business Objects Web Intelligence (Webl).
Software: Oracle, SQL, PL/SQL, MS SQL, QlikView 11, 10, Nprinting, SAP BO 4.1, Oracle SQL Developer, PL/SQL Developer, MS SQL Server Management Studio, Subversion
Staufen AG, management consultancy, 2012- 2015
Development and the upkeep of a target agreement system for more categories of advisors. Analysis of company specific requests and systems. Development of database-structures (SQL Server) and modeling of data. Design and implementation of Web-applications (MS Silverlight). Concept of authority control, database audit and development of reports. Migration of data and the quality assurance. Further development and upkeep.
Software: SQL Server 2008, Windows Server 2008, IIS, TSQL, Visual Studio, C#
Development and the upkeep of a target agreement system for more categories of advisors. Analysis of company specific requests and systems. Development of database-structures (SQL Server) and modeling of data. Design and implementation of Web-applications (MS Silverlight). Concept of authority control, database audit and development of reports. Migration of data and the quality assurance. Further development and upkeep.
Software: SQL Server 2008, Windows Server 2008, IIS, TSQL, Visual Studio, C#
Sulzer GmbH, Project Caesar-info and Sicon at BMW AG, 2014
Analysis, maintenance and development of ETL for order processing, guarantee, accommodating behavior and service contracts with Informatica and PL/SQL.
Data pre-processing and aggregation for analysis (reporting). PL/SQL Performance Tuning. Design and Implementation of new reports with Business Objects Web Intelligence (Webl).
Software: Oracle, SQL, PL/SQL, Informatica Power Center Version 9, SAP BO 3.1, Toad, SQL-Developer
Analysis, maintenance and development of ETL for order processing, guarantee, accommodating behavior and service contracts with Informatica and PL/SQL.
Data pre-processing and aggregation for analysis (reporting). PL/SQL Performance Tuning. Design and Implementation of new reports with Business Objects Web Intelligence (Webl).
Software: Oracle, SQL, PL/SQL, Informatica Power Center Version 9, SAP BO 3.1, Toad, SQL-Developer
Sulzer GmbH, Project FMP, 2013- 2014
Design and Implementation of reporting for the process of problem-management (FMP) at MAN. Analysis of business request, communication with technical department, design of databases for reporting. Concept of ETL-Processes. Development of procedures for data editing and data aggregation.
Optimizing of execution time (Performance Tuning) of single procedures. Job scheduling.
Implementation of interactive reports with Business Objects Web Intelligence (Webl) and BO Universum. Testing of developed reports. Validation of Data, putting it into service and documentation.
Software: Oracle, SQL, PL/SQL, Stored Procedures, SAP BO 4.0, Toad, Eclipse, Subversion
Design and Implementation of reporting for the process of problem-management (FMP) at MAN. Analysis of business request, communication with technical department, design of databases for reporting. Concept of ETL-Processes. Development of procedures for data editing and data aggregation.
Optimizing of execution time (Performance Tuning) of single procedures. Job scheduling.
Implementation of interactive reports with Business Objects Web Intelligence (Webl) and BO Universum. Testing of developed reports. Validation of Data, putting it into service and documentation.
Software: Oracle, SQL, PL/SQL, Stored Procedures, SAP BO 4.0, Toad, Eclipse, Subversion
Sulzer GmbH, Project Quer-DWH, 2012- 2014
Maintenance and further development of a central DWH for the alliance of quality systems at the BMW AG. Analysis of new data sources, definition of the data exchange interfaces.
Development of ETL-job chain with Informatica Power Center. Testing of developed ETL-Workflows.
Upkeep and development of existing combine-DWHs. putting into service, operation and documentation.
Software: Oracle 11g, SQL, PL/SQL, SQL Developer, Informatica Power Center Version 9, Subversion
Maintenance and further development of a central DWH for the alliance of quality systems at the BMW AG. Analysis of new data sources, definition of the data exchange interfaces.
Development of ETL-job chain with Informatica Power Center. Testing of developed ETL-Workflows.
Upkeep and development of existing combine-DWHs. putting into service, operation and documentation.
Software: Oracle 11g, SQL, PL/SQL, SQL Developer, Informatica Power Center Version 9, Subversion
Telefonica Germany (O2), Telecommunications, DWH project, 2011- 2012
Analysis of business requests, analysis of mass-data (60 TB) and database design.
Design of ETL-process. Development of new ETLs and expansions of existing ETL-procedures.
Data processing for cognos reporting. Job control implementation. Performance Tuning of single ETL-processes. Testing of developed moduls (unit- and integration tests). Documentation and maintenance.
Software: Oracle, SQL, PL/SQL, Stored Procedures, Toad, Subversion, Fitnesse
Analysis of business requests, analysis of mass-data (60 TB) and database design.
Design of ETL-process. Development of new ETLs and expansions of existing ETL-procedures.
Data processing for cognos reporting. Job control implementation. Performance Tuning of single ETL-processes. Testing of developed moduls (unit- and integration tests). Documentation and maintenance.
Software: Oracle, SQL, PL/SQL, Stored Procedures, Toad, Subversion, Fitnesse
Ingenieurbüro Pastor
Software - Programming - Networks - Business Intelligence
