PROFESSIONAL PROFILE:

Microsoft Excel/Access guru with a team oriented mindset, seeking a support position that will utilize my advanced data analysis, business analysis, tracking and reporting skills. Macro VBA, Report Automation, SharePoint, SAP/Ariba Super User.

SKILL:

High level of expertise in the use of: 15 + years of Access version

Access Databases: Inception via Design Creation or via Excel Table, Relationship tables, Append queries, Forms, Reports, Imports from Excel, Extracts to Excel, Links to Excel spreadsheets

SQL: (Intermediate)

MS Excel Functions: Vlookup, Concatenate, Trim, SumIF, CountIF, Match, Search, Left, Right, AVG, Filter, Conditional Formatting, Paste Special, Paste Link, Pivot tables, VB Macros

Deep Dive Data Analysis/Business Analysis: Reporting

SAP which includes: 1SAP, PM, MM, MDM, FICO, BOM, Data Governance, Transaction Codes

Powerpoint Presentation Skills

Accounting Principles

Data Profiling, Sharepoint, Business Analysis: Requirements Gathering

Data Conversions/Data Migrations

Data Cleansing, Deduplication, Remedy, ICTS Trade Capture.

Project Schedule: Tracking Projects from Inception to Completion

Vendor Management: contact with various vendors that service the oil industry

Ariba: Catalogue Creation to facilitate Requisitions and Purchase Orders

Supplier Procurement: Ariba

Supplier Procurement: Hubwoo

P2P as a Lead P2P Analyst responsible for converting over 300 contracts to P2P tool to enable electronic vendor payments

Oil Industry Experience onsite at Confidential, Confidential, Shell, Confidential

Experience with, DMS, OpenWells, Dodson, SkillsXP, Catalogue Creation, Visio & PCard

HP Service Manager, QuickBooks, SaasAnt: Excel Transactions, ITIL Site HelpDesk, Nexpose, Winshuttle

EXPERIENCE:

Confidential

SAP - BOM Analyst/Quality Technician

Responsibilities:

• Utilizes WinShuttle to process SAP-BOM requests for all Plants.
• Utilizing SAP Creates BOM/Recipes for all Plants.
• Creates Inspection Plans in SAP for newly created Material.
• Deletes Material in SAP for all Plants as requested.
• Utilizing SAP-BI, extracts weekly and monthly QM data for Reporting Purposes.
• Runs daily ZPQM COA transaction in SAP to process and release Customer Certificate Of Analysis Reports.
• Updates Batch Information in SAP to clear held COAs.
• Updates expired Held Values to release COAs.
• Creates COA profiles as requested.
• Sends COAs to Customers as requested.

Confidential

IT Operations Reporting Analyst

Responsibilities:

• Creates New Exceptions via SharePoint.
• Tracks Approval status using Workflow in SharePoint. Contacts Management as required to facilitate Exception Approvals.
• Extracts Exception Reports from Nexpose.
• Formats Exception Reports in Excel by creating Pivot Tables that track 15-30 day Exceptions expiring.
• Created Macro to Automate Repetitive formatting of Exception Report to streamline time required to Publish Report.
• Facilitates weekly meeting to address Exceptions requiring Managerial Approval as well as Exceptions nearing expiration.
• Updates Approved Exception Exclusions in Nexpose as required utilizing CVE, Vulnerability Title or Asset.
• Extracts Vulnerability Reports from Nexpose.
• Automated Vulnerability Nexpose Reporting in Excel by creating Macro that combines reports and creates a pivot table to sum vulnerabilities by site and track critical risks.
• Creates ad-hoc Vulnerability Reporting as requested utilizing advanced If Statements, Macros and Pivot Tables.
• Researches and provides solutions for remediation of Vulnerabilities.
• Uses NMAP to Ping Servers.
• Kept Excel log of Third Party Vendor Cert Vulnerability Updates.
• Logged/Closed Tickets in Site HelpDesk. Sent remediation requests to various IT Teams.
• Tracked Cert Security Updates from Inception to Remediation Completion.

Confidential

Ariba Contracts Administrator

Responsibilities:

• Creates Contract Workspace in Ariba for New contracts.
• Updates Contract Effective Dates, Expiration Dates, Terms, Approvers, Owners, Titles, Descriptions and Contract Amounts.
• Manages contracts in Ariba to Published stage.
• Downloads PO’s from Ariba and Updates PO in Excel to attach to Contracts in the Ariba Workspace.
• Updates Statements of Work in Word to attach in the Ariba Workspace.
• Works with Management to resolve Contract issues.
• Submits contracts to Suppliers via DocuSign.
• Corresponds with Management via email to provide updates on the status of Contracts from Inception to Completion.

Confidential, Plano, TX

Access Developer

Responsibilities:

• Updated Microsoft Access Database 2013.
• Updated Microsoft Access Queries, Forms, Reports, and Data Links to external data.
• Utilized SQL Coding for Joins, Unions and Extract statements to update database.
• Utilized Saas-Ant-Excel Transactions to import Excel Invoice data to QuickBooks.
• Utilized QuickBooks to link Microsoft Access Invoice data via Microsoft Excel.
• Short Term Remote position.

Confidential, Plano, TX

SAP Data Analyst

Responsibilities:

• Verifies Data Governance.
• Updates Data Governance Position Papers.
• Checks Data Governance in over 40 SAP landscapes for ESSA, LATAM, E-AMENA & W-AMENA.
• Runs ALE in SAP Global Landscapes for Class Classification/Characteristics.
• Runs IDOC transaction in SAP to transfer/update data.
• Updates Task 30 and Task 35 in HP Service Manager for Hierarchy add/change and COPA.
• Profiles Data for Task 30 to ensure Data quality.
• Responsible for running transactions in SAP to extract data to Excel.
• Analyzes up to 2.5 million lines of SAP extracted data in Excel.
• Uploads Data to Microsoft Teams/Sharepoint.
• Utilizes Vlookups, Pivot tables, VB Macros and Formulas to cleanse data extracted from SAP.
• Updates PowerPoint presentations as needed. Uploads documents to PEPNET as requested.

Confidential, Cincinnati, OH

SAP Data Analyst

Responsibilities:

• Works with functional analysts across multiple functional groups to verify data governance and prepare SAP object data templates and understand data requirements for Legacy data migration to SAP.
• Profiles master data to cleanse and complete data needed to load into SAP.
• Follows up on data collection by the business users and issues resolution on their data.
• Utilizes Excel to create/update business objects.
• Creates VB macros to expedite cleansing process.
• Creates vlookups, if statements & various data specific formulas to format data.

Confidential, Plano, TX

Analyst

Responsibilities:

• Updates & Distributes Weekly Recap Reporting for FLNA - Signature Service GTM.
• Responsible for updating & Distributing Period FLNA Tracking Reports as well as Dollar General Reports.
• Updates FLNA Signature Service Webpage as requested.
• Updates Weekly Quality Recap via PowerPoint for FNLA-GTM and distributes to Team.
• Updates charts via PowerPoint as required.
• Utilizes Business Objects to schedule & retrieve Reports that are exported to Excel.
• Implemented Process Requirements for Reporting Training purposes.
• Implemented VB macros to expedite repetitive Reporting requirements.

Confidential

SAP Data Analyst

Responsibilities:

• Verifies Data Governance.
• Analyzes SAP Vendor Master Data information for data cleansing to be utilized in Tungsten E-invoicing system implementation.
• Profiles Data for data standardization as requested.
• Retrieves text files from Sharepoint. Converts to Microsoft Excel to Analyze.
• Utilizes VB Macros, Vlookups, Concatenate, Left, Trim & Pivot tables daily.
• Suggested Microsoft Excel VB Macro creation to expedite process to analyze 150,000 vendors. VB Macro process approved by Manager.
• VB Macros created expedited process from 4 hrs. Per file to 30-45 min.
• Maintains Vendor Master File in Microsoft Excel. Updates/distributes as needed.
• Provides daily completed analyzed files to Manager.
• Responsible for analyzing 2000 lines of data per week. Creates reports utilized in weekly meeting.
• Created Microsoft Access Database to streamline reporting process.
• Attends weekly status meeting via conference call. Handles ad-hoc request to analyze data.

Confidential, Fort Worth, TX

Data Conversion Analyst

Responsibilities:

• Converts RCM data to RCCD format utilizing an Excel template for conversion upload.
• Uses these various Excel functions: vlookup, sumifs, countifs, if statements, logical statements, filters, array formulas and parsing data using left/right/find/len. Formats data using text functions and Pivot tables for summarizing data.
• Profiles data for standardization.
• Created VB Macros to automate data cleansing.
• Builds reports. Creates Excel templates to automate complex analysis or processes that are intended for use by other staff.
• Feeds results and issues to COE Contacts. Funnels questions on the documentation to the internal Chase COE coordinator and receives answers back to complete the conversion.
• Uses SharePoint to update, track and upload new RCCD's.
• Uses Visio, Igrafx, Phoenix Downloads and Top Down Heat Map data as needed.

Confidential, Houston, TX

P2P Lead Data Analyst

Responsibilities:

• Returned to previously held position at ENI.
• Was first Lead Analyst hired on this project in Mar 2013. Worked closely with Managers to implement conversion of contracts to Hubwoo environment.
• Reviews P2P Monitor report in SAP to check status of vendor invoice submissions. Checks status to see if payments have been rejected or financially approved.
• Provides P2P Hubwoo training for vendors via phone or video conferencing.
• Provides Vendor assistance with creating/submitting Service Entry Sheets to match Purchase Orders. Tracks status/approval of Service Entry Sheets/Purchase Orders in SAP.
• Utilizes SAP to verify/validate contract validity dates and contract amount.
• Retrieves Vendor Price Sheets from SAP to create vendor templates for Hubwoo uploads.
• Assist with Help Desk for Hubwoo vendor related issues.
• Utilizes DMS to research/download vendor contracts.
• Creates/Uploads vendor catalogs into Hubwoo utilizing Excel.
• Utilizes VB Macro to assist with template upload into Hubwoo. Updates Macro as required.
• Updates pricing in vendor catalogs for amended contracts.
• Works closely with vendors to resolve Hubwoo related pricing issues.
• As a Hubwoo Administrator updates vendor catalogs in Hubwoo.
• Works closely with Contract Managers/Contract Handlers to resolve discrepancies related to Hubwoo templates/pricing issues.
• Works closely with Buyers to resolve pricing discrepancies/create vendor templates.
• Troubleshoots Hubwoo upload discrepancies. Works with Hubwoo Technical support to resolve vendor pricing/catalog issues.
• Works closely with Vendors to resolve invoice payment resolutions.
• Checks Vendor Invoice Payment Status in SAP using P2P transaction code.

Confidential, Houston, TX

Technical Assistant

Responsibilities:

• Maintenance of Performance Indicator data.
• Provides S&OR staff with analysis (tabular and graphical) from GWEA spread-sheets using VB macros and pivot tables.
• Creates Pivot Tables, VB Macros, and Formulas to enhance Excel Reporting.
• Obtains data from the line under the direction SETAs and EA in support of Assurance activity.
• Uploads/Updates documents on Sharepoint.
• Enters Assurance scheduling into the Assurance Database that I created. Exports tables from the Assurance Database to Excel to create Reports.
• Enters GOM Plea Agreement “stop the operation” activity into the Excel based Register.
• Tracks activities and work plan completions to ensure we are meeting schedule in accordance with the Assurance Plan.
• Assist in the planning and coordinating of assurance activities for both current and follow on year.
• Tracks Peer-to-Peer Review Assurance scheduling and completion of assurance and in corporation in the database.
• Establishes and maintains a register documenting any major new and/or updated safety related requirements.
• Schedules and coordinates the monthly review board for the “Stop the Operation” Register submissions.
• Prepares examples from the exercising of the authority to stop the job for communication.
• Compiles both the safety related requirements register and the “Stop the Operation” register.

Confidential, Houston, TX

P2P Lead Data Analyst

Responsibilities:

• Lead for Data Analysis and Contract uploads for P2P Hubwoo Project.
• Guides/Instructs P2P Specialist on daily objectives.
• Worked with IT Manager to obtain software essential for contract conversion.
• First point of contact with Vendors to introduce Hubwoo implementation.
• Updates Excel file with contract upload status from inception to completion.
• Implemented efficient ways to track/house data by creating one central contract repository. Also implemented file share to simplify updating process between various users.
• Utilizes SAP to Validate Contract data for upload analysis. Extracts data as needed.
• Utilizes DMS to review/retrieve contracts.
• Communicates with Contract Managers/Buyers to obtain contract detail.
• Utilizes Microsoft Excel to prepare upload template for Hubwoo.
• Utilizes Vlookups, concatenate, date formulas and VB macros to expedite data cleansing for upload process.
• Completes weekly vendor contract validity end date Analysis. Determines timeline and provides status to Management.
• Weekly Reporting provided to Management.
• Ad-hoc Analysis/Reporting created as requested.

Confidential, Houston, TX

Technical Assistant

Responsibilities:

• Responsible for the creation/generation of spend reporting per projects as requested.
• Responsible for Updating the Sharepoint Tracker with Financial data, Confidential Engineering Standard document updates and project completion status.
• Created document sites in Sharepoint as needed.
• Extracted SAP WBS data for cost codes and project costs to be utilized for monthly reporting purposes.
• Extracted various Reporting in SAP-BO for Manager.
• Utilized SAP PCH and PC3 6.0 to enter/extract data.
• Created/updated charts, formulas and spreadsheets utilizing Microsoft Excel for monthly reporting.
• Utilized PCard for departmental purchases.
• Supplier Procurement - Ariba
• Tracked Invoice Status in Ariba. Submitted invoices for payment.
• Ran SAP Transaction codes to track Ariba Invoice status.
• Tracked CES project status and cost associated and was responsible for flagging over budget documents.
• Assisted with special projects as needed.

Confidential, Houston, TX

Business Analyst/SAP Data Analyst (Maintenance)

Responsibilities:

• Gather requirements to facilitate process change in data capture to update/cleanse Maintenance Plans in SAP
• Responsible for updating Excel spreadsheets associated with Equipment Task List and Maintenance Plans related to SAP PM.
• Updated/Created/Deleted Equipment in SAP utilizing SAP PM transaction codes for various Rigs.
• Created/Deleted Maintenance Plans associated with Equipment.
• Ran various transactions codes in SAP for retrieving Maintenance Data.
• Exported data from SAP to Excel as needed.
• Cleansed Maintenance/Equipment Data for various Noble Rigs utilizing Microsoft Excel.
• Created Pivot Tables as needed in Microsoft Excel.
• Utilized Vlookups to populate data from one spreadsheet to another.
• Manipulated extreme volumes of Maintenance data utilizing Microsoft Excel.

Confidential, Houston, TX

Well P&A Coordinator

Responsibilities:

• Responsible for updating Microsoft Access 2007 database with all well plug & abandonment permitting submittal, approval and expiration dates. Updates well status as needed.
• Created Access databases, relationship tables, update/append tables, linked excel files, import/export from and to excel as required.
• Created Access queries, forms, and reports. Reports exported to Excel as required.
• Updated approved dates in database for Sundry Notices, W3, W-3A, and 3160 Notices received to P&A Wells in Texas, Oklahoma, Wyoming and New Mexico.
• Added new wells to the database to be plugged & abandoned. Updates database with new well reps and vendors as needed.
• Ran transaction codes in SAP to obtain WBS financial information to update in database.
• Imported Excel files into database to track daily work activity associated with wells.
• Exported various reports from Microsoft Access to Excel 2007 to distribute to Project Managers.
• Utilized Microsoft Excel to create spreadsheets that tracks well information not found in Access database.
• Created Vlookups and Pivot Table in Microsoft Excel to analyze database in comparison to Client Spreadsheets. Automated process utilizing Microsoft Excel to verify data.
• Researched well data on various websites to verify API number and well name.
• Corresponded with Well Reps and Project Managers to convey well status change, permitting issues and WBS information.
• Tracked Microsoft Project Schedules from inception to completion.
• Assisted with Month End Financial Reporting. Assisted with Lean Sigma Projects.

Confidential, Houston, TX

Business Planning Technologist

Responsibilities:

• Responsible for monthly spend reporting.
• Utilized Microsoft Excel to update monthly reports as requested.

Confidential, Houston, TX

SkillsXP Administrator

Responsibilities:

• Responsible for linking all Certificates/Assessments for Mendocino and Molokai Rigs.
• Submitted weekly KPI Report to Manager. Extracted data from SkillsXP as a Microsoft Excel Document and formats as needed to create report.
• Responsible for updating New Employee Roles in SkillsXP.
• Proactively created Excel Spreadsheet to track daily certificates/assessments linked to send to Management to show daily Accountability.
• Responsible for KPI Reporting utilizing Microsoft Excel and Powerpoint.
• Linked employee certificates and enters assessments into SkillsXP.
• Extracted personnel and assessment data from SkillsXP.
• Updated documents as needed.

Confidential, Houston, TX

Analyst

Responsibilities:

• Created/Updated Spend Report sent to Finance Daily.
• Updated CPP Tracker and 213 Tracker on Sharepoint as needed.
• IBM CAP Team Point of Contact for all documentation and reporting for Equipment Team.
• Responsible for placing Scanned documents on Ariba.
• Created Catalogues utilizing Ariba to initiate Purchase Requisitions.
• Published Ariba catalogues for Customer Purchase Order creation to facilitate invoicing.
• Supplier Procurement - Ariba
• Tracked Ariba Invoicing status in SAP form inception to completion.
• Sourced Critical Equipment needed to respond to the Gulf Spill Crisis totaling over $1MM.
• Responsible for Planning, Sourcing and Negotiating pricing as requested.
• Managed Supplier Sourcing list and distributed daily. Updated as needed.
• Contacted Suppliers as needed to convey purchasing needs and follow up on shipments.
• Responsible for tracking all equipment purchased by the Buyers on the Oil Spill Response Team utilizing Microsoft Access and Excel.
• Updates Daily as needed. Created Pivot Tables to show Equipment purchased per Vendor, By Buyer, capturing total amount purchased per Buyer.
• Created Pivot Table to show Equipment Delivered by Location capturing Actual Date and ETA Delivery Date, as well as total expenditure.
• Created Access Database to track Purchase Orders, Equipment, Vendors and Cost for departmental Buyer activity.
• Creates Access databases, relationship tables, update/append tables, linked excel files, import/export from and to excel as required.
• Creates Access queries, forms, and reports. Reports exported to Excel as required.
• Disbursed Excel Reports to Management and Critical Resources Equipment Team.
• Updated Equipment Delivery Report daily.
• Assisted Equipment Team with Microsoft Excel as requested.
• Utilized advanced functions in Microsoft Excel to expedite Reporting.
• Updated Sharepoint with Daily Reporting.

Confidential, Houston, TX

Business Analyst/Drilling/Engineering

Responsibilities:

• Responsible for Daily/Weekly/Monthly Reporting.
• Updated Trouble Time, Completion Measures and Quartile Curve Reports.
• Input New Wells into SWPM for Drilling and Completion Phase.
• Utilized Openwells to view Daily Operations, AFE and Completion Reports.
• Utilized Data Analyzer to run various Drilling Reports.
• Utilized Open Wells, also tracked well cost, mud weight, hole size, spud date, rig release date, mobilization and demobilization cost.
• Tracked Trouble Time.
• Utilized Summary Sheets to track well status from Drilling to Completion Phase.
• Utilizing advanced Excel Skills was able to complete reports in 2 hrs that had previously taken all day to produce.