Louis Matura

Louis Matura

Senior Business Analyst
Canada
English

About Me

An accomplished Senior Business Analyst and Manager with over 25 years’ experience in Business Intelligence, Data Analytics, and Visualization across a variety of industries: Agricultural, Banking/Finance, Government, Mi…

Experience

Team Lead/Manager, SAP BI Front-end Designer/Developer | Persons with Disabilities Advocate | Mental Health Advocate

Accenture
Feb 2013 - Present · 13 years 4 months

• Provided Data, Reporting (development and testing) and Analytic expertise when responding to multiple RFPs (Request for Proposal).
• Selected to provide Hypercare report development expertise in the Canadian agriculture industry.
• Co-managed development team responsible for reporting and analytics, and data team activities with business counterpart (3 onshore and 4 offshore resources).
• Led data mapping projects to migrate data from legacy systems to R3 and S4 tables and views by dissecting core reports.
• Provided expertise on SAP S/4 HANA Fiori reporting, Analysis for Office, and Analytics Cloud and Reporting leading best practices.
• Managed the documentation of configuration rationales and RICEFW functional designs.
• Led the planning, development, analysis, testing and delivery of business intelligence reports and dashboards using Analysis for Office, Analytics Cloud embedded reporting templates, WebI, Tableau, Qlik and Power BI.
• Validated design and testing efforts to confirm that report functionality aligns to business reporting requirements and objectives.
• Ensured GUI’s, parameter inputs and report outputs embodied a standardized corporate look and feel.
• Performed deep dive analysis of core financial, regulatory, and statutory reporting to create a data model for analytics, data visualization and reporting.
• Researched and developed KPIs. Tested and validated report balances with business users to ensure calculations were correct.
• Ensured quality standards were met and in line with business user’s expectations.
• Authored both business and functional requirement documents.
• Demonstrated AFO functionality to end users on how to use production reports for analytics and ad hoc analysis and data visualizations.
• Created and developed training materials and documentation. Provided training for reporting solutions.
• Selected to provide embedded analytics reporting expertise in the US finance/insurance industry.
• Conducted Gap Analysis on new and existing solutions to improve performance reporting.
• Analyzed and communicated report development issues, including issues with data integrity, data design, and functional and technical software issues. Provided solutions on fixing data quality issues to ensure data integrity.
• Gathered, reviewed, analyzed, and evaluated business requirements for data, business intelligence analytic and data visualization and reporting across a variety of business areas

Team Lead/Manager, SAP BI Front-end Designer/Developer | Persons with Disabilities Advocate | Mental Health Advocate

Accenture
Feb 2013 - Oct 2023 · 10 years 8 months

Provided Data, Reporting (development and testing) and Analytic expertise when responding to multiple RFPs (Request for Proposal).
Selected to provide Hypercare report development expertise in the Canadian agriculture industry.
Co-managed development team responsible for reporting and analytics, and data team activities with business counterpart (3 onshore and 4 offshore resources).
Led data mapping projects to migrate data from legacy systems to R3 and S4 tables and views by dissecting core reports.
Provided expertise on SAP S/4 HANA Fiori reporting, Analysis for Office, and Analytics Cloud and Reporting leading best practices.
Managed the documentation of configuration rationales and RICEFW functional designs.
Led the planning, development, analysis, testing and delivery of business intelligence reports and dashboards using Analysis for Office, Analytics Cloud embedded reporting templates, WebI, Tableau, Qlik and Power BI.
Validated design and testing efforts to confirm that report functionality aligns to business reporting requirements and objectives.
Ensured GUI’s, parameter inputs and report outputs embodied a standardized corporate look and feel.
Performed deep dive analysis of core financial, regulatory, and statutory reporting to create a data model for analytics, data visualization and reporting.
Researched and developed KPIs.
Tested and validated report balances with business users to ensure calculations were correct.
Ensured quality standards were met and in line with business user’s expectations.
Authored both business and functional requirement documents.
Demonstrated AFO functionality to end users on how to use production reports for analytics and ad hoc analysis and data visualizations.
Created and developed training materials and documentation.
Provided training for reporting solutions.
Selected to provide embedded analytics reporting expertise in the US finance/insurance industry.
Conducted Gap Analysis on new and existing solutions to improve performance reporting.
Analyzed and communicated report development issues, including issues with data integrity, data design, and functional and technical software issues.
Provided solutions on fixing data quality issues to ensure data integrity.
Gathered, reviewed, analyzed, and evaluated business requirements for data, business intelligence analytic and data visualization and reporting across a variety of business areas from ECC, S4 and Data Lakes.
Developed functional/technical requirements, specifications, and documentation.
Utilized Agile, Waterfall and hybrid development methods.
Consulted with end users, subject matter experts, and cross functional project team members to gather, interpret, analysis, design, develop and document reporting requirements and resolve complex design issues impacting reports.
Developed, led and performed UAT for BEx, BOBJ queries/reports, Fiori, MS Power BI, Access and Tableau to ensure that Client requirements have been met.
Created test scripts and testing plans ensuring all reports and data sources were tested across DEV, QA, Pre-Production and Production environments.
Tested reports utilizing all tables, views, and files.
Analyzed and communicated report development issues, including issues with data integrity, data design, and functional and technical software issues.
Provided solutions on fixing data issues to ensure data integrity.
Worked on various SAP ERP implementations and upgrades developing and designing reporting solutions for FI, CO, SD, PM, WM, MM, CRM, BW, REFX, PS and MDM.

Director/Consultant, Senior SAP BI Functional Business Analyst

1799719 Ontario Limited
Jun 2012 - Jan 2013 · 7 months

Subcontract through Accenture as a Senior SAP BI/BW Functional Analyst.
Trained Power Users for BEx/WebI reporting UAT.
Developed and wrote test scripts.
Responsible for defect tracking and resolution.
Responsible for coordinating testing teams.
Developed functional/technical specifications and requirement documents for SAP reporting in the REFX, IM and PS modules.
Built production-based queries and BOBJ reports.
Developed and defined KPI’s critical to the various business units for core business operations, statutory and regulatory reporting, developing Key Figures as required.
Defined business needs and requirements through interviews, User Group sessions and analyzing current reporting structures.
Provided consolidated weekly status reports to project management office.
Performed training needs analysis for SAP BI reporting tools, developed training documentation and trained the trainer.
Trained, tutored, and on-boarded new project members.

Senior Business Analyst, Client Services

Grantium, CSDC Systems Division
Jul 2011 - May 2012 · 10 months

Gathered and documented As-Is and To-Be business requirements for Grants and Contribution software with all investigative and final documents stored on SharePoint with proper versioning.
Elicited data migration business requirements, guiding clients through the Grantium data migration process.
Evaluated and interpreted client business processes, documenting the corresponding Grantium workflow using MS Visio.
Conducted business needs analysis and gathered requirements through interactive presentations, interviews, and User Group/JAD sessions at the Enterprise and Program levels.
Prepared and delivered business requirement documentation where the solution improved governance, compliance, accessibility, and the automation of client processes.
Developed and performed presentations to clients up to the Vice-Presidential level for US and Canadian Clientele.
Wrote client “How to Prepare For-” documents for corporate presentations to clients to improve the quality of business requirement sessions, to define the scope of the sessions and reduce BRD preparation time by 30%.
Developed and implemented several program/project changes to improve delivery and financial management within the project teams as part of my overall objectives to improve operating margins.
Developed and designed client facing documentation to improve the quality of presentations, provide standardized information to clients and decrease presentation preparation time by 50%.
Designed and wrote Business Analyst documentation.
Development of Standard Project Plan guidelines.
Chairman of Implementation Methodology Enhancement Committee.
Development of roles and responsibility matrix (RACI), analysis and improvement of client facing documentation and Business Analyst toolsets.
Mentor for junior Business Analysts.

Director/Consultant, IT BW/BI Business Analyst

1799719 Ontario Limited
Jan 2010 - Jun 2011 · 1 year 5 months

Gathered and documented As-Is and To-Be business requirements for BI/DW.
Defined stakeholder business needs and requirements through interviews, User Group sessions and utilizing existing information.
Evaluated previously gathered documents and validated their significance.
Identified, analyzed, and documented information for the stakeholder.
Worked as a Level 3 Business Analyst within 2 Federal Government departments.
Gained knowledge of SAP BO and XCelsius.
Gained knowledge of Cognos Report/Query Studio.
Analyzed current reports and capabilities as well as end user needs and requirements.
Evaluated data sources and technologies for the current Datamart.

Officer, IT SAP BW Business Analyst, Enterprise Information Management

Canada Post Corporation
Jan 2000 - Feb 2009 · 9 years 1 month

SAP BW Lead Business Analyst and Project Management.
Member of SAP technical upgrade (to ECC 6.0) project team performing roles within the functional analyst sphere.
Correlated and documented all system changes during the SAP upgrade for R3, OTC, CRM, ERP, FI, CO and BW.
Responsible for the BI/BW component of this project; Facilitating user group sessions, provided status reporting, administration, communications, business requirement documentation and provided findings to the Project Manager.
Conducted GAP analysis for new and existing solutions.
Work closely with stakeholders to define and document applicable business processes and procedures.
Documented, managed, and tracked business, Project and Program requirements.
Created test plans, test scripts, working with stakeholders to monitor test execution while assessing, tracking, managing/tracking/reporting defects.
Produced SAP BI report building training documentation and presented the materials in a classroom environment for Power Users.
Developed product analysis reporting for all Canada Post products for SVP Sales, Marketing, Product and Finance areas including customer and market segment analysis.
Performed monthly trend analysis and 5-year trend analysis and forecasts for volume, revenue and price using historical data, market trends and a variety of historical and forecasted GDP statistics; collecting and analyzing quantitative and qualitative data using statistical techniques to identify patterns and trends.
Developed comprehensive reports and presentations, including actionable recommendations for business strategies and product development.
Conducted market research and analyzed competitor trends, products, and pricing.
Researched, planned, and formulated policies and best practices to ensure the quality and effectiveness of the data warehouse and BI solutions.
Managed change request process to ensure that projects were completed on time and within budget.

Skills

Advanced Business Application Programming - ABAP Access Accounting & Finance System Administration Accounts Receivable (A/R) A/R Collections A/R Management Problem Solving Administrative Activities Analyzing and Maintaining Appropriate Safety Procedures Audit Engagements Back End Bank Procedures Budgeting Skills Business Central Business Communication Business Office Business Plan Writing Business Planning Business Units Chef Configuration Management Client Data Client Goals Code Writing Committee Meetings Company Standards Compensation Consulting Contract Negotiation Contract Requirements Contract Reviews Contracts Requirement Core Network Corporate Accounts Cost Projections Course Structure Creativity Skill Critical Path Current Financial Situation Customer Information Management Customer Specification Client Interaction Daily Operations Coordination Daily Revenue Report Dashboards Data Acquisition Data Base Administration Data Cleansing Data Collection Management Data Scraping Data Conversion Data Entry Data Assessment Data Extraction Data Files Data Governance Data Guard Data Entry Professional Data Integration and ETL Data Investigation Analysis Data Warehouse Design Review Design Development Design Projects Detail-Focused Meticulousness Developer Software Diagnostic Test Management Diagnostic Tools Direct Report Divisional Financial Statements Documentation Process Driver Performance Due Diligence Email Correspondence Employee Relationship Staff Development End User Technical Documentation English (US) Ensure Accuracy Enterprise Resource Planning Equity Analysis Financial Documentation Financial Statement Finance Transformation Financial Accounts Financial Assistant Financial Coordinator Financial Documents Financial Institution Financial Institutions Financial Manager Financial Modeling Financial Modules Financial Objectives Financial Officer Financial Policies Financial Procedures Financial Research Financial Resources Financial Sales Financial Situation Financial Skills Financial Report Financial Statements Financial Reports Financial Support Financial Systems Financial Transactions Full Stack Development Function Test Functional Coverage Functional Specs Functional Testing Functional Verification Fundamental Analysis General Office General Public GIT Version Control (GIT) Glitches or Bugs Goal Setting Good Communication Google Chrome Google Docs Google Earth Hand Tools Hazardous Materials Dangerous Substances High Pressure Installation Skill Installations International Travel Inventory System Managed Analytics Management Skill Abilities Marketing Skills Material Ledger Mathematical Analysis MS Microsoft Access Professional MS Office MS Outlook Multivariate Analytics Negotiation Tactics New Account New Code New Data New Design New Procedures New Technologies Technical Assistance Office Functions OLAP Operations Open Journal Systems Operational Risk Operational Aid Sales Administration Operations & Maintenance Support Organizational Skill Organization Skill Organizational Goals Ownership Reports PC Performance Improvement Activities Performance Reports Planning Skills Policy Changes Freight Administration Asset Administration Optimistic Attitude Proactive Equipment Maintenance Administration Management Procurement Policy Production Enhancement Production Patterns Manufacturing Process Merchandise Knowledge Professional Developments Professional Organizations Professional Relationships Professional Support Profitability Analysis Profitable Business Project Management Project Management Office Project Records Project Safety Project Coordination Project Specifications Development Project Value Project Works Projects Checks Projects Control Proofread Public Records Public Relations Efforts Public Sector and Taxation Public Works Projects Purchase Orders Purchase Agreements Purchase Order Purchase Orders Management Purchasing and Inventory Managements QuickBooks Financial Management Raw Materials Regulatory Documents Release Planning Request for Proposal (RFP) Researching Skill Retail Environments Retail Market RFQ Sales Account Management SAP R/3 4.7 SAP Transformation Service Reports Software Architecture Software Documentation Software Monitoring Software Packages Software Solution Software Systems Software Upgrade Strategy Management Subject Matter Experts System Oversight System Design System Designs System Integration Techniques Task Managements Teaching Skill Employee Evaluation Hospitality Experience Hotel Experience Management Reporting Microsoft Project Post Production Qualitative Analysis Sanitation Data Analysis and Reporting Data Analytics Change Management Monumental Management Experience Leadership Background Crisis Response Executive Management Strategies Business Requirements Functional Requirements Investigation KPI Creation Development Requirements Analysis Requirements Definition RICEFW functional designs Statistical Analysis Ad hoc Report Development Production Report Development Credit Customer Relationship Management Data Analysis Data Analytics Data Conversion and Integration Data Visualization Finance Financial Report Development HPQC Information Management Investment Management JIRA Master Data Materials Management Project Systems Qlik Real Estate Report Development Sales and Distribution SAP Analytics Cloud SAP BI/BW SAP ECC SAP S/4HANA SAP Implementation SAP BEx Query Designer SAP Web Application Designer Statistics System Integration Tableau Testing Troubleshooting User Acceptance Testing Agile Waterfall Hybrid Development Strategies Business Analytics Business Insights Business Processes
Report this Profile?