Sales Data Analyst
Resume:
JIM SOLCHENBERGER
*********@*****.***
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