Daniel Fernandes
Edmonton,AB
Summary
Senior business analysis professional with 13 years of experience, specializing in transformative projects within healthcare and technology. Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills.
Overview
17
17
years of professional experience
Work History
Senior Project Business Analysts
Alberta Health Services
04.2019 - Current
- Conducted interviews with key business users to collect information on business processes and user requirements.
- Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.
- Improved business direction by prioritizing customers and implementing changes based on collected feedback.
- Analyzed key aspects of business to evaluate factors driving results and summarized into presentations.
- Performed gap analysis to identify areas of improvement.
- Generated business intelligence reports to inform strategic decision-making.
- Drafted reports on company financial metrics to assess successes and account for deficiencies.
- Assessed business requirements to forecast annual budgetary operational costs.
- Executed analysis of risks and identified risk mitigation strategies.
- Interacted with internal customers to understand business needs and translate into requirements and project scope.
- Collaborated with teams in product line transition to streamline manufacturing footprint.
- Developed customized reports, summarizing and presenting data in visually appealing format.
- Optimized data access and storage to improve performance of analytics systems.
- Collaborated with stakeholders to identify business needs and data sources.
- Assisted with creating data cubes and OLAP models to improve data analysis.
- Developed data mining algorithms to identify and classify patterns in data.
- Developed and maintained data warehouses and data marts to support business operations.
- Implemented business intelligence solutions to increase operational efficiency.
- Developed and implemented data governance policies and procedures.
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
- Developed complex dashboard and reporting tools to track business performance metrics.
- Generated standard and custom reports to provide insights into business performance.
- Designed and developed data pipelines to acquire, clean and process data.
- Created data models to support decision-making processes.
- Provided technical support for troubleshooting analytics and reporting issues.
- Created dashboards to monitor and track key performance indicators.
- Analyzed data to identify root causes of problems and recommend corrective actions.
Senior Business Analyst
Alberta Public School Board
06.2018 - 03.2019
- Worked with team leads and managing leadership, establishing robust talent pool with focus on people and continuous improvement.
- Supported leadership team with reporting, analysis, and business presentations to inform divisional strategies.
- Reduced corporate expenses by streamlining incentive and demand processes across regions.
- Developed diverse reporting packages to meet individual needs of sales, marketing, product management and senior leadership.
- Collaborated with internal business partners to implement commission arrangements.
- Created new analytical systems to boost vital business metrics visibility.
- Guided teams and refined Agile techniques throughout journey and evolution of delivery cycles, establishing documentation framework to support Agile methodology implementation with Waterfall-centric delivery team.
- Analyzed performance metrics to identify opportunities to increase sales.
- Analyzed key aspects of business to evaluate factors driving results and summarized into presentations.
- Improved business direction by prioritizing customers and implementing changes based on collected feedback.
- Executed analysis of risks and identified risk mitigation strategies.
- Generated business intelligence reports to inform strategic decision-making.
- Performed gap analysis to identify areas of improvement.
- Drafted reports on company financial metrics to assess successes and account for deficiencies.
- Produced monthly reports using advanced Excel spreadsheet functions.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Identified, analyzed and interpreted trends or patterns in complex data sets.
- Tested data prediction algorithms based on historical data.
- Worked with business intelligence software and various reports to glean insights into trends and prospects.
- Documented effective and replicable methods for extracting data and organizing data sources.
Business Analyst
Edmonton Catholic Schools
07.2017 - 05.2018
- Conducted interviews with key business users to collect information on business processes and user requirements.
- Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.
- Collaborated with stakeholders to define project objectives and criteria.
- Assessed business requirements to forecast annual budgetary operational costs.
- Interacted with internal customers to understand business needs and translate into requirements and project scope.
- Drafted reports on company financial metrics to assess successes and account for deficiencies.
- Utilized data visualization techniques to present and explain complex data sets.
- Created data models to support decision-making processes.
- Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.
- Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
- Designed customized data collection models for specific visualization tasks.
- Created data analysis tools to allow teams to query acquired information for unique details.
Business Analyst
Design Group Staffing (DGSI)
11.2014 - 06.2017
- Performed gap analysis to identify areas of improvement.
- Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.
- Assessed business requirements to forecast annual budgetary operational costs.
- Provided technical support for troubleshooting analytics and reporting issues.
- Collaborated with stakeholders to identify business needs and data sources.
- Created dashboards to monitor and track key performance indicators.
- Consulted with internal personnel to develop information systems strategies, tailoring technology purchasing, and installation roadmaps to meet users' unique needs.
- Created detailed [Type] reports from [Type] research for review by development team.
- Supported new project initiatives by analyzing preliminary business needs and defining factors such as budget constraints, time management and resource planning.
- Provided hands-on troubleshooting for issues at multiple scales, from individual systems to multi-site infrastructure.
- Assisted development staff with drafting project plans, advising personnel on milestone planning.
- Authored documentation on technology implementation strategies and best practices to optimize spending and IT staff deployment.
- Exercised critical thinking to resolve [Type] error in [Type] reports.
- Produced charts and diagrams to assist with problem analysis.
- Gathered, reviewed and reported on findings.
- Installed system updates to address vulnerabilities and reduce security issues.
- Enhanced and reconstructed computer systems to increase efficiency.
- Collected, defined and analyzed business requirements.
- Trained business personnel in use of systems.
- Assessed business requirements to create focused solutions.
- Developed diagrams to describe and lay out logical operational steps.
Business Systems Analyst
Workers Compensation Board (WCB)
04.2014 - 10.2014
- Organized system operating procedures to strengthen controls.
- Identified needed business improvements and determined appropriate systems required to implement solutions.
- Assessed business requirements to create focused solutions.
- Helped deploy system enhancements to improve field operations.
- Trained business personnel in use of systems.
- Installed system updates to address vulnerabilities and reduce security issues.
- Improved systems with addition of new features and infrastructure.
- Developed diagrams to describe and lay out logical operational steps.
- Tracked feedback at all levels and researched resolutions for common concerns.
- Monitored employee tasks to gauge business functions and inefficiencies.
- Collected, defined and analyzed business requirements.
Junior Business Analyst
ATB Financial
03.2013 - 03.2014
- Created detailed [Type] reports from [Type] research for review by development team.
- Exercised critical thinking to resolve [Type] error in [Type] reports.
- Worked one-on-one with clients to improve [Type] specifications.
- Conducted interviews with key business users to collect information on business processes and user requirements.
- Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.
- Generated business intelligence reports to inform strategic decision-making.
- Collaborated with stakeholders to define project objectives and criteria.
- Performed gap analysis to identify areas of improvement.
- Interacted with internal customers to understand business needs and translate into requirements and project scope.
- Assessed business requirements to forecast annual budgetary operational costs.
Business Support Analyst
ATB Financial
06.2009 - 02.2013
- Identified and managed service risks within company, recommending best practice enhancements and guidelines updates.
- Rendered on-demand support to senior leadership, connecting executives with appropriate management personnel to address concerns.
- Held meetings to communicate new policies and procedures to appropriate personnel.
- Designed onboarding process for new personnel, expediting full operational competency through standardized curricula.
- Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.
- Analyzed open orders, backlog, and sales data to provide sales team with insights.
- Conducted interviews with key business users to collect information on business processes and user requirements.
- Executed analysis of risks and identified risk mitigation strategies.
- Generated business intelligence reports to inform strategic decision-making.
IT Service Desk Analyst
Acrodex
05.2007 - 05.2009
- Collaborated with supervisors to escalate and address customer inquiries or technical issues.
- Translated complex technical issues into digestible language for non-technical users.
- Resolved diverse range of technical issues across multiple systems and applications for customers and end-users across various time zones.
- Used ticketing systems to manage and process support actions and requests.
- Managed high levels of call flow and responded to [Type] technical support needs.
- Assisted customers in identifying issues and explained solutions to restore service and functionality.
- Configured hardware and granted system permissions to new employees.
- Promoted efficiency among departments with prompt resolution of system issues.
- Researched product and issue resolution tactics to address customer concerns.
- Documented support interactions for future reference.
- Responded promptly to incoming sales leads and requests for technical support.
- Monitored systems in operation and quickly troubleshot errors.
- Assisted with updating technical support best practices for use by team.
- Researched and identified solutions to technical problems.
- Maintained servers and systems to keep networks fully operational during peak periods.
- Patched software and installed new versions to eliminate security problems and protect data.
- Assisted in development of system security protocols.
- Tested new software and hardware prior to deployment.
- Diagnosed and troubleshot hardware, software and network issues.
- Broke down and evaluated user problems, using test scripts, personal expertise, and probing questions.
- Generated reports to track performance and analyze trends.
- Created user accounts and assigned permissions.
- Removed malware, ransomware, and other threats from laptops and desktop systems.
Education
Bachelor of Applied Information Systems -
PMI-PBA (PMI-Professional in Business Analysis) - undefined
04.2024
Business Analysis Certificate - undefined
01.2015
Computer Technology Diploma - undefined
01.2010
Skills
- 5 years as a senior business analyst with AHS Connect Care: a multi-year, $15-billion program (comprised of 75 projects) to enable unified healthcare information across the province of Alberta and provide information access for all patients and providers Cultivated and maintained cross-functional teams to develop and implement IT Solutions aligned with business goals
- 8 years as a business analyst, support analyst, and functional subject matter expert, leading projects for software upgrades or new implementations, designing and presenting data-driven analytics, assisting in leading change management
- 4 years direct development of technical solutions, specializing in custom reporting, value-add enhancements, and ad-hoc information
- 2 years directly managing teams of business analysts, systems analysts, and functional specialists Additional years leading by establishing credibility, expertise, and trust; bringing practical solutions; and forming strong coalitions and networks
- Project Planning
- Requirements Gathering
- Stakeholder Management
- User Acceptance Testing
- Business Analysis
- Data Mapping
- Business process improvement
- KPI Tracking
- Business Process Mapping
- Data Mining
- Gap analysis
- Data Analysis
- Quality Assurance
- Process Optimization
- Project Management
- Microsoft Office Suite
- IIBA methodologies
- Project Scheduling
- Decision-Making
- Relationship Building
- Attention to Detail
- User Support
- Organizational Skills
- Problem-solving abilities
- Analytical Thinking
- Active Listening
- Time Management
- Team Collaboration
- Team building
- Project Coordination
- Analytical Skills
- Problem-Solving
- Excellent Communication
- Project lifecycle management
- Time management abilities
- Goal Setting
- Task Prioritization
- Agile framework
- Self Motivation
- Problem-solving aptitude
- Requirements Analysis
- Process Mapping
- Technical Analysis
- Data Warehousing
- Data formatting
- Data Validation
- Database Maintenance
- Data Modeling
- Report Preparation
- Data Visualization and Presentations
- SQL
- Database Management
- Microsoft Access
- Tableau
- Oracle Business Intelligence
- Google Analytics
- Microsoft Visio
- Data Science
- Report Writing
- Business intelligence tools
- Agile Methodology
- Software Development Lifecycle
- Process Development
- Work flow planning
- Root Cause Analysis
- Productivity Improvement
- Risk Management
- Project tracking
- Technical Support
Process Mapping Improvement
- Led teams and delivered a wide range of processes, including technical support, data management, information flow, and program/project management.
- Led a team of 3 business analysts through a comprehensive review of 600+ clinical system processes.
- Mapped and improved processes relating to systems integration and reporting for Contracting, Procurement, and Supply Management, and optimized custom solutions not meeting performance goals.
- Designed processes and supporting documentation enabling a multi-site technology assessment used for Connect Care Program scoping.
Project Delivery
- Project managed the testing and coordination of a data migration for an extensive SharePoint collaborative document repository. (200+ sub-sites, 1TB of data).
- Leader for the warehousing optimization and RF device remediation initiatives. Efficiency gain of 100% for inventory pickers (from 30 lines per hour, to 60), through warehouse reorganization (ABC analysis), and improvements such as zoning, conveyors, and automation.
- Facilitated and made key decisions on behalf of Contracting, Procurement, and Supply Management during the AHS consolidation, and acted as a business relationship partner to identify and mitigate cross-functional impacts.
- Leader for the comprehensive technical testing for software version upgrades within the Oracle ERP (Enterprise Resource Planning).
- Leader for the surgical services inventory system migration from Oracle to DynaMed.
Document Design Delivery
- Designed and implemented the business analysis best practices for distilled and consistent process mapping within the AHS Connect Care Program, based on Business Process Model Notation (BPMN).
- Created and maintained the AHS Connect Care Program Handbook: a comprehensive guide to the overarching governance, and program and project processes, working with stakeholders through the executive level.
- Developed various comprehensive Business Requirements Documents (BRDs) and RACI (responsibility assignment) matrices.
- Managed the support team, and oversight of the modelling, of the SharePoint collaborative information repository for the Connect Care Program.
Solution Delivery
- Innovated, designed, and delivered technology and functional solutions:
- Integrated automations for monthly reporting across the Connect Care Program to the AHS Board and Alberta Health, using advanced Excel features and Visual Basic. Reduced time from 40-hours per month to 1-hour.
- Custom reporting and ad-hoc data solutions for the H1N1 flu pandemic for strategic sourcing and inventory management. Formed the basis of an overall supply chain and warehousing strategy for pandemic inventory, including inventory segmentation, and automated turnover for perishable items.
- Integrated materials management solution for the operating room inventories, resulting in an improved method of tracking instruments and items within sets.
- Database and associated processes and procedures for expensed operating room inventory counts. Resulting in quantification and costing used for catastrophic events and insurance purposes.
- SQL stored procedures, custom defined functions, and custom views, resulting in highly flexible reporting, data integrity, and enabling data warehouse Business Intelligence (BI) dimensional information modelling.
Timeline
Senior Project Business Analysts
Alberta Health Services
04.2019 - Current
Senior Business Analyst
Alberta Public School Board
06.2018 - 03.2019
Business Analyst
Edmonton Catholic Schools
07.2017 - 05.2018
Business Analyst
Design Group Staffing (DGSI)
11.2014 - 06.2017
Business Systems Analyst
Workers Compensation Board (WCB)
04.2014 - 10.2014
Junior Business Analyst
ATB Financial
03.2013 - 03.2014
Business Support Analyst
ATB Financial
06.2009 - 02.2013
IT Service Desk Analyst
Acrodex
05.2007 - 05.2009
Bachelor of Applied Information Systems -
PMI-PBA (PMI-Professional in Business Analysis) - undefined
Business Analysis Certificate - undefined
Computer Technology Diploma - undefined
Similar Profiles
Shawna ButlerShawna Butler
Administrative Support Assistant III at Alberta Health Services - Alberta Public Health NGAdministrative Support Assistant III at Alberta Health Services - Alberta Public Health NG
Nerissa DauloNerissa Daulo
Environmental Services II at Alberta Health Services University of AlbertaEnvironmental Services II at Alberta Health Services University of Alberta
Brenda BaltimoreBrenda Baltimore
Temporary Clinical Supervisor at Alberta Health Services / Recovery AlbertaTemporary Clinical Supervisor at Alberta Health Services / Recovery Alberta
FREDERICK PahanonotFREDERICK Pahanonot
Environmental Services II at Alberta Health Services - University of Alberta HospitalEnvironmental Services II at Alberta Health Services - University of Alberta Hospital
Harmanjot KaurHarmanjot Kaur
Warehouse Worker at AmazonWarehouse Worker at Amazon