Business Intelligence Developer resume title

Edwin Kerauni

Phone: 214-***-****

Grand Prairie, TX 75052 Email: **********@*****.***

Passionate, dedicated, and self-motivated professional with a strong desire to leverage my experience and education. A quick learner that is a self-starter who requires minimal supervision to excel in a dynamic environment.

Experience

Calyx Software Dallas, Tx 04/2023 - Current

Bi Developer

Generating ad hoc and regular reports for clients and regulatory bodies based on needs using either Crystal Reports, Stimulsoft Bi Designer, SSRS or Power Bi Publishing the same reports to the clients LOS (Loan Origination Software) for UAT /Or Production.

Creating and reviewing queries, and views necessary to support SSRS reports, Stimulsoft Bi Designer and Power Bi Dashboards

Utilizing Power Query and DAX functions in Power BI for reporting purposes.

Reviewing existing reports for data accuracy. Proposing resolutions for quality issues of limited scope to more senior level analysts/supervisor and escalates complex quality issues to supervisor or senior staff for resolution.

Identifying and interpreting trends and patterns in datasets to locate influences.

Responsible for data governance processes and quality in assigned area of responsibility.

Zebra Technologies Fort Worth, Tx 05/2022 - 04/2023

Bi Developer/Business Analyst

Created and reviewed stored procedures, queries, and views necessary to support SSRS reports and Power Bi Dashboards

Utilized Power Query and DAX functions in Power BI for reporting purposes.

Reviewed existing reports for data accuracy. Proposing resolutions for quality issues of limited scope to more senior level analysts/supervisor and escalates complex quality issues to supervisor or senior staff for resolution.

Identified and interpreted trends and patterns in datasets to locate influences.

Responsible for data governance processes and quality in assigned area of responsibility.

LightBeam Health Solutions Irving, Tx 10/2019-04/2022

Bi Developer

Developed Ad-hoc reports through SQL Server Reporting Services (SSRS) and maintained existing reports in the client’s environments.

Designed and developed stored procedures, queries, and views necessary to support SSRS reports and Tableau charts.

Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

Implemented several DAX functions for various calculations for efficient data visualization in Power BI.

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

Collaborated with team members in the development and implementation of projects through Source control to get work done faster.

PennyMac_FortWorth, Tx 05/2017-8/2019

Bi Developer

Created reports using SSRS to visualize data in support of the Tax Department among others saving the company a lot of FTEs hours.

Utilized Power Bi to create dashboards and other reports as per business requirements. Utilized Power Query to clean up data and created data models for executive level reporting.

Gathered business requirements from different business units, Tax, Escrow, Loan Boarding and credit corrections.

Created monthly executive departmental reports using Visio to create Org charts, functional org charts and P Tree.

Performed User Acceptance Testing and redlining every story to obtain business signoffs.

Collaborated with management and staff in the development and implementation of all projects and/or initiatives related to operational goals and/or process improvement directives.

Texas Instruments_ Dallas, TX 06/2015-02/2017

Bi Developer

Used SSIS features like package event handlers, property expressions, and package configurations, transactions in packages, checkpoints, and protection levels.

Experienced in creating operational drill down, drill through, parameterized reports, using SSRS.

Generated adhoc and periodical reports based on the statistical analysis of the data from various time frames and divisions using SQL Server Reporting Services.

Wrote SQL code to enable extraction, transformation, and loading of data ensuring compatibility with all tables and specifications.

Experienced in using T-SQL creating tables, stored procedures, views, indexes, user defined functions, database models and data Integrity in SQL Server 2012 and 2014.

Worked with internal business clients to solve problems with data loading or integrity issues.

Education

Keller School of Management 2012

Master’s Degree

University of Texas at Dallas – Richardson, TX 2010

Bachelor’s Degree

Technical Skills

Power Bi

Power Bi Desktop, Power Query and DAX functions

Report Tools

SQL Server Reporting Services (SSRS), Stimulsoft Bi Designer & Crystal Reports

Languages

T-SQL

Operating System’s

Windows server2008/2003/XP/Vista, Windows 10

Source Control

Source Tree, Atlassian’s Bitbucket

Mortgage Tools

experience with MSP (Black Knight), LOS

Office Tools

MSWord, PowerPoint, Excel, Visio, OneNote, Smartsheet

Contact this candidate