BUSINESS/ DATA ANALYST

Database Administration Systems & Process Optimization Pricing Analyst

Experienced, detail-oriented financial data analyst with versatile experience in SQL database administration, systems, and process optimization, & pricing analysis. Recognized for resolving employer challenges with work management oversight to increase efficiency, customer satisfaction, and the bottom line. Strong foundation in data entry, including spreadsheet creation, use of pivot tables, V-Lookups, macros & formulation.

Technical skills include Microsoft Office, Oracle, SQL Server, PeopleSoft, QuickBooks, JDE & SAP.

Key areas of expertise include:

A/P, A/R, Auditing, Compliance

Master Data Analyst

Integration to ERP Systems

Product Marketing Management

Project Management

SharePoint

SAP S/4Hana

Visio

Human Resources/Payroll

Data Mining

BOM Validation

Pivot Tables/VLOOKUP’s

Database Administration

Data manipulation

Salesforce/Service Now

PowerBI

Professional Experience

REMOTE DATA ANALYST October 2023 TO Present

Dollar General contracted through Beacon Hill Staffing, Nashville, TN

Data cleaning for cataloguing purposes in Snowflake. Able to discriminate between the types of data within the framework of the company. Ability to recognize Personally identifiable information (PII); along with secure and non-secure data. A complete understanding of data privacy and security principles as well as the ability to recognize redundancies, patterns, inconsistencies, and errors within the data.

REMOTE DATA ANALYST March 2023 to October 2023

Johnson Controls, Inc., contracted through The Talent Source – Weston, FL

Data cleansing and analysis for all data going into the Product Marketing Management system including products, items, and resource data from business units throughout JCI. Assisting the business units in the organization of this data into data loader sheets designed to capture their specific taxonomy for products as well as individual items.

Key Achievements:

Created data loader sheets that had specific criteria used by specific business units; so that duplication of data could be eliminated.

Analysis of all metadata from business units against SAP data, reconciliation of the data.

Created a more efficient way to handoff data to be loaded by creating easier documents to be loaded directly from validation.

Managed all Sharepoint sites; by setting up access for users, the organization of folders within the site.

REMOTE DATA ANALYST April 2022 to December 2022

FLEETCOR, contracted through Internal Data Resources – Bentwood, TN

Data Research & cleansing, reporting and summarization related to Merchant services department. Pulling data from Lawson, Service Now and Salesforce and completing data validation within these systems and creating flow charts of the findings.

Key Achievements:

Developed a collection report along with a settle deduction report so that monies could be collected from customers.

Found approximately $2.6 million of unapplied payments from customers that needed to be applied in the correct customers’ accounts.

Created a database for all customers with all the pertinent information for their accounts by extracting data from Salesforce, Lawson and AS400.

Created a master sales tracker in Power BI that pulled data from territories to show visibility of forecast valued vs. actual values.

REMOTE DATA ANALYST September 2021 to April 2022

STARBUCKS CORPORATION, contracted through Insight Global, LLC – Seattle, WA

Fulfil various types of requests for the Partner Data Operations. Enters information into databases and coordinates regular database maintenance to keep information up to date. Processes data change requests & modify information in related spreadsheet files.

Key Achievements:

Develops, maintains, and communicates system and application operating procedures and desk guides. Educates and provides ongoing training for end-users on programs, procedures, and data attributes.

Ensures data accuracy. Maintains system audits to ensure shared applications within the organization are accurate.

Works independently to control data integrity as defined in the Standard Operating Procedures (SOPs)

March 2021 – August,2021- Took a year off to take care of my mother- she passed away.

REMOTE MASTER DATA ANALYST September 2020 to March 2021

TE CONNECTIVITY, contracted through New Tech Global Staffing – Katy, TX

Assist in the integration of the new ERP system (Global Shop Work Resources) by going through all BOM data validating it and preparing it for mass uploads. Testing of new data after mass uploads. Created database for drawing files which cross referenced with Central Parts Registry (CPR) in ERP system.

Key Achievements:

Data Validation in the BOM for Engineering Department

Generated queries from SQL to create a new BOM file that is automated from pull.

Identified a process that was more efficient to maintain all engineering drawings.

REMOTE DATA ANALYST October 2019 to April 2020

HEWLETT PACKARD ENTERPRISE, contracted through KForce – Houston, TX

Coordinate & facilitate effort taking of the documentation process; along with clients’ re-design processes & document them in SharePoint & Visio. Record all required documentation corresponding to SAP/S4Hana implementation & process changes including training documentation. Follow up, document, communicate, and coordinate execution of project goals, schedule, and task.

Key Achievements:

Data Validation in SAP Material Master for Supply Chain & Quality Control: Performing tests, finding errors, creating reporting for correction by tech team members.

Navigate system to look up order, check on products, look up software SKU and Material numbers and descriptions.

October, 2018 to September, 2019 Took a year off to take care of my mother

DATA ANALYST/DATABASE ADMINISTRATOR December 2017 to September 2018

EXXONMOBIL, contracted through Manpower – The Woodlands, TX

Maintain client contractor database by handling administration and conducting testing on issues that have occurred. Ensure accuracy of all tables within database by conducting international contractors.

Key Achievements:

Optimized internal/external supplier request by creating a BRD and work management procedures to generate tracking of requests for all data, transferring data to a SharePoint site. Along with transformed manual, email-based request process into automated SharePoint site that logged request, provided status updates, and notified requesters of completion.

Conducted audits within the database for accuracy within each table in Access. Running SSRS & Crystal reports to compare the contract information in SAP to the database. Responsible for all maintenance, data extraction, transformation and loading into the SQL Server.

August, 2016 to December, 2017 -Took a year off to take care of my mother

BUSINESS ANALYST December 2015 to July 2016

COLOMBIA PIPELINE GROUP, contracted through the Addison Group – Houston, TX

Compiled all equipment, cost, monthly fees for all compression & meter stations throughout the U.S. Generated budgets, forecasting for all sites.

Key Achievements:

Created database for all department’s outstanding RITs (contracts) with milestones for payments.

Examined all departments’ projects within the TSA Roadmap system, identified and separated data into the correct divisions with total charges expected and what had been billed.

BUSINESS & SALES & PRICING ANALYST April 2011 to December 2015

WEATHERFORD, Houston, TX

Streamlined audit process to 9 months from start to finish, including upper management in all revenue decisions involving their product line throughout process. Acted as liaison between sales, product line managers, and auditors on pricing, clarification issues. Provided recommendations to settle audits by evaluating findings & communicating with upper management as well as identifying & acquiring data for product line catalogue for customers. Analyzed accuracy & quality of data in JDE, SAP, cross-functional ERP systems while resolving data integrity with all stakeholders to avoid potential data reconciliation issues.

Key Achievements:

Generated E-catalogs through sales history in ERP systems and engineering department to customize E-Catalog. Worked with e-commerce teams to create E-catalog for front-end validation of products with a sku, product number and description of product verified by Engineering department, along with cost of product.

Generated bids from data in Salesforce from Sales to complete all bids for the completion’s teams. Ran weekly sales reports along with forecasting from the reports in Salesforce.

Oversaw external audit department for United States, deploying processes in SharePoint websites for each operator; setting criteria in audit; executing new audit language for all contracts, proposals, & master service agreements. Closed 15 out of 17 outstanding audits in first year, collecting $1.5M in debt, of which $606K was applied to outstanding A/R accounts.

Extracted all data used in audits from SAP and JD Edwards 7.3 & 9.2 into Excel by Showcase queries; completed data scrub through Pivot Tables and V-Lookups to compile data for auditors.

Education

1982-1983 Courses in Business Administration, Texas Lutheran University, Sequin, TX

1983-1984 Legal Secretary Certification, North Harris County College, Houston, TX

2010 Project Management Certification

Contact this candidate