SUMMARY:

• Experienced accounting and analytical professional with exceptional analytical, reporting and interpersonal communications skills seeking new challenge

TECHNICAL SKILLS:

• Excel Power User
• Access
• Word
• PowerPoint
• Project
• Hyperion Essbase
• Oracle BI EE
• SAP
• SRC
• Crystal Reports
• Business Objects
• IDC
• PeopleSoft
• SQL
• FundStation
• VAX
• MAS90
• MS People
• MS Sales
• MS Spend
• MS Invoice
• MS Vendor
• MSRA
• Tymetrix T360 xCAT
• MFACCT and ADP.

PROFESSIONAL EXPERIENCE:

Finance Analyst

Confidential, Redmond, WA

Responsibilities:

• Pulled complex Excel data in MSRA and Mercury to check data entries for FDM team
• Reconciled and delivered daily data reports for high visibility NRS accounting project.
• Cross trained to serve as backup in performing file automation process using SQL
• Documented and created procedures for both reporting and automation processes

Sales Compensation Analyst

• Revised complex Excel data model to calculate Sales Compensation for company
• Pulled data from Essbase and reports from Oracle BIEE Portal for use in models
• Updated and improved procedures and built ad - hoc reports from internal data queries
• Re-built compensation budget model for compensation and salary expenses

Financial Analyst 2

Confidential, Bellevue, WA

Responsibilities:

• Engineered complex Excel data model to implement $6M budget for Bing RNR team
• Revised, reconciled and delivered weekly and monthly production reports for the team.
• Simplified and streamlined existing reports to provide timelier information for users
• Rewrote reporting procedures and built ad-hoc analyses from internal data pulls

Senior Financial Analyst

Confidential, Redmond, WA

Responsibilities:

• Crafted new Excel data model to identify $100K of unauthorized invoice items per year
• Revamped internal and external vendor audits saving $1M annually.
• Improved T360 system processes and solved data issues for more accurate reporting
• Slashed legal rate increases 35% negotiating with legal vendors saving $500K annually
• Automated and implemented process improvements for internal procurement tools
• Queried data using Access & MS Spend for creating timely ad-hoc reports
• Formed new detailed Crystal Reports to reconcile and confirm data integrity for managers during system transition
• Edited, implemented and communicated new policies and procedures to staff & vendors
• Investigated billing and rate variances to normalize them and to correct any errors
• Audited internal vendor budgets for compliance to policy

Data Analyst 2

Confidential

Responsibilities:

• Created and delivered analytical reports using various internal data models
• Built ad-hoc analyses from data pulls for detailed Excel pivots and PowerPoint slides to provide requested deliverables to complete a time sensitive project for the Global Procurement team.

Business Analyst 2

Confidential, Seattle, WA

Responsibilities:

• Improved procedures and analyzed sales data for the Wireless sales team.
• Assembled internal presentations and analytical reports for the company’s fraud team, and created new Visio and Project schemas detailing the process flow.
• Wrote, designed, scheduled and implemented new standardized procedures to improve fraud prevention for the wireless team.

Business Systems Analyst 3

Confidential, Issaquah, WA

Responsibilities:

• Engineered and maintained financial models and analytical reports for the Worldwide Services Finance team.
• Produced PowerPoint presentations for the company’s strategic plan, and structured new Project and Visio schemas for the team.
• Wrote and revised technical vision statement for the group.

Senior Treasury Analyst

Confidential, Seattle, WA

Responsibilities:

• Improved and maintained cash, budget, and analytical reports for executive team.
• Wrote detailed analysis for revising the company’s pension plan, and created and administered letters of credit for the company.
• Rewrote audit procedures, and assisted the director with the stock repurchase program.

Senior Financial Analyst

Confidential, Seattle, WA

Responsibilities:

• Generated models and reports for finance group with Excel and Hyperion Essbase.
• Forecasted loan volume and delivered ad-hoc analyses for the group, and documented and improved reporting procedures and processes.
• Normalized large data sets & modeled numbers for sales associates’ compensation plan.

Compensation Analyst

Confidential, Seattle, WA

Responsibilities:

• Analyzed job leveling data using Excel, Access, and queried SAP HCM module and initiated change requests.
• Evaluated staffing and market compensation levels for various managers.
• Communicated and met with hiring managers and HR managers to match the job and salary requirements of their positions into the new compensation model, and explained details of the new system to the managers.
• Generated regular updates that allowed our compensation analysis model to be used effectively by team.
• Compiled & prepared salary survey information to Mercer and Milliman and Salary.com.

Financial Analyst

Confidential, Redmond, WA

Responsibilities:

• Modeled new sales incentive compensation plan using Excel and various internal data tools and implemented plan for Worldwide OEM team.
• Simplified plan processing and calculated and reconciled compensation and quarterly payouts for participants

Financial Analyst

Confidential, Bellevue, WA

Responsibilities:

• Adapted and maintained income, budget, and analytical reports for executive team.
• Wrote and reworked analysis for the company’s quarterly 10Q report, and researched expense and competitor analyses for management.

Business Analyst

Confidential, Redmond, WA

Responsibilities:

• Administered accounting software called FundStation, which provided mutual funds data to internal and external sources, and used Access, Excel, SQL queries, MFACCT data pulls, and designed Crystal Reports to sort and analyze the data.
• Used pivot tables and macros for management trend reports and rate of return reports.
• Managed the IDC compliance software and tested and fixed issues with our accounting systems and various reports insuring compliance with the Sarbanes Oxley regulations as well as troubleshooting any issues that were found with the reports and data.
• Served as project manager and tracked spend for software upgrade projects.