Back to Search Results

Ronald F.

Senior Information Architect

Commitment
0/ 5
Competency
0/ 5
Reliability
0/ 5
  • Overall Experience: 18 Years  
  • Algorithm Development:
  • Amazon Relational Database Service:
  • Application Lifecycle Management:
  • Artificial Intelligence:
  • Finance:
+ More

Ronald F. 

Senior Information Architect

Commitment
0/5
Competency
0/5
Reliability
0/5

Time zones ready to work

  • Pacific Daylight [UTC -7]
  • Mountain Daylight [UTC -6]
  • Central Daylight [UTC -5]
  • Eastern Daylight [UTC -4]

Willing to travel to client location: Yes  

About Me 

I am a senior information architect with more than 15 years of experience in business intelligence and advanced analytics with a focus on data quality and governance. At
I am a senior information architect with more than 15 years of experience in business intelligence and advanced analytics with a focus on data quality and governance. At Microsoft I created a database application that grew to become the largest content management platform within the company (Arsenal) and I consulted on a demonstration of the worlds largest OLAP Cube. I developed a BI system prototype to analyze MS Sales against Siebel CRM data and initiated the earliest efforts within Microsofts Enterprise and Partner Group to analyze internal business data using OLAP technology. In the in the Army Reserve I served as deputy to the CTO of US Central Command, Directorate of Intelligence, and Chief of Intelligence Systems for Afghanistan. I have written published courseware for ITIL v2011. Ive written popular blog posts including OLAP is not becoming obsolete (link).
Show More

Interview Videos

Signup to see videos

Risk-Free Trial, Pay Only If Satisfied.

Portfolios

Built dimensional warehouse from scratch to replace Business Objects reports on SAP data

Website Link:

Role:

In this project I built a dimensional warehouse from scratch to replace a suite of Business Objects reports with SSRS reports. Source data was SAP. It involved extensive data quality work and ETL.

In this project I built a dimensional warehouse from scratch to replace a suite of Business Objects reports with SSRS reports. Source data was SAP. It involved extensive data quality work and ETL.

Skills: GitSQL

Tools: Visual Studio (Win)SQLSMSSSISazure devops

Predictive analytics to support real-time UI adaptation

Website Link:

Role:

Built analytical models to predict the ways users would configure a licensing tool based on their profile attributes so we could pre-configure the interrface and make it easier and faster for them to make adjustments. Used K-means algorithm to set defaults and EM algorithm to populate and sort al

Built analytical models to predict the ways users would configure a licensing tool based on their profile attributes so we could pre-configure the interrface and make it easier and faster for them to make adjustments. Used K-means algorithm to set defaults and EM algorithm to populate and sort alternative choices.

Show More

Skills: Predictive ModellingData Science

Tools: Visual Studio (Win)

Architectural analysis and performance tuning of production SSAS OLAP cube; Power BI dashboards

Website Link:

Role:

In this project my role was to diagnose significant prerformance challenges with a large production OLAP cube that supported the daily analytical needs of the worldwide retail operation. Source data was on IBM Netezza. I created Power BI dashboards to support busness analysts and retail managment

In this project my role was to diagnose significant prerformance challenges with a large production OLAP cube that supported the daily analytical needs of the worldwide retail operation. Source data was on IBM Netezza. I created Power BI dashboards to support busness analysts and retail managment.

Skills: NetezzaSSASPower BIData Modeling

Tools: Visual Studio (Win)

Develop OLAP cubes and data warehouse

Website Link:

Role:

With this customer I had multiple engagements: I developed OLAP cubes and analytical models to support finance and accounting; extended their data warehouse to support the OLAP cubes; I analyzed their entire reporting system to identify risks associated with a planned move to a new distribution c

With this customer I had multiple engagements: I developed OLAP cubes and analytical models to support finance and accounting; extended their data warehouse to support the OLAP cubes; I analyzed their entire reporting system to identify risks associated with a planned move to a new distribution center. Hard-coded references to the existing distrubution center were replaced with dynamic references in all ETL, Tableau workbooks, reports and code; I helped evaluate Snowflake for potential future migration.

Show More

Skills: SQLSnowflakeTableauAzure

Tools: Visual Studio (Win)SQL Server Business Intelligence Development Studio

Employment

Program Manager

2001/08 - 2006/04

Skills: SSASSQLVisual Studio CodeSQLVMWare

Your Role and Responsibilities:

Platform and Infrastructure Architect for Arsenal, which began as small project and became the largest content management system within Microsoft.

  • Principal designer of the Arsenal platform infrastructure, consisting of Application Center 2000, clustered web servers, clustered SQL

Platform and Infrastructure Architect for Arsenal, which began as small project and became the largest content management system within Microsoft.

  • Principal designer of the Arsenal platform infrastructure, consisting of Application Center 2000, clustered web servers, clustered SQL Servers, CMS 2002, SharePoint, Operations Manager, Reporting Services and Analysis Services
  • Developed a novel and significant technique to permit many-to-many dimensions in in Analysis Services 2000.  This approach was reviewed by the SQL Server product team and implemented as a feature into SQL 2005 and all subsequent releases
  • Created a BI system prototype for analyzing Microsoft's worldwide sales and CRM data
  • Data governance efforts led to a restructuring of Microsoft’s human resources database
Show More

Senior information architect

2006/04 -

Skills: Data ModelingData ScienceOnline Analytical Processing - OLAPPower BIData WarehousingBig DataData CleansingCosmo DBData ArchitectInformation Architecture

Your Role and Responsibilities:

Project-based consulting in business intelligence and data science, with a focus on data quality and governance. I've built many complete BI systems from scratch and created analytical models for purposes such as commercial banking appraiser performance; security risk model assessment; analyz

Project-based consulting in business intelligence and data science, with a focus on data quality and governance. I've built many complete BI systems from scratch and created analytical models for purposes such as commercial banking appraiser performance; security risk model assessment; analyzing the impact of service metrics on software license renewal; predictive models to drive real-time UI configuration; pharmaceutical pricing; discount bundling; targeted sell-through; and many others. My strengths are delivery, performance, and helping teammates. I blog about information management and related topics at http://oninfo.info. I have presented original research to the Association for Symbolic Logic, the Joint Mathematics Meetings, the American Philosophical Association, the Data Management Association, and numerous industry audiences.

Show More

Consulting in business intelligence, data science,

2006/01 -

Skills: SSASOnline Analytical Processing - OLAPPower BITableauSQLInformation Technology Infrastructure Library

Your Role and Responsibilities:

Consulting with a focus on data governance, BI, analytics, data warehousing, OLAP, data quality and process engineering. Engagements have included: Marcus & Millichap (2019): Built dimensional warehouse from scratch to replace Business Objects on SAP data Lululemon (2018): Performance tuning and arc
Consulting with a focus on data governance, BI, analytics, data warehousing, OLAP, data quality and process engineering. Engagements have included: Marcus & Millichap (2019): Built dimensional warehouse from scratch to replace Business Objects on SAP data Lululemon (2018): Performance tuning and architectural analysis of a production SSAS OLAP cube that supported daily analytical needs of the international retail operations. Re-engineered the Power BI dashboard. Brooks Running (2017-2018): Maintain and extend SSAS OLAP cubes and data warehouse. Analyzed all reports and ETL processes to support transition to a new distribution center. Ensured all reports would work after transition. Microsoft Engineering and Community Online (2016-2017): Developed tabular models and ETL for Customer Service and Support data warehouse. Microsoft Information Security and Risk Management (2016): Ported reports from Tableau to Power BI. Microsoft Enterprise Commerce IT (2015): Created analytical models to support user research and functional design for Microsofts Next Generation Volume Licensing (NGVL). Princess Cruise Lines (2013-2015): Wrote queries to map new Cisco call center schema to legacy Avaya reports. JPMorgan Chase Commercial Banking (2013): Developed data warehouse to support appraisal performance Groundspeak (2012-2013): Built new BI system from scratch with SQL Server dimensional warehouse, SSAS OLAP cubes, SSIS, and PowerPivot. Demonstrated Tableau Desktop for dashboard and reports. Microsoft MSDN/TechNet Publishing System (2012): managed assimilation of security bulletin reports into MTPS. Managed bug and incident triage for the Core PUB team (database design and maintenance). Microsoft World Wide Licensing and Pricing (2010-2011): DBA for the Advanced Analytics team for the volume license finance data warehouse. Increased performance of key process by 6x. Pultorak & Associates / Acceleres (ITIL training and business process consulting): wrote ITIL v2011 courseware for Service Operation (SO) and Continuous Service Improvement (CSI); redesigned internal database and VM server platforms; wrote courseware for IT asset management (2 courses for Provance).
Show More

Instructor in the Business Intelligence program

2012/01 -

Skills: SSASSQL

Your Role and Responsibilities:

Taught courses in SSAS, SSIS, SSRS; developed original course content for data governance
Taught courses in SSAS, SSIS, SSRS; developed original course content for data governance

Program Manager -- Microsoft Enterprise and Partne

2000/01 - 2006/01

Skills: SQLSharePoint

Your Role and Responsibilities:

Platform and Infrastructure Architect for Arsenal, which began as small project and became the largest content management system within Microsoft. Principal designer of the Arsenal platform infrastructure, consisting of Application Center 2000, clustered web servers, clustered SQL Servers, CMS 2002,
Platform and Infrastructure Architect for Arsenal, which began as small project and became the largest content management system within Microsoft. Principal designer of the Arsenal platform infrastructure, consisting of Application Center 2000, clustered web servers, clustered SQL Servers, CMS 2002, SharePoint, Operations Manager, Reporting Services and Analysis Services Developed a novel and significant technique to permit many-to-many dimensions in in Analysis Services 2000. This approach was reviewed by the SQL Server product team and implemented as a feature into SQL 2005 and all subsequent releases Created a BI system prototype for analyzing Microsofts worldwide sales and CRM data Data governance efforts led to a restructuring of Microsofts human resources database
Show More
+ More

Education

1989 - 1993

US work authorization

Are you legally authorized to work in the United States? Yes

Skills

Algorithm Development Amazon Relational Database Service Application Lifecycle Management Artificial Intelligence Big Data
+ More

Hobbies

I like to spend time with outdoors and playing games with my family and friends, and meeting new people. I recently took an interest in ammature radio. I've earned my Ammature Extra license and my 2 boys have earned their Technician licenses. This is a fun hobby to combine with hiking, camping and scouting.

Achievements

I have presented or

Certification

MCSE, MCSA, ITIL Foundation Certificate in Service Management

Preferred Languages

English - Native/Bilingual