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

Register now | Login

You are here: Freelancers » Werner Schröer

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

Show map

available

Hourly-/Daily rates: 80.00 €/hour
depends on location

Other:

Last update: 16.11.2011 17:29

.NET CRM Datawarehouse Database development Reporting

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

Contact freelancer

Name: *		Company: *
Email address*:		Phone:
Your website:
ZIP & City*		Country*:

*Subject:**

*Inquiry:**
Security code: *
I accept your conditions: (You agree that you do not send any spam messages to the freelancer, see § 4.8 our terms of use. There are no fees or contracts.)