Senior Business Intelligence Analyst

• Jul 2023 - Present

Senior Business Intelligence Analyst

• Aug 2016 - Jul 2023

Database Analyst & Report Developer

• Aug 2014 - Aug 2016

DBA, BI360 and Reports developer (August 2014 to present)Major project list and roles to date in current position:Centralized reporting SQL Server 2012 ODS design, architect, BI/DW/ETL developer. Collaboration with SharePoint team for SharePoint BI presentation implementation in development, test and production deployment. Data analyst and ETL developer - SQL, ETL, MS replication & SAGE SQL Gateway replication solutions extracting data from BuilderMT, Timberline accounting and Sales Simplicity OLTP applications into a Centralized staging and operational data store for reporting and analytics, improving performance issues experienced reporting from 3 OLTP Builder applications. Collaborating with SharePoint team to setup and configure a SharePoint Business intelligence portal with SSRS, Excel Services and Performance point services integration to host reports and dashboards for Corporate Centralized BI Portal. Developer/Analyst - Collaborate with senior management and Business Analysts to develop new reports and migrate slow reports from 3 OLTP Builder applications to SharePoint BI portal. Timberline Accounting System Implementation and Reports setup – San FranciscoSetup System and User Timberline ODBC application connections on servers including SQL server linked servers to facilitate SSRS, Crystal reports and ETL development against Timberline Accounting Data.Developer/Analyst - BI360 Data warehouse projectsSept 2014 to present: Collaborate with MS Dynamic Financial systems team and senior Accounting executives to implement BI360 Data warehouses including solutions deployment, maintenance, data warehouse performance optimization. Successfully assisted team to implement BI360 data warehouses for Cash flow management, Forecasting and Financial Consolidations. Optimized data warehouses to improve BI360 report execution speeds by over 50% after solution deployment. Show less

Data Analyst/Reporting & BI Consultant

• Aug 2014 - Aug 2016

DBA & BI Data warehouse professional currently performing implementations & integrations for BI and Reporting solutions for MS Dynamics ERP, Sage, BuilderMT, Sales simplicity, Lot Management System (LMS), BI360 data warehouse solutions and other applications for land and housing communities development projects DBA & BI Data warehouse professional currently performing implementations & integrations for BI and Reporting solutions for MS Dynamics ERP, Sage, BuilderMT, Sales simplicity, Lot Management System (LMS), BI360 data warehouse solutions and other applications for land and housing communities development projects

DBA and Reporting Analyst

• Oct 2011 - Aug 2014

DBA - Administration and maintenance of all Banking SQL Server & SSAS databases, maintenance plans, SSIS packages and SQL Agent jobs in all environments. Report Developer - Implemented Report development lifecycle process. Collaborating with users to collect requirements for iterative development, testing and deployment of Business and Senior Management reports. ETL Designer & Developer - Designed and developed modularized SSIS packages to generate extracts for CDIC Data and Systems Requirement By-Law. SharePoint Server 2010 Enterprise Installation, SharePoint Business Intelligence Portal setup and administration - Secure Store Services,Excel Services, Performance Point Services, SSRS SharePoint integration, Power Pivot. ETL & Dataware house Developer - Designed and developed modularized SSIS packages for loading Deposits and Mortgage pipeline to data warehouse. Project Manager and ETL Developer, Operational Data Store. ETL Developer, Compliance & Risk Assessment ETL Processes and creation and scheduling of internal audit SAP reports to validate completeness of processes ETL Developer, Treasury/Hedging Management Data Mart SSIS Developer - inter bank investor data exchange extracts for daily pipeline transactions & trial balance reconciliations including remittances, mortgage portfolio purchases and originated mortgage backed security sales SSAS Developer and Administration - Developed SSAS cube and reports for performance analysis. SSIS developer - Banking risk assessment project related to scanning secured assets against various high risk lists and SAP alert notifications or reports generation SSIS/ETL Developer - Underwriting/Funding workflow process automation MS Dynamics GP/ERP/Smart Connect Administrator, Management Reporter Administrator Data Analyst, SQL Server DBA, SQL and Crystal Reports developer CyberQuery developer for SIT PortfolioPlus deposits system Setup and administration of SAP Crystal reports Server and reports/publications jobs Show less

Business Intelligence Student

• May 2011 - Sep 2011

Business Intelligence Certification program SAIT which includes: Completing a fill cycle Business Intelligence project using the Microsoft SQL Server BI suite & SharePoint Enterprise Server, involving a complete OLTP Database design, Database design for Data warehousing, Data Mart Star Schema Dimensional Modeling, Extract, Transform, Load (ETL) package development for data cleansing, staging and loading data warehousing with SSIS, OLAP Cube design, development & enhancements for KPIs, Trends and other calculated business metrics with Visual Studio/BIDS/SSMS ,SSIS,SSAS, SSRS, SharePoint 2010 Designer development tools. Setup for a SharePoint BI Portal including required SharePoint BI service applications for the presentation layer used for all reports and dashboards. SAIT Business Intelligence Certification Couse standings - CPSY201 Intro to Data Management : A+ CPSY203 Architecture and Design: A+ CPSY205 SSIS/ETL(Extract,Transform,Load) : A+ MMGT205 Business Analysis for BI: A+ CPSY207 Reporting and Analytics: A+ CPSY209 OLAP/SSAS A+ MMGT206 Performance Mgmt Applications A+ PROJ212 Applied Business Intelligence Project A+ Show less

Graduate student, Teaching & Research Assistant - Analytical Chemistry

• Jan 1986 - Aug 1988