Bryan Lemmer Email & Phone Number

Beaverton, OR, US

Portland, Oregon, US

• I currently work on a small squad which develops pipelines for our fraud system.
• Assisted in the migration of our databases from SQL Server and SSIS packages from 2012 to 2017
• Assisted in the nCino integration
• Assisted in Snowflake integration
• Assisted in setting up MS Azure integration with our Reporting Datamart

Portland, Oregon, US

• Worked on a small agile scrum team implementing a SourceRecon project. This team also worked on new/updated features for the fraud system.
• Lead the effort to move from TFVC/TFC to Azure Devops (ADO) and GIT.
• Collaborated with our data teams to create a branching strategy.
• Collaborated with our data teams to create the initial build and release pipelines which were implemented across our projects.

Portland, Oregon, US

• Part of small agile teams focused on developing a CECL (Current Expected Credit Loss) solution for bank regulatory compliance and an email marketing solution.
• Extract, transform and load data from the EDW into the CECL and Marketing data marts using SQL/T-SQL (Server 2012) and SSIS based on business requirements.
• Read and produce flat files (csv) through SSIS for integration with other internal and external credit model systems e.g. Moody’s
• All packages run through JAMS scheduler
• Solutions source controlled through TFVC and GIT

Hedehusene, Denmark, DK

• Supervise a global ETL team (USA, India and South Africa)
• Responsible for all ETL deliverables
• Develop data warehouse and ETL frameworks from the ground up using IBM DataStage and SQL Server o Develop an operational data store (ODS) for operations data o Develop an operational data store (ODS) for Oracle.
• Advise architects on structures and techniques that worked as well as issues encountered while developing the legacy data warehouse.
• Develop a Movement Cost Allocation (MCA) system based on complex business requirements. E.g. if there are multiple shipments on a movement what percentage of the cost is allocated to each shipment in a container.
• Develop a profit/loss system based on Movement Cost Allocation. Is the booked shipment with the current settings profitable for the company?

Hedehusene, Denmark, DK

• Manage a small team of ETL Developers
• Collaborate with BA and reporting team in JAD sessions to understand new requirements from business as well as reporting team requirements
• Working with BI Director to understand our department strategy based on the corporate vision and work with the team to come up with a tactical plan to achieve these goals.
• Work with the ETL developers to ensure they have a clear understanding of the problem and their tasks
• Meet with other BI divisions within the company for a knowledge sharing session once a month

Hedehusene, Denmark, DK

• Enhancements and maintenance of a mature data warehouse using IBM Cognos Data Manager and Oracle PL-SQL
• Enhancements and optimization of Oracle packages and functions
• Fact and Dimension creation using IBM Cognos Data Manager
• Developing efficient job steams within IBM Cognos Data Manager
• Work with ETL Manager to understand requirements for new projects or enhancements

Hedehusene, Denmark, DK

• Used Cognos Report Studio to create client specific reporting on top of the OLTP system.
• Developed SQL based reports in Cognos Report studio

Developed the Data Access Layer and Business Logic Layer for the web application.

• Internal web application developer for the company
• Created an order management system from scratch. This system was used by the sales people to create, track order and to print out quotes in PDF form.
• Created a management Console for directors to look at aggregated data based on the Order Management System. E.g. Which Sales person had the highest revenue in May 2007 etc. There was also the facility to approve orders.
• Created a web service for a lead generation site. When the user clicked SUBMIT on the landing page the information was passed to the web service which then added the information into a database in the DMZ.
• Created a Cloud9 system which was a customer portal based on data from a cube. Used MDX statements to write the code behind the reports.

• Enhancements and maintenance of all web based applications using VBscript and SQL Sever
• Used MS Access to develop a container packing application to keep track of collapsible containers within a shipping container. Tracked dates when the collapsible containers were shipped back to General Motors, which.

Sql Server Data Integration And Sql Server Development

Bsc, Computer Science

A+ Certification

Pc Engineering