Eric Mayer

Eric Mayer Email and Phone Number

Sr. Business Systems Analyst @
Eric Mayer's Location
St Paul, Minnesota, United States, United States
About Eric Mayer

Eric is an accomplished Business Systems Analyst with experience in multiple industries with various stages of data management. From working directly with source systems, data lakes/warehouses/marts, and data visualization applications, he provides the link between the stakeholders and the developers to ensure a smooth product delivery. Each delivery requires collaboration and ownership, two of his strongest values, as he strives to cultivate exceptional professional relationships to better understand business needs and pain-points, and then drive those needs into a tangible product that meets the requirements gathered and exceeds expectations.

Eric Mayer's Current Company Details
Johnson & Johnson through Turnberry

Johnson & Johnson Through Turnberry

Sr. Business Systems Analyst
Eric Mayer Work Experience Details
  • Johnson & Johnson Through Turnberry
    Sr. Scg Pricing Strategy Analyst
    Johnson & Johnson Through Turnberry Jul 2022 - Present
    Enriched commercial data experience via Procedure Stamping Logic development with a targeted focus on Joint Recon, leverageable by downstream systems• Enhanced Analytics & Reporting for Contracting (ARC/Qlik) with the integration of targeted financial KPIs and further enhancements to better client’s data-driven decision-making• Expanded Contract Strategy Performance & Capital Channel initiatives (VELYS) analytics capabilities, to enable actionable insights & advanced analytics• Utilized Offer Performance (Win/Loss) deal attributes & offer outcomes to inform future contract proposals via mining & integration of SFDC contextual data• Enhanced visibility to P&C performance data for SCG internal & field-facing customers via targeted insights & reports (e.g., Executive Dashboard), and AI/ML technologies• Enhanced and Evolved Data Sourcing/Integration• Enabled business continuity for analytics affected by organizational system changes (SAP OTC, DBB1.0 - 2.0 etc.,) and evolved commercial data experience via integration of downstream system sources (SFDC, ICS etc.,)• Maintained the backlog in an agile/waterfall hybrid methodology• Mentored analysts with technical questions/processes• Assisted in validating the automation of several core reports with multiple data sources• Created dashboards, KPI's, and other visuals within ARC/Qlik to support the business and their needs• Provided insight to better streamline core inter/intra business processes• Drove all open items to either the backlog or completion with little to no guidance• Worked closely with lead analysts and Senior leadership to understand pain points to offer guidance and help design solutions
  • Avanos Medical Through Turnberry Solutions
    Sr. Consultant / Business Systems Analyst
    Avanos Medical Through Turnberry Solutions Jan 2022 - Jun 2022
    Avanos: January 2022 – June 2022➢ Coach management to effectively work in an Agile methodology➢ Help management understand data structures and how they can best utilize their current data to create reports in Power BI➢ Work closely with stakeholders to ensure all requirements have been met and expectations have been set accordingly➢ Derive pain-points and business needs across the organization to deliver solutions that address those issues➢ Collaborate with other business teams to ensure that our solutions streamline existing processes across the organization, reduce risk, & offer new insights in how to enhance existing processes➢ Provide mock-ups of Power BI reports to stakeholders and product owner to provide guidance to the Devs and to see how the stakeholders will receive the solutionEric Mayer 2➢ Ensure Devs have everything they need to successfully deliver the solution and support them If any issues arise➢ Confirm all technical areas have been properly solutioned and provide support when something has been missed➢ Collaborate with Scrum Master understands work to be done and expectations of the team per each solution➢ Coach Product Owner to ensure the proper priority has been set and is aligned on expectations➢ Own all prioritized items and help support the team so we can work independently of the client while still exceeding their expectations ➢ Demo the solutions to both internal and external stakeholders to ensure the solution has exceeded expectations and is ready for release➢ Create documentation to support use of the solution➢ Host training sessions with stakeholders and end users to ensure a smooth transition to the new Power BI reports➢ Work closely with the client to ensure that their expectations are being met and work with the team to resolve any discrepancies➢ Ensure the client has everything they need to succeed after the transition has taken place➢ Continu
  • Life Time Fitness-Corp Offices
    Business Analyst / Scrum Master
    Life Time Fitness-Corp Offices Sep 2021 - Jan 2022
    ➢ Utilize DOMO to visualize data for a myriad of reports➢ Work in an Agile environment➢ Lead daily stand-ups to ensure that the work for the sprint is on time and that all blockers are resolved➢ Met with stakeholders to define & subsequently refine their requests➢ Align with Stakeholders to ensure that all work is prioritized as required➢ Collaborate with Solution Architect to define solutions for all BOW’s➢ Break down each solution into actionable stories/items to be refined➢ Help refined the intake process to streamline work that is brought in and refined➢ Consistently delivered all work for a given sprint and brought in work from the backlog➢ Lead refinement meetings to assign point values to each story➢ Tactfully determined the ‘what’ & the ‘why’ behind a stakeholder’s request to ensure that the workbeing done meets/exceeds their expectations➢ Translate requirements between the business, solution architect, and data engineers➢ Work within Azure and utilized SSMS to track defects, detail stories with the most accurate granularinformation, and identify data discrepancies between Azure & DOMO➢ Work in a fast pace environment with constantly shifting priorities➢ Own all work and drive each item to success➢ Understand the data warehouse architecture from utilizing a data lake to feed into Azure’s datawarehouse to supply reporting in DOMO
  • Bi Worldwide
    Senior Business Analyst
    Bi Worldwide Dec 2018 - Sep 2021
    Minneapolis, Mn, Us
    - Utilize tableau for account reporting to drive business decisions- Become a subject matter expert on assigned customer data, system limitations, and the methodologies of both- Manage a dashboard of reporting for internal teams with Tableau for leadership- Development of the technical portion of the Statement of Work- Lead and provide improvement recommendations on business processes for both internal and customer teams- Develop standard operating procedures for ongoing programs and system improvements- Facilitate the creation of Website wire-frames for customer approval- Development, communication, and monitoring of project timelines- Communicate customer expectations and project requirements to the technical and customer teams- Refine requirements for large projects (6 months+)- Identify system limitations and potential bugs, open support tickets, and work with the DevOps team to resolve issues- Create project outlines, budgets, and high-level overview for management and sales- Direct customer presentations/meetings- Gather and document business requirements for assigned projects- Perform Root Cause Analysis methodology to identify and limit further/potential errors- Implement new documentation and data management standards to safeguard the system processes and data- Illustrate core business logic for ongoing projects with flow-charts, charts, and documentation- Create technical requirements to assist DevOps team- Drive business and technical development in the redesign of our database and systemic procedures- Perform QA and UAT testing of new development, change requests, and ongoing projects- Work with the DevOps team to support new data intakes for ongoing and new projects- Provide support mapping new tables across the relational database
  • Zeiss Industrial Metrology
    Sap Master Data Analyst
    Zeiss Industrial Metrology Jun 2018 - Oct 2018
    Oberkochen, Baden Wuerttemberg, De
    - Worked with global and local teams to design develop and continuously improve data integrity management, governance, and processes, ensuring both current and future business requirements are met- Collected demands from the organizational areas in close association with the master data architect- Analyzed of master data inconsistencies- Ensuring master data management policies- Eliminated existing overlaps in master data or master data inconsistencies- Established, monitored, and assessed master data policies and practices- Documented, analyzed, and troubleshot any issues with master data systems- Created processes to monitor the quality and accuracy of master data- Managed data conversions between different data systems- Developed processes to audit & measure the efficiency and quality of master data- Identified and managed data cleanup projects to improve data accuracy- Designed a Customer/Organizational and Pricing Hierarchy for customer accounts in ERP- Used SQL in Access to create queries that improved data reporting processes
  • 3M
    Sales Analyst
    3M Apr 2018 - Jun 2018
    - Utilized SQL to locate and extract customer records- Refined complex customer records from legacy ERP systems- Excelled in a high-pressure environment with increasing workload and shortened deadlines- Validated Customer records for data loads into SAP CRM- Collaborated with peers both in the office and internationally daily to conform to new business requirements
  • Chs Inc.
    Business Process Analyst
    Chs Inc. Oct 2017 - Apr 2018
    - Understood SAP and other ERP systems to map data- Constructed the “blueprint” with the Business for how data was to be migrated- Utilized SQL and Excel to locate, cleanse, and validate data- Conveyed business requirements and limitations between the business and technical teams- Created rules to translate and transform data to meet business requirements- Worked in a team that required constant communication between each other and other departments
  • Blue Cross And Blue Shield Of Minnesota
    Benefits Analyst
    Blue Cross And Blue Shield Of Minnesota Jul 2017 - Oct 2017
    - Taught myself VBA to create macros and streamline processes
  • Pace Analytical Life Sciences
    Business Analyst
    Pace Analytical Life Sciences Nov 2016 - May 2017
    - Supported business growth by generating new and evolving opportunities for account executives- Simplified processes to better communicate with team members- Utilized an ERP software solution to help the business develop- Understood business capabilities to refine processes
  • Axel'S
    Waiter
    Axel'S Jul 2015 - Nov 2016

Eric Mayer Skills

Salesforce Training Test Automation Ad Hoc Reporting Process Automation Rfp Microsoft Powerpoint Data Analysis Business Analysis Communication Data Analytics Plant Maintenance Visio Product Design Strategy Business Process Analysis Sap Materials Management Software Testing Microsoft Office Microsoft Word Test Cases Microsoft Excel Css3 Sap Erp Business Requirements Master Data Management Business Process Improvement Sql Test Driven Development Teamwork Analytical Skills Project Management Health Insurance Agriculture Sap Pm Module Sql Tools Html5 Master Data

Eric Mayer Education Details

  • University Of St. Thomas
    University Of St. Thomas
    Neuroscience

Frequently Asked Questions about Eric Mayer

What company does Eric Mayer work for?

Eric Mayer works for Johnson & Johnson Through Turnberry

What is Eric Mayer's role at the current company?

Eric Mayer's current role is Sr. Business Systems Analyst.

What schools did Eric Mayer attend?

Eric Mayer attended University Of St. Thomas.

What skills is Eric Mayer known for?

Eric Mayer has skills like Salesforce Training, Test Automation, Ad Hoc Reporting, Process Automation, Rfp, Microsoft Powerpoint, Data Analysis, Business Analysis, Communication, Data Analytics, Plant Maintenance, Visio.

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.