Resume of Ashfaq Moghal
SUMMARY
Technology Consultant, In over 22 years supporting the technical environments of IT systems he has covered the Financial, Manufacturing, Packaging and Petroleum industries. After 3+ years as an Oracle Database Administrator and Application Developer, Ashfaq turned his attention to the SAP world. For over 17 years, he has provided expert Basis support for the SAP software solution.
He was involved in a Siemens AG project that was the first to go live in SAP release 4.0B. This project was recognized as a success by SAP and was highlighted in an article on the front page of Computer World. Since that time he has been providing Basis support in increasingly complex environments, hands-on experience with several successful projects. Effectively executed a number of full implementations, upgrade projects and support administrations of SAP with release R/3 (4.0B, 4.5B, 4.6B, 4.6C, 4.7 SR1 and ECC 5/6), ECC 6.0 SoH, S4/HANA, Portal 6& 7, UCES, SRM 5.0,SRM business package, BW/BI 3.5 &7, XI/PI 2.0/3.0& 7, APO (3.10), EP/MSS (6.0), Solution Manager 3.2/4.0, IS_OIL, IS-U, NetWeaver on different platforms; i.e. AIX/DB2 UDB (32-64-bit), AIX/Oracle (64-bit), Window and MSSQL 2000/2005(MSCE 64x) NT/Oracle, Linux/Oracle and Windows-2000/Oracle/DB2 UDB SuSE Linux/HDB), OpenText, StreamServe, DQM, SAP BODS, CRM, SAP Hybris(Customer, Sales, and Marketing) and HCP, and CPI.
Diploma in Computer Science and Bachelor degree in Commerce reflect and support the interest in the chosen career, providing technical expertise to support the world’s top performing ERP solution – SAP.
Competency Areas:
SAP technical architecture with several Installations, Upgrades experience
24/7 Support/Administration & Trouble-shooting, transition capabilities; including DB2/Oracle/MSSQL Database Administration. Solution Manager Centralized Monitoring and Administration, SAP landscape availability monitoring from Solution Manager (ABAP+ Java Stack), Operating System Administration (AIX/HP/Windows), ERP and BI Upgrades, Live Cache, Output Management, System Management (CCMS), Performance Management, Background Processing, Homogeneous Oracle/SQL Database copy, Java patches, Kernel and Patch upgrade, TMS Configuration using Workflow and Queue controlled and Transport Administration (Change requests, Transport of copy and table data), SAP Connect (Exchange connector, Unix send mail), Backup and Recovery Administration for DB2 and Oracle, SAP Add-on, Client copies & Client Transports, OSS Administration
SKILLS
Technology
NW04: Portal 6& 7, BI 3.5/7.0, XI/PI-7.0, CRM, SRM, Solution Manager 3.2/4.0, XI 2.0/3.0, NW 7.4, BODS, DQM
ERP: SAP WAS 6.20/ R/3-4.6C(32 and 64 Bit Kernel)/4.6B/4.5B/4.0B, ECC and S4/HANA
SCM: APO 3.10
Database: DB2 UDB 7.2, 8.1, Oracle 7.x –to- 10g, SQL Server 7 -to- 2005, HANA DB 1.0 and 2.0.
Operating System: HP-UX, AIX 6.1,5x/4x, Linux RedHat, SuSE Linux, Window 2000/2003 (Server and Advanced Server), NT 4.0 & 3.1, Microsoft All Desktop OS
Network: Experience of Network Administration.
SAP HANA DB Landscape setup, Installation, configuration, HANA Sizing
HANA DMO (Data migration) from Oracle to HANA.
HANA Installation configuration on distributed environment.
ECC, CRM and BW SQLServer to HANA DB
Clould Experience (VirtuStream and Azure)
SAP Cloud (SCC, C4C, CPI and Market) integration
SELECTED PROJECT EXPERIENCE
Company
SDG&E (Sempra), San Deigo, CA
Duration
Jan 2019 – To-Date
Position
Technical Lead (Development and Basis / SAP Cloud Lead)
Responsibilities
Technical Lead Infrastructure/Basis/SAP Cloud Admin, Development and Opentext
Manage On-Shore and Off-Shore development and Basis team.
Sizing (ISU, PO, and BW4/HANA)
BW4/HANA and S4/HANA installation
Responsable for Technical deliverables (landscape / architecture, Change management etc..)
Plan / Design infrastructure for CR&B implementation
Create SAP landscape build plan
SAP Cloud (Customer and Marketing) Integration using SCC/CPI with S4/HANA and OpenText
Infrastructure planning for Cloud application (SAP Cloud, Azure etc..)
Installation of IDEX(MPM) and BDEx and technical configuration.
Install S4/HANA/Upgrade S4/HANA
KNOA and EnableNow installation and Configuration
Company
SoCal Edison, Irwindale, CA
Duration
June 2017 – Jan 2019
Position
Technical Architect HANA / Basis Lead / SAP Hybris tech lead
Responsibilities
Technical Architect Infrastructure/Basis S4/HANA/SAP Hybris (Customer, Sales, and Marketing)
C4C PoT/PoC on SoH
HCP IPS (Identity management) user and roles provisioning for SAP Hybris (PoC).
Sizing (ISU, EDM, PO, and BW on HANA)
S4/HANA installation
CRM 7.0 EHP 4 installation
Technical deliverables (DR plan, infra planning, and landscape/architecture etc..)
Plan / Design infrastructure for CR&B implementation
Manage the technical teams (Development, Basis, Security, and SAP Hybris CPI)
Create SAP landscape build plan
SAP Hybris (Customer and Marketing) Integration using HCI/CPI.
Infrastructure planning and deliver for Cloud application (SAP Hybris, Azure and DSM etc..)
Installation of SAP Model Company and Focus build
Installation of IDEX(MPM) and BDEx and technical configuration.
Company
Washington Gas and Light, Alexandria, VA
Duration
May 2015 – May 2017
Position
SAP NW 7.40 Technical Consultant / ASE and HANA DBA / OpenText / SAP DS /DQM and SUSE Linux Admin
Responsibilities
Ashfaq was called in as a Basis Lead/HDB DBA/ BODS/ DQM/ OpenText consultant to help WGL technical team to perform implementation Basis support.
Project Basis Build / support ECC on SoH, BI, EP, PI, CRM, GRC, Solution Manager, Click, BOBJ, Redwood, BOBJ, DQM, BODS, BW HANA, Web Dispatcher and Solution manager, Ancile (Uperform), OpenText and SFTP server.
Build Windows and SUSE Linux VM on Azure cloud (A5/6, DS3/4, G4/5, GS4/5 series machines)
Create VM image and build new VM from image
Create new VM from disk
Data Services on SAP ASE
Create VM snapshot using Azure Powershell scripts
Change VM name and network configuration using Azure Powershell scripts
Setup Azure network and configure VPN tunnel from Azure to WGL
Creating Azure Cloud services, Storage accounts
Configure storage container and new disk using Azure Cloud explorer
Creating and attaching disk to VM and extending the existing disk size.
Apply Windows and Linux.
Prepare Windows and SuSE Linux machine for HANA and ASE DB
Configure the disks and filesystems for HANA using LVM and MD utilities.
Installing Linux packages required for HANA DB.
Configuring SuSE Linux kernel parameters for HANA.
Installation of SAP application servers.
Migration Development and Sandbox ECC, CRM and BW systems from SQL DB to HANA DB.
Migration Development and Sandbox systems GRC, SolMan, DS, PI, BOBJ from SQL Server to ASE 16.00
Installation of QA systems BW, CRM, and ECC on HANA.
HANA multi host installation
Configure ASE disk backups
Configure HANA backups and write scripts for backups and transfer HANA old backups to backup server
Upgrade HANA revisions SPS09 rev 97 to SPS10 102.4
Upgrade BW, CRM, and ECC to SPS10 using SUM tool.
Create HANA schema for side by side scenarios SLT.
Troubleshooting HANA issues (out of memory errors indexserver crash) and view logs, traces and dumps and collect the HANA logs and dump from HANA studio and send to SAP support
Restore HANA DB from backups
Installation of HANA content for CRM and ECC for ISU solution
Configuration of CRM HANA free search and HANA Authorization Assistant
Create HANA users, roles and schemas
Configure HANA DB connectivity between BOBJ and Data services
HANA Studio table distribution for multi host
Adjusting/Changing HANA parameters from HANA Studio
HANA alert monitoring and HDBSQL to view HANA tables and states.
Editing HANA ini files from OS level changing and adding parameters.
HANA DN Sizing using HANA quick sizer and POC
Build SAP ASE 16.00 and SQL Database Server
Project daily support troubleshooting issues.
Non-Production migration from MS Azure to on-premises
Company
Consumers Energy, Jackson, MI
Duration
Mar 2015 – May, 2015
Position
SAP NW 7.40 Technical Consultant
Responsibilities
Ashfaq was called in as a basis performance testing and EHP 7 upgrade consultant to help CE Basis team to perform implementation Basis support.
Project Basis support ECC, BI, EP, PI, CRM, IEM, BOBJ, Redwood, DQM, BW HANA, Web Dispatcher and Solution manager
HP Unix / Oracle
Performance Testing
ASCS Split
EHP 7 upgrade and support
Project daily support troubleshooting issues.
SAP HANA Database Administration & Monitoring from HANA studio.
Stop and start of SAP HANA database from HANA studio and OS level commands
Alert monitoring for SAP database using HANA studio
Performance monitoring& tuning using SAP HANA studio
Configuration and parameter changes in SAP HANA system using HANA studio
Company
HCL AXON
Duration
2014/2015
Position
SAP Technical Consultant
Responsibilities
Help to build SAP HANA systems for Direct Energy, Iberdrola and John Hopkins in AXON Lab.
SAP HANA DB Landscape setup, Installation, configuration, HANA Sizing.
HANA DMO (Data migration) from Oracle to HANA.
HANA Installation configuration on distributed environment
Installation of SAP HANA database, Studio, Client, Host Agent &Life Cycle Manager
Installation of SAP BW and SAP Business suite application on SAP HANA
Revision/SP Upgrades of HANA DB, HANA Client, HANA Studio, and HLM
Configuration& Troubleshooting of SLT connections using LTR/LTRC transactions
SAP system data migration to SAP HANA using SLT replication
SAP HANA database Refresh & Failover
Performing backup & Restore of SAP HANA database using HANA studio
Installation/renewal of SAP HANA database license
Adding of SAP HANA database to HANA studio and secure store configuration
SAP HANA Database Administration & Monitoring from HANA studio.
Stop and start of SAP HANA database from HANA studio and OS level commands
Alert monitoring for SAP database using HANA studio
Performance monitoring& tuning using SAP HANA studio
Configuration and parameter changes in SAP HANA system using HANA studio
Company
DirectEnery, Houston, TX
Duration
Oct 2013 – Feb, 2015
Position
SAP NW 7.40 Technical Consultant / Oracle DBA / OpenText / SAP BOD/DQM
Responsibilities
Ashfaq was called in as a basis/Oracle DBA/BODS/DQM/OpenText consultant to help DE Basis team to perform implementation Basis support.
Project Basis support ECC, BI, EP, PI, CRM, IEM, BOBJ, Redwood, BOBJ, DQM, BODS, BW HANA, Web Dispatcher and Solution manager
Ancile (Uperform), VLTrader, OpenText and SFTP server
HP Unix / Oracle
Installation, system build, system copies, patches
Build BW HANA system for DE HANA POC in Axon Labs
SAP / Oracle RMAN backup configuration for NetBackup.
Oracle database installation for non-SAP productions
Project daily support troubleshooting issues.
Company
City of Oklahoma (OKC) Oklahoma, OK
Duration
July 2013 – Oct 2013
Position
SAP NW Technical Consultant / OpenText / SAP Archiving
Responsibilities
Ashfaq was called in as a basis consultant to help OKC SAP Basis team to perform SAP Arching and Basis support.
SAP Basis
Windows 2008 / Oracle
SAP Data Archiving Basis support
Installation/Configuration of OpenText Archive server and Content server
Company
Hydro One, Ontario, Canada
Duration
Dec 2010 – June 2013
Position
SAP NW Technical Consultant (Basis Lead)
Responsibilities
Ashfaq was called in as a basis lead to help Hydrone SAP Basis team to perform implementation Basis support.
Project Basis support ECC, BI, EP, PI, CRM, BODS, DQM, BOBJ, OpenText, StreamServe and Solution manager
HP Unix / Oracle
Installation, Upgrade
Project daily support
Manage Basis team and deliverables
System copies
HA/DR testing
Performance testing
Company
Timberland LLC
Duration
Jun 2010 – Nov 2011
Position
SAP NW Technical Consultant
Responsibilities
Ashfaq was called in as a basis consultant to help Timberland SAP Basis team to perform implementation Basis support.
Project Basis support ECC, BI, PI, APO, SCM, BOBJ, Live cache and Solution manager
AIX / Oracle
SAP Installations (AIX/Oracle)
Project support and support existing FICO systems
Applying patches
System copy
Implementation of AIX PowerHA
HP Openview (SAP monitoring)
Netbackup
Robotics background scheduling
SAP router setup
Company
Dr. Pepper DPSG
Duration
Oct 2010 – Mar 2011
Position
SAP NW Technical Consultant
Responsibilities
Ashfaq was called in as a basis consultant to help DPSG SAP Basis team to perform implementation Basis support.
Project Basis support ECC, BI, EP, PI, APO, WM, BOBJ, UC4 and Solution manager
HP Unix / Oracle
Company
Regional Water Authority (RWA)
Duration
May 2010 – Present
Position
SAP NW Technical Consultant
Responsibilities
Ashfaq was called in as a basis consultant to help RWA SAP Basis team to perform implementation Basis support.
Project Basis support ECC, BI, EP, PI, MI, BOBJ and Solution manager
Solution Manager central monitoring, EW reporting
Performance tuning
Company
Rochester Public Utilities
Duration
March 2009 – December 2009
Position
SAP NW Technical Consultant
Responsibilities
Ashfaq was called in as a basis consultant to help RPU SAP Basis team to perform EHP support pack and Basis support.
EHP 1 / 4 support packs ECC, BI, EP and UCES and Solution manager
Solution Manager central monitoring, EW reporting
Performance tuning
UCES installation and configuration
Company
Liquidnet (USA)
Duration
March 2008 – February 2009 (Currently support as required)
Position
SAP NW Technical Consultant
Responsibilities
Ashfaq was called in as a basis consultant to help Liquidnet SAP Basis team to perform
Re-architecture landscape. Tasks included:
Re-Architecture
Migration SRM and ECC (Hardware and DB)
Applying Patches (SRM and ECC)
System refresh (SRM and ECC)
Installation of Portal 7 and BI 7
Configure UME with AD and SSO
Configure ECC, SRM and, BI in Portal
Configure SRM Business package for EP
Installation Solution Manager 7.0
Solution Monitoring: Configure Central System Administration and Real-time monitoring based on the Computer Center Management System (CCMS) and SAP EarlyWatch Alerts. Implementation – Tools, Content, and Methodologies to Efficiently Implement SAP solutions
Applying Support packs and Kernel Patches and Java stack using JSPM and SPAM
Support and help implementation and resolving problem
Operating Linux
Database Oracle and MaxDB
Connectivity SRM with ECC
Configuration CUA and LDAP (AD) for ECC, BI and Portal
Configuration of SSO
Central Transport Management
Central SLD configuration
Migration SAP server from Liquidnet data center on VirtuStream cloud
Company
County of Simcoe / City of Kitchner
Duration
September 2007 – March 2008
Position
SAP NW Technical Consultant
Responsibilities
Ashfaq was called in as a basis consultant to help County of Simcoe SAP Basis team to perform ERP 2004s implementation Project. Tasks included:
Installation ERP 2005
Installation Portal 7 SP9 and SP13
Installation of BI 700 SP9 and SP13
Installation CRM 5.0 SP09
Configuration of Portal 7 with ECC, BI CRM (Middleware)
Installation and Activating SAP Best Practices for Canada ERP05VA and CRM Best Practices
Installation Solution Manager 4.0
Solution Monitoring: Configure Central System Administration and Real-time monitoring based on the Computer Center Management System (CCMS) and SAP EarlyWatch Alerts
Implementation – Tools, Content, and Methodologies to Efficiently Implement SAP solutions
Applying Support packs and Kernel Patches and Java stack using JSPM and SPAM
Support and help implementation and resolving problem
Operating System Windows 2003
Database SQL Server 2005 support
Connectivity BI with ECC, Portal 7 and CRM with ECC and Portal
Configuration CUA and LDAP (AD) for ECC, BI and Portal
Configuration of SSO
Central Transport Management
Central SLD configuration
Installation of TREX and configuration for BI and CRM
Sun OS and Windows.
Company
ITM – ARAMCO
Duration
April 2006 – August 2007
Position
SAP NW04 Technology Consultant
Responsibilities
Ashfaq was called in as a basis consultant to help PetroRabigh SAP Basis team to perform Solution Manager 4 and ERP 2004s Project. Tasks included:
Installation ERP 2004s
Installation Portal 7 SP9
Configuration of Portal 7 with ECC 6 with ESS and MSS
Activating IS-OIL in ECC 6
Installation Solution Manager 4.0
Solution Monitoring: Configure Central System Administration and Real-time monitoring based on the Computer Center Management System (CCMS) and SAP EarlyWatch Alerts
Applying Support packs and Kernel Patches
QAS Refresh
Support and help implementation and resolving problem
Operating System HP-UNIX / Database Oracle support
Company
OCE North America Inc. / Chicago, IL, USA
Duration
September 2006 – March 2007
Position
Sr. SAP Basis Consultant
Responsibilities
Ashfaq was called in as a basis consultant to help OCE SAP Basis team to perform Solution Manager 3.2 – 4.0 and to apply support packs.
Upgrade Solution Manager 3.2 to 4.0
Solution Monitoring
Applying Support packs and Kernel Patches
Problem solving of SAP R/3 and SQLServer Database and EDI and ALE
QAS Refresh
Hardware migration IBM to HP servers
Transport system Migration and CUA
Operating System Window2003
Database SQLServer2003 (Shrink datalife and DRP Testing ect.)
Company
Cosma International Inc. Canada /Vehtek system Ohio
Duration
December 2005 – March 2007
Position
SAP Basis / Oracle Consultant
Responsibilities
Ashfaq was called in as a basis consultant to perform implementation of MySAP ECC 5.0, Solution Manager 3.2, and SAP Best practices base line package US V2.5 and DIMP 5.0.
Administration work /Tasks included:
Installation of MySAP 2004 ECC 5.0, Solution Manager 3.2, and SAP Best Practices Base line Package US V2.5, and DIMP 500
Configuration of Solution Monitoring – From System Monitoring to Business Process Monitoring
Solution Monitoring: Configure Central System Administration and Real-time monitoring based on the Computer Center Management System (CCMS) and SAP EarlyWatch Alerts
Help implementation team to setup Project using SAP best practices base line package US V2.5 and project administration and Business Blueprint relevant functionality, integrated use of configuration (IMG) and testing facilities
Configuration of Solution Manager Service Desk
Implementing and maintenance of MySAP, DIMP and Implementation support
Performing transports from Development system to Consolidation and to Production System
Configuring SAP spool system and installing printers
SAP OSS connection
Scheduling Basis background jobs
Organization of Help Desk
Applying Support packs and Kernel Patches
Problem solving of SAP R/3 and SQLServer Database
Client Copy and QAS Refresh
Operating System Window2003 / Database SQLServer2003
Company
St Lawrence Seaway Mgmt Corp
Duration
August 2004 – November 2005
Position
SAP Basis / Oracle Consultant
Responsibilities
Ashfaq was called in as a basis consultant to perform R/3 SAP Version 4.6C
Implementing and maintenance of SAP Corrections and Transport system
Performing transports from Development system to Consolidation and to Production System
Configuring SAP spool system and installing printers
SAP OSS connection
Scheduling Basis background jobs
Organization of Help Desk
Applying Support packs and Kernel Patches
Problem solving of SAP R/3 and Oracle Database
Client Copy and QAS Refresh
Operating System Tru64 / Database Oracle
Database reorganization (Tables and Table spaces) and other SAP DBA tasks
DRP Testing
Oracle Upgrade from 8.1.7, 8.17.4 to 9.2.0.4 Tru64
Company
Progistix
Duration
April 2002 – September 2006
Position
SAP Basis / Oracle Consultant
Responsibilities
Release 4.6C and WAS 6.x (Windows 2000 and HP UNIX) SAP Basis development and Production support and new ongoing projects
Database refreshes, client copies, transports, performance tuning
Installation of Web Application Server 6.10
Solution Manager 3.1, 3.2
Configuration of Central CCMS monitoring system WEB AS 6.10, 6.20 and 6.40
Configuration of SMTP mail setup in 6.10, 6.20 and 6.40
Configuration of CCMS alerts and generate pages and email on alerts
Installation of SAP solution Manager
Database reorganization (Tables and Table spaces) and other SAP DBA tasks.
Oracle upgrade 8i to 9i and 10i
SAP NetWeaver EP
Portal and NetWeaver Installation
Configuration of Portal access through Proxy server and LDAP configuration Portal user data, configuration of Portal runtime display, permission and securities, PCD, ActiceX
IViews, Personalize User Profile, creating second Admin user
Availability and Connectivity Monitoring J2EE Nodes (dispatchers and servers), Database pools, JCo connections to R/3, Core services and J2EE applications (EJBs and servlets)
J2EE Log monitoring (Memory, HTTP requests, Session and database pool connection)
The Internet Communication Manager (ICM) Monitoring
Internet and processing Internet requests in HTTP, HTTPS, and SMTP protocol monitoring
Configuration of Portal access through Proxy server
Availability and Connectivity Monitoring SAP Enterprise Portal (SLR)
Portal availability via load balancer, Load Balance, SSO, LDAP (Down time, response time and monitor), Portal instances (Status, availability, runtime availably and Diagnosis), Services and backend system monitoring, Portal log monitoring and user connectivity, IGS, SLD, SDM
Applying Patches and hot fixes and trouble shooting
Company
Domtar Inc
Duration
June 2001 – December 2001
Position
SAP NW Technical Consultant
Responsibilities
Ashfaq joined Origin North America in June 2001 and has been serving as a Basis Consultant. Working for Domtar client he executed follows actions:
Production support for Domtar and Origin’s local support SAP R/3 4.6C
Installation of BW 2.1C
Installation of mysap workplace, Middleware and plug-ins
Installation of Web server Instances
Installation of ITS AGATE
Installation and troubleshooting of ITS Instance for Administration purposes
Configuration of Sap DCOM component connector
Installation of Drag&Relate Servlet
Defining the Drag&Relate Parameters – MiniApp Servlet Installation
Defining the MiniApp Servlet for iViews Parameter
Company
Haliburton Oil Co
Duration
October 2000 – May 2001
Position
SAP Basis / Oracle Consultant
Responsibilities
Ashfaq was called in as a basis consultant to perform R/3 SAP 4.6C Administration work/Tasks included:
Implementing and maintenance of SAP Corrections and Transport system
Performing transports from Development system to Consolidation and to Production System
Configuring SAP spool system and installing printers
SAP OSS connection
Scheduling Basis background jobs
Organization of Help Desk
Applying Hot packages, LCPs, BW and, Kernel Patches
Problem solving of SAP R/3 and Oracle Database
Client Copy
Operating System HP Unix and Sun Database Oracle
Database copy one system to another system
EMPLOYMENT HISTORY
Date
Company Name
Role
Jan 19 – Present
Accenture
Business & Integration Manager
Mar 08 – Dec 18
HCL AXON
SAP NW Technical Consultant
Apr 06 – Mar 08
IDS Scheer North America
SAP NW04 Technology Consultant
Apr 02 – Mar 07
CGI SAP CENTRE OF EXPERTISE
Sr. SAP Basis Consultant
Jun 01 – Dec 01
ATOS ORIGIN INC
SAP Basis / Oracle Consultant
Oct 00 – May 01
CIBC INTRIA HP
SAP Basis / Oracle Consultant
Jun 98 – Aug 00
SIEMENS, Pakistan / SBS AG
SAP Basis / Oracle Consultant
QUALIFICATIONS
Level
Subject
College / University
Degree
Bachelor in Commerce
University of Karachi, Pakistan
Diploma
Diploma DBA Oracle
Oracle Education Centre
Diploma
Oracle Diploma
Oracle Education Centre
Diploma
computer science Diploma
Grace Institute of Tech
TRAINING
Certification
SAP Technical Consultant (SAP Basis Admin 2002) certification
CONTACH INFORMATION.
Phone: 917-***-**** / 917-***-****
EMAIL : adg8qi@r.postjobfree.com
Home Location : Tampa, FL
Immigration Status: Canadian Citizen / US GC