Business Intelligence Specialist

• Mar 2021 - Present

Executive Director

• Jan 2017 - Present

Business Intelligence Specialist

• Sep 2020 - Mar 2021

Part of a team developing an enterprise-wide data warehouse for reporting across clinical, revenue and operational data for medical transportation. Worked with stakeholders to identify valuable business questions, analyzed multiple source systems, contributed to data modelling and ETL design, and developed cross-domain reports that delivered stakeholder value. Microsoft Power BI, SQL Server, SSIS, SSAS, Power Apps Part of a team developing an enterprise-wide data warehouse for reporting across clinical, revenue and operational data for medical transportation. Worked with stakeholders to identify valuable business questions, analyzed multiple source systems, contributed to data modelling and ETL design, and developed cross-domain reports that delivered stakeholder value. Microsoft Power BI, SQL Server, SSIS, SSAS, Power Apps

Business Intelligence Specialist

• Sep 2020 - Mar 2021

Business Analyst and BI Architect

• Feb 2019 - Sep 2020

Designed and implemented a complete cloud-based BI research environment for a pharmaceutical research firm. Responsibilities included user needs analysis, source data analysis, data modeling, ETL programming, data visualization development, user training. Designed and implemented a complete cloud-based BI research environment for a pharmaceutical research firm. Responsibilities included user needs analysis, source data analysis, data modeling, ETL programming, data visualization development, user training.

Senior Business Intelligence Analyst and Developer

• Dec 2017 - Dec 2018

Lead analyst, designer and developer within the Birst Professional Services group. Responsible for all aspects of BI design, implementation and deployment. User requirements analysis, source data analysis, data model design and source mapping, ETL design and coding, visualization dashboard and report development, user data literacy training. Clients included manufacturing, defense, transportation. Lead analyst, designer and developer within the Birst Professional Services group. Responsible for all aspects of BI design, implementation and deployment. User requirements analysis, source data analysis, data model design and source mapping, ETL design and coding, visualization dashboard and report development, user data literacy training. Clients included manufacturing, defense, transportation.

Senior Business Intelligence Analyst, Developer and Trainer

• Jan 2008 - Dec 2016

Project manager and database designer on a full range of dimensional data warehouse implementations on Oracle and Microsoft SQL Server. Activities include pre-sales presentations and prototyping, user requirements analysis, dimensional ("star schema") database design, ETL specification and implementation, front end design and implementation, user and technical training, data quality assurance. Clients included manufacturing, aviation, health care, banking and finance, insurance, government, retail, transportation. Show less

Database Designer

• Jan 2005 - 2006

Business analyst and database designer for a national database analyzing bankruptcy information. Business analyst and database designer for a national database analyzing bankruptcy information.

Senior BI and Data Warehouse Developer

• 1998 - 2004

Database designer and developer and ETL developer for dimensional data warehouses. Clients included Hitachi Data Sytems, Sun Microsystems, Cisco, Accuson, Applied Materials. Primary platforms: Oracle, Business Objects, MicroStrategy Tools: PL/QL, SQL Plus, Toad. Database designer and developer and ETL developer for dimensional data warehouses. Clients included Hitachi Data Sytems, Sun Microsystems, Cisco, Accuson, Applied Materials. Primary platforms: Oracle, Business Objects, MicroStrategy Tools: PL/QL, SQL Plus, Toad.

Data Warehouse Developer

• Jan 1995 - Dec 1998

Responsible for specification, design and implementation of dimensional data warehouses, primarily on Oracle relational databases. Gather user requirements, design dimensional data warehouse and ETL strategy, build database and code ETL. Clients included Bank of New Zealand, Air New Zealand, CIO Insurance (Australia), Philippines Long Distance Telephone Company, United Coconut Planter's Bank (Philippines) Responsible for specification, design and implementation of dimensional data warehouses, primarily on Oracle relational databases. Gather user requirements, design dimensional data warehouse and ETL strategy, build database and code ETL. Clients included Bank of New Zealand, Air New Zealand, CIO Insurance (Australia), Philippines Long Distance Telephone Company, United Coconut Planter's Bank (Philippines)

Professional Services Manager

• Jan 1990 - Dec 1992

Helped develop and launch Sequent's Data Warehousing practice. Worked with industry leaders to developed Sequent's implementation methodologies and acted as project manager for data warehouse clients including Mervyn's Department Stores, Blue Shield of California, and Monsanto. Helped develop and launch Sequent's Data Warehousing practice. Worked with industry leaders to developed Sequent's implementation methodologies and acted as project manager for data warehouse clients including Mervyn's Department Stores, Blue Shield of California, and Monsanto.