MARY MATHIAS
Monroe,MI
Summary
Over 20 years of experience in Information Technology, with 17 years using numerous Business Intelligence Tools including Domo, Microsoft BI tools - Power BI, SSRS, SSIS, SSAS, Azure, Excel SAP BI tools - BusinessObjects, BusinessObjects Data Services, Pentaho - BA tools and ETL, IBM - Cognos Analytics and DataStage ETL. Demonstrated success in requirement gathering, analysis, design, development, implementation, testing, integration deployment, documentation, and maintenance. Comfortable interacting with all levels of the organization. Customer-focused problem solver with an ability to adapt to new challenges. Enjoys learning new applications, designs and processes.
Overview
21
21
years of professional experience
Work History
Analyst, Data Services
Libbey Glass
Toledo, OH
01.2021 - Current
- Currently responsible for providing company-wide support for strategic, analytical, technical tools and processes in the Business Intelligence area entailing both development and support of BI solutions
- Ensure that procedures are properly executed and documented, including development, change requests, and enterprise integration projects
- Respond to support inquiries and incidents for existing ETL and server jobs, reports and dashboards and other BI related applications and systems
- Partner with internal customers (technical or business) to accomplish goals of the company by collecting, clarifying, and translating business requirements into a practical design
- Handle multiple projects and tasks simultaneously and efficiently
- Provide technical and user training and create technical and user documentation
- Ensure all processes and procedures including software changes are performed in an audit worthy manner
- Experience SQL programming and relational databases
- Develop and support SSIS Projects
- Develop with reporting tools SSRS and Power BI.
Shared Services Software Developer
La-Z-Boy Inc.
Monroe, MI
08.2018 - 01.2021
- Developed and supported Pentaho ETL jobs and transformations
- Worked with transforms, jobs, workflows, and data flows in Business Objects Data Service to extract, cleanse and load into target data bases
- Extracted data from various heterogeneous sources like Oracle, SQL Server, DB2, PostgreSQL, flat files
- SQL knowledge and ability to code complex queries
- Created batch files for Control-M to run jobs on various applications, Pentaho ETL, BODS, Domo
- Developed and used SQL queries to validate the data in both source and target databases
- Coded mappings to perform the tasks such as cleansing data, populate staging, fact and dimension tables to create a data mart with only required information for business needs
- Responsible for monitoring scheduled, running, completed and failed jobs
- Involved in debugging the failed mappings and developing error-handling methods
- Performed migration of mappings and workflows from development to test and to production
- Continued responsibilities listed under Senior Report Writer and the Subject Matter Expert of the BOBJ applications.
Senior Report Writer
La-Z-Boy Inc.
Monroe, MI
05.2012 - 08.2018
- Efficiently mapped business requirements and processes to technical solutions
- Held weekly working sessions to help business users with their Business Objects reports
- Developed and implemented a Supply Chain Dashboard using SAP Dashboards 4.0 (Xcelsius)
- Completed Business Objects Upgrade from 3.1 to 4.1
- Converted Deski Reports to Webi using Report conversion tool for enhancements and manually recreated any reports that did not convert through the conversion tool
- Created complex reports using multiple data providers
- Involved in modifying and performance tuning of existing reports
- Scheduled reports for distribution with multiple distribution methods and bursting
- Supported Universes using complex and advanced features from various database sources including PostgreSQL, DB2, SQL Server, and JD Edwards Oracle
- Developed and created classes with dimension, detail and measure objects within universes
- Created users, groups, server groups within security architecture in the CMC
- Experience with Domo, a cloud-based visual dashboard product
- Supported Pentaho Business Analytics tools including Interactive and Analysis reporting.
E-Business Analyst & EDI Coordinator
La-Z-Boy Inc.
Monroe, MI
09.2003 - 05.2012
- Completed an upgrade to version 3.2 of the Data Interchange software in April 2005, became an expert with the new client software while moving away from the mainframe version
- Developed new skillset of data transformation maps, including flat file to flat file translations
- Implemented various transactions sets for Centralized EDI working with many areas in the company and learning their transaction process
- Gained extensive experience with Business Objects by creating multiple reports for different areas of the company such as Payroll/Kronos, Retail, Logistics, Production Planning, Accounting and Materials
- Developed application data formats, maps and special logic within them to be able to translate files in and out of x12, flat file, C&D, delimited, and XML
- Experienced in production support and researching errors in testing translations and batched mainframe jobs
- Executed queries through Transaction Store to assist in research of production issues and monitoring the flow of incoming and outgoing transactions
- Tested with each one of the company’s divisions with an understanding of each of their unique file layouts, manipulating the data through the translator into a structure needed to feed into each of their systems
- Lead the customer and supplier EDI onboarding processes, ensuring timely and quality onboarding in accordance with the targeted timelines.
Education
Bachelor of Science with Honors in Computer Information Systems -
Madonna University
Livonia, MI12.2002
Skills
- Analytical Thinking
- MS Excel
- Team Collaboration and Leadership
- Documentation And Reporting
- Information Gathering
- Data Research and Validation
- Data Processing
- SQL and Databases
- Root Cause Analysis
- Issue Identification
- SQL Programming
- Data Integrity Assurance
- Business Intelligence
- Data Analysis
- Problem-Solving
- Excellent Communication
- Multitasking Abilities
- Organizational Skills
- Task Prioritization
- Time Management
- Attention to Detail
- Active Listening
- Problem-solving abilities
- Team Collaboration
- Effective Communication
- Adaptability and Flexibility
- Self Motivation
Timeline
Analyst, Data Services
Libbey Glass
01.2021 - Current
Shared Services Software Developer
La-Z-Boy Inc.
08.2018 - 01.2021
Senior Report Writer
La-Z-Boy Inc.
05.2012 - 08.2018
E-Business Analyst & EDI Coordinator
La-Z-Boy Inc.
09.2003 - 05.2012
Bachelor of Science with Honors in Computer Information Systems -
Madonna University