Sign in

Manager/Architect - Data Warehouse and Business Intelligence

Keene, NH
January 10, 2020

Contact this candidate


Nathan Blanchard


A Business Intelligence Technical Architect/ Manager/ Director with over 17 years of experience in all phases of data warehouse implementations and architecture; including project and team management applied to data warehouse architecture. A strong hands-on experienced director/architect/engineer/team manager focused on business intelligence decision support solutions. Confident technical execution producing positive results while concentrating on business objectives and financial responsibility. With many years of data experience comes numerous subject area experience with a wide variety of challenges accomplished. Additional experience in customer integration messaging micro services related to robotics warehouse automation systems.


A remote leadership or technical position in data warehouse, integration and business intelligence technologies.

Technical Experience

●Data Architecture / SQL

●ETL Integration


●Oracle Informatica / DAC

●AWS Data Migration Services (DMS)

●AWS S3, EC2, RDS, Lambda, Glue

●Oracle Analytics Cloud (OAC)

●OBIEE Architect

●Microstrategy Architect

●MS SQL Server

●Oracle Database


●SOAP / Micro-Services




●Web Programming

●Java / JSP


●JavaScript / JQuery

Business Data Experience

●Warehouse and Transportation


●Inventory Management

●Order Entry

●Order Management



●Financial OPM Manufacturing

●Mortgage Loan Origination

●Mortgage Servicing

●Discrete Manufacturing

●Product Pricing




●Grocery Wholesale


2018 Classes

●Python Programming

●Spark / Scala / Kafka

●Hadoop Big Data

●Hive / Pig / HBase / Impala / HUE

2006 Certifications

●Certified Microstrategy Architect

●Certified Microstrategy Report Developer

Employment Experience

Cardinal Financial (Feb 2019 – Present)

Manager, Business Intelligence / Data Warehouse

●Cloud based Data Warehouse with OAC on MS SQL Server

Directing business intelligence, integration and data warehouse solutions in the AWS and Oracle cloud for a fast growing mortgage financial company.

Directed, managed and performed lead architecture roles while mentoring and growing an agile team of 6 fully remote cloud data warehouse engineers or varying skills.

Ground up implementation. There was no functioning data warehouse components when I was brought on in Feb 2019. Since then I have directed the entire dev/uat/production environment setup for the data warehouse, integration and business intelligence reporting engine.

Designed and implemented a full BI security configuration in OAC with Multi-factor authentication and role based security. This includes row base security filtering for personalized data sets.

Integration using Data Migration Services to produce a real time operational data store that feeds an operational data store and data warehouse in near real time (less than 5 minutes).

Additional integration to over 15 other data sources using web services and FTP files that are processed hourly and daily per data source requirements using both Python and Pentaho jobs. Files were processed and archived thru AWS S3 and Google Drive folders depending on source needs.

All reports are currently processing in sub second due to business data rationalization into well designed fact dimension models made into column store tables.

Business processes were non-existent when I began. Now we are doing complete 2 week sprints releases utilizing dev/uat and production systems with full migration documentation and source control versioning in Git.

All components are cloud based and management of the teams is 100% remote. Daily stand-ups are in place to continue to address impediments and team focus.

Technologies: AWS Cloud running Data Migration Services, S3, RDS EC2, CloudWatch, MS SQL Server, Oracle Autonomous Data Warehouse, Oracle Analytics Cloud, Pentaho, Python, SQL, Git, Asana, Freshdesk

Symbotic, LLC. (Oct 2016 – Mar 2018)

Manager, Customer Integration

●Customer Integration via asynchronous SOAP Messaging Services

Managed an agile team of 5 domestic and 15 offshore software engineers and quality assurance engineers using Scrum methodologies.

Implemented full life cycle integration services to Forbes Top 10 companies including multiple implementations for Walmart, Albertsons, Giant Tiger, Coca-Cola; all simultaneously with tight deadlines using clever development alignments to optimize development results.

Messaging types included guaranteed delivery using asynchronous messaging for inbound orders, outbound shipments, replenishment, item master updates, message confirmations, and so much more.

Protocols implemented included SOAP via HTTP, XML via TCP, SFTP fixed width files.

Actively engaged in customer interface testing and full stack testing, as well as onsite functional testing and feature burn in.

Implemented automated testing for regression testing quality assurance of messaging interface using ReadyAPI (SoapUI).

Log Parsing implementations using Splunk and custom solutions. Search feature for finding specific log messages and replaying messages.

Dashboard designs for Replenishment data using MS SQL Server and Tableau.

Quality toll enhancements to custom integration software package used internally for functional programming business workflows.

Technologies: MS SQL Server 2012, SQL, Git, Jenkins, SOAP, WSDL, Splunk, ReadyAPI (SoapUI), Integration Manager Suite, SFTP, BitVise

Lucidity Consulting Group / Emtec, Inc. (Mar 2013 – Dec 2016)

Senior Consultant - OBIEE and Data Warehouse Managed Services

●Oracle BI Apps Data Warehouse

Implemented and support OBIEE 11g architecture and reporting conversion to better align with the corporate applications architecture for reporting with project ROI savings of 1.75 million dollars over 5 years.

Consulted and implemented full data warehouse solutions for multiple clients including manufacturing and utilities clients. Oracle based data warehouse solutions with both OBIEE and Microstrategy depending on the clients needs.

Integration was using Oracle Informatica Powercenter and DAC scheduling tool.

Technologies: OBIEE, BI Apps, Financial Analytics, Supply Chain Order Management Analytics, Oracle Fusion Middleware EM, Oracle BI Admin Console, Oracle R12, Informatica PowerCenter, DAC

C&S Wholesale Grocers (Oct 2002 – Jan 2013)

Sr. Manager/ Sr. Architect Data Warehousing

●Oracle Business Intelligence Data Warehouse

Implemented a full Microstrategy to OBIEE 11g architecture and reporting conversion to better align with the corporate applications architecture for reporting with project ROI savings of 1.75 million dollars over 5 years.

Acted as Senior Architect for new to company business intelligence platform Oracle Business Intelligence Enterprise Edition 11g.

Consolidated over 1500+ customer reports into standardized reporting dashboards for key business decisions as well as simpler production support, maintenance and upgrade ease.

Architect, designed security model and implemented entire security framework from LDAP groups. Security model was designed to scale for current and future business with groups to roles, roles to features/reports.

Technologies: OBIEE 11g, BI Apps 7.9.6, Financial Analytics, Supply Chain Order Management Analytics, Procurement and Spend Analytics, Oracle Fusion Middleware EM, LDAP, Oracle BI Admin Console, Teradata, DataStage

●Microstrategy Business Intelligence Data Warehouse

As the Senior Architect, managed a team of business intelligence and data warehouse specialists through numerous reporting projects supporting business subject areas for Procurement, Retail, Finance, Merchandising, HR Payroll, Sales, Customer Service Level and smaller specialized areas of decision support on an active data warehouse.

Inherited, improved and deployed new integration points across all major IS systems including XATA for transportation truck route data (web service), Lot Management System interfaces (Oracle), Deal and Incentive systems (BICEPS and Prompt), Mainframe systems for invoices.

Launched cutting edge service level interactive dashboards for external customers using content rich Flash files generated via Microstrategy. This was the first of its kind at the time of deployment. These files allow for customers to get updated service level detail information about their daily and WTD orders delivered directly to them automatically three times per day.

Implemented an entire data warehouse and reporting solution for a new Birmingham, Alabama based retail store segment. The retail industry was not part of their mainstream wholesale supply chain processes. This decision support solution were instrumental in providing the right business visibility to the acquired retail business that was losing $250,000 dollars per week into a profitable business within 1 year.

Technologies: MicroStrategy 8.1.2/9, Teradata, DataStage 7.5/8.5, BTEQ, SQL, Unix Shell Scripting, Tivoli Scheduler

●Web Application Programming / Portal Development

Managed development team and design process for the external customer portal implementation using open source Liferay Portal with embedded portlets using Java technologies. The customer portal allows independent retail stores to monitor inbound deliveries, track order status, item pricing, inventory out of stock and other customer facing data points.

Technologies: Liferay Portal, Java, JQuery, AJAX, HTML, SQL, Teradata, Oracle

Markem Corporation (1996 - 2002)

Web Development Technical Manager

●Web Application Programming

Managed a development team that implemented the initial Company marketing website using ASP for the first iteration. This website was later re-engineered with emerging Java web technologies; ASP, VBScript, Java, JSP, Javascript, SQL, MS SQL Server.

Managed a development team of 4 software engineers that implemented the Company technical support extranet web site.

Technologies: IIS, ASP, Java, JSP, Javascript, SQL, MS SQL Server

Contact this candidate