SQL, PowerBI, IBM Cognos, Excel

RAPHAEL CHIBOTA, MBA

American Fork, UT 801-***-**** ********@*****.*** www.linkedin.com/in/rchibota

Seeking opportunities in Data Analysis, Business Intelligence, or Risk Analysis.

SKILLS

•SQL (SQL Server, MySQL, Oracle & PL/SQL )

•Tableau

•Open Text eDOCS (Hummingbird)

•SharePoint

•SQL/Oracle Database Administrator

•IBM Cognos

•Excel (VLookup, Conditional Formatting, Pivot Tables)

•Microsoft Power BI

•SPSS (IBM Statistical Analysis Tool)

•Highly collaborative with team members

•Able to work independently

•Able to effectively prioritize work

•Strong organizational ethics & integrity

EXPERIENCE

Glacier Bancorp, American Fork, Utah, USA

Corporate Risk Analyst

Oct 2021 – Current

Develop and maintain Key Risk Indicator (KRI), Risk Profile, and Risk Appetite reports through the use of Excel, SQL, IBM Cognos, Power BI and other analytical tools.

Analyze reports to make sure the bank operates within the risk appetite framework, escalating deviances to management for corrective action.

Perform root cause analysis in cases of fraud or loss to determine if key risks have been overlooked or if controls need to be strengthened

Review vendor management data to identify and report any significant risks related to vendor relationships – with special focus on IT-related vendors.

Track progress of mitigation activities underway to address new regulations, regulatory issues, and audit findings; liaise and assist finding owners in rectifying gaps and meeting deadlines.

Provide dashboards that easily communicate the risk posture of the bank to senior management and the Board of Directors.

Altabank (a division of Glacier Bancorp), American Fork, Utah, USA

Enterprise Risk Analyst

Sep 2016 – Sep 2021

Made use of Excel, SQL, IBM Cognos, and Power BI to track fraud losses so as to identify areas of weakness to strengthen controls.

Helped law enforcement to analyze video footage of perpetrators when there was fraud.

Managed physical access to buildings by issuing and monitoring the use of access cards.

Reviewed access logs of the various IT systems to make sure that terminated employees were timely removed from the systems.

Utah Valley University, Orem, Utah, USA

MBA Graduate Assistant

Aug 16, 2015 – Jul 31, 2016

Used Excel functions and Access database tools to increase efficiency in manipulation of data for networking and the development of community business partnerships.

Acquired and utilized new Qualtrics and SPSS analytical tools for data collection and analysis to improve evaluation of customers, competitors and market trends.

Developed and applied creativity and innovative problem-solving skills to real-world consulting projects which promptly increased value to the client outcomes. The university offered free consulting service on projects to companies as part of learning.

Britehouse, Johannesburg, South Africa (Provides industry-leading digital solutions in Africa)

Senior ECM Consultant

Apr 1, 2014 – Jul 31, 2015

Provided roadmaps and strategies to companies on how to leverage Microsoft SharePoint as an effective data analytical tool to obtain best ROI of using the product.

Improved morale and team performance by encouraging learning and knowledge sharing data analysis techniques within the team.

Implemented Data management systems in Oracle and SQL server

Created Business Intelligence (BI) dashboards and reports using Power BI, Cognos, and other visualization and analytic tools.

Leveraged SQL to create ad hoc reports and analysis on budgeting, planning, financial reporting and others.

Business Connexion, Johannesburg, South Africa

(The Leading Enabler of The Internet of Things in Africa)

Senior ECM Consultant

Jul 11, 2011 – Mar 31, 2014

Implemented digital signatures and workflows at the Central Bank of Lesotho which cut paper usage by more than 80% and increased processing efficiency.

Created BI dashboards and reports using Cognos and other visualization & analytical tools.

Created ad hoc reports and responded to analysis needs by pulling data using SQL.

The Cotton Company, Harare, Zimbabwe

(The largest cotton processing and marketing in Southern Africa)

Group IT Systems Administrator

Jun 1, 1994 – Aug 31, 2007

Previous Roles: Software Analyst, Analyst Programmer, Systems Administrator.

Managed patch management to make sure systems were protected from zero-day vulnerabilities.

Administered Oracle and SQL Server databases as well as other systems.

Maintained a 99% level of IT systems availability at head office, at 8 branches and subsidiaries and led a team of IT Professionals of 10 people.

Designed, configured, and implemented user access controls.

Performed troubleshooting and resolved system performance issues

Implemented Data Management systems in Oracle and SQL server

Trained users on how to create easy-to-read dashboards and reports using visualization and analytical tools like Excel.

Developed input Oracle forms using PL/SQL to automate a lot of the manual processes captured in Excel.

CERTIFICATIONS

ABA Certificate in Operational Risk Management: The American Bankers Association

Mar 2020

Advanced Solutions of Microsoft SharePoint Server 2013

Jan 2014

Open Text Livelink Certified Administrator

Jul 2008

EDUCATION

MBA: Utah Valley University

Aug 2016

Management Development Program: University of Stellenbosch

May 2013

Bachelor of Science, Information Systems: BYU-Hawaii

Jun 1993

Contact this candidate