Polished acumen of financial analysis & reporting to include fiscal period

compilation/review for delivery to executive management. Heavy technical data skills in spreadsheet manipulation, database management & dashboard presentation. Knowledgeable in multiple applications, lines of business, management styles & industries. Personal initiative to develop automation, process improvement and report standardization.

Sr. Data Analyst, Gainwell Technologies, Austin, TX, USA Nov 2022 to Jan 2024

Developed a model to create a Timesheet Correction Tool for the Engineering team to automate the process from input to manager approval to correction in a common SharePoint site. Used existing Pivot Table model to create Month End Reports for 7 different Engineering Departments in Power BI. This project required using MS Power Query to automate the Data management process, & using the formatted table to feed Power BI for a semi-Automated workflow. This also offered the user multifunctional Drill down/Filter views to the data. The report also provided a YTD, Prior-to-Current period, view of the data. In contrast to the 1-month view on prior Pivot Table reports. I also finished approx. 30 on-line data tutorial courses on top of the required career development corporate courses.

Sr. Advisor, Dell Technologies, Austin, TX, USA

July 2015 to Nov 2021

Managed the Marketing Ops, NA Channel, MyRewardFunds (MRFs)Sales Rep incentive program for the participating NA Channel Partners (NSP, MB, SMB). This represented

$1.2m in Quarterly payouts across 5 LOB’s, & dozens of Dell Products Required calculating performance payouts and compiling communication files out to the partners. Transitioned to Outbound Leads once the incentive program became automated in a Customer Portal App. Heavy use of Excel/Access/VBA/SQL to crunch & summarize huge sales data sets. Able to automate the process to decrease turn-around time and manual errors. Prepared EOQ Trend/Variance analysis for all Partners, LOB’s & Products included in the MRFs incentive program. Became the point person for any follow up action items. Responsible for Loading the Weekly Trigger campaign files for a lineup of Business Unit & Sales Rep plays via Sales Force, prepped & Loaded Sales Play campaigns to the lead engine using VBA, and automated and slashed processes time for Trigger Loads utilizing various data apps including Excel, Access, VBA, SQL and others. Sr. Financial Analyst-Rev Rpt, Active Power, Austin, TX, USA Sep 2008 to May 2015

Responsible for all revenue reporting for Active Power global sales avg $18m/qtr. Reported directly to the Comptroller & CFO in a Local UPS MFG company. Developed a robust revenue package that summarized $18M in quarterly revenue across a global product line. Used by Executive Mgmt for 10k & Board reporting. Determined trend drivers, variances, and KPI’s for corporate operational leaders. Compiled & Analyzed AR aging reports that were instrumental in determining the company's cash management policy. Prepared the Allowance for Doubtful Accounts report & calculated the necessary reserve for Bad Debt. Managed the commissions schedule for US/EMEA/Asia sales based on bookings & revenue by company product line. Developed processes to automate, A/P,A/R

& Deferred Revenue Reports by incorporating Access queries, V-lookups, SumIf statements & Macros

H/P Hector Parra

Professional Financial/Data Analyst

- 512-***-****

- ad3v8b@r.postjobfree.com

- Austin, TX, USA

-LinkedIN

www.linkedin.com/in/hparra-

analyst-atx99

SKILL

Accounting/Finance

• Revenue Analysis

• Month End Reporting

• Variance/Trend Analysis

• Invoicing

• JE Posting

• Account Reconciliation

• Deferred Rev Recognition

• Aging report activities

• Sox/Process Documentation

Marketing

• Sales Rep Incentive program

Data management.

• Booked Sales Plays/Triggers to

Salesforce.

• Paid commissions off

Commission schedule.

Data Management

• Advanced Excel

• Pivot Tables/v-Lookups

• Excel Power Query

• Excel Macro’s

• Excel VBA

• SQL

• Tableau

• Power BI

• MS Access

• MS Office Suite: Word,

PowerPoint, Outlook, Excel,

Access

• SAP

• Salesforce

• Teams

• SharePoint

ABOUT ME

EXPERIENCE

• University of Texas El Paso

BBA – Finance / POM, 1999

• English/Spanish/Italian

CONTACT

Contact this candidate