Bryan M. Email & Phone Number

Golden, CO, US

• DATA ENGINEER (August 2018 - Present)
• Integrating and performing ETL between many disparate data sources (Oracle EBS, Hyperion Planning & Essbase, Salesforce, Concur, FileMaker, Project Server, Workday, FAMIS Cloud, ServiceNow, flat files, and many.
• Working with end users, project managers, and visualization experts to design a useful and efficient data architecture
• Maintaining and designing a dimensional EDW (star design) on an Oracle 12.2 (LINUX) platform
• Converting from OBIEE to Yellowfin reporting system. Designing logical views, and building new data marts to support a new reporting environment
• Developing QA systems to ensure our warehouse is continually meeting logical constraint specifications. Fixing bad data when problems arise

Denver, CO, US

• BUSINESS INTELLIGENCE TEAM LEAD (August 2014 - June 2017)
• Leading a team of 4 BI developers who develop database objects and write actionable reports & dashboards to track KPIs, strategic goals, and operational needs
• Liaising between business and technical audiences to transform business requirements into actionable and effective technical solutions
• Developing expert knowledge in the process of MEP (Multi-Entity Processing) database customization; leading MEP conversion for all upgrades/patches for Ellucian's ODS and EDW. Worked closely with Ellucain developers to.
• Constructing and implementing our scalable EDW with 30+ star schemas
• Cleansing raw data sets using R programming; inputting cleansed data to our data store

Golden, CO, US

• ASSISTANT DIRECTOR OF IT (June 2005 - February 2012)
• Performing ETL and migrating data between our databases and external systems while data munging. Working with Sunguard (Ellucian) Advance DataLoader
• Upgrading Sunguard (Ellucian) Advance software from v5 to v9.1 through the years
• Installing Oracle patch sets as needed to production and test databases
• Managing hot/cold physical/logical Oracle 10g backups using RMAN, Import/Export, Data Pump, and Flashback
• Converting our production database from Oracle 9i to Oracle 10gR2

West Des Moines, IA, US

• Working in focused groups configuring and installing NT 4 Servers
• Interacting with Motorola routers and frame relay networks
• Debugging SQL code for accounting applications on SQL Server platform
• Reconfiguring Webramp routers enabling VPN connections to the corporate office
• Remotely installing accounting and training applications through our LAN
• Relocating SCO Unix servers in 100+ locations while rewiring DLC lines

Oskaloosa, IA, US

• Placing purchase orders for customers while providing excellent customer services
• Aiding customers in the design of prototypes
• Designing and pricing custom made-to-order parts
• Correcting minor accounting errors
• Maintaining good business relations with internal sales representatives

Master'S Degree, Computer Science - Database Technologies

Bachelor'S Degree, Mis

Education record