Business Intelligence Data Engineer

S T EVE OMALE

DATA ENGINEER/BUSINESS INTELLIGENCE PROFESSIONAL

CONTACT PROFILE

847-***-****

*****.*****@*****.***

Experienced in BI solution design, development and implementation, data warehouse deployments, cloud

solution integrations, consulting, project management. Possess excellent verbal and written communication skills to effectively facilitate group and individual discussions, provide training, create documentation, negotiate and influence. Flexibility in responding promptly, thoughtfully and effectively to changing work environments and new situations.

• Translate complex business data requirements into logical/physical data models.

• Facilitate the availability, access, security, and integrity of the organizational data warehouse,

including core Business Intelligence data, as well as critical operations data.

• Implement enterprise wide, and regional business intelligence solutions by leveraging integration with Cloud Technologies.

• Develop ETL processes supporting data warehouses, clouded BI environments and integrated data marts

to incorporate new business data including

acquisition and “Spin Off” scenarios.

• Spearhead multi-functional teams in defining

business requirements, identifying options, selecting optimal solutions, and manage project

implementation.

SKILLS EXPERIENCE

MS SQL Server

Azure SQL

MS SSIS

PowerBI

Netsuite

Workato

Marketo

Senior Database Developer

National Restaurant Association

Chicago, Illinois

April 2019 – Present

• Lead multifunctional teams in designing and

implementing Business Intelligence solutions in Power BI, enabling tracking of key performance indicators and program effectiveness.

• Supervise/Manage and work alongside technical

contractors brought in for specific projects.

• Provide primary support for an Azure-based data

solution, integrating Synapse, Azure SQL, and

Medallion architecture (Gold, Silver, Bronze).

Designed and managed pipelines, enabling Power BI

reporting to track key performance indicators and

measure program effectiveness.

• Design, implement and maintain data marts

leveraging the existing data warehouse using the SQL Server toolset.

• Build and support integrations between Salesforce and Marketo, Netsuite and Marketo using Workato,

analyzing JSON code to troubleshoot integration

issues that pop up from time to time.

• Spearhead requirements definition sessions to

achieve effective data integration between

operational departments e.g. Finance, Marketing

and Sales, to accomplish effective data integration and Power BI solutions to track key KPIs.

• Develop integrations between clouded systems like Netsuite, Salesforce, One Trust and Workato.

• Streamline ETL processes with SQL code improving stored procedures, triggers, SSIS packages, and SQL jobs where appropriate.

• Manage integrations between Salesforce, Marketo, Netsuite, and Workato, resolving issues that may pop up.

• Spearheaded data migration projects and led

compliance efforts around the California Consumer

Protection Act (CCPA) data retrieval and

obfuscation process.

• Involved in efforts to migrate existing SQL data warehouse into MS Fabric.

Business Intelligence Analyst

Weiman Products LLC

Gurnee, Illinois

May 2018 – April 2019

• Led the design and implementation of a data

migration effort to a cloud based BI product (Domo) and Power BI.

• Developed, supported and implemented new

versions and report enhancements of MS-excel, MS-

access and Qlikview Reports.

• Profiled and resolved SQL database issues caused by inefficient queries.

• Created standardized solutions from multiple different requests and datasets.

Business Intelligence Analyst/Datawarehouse Developer Terlato Wine Group

Bannockburn, Illinois

June 2016 – May 2018

• Developed a SQL Server upgrade strategy to move

the data warehouse from an unsupported version of

SQL to version 2016.

• Designed and implemented data access objects

(stored procedures, SQL statements) for improved

reporting.

• Identified BI needs, goals, and opportunities by partnering with key stakeholders, and data subject matter experts and Built comprehensive dashboards

and reporting while utilizing multiple data sources (flat files, database servers, etc)

EDUCATION

Northern Illinois University

2000 – 2002

MSc. – Management

Information Systems

DeKalb, Illinois

United States International

University - Africa

1994 - 1997

BSc. Management

Information Sysyems

Nairobi, Kenya

Contact this candidate