Ian Hogan Email & Phone Number

Bellingham, Wa, Us

Bellingham, Washington, United States

Our mission at Datalation is to design and implement data & analytics solutions for organizations and teams that apply the right technology to the right problem at the right time, and with the right balance of innovation and best-practice patterns so that they can become elated with their data.The cloud is simply vast and confusing, and all the buzz and hype around Artifical Intelligence and especially generative AI like ChatGPT lately is not making it any clearer. Offerings, services, and environments can change daily. It can be daunting and infuratiting at times to understand just where, how, and when to "jump" in and make sense of it all. Even seasoned technologists could spend what seems like an eternity on research into all the latest Azure has to offer. Most of us have jobs with organizational goals that demand our full attention, and while some time for education, innovation, and continuous improvement may be possible, certainly one cannot dedicate endless hours to exploration of such an ocean of potential. It can be next to impossible to know what to adopt, when to adopt it and how to leverage it. Myself and my insanely smart and fun colleagues are here to help you solve specific problems, make sense of Azure cloud services, design an adoption path for analytics in the could using your on-prem data, assist with ETL/data processing coding practices and methodologies, design and build Power BI reports, and provide education and guidance along the way. We have a fervid zeal about pairing organizations and people with data technology to help solve their biggest problems while positioning them for their best future.

Bellingham, Washington Area

In BI here at SPIE we do it all; Data Warehouse Architecture and Design, Data Modeling, ETL, Data Science/Machine Learning, and multi-varied BI deliverables development using SQL Server, SQL Server Reporting Services/SSRS, SQL Server Integration Services/SSIS , SQL Server Analysis Services/SSAS Tabular, DAX, Power Pivot, Power Query, Power BI, Azure Synapse Analytics, Azure SQL DB, Azure Data Factory, and C#.NET. We are primarily a Microsoft shop but employ a few other tools here and there just to confuse ourselves.My fellow BI fools here at SPIE are beyond AWESOME. Each has an area of expertise and a depth and breadth of knowledge that is honed and humbling. They are each analytic alchemists exceptionally skilled at creating impressive illusions with intricate and confusing data. To say it is a pleasure to work with this team is an understatement. We teach, frustrate, challenge, and steal code from each other daily, and we laugh through the tears while doing it. I wouldn't want to do BI anywhere else, with anyone else.The cloud is amazing. So much to explore and do. The Azure ecosystem is vast and incredible, and I am very excited to be leveraging it in our work.

Anvil Corporation is an Engineering, Design, and Procurement firm with primary focus on the petroleum industry. As a member of a team of four developers, we collectively supported all of the business and engineering design systems for the organization with a collective user base of over five hundred. The “Integrated Project Control Systems” (IPCS) comprised over 750,000 lines of .NET code in a suite of 10 user-facing executables along with over two dozen other associated ancillary utilities and supporting dlls/libraries written in both VB and C#.NET. Daily activities involved the use of Visual Studio to author and debug C#.NET and VB.NET application code primarily in a Windows Forms setting, use of SQL Server Management Studio to design, develop, and support all associated databases and objects. Use of SQL Server Reporting services, third-party .NET BI plug-ins, and Excel for BI and data visualizations. Deliverables included Windows executables, libraries of distributable .dlls and assembly components, SSRS RDL (report server) and RDLC (client-app) reports. Activities also included requirements gathering direct with business users in scoping work, creating project plans, as well as management engagement.

Bellingham, Washington, United States

Analytic staff at Peacehealth provide data analysis services, including reporting, statistical analysis and business intelligence for a hospital system with over one hundred fifty hospitals and clinics across the Pacific Northwest, over sixteen thousand employees, and a collective systems user base of over ten thousand. On a team of over thirty-five, in a department of nearly one hundred, we collaboratively provided the all analytics, reporting, and Business Intelligence for the organization in support of major organizational business and clinical initiatives. Daily activities included developing, maintaining, and troubleshooting TSQL queries, views, functions, and stored procedures of a highly complex analytical nature using various normalized source system databases, data extracts, and a highly structured Enterprise Data Warehouse inclusive of data from nearly fifty major clinical applications. Querying activities included the extensive use of query execution plans and performance tuning to established runtime standards. Deliverables were mainly in the form of SQL Server Reporting Services report server reports and Business Objects Crystal Reports, with periodic use of and MS Access VBA applications and Excel workbooks, as well as stored procedures and various queries for use in transactional Electronic Medical Record system. The analytics department was constantly at the center of engagement for major organizational initiatives from technology upgrades, platform migrations, implementation of new BI technologies, executive and operational dashboard development, and support of operational information services for hospital and clinic operations, clinical trials, and government medical provider compliance.

San Diego, California, United States

Hogan & Co. was a small, independent Finance & Accounting consulting firm specializing in software and data services with a Finance and operations emphasis. It had a rich and dynamic twenty-five year history involving projects than touched every aspect of business, and every role in business. Services comprised of a very wide variety of data driven services including software acquisition, installation, and implementation, application development, data collection, staging, archiving, integration, and analytics/reporting. Client user base typically ranged from five to five hundred, with a few involving departmental initiatives in large organizations. Client industries of focus were typically Manufacturing, Distribution, Service, and Biomedical.*see resume for more detail

Carlsbad, California, United States

Standard Filter Corporation is a manufacturer of industrial pulse-jet filters and custom machinery. Duties included management and maintenance of all company information systems including ERP/MFG system (Epicor), CRM, Windows Server 2003 R2, and SQL 2000 databases, including various supporting third-party applications and system integrations. Responsibilities included maintaining connectivity, security, customizations, upgrades, and integrations. Development activities included designing and developing accessory reporting and analytics utility application using MS Access and VBA. BI reporting deliverables included Financial; Income Statement, Balance Sheet, Statement of Cash Flows, Cost Accounting, inventory turns, liquidity, cash days, acid ratios, as well as various operational manufacturing job and labor reports, freight fulfillments, procurement analysis, and more.

Carlsbad, California, United States

Key member of management team responsible for all Accounting and Finance activities including AP, AR, Payroll, tax reporting, cash management, treasury activities, budgeting, fixed assets, General Ledger maintenance, and Financial reporting. Directed and supervised all data input to enterprise Accounting and ERP system, including supporting staff of one to two. Coordinated & prepared annual budgeting. Managed financing for foreign trade contracts, external finance reviews and tax audits. Prepared financial reports including standard financial statements, statements of manufacturing, profitability analysis, Activity Based/Job Costing, customer spending profiles, retention, and life cycle-analysis, industry benchmarking, and more. Maintained company policies, procedures and compliance documentation. Acting liaison with outside legal counsel on employment issues. Facilitated and maintained open dialog between managers and shop workers (head count of fifty-five) regarding workplace issues including conditions, complaint, and dispute resolution. Coordinated mandatory manager and employee harassment and sensitivity training.

Education record

Biology and EMS major

Education record

Biology and EMS major

I Survived.

My major was whatever they told me because it was high skool. :OP