Post Job Free

Resume

Sign in

Data Analyst Accounts Payable

Location:
Houston, TX
Posted:
August 06, 2023

Contact this candidate

Resume:

James Dallavalle

**** ******* *****, ********* ***, Houston, TX 77081

713-***-****

adyquh@r.postjobfree.com

Long-term, comprehensive experience in secondary education, administration, executive assistance, personnel hiring and training, invoicing, project spend reporting and database recordkeeping.

Bachelor of Science in Mathematics w/ Graduate-level Mathematics studies at University of Houston.

Proficient in SAP, Adobe Acrobat, Microsoft Office Suite, Visio and Business Objects.

Very high level of proficiency in Excel: creation of formulas, graphs/charts, dashboards and pivot tables

Self-driven, high-energy team player with solid communication and interpersonal work relationship skills.

Possesses excellent planning, organization, time management and decision-making skills.

Work experience as a secondary mathematics teacher (middle-school - Pre-Calculus)

Career Track

Data Analyst Jul 2022 – Present

Eastern Metal Supply

Tracked several metrics of Houston warehouse employees: a) OT Hours, b) Lines Pulled, c) Weight, d) Bundle Moves e) Orders and f) Exceptions/Errors. Recorded weekly data totals, within Excel, on a Puller “Scorecard”. Discussed strategies to mitigate exceptions and need for overtime hours with appropriate management personnel. Created a Power-BI report to track various metrics, using a variety of visuals and filters to display the required results. Created a method to track the type/frequency of daily internal exceptions captured, using a Power App. Trained warehouse personnel in tape measuring and basic math computations.

Secondary Mathematics Instructor Aug 2021 – May 2022

Fort Bend ISD

Taught Algebra I classes at Willowridge High-School in Houston, Texas

Exec Admin Ass’t/Project Assistant, Chevron Corp, Houston, TX 2008-2010, 2010-2021

Created/Modified a Power BI report to track data safety data from Chevron-owned facilities worldwide.

Created a Power App to update work-related roles of team members within our HES group.

Developed a comprehensive Access database for tracking oil & gas data for the ETC Subsea Team.

Updated PowerPoint slides to assist in tracking projects for the Process Automation (PA) Unit, to track annual budget, monthly spend, milestone initiatives and quarterly accomplishments.

Created an Excel dashboard displaying employee project code data, billable/non-billable time, job phase, lessons learned and time summary hours for engineers on the Fixed Equipment/Facilities Analysis team.

Created an Access database to track Service Orders, Purchase Orders and invoices for several PA teams.

Generated project codes from the TSG (Technical Service Gateway) system for both the PA/QA engineers.

Formulated pivot tables in Excel to display current SR-TD monthly project spending and budget spent.

Created a pivot table to track the PA team’s monthly budget/spend data vs targeted budget/spend figures using the VLOOKUP, IF-THEN and IFERROR statements.

Updated Excel documents and PPT files on various departmental SharePoint sites.

Ran custom percent billable, unaccounted hours, vacation balance and labor/time summary reports in SAP.

Collected year-end accrual data/information for both the PA and QA (Quality Assurance) teams.

Prepared presentation graphics to visually display information technology inventory and cost information.

Data Analyst, Reliant Energy (Facilitek Services), Houston, TX Aug 2010 – Oct 2010

Comprehensively evaluated & corrected errors with billed, residential and commercial records.

Using VLookUps, produced error reports with Excel.

Verified & cross-referenced database information.

Data Analyst, Reliant Energy (Facilitek Services), Houston, TX Aug 2010 – Oct 2010

Comprehensively evaluated & corrected errors with billed, residential and commercial record

James Dallavalle

Page Two

Accounts Payable/Bill Specialist, Various Services (temp assignments) Nov 2006 – Aug 2008

Worked for Noble Drilling Services, CGI International and Christus Hospital.

Diligently posted financial transactions to AP sub ledger in SAP.

Generated reports detailing open vendor invoices and payment plans out of SAP.

Accurately calculated line-item partial percentages and assigned charge codes for purchase orders.

Verified employee expenses, paid dates, payment amounts and coding data prior to entry into database.

Accounts Payable/Bill Specialist, Nami Resources Co, Houston, TX Jan 2006 - Oct 2006

Accurately calculated, coded, drafted & dispatched customer invoices and reconciled accounts each month.

Diligently maintained client contact information, mailed & voided checks.

Contacted vendors to discuss past-due balances and posted employee expense checks.

Associate Business Analyst, Duke Energy Corporation, Houston, TX 2001 – 2005

Utilized Business Objects to research paid invoices and generate reports on spending by outside counsel.

Tracked hardware equipment and supplies for Duke Energy International’s Legal Department…

Formulated an Excel spreadsheet to monitor personnel software compliance.

Routinely managed and updated the legal department’s organization chart.

Diligently tracked AP queries, journal detail records, quarterly discount savings and monthly billing totals.

Administrative Assistant, Assistant Coordinator and Liaison 1997 – 2001

Contracted to various companies, including SBPA Systems, Mental Health Assoc, Telecheck,

American General, ExxonMobil, Phillips Petroleum and Continental Airlines.

Worked as a tester and developer of software systems for SBPS Systems, a medical manufacturer

Maintained legal records and drafted correspondence letters in Word to donors on behalf of MHMRA.

Calculated gross profit from internal pricing models and instituted medical software applications.

Assisted in the implementation of a practice business continuity testing plan for a team at ExxonMobil.

Instructed high school industrial mathematics courses to Aramco personnel in Saudi Arabia.

Secondary Mathematics Instructor 1992 – 1997

River Oaks Academy, Galena Park ISD, North Forest ISD, Huffman ISD, Humble ISD, Hitchcock ISD, Fort Bend ISD

Taught Eighth-Grade Mathematics, Computer Math, Consumer Math, Algebra 1 and Geometry at several school districts and a Psychiatric Facility within the greater Houston, Texas Metro Area.

Technical Recruiter and Salesman, Milam Design Services, Houston, TX 1989 – 1991

Proficiently acquired and dispatched temporary engineering personnel.

Communicated with client firms to discuss employee requirements.

Thoroughly reviewed applicant resumes and matched skill sets with available positions.

Secondary Mathematics Instructor 1985 – 1989

Donna ISD, PSJA ISD, Edinburg ISD, Galena Park ISD

Taught Middle-School Mathematics, Compute Literacy, Informal Geometry and Fundamentals of Mathematics at several school districts in the Rio Grande Valley and Houston, Texas

Education

University of Houston, Houston, TX

Graduate-level Mathematics Studies 2009-2014

St. John’s University, Collegeville, MN

Bachelor of Science - Mathematics 1979-1983



Contact this candidate