JIM SOLCHENBERGER

acpmey@r.postjobfree.com

408-***-****

Cupertino, CA

QUALIFICATIONS

* ***** ** ************ ********** as a business data and project analyst

Excellent communication, analytical, problem-solving, multi-tasking, and organizational skills

Ability to work with cross-functional teams, both internally and externally

Super-user Microsoft Office package (Excel, Word, PowerPoint)

ADDITIONAL SKILLS

Capable of handling multiple projects at one time, while meeting deadlines to help the company meet their goals. Understanding of SQL basics, and

a quick learner, this will be put to use learning any internal or external tools to ensure successful transition into any position.

EDUCATION

Bachelor’s Degree – San Jose State University 2008

PROFESSIONAL EXPERIENCE

Picaboo Inc., Redwood City, CA

Data Analyst – September 2012 – January 2015

Created and maintained pivot tables, charts, and reports tracking expected revenue, bookings, and agreements

Built Excel databases from signed agreements, and created pivot charts and graphs from data to show expected growth

Manipulated raw data on a daily basis, to show day-to-day growth, as well as year-over-year growth in sales

Created dashboard views for weekly dispersal, based on signed agreements, expected delivery, and other requested views

Manage all dealer territories within Excel

Processed all commission reports within Excel, leveraging several workbooks that I created for tracking purposes

Responsible for being liaison between customer support and partners

Created multiple reports within Excel for weekly distribution to upper management

Worked to automate commission reporting with development team, implementing multiple improvements to system

Learned SQL for data pulls, data manipulation, and updates

Created and maintained pivot tables and charts for weekly dispersal

Distribute all leads based on projects started and dealer table

Cisco Systems, San Jose, CA (Trianz Inc.)

Data Analyst - November 2010 to June 2012

Leveraged vlookups within Excel to track new and existing customers

Created multiple workbooks with concatenation formulas, and de-duping formulas to ease the processing time of co-workers

Create Microsoft Excel macros to expedite and simplify processing of multiple orders within the sales crediting engine

Maintain sales crediting rules within the sales crediting engine for all of Europe and global Inside Sales

Perform research pertaining to missing credits, and provide analysis to business partners in a timely fashion

Handle any escalations pertaining to missed crediting and provide feedback to business partners

Lead weekly calls with stakeholders, allowing for clear communication of timelines and solutions

Manage sales crediting cases using SalesForce.com for case management

Implemented processes to follow for completion of sales credit requests

Responsible for year to year changes within the sales crediting engine, ensuring timely completion of new year set-up for day 1 crediting

Cisco Systems, San Jose, CA (Trianz Inc.)

Data Analyst - December 2008 to November 2010

Create Microsoft Excel macros to simplify the set-up of Point of Sales reports for distribution

Handle all issues regarding Point of Sales reports to resolution from partners, and communicate with all parties regarding the issues and

steps to resolve.

Receive and process Point of Sales reports from multiple partners, ensuring that correct pricing discounts are leveraged for each partner

by using vlookups across multiple price sheets

Responsible for providing correct Point of Sales reports to the appropriate operations departments worldwide

In charge of updating price lists as new products became available for purchase

Update price lists as new partner discounts become available

Manage sales crediting databases for use by worldwide audiences

Manage distribution of worldwide sales crediting funds in Oracle Financials

Contact this candidate