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