Mathew Flannery

Maplewood, NJ *****

973-***-**** • ad0rft@r.postjobfree.com

Data Warehouse Architect

Intrepid IT Architect with history of providing thoughtful and profitable solutions with rich interface and intuitive utilization.

Passionate data warehouse architect with over 20 years’ expertise in delivering end-to-end Business Intelligence solutions and executing change in diverse organizations. Talent for quickly assessing needs and discrepancies and discerning the most effective solution. Adept at gleaning new technical solutions from diverse sources. Well- prepared to increase productivity and revenue from within diverse technological environments. Extensive tenure in manufacturing and service organizations, with solid performance as a Full-Time employee and contractor. Dynamic and effective leader comfortable with teams of any size.

Database Design •Data Modeling • ETL Program Design and Development • Dimensional Analysis and Design

Change Management • Testing and Validation • Procedural and Declarative Coding • Problem Analysis and Resolution

TECHNICAL PROFICIENCIES

Software

ETL Software: Informatica 10, SSIS 2005, 2008, 2010, 2012, 2013, 2017, 2019, Talend, Oracle Data Integrator 11i, Cognos Data Manager 10.x, Task Factory, ZappySys

Database Clients:, Toad for Oracle 13, SQL Developer 19, SQL Server Management Studio

Data Sources: SQL Server DB, Oracle DB, PostGresSQL, Cassandra, MongoDB, CosmosDB, Rest APIs, Google Analytics, JSON, XML, CSV

Reporting Software: Tableau 10.x Desktop and Server, SSRS, SSAS, OBIEE, Cognos8 10, Cognos Series 7, Crystal Reports 8.5, R&R 5.0

Productivity Software: Jira, Ansible, Git, Erwin, Microsoft Teams, Microsoft Office, MS Outlook, Lotus Notes, Tidal Scheduler

Systems and Languages

Database Platforms: SQL Server 2000- 2019, Oracle 8, 11, 12.2, 19, DBase III,IV,V, MS Access, Lotus Notes 4.x, 5.x, 6.x, Flat File Systems

ERP Systems: Dealogic, WorkDay, PeopleSoft, Oracle JD Edwards, Flexible Trading System, CU TIMS 3.x, MestaMed, CST-Mercator

Operating Systems: Windows XP, Vista, 7, 8, 10, 11 Windows Server 2000- 2016

Languages: PL/SQL, T-SQL, Xml, JSON, Visual Basic .Net, LotusScript, Java

Cloud

Azure: Azure Data Studio, Azure Storage Explorer, SQL Server Managed Instance, SQL Server on VM

PROFESSIONAL EXPERIENCE

Data Warehouse Architect (May 2022 – Present) Bank of America Global Capital Markets, New York, NY

Transforming business requirements into flexible, dynamic data solutions. Analyze numerous Capital market deal systems including Debt, Equity, MNA, and Leverage Finance to design, develop and implement a single data warehouse solution. Incorporating a Data Lake to stage relational and non-relational data sources. Design Data Models for Bronze, Silver, and Gold levels of the Data Warehouse.

Key Achievements:

Designed, developed and implemented a process, using only native Oracle 12.2 functionality, to load the entire Dealogic data feed into an Oracle schema. The feed came in a weekly snapshot of over 10,000 xml files and daily incremental updates of several hundred xml files. Extracting the data from 12 complex nested xml structures. Completed in two months. Employed Oracle SQL*Loader and PL/SQL Stored Procedures

With the Dealogic data loaded into an Oracle schema proceeded to develop complex Views to replicate the Dealogic Cortex UI. Eliminated six manual processes of downloading data from Cortex into Excel spreadsheets saving 2 hours of daily work. Completed in two months. CTE’s and in-line view were necessary to fulfill this requirement.

Used Informatica Power Center 10 Repository Manager, Designer, Workflow Manager, and Workflow Monitor to develop, test, and deploy Informatica ETL jobs.

Used Jira to track Agile development progress, Git repository for checking in the code, and Ansible for DDL deployments.

Data Warehouse Architect (November 2014 – April 2022)

Edison Properties, Newark, NJ

Edison Properties is a large privately-held company that operates parking and storage locations in the Northeast.

Analyze business requirements to create custom data warehouse solutions. Evaluate existing systems and processes to determine design needs and commence development of new architecture; extract needed data and business rules from previous system. Test, troubleshoot, and report performance of new system. Initiate go-live and work cross-functionally with various business units to verify performance. Design and create SSRS reports.

Key Achievements:

Leading Migration of SSIS jobs, SSRS reports, and Tableau environments from On-Prem to Azure Cloud. Used Azure Data Storage, SQL Server Managed Instances, and Windows Virtual Machines to move the entire reporting environment running on 40 cores (ten servers) On-Prem to 8 cores ( two servers) in the Azure Cloud. This included performance tuning of ETL and Reporting queries

Engineered and enlisted a new Tableau Server environment of 40 server users and five developers. Added Removing Users, Creating Groups, Establishing Security, backing up content, and using Tabcmd for automation. Designing dashboard with click through functionality, LOD and Windowing calculations

Single handedly completed the entire SDLC for two data warehouses based on Kimball design. This included Business Requirements, Analysis, Data Modeling Design, Data Modeling Development, ETL Deployment and Productions Support. Manhattan Mini-Storage ran their entire business on my data warehouse from 2016 to 2022 when it was sold for a record-breaking deal price of 3.2 billion USD in the storage industry space. The second data warehouse was for the ParkFast business which runs 35 parking lots in the Newark/New York City area. Built hundreds of complex SSIS packages and stored procedures. Developed SSRS reports, Tableau Dashboards, and detailed documentation to facilitate the Business analysts’ efforts.

SME Consultant (October 2013 – December 2016)

Praxair, Inc, Danbury, CT

Over the course of 12 years, I worked as an employee and contractor in several roles for Praxair, Inc.

Served as SME for the Global Data Warehouse team. Documented knowledge transfer of business applications and ETL processes. Supported existing processes and collaborated on projects for new ETL development.

Data Warehouse Architect (March 2004 - September 2013)

Praxair, Inc, Danbury, CT

Provided Business Intelligence Solutions to diverse business groups worldwide; served as key member of the Global Data Warehouse team. Planned and executed architecture projects from scope definition through ongoing maintenance and enhancement. Helmed project teams; coordinated assistance and guidance over multiple programs. Cultivated relationships throughout the organization to leverage subject matter expertise and deliver effective and cost-efficient solutions. Excelled at star schemas in functional areas of General Ledger, Sales, Accounts Receivable/Payable, and Fixed Assets; utilized conformed dimensions to provide enterprise reporting across data marts.

Key Achievements:

Converted over 150 IBM Data Manager ETL jobs to Oracle Data Integrator

Rebuilt the Necho data warehouse, which resulted in a 75% reduction in load time and tie-outs.

Increased productivity in existing ETL processes, data marts, and reports through, enhancements and redesign.

Pioneered the use of SSIS at Praxair as an ETL tool to complement T-SQL and IBM Data Manager.

Performance improvements on SQL queries for ETL, Reporting, OLAP and OLTP

Vice President Sales & Technical Services (October 2013 - October 2014)

RCMA Americas, Inc., Norfolk, VA

I worked for RCMA in several capacities from 2001-2016.

Directed the business intelligence infrastructure; managed process changes to migrate to new platforms. Developed consultative sales and customer relationships. Interfaced with divisional offices worldwide to create larger and more facile solutions for the global organization.

Key Achievements:

Replaced existing Lotus Notes\Domino and Crystal Reports reporting environment with Talend, SSIS, SSRS, and SQL Server 2012, resulting in exponential growth in productivity.

Identified and cultivated new major accounts for natural rubber business; diversified the end use customer base and increased overall profitability.

SME Consultant (February 2001 - September 2013)

RCMA Americas, Inc., Norfolk, VA

Implemented CST-Mercator software ERP system to replace manual purchase, sales, and inventory tracking. Synchronized business processes to system functionality. Led data entry teams; provided ongoing training and authored the system training manual. Executed transition to Lotus Notes/Domino Application to corporate locations across the globe.

Key Achievements:

Designed a Lotus Notes\Domino Application to overcome the limitations of CST-Mercator’s DOS based interface and reporting capabilities, increased productivity.

Additional Professional Experience includes Lotus Notes Developer, for Praxair, Inc., Systems Consultant, for RCMA Americas, Inc., Operations Manager, IT Services Manager, and Technical Service Representative, with Lewis & Peat Rubber, L.P.

EDUCATION & CREDENTIALS

B.S., Chemical Engineering

Clarkson University, Potsdam, NY

Contact this candidate