Brenner L.
Data Analyst

Skills

Tableau

Sql

Microsoft Excel (Advanced Analytics Add-ons)

Microsoft Sql Server

Python

Microsoft Azure

Brenner is available for hire

Hire Brenner L.

All Howdy Candidates are vetted for skills and english proficiency.

Bio

A Data Engineer with robust expertise in Data Warehousing, Business Intelligence, and SQL tuning, complemented by a background in Project Management and Agile Management (Scrum). Proficient in SQL Server databases and skilled in SQL tuning, as well as in executing ETL processes using SSIS and SQL scripts. Experienced in leveraging BI tools such as Power BI and Tableau to drive data-driven decision-making.

Power BI Developer
4/1/2023 - Present

Reviewed business requirements alongside key BI stakeholders and business units, delivering high-level solution designs to address specific challenges. Gained a deep understanding of business challenges, enabling the gathering and documentation of comprehensive requirements. Developed and maintained various Power BI data products, ensuring they met the needs of the organization. Stayed up-to-date with new Power BI features, continuously recommending improvements to enhance existing solutions. Provided mentorship to junior BI team members, facilitating their professional growth and technical development.
Senior Data Engineer
11/1/2021 - 3/1/2023

Executed a data migration project following the exit from the Irish market, focusing on extraction, transformation, and loading of key financial datasets including customers, mortgages, personal loans, deposits, and credit card accounts. Developed, tested, and ran ETL jobs using IBM DataStage, enhancing expertise in DataStage processes and workflows. Extracted and analyzed data through the execution of complex SQL queries. Created comprehensive reports using Power BI to visualize and interpret data insights. Identified and extracted non-performing products for sale to a third party, implementing data-driven decisions to streamline the migration process.
Senior Business Intelligence Analyst
9/1/2018 - 11/1/2021

Specialized in data analytics and visualization to deliver actionable insights and impactful recommendations for performance optimization across diverse business domains. Oversaw small-scale project management within the Analytics area, supporting various Business Intelligence (BI) teams globally.

For the Marketing Analytics Project targeting the German market, facilitated the implementation of SAP BusinessObjects by providing license keys, tools, user training, and troubleshooting. Managed project progress and budget adherence through regular weekly meetings.

On the Causeway Project for the UK/Ireland market, utilized analytical tools to develop Crystal Reports and Analysis for Office, and designed dashboards with Lumira Discovery and Lumira Designer. Provided extensive user training for these tools, controlled schedules via SAP BusinessObjects, and developed ad-hoc scripts using PowerShell.

In the Causeway Project for the Americas, adapted reports from the UK market for use in the Americas and transitioned all reports from Lumira Discovery/Designer to Microsoft Power BI.
Senior Database Developer
11/1/2017 - 9/1/2018

Designed, developed, reviewed, and tested SQL and T-SQL code to align with business and technical requirements. Led data modeling and database design efforts, applying and retroactively implementing appropriate standards. Planned and executed database changes in a structured and controlled manner to minimize customer impact. Reviewed, approved, and executed all database-related changes, advocating for high standards of excellence. Actively contributed to delivery management through participation in Scrum and Kanban meetings. Optimized query performance through effective data and index management. Ensured ETL processing to other repositories, including Business Intelligence systems, was optimized. Supported all reporting and Business Intelligence activities and initiatives. Identified repeatable operational database-related tasks and automated these processes using PowerShell and other appropriate tools.
Senior Business Intelligence Analyst
3/1/2015 - 10/1/2017

Supported the development of KPIs across various fundraising campaigns and key segments. Developed cubes and dashboards using the Microsoft Business Intelligence platform, and assisted teams in designing ad hoc reports to address critical business questions. Contributed to data quality and enrichment initiatives. Provided Power BI training to business users.
Database Administrator
6/1/2013 - 10/1/2014

Developed expertise in database maintenance and architecture to support a high-availability, large-volume risk management system. Managed database changes and demonstrated advanced skills in database and SQL query tuning using SQL Server, MySQL, Oracle, and PostgreSQL.
Senior Data Analyst
1/1/2012 - 6/1/2013

Designed and developed the ETL process, implementing data cleansing techniques to ensure high-quality data for analysis. Provided critical support to Data Scientists, facilitating the generation of accurate prediction reports. Designed detailed output reports for customers based on complex data analytics. Managed the processing of credit card transactions for a large customer base, handling around 6TB of data across 90 database servers, predominantly using SQL Server and MySQL.
Business Intelligence Consultant
8/1/2010 - 2/1/2012

Specialized in designing and modeling Data Warehouses with a focus on optimizing performance and storage efficiency. Managed the entire ETL process, including extracting, transforming, and loading data to ensure accurate and efficient data flow between systems. Oversaw the installation and setup of databases and business intelligence tools, ensuring seamless integration and functionality across platforms. Cultivated expertise in data warehousing best practices, ETL tools, and database management systems.