Business Solutions Consultant
The Ottawa Hospital
Total years of experience :23 years, 2 Months
• Strategic consulting experience in digital business transformation, packaged software selection, implementation and risk assessment
• Develop the information system strategy and roadmap to acquire and implement a new ERP cloud SaaS for the hospital and regional partners (other healthcare provider in the Ottawa valley)
• Work with business portfolios to define project charter, scope, current challenges, opportunities and potential benefits to provide an excellent patient care service and user experience
• Project scope includes finance, supply chain, human resources, payroll, projects financial, and assets management business applications
• Develop the benefit realization matrix with KPIs and the project risk register with mitigation plan in coordination with business portfolios
• Assist finance team in developing the business case and total cost of operation (TCO) for budget approval. This includes the capital and operating cost budget for software licenses subscription, resources, integrations with third party applications, cost avoidance, maintenance ad support
• Work with external consultant on Market Sounding Exercise to identify potential quantifiable and non-quantifiable benefits of implementing a cloud ERP solution to support the business case
• Develop the project structure, governance and key stakeholders’ roles for the steering committee and core project team
• Prepare monthly presentation material for different business portfolios, steering committee and core project team and set the expectations
• Manage vendor relationships, engagements and facilitating educations workshops, peer reviews
• Facilitate and coordinate business requirements and scenarios gathering sessions with IS leads, key stakeholders, and subject matter experts (SMEs)
• Interview and hire necessary resources to support project multiple activities including backfill resources for IS team, procurement lead and the fairness officer
• Prepare the RFP document in coordination with procurement lead and fairness officer, activities include vendor qualification, identifying committee members and developing evaluation process (RFP stages, rating criteria, scoring guidelines)
Key Projects (some are under progress)
• Successful upgrade of Oracle Hyperion from on-prem to Oracle Cloud EPM and develop the data extract process with integration to Oracle financial and human resource applications
• Analyzing, implementing and managing business processes and application solutions
• Implementing and managing Oracle ERP application software/hardware platforms and operating systems for The Ottawa Hospital (three campuses) and regional partners including Heart Institute, Queensway Hospital and EORLA
• Managing ERP business application enhancements and upgrades
• Supporting ERP business systems and users in a production environment
• Managing information system professionals, external consultants, vendors and end-users
• Preparing project business cases, scope and objective documents, budgets, resource capacity planning, project plans and status reports
• Applying testing methods and cycles including quality assurance testing on business systems
• Architecting and implementing Oracle application solutions to address the enterprise-wide current and future business needs of the organization
• Following the Application Implementation Methodology (AIM) and Project Management Institute (PMI) principles for the project management lifecycle (BR100, RD20, RD50, BR30, TE40, MD50, MD70)
• Support special healthcare software and integrations to Oracle ERP including Alex Gold for tools sterilization, Solocain for warehouse management with carousel functionality, Epic for patient records and billing, GHX EDI interface with vendors and Loftware for medical labels printing
• Implelmting standard ITIL processes for end-user support of incidents, problems, tasks, users access and enhancement requests using Service Now application
• Coordinating ERP upgrade project assessment and evaluation from R12.1.3 to R12.2
Key Projects (some are under progress)
• Managing and coordinating Oracle database upgrade with IT DBA team from 11g to 19c. The project includes hardware, operating system (Sun Solaris0, JRE, and database components upgrade as well as testing business cycles before moving to production
• Corodiantiong Alex Gold application and Solochain applications upgrade to the latest versions to mitigate security threats to the hospital network. this includes hardware, OS, database and application
• design and develop a solution to integrate purchase order data with third party shipping/clearance company software (Opti-Freight) to process shipments
• Managed and completed successfully the implementation of Oracle AR Sundry solution
• Managed the Personel Protective Equipment (PPE) data extract solution design and implementation for the analytics team to develop necessary dashboards responding to COVID19 requirements
• Environment: ERP Oracle 12.1.3, Oracle SQL*, PL/SQL, Oracle Forms and Reports 9i, Mobile Application Framework MAF, Oracle Workflow, Toad, OBIEE, VPN, Citrix, Visio, SharePoint, MS Office/Projects/Teams, Service Now, Epic, Alex Gold, Solochain, GHX, Loftware
• Provided remote support, consultancy, recommendations and initiatives services for IT various activities and to senior management to ensure smooth and efficient operations of ERP and IT department services
• Undertook and performed assigned tasks by the management in coordination with IT department team and relevant stakeholders to provide required business solutions
• facilitated workshop session for business requirements gathering with stakeholders and solution designs/development with IT team
• Diagnosed and solved technical problems, managed prioritization, escalation and solution tracking internally within IT team and externally with the third-party vendors/contractors
• Managed software and hardware licenses and, support agreements (SLAs) renewals with international and local vendors/contractors
• Environment: ERP Oracle 11i/12c e-Business Suite, Enterprise Red Hat Linux 4.5/5.8, Clustering, Load Balancing, VPN, Oracle RAC DB 10g, HP Itanium Servers, EVA 4000 SAN, Tape Library Backup, SQL*, PL/SQL, Oracle Forms and Reports 9i, Toad, Discoverer BI, MS Office, MS Projects, Visio, WBS, DRP, Data Cleansing and Migration, Excel4apps reports
• Managed all financial objectives related to IT by forecasting purchases and system requirements, preparing the annual budget, scheduling expenditures, and reviewing the budget for variances/corrective action.
• Identified technology solutions and software development options to support business objectives and clearly communicated risks, issues and benefits with the board of executives
• Utilized project management skills including planning, stakeholder’s engagement, tracking project execution, managing deliverables, mitigating risks, reporting, securing resources, controlling budget and implementing corrective measures ensuring project scope completion on budgeted time/cost
• Demonstrated polished leadership skills and proactive team-based management style with the ability to motivate teams to increase productivity and utilize their talent and knowledge
• Maintained strong vendor relationships, implemented strategic negotiations and evaluated service provider performance for improved services
• Evaluated the operations and performance of information systems, developed new strategies and IT procedures that will increase efficiency and enhance business workflow
• Developed three-tier support strategy for problem/incident management based on ITIL service standards as well as change management procedure for solution requirements changes throughout the software development lifecycle (SDLC)
• Initiated improved IT governance structure and quality assurance procedures in lieu with ISACA COBIT5 framework by identifying clear duties and responsibilities for IT team, developing and implementing proper IT policies and, improving network/information systems security
• Developed and maintained effective disaster recovery plans in accordance with organization business needs and in coordination with ERP module owners to maintain essential operations
• Ensured the creation and maintenance of all manuals and written documentation, including Oracle standard material, custom user training manuals and applied modifications/upgrades
• Recruited/supervised the development/training of a (12) IT professionals and encouraged positive communication atmosphere making sure the team is working together in the most efficient manner
Key Projects and Achievements:
• Managed and supervised the Enterprise Resource Planning (ERP) project implementation, development, deployment, maintenance and post-go-live support activities for Oracle e-business suite 11.5.10.2 with an approximate value of $10 million. The project was vast and covered multi-organization business lines having operations in multiple middle east countries: Kuwait, UAE, Egypt, Qatar, Lebanon and Iraq with more than 2100 users connected to a centralized clustered ERP production system based in Kuwait.
• Implemented modules include: finance (general ledger, accounts payable, accounts receivable, assets, consolidation), core HRMS, e-learning, payroll, supply chain (purchasing, inventory), iprocurement, order management, projects management/costing/billing, manufacturing, quality control and enterprise assets management (eAM) in addition to the following customized modules: credit facility, letter of credit, letter of guarantee, subcontract, inter-company billing, accommodation and imprest funds
• Communicated and facilitated across diverse groups and at all corporate levels to build project engagement and cohesion toward common goals
• Performed internal quality control check throughout ERP project phases to drive consistency & integrity
• Applied ERP best practices for standards business cycles and performed Business Process Re-engineering (BPR) for others to comply with international standards
• Planned, applied and tested recommended Oracle rollup patches for ERP application and database
• Led ERP application R12 upgrade in parallel with installing 2 new application nodes of 64 bits
• Developed and implemented the ERP backup strategy and preventive maintenance procedure/schedule
• Designed, constructed, modified, implemented and tested database architecture and data models
• Analyzed user’s requirements, designed, developed and tested required Oracle forms/reports V3
• Performed administration, configuration and support the company integrated application system (ERP). The application modules are general ledger, project control, accounts payable, inventory management, fixed assets, procurement, subcontractors, human resources, payroll and letter of guarantee
• Designed, implemented backup strategy and effective preventive maintenance contracts with vendors
• Maintained application data accuracy, consistency and confidentiality across different branches
• Performed administration of Sun Servers running on Solaris UNIX platform and external peripherals
• Performed database activities including solutions structure design, data manipulation as well administrative part such as creating data files and database fine-tuning to enhance performance
Key Projects and Achievements:
• Designed, developed and implemented the engineering system for the Petrochemical Industry division. The system was developed to control fabrication in-company workshop and keep track of free issue material, isometrics, spools, welding process and project progress in different stages
• Implemented and supported the fixed assets and payroll modules for the company branch in Egypt. This includes modules setup, configuration, data migration and end-user training
• Environment: SQL*, PL/SQL, Oracle DBA, Cold Backup, Sun Solaris UNIX, Sun Spark Stations, Oracle Forms and Reports Builder v2/3, MS Outlook, Word, Excel, PowerPoint, MS Projects
• Developed and implemented application code of new business cycles and reports for the company ERP system as per project/user requirements
• Analyzed business requirements and worked with the team to optimize system implementation
• Prepared performance reports, manuals and documentation on the status, operation and maintenance of system software and hardware
• Designed and conducted end-user training programs
• Troubleshoot and support end users/application problems and bugs
Key Projects and Achievements:
• Developed and implemented online inventory data processing for 100 remote sites connecting to one central database, keeping stores data up to date and reducing paperwork cycle
• Implemented the fixed assets module and barcoding system to control and track assets movements (approx. value 35 KWD million) across different location
• Environment: SQL*, PL/SQL, Oracle DB, Cold Backup, Sun Solaris UNIX, Sun Spark Stations, Oracle Forms and Reports Builder v2/3, MS Outlook, Word, Excel, PowerPoint