SEAN A. BRASNER
PASADENA,CALIFORNIA
Summary
Seasoned Business Analyst offering [Number] years of [Industry] industry success. Expert on business and systems requirements, user acceptance testing and end-user training. Accomplished at leveraging past lessons to inform future decision-making. Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills.
Overview
28
28
years of professional experience
Work History
BUSINESS/DATA ANALYST
ACT-1 STAFFING & PERSONNEL SERVICES
02.2010 - Current
- Develop Tableau dashboards consisting of financial/operation/sales performance indicators that are distributed to the regional leaders as well as present findings
- Oversee the sales performance of 500+ employees throughout the organization
- Provide market analysis on competitors’ compensation programs vs
- Internal programs to leverage position in the marketplace
- Remodel executive compensation programs based on competitive analysis in order maximize ROI on plans
- Coach and mentor sales leadership upon achieving sales standards for their respective regions
- Manage sales database and perform query outputs for ad hoc and cyclical reporting on sales compensation analysis
- Collaborate with Human Resources and Talent Development departments on the New Hire and Ramp-Up analysis of sales force to ensure mutual profitable onboarding process.
DATA VISUALIZATION/BUSINESS INTELLIGENCE ANALYST
RAPP
09.2009 - 01.2010
- Compiled raw data pertaining to performance statistics of marketing campaign
- Extract SQL Server and formatted reporting data for input into Tableau data pivoting and visualization software
- Developed dashboards consisting of key performance indicators that aided in leveraging clients’ operational/marketing needs.
SENIOR FINANCIAL ANALYST (Consultant)
SPECIALTY LABORATORIES
01.2008 - 05.2009
- Performed trend analysis and forecasted future costs of specimen pricing on hospital contracts
- Performed variance analysis of actual versus budgeted expenses for departments throughout the company
- Prepared monthly reports and spreadsheets reflecting the expenditure of the departments to corporate executives
- Performed ad hoc analysis to various department heads regarding the performance trends of their respective business units
- Extracted data to perform reporting and analyses from Cognos and Oracle ERP platforms.
SENIOR INCENTIVE COMPENSATION ANALYST (Consultant)
INDYMAC BANK
10.2006 - 08.2007
- Calculated incentive compensation via modeling for 400 employees on monthly and quarterly basis and prepared income statements reflecting their respective compensation
- Responded to inquiries from employees regarding driving components leading to their payouts
- Interacted with business unit executives in terms of calculating the differential of compensation payouts based on altered metrics compared to original metrics within various compensation plans
- Performed trend analysis of compensation performance within respective business units
- Collaborated with compensation plan committee and legal department in terms of officiating the verbiage used in compensation plans
- Acted as liaison between business units and payroll department in preserving the quality and assurance of incentive compensation for employees
- Developed an auditing model that generated an automating effect in validating payroll data.
PRICING/VALUATION ANALYST
INFINITY WEALTH ADVISORS
11.2001 - 09.2006
- Tracked ongoing annuity pricing for portfolio of private wealth investors
- Coordinated with insurance sales brokers in respect to servicing insurance policyholders regarding their investment valuation
- Performed statistical and actuarial analysis in determining premiums and benefits of life and health insurance products
- Maintained profit and loss schedule for portfolio of annuity investors.
PRICING/COMMISSIONS ANALYST
J.P. MORGAN CHASE
08.1999 - 10.2001
- Developed pricing model outputting trade activity on credit derivative and bond products
- Calculated present value and other statistical calculations on trade activity funneling to traders’ monthly commissions
- Calculated monthly reserve for trade activity based on differentiation of market quotes that are company-based versus externally-originated
- Interfaced directly with credit derivative traders to reconcile differences in reserving and pricing issues regarding respective trade activity
- Maintained a profit and loss schedule in terms of traders’ profitability.
ACTUARIAL/SALES COMPENSATION ANALYST
MONY GROUP (formerly Mutual of New York)
03.1996 - 07.1999
- Consulted with sales force regarding their productivity targets and corresponding compensation payouts
- Assisted in the design, structure and implementation of salary financing plan
- Assessed and analyzed risk involving the implementation of newly-imposed financing plan
- Performed financial modeling of compensation program to determine cost effectiveness versus existing company compensation plans
- Performed hypothetical scenario testing to determine optimal effects of financing plans
- Prepared forecasting models of future compensation and calculated valuations for clients based upon present production statistics
- Developed annuity model in determining policyholders’ return on investment
- Prepared financial statements to reflect actual performance and productivity of clients
- Prepared product line profitability analysis of future compensation
- Managed compensation database regarding the production of the sales force.
Skills
- CRM Systems
- Internal Auditing
- Product Development
- Data Acquisition
Timeline
BUSINESS/DATA ANALYST
ACT-1 STAFFING & PERSONNEL SERVICES
02.2010 - Current
DATA VISUALIZATION/BUSINESS INTELLIGENCE ANALYST
RAPP
09.2009 - 01.2010
SENIOR FINANCIAL ANALYST (Consultant)
SPECIALTY LABORATORIES
01.2008 - 05.2009
SENIOR INCENTIVE COMPENSATION ANALYST (Consultant)
INDYMAC BANK
10.2006 - 08.2007
PRICING/VALUATION ANALYST
INFINITY WEALTH ADVISORS
11.2001 - 09.2006
PRICING/COMMISSIONS ANALYST
J.P. MORGAN CHASE
08.1999 - 10.2001
ACTUARIAL/SALES COMPENSATION ANALYST
MONY GROUP (formerly Mutual of New York)
03.1996 - 07.1999
Similar Profiles
Calvin R. Dailey JR.Calvin R. Dailey JR.
Certified Medical Assistant at A-1 Personnel Staffing/ City Of Houston Health DepCertified Medical Assistant at A-1 Personnel Staffing/ City Of Houston Health Dep
Marie AguirreMarie Aguirre
Manager at A-1 Personnel ServicesManager at A-1 Personnel Services
Karla DiazKarla Diaz
Patient Administrative Specialist at Option 1 Staffing ServicesPatient Administrative Specialist at Option 1 Staffing Services
Araceli Guillén-TuerpeAraceli Guillén-Tuerpe
SENIOR MEDIA SUPERVISOR at Cooper-Smith AdvertisingSENIOR MEDIA SUPERVISOR at Cooper-Smith Advertising
MANDI PEACHMANDI PEACH
Paralegal at Laurel Employment Law, APCParalegal at Laurel Employment Law, APC