Commission Analyst Resume Sample
Kristopher Braun
47289 Angela Road,
Detroit,
MI
+1 (555) 905 8995
Work Experience
Senior Commission Analyst
01/2016
-
PRESENT
Boston, MA
- Excellent customer service attitude, professionalism, and advanced verbal and written communication skills
- Advanced skills with Microsoft Excel (V-Lookups, Pivot Tables) and MS Access
- Experience in SQL database – intermediate skills, writing queries, and VBA is highly desired
- Knowledge of Varicent, or other similar ICM is desired
- Extensive knowledge and experience working with Xactly/Callidus/Oracle or other commission platforms in an administrative capacity
- Technical proficiency with PCs, MS Office and Windows environment
- Advanced Excel skills. Ability to prepare spreadsheets and analytical models using complex formulas, functions, links, macros
- Advance MS Access skills. Ability to create and manage databases. Ability to quickly learn financial software applications
Commission Analyst
05/2011
-
11/2015
Philadelphia, PA
- Understand and analyze financial data, as well as ability to evaluate processes and develop improvements
- Maintain confidentiality of employee data and business plans
- Organize information from different systems into integrated reports
- Knowledge of SOX compliance rules and regulations
- Quickly learn financial software applications
- Championing the commission process and working with the various stakeholders (finance, HR and our sales team) to ensure the timely execution and ongoing improvement
- Support the design and implementation of sales compensation plans, policies and processes each fiscal year (or as needed) that support business objectives
- Calculating and reconciling commissions, which includes scrubbing data from multiple sources
VMS Commission Analyst
05/2007
-
12/2010
New York, NY
- Assist with plan effectiveness assessment through data analysis of relevant compensation, HR and target attainment data
- Partnering with the Finance department to support accrual entries
- Auditing the current guidelines and processes and finding the opportunities for improvement
- Manage and support our internal commissions tool
- Daily administration, troubleshooting and support of commission system
- Maintains the system for all new hires, terminations and other headcount movement. Includes updating plans, quotas, rate tables and hierarchies, as well as creating compensation plan documents
- Responsible for collecting, analyzing and processing objective-based bonuses on a quarterly basis
Education
Lindenwood University - Belleville Campus
2002 - 2006
Bachelor's Degree in Finance
Professional Skills
- The ability to establish and maintain cooperative working relationships with internal and external working partners is required. Liaisons with Sales Commissions, Sales Operations, Finance, and other departments
- Excellent interpersonal skills with a proven ability to work as part of a team
- Demonstrated interpersonal skills to consistently demonstrate job knowledge
- Exceptional verbal and written communication skills. Ability to communicate effectively with all levels of management
- Demonstrated customer service skills in a professional business environment
- Strong analytical skills and effective use of information and reporting systems
- Excellent communication skills, especially in one-on-one and small group settings
How to write Commission Analyst Resume
Commission Analyst role is responsible for analytical, excel, reporting, compensation, advanced, database, research, retail, finance, training.
To write great resume for commission analyst job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For Commission Analyst Resume
The section contact information is important in your commission analyst resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:
- First and last name
- Telephone number
Work Experience in Your Commission Analyst Resume
The section work experience is an essential part of your commission analyst resume. It’s the one thing the recruiter really cares about and pays the most attention to.
This section, however, is not just a list of your previous commission analyst responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular commission analyst position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative Commission Analyst resume experience can include:
- Skilled at working as a contributing team member and individually on set projectsLanguage Skills
- Highly developed analytical skills and effective use of information and reporting system
- Demonstrated reporting and analytical skills
- Strong MS Excel skills (formulas, pivot tables, macros)
- Prior experience working with technical implementations
- Work experience in finance or accounting or related experience
Education on a Commission Analyst Resume
Make sure to make education a priority on your commission analyst resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your commission analyst experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.
Additional details to include:
- School you graduated from
- Major/ minor
- Year of graduation
- Location of school
These are the four additional pieces of information you should mention when listing your education on your resume.
Professional Skills in Commission Analyst Resume
When listing skills on your commission analyst resume, remember always to be honest about your level of ability. Include the Skills section after experience.
Present the most important skills in your resume, there's a list of typical commission analyst skills:
- Strong analytical capabilities and superior problem-solving skills to gather and interpret data is required
- Possesses written communication skills enabling independent handling of correspondence
- Demonstrated experience in establishing positive relationships and working with all levels of management
- Extremely organized with excellent multi-tasking. Ability to adjust priorities based on workload
- In process operations or analysis with demonstrated experience in problem-solving projects
- Strong process development and writing experience
List of Typical Experience For a Commission Analyst Resume
1
Experience For Senior Commission Analyst Resume
- Professionalism: ability to respond to sales compensation requests in a timely manner and be able to communicate effectively in writing and/or over the phone
- Progressive finance/business admin experience; mid-to-large public company, preferable with understanding of sales
- Responsible for the collection, analysis, audit, aggregation, scrubbing and consolidation of all commission and revenue data on a monthly basis
- Experienced in Finance Controlling, Finance Business Operations or as a Total Rewards professional
- Work experience in Operations, Accounting, or other business related field
- Extensive experience in interfacing with various senior level business owners, across multiple time zones
- Accounting, finance, payroll experience
2
Experience For Fp&a / Commission Analyst Resume
- Calculates/Validates and proceeds pay variable earnings accurately on time for assigned sales teams and in line with current comp plan rules
- Related experience in accounting, finance operations, or sales compensation administration
- Ensuring all reward payments are being processed in accordance with policy and procedure within agreed performance levels
- Ensuing all payments are being calculated accurately and paid on a timely basis in line with company reward schemes
- Ensuring target allocations relating to Customer Lifetime Value (CLV) and Business Revenues are accurately maintained
- Calculating Europe ‘Go To Market’ Commissions for specific area
3
Experience For VMS Commission Analyst Resume
- Working alongside our outsourced partners to ensure that Commission governance and approvals are consistently adhered to
- Governing accurate records on the rewards systems (i.e. Oracle and Payplan) to facilitate accurate and timely payments
- Responsible for collecting and processing sales data for past due accounts and consulting orders monthly
- Develop, edit and distribute training materials on commission system for new hires and provides retraining for existing employees
- Responsible for updating and maintaining sales files for future periods as well as reassigning accounts as needed
4
Experience For Manager, Commission Analyst Resume
- Lead for commission statement reporting improvements/UAT for any new plans/reporting required during plan year
- Assist in licensing issues, missing or disputed payments, and additional issues raised by brokers requiring resolution
- Assists with updating and maintaining internal procedure documents
- Provides high quality, timely responses to the sales field and sales management, fully meeting their informational and reporting needs
- Responsible for reporting and tracking sales and commission payments to the Sales department
- Provide high quality, timely responses to management, fully meeting their informational and reporting needs
5
Experience For Commission Analyst Resume
- Participates in User Acceptance Testing and other projects within GCO, coordinating with a global team of analyst involved in the projects
- Work with Total Rewards during incentive plan design to understand the plans and the implications for the ICM tool, raising any concerns for implementation
- Ensure the Airline Contract Worksheet is sustained by identifying new audits and tracking completed audits
- Query large datasets utilizing a variety of Business Intelligence tools, including Cognos, Tableau, MS Power BI, etc
- Be able to adapt to changes associated with a growing company
6
Experience For Senior Commission Analyst Resume
- Maintain detailed, accurate, and organized records of commission research, calculations, payouts, and reconciling items
- Responsible for incoming producer communications via phone, email, mail, and fax
- Oversee process of providing timely and accurate responses to inquiries from all commissions payees
- Analyze customer and associate enrollments and other source data to ensure smooth running of commissions based on these data sources
- Strive for continual improvement, making the various commission processes as efficient as possible
7
Experience For Fp&a / Commission Analyst Resume
- Proficient in Excel using Pivot Tables, Graphs and Charts
- Works autonomously but interacts with other team members as needed, escalating items when needed to management
- Able to multi task and deliver results in a fast-paced environment with tight deadlines while maintaining accuracy
- Provides understanding to other team members, helps other commission analysts as needed on plan guidelines
- Extensive research and error resolution to resolve commission accounting discrepancies
- Research, audit, and reporting projects as assigned
- Performs necessary analysis and financial summaries pertaining to all payments
- Act as first line of contact for commission disputes and reconciliation, escalating issues as appropriate
- Set up and manage the business rules in the ICM tool, liaising with ICM consultants
8
Experience For VMS Commission Analyst Resume
- Undertake reporting and analysis to enable the business to understand cost of incentive pay
- Performs variance analysis on quota attainments
- Assists with data collection for quarter-end accrual
- Assists with research and analyze disputes and discrepancies reported by the sales team
- Proficient with intermediate/advanced MS Excel functions, such as lookup/IF functions and pivot tables
9
Experience For Manager, Commission Analyst Resume
- Work independently, prioritize assignments and manage multiple projects simultaneously while adhering to strict deadlines in a dynamic fast-paced environment
- Works well independently, but understands importance of working as a team and helping other team members as needed
- Commission Accounting payfile generation Lead for a specific GEO
- Perform analyses, reconciliations, Sox compliance activities, and ad hoc reporting as directed
- Multi task and work towards tight deadlines while maintaining accuracy
- Knowledge of relational databases & SQL
10
Experience For Commission Analyst Resume
- Mastery of Microsoft Excel with knowledge of cube functions and PowerPivot
- Advanced Microsoft Excel (pivot tables, vlookup, logical statements)
- Audit customer’s MLM commissions and rank, to ensure accuracy with MLM system and communicate your findings to internal departments or Rep Customers, in a way that is easily understood
- Advanced Microsoft Excel, as well as Business Objects, Qlikview, Cognos/Varicent is required
- Performs month-end reconciliations between the sub-ledger and general ledger; research and resolve variances.Accounts reconciled include current and non-current C&W and Outside Broker commissions payable
- Monitor deficit broker balances, obtain collection status from branch personnel and coordinate the collection of deficit balances with the Accounts Receivable Department.Analyze, record and report on deficit broker reserve balances quarterly
- Assist in the training and development of the Broker Compensation Analysts resulting in strengthening of the overall team and providing flexibility, opportunity, and results.In addition, provides training to Branch and Corporate Commission Accountants so that they have a working knowledge of the compensation function
- Interface with internal Finance and A/P teams to manage distribution of commissions
List of Typical Skills For a Commission Analyst Resume
1
Skills For Senior Commission Analyst Resume
- Exceptional Microsoft Excel/Access skills are essential
- Intermediate – Expert level skills with Word, PowerPoint, and Outlook required
- Fluent written and verbal skills (conversational and business communications) in English required
- Communicate effectively with sales agents and other departments
- Access database skills (ability to edit, create, save)
- Prior experience in sales operations and / or commissions / incentive compensation
2
Skills For Fp&a / Commission Analyst Resume
- Demonstrated intermediate level experience with Excel (vlookup, sumif, pivot, etc…)
- Experience and/or military experience
- Prior experience in software/high tech industry is preferable
- Implementing effective controls and reporting to ensure integrity of salescommissions
- Implementing effective controls and reporting to ensure integrity of sales commissions
- Working knowledge of Anaplan strongly desired
3
Skills For VMS Commission Analyst Resume
- Conducting relevant analysis/experience (e.g. payments made, frequency of payments, trends etc)
- Skill in operating a personal computer utilizing Microsoft Office products and/or other general business and specialized software applications
- Experience in commissions processing, finance, accounting, financial data analysis and/or related fields
- Coordinate and complete validation of system set up for new plan structures, and document annual user acceptance testing
- Good working knowledge of Salesforce CRM or PRM tool required
4
Skills For Manager, Commission Analyst Resume
- Previous experience in handling confidential matters is desired
- Experience of progressive finance environment; mid-to-large public company, preferable with an understanding of sales and sales commission
- Progressive finance experience; mid-to-large public company, preferable with an understanding of sales and sales commission
- Progressive finance experience; mid-to-large public company, preferable with understanding of sales and sales commission
- Related accounting and analytical experience
- Previous experience working in commissions/Analytical role required
5
Skills For Commission Analyst Resume
- Experience with resolving broker payout disputes
- Progressive finance experience with mid-to-large public company, preferable with understanding of sales and sales commission
- Demonstrated knowledge and use of Excel spreadsheets
- Previous experience with commission processes and systems
- Previous experience with Medicare and/or the healthcare insurance industry
6
Skills For Senior Commission Analyst Resume
- Hands-on experience with innovative technology
- Experience within the travel industry/corporate travel
- Experience with Microsoft SQL Server 2012 or 2016
- Experience with Commission Plan administration
- Experience in a sales support capacity
- Validate sales data for accuracy and consistency with the guidelines as defined in the compensation plan terms and conditions
- Review and validate payroll report post commission payments
- Build effective partnerships across teams
7
Skills For Fp&a / Commission Analyst Resume
- Ensure effective communication and issue resolution with sales force
- Experience in journal entries
- Reviews compensation plans and validates Income Plan metrics to perform appropriate calculations to accurately pay commissioned employees
- Reviews and validates that submitted employee commission paperwork is complete and meets established commission criteria
- Strong enthusiasm, drive and a desire to learn
- Experience with enterprise software companies and SaaS business models
- Review and validate payroll calculations
- Demonstrated knowledge of the broker distribution channel
- Demonstrated ability to create and edit documents and presentations in MS Word, PowerPoint
8
Skills For VMS Commission Analyst Resume
- Calculates/validates pay variable earnings accurately and on time for assigned sales teams and in line with current comp plan rules
- Calculates/Validates and pay variable earnings accurately and on time for assigned sales teams and in line with current comp plan rules
- Drive administration and implementation of financial and process controls to improve process effectiveness
- Implementing and configuring incentive compensation plans using Xactly Software
- Implementing and configuring incentive compensation plans using Xactly
9
Skills For Manager, Commission Analyst Resume
- Keying in variable pay claims into Oracle and respond to queries within SLA using the CRM system ensuring all FTR reason codes are completed
- Creating/maintaining database of rules and logic for Xactly plans
- Providing commission expenses reporting and analytics
- Providing phone and email support relating to commissions to external and internal customers
- Helping scale and streamline the incentive compensation workflow process
10
Skills For Commission Analyst Resume
- Managing data within the Xactly commission module for new hires, plan changes, and terminations
- Maintaining monthly commission analysis andcalculate required financial accruals for payments
- Assisting in the creation of the commission accrual methodology and test for accuracy
- Managing data within the Xactly for new hires, plan changes, and terminations
- Working knowledge of general database structure, rules and topics
- Working knowledge of PDF software (Adobe Acrobat, Nitro Pro, etc.)
- Ensuring the wider team’s delivery of a timely, accurate and efficient Commissions administration service for eligible employees and line managers
List of Typical Responsibilities For a Commission Analyst Resume
1
Responsibilities For Senior Commission Analyst Resume
- Highly skilled in the use of Microsoft Office suite ( particularly, Excel, Access and outlook ), Oracle (11.5.9), SQL, DB2
- Auditing commission calculations to ensure they are accurate and within the scheme criteria and applied to payroll correctly
- Maintaining a full audit trail to ensure audit compliance on Virgin Media Business Commission schemes
- Interact with sales organizations to address inquires regarding sales and resulting commissions
- Drive maintenance of detailed documentation of commission related data for management and cross-referencing to Anaplan
- Manage the full cycle of company’s variable compensation process, including documentation, calculations, and sign-off workflow
2
Responsibilities For Fp&a / Commission Analyst Resume
- Learn company policies on ASC606 to determine accounting treatment for various payment types
- Highly organized and motivated with the ability to work on multiple projects while delivering results in a timely manner
- Familiar with intercompany accounting
- Assist co-workers with meeting the team’s daily production goals
- Expert point of contact for all queries relating to commissions payments (help desk contact)
- Prep/Review of files used during monthly commissions process
3
Responsibilities For VMS Commission Analyst Resume
- Build relationships with finance and operations BPs to continue improving processes
- Use business tools and resources to gather missing information for orders and commissions
- Proactively audit carrier commission payments vs contract and billing data
- Supports the creation of crediting rules and sales rep master Territory Target Sheets (TTS) for their specific sales teams
- Creates TTS’s for their teams, with insight and understanding for accuracy and alignment to Sales Compensation Plan
- Review employee commissions, to ensure accuracy regarding payment, quota attainment and any outside payouts to Global Sales Team
- Manually and accurately enter commission records, including deal bookings into Company’s commission systems
- Provide thorough and timely support to Sales, Sales Operations, HR and Finance regarding sales incentive programs
4
Responsibilities For Manager, Commission Analyst Resume
- BS/BA in accounting, finance, economics, sciences or other quantitative fields
- Oversight of the entire appointment process to ensure proper completion of contracts and marketing agreements for internal agents and commercial brokers/GA
- Sales support and administrative services to non|employee selling producers
- Work schedule flexibility, including availability for overtime
- Works autonomously, escalating items when needed to management
- Multi task and deliver results in a fast-paced environment with tight deadlines while maintaining accuracy
- Knowledge of applicable Federal, state and local statutes, rules, regulations, ordinances and other governing documents/requirements
- Collaborate with geographically distributed teams
5
Responsibilities For Commission Analyst Resume
- Multi-task in fast paced environment and meet deadlines
- Be proficient in Microsoft Excel and PowerPoint
- Knowledge of sales processes and incentive programs
- Conduct daily Egencia corporate audit of airline tickets to confirm accurateness
- Maintain a personal audit log to collect all types of completed audits and track any errors identified
- Be proficient with the airline contracts and rule regulations to recognize any internal and external system issues, report to the appropriate teams, and work towards a resolution
- Serve as a liaison between Commission and support functions ( ADM team, Settlement, and Ticketing), on process improvements, ad-hoc research, analysis and reporting as needed to serve business partner needs and support Commission team members
- Perform ‘root-cause’ analysis on issues with commissions payroll – system driven, process design, absence of process or training
- Responsible for supporting the creation quota assignment and alignment of territory assignments for the channel team
6
Responsibilities For Senior Commission Analyst Resume
- Guide Management on the easiest plan to creating quota that can be paid timely
- Responsible for being first line support for any queries for maintenance of commission related questions and profiles in Anaplan
- Drive maintenance for organizational changes into Anaplan for new hire, terminations, and territory/account changes
- Work collaboratively with the wider HPE team for readiness and support for assignment of Partner level quota needed for EG/DCIG side of the house
- Work collaboratively with VP of Channel and multiple Channel Directors to determine quota for channel organization
- Deploy and maintain quota in Anaplan system
- Respond to the sales team’s inbound inquiries.For example: quota letters, commission payment calculations, historical achievement trends, payment dates, policy interpretation, etc.Responding to questions on territory assignments and quota
- Given Channel Reps overlay to field sales, monitor and maintain change of assignments or quota as these changes have ripple effect on Channel side
- Calculate monthly commission accrual for domestic and international sales organization
7
Responsibilities For Fp&a / Commission Analyst Resume
- Prepare commission statements and payments for domestic and international sales team
- Calculate prepaid commissions balances and amortization schedules
- Model various earned commission scenarios due to complex license agreement terms
- Prepare monthly and quarterly commission accruals
- Full ownership of commission accruals and payment reconciliations
- Provide support to inquiries from external auditors
8
Responsibilities For VMS Commission Analyst Resume
- Prepare monthly commission forecast
- Assist in incentive compensation budget process
- Participate in annual incentive plans creation, documentation and goal letters
- Ensure accurate and timely payment of commissions to external producers. Process changes to agents’ payment accounts and Assignments of Commission. Reissue payments to agents upon request
- Ensure accurate and timely payment of commissions related to commission payment inquiries. Perform research on commission questions, resolve discrepancies, and communicate results to appropriate parties
- Process changes to information in the commission system
- Perform monthly control audit reports, communicate results timely and consistently
- Interact via written and verbal communication with Sales Distribution Operations, Agent Onboarding, Sales leadership, Producer Help Desk, and Sales agents on commission status, issues and resolution
- Coordinate cross functionally within and outside the Commission team to ensure commission payments occur at the correct times by communicating the business rules, plan administration and commission processing timelines
9
Responsibilities For Manager, Commission Analyst Resume
- Draft commission procedures manual as needed
- Adhoc compensation analysis as required by business /partners (HR/Compensation/Ops)
- Internal & External Audit documentation preparation as required
- Commission Web Page Administrator - EMEA
- Back up contact for region commission manager
- Assist with commission calculations and payouts
10
Responsibilities For Commission Analyst Resume
- Work with commission team to prepare commission statements and disseminate
- Work with HR and Sales to ensure new or modified comp plans are issued and received timely
- Gather, research, and supply data and information needed by the commission team
- Analyze commission data for completeness
- Calculate carrier commission payout report
- Create reports and summaries in accordance with commission-related projects in a timely manner
- Utilize ERP system and spreadsheets to gather data for calculations
- Understands and can implement The Autodesk Compensation Plan
- Gives input into and support the rollout of changes to the commissions system
Related to Commission Analyst Resume Samples
AML Analyst Resume Sample
Work Experience
• Advising business units and Corporate Support areas
• Auditing business units
• Coordinating across first, second and third line
• Monitoring business units
• Prescribing risk and compliance actions for business units
Professional Skills
• Strong PC skills including Excel, PowerPoi...
• Strong documentation skills, with the abil...
• Excellent communication skills with demons...
Assistant Analyst Resume Sample
Work Experience
• Responsible to publish all the reports (scheduled & ad-hoc) in time with quality
• Responsible to acknowledge customer related queries/request to his/her respective activity with consultation of TL and SME
• Work as per work allocation (Transactional / Non-Transactional a...
Professional Skills
• Strong interpersonal skills with ability t...
• Excellent knowledge of spreadsheets, datab...
• Excellent Communication/Presentation skill...
Policy Analyst Resume Sample
Work Experience
• The OCC, an independent bureau of the U.S. Department of the Treasury, acts as the Bank's primary regulator
• The Consumer Financial Protection Bureau (“CFPB”) conducts reviews and examinations of the Bank’s activities that are within the scope of various consumer protection laws; and
&nb...
Professional Skills
• Strong organizational and critical thinkin...
• Outstanding written communication and edit...
• Demonstrate proven writing skills for poli...
Analyst, Capital Resume Sample
Work Experience
• Consolidating and executing aggregation process for CCAR
• Following up with stakeholders to ensure timely delivery of inputs for CCAR process
• Supporting external reporting (FR Y14A/Q/M)
• BU/portfolio level, board, and FR reporting
• ...
Professional Skills
• Adaptability - Exhibits the capacity to su...
• At least one (1) to three (3) years of pri...
• Analytical and proactive problem-solving s...
Analyst, AML Resume Sample
Work Experience
• Uses analysis and internal peer reviews to identify significant trends requiring further investigation, root causes; predicts potential impact; improves the quality and consistency of SARs reported to the U.S. Government; and provides reporting to various levels of senior management, monitoring teams and other Compliance...
Professional Skills
• Have excellent interpersonal skills and ab...
• Supervise others’ work (in particular, rev...
• Strong communication skills: oral and written
Analytics Manager / Senior Analytics Manager Resume Sample
Work Experience
• Lead a global team of analysts to integrate market data, spend analytics and quantitative modeling into a cohesive package, which meets the analytical needs of procurement by providing insights that empowers better business decision making
• Collaborate with the Shared Service Centers to get the an...
Professional Skills
• Excellent communication skills and executi...
• Strong Skills- Microsoft Excel, Access, Po...
• Demonstrated experience managing a high pe...