JACQUELYNE MAYO
Hillsborough, NC ***** 984-***-**** ad0tw7@r.postjobfree.com
Summary
Hardworking Data Analyst experienced in field and ready for challenging assignments. Reliable in completing quality work and exceeding expectations.
Skills
Data consolidation
Solution development
Cost estimation and budgeting
Data extraction
Data Mapping
SAP Reporting
Oracle Financial
Tableau
R Programming
MS Access
MS Power BI
SQL
Oracle Business Objects
Data Warehouse
R Markdown
Experience
Freelancer 2014 to Current
Self Employed Management Consultant Hillsborough, NC
Troubleshot and resolved problems with programs and systems.
Revamped existing system to improve functionality or repurpose for new requirements.
Expanded systems with new features and structural components.
Business Systems Analyst 2014 to 2015
Kforce - Wells Fargo Charlotte, NC
Providing compliance expertise and consulting for projects and initiatives with moderate to high risk
Creation of MS Access Tables and Reports for collaboration in Sharepoint
Assessing and mitigating regulatory risk in all business activities
Retrieved and cleaned data from Data Warehouse into Microsoft Excel.
Supply Chain Analyst 2011 to 2013
CCSI - United Technologies Charlotte, NC
System specification testing of SAP – Business Objects software development
Maintenance of Materials and Resources Database for Supply Managers
Performed database contact updates for direct and indirect material suppliers.
Performed market research to support commodity strategies
Set up user accounts based on eRFS requests
Communicated with end users regarding any delays in user account setup
Managed databases (update profiles, maintain user account data
Ran Denied Party Screening and update DPS record in Co-exprise for each supplier
Produced and published weekly status report
Maintained training documentation for tools, reports, commodity management process, etc.
Pulled reports from AeroVantix and SAP to look at line item details for mismatches to support accurate SCM metrics
Work with SBUs and IT to perform SCM data cleanup
Utilized SCM data warehouse for quick lookups on supplier metrics
Sent requests to SCM community for parts searches
Performed market research to support commodity strategies
Business Systems Analyst 2010 to 2011
Sherpa - Bank of America Charlotte, NC
Documented defects in software integration objects using Quality Assurance software
Created test plans and test scripts according to documented technical requirements
Worked with foreign currency transactions to ensure that balances were properly translated from Oracle and Insight into SAP ECC software.
Education and Training
MISM: Information Systems - Project Management
Keller Graduate School of Management
MBA: Business Administration
North Carolina Central University Durham, NC
Golden Key International Honor Society
B.S: Accounting
North Carolina Central University Durham, NC
Activities and Certificates
UNC Internal Medicine Patient and Family Advisory Council Member 2022
Google Data Analytics Certification 2023
Websites, Portfolios, Profiles
http://jacquelynemayo.webflow.io/