SUMMARY:

• Extensive years of experience in Data Reporting/Business Analytics, Data Management.
• Genuinely flexible individual possessing an MSc in Business Computing and BSc in Accounting, combining comprehensive technical competence with strong numerical ability
• Designed data structures using SQL and Excel for business intelligence and reporting which include but not limited to GLs, loan, deposit, growth, variance and trends via dashboards.
• Data gathering, cleansing, modelling, Profiling, documentation and evaluation of system specifications for business requirements.
• Performing against KPI and SLA targets in terms of issue response and resolution times.
• Run SQL queries and output result set to Excel for various analyses.
• Maintained proficiency with respect to SAS programming and statistical methodology.
• Data Mapping, Migration/integration and profiling with analysis and reporting functions using SSIS, SSAS and SSRS.
• Provide data, write SQL queries for data manipulation and also generate/build reports via SQL from data warehouse.
• Ensure routine data backups on Oracle and SQL servers are performed as outlined by the Backup & Restore Manual.
• Used Tableau desktop and Confidential to explore, visualize, analyze and create dashboards to consolidate views for the management as requested, pulling out the reports as needed.
• Responsible for the translation of the Business Requirements into clear IT Systems Requirements.
• Designed financial data structures in Confidential excel and analyze/report using power point and Think - cell.

CORE COMPETENCIES:

• Rapid acclimatization to new business sectors, operating environments, processes and terminology.
• Business Systems Modelling, Databases for Enterprise, Business Intelligence (SAS), Technology Entrepreneurship, IT Project Management and IT Strategic Planning.
• Seamless integration into any team of staff, comfortable leading or working autonomously on projects.
• Customer service focused, able to communicate complex concepts to non-technical individuals.
• Design, implementation and support of business information systems (Oracle and SAP).

TECHNICAL SKILLS:

Database Systems: Oracle, SQL Server, Sybase and MySQL relational database management systems.

Tools: SQL, PL/SQL, MS- Office (Excel, PowerPoint, Access, Word, Visio, Project ), WebEx, VPN, Oracle Forms, Think cell, Confidential, SAS,Tableau, Business Object

PROFESSIONAL EXPERIENCE:

Confidential

Business Data Analyst

Responsibilities:

• Delivering a comprehensive Techno-Functional/ MIS role as well as managing modules, functional and technical requests on Oracle-Flexcube (Core banking application) and other external applications of the bank.
• Provide data, use SQL queries for data manipulation and also generate/build reports from various databases
• Ensure routine data backups on Oracle and SQL servers are performed as outlined by the Backup & Restore Manual
• Successfully implemented, tested and Go-Live of Oracle EBS and Oracle Flexcube from Oracle FCR.
• Data modelling, mapping, migration/integration and profiling in line with business requirement
• Analysis and reporting functions using SSIS, SSAS and SSRS.
• Implemented and supported Products (Investment, deposit, loan), Account classes, Interest and charges, GLs, Branches, Card bins (Visa, master and verve), Transaction Codes and MIS modules on Flexcube (Oracle) and also supported users.
• Provided training, functional support and also developed a comprehensive documentation for procedure manual, system, enhancements and business cases supporting the development needs on Oracle Flexcube UBS 12.0 modules, Oracle EBS and Confidential data warehouse
• Meetings, Local and remote support using VPN and webEx connection to an ITIL-aligned process within SLAs
• Used Confidential and Business Object to explore, visualize, analyze and create dashboards to consolidate views for the management, branches, marketers, Investment, finance, HR and Cards business partners for decision making.
• Ensures back-end and front-end synchronization and also troubleshoots and analyzes code to find root cause of errors
• Connected Tableau desktop to a Confidential SQL Server database and set up the data source for calculation and analysis visualization
• Development of functions, procedures, triggers & packages using SQL to implement business logic
• Reviews and analysis of business performance and operational efficiency

Confidential

Senior Business Data Analyst

Responsibilities:

• Data gathering, modelling, profiling, documentation and evaluation of system specifications for business requirements.
• Develops and implements comprehensive test plans to ensure that systems and programs are tested and debugged.
• Determines proper installation parameters for software and hardware, for smooth integration, change and efficiency
• Run SQL queries and output result set to Excel for various analyses.
• Worked closely with management to prioritize business goals and information needs.

Confidential

Application / Data Analyst

Responsibilities:

• Providing all level application support and resolution management within health public sector setting
• Working within a multi-platform, mixed operating system environment (Unix/Linux)
• Performing against KPI and SLA targets in terms of issue response and resolution times
• Data gathering, documentation and evaluation of system specifications for business requirements
• Develops and implements comprehensive test plans to ensure that systems and programs are tested and debugged
• Determines proper installation parameters for software and hardware, for smooth integration, change and efficiency
• Works closely with management to prioritize business goals and information needs
• Supporting data security policy through maintenance of Oracle user accounts and access permissions
• System performance monitoring including error analysis and security monitoring
• Operating in line with defined service management frameworks; following procedures for call logging, prioritization of issues/incidents, managing user expectations and reporting
• Contributed to driving system improvements, reported recurring issues through appropriate channels
• Liaising with ICT department in resolving hardware failures affecting the operation of Oracle including escalating significant disruption incidents and ensuring effective user communication
• Conducting data cleansing, integrity checking, updating system documentation and relevant procedures
• Provide data and also generate ad-hoc reports from crystal, Oracle and MSSQL databases as required

Confidential

Systems/Reporting Analyst

Responsibilities:

• Delivering comprehensive IT support to over 3000 user-base within this major financial service provider by ensuring that all incidents/service requests are logged, documented and prioritized with progress effectively conversed back to users.
• Run SQL queries and output result set to Excel for various analyses.
• Meeting, Local and remote desktop support using VPN and webEx connection to an ITIL-aligned process within SLAs
• Installation of computer hardware and peripherals; managing infrastructure and software deployment processes
• Application support (Astra, Remedy, Tivoli, Exchange/Outlook, Oracle), plus UAT of new applications
• Identifying trends and escalating incidents to both internal and external (System providers) parties as required by strict procedures and advising senior management and colleagues
• Network administration via Active Desktop, Windows XP/7 OS builds and knowledge of shell scripting
• Identifying potential system failures and weaknesses and proactively advice management on course of action

Confidential

Systems/Data Analyst

Responsibilities:

• Responsible for the translation of the Business Requirements into clear IT Systems Requirements.
• Used Tableau desktop to explore, visualize, analyze and create dashboards to consolidate views for the management as requested, pulling out the reports as needed.
• Responded to department requests for financial data, providing financial expertise in Project Management
• Coding of system data and also ensured that all system-related reporting issues were resolved promptly.
• Continual measurement of company performance against agreed strategic business plan.
• Designed and produced reports with detailed commentary and variance/trend analysis, identifying areas of potential improvement and highlighting risks for the purpose of business intelligence via manipulation of data on SAS
• Assisted with the automation of common tasks to secure increased in efficiency
• Coordinated software and system test which include preparation of acceptance test plans, test planning, test execution, and monitoring and oversight of test execution

Confidential

Financial Data Analyst

Responsibilities:

• Maintained accounting records and prepared management accounts
• Established and integrated new investments into existing systems and processes
• Monitored existing investments, primarily through analysis and interpretation of financial information
• Designed financial data structures in Confidential excel and analyze/report using power point and Think-cell

Confidential

Data/Reporting Analyst

Responsibilities:

• Produced performance reports of the strategic business unit and provided financial advice based on the performance; reviewed the performance against budget and communicated the variance to the management
• Assessed the credit-worthiness of client companies; underwriting loan modification, renewal, and extension requests using bank credit policies to spread customers’ financial statements in order to determine the financial position of borrowing customers, measuring risk in the business to avoid unnecessary exposure

Confidential

Data & Reporting Analyst

Responsibilities:

• Maintained knowledge of compliance to ensure deliverables consistently met regulatory requirements
• Designed data structures using SQL and Excel for business intelligence and reporting which include but not limited to GL balances in investment portfolio, loan, deposit, variance and trends via dashboards.
• Appraised transactions and verified if executed transactions were conducted under appropriate approvals.
• Balance sheet /income data monitoring and also supervised the Inventory and tagging of assets acquisition
• Provided data for external auditors - Confidential during audit process