Alexander Grando
BI Analyst · Lincoln Property Company
Tustin, CAWork Experience
BI Analyst
Lincoln Property Company2017 – 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 Health2015 – 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 Track2014 – 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 University2016
Master of Science in Information Systems
Bachelor of Arts in Information Systems
California State University2013
Bachelor of Arts in Information Systems