Takawira

 Patterson T. Sanganza Mobile: - WhatsApp:- Certifictions: AWS Solutions Architect Associate- StackSkills Amazon Web Services: Data Analytics-LinkedIn CERTIFIED AWS CLOUD PRACTITIONER-Amazon Web Services 11/22 Professional Summary: More than 10 years of Financial GAAP Accounting, Audit, Consulting on Tableau, Obiee and Power BI, Financial Analysis, Business Intelligence and Financial Reporting /developer experience and 6 years in the IT field industry as BI professional. Ad hoc and regular Reporting at executive and leadership level Presentation of insights in excel and power point to leadership team. Pursuing DevOps certification Strong GAAP and Financial analysis background. Validation and end to end audit of sample financial transactions in various ERP modules. Strong CRM (Salesforce) and negotiation experience SQL query of various operational and relational databases Advanced Excel formatting skills using formulas, macros, V-lookups. More than 6 years’ experience leveraging OBIEE in an OLAP environment. Master Data and Data Quality Management and Data profiling ability Automating/Scheduling Hyperion Financial, BI Publisher, Crystal and OBIEE Reports Strong background in Leading, Organizing and Managing Work teams. 7 years of Oracle Operational Financial Applications (Sales, Project‘N Grants module, OM, Supply Chain, AR, HCM, AP, FA, PA, GL) and Hyperion experience Troubleshooting, data, network, database and, accounting issues in Oracle/Peoplesoft modules (AP, Billing, AR, FA, Inventory, PA Experience in regulatory reporting requirements for the FAA. Used predictive intelligence tool data (Cortana)to build dashboards visualizations. Preparing Functional Report Design documents Assisting external auditors with reconciliations and preparing work schedules Collaborate in source to target mapping design documents for ETL. Knowledgeable in working with Hyperion financial reporting, Oracle Discoverer and the OBIEE Repository Analytics (Answers, Dashboards, Delivers and BI Publisher), Oracle Transactional Business Intelligence (OTBI) ns Smart View and Excel Calculating Net Present Value (NPV, IRR, DCF), discounted cash flow, Internal rate of return and payback on investments Exposed to Oracle Business Intelligence and performed proof of concepts OBIA(BIAPPS), on Oracle BI publisher. I was responsible for implementing Financial Analytics (Sales, Projects,General Ledger, Account Receivables, Purchasing, Accounts Payables & Profitability) of Oracle Business Intelligence applications 7.9.5.1 on top of existing Oracle EBS Suite R12 & Customized existing prebuilt dashboards and developed new dashboard according to the user requirements. Oracle Cloud Hyperion Financial reporting Participation in Oracle/PeopleSoft ERP upgrade discussions Participation in Oracle/PeopleSoft/ SAP ERP UAT and Performance testing of modules; AP, AR, HCM, PA, FA, GL, and Oracle Supply Chain modules Conduct User Acceptance testing. Tableau server administration Conduct Unite Testing on EBS modules. Skills: Accounting and Audit FA, AP, PA &SCM RECONCILIATIONS, including 2/3-way matching. Oracle Cloud; EBS; D365;Peoplesoft and SAP Journal entries and accounting reconciliation. Purchases, Inventory and General ledger accounting Business Analysis Data validation Data Analytics Managing project Data mapping Vendor Management VLOOKUP Excel Project Costing and management Tableau OBIEE Coupa Power BI, Cognos Visualizations Documentation Scheduling Snowflakes Alteryx OLA OLTP Visio EBS CRM SQL Database JIRA QuickBooks ServiceNow Agile AWS Oracle SAP Cloud Oracle 11i, R12 Excel OBIEE CRM SQL Database JIRA ServiceNow Agile AWS Oracle SAP ERP Excel OBIEE Education: MBA-Finance -DeVry University 2000 BS-Accounting-University of Zimbabwe Professional Experience: Data Piper July ’24-Current Business Analyst and Applications support DevOps Project support Agile and Sprint coordination Reporting applications prod. support ;Power BI, Tableau, OBIEE, Cognos etc) BRD, FDD and TDD prep and support Data analysis and Financial analysis Financial Reporting and support in Power BI, Cognos and Tableau. Infosys@ Bayer, Cisco and Truist, BOA, Atlanta, GA Feb-2019-Oct’23 Business Intelligence Analyst & Incident management JD Edwards, SAP, Oracle Projects, and Peoplesoft support HR, AP modules & BI Production support of over five thousand (five thousand) users of BI Tableau, OBIEE and Cognos) and AWS hosted applications. Requirements gathering of business processes and data artifacts for development and process improvements. SQL queries on data tables for specific subject area. Regular and periodic Financial, performance and Regulatory Analytic reporting of sales (Bayer) of drugs in the Marketing BU. Management of vendor accounts; reconciliation, opening and closing Well versed in micro and macroeconomic indicators affecting various economies. I appreciate various models of valuing (assets) equities and cash flows; Price earning, DCF, Payback and Net Present value techniques. Oracle EPM reporting and budget and variance analysis. Financial statement analysis and reporting to stakeholders and executives. Power point presentations at Executive and leadership team. Accounts receivable Aging and reporting, Pivot table analysis Forecasting and providing micro and macroeconomic commentary. Use of financial and accounting ratios to evaluate performance. Leading offshore and onshore teams on Project deliverables. Basic Python queries Data manipulation and cleansing with Alteryx. Rebate and re-imbursements analysis across Pharmacies and other third parties. Reported on Bayer sales to independent distributors. Reconcile Coupa invoices and match with Purchase orders. Run monthly reporting on Coupa generated invoices/spend as well as on other ERP, third party integration platform (Ariba etc.) Reconciliation of Project module costs with General ledger. Fund accounting and reconciliation. Continuous improvement of portfolio of product, namely reports, dashboards and customer (business unit) liaison and support. A strong champion of company products Team player and collaborator Monthly close journal entries, trial balance runs and reconciliations. Report and analysis creation in OBIEE, Tableau and Cognos. Data Analysis and requirements gathering Workday reporting, Prism analytics and data base SQL querying Data query and reporting on Projects and Transactional data, retrieval with SQL. Managing and monitoring Applications/Informatica workflows, observability, and dashboard metrics through AppDynamics, Geneos and Dynatrace platforms Regulatory reporting of Bayer sales of drugs in the Marketing BU. Reporting on Bayer sales to independent distributors Migration of developed rpd in OBIEE and Qlik sense Use of and monitoring of Informatica workflows and database migration tool jobs to move data from source to target databases. Support Bayer Oracle SCM reporting and visualization dashboards; Order management, Inventory and Warehouse management. Documenting data assets, data lineage, ownership, and Cyber Risk and IAM reporting lineage through graphical representation and flow chart diagrams. IT asset life cycle asset management, reporting and reviews through Service Now and service now reporting. Supporting Oracle HR, AP, PA, FA, billing, AR, Finance and other corporate business units in Dev and QA of new initiatives and running reporting in Oracle Transactional Business Intelligence (OTBI), OBIEE and Smart View. Oracle Cloud procures to pay audit and procure to pay processes testing. I have worked in Oracle fusion cloud application suite, focusing on procurement, order management and ERP analytics. Participated in requisitioning, Purchase order creation, PO approval, PO/Invoice matching and payments. Reporting on BI Publisher, Power BI on functional BU like Finance, PA, HR, Inventory etc. ServiceNow dashboard, reporting and Problem management. Monitoring AWS instances using Amazon Cloud watch. Managing Production support team in Agile framework and adhering to ITIL framework Documentation of requirements, version control and management of requirements and artifacts in ticketing and document systems like JIRA, ServiceNow and Confluence Data Analysis and requirements gathering. Manage support team/developers, prioritize work, and coordinate work tasks with Client/Application/Business owner. Ticket handling, status updates in ServiceNow. General administration of Tableau BI platform, running publish schedules adding users, and groups. Creating Alerts on Tableau BI metrics Managing and mentoring team on ITIL processes, communication protocols and SLA resolution guidelines and timelines IT Infrastructure handling, coordination, and Application owner discussions as part of disaster recovery Running queries on snowflakes database Supporting Tableau server hosted on AWS. Migration of app packages in Harvest from DEV to QA& Production Create data visualizations, dashboards and other financial reports using Tableau, OBIEE and Power BI. Processing weekly, monthly, and yearly sales report files received securely through sftp servers and updating SQL server database views and shared cloud folders. Storytelling and dashboard editing in Tableau desktop/server. Tableau server administration; user’s/ group edits; etc. Server Monitoring in QlikView QMC and Dashboard & tasks refresh Making presentations to team and higher executives in power point on new AWS initiatives and strategy. Workbook & Performance administration Follow up on and resolving all Jira tickets to avoid SLA violations. Uploading of requirement documentation on Bayer and Infosys SharePoint Incident management using ServiceNow and Jira and Harvest package migration. Provide ad hoc financial analysis on sales compensation, SLAs, sales market &geographic metrics, and sales growth opportunities. Blending data from disparate data sources in Tableau based on common dimensions. Liaise with data governance teams on dimension use and reporting strategy on reports. Collaborate and share documents with team members in Confluence, SharePoint, PowerPoint and ticket and project tracking in Jira and ServiceNow Deployment of changes and enhancement to production and oversight of patching, upgrades of software and Change management board oversight. Production support monitoring and support of ETL and Cognos, QlikView and OBIEE server instances. DELOITTE CONSLTNG-Atlanta GA April 2017 –Dec-18 Oracle R12 EBS Accounting Support & Business Intelligence (OBIEE) Financial analysis of payments, purchase orders, payables, and cash flows Performing pivot table analysis in excel of reports downloaded from BI applications. Project cost allocation and analysis Project accounting and transfer to Fixed assets of completed Projects Stores and Inventory stock take and GL reconciliations. Reporting on actuals and budget variance analysis Reconciling subledger balances to General ledger Hyperion Enterprise financial management reporting Running reports in various subject areas; Oracle billing, AR, AP, OM, Inventory, PA, HCM/Payroll, FA, P2P Ad hoc SQL queries for transactional research and reporting Reconciling Commitments, Obligations, Purchase Orders and Payable invoices Report on cash inflows of project and perform payback and IRR analysis on new project proposals. Data Analysis and requirements gathering Ad hoc report analysis and creation in Obiee and Workday for HR, Finance, Payables, and procurement teams Data query and report retrieval with SQL and visualization with OBIEE Procure to pay process validation. Querying the production database tables using Toad Assist with month end close reconciliation. Strong adherence to client SLA agreement and delivery timelines Adherence to ITIL/ITSM standards Strong reconciliation experience in OM/PA, Inventory and AP ETL workflow support and business intelligence application support Business Analysis and use case analysis. Reporting and visualizations and storytelling using OBIEE, Tableau and QlikView Assist the client associates with data issues and fixes. New set ups for new or edits of functionalities in Teradata, Oracle R12 Compiling status reports Monitor ETL loads and troubleshoot. Prepare Answers reports in OBIEE. Deutsche Bank-Jacksonville FL Aug-2016 –April-2017 Service Management Analyst the Business Analyst interface for all Deutsche Bank’s front, middle, capital markets and back-office client facing and trading businesses. Basic Unix commands ensure the stable running of the technology platform. Support Oracle/SAP nightly ETLworkflows/ batches and year end accounting production reconciliations and outages! Investigations and reconciliation of payments and chargebacks Monitoring capital markets data loads and reporting on Informatica workflow interruptions. Monitoring applications, databases, market data and network infrastructure performance through Geneos alerts and statistics on geneos dashboards/visualizations. Providing proactive and reactive support to the Capital markets and Fixed Income business and its clients whilst working closely with development and product management teams. primary contact point for all technical issues, the team has high exposure to and work with the clients & client facing teams daily. Use multiple sources of information for root cause analysis (e.g., log files, error messages, user feedback). Support experience on Capital markets trading applications/client connectivity/market connectivity. ITIL framework adherence Incident management – Handle high priority incident tickets, work with members of the team and developers to resolve incidents, ensuring that affected users & management are always kept informed. Continual Service Management Process Improvement - Identify process improvements in the regional and global support models and assist in implementation, work with project managers on the introduction and supportability of new services and systems. Technology platform monitoring, new developments & enhancements/change management, and sign offs Participate in disaster recovery test activities as part of risk management. Management of IT assets to mitigate against business risks; regulatory, financial, market, reputational. ACCENTURE-ATLANTA GA Apr 2015 –April-2016 SENIOR SYSTEMS CONSULTANT Consult on OBIA Business Intelligence and ERP Integration Implementations Conduct workshops with business users to gather EBS module specific requirements, Oracle & PeopleSoft Adherence to best practice in recommending solutions to EBS module implementations; AP, AR, PA, FA, SCM etc. Custom report development for internal clients Schedule report alerts(ibots) for internal clients Functional knowledge in Accounting and Finance EBS (Oracle, PeopleSoft, and SAP) knowledge Supporting Inventory, Order management and the whole supply chain processes (SCM) in the organization PeopleSoft 9.0 QA testing of EBS modules. Production support of Peoplesoft/Oracle BI and ETL applications per ITIL/ITSM models; OBIEE and Informatica Use of Talend Data Profiling Tool to validate quality of Data in database Tables. Validate Data sources before data load into target tables. Create new customized DataMart for OBIEE reporting out of multiple source tables(databases) including Oracle R12 Implementation of OBIEE, Alteryx, Tableau, Qlikview and other Big Data analytics Facilitate creation of Conceptual, Logical and Physical Data model Big Data and Hadoop configurations Internal and External Client support on reporting, dashboard, and query performance. Engaging with clients to deliver Value propositions on various projects. Introduction of new innovative tools to clients to drive growth and market share. Requirements gathering for BI APS on PeopleSoft and Oracle ERP Requirements gathering for ERP upgrades and enhancements and Reports Functional design. Data Analysis and manipulation with SQL, Pig, Hive, and Impala Financial Analysis with excel. Pivot tables and Visualization. Report/Metric Fit Gap analysis. INVESCO Apr 2014 –Mar-2015 SENIOR OPERATIONS ANALYST-BUSINESS INTELLIGENCE-HOUSTON TX Oracle EBS Quality assurance testing on AP, AR, PA, and FA Participated in handling broker requests in capital market distribution business unit. Validation/Reconciliation of Oracle billing and revenue collection and reporting Troubleshooting Autosys and DAC scheduled jobs for Capital markets data marts. ServiceNow ticket handling and Informatica troubleshooting. Ensuring that ALL scheduled Production Autosys/DAC Box Jobs complete to Success. ETL Informatica design changes, workflow monitoring and troubleshooting Monitoring Applications and loads using Informatica Workflow monitor, Genos, Splunk, Dynatrace, Oracle OBIEE, Grafana Tempo and troubleshooting front end BI tools/Applications and addressing front end user/customer issues. Test BI (OBIEE) code design in Dev, UAT and Production Test ETL (INFORMATICA) code design in Dev, UAT and Production Monitoring, start, re-starting and marking jobs in Informatica DAC and AUTOSYS to ensure that there are no disruptions to Production. Participate in CM/Change Management initiatives and scheduling code changes in the Change Management Module/ServiceNow Participated in QA initiatives for PeopleSoft 9.0 and ORACLE R12 EBS implementations. Extensive Financial and Accounting reporting and analysis experience Internal and External Client support on reporting, dashboard, and query performance. Reporting on trades for the week and month in the Capital market business unit, as well as Data Analysis Monitoring BI Applications (OBIEE) performance issues as well as Oracle/SQL Server database issues Constant and frequent liaison with DBAs and front-end users to ensure productions bottlenecks are removed and solved. Root cause analysis and IT Problem management. Documentation of IT problems/issues and monitoring until resolution Strong adherence to ITSM/ITIL models Collaborate with clients on MDM initiatives and advise on same to achieve data consistency. Suggesting BI performance improvements through code design changes and Data modeling designs. Continuous learning of SQL, SQL SERVER, Oracle, OBIEE and PL/SQL Continuous learning of Performance Tuning in Oracle and SQL SERVER data bases Preparing batch JIL scripts that call Informatica Workflows Design Informatica Mappings, tasks, and Workflows. Excellent client service skills and ability to work well in a fast-paced Investment/Trading environment. BROOKFIELD CONSULTING-ATLANTA GA Sept 2013-Apr 2014 CONTRACTOR Projects and grants and construction/project accounting in JD Edwards. End to end audit of financial transactions. Preparation of journal entries, positing, and validation of same Assisting external auditors with enquiries. Worked on OBIEE Answers to build Interactive dashboards with drill-down capabilities. Created several answers reports and then dashboard with reports links. Creating excel reports with analysis and VLOOKUP, lookup ups and what if scenarios and formulae. On reports, used case statements, several expressions, and tried unions. Used column properties to create custom columns, labels, and formatting. Created numerous reports using table view, pivot table, chart view, column selector, view selector, and narrative views as business demands. Utilizing SQL and Business OBIEE ANSWERS/Objects (BO) INFOVIEW to facilitate client reporting requirements. Extensive Financial and Accounting reporting and analysis experience Internal and External Client support on reporting, dashboard, and query performance