Frank Lopez Email & Phone Number

Philadelphia, Pa, Us

East Hartford, Ct, Us

• Spearheaded the implementation of digital factory technology, empowering teams to leverage data analytics and machine learning to drive business value.• I supported the roll-out of new management execution software, which enabled teams to take advantage of improved user experience, enhanced security, and productivity features.• I led shop floor process re-engineering initiatives which improved signoff processes, which resulted in time savings valued at $742K per year.• I guided the implementation of MES features which improved repair processes by streamlining data collection processes, resulting in time savings valued at $15M per year.• Authored documentation, such as, standard work and knowledge base articles that enabled teams to quickly resolve common issues and improve turnaround time.

Us

• Launched a comprehensive loyalty reporting system by coordinating requirements and design sessions with business stakeholders and working closely with engineering teams. This led to improved visibly of customer behavior and improved marketing campaign performance.• Collaborated closely with development teams to design and implement a dashboard reporting on gift card data, addressing the needs of both accounting and corporate users. This resulted in significant time savings for accounting teams by enabling quick reconciliation of gift card transactions and empowered corporate stakeholders to track sales data, facilitating data-driven decision-making for improving gift card sales.• Worked with business stakeholders to elicit requirements for a kiosk implementation dashboard that helped business leaders monitor the performance of kiosks in restaurants, identify customer preferences, and make data driven decisions to optimize sales strategies.

Toronto, Ontario, Ca

• Collaborated closely with business and engineering stakeholders to launch a web and mobile application that helped improve restaurant operational performance used by more than 4K users.• Gathered requirements, translated them into business specifications for engineering team, translated stakeholder priorities, and managed the software backlog using tools like JIRA and Confluence.• Coordinated a pilot launch for a web application that helped restaurant operators review transactional variances. In one success story, a user was able to find an anomaly that was costing them $12K in sales.

Miami, Florida, Us

• Developed reporting dashboards and regression models in Tableau that tracked impact on KPIs from business initiatives. It was the first standardized way to evaluate and estimate the success of initiatives in the organization.• Developed an actionable Tableau reporting dashboard powered by JSON queries, which resulted in huge time saving factor by optimizing packaging standardization processes.• Elicited requirements and compiled pain points from internal stakeholders to improve internal tools and optimize processes.• Assisted in market trial of a new initiative valued in 12.5M dollars by documenting feedback, troubleshooting with operations team, and presented findings.• Scripted queries using SQL and Amazon Redshift to power ad hoc reporting and Tableau dashboards.• Conducted field research to improve operational processes and presented findings.

South Jordan, Ut, Us

• Responsible for planning and execution throughout the reporting and analytics lifecycle, including gathering and prioritizing requirements, and working closely with developers, product, and support teams to ensure customer satisfaction goals are met• Performed Product Owner responsibilities such as defining user stories, prioritizing the team backlog in Jira to streamline the execution of program priorities, and ensure stories meet the users’ needs and comply with the Definition of Done• Delivered functional specifications and stories with prioritized features and corresponding justification• Converted reporting requirements into visualized prototypes in Tableau

Memphis, Tn, Us

• Gathered business requirements from stakeholders. • Provided project management support on the implementation of financial solutions. • Streamlined reporting processes by leveraging data cleansing and data transformation features in Power BI. • Performed quality assurance, system integration and user acceptance testing. • Authored training materials and documentation on processes and software. • Worked under the agile methodology to deliver system development projects. • Developed reporting dashboards in Power BI • Delivered ad hoc reports using SQL in Teradata and Oracle. • Delivered ad hoc and canned reports using SAP BO.

Coral Gables, Fl, Us

• Authored critical exceptions dashboard reports in Tableau used by business units to help them find regulatory liabilities in their processes. • Analyzed complex business process and translated them into technical requirements to be used in the development of reports. • Developed intuitive KPI dashboards in Tableau for senior management that provided insight into the performance of department strategies. • Developed scripts in tabcmd (Tableau's command line language) to automate report pulls; thereby eliminating a manual, time intensive process. • Delivered ad hoc reports using SQL Server.

Chicago, Il, Us

• Optimized reporting processes by reducing manually intensive tasks using tools like SAS Enterprise Guide and TIBCO Spotfire. In my biggest success story, I was able to reduce the time to create digital performance report for our client from one week to an hour. With this extra time and the reduction of errors, our digital optimizers and planners were able to deliver higher quality analysis and optimizations to their marketing campaigns, resulting in greater value to our clients. • Developed highly interactive reporting dashboards in Spotfire that consistently earned high praise from clients for their ease of use and their straightforward insight. • Created and delivered reports on campaign performance and presented analysis to our clients. For one campaign, I provided weekly analysis on the performance of a digital campaign, where through my recommendations we were able to optimize how users engaged with the site. At the end of the campaign, I was able to evaluate our content partners through the creation of KPIs and provided our media planners with valuable insight for their next media plan.