Frank Lopez work email
- Valid
- Valid
- Valid
Frank Lopez personal email
- Valid
Frank Lopez phone numbers
Specialties: Experienced with relational database systems like SQL Server and dashboarding software like Tableau Demonstrated critical thinking and data analysis skills
-
Business AnalystDupontPhiladelphia, Pa, Us -
Data AnalystPratt & Whitney Dec 2023 - PresentEast 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. -
Senior Business AnalystSubway Feb 2023 - Oct 2023Us• 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. -
Product OwnerRestaurant Brands International Oct 2021 - Feb 2023Toronto, 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. -
Business AnalystReef Feb 2021 - Oct 2021Miami, 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. -
Business AnalystCotiviti Aug 2020 - Feb 2021South 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 -
Contractor - Business AnalystFedex May 2019 - Jun 2020Memphis, 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. -
Data AnalystBayview Asset Management, Llc Nov 2015 - May 2019Coral 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. -
Data Analytics AssociateStarcom Mediavest Group Mar 2013 - Oct 2015Chicago, 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.
Frank Lopez Skills
Frank Lopez Education Details
-
Florida International University - College Of BusinessManagement Information Systems
Frequently Asked Questions about Frank Lopez
What company does Frank Lopez work for?
Frank Lopez works for Dupont
What is Frank Lopez's role at the current company?
Frank Lopez's current role is Business Analyst.
What is Frank Lopez's email address?
Frank Lopez's email address is fr****@****eef.com
What is Frank Lopez's direct phone number?
Frank Lopez's direct phone number is (888) 997*****
What schools did Frank Lopez attend?
Frank Lopez attended Florida International University - College Of Business.
What skills is Frank Lopez known for?
Frank Lopez has skills like Html, C++, Html/xml, Visual Basic, Web Development, Visual Studio, Dreamweaver, Web Design, Vb.net, Microsoft Office, Fireworks, Css.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial