Project Management, Data Analysis, Business Intelligence, Data Engineering
Aktualisiert am 24.09.2024
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 01.10.2024
Verfügbar zu: 80%
davon vor Ort: 60%
SQL
Data Analyst
Business Intelligence
MS Power BI
Microsoft Access
VBA
MS SQL Server
SAP BusinessObjects
German
Muttersprache
English
Verhandlungssicher
French
Grundkenntnisse
Spanish
Grundkenntnisse

Einsatzorte

Einsatzorte

Kreuzlingen (+75km)
Schweiz
möglich

Projekte

Projekte

1 year 9 months
2023-01 - 2024-09

Project Management

Senior Project Manager (Corporate Legal / IT)
Senior Project Manager (Corporate Legal / IT)
  • Project Management (e.g. contract process optimization rollout)
  • Contract database support, enhancement and issue resolution
  • Data & business analysis, reports and dashboards in Power BI
  • created and rolled out Microsoft Copilot (PVA) chatbot
  • End-to-end Robotic Process Automation e.g. to bulk collect signatures
  • Implemented a Power Apps solution to automate signature requests
Takeda Pharmaceuticals Internat. AG, Zurich, Switzerland
10 years 4 months
2012-09 - 2022-12

System management

Project Manager (Corporate Legal / IT)
Project Manager (Corporate Legal / IT)
  • System management, database administration and enhancement for the legal Contract Management Database (Contiki, now Coupa)
  • Training and user support, system documentation etc.
  • Data analysis and dashboards (SAP Business Objects / Power BI etc.)
  • Legal Sharepoint site administration and other special project support
Takeda GmbH, Constance, Germany
3 years 8 months
2009-01 - 2012-08

Operative management of business critical Oracle + SQL Server applications

Business Information Management Specialist (IT Department)
Business Information Management Specialist (IT Department)
  • Operative management of business critical Oracle + SQL Server applications, such as the adverse event reporting platform/database
  • Implemented SAP Business Objects BI solutions, e.g. for ticketing system
  • Managed IS/IT change projects according to user requirements
  • 2nd level helpdesk support and incident/problem resolution
Nycomed (a Takeda Company), Constance, Germany
5 years 3 months
2003-08 - 2008-10

Completed end to end project to integrate Home Loans legacy reporting

  • Completed end to end project to integrate Home Loans legacy reporting (Access, Excel) into SAP Business Objects BI Platform.
  • Data scrubbing, ETL, BI architecture / universe layer design
  • Ad hoc, operational and management reporting, data analysis etc.


Role:

  • 09/2008 ? 10/2008: Business Strategy Analyst Lead AVP - JP Morgan Chase
  • 04/2006 ? 08/2008: Business Strategy Analyst Lead AVP
  • 01/2005 ? 12/2005: Business Data Analyst III
  • 09/2003 ? 12/2004: Business Data Analyst II - Washington Mutual Bank
  • 08/2003 ? 09/2003: Business Data Analyst - via Adecco temp agency

Washington Mutual Bank / JP Morgan Chase, Irvine, USA
3 months
2006-01 - 2006-03

Development of a data warehouse

Senior Credit Risk Analyst
Senior Credit Risk Analyst
  • Development of a data warehouse for mortgage portfolios
  • Import and preparation of portfolio data from various sources
  • Analysis for portfolio risk mitigation and damage prevention
Impac Mortgage Corp., Newport Beach, USA
4 months
2003-05 - 2003-08

Support

Special Events Project Support
Special Events Project Support
  • Support for the Disneyland Resort Special Events team (event database management, event planning, organization and execution support).
The Walt Disney Company, Anaheim, USA
1 year 4 months
2002-01 - 2003-04

Promotion and marketing material design

Marketing Assistant
Marketing Assistant
  • Promotion and marketing material design and trade fair organization
  • Converted all promotional materials to electronic format
  • Created digital interactive product catalog, leading to substantial savings
  • Published online media library to make marketing material, user guides and technical documentation instantly available
Teca-Print AG, CH-Thayngen, Switzerland
3 months
2001-10 - 2001-12

Analyzed customer requirements

eBusiness Intelligence Consultant ? Young Professional
eBusiness Intelligence Consultant ? Young Professional
  • Analyzed customer requirements and created custom built solutions for Microsoft SQL-Server and the SAP BW data warehouse
eNovation GmbH, Radolfzell, Germany
11 months
2000-07 - 2001-05

Managed daily, weekly and monthly performance reporting

Process and Measures Specialist
Process and Measures Specialist
  • Managed daily, weekly and monthly performance reporting for senior management
  • Developed Microsoft Access database to automate reporting data input, throughput and output
NTL, London (as of 2007: Virgin Media), Lewisham, UK
2 months
2000-05 - 2000-06

data consolidation and cleanup project

Temporary Assignment as an IT Consultant
Temporary Assignment as an IT Consultant
  • Completed a data consolidation and cleanup project for the launch of a new business intelligence platform
ThamesWater, Greenwich, UK
1 year 7 months
1998-10 - 2000-04

Implemented new pump export department

Sales Coordinator
Sales Coordinator
  • Implemented new pump export department in four months together with Sales Manager
  • Programmed Microsoft Access database to automate all export department paperwork such as price quotes, order confirmations, invoices and shipping documents end to end
Sykes Pumps International, Charlton (London), UK

Aus- und Weiterbildung

Aus- und Weiterbildung

3 years
1995-10 - 1998-09

Bachelor of Business Management

Diploma: Competitor Analysis, Berufsakademie VillingenSchwenningen, Germany
Diploma: Competitor Analysis
Berufsakademie VillingenSchwenningen, Germany
Majors: Marketing, Finance and Accounting

Kompetenzen

Kompetenzen

Top-Skills

SQL Data Analyst Business Intelligence MS Power BI Microsoft Access VBA MS SQL Server SAP BusinessObjects

Produkte / Standards / Erfahrungen / Methoden

PROFILE

Experienced data analyst, BI architect and project manager with a passion for streamlining and automating repetitive processes end-to-end


OTHER SKILLS

  • Result and value oriented project manager
  • Excellent communication skills
  • Very quick learner
  • Data analysis, business analysis
  • Dashboard and visuals design (operational, management etc.)
  • Keyboard typing speed > 70 wpm


TOOLS

  • Microsoft Office Power User
  • Visual Basic (VBA) Office and Windows Shell automation
  • Power Apps & Power Automate Web + Desktop citizen developer
  • MS Copilot (Power Virtual Agents) chat bot design
  • Sharepoint site admin/curator
  • SQL Server, Azure Data Studio
  • Power BI, Power Query, DAX
  • Advanced SQL (DDL, DML, T-SQL etc.)
  • Oracle Developer, PL/SQL, TOAD
  • Google Cloud Analytics (Looker, LookML etc.)
  • SAP Business Objects universe design, reports, dashboards, SAP Crystal Reports
  • Interactive learning content development (SCORM via Power Point iSpring Suite published on edcast and SAP Success Factors platform)

Einsatzorte

Einsatzorte

Kreuzlingen (+75km)
Schweiz
möglich

Projekte

Projekte

1 year 9 months
2023-01 - 2024-09

Project Management

Senior Project Manager (Corporate Legal / IT)
Senior Project Manager (Corporate Legal / IT)
  • Project Management (e.g. contract process optimization rollout)
  • Contract database support, enhancement and issue resolution
  • Data & business analysis, reports and dashboards in Power BI
  • created and rolled out Microsoft Copilot (PVA) chatbot
  • End-to-end Robotic Process Automation e.g. to bulk collect signatures
  • Implemented a Power Apps solution to automate signature requests
Takeda Pharmaceuticals Internat. AG, Zurich, Switzerland
10 years 4 months
2012-09 - 2022-12

System management

Project Manager (Corporate Legal / IT)
Project Manager (Corporate Legal / IT)
  • System management, database administration and enhancement for the legal Contract Management Database (Contiki, now Coupa)
  • Training and user support, system documentation etc.
  • Data analysis and dashboards (SAP Business Objects / Power BI etc.)
  • Legal Sharepoint site administration and other special project support
Takeda GmbH, Constance, Germany
3 years 8 months
2009-01 - 2012-08

Operative management of business critical Oracle + SQL Server applications

Business Information Management Specialist (IT Department)
Business Information Management Specialist (IT Department)
  • Operative management of business critical Oracle + SQL Server applications, such as the adverse event reporting platform/database
  • Implemented SAP Business Objects BI solutions, e.g. for ticketing system
  • Managed IS/IT change projects according to user requirements
  • 2nd level helpdesk support and incident/problem resolution
Nycomed (a Takeda Company), Constance, Germany
5 years 3 months
2003-08 - 2008-10

Completed end to end project to integrate Home Loans legacy reporting

  • Completed end to end project to integrate Home Loans legacy reporting (Access, Excel) into SAP Business Objects BI Platform.
  • Data scrubbing, ETL, BI architecture / universe layer design
  • Ad hoc, operational and management reporting, data analysis etc.


Role:

  • 09/2008 ? 10/2008: Business Strategy Analyst Lead AVP - JP Morgan Chase
  • 04/2006 ? 08/2008: Business Strategy Analyst Lead AVP
  • 01/2005 ? 12/2005: Business Data Analyst III
  • 09/2003 ? 12/2004: Business Data Analyst II - Washington Mutual Bank
  • 08/2003 ? 09/2003: Business Data Analyst - via Adecco temp agency

Washington Mutual Bank / JP Morgan Chase, Irvine, USA
3 months
2006-01 - 2006-03

Development of a data warehouse

Senior Credit Risk Analyst
Senior Credit Risk Analyst
  • Development of a data warehouse for mortgage portfolios
  • Import and preparation of portfolio data from various sources
  • Analysis for portfolio risk mitigation and damage prevention
Impac Mortgage Corp., Newport Beach, USA
4 months
2003-05 - 2003-08

Support

Special Events Project Support
Special Events Project Support
  • Support for the Disneyland Resort Special Events team (event database management, event planning, organization and execution support).
The Walt Disney Company, Anaheim, USA
1 year 4 months
2002-01 - 2003-04

Promotion and marketing material design

Marketing Assistant
Marketing Assistant
  • Promotion and marketing material design and trade fair organization
  • Converted all promotional materials to electronic format
  • Created digital interactive product catalog, leading to substantial savings
  • Published online media library to make marketing material, user guides and technical documentation instantly available
Teca-Print AG, CH-Thayngen, Switzerland
3 months
2001-10 - 2001-12

Analyzed customer requirements

eBusiness Intelligence Consultant ? Young Professional
eBusiness Intelligence Consultant ? Young Professional
  • Analyzed customer requirements and created custom built solutions for Microsoft SQL-Server and the SAP BW data warehouse
eNovation GmbH, Radolfzell, Germany
11 months
2000-07 - 2001-05

Managed daily, weekly and monthly performance reporting

Process and Measures Specialist
Process and Measures Specialist
  • Managed daily, weekly and monthly performance reporting for senior management
  • Developed Microsoft Access database to automate reporting data input, throughput and output
NTL, London (as of 2007: Virgin Media), Lewisham, UK
2 months
2000-05 - 2000-06

data consolidation and cleanup project

Temporary Assignment as an IT Consultant
Temporary Assignment as an IT Consultant
  • Completed a data consolidation and cleanup project for the launch of a new business intelligence platform
ThamesWater, Greenwich, UK
1 year 7 months
1998-10 - 2000-04

Implemented new pump export department

Sales Coordinator
Sales Coordinator
  • Implemented new pump export department in four months together with Sales Manager
  • Programmed Microsoft Access database to automate all export department paperwork such as price quotes, order confirmations, invoices and shipping documents end to end
Sykes Pumps International, Charlton (London), UK

Aus- und Weiterbildung

Aus- und Weiterbildung

3 years
1995-10 - 1998-09

Bachelor of Business Management

Diploma: Competitor Analysis, Berufsakademie VillingenSchwenningen, Germany
Diploma: Competitor Analysis
Berufsakademie VillingenSchwenningen, Germany
Majors: Marketing, Finance and Accounting

Kompetenzen

Kompetenzen

Top-Skills

SQL Data Analyst Business Intelligence MS Power BI Microsoft Access VBA MS SQL Server SAP BusinessObjects

Produkte / Standards / Erfahrungen / Methoden

PROFILE

Experienced data analyst, BI architect and project manager with a passion for streamlining and automating repetitive processes end-to-end


OTHER SKILLS

  • Result and value oriented project manager
  • Excellent communication skills
  • Very quick learner
  • Data analysis, business analysis
  • Dashboard and visuals design (operational, management etc.)
  • Keyboard typing speed > 70 wpm


TOOLS

  • Microsoft Office Power User
  • Visual Basic (VBA) Office and Windows Shell automation
  • Power Apps & Power Automate Web + Desktop citizen developer
  • MS Copilot (Power Virtual Agents) chat bot design
  • Sharepoint site admin/curator
  • SQL Server, Azure Data Studio
  • Power BI, Power Query, DAX
  • Advanced SQL (DDL, DML, T-SQL etc.)
  • Oracle Developer, PL/SQL, TOAD
  • Google Cloud Analytics (Looker, LookML etc.)
  • SAP Business Objects universe design, reports, dashboards, SAP Crystal Reports
  • Interactive learning content development (SCORM via Power Point iSpring Suite published on edcast and SAP Success Factors platform)

Vertrauen Sie auf Randstad

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.