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…
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, Mining, Oil and Gas and Postal/Logistics across North America. Comfortable working across finance, procurement, material management and information technology domains. Significant experience working within SAP and business intelligence reporting tools, ETL tools, data, testing and Hypercare/End of Project warranty work. Possess strong leadership, coaching and stakeholder relations skills.
Experience
Team Lead/Manager, SAP BI Front-end Designer/Developer | Persons with Disabilities Advocate | Mental Health Advocate
• 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
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
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
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
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
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.