Frank Lopez

Frank Lopez Email and Phone Number

Business Analyst @ DuPont
Philadelphia, PA, US
Frank Lopez's Location
Lansing, Michigan, United States, United States
Frank Lopez's Contact Details
About Frank Lopez

Specialties: Experienced with relational database systems like SQL Server and dashboarding software like Tableau Demonstrated critical thinking and data analysis skills

Frank Lopez's Current Company Details
DuPont

Dupont

View
Business Analyst
Philadelphia, PA, US
Frank Lopez Work Experience Details
  • Dupont
    Business Analyst
    Dupont
    Philadelphia, Pa, Us
  • Pratt & Whitney
    Data Analyst
    Pratt & Whitney Dec 2023 - Present
    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.
  • Subway
    Senior Business Analyst
    Subway Feb 2023 - Oct 2023
    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.
  • Restaurant Brands International
    Product Owner
    Restaurant Brands International Oct 2021 - Feb 2023
    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.
  • Reef
    Business Analyst
    Reef Feb 2021 - Oct 2021
    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.
  • Cotiviti
    Business Analyst
    Cotiviti Aug 2020 - Feb 2021
    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
  • Fedex
    Contractor - Business Analyst
    Fedex May 2019 - Jun 2020
    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.
  • Bayview Asset Management, Llc
    Data Analyst
    Bayview Asset Management, Llc Nov 2015 - May 2019
    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.
  • Starcom Mediavest Group
    Data Analytics Associate
    Starcom Mediavest Group Mar 2013 - Oct 2015
    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.

Frank Lopez Skills

Html C++ Html/xml Visual Basic Web Development Visual Studio Dreamweaver Web Design Vb.net Microsoft Office Fireworks Css Visio Access Sql Microsoft Sql Server Programming Databases

Frank Lopez Education Details

  • Florida International University - College Of Business
    Florida International University - College Of Business
    Management 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

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

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.