SAP BASIS

PROFESSIONNAL EXPERIENCE
 
Mars 2012 – Present             Le Groupe Uni-Select
SAP BASIS
 

• Security support
• Role Updates with PFCG and SU24
• User Administration
• Auditing and trace report using SUIM and SM20.
• Interface connection setup de PI/XI
• Interfaces support for PI/XI, ECC, SCM et BI.
• CCMS Alert configuration setup for SAP Solution Manager.
• Deployment of Java stack for Integration builder PI/XI
• Parallel landscape support.
• Configuration of SAP mobile using for SCM
• Redo the configuration of transport système using parallele landscape.
• Redo interface of SCM and BW on PI/XI.
• Technical support of transport système Java stack system.

 
Software ECC6 EHP5, SAP PI/XI, SAP SCM, WIN/NT, DB6, SAP BW NETWEAVER 701
               SAP Solution Manager.
Hardware IBM Server AIX, SAN
 
Feb 10-Mars 2012                    ArcelorMittal Montreal
SAP BASIS
 

• Configuration and security support using SAP transactions PFCG, SU01, SU10, SU24
• Create and configuration Iview, Role on Portal using User Management.
• Auditing and trace report using SUIM and SM20.
• Segregation on access analysis report using CSI Tools.
• Security & Basis Support on SAP ECC and BW
• Support PI/XI web interface in file transfer project for BI
• Implementation and Support of SAP Netweaver 7.0.1 (Portal)
• Create and setup portal in Java stack
• Create Pre-calculation Server for BI Broadcasting.
• Create and configuration Knowledge Management an external file system NFS with PI/XI server
• Side effect study for business extension on EHP4 compare with ECC 6 Sp17.
• Update ECC6 with enhance package 4 (EHP4) & Upgrade the Security using SU25
• Support on Panaya application in EHP4 project
• Support on Java stack system
• Update ECC6 with enhance package 5 (EHP5) & Upgrade the Security using SU25

 
Software ECC6 EHP5, SAP PI/XI, SAP NETWEAVER 7, Unix AIX 5.1, Oracle 10.2.0.4
Hardware IBM P690 on partition.
 
 
 
 
May 08 – Feb 10                  Boutique Jacob Inc.
SAP BASIS
 

• Setup CUA for portal user’s access.
• Configuration and security support using PFCG (SU01, SU10, SU24).
• Auditing report using SUIM and SM20.
• Manipulation of users access on Java Stack NW using user management.
• Support on SAP R3 and BW
• Setup BW broadcasting pre-calculation BI.
• Support on Java stack system
• Support on post upgrade SAP ECC6 and BW 7
• Configuration of SAP Solution Manager E2E root cause diagnostic.
• Update Oracle Version 10.2.0.2
• Installed Stack on R3 system
• Setup and installation of interface application related with SAP
• Installed Support pack.
• Setup SAP GUI HTML
• Setup package build for SAP GUI implementation.
• DBA support for non-SAP database
• Installation of EHP (Enhancement Package) for SAP/R3 system

 
Software               Tivoli Storage Manager, Oracle V9i, 10i on Window SAP (ECC 6),
                             BW  NW 7,  Java Stack, NETWEAVER, VM Ware 3x, SAP Solution Mgr
Hardware              IBM X386 x64. SAN
 
 
April 08 – May 08           CGI - Groupe TVA
SAP BASIS

• Configuration Saprouter connection for SAP OSS
• Migration OSDB from Thru64 to Linus Redhat 5
• Documented the migration tasks
• Setup transport system
• Setup SAP interface RFC
• Reconfigured Unix parameters on target system

 
Software                Oracle V 9i and 10i on Thru64 SAP 4.6C on Kernel 4.6D and Linux Redhat 5,
                              SAP ECC 6.
Hardware                HP and IBM
 
 
Nov. 07-Feb. 08  ABB Canada Inc.
SAP BASIS/ARCHITECT
 

• Installation and configuration Saprouter server for SAP OSS connection
• Hardware sizing and design Landscape for SAP R3 and BW.
• Update Oracle version 9i.
• Update Oracle version 10.
• Setup and created a procedure for new printer using with Macro3 – Colombus Software.
• Created a refresh procedure for a system 24/7
• Setup a backup procedure using TSM (Tivoli Storage Manager – Flash backup)
• Setup a standby system on Oracle production system.
• Update TSM (Tivoli) client
• Installation of Stack (support pack) on R3, BW and SAP Solution Manager.
• Setup transport system and sap transport route.
• Setup Oracle client on application server.
• Setup script to upload user for GRC

 
Software                   Tivoli Storage Manager Client Version 5.2.3, AIX, Oracle V 9. SAP
                                 4.6C, Oracle 10, BW 7, NETWEAVER, SAP Solution Manager.
Hardware                  IBM P690, Sun Solaris, IBM Server Window NT.
 
Dec. 06 – Nov. 07            EDS Consultant – Molson-Coors
SAP BASIS

• Setup Saprouter server for SAP OSS connection.
• Installation and configuration Sap Sandbox for BW.
• Migration of DB for SAP/R3 from HP to SUN Solaris.
• Update Oracle version 9i.
• Update Oracle version 10.
• Create a procedure for printer creation.
• Create a procedure for database refresh.
• Configuration of TSM (Tivoli Storage Manager) for backup.
• Create a DR database using standby database for production instance.
• Update  TSM (Tivoli) client version.
• Stack (support pack) installation with SPAM and SAINT.
• Stack (support pack) installation for Sap Solution Manager.
• Re-configuration of STMS transport system.
• Create refresh client by remote client copy.
• Performance tuning of SAP and verification on SAN for space available.
• Software  TSM Client Version 5.2.3, HP-UX, Oracle V 9. SAP 4.6C, Oracle 10, BW 7. SSM. Hardware   HP 11.11, Sun Solaris, IBM Server Window NT.

 
 

Oct. 03 – Dec. 06     IBM Global Services
                                 Cirque du Soleil.
Responsibility         SAP BASIS/SECURITY
 

• Creation of securities procedure
• Role Implementation with Profile Generator (PFCG)
• User Maintenance SU01 & SU10
• Auditing report using SUIM and SM20.
• Configuration of Saprouter connection.
• Install and Configuration Sap Solution Manager.
• Install and configuration CCMS alert monitoring on Sap Solution Manager.
• Upgrade of Oracle version 9.
• Create a procedure data refresh on system 24/7
• Configuration backup/restore with  TSM (Tivoli Storage Manager)
• Participation on Disaster recovery project.
• Upgrade TSM (Tivoli) client

• Install Stack using SPAM et SAINT.
• Install Stack on Sap Solution Manager.
• Configuration transport. system
• Executing a remote client copy (multiple clients system)
• Upgrade Oracle client on application server.
• Performance tuning on SAP and configuration SAN storage system.

 
Software                   Tivoli Storage Manager Client Version 5.2.3, HP-UX, Oracle V 9. SAP
                                 640 (4.7 Ext1.1), SAP Solution Manager, BW 3.5/4
 
Hardware                  HP 11.11, IBM Server Window NT.
 
Sep 03 – Oct. 03      DMR Conseil.
 
Responsibility          SAP BASIS.
 

• Answer the proposal for DMR Consulting client about Support center of SAP R/3 version 4.7 extention 1,10.
• Using SAP Quick Sizing of SAP Version 4,7 extension set 1.10.
• Writing the report on proposal about delta between 4.6C and 4.7.
• Writing the report about SAP BASIS profile (his task).
• Sizing feature of Oracle database with SAP R/3 version 4.7.
• Planning time sheet for SAP R/3 version 4.7 installation.
• Planning time sheet and impact for upgrade version from 4.6C to 4.7.
• Estimate cost about the impact for upgrade version 4.6C to 4.7.

 
Softwares                   Window 2000 and Sun Solaris.
Equipments                Sun and DELL.
 
 
 
 
April 03 – July 03     MICROCELL
 
Responsibility              DBA Oracle.
 

• Refresh test database from production.
• Up grade version 8.1.7 to 9i
• Create info cube for BW Datamart.
• Security reconfiguration of Datamart BW.
• Create from scratch new server and BW database.
• Technical support for BW.

 
Software:                    OS Solaris, Window NT, Oracle version 8 et 9. Datamart, Seagate.
                                   Perl version 5, SQL Server 2000.
 
Equipments :              SUN, Window 2000., SAN.
 
 
Jan 2003 – Mars 03  IBM Support Center – Ontario Division.
Hydro One.
Hydro-Ottawa.
 
Responsibility             SAP BASIS and DBA Oracle on JDE One World XE.
 

• Database performance turning for SAP R/3 version 4.6C.
• Technical support for Go live for JDE One World XE system.
• Recommendation on database maintenances.
• Documented the maintenances procedure for oracle database under JDE.
• Recommended backup and recover procedure on IBM SAN track.
• Recommended and documented technologies study for 24/7 system.

 
Software                     Toad, Entreprise manager, SpotLight on Oracle, Oracle version 8.1.7.
 
Hardware                   SUN Solaris, DELL, Compaqc.
 
December 2002 – Jan 03     IBM Support Center West Division (In Site Support).
Alberta Petroleum
Ivannhoé Cambridge Division Calgary.
 
 
Responsibility          SAP BASIS/DBA SQLServer on JDE One World XE.
 

• Performance tuning for SAP R/3.
• Rebuild primary keys for SQLServer version 7.
• Planning performance test for SAP R/3
• Rebuild backup and restore plan on SAN track.
• Planified technologies study for JDE Oneworld XE.

 
SOFTWARE                         SQL Server V7, Omniback, Window 2000, Oracle version 8.1.7.
 
EQUIPMENT                                   COMPACQ Proliant, HP and IBM.
 
 
September 2002-Dec 02      IBM Support Center.
 
 
Responsibility                     SAP BASIS and DBA support for clients of IBM.
 

• Performance tuning of oracle database.
• Create authorization and profile.
• Reconfiguration of transport system.
• Installation of LCP and support pack.
• Support for test before go live.
• Documentation and forming junior Basis.
• Update sap kernel and oracle version.

 
 
Equipment                                 HP, Sun Solaris and NT.
 
 
February 2001-Sep 02         Hydro Québec.
 
Responsibility                        SAP BASIS B2B (Business to business).
 

• Implementation SAP B2B/I2 solution using Aspect catalogue management tools.
• Scheduled and Updated catalogue version.
• Installation and Performance tuning CMT (catalogue management) Using Spotlight Center.
• Updated SAP version 3.1I to 4.6C.
• Support B2B and WEB Server, knowledge of Symmetric web design and ICC.
• Created a refresh procedure for B2B to synchronize with CMT.

 
Software                     Oracle version 8.1.6 et SAP/R3 version 3.1 et 4.6C. BW 3.5/4, SQL Server
 
Equipment                  SUN et HP.
 
 
April 1999- Feb 2001           St- Laurent Cement. (mandat by Groupe DRI)
 
 
Responsibility                        SAP BASIS and Database administrator
 

• Created profiles and prepare for activity group of R3 and BW.
• Working on transport between R3 system
• Maintain (performance tuning) and support of SAP R3 and BW.
• Support pack and LCP installation.
• Update version 3.1H to 4.6B.

 
Software                              SAP R3 3.1H and 4.6B, Oracle on Unix, BW 3.4/4
 
Equipment                              Digital and NT.
 
October 1998 -Apr. 99         Le Groupe Forzani Ltée. (mandat by Groupe Conseil C.D.L)
 
RESPONSABILITY                          Database Administrator J.D.EDWARDS system.
 

• Configured a database depending on One World architecture.
• Optimized the performance of Oracle database.
• Training for user of administrator level on One World and Oracle.
• Developed backup procedure for One world and Oracle.
• Technical support for a go live.
• Installation of service pack.
• Installation One World version 7.3.2 for LE CHATEAU with ORACLE version 7.3.2.4 on HP-UX (Unix)
• Installation One World et SP11 for CANADA MUSEUM of NATURE.

 
SOFTWARE                          Oracle version 7.3 et One World version 7.3.2.1 on Window NT., SQL Server version 6.5 on Window NT and Oracle 7.3.2.4 on Unix, DB2.
 
EQUIPMENT                                   AVIION from Data General, HP9000 and Compaq Proliant 3000,
                                               AS400.
 
Mai 1998-Oct. 98                  Videotron
 
RESPONSABILITY             Database Administrator for SAP basis group.
 

• Configured database depending on architecture (SAP/R3).
• Data modelling and participated for development of architecture of data conversion.
• Installed Oracle and created a database for SAP.
• Technical support for testing and go live.
• Maintenance system with DB2.
• Maintenance database for SAP/R3 (SAPDBA utility)
• Worked with CCMS in SAP/R3.

 
SOFTWARE                         Oracle version 7.3 and SAP/R3 and DB2, SOLARIS 2.5, VMS, AIX.
 
EQUIPMENT                                   SUN, RISK 6000, VAX.
 
April 1998                             ISM GROUP branch of IBM
 
RESPONSABILITY             Database Administrator for National Bank of Canada.
 

• Sizing and configured of two warehouse database.
• Installed Oracle software.
• Created a database and data modelling with warehouse method.
• Architecture designed of warehouse system.

SOFTWARE                         Oracle version 8 et EASYTRIEVE, AIX, DB2.
EQUIPMENT                                   RISK 6000 of IBM, AS400.