Resume

Sign in

Sales Microsoft Office

Location:
Yorktown Heights, New York, 10598, United States
Posted:
February 13, 2018

Contact this candidate

M: 914-***-****

E: ac4gor@r.postjobfree.com

https://www.linkedin.com/in/fernando-soto/

Fernando Soto

Profile

SENIOR ANALYST & INFORMATION TECHNOLOGY EXPERT

Analytics Training Project Management

Data Analytics expert with extensive experience developing, launching and monitoring sales analytics and workflow tools as well as databases to strengthen productivity and efficiency with significant impact to the business bottom line. Problem-solver with exceptional ability to manage and train across levels, functions and cultures. Astute at change management, readily able to incorporate new approaches, requirements, and features; as a result, gained rapid advancement across functions and specialized knowledge bases. Fluent in Spanish.

Professional Accomplishments

SIEMENS HEALTHINEERS, Tarrytown, NY 2011–2017

Marketing Specialist (2015-2017)

Provided comprehensive sales analytics and reporting for the entire continental US, 500+ reps over three units: Central Lab Automation Specialist (CLAS), Chemistry Cardiac Specialist (CCS) and the Technical Application Organization (TAO)

Developed and distributed Sales & Opportunity reports monthly to US Marketing and Sr. Executives supporting crucial business objectives

In first quarter, developed and administered Compensation Tool utilized by the CLAS and CCS groups for commission payout submissions increasing efficiency and employee satisfaction.

Optimized Instrument Workflow Tool for Senior management and Sales Marketing and TAO Dashboard, streamlining project management.

Developed MS Access request form for the Scientific and Clinical Affairs (SCA) team

Automated the IWT Capital Tracker report to track pending instruments and instruments shipped/closed.

Designed Excel spreadsheet to split master Reagents and Consumable data file by Zone and Region for distribution.

IT Business Analyst (2014-2015)

Responsible for the performance and integrity of the IBM Cognos ICM (Varicent) database, including planning, development, reporting, and troubleshooting

Monthly processing such as data uploads, file setups, transaction review, compensation plan component setup with Varicent, maintaining master tables

Identified, documented, and resolved system defects

Created and supported commissions related reporting

Provided IT support within the department

Compensation Senior Analyst (2011-2014)

Responsible for developing, modeling and distributing annual targets to all business units domestically as well as globally. Reduced manual distribution of targets and statements by 50% thru automation.

Calculated and Distributed Quotas/Targets for All DX Sales Teams based on Finances Growth Rates

Created a Quota database for departmental use. Database is also used by Data Analytics Team

Calculated, analyzed, and prepared Incentive Compensation statements for all incentive compensation payouts, rankings, and awards for the Siemens Diagnostics USA Organization

Built several analytical reports for DX as well as the IM/CP side utilizing Tableau Software

Automated Statement delivery process thru VBA (Excel)

Streamlined Key Initiative Process for both Corporate Accounts and Zone Corporate Account Managers

THOMSON REUTERS, Valhalla, NY 1999-2011 Reports Analyst (2006-2011)

Conducted quarterly reporting training sessions for New Hire Account Managers

Designed courseware materials using Microsoft Word and PowerPoint

Created detailed weekly, monthly, quarterly and yearly operating reports using formulas, graphs, pivot tables and VBA code

Developed weekly/monthly and ad-hoc reports for senior management

Performed server backups and restoration procedures

Automated recurring reports

Compensation Review Analyst (1999-2006)

Implemented over 25 Compensation Plans for over 100 sales representatives across the continental US

Maintained Compensation Error Adjustments (CEAs) via Lotus Notes Database

Reviewed accounts payables to ensure accuracy

Tracked annual sales performance and provide a detailed comparison to previous years

Computer Skills

Fluent – Microsoft Office Suite, MS Access, Visual Basic Applications (VBA), Windows

Intermediate – Tableau, Cognos ICM, Crystal Reports, Publisher, Diver, MS Project, Siebel 7, Lotus Notes, Cisco IOS, Unison, Routers, Hubs, and Switches.

Familiar – SAP, SQL, Shell Scripts, Unix, VISIO, Salesforce.com

Education

Master of Health Administration/Master of Business Administration

University of Phoenix, AZ (2020)

Bachelor of Science Business, Information Systems;

University of Phoenix, AZ



Contact this candidate