Business Data Analyst/ PowerBi Report Analyst

Overview

Looking for part-time work (4 hours/day)

at $20.00/hour ($1,760.00/month)

Bachelors degree

Last Active

April 24th, 2024 (10 days ago)

Member Since

September 14th, 2021

Profile Description

Google Data Studio, Google Analytics (May 2021 - May 2022)
Dwyer Enterprises
• Developing and executing strategies, performing data analysis and data mining for digital
marketing efforts. 
• Analyzing key performance metrics, competitive trending and optimizing content themes. 
• Create reports for Amazon Sellers

Business Data Analyst, Analytics Governance (June 2015 to Current)
Lexmark Research and Development Corporation
• Significantly improves the data analytics and reporting support to the Global Supply Chain as well as
to other executive departments to aid them in decision making and planning, to wit: 
   o Develops reports and analytics through data visualizations (Power BI dashboarding) based on
requirements from key stakeholders and report users.    o Familiar with basic SQL language
o Publishes reports with analytics, trends and insights on track with agreed frequency and provides
further insights during reviews, calls and collaboration efforts with other functional teams. 
• Deepens data integrity through validation of data sources, analyzing data architecture and
establishing methodologies to establish a reliable and solid database. 
• Resolves reporting issues and escalates back-end data related issues to appropriate teams for
resolution. 
• Acts promptly on cross-functional and other ad-hoc data-mining and reporting requests. 
• Successfully led cleanup and process improvement projects and was actively involved in the system
integration and user acceptance testing, cleanup and conversion activities in support to a major Ariba
project worldwide implementation. 
• Currently leads report automation initiatives of the Analytics Governance team to keep driving the
sustainability of solution, ensure long-term capabilities, and promote digital transformation. 
• Provides mentoring and training to peers on excel and the Power BI tool.
• Adopts very well to LEAN culture of continuous improvement. 
• SOD (Segregation of Duties) Risk Owner that will analyze High Risk conflicts of access from Global
Sourcing and Global Business Services – Procure to Pay (SAP ECC, ARIBA, MDM) 
• Semi Annual SOD (Segregation of Duties) validation/analysis 
• Do supplier Financial Statement Analysis as part of the risk management and Lexmark RFQ process 
• Supplier Credit Risk Monitoring 
• Conflict Minerals Reporting 
• SAP Business Support. Resolves Direct Purchase Orders 
• SAP Concur Support Resolution – Lexmark Travel technical issue support 
• Monitors EDI Invoice Idoc Failures

Procure To Pay Business Analyst/ SAP Analyst (Mar 2016 –Oct 2019)
Lexmark Research and Development Corporation
• Develops reports and analytics through data visualizations (Power BI dashboarding) based on
requirements from key stakeholders and report users. 
• Publishes reports with analytics, trends and insights on track with agreed frequency and provides
further insights during reviews, calls and collaboration efforts with other functional teams. 
• Resolves reporting issues and escalates back-end data related issues to appropriate teams for
resolution. 
• Acts promptly on cross-functional and other ad-hoc data-mining and reporting requests. 
• Successfully led cleanup and process improvement projects and was actively involved in the system
integration and user acceptance testing, cleanup and conversion activities in support to a major Ariba
project worldwide implementation. 
• Adopts very well to LEAN culture of continuous improvement. 
• Facilitates Customer requested supplier Audits (Electronics Industry Citizenship Coalition) 
• Coordinates with cross-functional teams and drive closure of audit findings 
• Coordinate with Lead buyers and Suppliers for compliant to our Corporate Social Responsibility Policy
requirement (EICC) 
• Drive Conflict Minerals compliance activities. Work with Lead buyers, suppliers and Corporate
Sustainability team and prepare Conflict Minerals Compliance reporting for SEC (US Gov’t)
requirement. 
• Evaluate large dataset for quality and accuracy. 
• Develop process improvements to enhance oUpgrade to see actual infoll data quality. 
• Develop and execute data cleanup measures. 
• Perform daily, weekly and monthly reviews and analyses of current processes using operational
metrics and reports 
• Conduct insightful, ad hoc analyses to investigate ongoing or one-time operational issues 
SYSTEMS USED 
  • MDM Data Manager 
  • SAP ECC 
  • Enovia PLM

Global Sourcing Commodity Analyst – Supply Chain (Oct 2012 – Mar 2016)
Lexmark Research and Development Corporation
• Global P2P Operations – Supply Base Management Purchasing Analyst
Performs advance analytical tasks in support of the Global Sourcing management. 
• Assist SRM/SAP requester with Procure to Pay end to end process
• Develop and maintain Key metrics such as purchasing spend vs. budget. Assess the effectiveness of a
supply chain system pertaining to supplier relationship. 
• Ensures strategic goals, policies and procedures of the organization are followed. 
• Implement all commercial agreements and provide support to buyers; Prepare Non-Disclosure
Agreement, review contracts and agreements. Analyze projects to reduce cost and risks. 
• Manage contracts in CLM tool (Contract Lifecycle Management) 
• Review Global Purchase Orders (using SAP Portal) according to Global Sourcing Policy. 
• Review and approve Vendor related requests in Master Data Manager (MDM) 
• Facilitates Customer requested supplier Audits (Electronics Industry Citizenship Coalition) 
• Coordinates with cross-functional teams and drive closure of audit findings 
• Coordinate with Lead buyers and Suppliers for compliant to our Corporate Social Responsibility Policy
requirement (EICC) 
• Drive Conflict Minerals compliance activities. Work with Lead buyers, suppliers and Corporate
Sustainability team and prepare Conflict Minerals Compliance reporting for SEC (US Gov’t)
requirement. 
• FieldGlass Super User. Work with Contingent Labor suppliers and Boulder managers for contingent
labor

Bill of Materials Analyst  (Jul 2011 – Oct 2012)
Lexmark Research and Development Corporation
• Manage mono laser printer BOM (Bill of Materials) through advanced excel and product lifecycle
management (Enovia) 
• Track, manage and provide cost update to management. Provide monthly Cost BOM update and
bridge cost difference in monthly basis to the Lexmark division director. 
• Regularly meet module owner to capture cost opportunity/reduction and cost exposure and taking
the lead and challenge each module owner to meet cost targets. 
• Work with stakeholders, suppliers and with other cross-functional teams to deliver quality and
reliable BOM related tasks/projects.

Associate Engineer – (May 2008 – Jul 2011)
LEAR AUTOMOTIVE SERVICES (NETHERLANDS) B.V.
•
Responsible in all Engineering Change Control activities per program assignment 
• Creation, generation and update of Bill of Materials for the General Motors, Ford and Chrysler
programs 
• BOM Analyst of General Motors programs 
• Program monitoring, BOM generation and continuous update of programs using AS400 software and
PLM ( Product Lifecycle Management) system 
• Uses Visual basic development to continuously improve and reduce processing cost 
• Uses tools such as FMEA and 8D Analysis in obtaining and maintaining quality in work 
• Performs all BOM activities requests from the US counterpart (e.g BOM Audit, BOM Costing,
Engineering Change Notice or ECN creation, BOM structuring, etc.)
• 2D drafting (T6, GM, TATA) 
• Do the weekly Quality First Result report for the Department 
• Do overtime and expense reports of the offshore associates 
• Has supported 3D basic drafting of IDEAS program 
• AutoCad Drafting