ETL: Extraction, transformation and loading of data with SQL Server SSIS
Design and management of OLAP cubes with SQL server SSAS,
Data analysis and Reporting with PowerBI, QlikView and QlikSense and Serveur SSRS,
Big Data, Hadoop, Map Reduce, Mongo DB, Machine Learning and Data Mining.
- Technical analysis and architecture of the target platform
- Architecture and user support in the development of applications of decision support.
- Workload estimation, specifications, planning
- Project Management & Change Management
- Coordination of IT and business teams
- Installation, configuration, maintenance and monitoring SAP Business Intelligence
- Implementation Content management plan, security model, levels security, Active Directory
Single Sign On Integration
- User security and access rights
- Synchronization Load Data and the Scheduler Reports
- Recruitment and selection and Training of new colleges
- Analyses of structural needs and dysfunctions and their problem-solving
- Developing, implementation, maintaining and distributing Universes.
Activities
Migration of BI4.1 to BI4.2 SP8
Feasibility study
Analysis of the existing environment
Workload estimation, specifications, planning
Implementation
Upgrade CMS System Database from Oracle 11 to DBaaS
- Technical analysis and architecture of the target platform
- Architecture and user support in the development of applications of decision support.
- Workload estimation, specifications, planning
- Project Management & Change Management
- Coordination of IT and business teams
- Installation, configuration, maintenance and monitoring SAP Business Intelligence,
Information Steward
- Implementation Content management plan, security model, levels security, Active Directory
Single Sign On Integration
- Installation of SAP Business Intelligence 4.2, Objective : Migration 2000 reports, 100
Publications, 240 univers, 4500 users :
- User security and access rights
- Synchronization Load Data and the Scheduler Reports
- Migration of existing reports
- Testing, Training of IT & business team
- Recruitment and selection and Training of new colleges
- Analyses of structural needs and dysfunctions and their problem-solving
- Setting deadlines, follow-up, deontology and achievement of objectives
- Developing, implementation, maintaining and distributing Universes
- Creation Desktop Intelligence and Web Intelligence report on Business Objects
PROJECT Installation and Migration 4.2 SP6
Activities
Migration of BI4.2 to BI4.2 SP6
Feasibility study
Analysis of the existing environment
Workload estimation, specifications, planning
Implementation
Project Management & Change Management
Coordination of IT and business teams
Installation BI4.2
Migration of existing reports, universes and groups
Configuration service BI
BI Level 3 Support
- Installation, configuration and maintenance, platforms optimization in terms of
performances and stability SAP Business Intelligence and SAP Data Services 4.2.
- Management of BI4, DS servers and BI applications on Windows and on Linux OS.
- Security Level Management Business Intelligence.
- Responsibilities include designing, implementing, and maintaining the database system
establishing policies and procedures pertaining to the management, security, maintenance,
and use of the database management system.
- Responsible to develop and maintain the databases of the organization
- Build up the database architecture and models
- Design the schemes, permissions and tables for database as appropriate for its use
- Install, configure and upgrade the server to suit the database needs
- Design automated systems to mine information and make reports
- Provide inputs for developing newer versions of databases customized to peculiar need
- Include objects in database like tables, views, functions, triggers, etc.
- Installation, configuration, maintenance and monitoring SAP Business Intelligence, SAP
Data Services, Information Steward, Lifecycle Management and SAS.
- Implementation Content management plan, security model, levels security, Active
Directory Single Sign On Integration
- Installation of SAP Business Intelligence 4.1
- Objective : Migration 2000 reports, 100 Publications, 240 univers, 1800 users :
- Technical analysis and architecture
- Installation of the software and Administration Console
- Installation of the products 360°
- User security and access rights
- Developing, implementation, maintaining and distributing Universes
- Creation Desktop Intelligence and Web Intelligence report on Business Objects
- Create data model according to user's request.
- Architecture and user support in the development of applications of decision support.
- Database Administrator Oracle.
- Migration of BO 6.5 to BO XI v3.1
- Feasibility study
- Analysis of the existing environment : source data, reports, dashboards
- New business requirements
- Architecture of the target platform
- Workload estimation, specifications, planning
- Project Management & Change Management
- Security and Administration
- Installation of BO XI 3.1 server and clients, LiveOffice 12.1
- Automated deployment package
- Migration of existing reports
- Testing, Training of IT & business team
- Recruitment and selection and Training of new colleges
- Analyses of structural needs and dysfunctions and their problem-solving
- Setting deadlines, follow-up, deontology and achievement of objectives
I was part of the Infrastructure BI team. I was responsible for the installation of applications
in Acceptance and Production environments. The applications were functional BS200
applications where the technology was COBOL. I also managed and maintained Job Control
Language (JCL). Apart from the installation, maintenance of the applications, resolution of
problems, incident management, analysis of issues, performance tuning and giving support to
the development team when needed, the role also involved documentation of the process,
best practices, etc. Working in an operational environment meant that I had to be flexible
and stress resistant with continuous improvement in mind.
PROJECT Installation and Migration 4.2 SP8
Activities
Migration of BI4.1 to BI4.2 SP8
Feasibility study
Analysis of the existing environment
Workload estimation, specifications, planning
Implementation
Project Management & Change Management
Coordination of IT and business teams
Installation BI4.2
Migration of existing reports, universes and groups
Configuration service BI
BI Level 3 Support