Steve B Email & Phone Number

Created a number of reports and dashboards in Salesforce.com used to show high level summaries and corresponding details behind Horizon Sales performance and effectiveness of Marketing business strategies. Enabled the company to determine where to focus their resources to enhance productivity, increase market share, evaluate broker performance and track industry trends by various components such as SIC code and market sectors.Compiled data/reports used in sales trending analysis, new product development and customer retention for the Small Employer market using MS Access and Excel.Used MS ACCESS to create front end modules to allow users point and click functionality used in various departmental functions.Used data validation and pivot tables to create the model for aligning sales staff and giving managers the ability to perform “what-if” changes to alignments enabling them to determine impact on staff workload.Utilized macros to automate many existing manual procedures to facilitate report distribution.Automated the process of capturing enrollment projections and consolidating the data into user friendly views by using Excel/Access macros and advanced features of Excel pivot tables such as filters and slicers.Assisted with the configuration of the base Salesforce.com package to corporate specifications by designing standard/custom objects, custom reports and dashboards.Imported data into Salesforce using data cleansing techniques to map fields from various data sources and validation of expected results.

Roseland, New Jersey

Member of project team to ensure business unit's risk/control compliance in connection with Sarbanes-Oxley legislation.Coordinated the receipt, conversion and importation of risk data as submitted by business units from EXCEL spreadsheets into a web-based system for which corresponding units became responsible for monitoring and tracking these risks. This was achieved via the use of macros and VBA programming to automate the data manipulation process and eliminate redundancies.Created a status report to enable the tracking of assessments through the various milestones of completion and performed statistical analysis to ensure all submitted assessments were not bottlenecked during the process flow. Used pivot tables and filters to create reports for management review.

Data Analyst-Worked with the Sales and Marketing groups to create various data analyses and provide ad-hoc reports to managementUsed advanced EXCEL programming techniques/macros to create standardized reports from raw mainframe data. This allowed the Sales and Marketing Group to utilize key physician data while allowing the I.T. group to focus on larger range projects. Worked with various Sales and Marketing management teams to determine the best possible format and practical usage.Reduced by 80% the amount of time spent on administrative functions and data entry routines for monthly data QC. This was accomplished using EXCEL macros to automate the prior process.Wrote SQL queries to produce reports/create datasets used in the analysis of Oncology/Immunology sales data. These report enabled the company to create and implement sales promotion programs.Used a sales tracking application to drill down on new prescription data. This was done in connection with determining the root cause of negative sales changes reflected in physician ordering patterns. The results of the analysis specifically helped the company understand the impact of sales rep calls and product sample drops to obtain the maximum benefit of these and similar type product promotions.