CURRICULUM VITAE PERSONAL DETAILS NAME : Evans Maravanyika SEX : Male ID Number : (***)-***-****4 HOME : 87 Goethe Road, Lombardy East Johannesburg, 2090 TELEPHONE : +(***)-***-**** EMAIL : ****@*****.*** CAREER OBJECTIVES & VALUES • To contribute to the goals of an organization using appropriate skills & experience. • To implement Information Technology systems using appropriate methods and standards. • To associate with a dynamic organization that values professional qualifications, commercial experience and general business acumen. • Areas of specific interest are implementation of latest technology to achieve best practice business processes. • To be able to demonstrate a high level of competency and confidence. CAREER PROFILE • Effective highly motivated results driven individual, quality oriented; with in depth knowledge of IT trends & solutions, network infrastructures, software applications, systems development life cycles, systems administration and IT project management acquired over a period of over thirty-two years. • A catalyst, problem solver with a flair for spotting opportunities and selling new ideas to executive management. • A public sector manager with a very good grasp of government policies and regulations as well as provincial strategic plans and knowledge of PMFA. • An IT Senior Manager who provides technology vision and leadership developing and implementing information technology initiatives that save business costs in a constantly changing environment. ACHIEVEMENTS • Implemented SAP Solution Manger for Root Cause Analysis & Solution Monitoring at Johannesburg Water. • Implemented ITIL based service management processes for Johannesburg Water. • Relocated Johannesburg Water HO IT infrastructure to a new site located at 17 Harrison Street • Implemented a Branch Environment Automation Manager, an online front-end system for Branches. • Developed and implemented a Travelers cheque reconciliation module. • I was responsible for the successful implementation of a major project, which saw the first deployment of ATM’s by Zimbank Ltd. • Designed and implemented a Bill payment module for Zimbank customers. • Implemented VISA and MasterCard Issuer and Acquirer systems for Zimbank Ltd. • Administered credit and debit card Management Systems for Zimbank Ltd. • Commissioned EFT Point of sale system for Zimbank Ltd. • Responsible for the implementation of a Service Desk running HEAT software at Baragwanath Hospital. • Reimplementation of MEDICOM modules which had fallen into disuse at the hospital. • Designed and documented disaster recovery procedures for the hospital computer system. • Initiated a training and re-skilling programme for the IT department staff at Baragwaneth Hospital. • Implemented IT infrastructure for Limpopo Dept of Health information system MEDICOM ERP. • Deployment & Operations Support of the IT Infrastructure for the 2010 FIFA World Cup S.A. events such as the Preliminary Draw, Confederations Cup Draw, Confederations Cup, 2010 Final Draw and 2010 Final games. • Implemented VISA & MasterCard POS Acquiring systems for Mercantile Bank Ltd. • Responsible for the setup of an Oracle practice with Gold Partner membership at Real Global Business Solutions. ACADEMIC QUALIFICATIONS Level : GCE “O” Level Period : 1979-1982 Institution : Mabvuku High School Course : National Diploma in Computer Studies Period : 1984-1986 Institution : Harare Polytechnic: PROFFESSINAL COURSES ATTENDED Conducted By Year Description NCR 1989 VRX to VRX/E Migration 1990 UNIX Operating System 1990 Seminar in Data Communications UNIX V.4 System Administration ICL 1993 Structured Systems Analysis & Design Method PC LAN 1991 Netware V2.1 System Manager 1991 Netware V2.1 Supervisor Windows NT Systems Administration NIIT 2000 C++ Dynamix 2003 MS Project 2000 Wits University 2003 Hospital Management SAP AG 2006 SAP Solutions Manager Certified Consultant Exin 2007 ITIL ver.2 Foundation Certificate PMSoft 2009 PMI - Project Management Professional Quintica 2011 ITIL ver.3 Foundation Oracle University 2012 Oracle Unified Method Level 4D Application Discipline Readiness Oracle Unified Method Level 3: Gathering Requirements Oracle Unified Method Level 2: Use Case Overview Oracle Unified Method Level 2: Envision Focus Area Overview Oracle Unified Method Level 2: Manage Focus Area Overview Oracle Unified Method Level 2: Implement Focus Area Overview Oracle Unified Method Level 1: Overview and Awareness Oracle E-business Suite R12 Implementation Bootcamp Oracle Database 11g Sales Specialist Oracle E-Business Suite R12.1 Supply Chain Management PreSales Specialist Oracle E-Business Suite R12.1Supply Chain Management Sales Specialist Oracle E-Business Suite R12.1 Financial Management PreSales Specialist Oracle E-Business Suite R12.1 Financial Management Sales Specialist E-Business Suite Support Specialist (v3.0) 2015 Oracle Business Intelligence Foundation 11g Implementation Specialist EMPLOYMENT HISTORY Employer : Anmar Construction Africa Pvt Ltd. Period : October 2018 – Current Position : OBIEE Consultant Provide subject matter expertise in deployment of OBIEE Cloud services. Creation of Projects and Adding Data Sources Addition of Data Elements to Visualizations Exploring Data Using Filters Adding Data to a Project Modifying Uploaded Data Sources Creating Analysis and Dashboards Creating Interactive Analyses, formatting columns and views Addition of Content to Dashboard Pages Creating Column Prompts and Prompts to Dashboard Pages Team Leader OBIEE Front End Development Develop OBIEE 11g/12c ad-hoc reports + dashboard Develop OBIEE 11G/12c BI Publisher reports Technical setup and a design of the RPD using Data Modeling techniques Write advanced PL/SQL, use Oracle's SQL aggregate and analytic functions using Oracle SQL Developer Design repository objects from ROLAP data models, hierarchies, levels Understanding of OBIEE ad-hoc reports development process Creating of XML data templates in BI Publisher Technical expert for mission-critical OBIEE applications including design, development, implementation and support. OBIEE migrations and merges of repositories, web catalogs, upgrades and security configurations. Manage performance tuning in OBIEE and the reports. Drive the analysis, design, and development of new dimensional models and enhancements to current models. Contribute throughout project life cycles, from planning to production implementation, including the creation of functional Technical designs and test plans for repository models and hierarchies. Create standard documentation for repository structures and provide metadata for business owners, end users and IT staff. Test and reconcile designs to source systems and business specifications. Support and maintain production data and repository assets. Administer, support and maintain the reporting toolset environment. Respond to third tier incidents and conduct appropriate research and communication to resolve issues. Cross training of team members. OBIEE Administration Installing, upgrading and configuring OBIEE tools 11g/12c on Weblogic Domains Administering ETL and data warehousing applications and tools Administering metadata repositories Migration of RPD and Catalog from DEV, QA thru to Production environments Installing and configuring OBIA 11g Installing and configuring Oracle Data Integrator Customization of Oracle Business Intelligence Applications Oracle Business Analytics Warehouse Customization Design and implement ELT processes using Oracle Data Integrator tool set Employer : Emisha Systems. Period : December 2017 – March 2018 Position : OBIEE Consultant Provide OBIEE Development and Administration services at MTN client. Provide maintenance and technical support for OBIEE 11g and 12c. Upgrade and migration of metadata from OBIEE 11g to 12c. Install and configure OBIEE 11g and 12c. Develop and maintain OBIEE Analysis, Dashboards and Reports. Use Agile methods to develop and maintain PL/SQL functions. Develop BI Publisher Data Models, Fixed format reports, Integration and BI Publisher SQL custom development well as technical support and maintenance. Carry out JAD sessions with business users to configure and mapped source files for initial configuration. Dimensional modeling for new and modified star schemas. Develop and maintain Physical Layer, Business Model & Mapping Layer and Presentation layer using OBIEE Administration tool. Lay out the plan for customization from initial design document to rollout plan. Merged the multiple RPD and Catalogs to DEV, QA and Production. Used Catalog Manager to migrate new Projects and enhancements from Development to Production environment. Configure LDAP security through RPD in Admin Tool, Weblogic and Enterprise Manager. Created users and groups and setup the Data Level Security as well as Object Level Security. Conducted OBIEE (server, apps, ) training sessions for client's team. Employer : Consolidated African Technologies (Pvt) Ltd. Period : July 2016 – December 2016 Position : OBIEE Specialist Client: Liberty Life (July 2016 to December 2016) Liberty Reporting project Key Accomplishments. • Implementing OBIEE and BI Publisher 12c. • Install and configure OBIEE & BI Publisher 12c Answers, Publisher, Delivers & BI Office components. • Participate in Requirements Gathering, productions of Functional & Technical Requirements Specifications. • Design, develop, and implement (ELT) processes on Oracle Data Integrator (ODI). • Designing OBIEE technical architecture. • PL/SQL development using SQL Developer • Implement Meta Data Physical, Business Model & Mapping and Presentation layers using BI Admin Tool. • Creation of BI Publisher Data Models. • Creation of custom OBIEE and BI Publisher analysis, reports and dashboards. • Produced project documentation, conducted unit testing and produced project status reports. • Migration OBIEE metadata repositories. • Performance tuning of OBIEE & BI Publisher 12c, troubleshooting, problem resolution and user support & training. • Manage OBIEE caching for efficient report generation. • Communicate status on progress, problems and plans to leadership; adapt to changes in the project plan and customer requirements. • Configure OBIEE 12c Visual Analyzer, create analysis and interactive dashboards. • Install & Configure Data Visualization Desktop, create dashboards visualizations. • Support and maintenance of Oracle BI Applications 11g. Employer : Real Global Business Solutions (Pvt) Ltd. Period : April 2012 – June 2016 Position : Senior OBIEE Consultant Role: Team lead and BI Architect to strategically design, implement, and support BI software and systems, including integration with databases and data warehouses, and report writing. Subject matter expert in the areas of BI Analytics, OBIEE, Enterprise Reporting and Data Warehousing, thorough understanding of Oracle Technologies, Data Modeling, RPD, Star Schema design and Oracle Applications Architecture (11g). Duties. Business Intelligence - selecting, blueprinting, gathering requirements, designing, and rolling out BI solutions to end users. Ensuring high levels of OBIEE availability through support functions and in depth testing. Configuring all components of OBIEE (OBIEE Answers, Publisher, and Delivers & BI Office). Implement OBIEE integration with EBS, ESSBASE, ODI, BI APPS, ActiveDirectory and other 3rd party Applications. Data - Designing, developing, and implementing data models for enterprise level applications and systems. Architect Data Models at the following layers: conceptual, logical, business area, and application. Identifying, documenting, and administering the metadata repository. Reports - Examine and evaluate reporting requirements for various business units across the organization. Create/modify OBIEE Metadata repository’s Physical, Business Model and Mapping and Presentation Layers. Develop and deploy OBIEE dashboards, analytics and reports. Create well-organized tables and pivot tables Convey data insights with line, bar, pie, waterfall, radar, and other graphs Configure MapViews for interactive maps and spatial analysis. Build advanced visualizations, including trellis charts, gauges. Use Oracle Business Intelligence Publisher to create pixel-perfect reports from various data sources Design effective, interactive BI dashboards Use the Oracle Scorecard and Strategy Management module to measure, evaluate, and manage key performance indicators Administration - will include regular reporting on performance and/or oversight of installations, integration, upgrades, migrations and on-going maintenance on the Company’s various Business Intelligence Applications. Responding to the technical requests of Users and project teams pertaining to OBIEE applications. Performance tuning of OBIEE reports. Manage and mentor a team of technical resources. Client: Gauteng Dept of Health Medical Supplies Depot (January 2013 to June 2016) Key Accomplishments. • Interacted with the business analyst and business users to understand the customer requirement documents. • Installed and Configured OBIEE 11.1.1.3.0/11.1.1.5.0 • Configured OBIEE components for reports Performance Tuning • Diagnosing and troubleshooting BI Reports ability to articulate configuration and technical issues. • Tuned weblogic application server and its managed servers to run deployed applications fast. • Configure the initial configurations for Finance and SCM Analytics. • Analyzed reporting requirements for dashboard reports and adhoc reports. • Involved in Analysis and Design of the BI data warehouse. • Execute the initial test full load for a subset of data. • Fix the ETL load issues because of the data or OOTB ETL mappings. • Execute Incremental test loads. • Validated and customized OOTB reports. • Incorporate all the customizations require for the initial requirements in to the ETL mappings. • Test ran the load for a complete data load. • Design the test cases for all the initial requirements. • Involved in configuring, creating and modifying repository for various modules for necessary customizations. • Implemented security by creating users & groups, setting up External Table Authentication, creating Session Variables and Initialization Blocks and associated catalog objects and Web modules with the created groups • Used Filters and provided Customized prompts appropriately to avoid excessive data showing up in Reports to improve performance • Integrate Custom warehouse table with the OBI Apps tables for extending the business analysis capabilities. • Migrating/merging Repository and web-cat and documented migration procedure and best practices to be followed during migration from development to test and then to production. • Documented processing times for each module, developed test cases and used them to run through each process. Employer : Mercantile Bank Ltd Period : April 2010 – August 2011 (Retrenched) Position : Systems Owner - PRIME Accountable for services to MBL Card Business Unit, their customers and 3rd Party Alliance Partners. Ensure successful delivery, risk management and support of the PRIME Card Management systems. Manage IT resources associated with these services and systems. Accountable for the optimal functioning of the PRIME Systems, and directly or indirectly manage the full technology stack that supports the System through SLA’s. Administrative Duties • Business Stakeholder Management and Planning. • Accountable for implementing new systems functionality. • Drawing up a Systems Plan that is aligned to the business priorities and objectives for each System. • Assigning and resolving incidents related to the System through appropriate resources. • Participating in the Change Control forum. • Selecting and implementing appropriate monitoring tools, monitoring that support processes are executed, and reporting on overall systems performance. • Manage and Optimize LINUX and Windows 2003 Server Performance. • Administration of user access to systems and databases, monitoring system and application performance. • Implement and administer system IT contingency plans. • Processing (or overseeing) that recurring Administration and scheduled tasks and processes are done by the correct Systems Specialists or outsourced vendor. • Participating with business in the selection and evaluation of appropriate products and vendors, through formal processes such as RFI and RFPs. • Management of staff members according to HR Best Practice and Policies. Employer : Satyam Computer Services Ltd Period : October 2007 – March 2010 (Resigned) Position : Head – Infrastructure Management Services Duties • Plan, direct and co-ordinate activities of multiple projects ranging in the areas of IT, Systems Integration and Business Process Management • Define project scope, objectives, staffing, resources and deliverables • Develop project plans that identify key issues, approaches and performance metrics • Plan and schedule project timelines and milestones • Formulate risk management plans • Assemble and coordinate multi-disciplinary project teams • Lead and mentor up to 100 project staff • Manage vendor relationships including negotiating and controlling contracts • Track project deliverables • Monitor quality assurance measures • Control project variances through root cause analysis and correction • Implement and manage project changes and interventions • Manage and control project budgets • Develop and present reports on project progress • Maintain communication with project stakeholders and manage expectations • Evaluate projects and assess results Project Description The project was to deploy IT infrastructure for the FIFA 2010 SA World Cup Preliminary Draw, Final Draw and the 2010 World Cup. Contribution The associate was responsible for staging and managing the deployment and decommissioning of the IT infrastructure for these events. • Planning IT infrastructure roll out and asset management. • Planning AD landscape, Windows Server 2008 configuration, deployment and maintenance. • Deployment of computer hardware. • Provide hardware and software support. • Deployment of client workstations using WDS. • Provide user training and support. • Provision of IT Contingency plans. • Leading the ICT professionals on this project. • Liaison with all vendors and sponsors contributing to the events. • Liaison with FIFA IT consultants. • Developing policies and procedures for operations of the IT solution for the events. • Identifying IT systems to support the IT infrastructure for the events. • Taking charge of project management requirements for the events. Employer : LHC Health Solutions Period : December 2006 – September 2007 (Resigned) Position : Technical Manager Duties • Coordinate internal resources and third parties/vendors for the flawless project execution • Ensure that the project is delivered on-time, within scope and within budget • Assist in the definition of project scope and objectives, involving all relevant stakeholders and ensuring technical feasibility • Ensure resource availability and allocation • Develop a detailed project plan to monitor and track progress • Manage changes to the project scope, project schedule, and project costs using appropriate verification techniques • Measure project performance using appropriate tools and techniques • Report and escalate to management as needed • Manage the relationship with the client and all stakeholders • Perform risk management to minimize project risks • Establish and maintain relationships with third parties/vendors • Create and maintain comprehensive project documentation Project Description The project was to deploy IT infrastructure for the Limpopo Department of Health Hospital Information System Contribution The associate was responsible for designing and implementation of the IT Infrastructure • Design and implement network architecture • Design and rehabilitation of server rooms • Configuration of HP servers centrally • Deployment of servers to hospital locations • Deployment of client workstations using WDS. • Deployment of print servers • Provide user training and support. • Provision system backups and recovery • Manage the Infrastructure project team Employer : Johannesburg Water (Pvt) Ltd Period : June 2005 – November 2006 (Resigned) Position : Senior Manager – Information Technology Responsible for ensuring the implementation and functioning of an integrated SAP & HANSEN ERPs IT solution for JW in line within business needs and strategic priorities by providing strategic and tactical planning, development, evaluation, and coordination of the information technology systems for the Johannesburg water network BUDGET/CONTRACTS • Approval, coordination and controlling of all projects related to selection, acquisition, development and installation of major information systems for JW. Provision of advice on evaluation, selection, implementation and maintenance of information systems, ensuring appropriate investment in strategic and operational systems. Evaluation of systems to measure their success. • Reviewing of all hardware and software acquisition and maintenance contracts, with involvement and participation of other management team members as appropriate. • Development and maintenance of corporate policies and standards aimed at maximizing effectiveness and minimizing costs related to the acquisition, implementation and operation of IT systems. • Development of purchase or lease agreements for hardware, software and telecommunication services. • Development and monitoring of the approved annual operating and capital budgets for information and technology systems. • Management of contracts with IT suppliers and service providers. • Management of relationships with vendors for sales, service and support of all information systems and technology. Maintenance of problem logs, documentation of system errors or defects. Acting as the primary contact to software, hardware and network-related vendors and consultants. PLANNING/POLICY DEVELOPMENT • Responsible for the technology vision and planning process that will regularly evaluate existing technology, information systems, and staffing, research new solutions and technologies and recommend changes. • Responsible for planning, development, evaluation, coordination and management of the information and technology systems for the JW including telephones, data imaging and office automation. • Development and enforcement of policies and procedures to ensure the protection of the JW IT assets. • Recommendation of changes to software applications. • Gathering and analysis of changing user requirements and development of effective and feasible ways to satisfy user requirements. SYSTEMS ADMINISTRATION/REPORTING • Promotion and overseeing of relationships between IT resources and external entities. • Manage SAP and HANSEN ERP Systems. Ensuring that all information systems and networks operate according to internal standards. Development and maintenance of the systems architecture. • Coordinates and management of the provision of Management Reports. • Manages the system that provides training and support to end users. • Development and maintenance of IT Contingency plans in the event of power failure, damage to system, etc. • Oversee the development, maintenance, and communication of systems documentation, policies, and procedures. TRAINING • Supervising the development and maintenance of user documentation. • Communication of IS/IT plans, policies and technology trends throughout the organization, including management groups and professional staff. • Development, implementation and maintenance of comprehensive user training program. Provision of new user training and advanced training for existing users. • Update documentation and on-line help facilities. SUPERVISION/STAFF COORDINATION • Selection, training, supervision and evaluation of staff • Serve as chair of Information Technology steering committee. • Manage Individual and Team Performance. • Develop Individual and Team Competence. • Manage Workplace Climate Employer : Chris Hani Baragwaneth Hospital Period : May 2002-June 2005 (Resigned) Position : Deputy Director – Information Technology Duties & Responsibilities : Addressing IT business strategies Develop, implement and provide support to MEDICOM IT systems and networks. Manage network hardware and software to achieve required level of availability. Direct and coordinate IT activities -: Provide technical input for training and development of IT skills. Investigate the availability of hardware and software and evaluate in the light of hospital needs. Provide and maintain servers for AD, Application, Internet and email facilities. Provide and maintain system backups and recovery. Provide norms and standards for Information Technology and support. Provide mechanisms for quality assurance relating to IT and IS. Manage the budget for the IT cost center. Provide overall management and administrative needs for the IT department. Prioritizing goals of IT department Provide advice to the hospital management on IT related issues. Provide IT strategic management plans for the hospital. Decision Making and negotiations Negotiate and liaise with vendors in relationship to out-sourced activities. Negotiate and provide service level agreements. Management and development of employees Employer : Department Of Public Works (Limpopo Province) Period : July 2001- May 2002 (Resigned) Position : Control Network Controller Duties : Establishment, coordination and implementation of server and network strategies. Manage network hardware and software to ensure systems availability. Adopting server and network technology and strategies to achieve business requirements and Objectives of department Maintaining high standards to keep the servers and network operational to service levels. Monitoring Server and Network availability, reliability and security. Administration and configuration of Servers and WAN/LAN. Trouble shooting and diagnostics of logins and other server and network related problems. Deployment of new equipment within the department. User service and support. Employer : Zimbabwe Banking Corporation LTD Period : January 1987- June 2001 (Resigned) Position : Held several through promotions as outlined: Year Positions Held 01/01/1987 Trainee Programmer 22/02/1988 Programmer 01/03/1990 Senior Programmer 24/04/1991 Programmer/Analyst 29/01/1993 Senior Analyst/Programmer 01/01/1996 Systems Analyst 01/03/1997 Senior Systems Analyst Duties and Responsibility:- User Support System Banking systems. Foreign systems. ATM's. Branch Environment Automation Manager. PC's. EFTPos. Credit & Debit Card production. Data Communication. CARDMAN Issuer and Acquirer. CTL Online authorization system. VISA Payment System MasterCard Payment System Systems Administration & Operations Support Server Model NCR 4300 NCR 3000. NCR Criterion. NCR 9800. MDS 2100. Data Card 310+. VISA V.A.P. VISA Edit package. MasterCard C.C.S. Systems Development System Traveler’s cheque reconciliation module. BEAM foreign WASTE module. BEAM Travelers cheque WASTE module. BEAM punch room data capture formats. ATM bill payment module. Data interface ATM to Host, Host to ATM. Systems Maintenance & Enhancements System Zimbank Online Enquiry System. Banking system - ACS & TCFS. Foreign systems - AIT. Stop orders. BEAM. Debit & Credit Card Management Systems. Installation and Software Support System Novell 2.2, Novell 3.11. AT&T UNIX SVR4. SCO UNIX. Branch Environment Automation Manager. ACS - Zimbank Botswana. Project Lead - ATM network. Project Lead - Card Production Center. Representative to the ZIM-SWITCH technical Committee. Project Lead - Point of Sale Systems. Project Lead - Credit & Debit Card systems. DATA PROCESSING EXPERIENCE High Level Languages - Cobol 74 - VRX COBOL - VRX/E COBOL - MDS Mobol - Dbase 3 Plus - Microsoft Basic - Pascal - C++ Operating Systems - TME Operating System ICL ME29 - NCR VRX - VRX/E - Ms Dos - Netware Ver 2.2 - UNIX SVR4 - UNIX SVR4 MP-RAS - SCO UNIX - Linux Red Hat - Microsoft Office Suite - Windows 98/2000/XP, Windows 7 - Windows NT / 2000 Server, 2003 Server and 2008 Server REFEREES Name: Lerata Motaung Company Name: Emisha Systems working at MTN Period: December 2017 – March 2018 Contact Number: (***)-***-**** Name: Itayi Mandonga Company Name: Real Global Business Solutions working on Oracle projects Period: April 2013 - June 2016 Contact Number: (***)-***-****