Scott A Johnson Email & Phone Number

Grosse Pointe, Mi, Us

Troy, Michigan, United States

Work closely with IT and various development and business teams to create, deploy and support the following QlikView 11 projects: Invoiced Orders, Orders, Open Orders, Commission Dashboard, Regional Sales Dashboard, Distributor Summary Business Review Dashboard, Inventory Tracking, Product History, Key Products, Price Maintenance, Opportunity Tracker, Operating Cost and Field Sales Demo Product Tracking.Additional responsibilities include: Write QlikView scripts utilizing ODBC… Show more Work closely with IT and various development and business teams to create, deploy and support the following QlikView 11 projects: Invoiced Orders, Orders, Open Orders, Commission Dashboard, Regional Sales Dashboard, Distributor Summary Business Review Dashboard, Inventory Tracking, Product History, Key Products, Price Maintenance, Opportunity Tracker, Operating Cost and Field Sales Demo Product Tracking.Additional responsibilities include: Write QlikView scripts utilizing ODBC connections to merge data from multiple data sources including the IBM AS/400 PRMS order system, Microsoft SQL Server, Microsoft Access and Microsoft Excel Utilize Set Analysis scripting for all QlikView objects Normalize all QlikView table inputs to provide optimal performance Utilize the QlikView Management Console to schedule QlikView document updates, QVD builds and troubleshoot issues through trace and error logs Administer all North American QlikView user and document access levels Work closely with the global QlikView IT Developer team providing North American data for global QlikView documents Design, implement and administer Microsoft SQL Server 2012 Business Information database for Distributor Resales and Cost of Goods Sold data used for calculating commissions Administer the National Sales Organization commission plan for North America Provide sales information by customer, product, and salesperson for InfoLINK, Seco Tools’ customized Lotus Notes based Sales Force Automation software Publish monthly sales reports to upper management and provide quarterly information for the Board Book  Analyze key distributor channel information, economic statistics, and competitive information Forecast product sales by region based on industry and economic trends Provide business intelligence support including diagnosing and resolving complex problemsEnvironment: SQL, QlikView, InfoLINK (Lotus Notes), Access, Excel, IBM AS400, SharePoint, Power BI, PowerApps, Smartsheet Show less

Troy, Michigan, United States

Designed, implemented, and administered MS Access databases for sales force automation, and sales and competitive market analyses. Published daily, weekly, and monthly sales reports by product categories, regions, and customers Analyzed key distributor channel information, economic statistics, and competitive information Forecasted product sales by region based on industry and economic trends Provided Marketing and Finance teams with various product and customer sales… Show more Designed, implemented, and administered MS Access databases for sales force automation, and sales and competitive market analyses. Published daily, weekly, and monthly sales reports by product categories, regions, and customers Analyzed key distributor channel information, economic statistics, and competitive information Forecasted product sales by region based on industry and economic trends Provided Marketing and Finance teams with various product and customer sales reports in MS Access, Excel, and IBM AS/400 QueryEnvironment: MS Excel, Access, MS SQL, SQL Server, SQL Management Studio, Cognos, IBM AS/400 Show less

 Designed, implemented, and administered MS Access databases for sales force automation, and sales and competitive market analyses Published daily, weekly, and monthly sales reports by product categories, regions, and customers Analyzed key distributor channel information, economic statistics, and competitive information Forecasted product sales by region based on industry and economic trends Provided Marketing and Finance teams with various product and customer sales… Show more  Designed, implemented, and administered MS Access databases for sales force automation, and sales and competitive market analyses Published daily, weekly, and monthly sales reports by product categories, regions, and customers Analyzed key distributor channel information, economic statistics, and competitive information Forecasted product sales by region based on industry and economic trends Provided Marketing and Finance teams with various product and customer sales reports in MS Access, Excel, and IBM AS/400 QueryEnvironment: MS Excel, Access, MS SQL, SQL Server, SQL Management Studio, Cognos, IBM AS/400 Show less

Bachelors, Economics

Masters, Finance, Managment Information Systems