AG

Alexander Grando

BI Analyst · Lincoln Property Company

Tustin, CA

Work Experience

BI Analyst

Lincoln Property Company

2017 – 2021

* Redeveloped and enhanced the back-end and front-end of approximately 5 data marts in Qlik Sense and QlikView. * Redeveloped and enhanced approximately 4 master dimensions and 4 extract apps for the data warehouse. * Trained approximately a total of 80 clients to use the existing business intelligence apps. * Developed automated executive-level and administrative reports using Qlik NPrinting. * Maintained, troubleshot, upgraded, and improved reporting solutions. * Assisted in migrating BI servers to Google Cloud. * Maintained integrity of Microsoft SQL and PostgreSQL databases.

BI Engineer (Internship)

Modern Health

2015 – 2015

* Performed data profiling on new sources of reports and tables to be integrated into the data warehouse. * Generated reports using Excel with pivot tables. * Developed scripts in SQL Server for data validation between reports and the cube. * Created a data warehouse sales cube using SSAS. * Performed data mining to increase sales profits using the sales cube.

IT Support Specialist (Internship)

Pacific Couriers / Pac Track

2014 – 2014

* Installed and troubleshot software and hardware. * Advised on tech purchases for upper management. * Designed numerous electronic and physical forms. * Advised on expansion of company using business analytics. * Designed database and system blueprints for future information system.

Education

Master of Science in Information Systems

California State University

2016

Master of Science in Information Systems

Bachelor of Arts in Information Systems

California State University

2013

Bachelor of Arts in Information Systems