Diana Lopez Email & Phone Number

Rockford, Il, Us

San Francisco, California, Us

- Provide mentorship to 20+ racially and socioeconomically diverse students employed by Walmart or Amazon in the Business to Business (B2B) Data Analytics Certificate Program, which allows businesses to provide additional educational opportunities to their employees through the Springboard curriculum- Graded 300+ assignments, quizzes, and projects for mentees, providing feedback to the mentee in a timely manner in order to ensure the student completes the program on time- Meet with mentees weekly to provide grading feedback, share professional career insights, and encourage mentees through their career transition into data analytics - Tailor meetings to each mentee based on their strengths and opportunities for growth, providing guidance and teaching to target curriculum competencies such as critical thinking, analysis planning, statistics, Excel, business intelligence tools, SQL, python, and presentation skills- Partner with students to create exemplary capstone projects by approving mentee dataset choice, providing guidance on their analysis plan, delivering feedback on their Tableau or Power BI presentation, and overall helping them develop weekly goals to ensure the project is completed on time

Elmhurst, Illinois, Us

- Prepare 40+ Excel reports (daily, weekly, monthly) and Microsoft SQL Server data audits every month that capture crucial product launch workflow management KPI metrics and flag data quality issues in the data warehouse, ultimately providing management with quick and actionable insights- Create and maintain ETL automation of 10+ reports and audits via SQL stored procedures and VBA programming, ensuring our data pipeline runs smoothly for our end users- Support database operations of 50+ SQL tables and 20+ SQL stored procedures, fixing any query and database processing errors via root cause analysis- Oversaw creation of an Entity-Relationship Diagram (ERD) for our database, a net-new document/visualization in Mural for the team, effectively improving speed of ETL process changes, decreasing average research time by approximately 50% overall- Manage Flokzu, a workflow automation software, which includes account creation, user permissioning, workflow map/logic updates, javascript programming for custom field logic, task changes, data exports, etc.- Provide Flokzu admin support to end users by completing 50+ weekly support requests in a manner that maintains our data quality and integrity, leading to less manual updates to our data and satisfied users- Spearheaded the creation of an onboarding program for new analysts, including the assembly of two detailed Mural boards focused on task documentation and onboarding planning, resulting in a streamlined and effective onboarding process- Successfully tailored the onboarding process for a new analyst with a data engineering background, focusing on data concepts and database structure, leading to positive feedback and efficient integration into the team

Philadelphia, Pa, Us

- Managed 9 of the top 10 US dashboards with over 2.3 million dashboard runs and 50 million query runs- Created 10+ dashboards (multi-viz reports) and 30+ looks (single viz reports) with 300,000+ runs and wrote 2000+ lines of LookML/SQL to surface key KPI metrics including inventory, order quality, and ops performance - Maintained and oversaw change management of 60+ Looker data products as an admin, which included updating filters, removing/adding new measures, writing LookML, using HTML, and maximizing Looker performance- Implemented 5+ SQL models through initial query creation and validation in Snowflake, further validation by operations leaders in a LookML derived table in Looker, and productionalization in dbt Cloud- Identified expiration request compliance and provided further insight into our overall expired inventory workflow in order to decrease the 5% expiration request incomplete rate discovered through the query- Identified root cause of order edits as being either false order edits, controllable order edits, or true order edits in order to decrease the almost 40% of false or controllable order edits discovered through the query- Integrated new HRIS system, Workday, into our data pipeline to ensure that there are no gaps in labor data/reporting from Snowflake ingestion to end user dashboards/reporting- Used best practices (version control, data testing/validation, continuous integration/delivery, etc.) to union 3 Workday source tables and 6 historical Ultipro/Humanity source tables via staging, intermediate, and final models- Established team processes for requests, task tracking, and data product cataloging using Asana and Lucidchart- Successfully created and launched the first onboarding program for the Operations Analytics team as we brought on 3 new analysts at once, using Asana to create an onboarding template, facilitating meetings between new analyst and stakeholders, and providing informational sessions on our main tools and processes

Bethesda, Md, Us

- Used a multinomial logistic regression model to examine acculturation, depression, and sleep duration in a cross-sectional data set of 4,700 Mexican American adults- Detailed over 10+ data analysis plans with clear inputs/outputs, R/Python code (at least 80%), and pseudocode to be sent to consultants for data analysis completion- Used latent class analysis and multinomial linear regression models to identify/examine subgroups of mothers experiencing intimate partner violence and the likelihood of HIV testing in 2,809 Tanzanian mothers- Used a multinomial logistic regression model to investigate race/ethnicity, immigrant generation, and suicide in 6,250 adolescents as well as the familial patterns of suicide attempts and chronotype among 1,504 individuals- Managed recruitment for a large-scale mental health family study, contacting 200+ participants, scheduling 100+ clinical visits, and conducting various testing in a clinical research setting

Master Of Science - Ms, Data Science - Analytics Management Specialization

Bachelor’S Degree, Public Health, Spanish, And Urban Studies