USA: Freelancer profile Werner Schröer from Moers, Consultant Datawarehouse, Teradata, DB2, Design, DBA, Tuning, SQL, SAGENT, DWH, Sunopsis, Oracle | Profiles from freelancers and companies
Werner Schröer, Consultant Datawarehouse, Teradata, Design, Administration, Tuning, SQL, DWH, BO, Sunopsis, .Net, C
Werner Schröer
Consultant Datawarehouse, Teradata, Design, Administration, Tuning, SQL, DWH, BO, Sunopsis, .Net, C
47447 Moers
available
Hourly-/Daily rates:
80.00 €/hour
depends on location
depends on location
Last update: 16.11.2011 17:29
Attachments
- none -
Language skills
german (first language)english (good)
Abilities, knowledge, experiences:
8 years experience in Teradata
Programming languages: VB, .Net, ASP, Clipper, SQL Windows, am, Centura
RDBMS : Teradata, Oracle, MS SQL-Server, ACCESS, DB2/400
OS : W2K, Windows XP, Win 9x, Win NT, OS/2, UNIX
Miscellaneous : SQL, Sunopsis, PL/SQL, Microstrategy, Crystal Reports, HTML, ASP, XML, ADO, OLE, API, MS-Project, ErWin, Office-Produkte
References:
Project overview (10 years period)
Status : Freelancer
Period : 07.2006-04.2009
Business : Telco
Project : Database administration Teradata
Control of Shell-Scripts
Control and debugging of Bteq-Scripts
Capacity planning
Stored Procedure programming
Makro Programming
User administration
Tuning
Upgrade planning (Software)
Development of VB.NET programms for Database administration
Software/Tools : Teradata, Teradata-Administrator, SQL-Assistent, Teradata Manager, VB.NET
Status : Freelancer
Period : 02.2006-07.2006
Business : Logistic
Project : Database design of a DB2/400 Staging area
Design Teradata-Datawarehouse (Staging area, Core-Warehouse
and DataMart)
Programming Loadjobs for daily, monthly and initial load with Sunopsis
Loading FlatFiles and DB2/400 DB-Tables
Data transfer from Teradata to DB2/400
Normalization of data in the Teradata Core-Warehouse
Denormalization and aggregation in the Teradata DataMart
Software/Tools : Teradata, DB2/400, Sunopsis, Teradata-Administrator, ErWin
Status : Freelancer
Period : 10.2004 – 02.2006
Business : Call Center
Project : Development of a webbased CRM application (In- and Outbound)
Database design
Campaign Control
Implementing VoIP-Functionality (SIP)
Implementation and configuration of a SIP Gateway and Proxy
Conception and development of complex reports
Software/Tools : MS SQL-Server, ASP.Net, Javascript, SQL, SIPPStar
Status : Freelancer
Period : 05.2005 – 10.2005
Business : Call Center
Project : Development of an application for Outbound with a dialer connection (Melita)
Conception and development of complex reports
Software/Tools : Oracle 8.1.6, VB 6.0, SQL, Melita Dialer
Status : employed Senior Consultant NCR GmbH
Period : 11.2003 – 01.2005
Business : Logistic
Project : Advice DWH-department on Reporting for „Global Mail“
Development of loadscripts
Report design
Design of complex SQL-Queries for reporting
Development of a Metada tool in Microsoft VB.NET, based on Teradata
Software/Tools : Teradata, Teradata Load tools, CrystalReports, EXCEL, VB.NET, ASP.NET
Status : employed Senior Consultant NCR GmbH
Period : 08.2003 – 11.2003
Business : Telco
Project : Advice for a Database consolidation and migration of an IBM Datawarehouse and some Oracle Data Marts to Teradata
Assistance of the salesteam
Analyse of the Datasources
Advice for the migration of Oracle PL/SQL Procedures to Teradata Stored Procedures, macros and Set-oriented SQL
Software/Tools : Teradata, Oracle, DB/2, PowerPoint, ErWin
Status : employed Senior Consultant NCR GmbH
Period : 04.2003
Business : Retail in Switzerland
Project : Advice for implementing an analytical CRM (Teradata CRM)
Technical support of the Project team during implementation period
Training of the Users
Software/Tools : Teradata, PowerPoint, ErWin
Status : employed Senior Consultant NCR GmbH
Period : 12.2001 – 12.2002
Business : Retail
Project : Technical lead for implementation of an analytical CRM (Teradata CRM)
Modules
· Segmentation
· Communication Manager
· Percentile Analysis
· Product / Affinity Analysis
· Market Basket Analysis
· Cross Segment Analysis
Responsibilities : Lead of a Project team
Research of customer needs
Advice customer departments (Customer loyality- and marketing department)
Guidance for reporting (Response, Lift and Segmentanalysis)
Design of the CRM Database (Teradata)
Definition of the Dataflow between the Datawarehouse and the operating Databases
Definition and sizing of the needed Hardware
User training and Admin training
Software/Tools : Teradata, ErWin, Teradata Ladetools, Excel, PowerPoint, MS-Project
Status : employed Senior Consultant NCR GmbH
Period : 10.2001 – 12.2001 and 09.2003-11-2003
Business : NCR Denmark
Project : Translation of the Application (GUI) and the documentation from English into German
Software/Tools : Teradata
Status : employed Senior Consultant NCR GmbH
Period : 06.2001 - 10.2001
Business : NCR Germany
Project : Feasibility study for transmitting Teradata CRM to Oracle Database
Translate Teradata macros and procedures to Oracle
Software/Tools : Teradata, Oracle, ErWin
Status : employed Software Development Manager SITEL GmbH
Period : 10.1998 – 06.2001
Business : Telco, Retail, Finance, Customer Care
Projekt : Analyse Customer needs
Databasedesign (Oracle 7.3 and 8.0.5)
Software development with VB 6.0
Inbound applications
Outbound applications
Backoffice applications
Fullfilment applications
Faxserver application
Software/Tools : VB 6.0, Oracle, MS-Project
Temporal and spatial availability.:
asap
8 years experience in Teradata
Programming languages: VB, .Net, ASP, Clipper, SQL Windows, am, Centura
RDBMS : Teradata, Oracle, MS SQL-Server, ACCESS, DB2/400
OS : W2K, Windows XP, Win 9x, Win NT, OS/2, UNIX
Miscellaneous : SQL, Sunopsis, PL/SQL, Microstrategy, Crystal Reports, HTML, ASP, XML, ADO, OLE, API, MS-Project, ErWin, Office-Produkte
References:
Project overview (10 years period)
Status : Freelancer
Period : 07.2006-04.2009
Business : Telco
Project : Database administration Teradata
Control of Shell-Scripts
Control and debugging of Bteq-Scripts
Capacity planning
Stored Procedure programming
Makro Programming
User administration
Tuning
Upgrade planning (Software)
Development of VB.NET programms for Database administration
Software/Tools : Teradata, Teradata-Administrator, SQL-Assistent, Teradata Manager, VB.NET
Status : Freelancer
Period : 02.2006-07.2006
Business : Logistic
Project : Database design of a DB2/400 Staging area
Design Teradata-Datawarehouse (Staging area, Core-Warehouse
and DataMart)
Programming Loadjobs for daily, monthly and initial load with Sunopsis
Loading FlatFiles and DB2/400 DB-Tables
Data transfer from Teradata to DB2/400
Normalization of data in the Teradata Core-Warehouse
Denormalization and aggregation in the Teradata DataMart
Software/Tools : Teradata, DB2/400, Sunopsis, Teradata-Administrator, ErWin
Status : Freelancer
Period : 10.2004 – 02.2006
Business : Call Center
Project : Development of a webbased CRM application (In- and Outbound)
Database design
Campaign Control
Implementing VoIP-Functionality (SIP)
Implementation and configuration of a SIP Gateway and Proxy
Conception and development of complex reports
Software/Tools : MS SQL-Server, ASP.Net, Javascript, SQL, SIPPStar
Status : Freelancer
Period : 05.2005 – 10.2005
Business : Call Center
Project : Development of an application for Outbound with a dialer connection (Melita)
Conception and development of complex reports
Software/Tools : Oracle 8.1.6, VB 6.0, SQL, Melita Dialer
Status : employed Senior Consultant NCR GmbH
Period : 11.2003 – 01.2005
Business : Logistic
Project : Advice DWH-department on Reporting for „Global Mail“
Development of loadscripts
Report design
Design of complex SQL-Queries for reporting
Development of a Metada tool in Microsoft VB.NET, based on Teradata
Software/Tools : Teradata, Teradata Load tools, CrystalReports, EXCEL, VB.NET, ASP.NET
Status : employed Senior Consultant NCR GmbH
Period : 08.2003 – 11.2003
Business : Telco
Project : Advice for a Database consolidation and migration of an IBM Datawarehouse and some Oracle Data Marts to Teradata
Assistance of the salesteam
Analyse of the Datasources
Advice for the migration of Oracle PL/SQL Procedures to Teradata Stored Procedures, macros and Set-oriented SQL
Software/Tools : Teradata, Oracle, DB/2, PowerPoint, ErWin
Status : employed Senior Consultant NCR GmbH
Period : 04.2003
Business : Retail in Switzerland
Project : Advice for implementing an analytical CRM (Teradata CRM)
Technical support of the Project team during implementation period
Training of the Users
Software/Tools : Teradata, PowerPoint, ErWin
Status : employed Senior Consultant NCR GmbH
Period : 12.2001 – 12.2002
Business : Retail
Project : Technical lead for implementation of an analytical CRM (Teradata CRM)
Modules
· Segmentation
· Communication Manager
· Percentile Analysis
· Product / Affinity Analysis
· Market Basket Analysis
· Cross Segment Analysis
Responsibilities : Lead of a Project team
Research of customer needs
Advice customer departments (Customer loyality- and marketing department)
Guidance for reporting (Response, Lift and Segmentanalysis)
Design of the CRM Database (Teradata)
Definition of the Dataflow between the Datawarehouse and the operating Databases
Definition and sizing of the needed Hardware
User training and Admin training
Software/Tools : Teradata, ErWin, Teradata Ladetools, Excel, PowerPoint, MS-Project
Status : employed Senior Consultant NCR GmbH
Period : 10.2001 – 12.2001 and 09.2003-11-2003
Business : NCR Denmark
Project : Translation of the Application (GUI) and the documentation from English into German
Software/Tools : Teradata
Status : employed Senior Consultant NCR GmbH
Period : 06.2001 - 10.2001
Business : NCR Germany
Project : Feasibility study for transmitting Teradata CRM to Oracle Database
Translate Teradata macros and procedures to Oracle
Software/Tools : Teradata, Oracle, ErWin
Status : employed Software Development Manager SITEL GmbH
Period : 10.1998 – 06.2001
Business : Telco, Retail, Finance, Customer Care
Projekt : Analyse Customer needs
Databasedesign (Oracle 7.3 and 8.0.5)
Software development with VB 6.0
Inbound applications
Outbound applications
Backoffice applications
Fullfilment applications
Faxserver application
Software/Tools : VB 6.0, Oracle, MS-Project
Temporal and spatial availability.:
asap
Register now
Profile Navigation
New profile
New Company Profiles
Statistic
The average daily rate of our Freelancer amounts to 458 €, the hourly rate 55 €.
New projects
RSS feeds
Read the newest projects in your favorite rss reader.
Deutschland | Österreich | Schweiz | United Kingdom | USA | Russian Federation | España | Italy | Ukraine | Liechtenstein | Hungary | New Zealand | France | Slovakia | India | United Arab Emirates
Theme related Websites :






































