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 homegrown MySQL, Postgres, and SQL Server systems) • 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• Reverse-Engineering ETL from our warehouse back to various source systems to identify data issues• Supporting a Essbase/Hyperion Planning cube system with nightly ODI integrations• Tasks listed below ...SR. DATA WAREHOUSE/ETL DEVELOPER (June 2017 - August 2018)• Constructing & troubleshooing complex Informatica mappings & workflows; integrating slowly changing dimensions with our fact tables• Working with DBAs and Sys Admins to configure ETL tools, tweak security settings, and complete upgrades of various software packages• Loading data to our warehouse on various schedules (hourly, nightly, monthly, etc.) using a combination of Informatica workflows & Jenkins jobs• Communicating with financial & business analysts to validate data warehouse results• Constructing physical, business model, and presentation layers within Oracle Business Intelligence EE (OBIEE) to support self-service reporting & dashboards throughout NREL• Software/Tool use: Oracle 12.2, PL/SQL Developer, Oracle SQL Developer, Informatica PowerCenter (9.6.1, 10.2, 10.4), Oracle Data Integrator (ODI), Yellowfin, Jenkins, OBIEE, Bash, SQL (Oracle/Maria/MySQL/SQL Server dialects)

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 help them develop their MEP strategy for RAP for Recruiter• Constructing and implementing our scalable EDW with 30+ star schemas• Cleansing raw data sets using R programming; inputting cleansed data to our data store• Tasks listed below ....BI/DATA WAREHOUSE DEVELOPER (March 2012 - August 2014)• Creating, modifying, and maintaining ETL mappings using Oracle Warehouse Builder and Oracle Data Integrator• Constructing new PL/SQL packages (functions, procedures, and triggers) to simplify and more efficiently process our data• Supporting 80+ self-service BI report authors on Cognos 10 & 11 platforms• Tuning ETL mappings, SQL, and PL/SQL code through the use of statistics, indexing, Oracle tuning advisor, explain plans, and other tuning mechanisms• Maintaining ODS, EDW, and report source code using GIT• Modifying several hundred database objects (packages, views, triggers, etc.) from our vendor's vanilla ODS software to work in a highly customized VPD MEP environment• Planning, testing, and implementing patches & updates to our Ellucian ODS & EDW systems while maintaining customizations and configurations• Maintaining data replication using Golden Gate, Oracle Streams, and Data Pump• Creating succinct documentation for all processes and projects• Overhauling our Cognos security implementation, converting folder-based security to a role-based security model

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• Converting to and maintaining a web-based telefunding database system while applying all appeal results and gifts/pledges back into Advance• Training users on proper data-entry techniques while documenting all policies & procedures with screenshots• Tasks listed below .....PROGRAMMER/ANALYST (February 2002 - June 2005)• Interacting with the Annual, Major, Planned, and Special Giving departments to devise useful reporting methods which allowed us to successfully identify targets, track goals, and set objectives to achieve our donor-campaign goals• Creating SQL scripts (queries) and ad-hoc Powerbuilder reports on Oracle 9i and 10g platforms for our Sunguard (Ellucian) Advance product• Writing SQL scripts which ensure data integrity• Keeping the office hydrated by changing out 5 gallon water jugs two times per day• Adding humor to my resume by listing water jug changes as a job duty• Teaching CSM 101, a one-credit success seminar, to incoming freshmen while acting as their campus advisor

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• Providing phone support to both users and co-workers

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