Business Intelligence Power Bi

KIM CHAVEZ

Phoenix Az ***** · 602-***-****

********@*****.*** · PowerBI Certified

EXPERIENCE

SEPTEMBER 2022 – CURRENT

BUSINESS INTELLIGENCE DEVELOPER, bcbs of az

Responsibilities include but not limited to:

oResearched and design data schema for claims, contacts, and operational reporting purposes

oBuilt, maintained, and troubleshoot SSIS jobs to ensure accuracy and timeline run of data processes

oDeveloped and maintained Tableau dashboards

oSpearheading Power BI incorporation and Proof of Concept built out for migration from Tableau

oCollaborate with stakeholders to successfully develop and provide key metrics to leaderships

Accomplishments:

oSuccessfully built out proof of concept for PowerBI in comparison to Tableau

oMigrated 80% of operational reporting and dashboard to PowerBI using with dashboard and paginated reports

oBuilt out data structure for contacts strategy and eliminating manual processes

AUGUST 2020 – MARCH 2022

BUSINESS INTELLIGENCE DEVELOPER, corbins electric

Responsibilities include but not limited to:

oDeveloped and maintained business intelligence data to produce dashboards and polished presentations, highlight findings, and recommending changes

oConducted interviews with key business users to collect information on business processes and user requirements

oDesigned data marts (star and snowflake schemas) for financials and HR processes

oDesigned ETL using SSIS packages to load data marts with data extracted from heterogenous data sources

oDesigned business process flow and functional requirements for streamlining development of a BI solution

Accomplishments:

oSuccessfully designed and developed data marts and Power BI solution for company’s financial statement and HR insights

oStreamlined Accounting process and eliminate manual processes and errors

oPerformed data analysis and built PBI visualization for project specific which helped recover promised compensation

JUNE 2018 – JULY 2020

REPORT/SQL DEVELOPER, ISAGENIX, INC.

Responsibilities include but not limited to:

oDesigned, developed, and maintained SSRS reports for internal and external customers through SharePoint and .NET

oDesigned, developed, and maintained PowerBI dashboard through SharePoint and PowerBI Portal

oCreated complex stored procedures, functions, tables, view and other SQL code

oCreate and maintain SSIS packages to process data

oConfigured, maintained, and supported SQL reporting servers

oUsed MDX to build reports and PowerBI dashboard

Accomplishments:

oSuccessfully implemented the documentation process and increase report/dashboard inventory by 30% for efficiency

oStreamlined onboarding process for report, business intelligence, and database developers

oLearned and administered Sharepoint for reporting/dashboard access and usage maintenance

JANUARY 2005 – JUNE 2018

LEAD BUSINESS INTELLIGENCE DEVELOPER, university of phoenix

Responsibilities include but not limited to:

oDesigned, developed, and maintained reports SSRS and Crystal Reports for internal customers using SQL and PL/SQL

oBuilt and manage suite of Salesforce reports for users

oModeled data, built and maintained PowerBI dashboard for operational KPI

oDesigned, developed, and maintained Salesforce reports and dashboard along with permission and role

oCreated complex stored procedures, functions, tables, view and other SQL code

oCreate and maintain SSIS packages to process large amount of data

oConfigured, maintained, and supported SQL reporting servers

oInvolved in data projects to identify opportunity for data report and optimization

oServed as Lead and Subject Matter Expert for team members and other teams

Accomplishments:

oStreamlined QA process to increase efficiency and accuracy of reports

oAssisted in project where SSIS was used to extract, modify, and load data into Salesforce that resulted in 500+ hours saved

oDesigned and maintained suite of reports and dashboards for new clients onboarding in Salesforce

oAssisted Zip-tone project working with multiple technical teams providing reports and analysis to increase efficiency and improve customer retention

EDUCATION

JULY 2022

MICROSOFT CERTIFIED: POWER BI DATA ANALYST ASSOCIATE

MAY 2011

BACHELOR OF SCIENCE IN ACCOUNTACY, university of phoenix

MAY 2008

MASTER OF SCIENCE IN INFORMATION SYSTEM, university of phoenix

MAY 2003

BACHELOR OF SCIENCE IN INFORMATION SYSTEM AND GLOBAL MANAGEMENT, arizona state university

SKILLS

Proficient with Power BI and DAX skill in building story telling dashboard Strong customer service skills including verbal and written communication skills

Strong data analysis and problem-solving skills

Proficient in different data language T-SQL, PL/SQL, AWS Redshift, and so on

Effective prioritizing skills and work well under pressure and low to no supervision

Demonstrated experience delivering effective visualizations to business users

Very strong SSRS and Crystal Reports skill

Excellent interpersonal skills and ability to work well within a team

Excellent organization skills and can adapt quickly to changes

Able to quickly digest new information

Attention to detail, accuracy, and quality of output

ACTIVITIES

Volunteer Work: actively volunteering with different organizations to improve the environment and the lives of people. For example: Habitat of Humanity, St. Mary’s Food Bank, and getting with friends to clean different area of the city

Travel: planned and executed yearly trips with friends and family. Following Dave Matthew Band with spouse to different locations yearly

Reading: interested and have read many technical and non-technical books

Contact this candidate