Luz Gabriela Lopez
I am an end-to-end BI analyst with 7 years of experience creating data models and impactful visualizations for executive and analyst level consumption.
I am an end-to-end BI analyst with 7 years of experience creating data models and impactful visualizations for executive and analyst level consumption.
Owned end to end dashboard development work streams from requirements gathering to data staging and report building. Identified and communicated high impact performance metrics, reflecting quick understanding of internal processes, client needs and products.
· Assisted in creating GAP analysis and documentation of report functionality of excel vba and power query reports
· Facilitated the expansion of existing client reporting to additional clients by recreating custom business rule logic in multiple layers of power query table cleansing and remapping legacy SQL server values to the new databricks structure
· Worked closely with stakeholders to analyze business needs, gather requirements, gauge project development scope, map out data models, and perform data analysis to provide actionable business insights
· Streamlined the new Power BI report daily scrum call by implementing an improved method of triaging and sub-task creation and Jira task assignment procedures allowing for more productive bug status facilitation during go live
· Headed the overhaul of continuous development python, SQL, and Qlik Sense training programs to uplevel the skills and understanding junior and entry level analysts
Managed the implementation of Master Data Management to ensure the quality and accuracy of data across multiple systems. Oversaw the creation of new data models in Profisee for master data standardization.
· Developed and maintained efficient SSIS processes for data ingestion and data integration from Oracle, Profisee, Salesforce rest API, as well as the multiple ERP systems and data sources
· Created and maintained Power BI dashboards to help leadership track department wide key performance metrics for data that was not previously tracked
· Communicated status, progress, roadblocks, and made recommendations to stakeholders, and executive managemen
· Presented process improvements for data engineering development and version control for ETL processes, reflecting deep understanding of internal systems and workflow scalability needs with the expansion of the departmen
· Led agile sprint meetings to ensure junior developers stayed on track and communicated progress status, roadblocks, and made scheduling recommendations to stakeholders and executive managemen
In the summer, I enjoy looking for new places to walk or bike. My favorite bike trail in Kansas City is the Line Creek Trail.
In the colder or very hot days I will often relax indoors and read. Last year my favorite books were, Know My Name by Chanel Miller, Cloud Cuckoo Land by Anthony Doerr, and The Name of the Rose by Umberto Eco.