Image of Mark Assoc.

Mark Assoc.

Financial Analyst @ Grainger

Cloud Consultant at 2nd Watch

Chicago, Illinois

Ranked #296 out of 5,918 for Financial Analyst in Illinois

Section title

Mark Assoc.'s Email Addresses & Phone Numbers

Mark Assoc.'s Work Experience

Grainger

Financial Analyst

July 2015 to Present

Discover Financial Services

Risk Analyst - DATA INTELLIGENCE AND INFORMATION DESIGNER,

August 2014 to Present

MJSchukas & Assoc

Director/Analyst/Developer/Statistician

January 1996 to Present

Greater Chicago Area

Mark Assoc.'s Education

Northeastern Illinois University

Masters of Arts Mathematics & Statistics

MBI

Bachelors of Arts Education

Mark Assoc.'s Professional Skills Radar Chart

Based on our findings, Mark Assoc. is ...

Inspiring
Realistic
Analytical

What's on Mark Assoc.'s mind?

Based on our findings, Mark Assoc. is ...

56% Left Brained
44% Right Brained

Mark Assoc.'s Estimated Salary Range

About Mark Assoc.'s Current Company

Grainger

...in the Finance Dept. for data analysis and visualization of SAP data via Teradata using: Tableau 9.0 with RRO (Revolution R Open) 3.2, Teradata SQL Assistant 15.0, Notepad++ 6.7, RExcel 3.2, etc.

Frequently Asked Questions about Mark Assoc.

What company does Mark Assoc. work for?

Mark Assoc. works for Grainger


What is Mark Assoc.'s role at Grainger?

Mark Assoc. is Financial Analyst


What is Mark Assoc.'s personal email address?

Mark Assoc.'s personal email address is ma****[email protected]


What is Mark Assoc.'s business email address?

Mark Assoc.'s business email address is m****[email protected]


What is Mark Assoc.'s Phone Number?

Mark Assoc.'s phone (217) ***-*378


What industry does Mark Assoc. work in?

Mark Assoc. works in the Machinery industry.


Who are Mark Assoc.'s colleagues?

Mark Assoc.'s colleagues are Mark Lee, Alex Krutik, Parks, Josh, Shawn Simmons, Stephen Zhang, Patrick Mazzariol, Carlos Queirós, Romain CATHERIN, Shaun Carlson, and Tom Kareus


About Mark Assoc.

📖 Summary

Data Analytics & Visualization / Microsoft Small Business Partner offering: • BI (Business Intelligence)/Probabilistic Modeling/Development and Analysis --Statistical/Visual analysis: Tableau 9.0 with R 3.2, Excel Stat (RExcel/NAG algorithms.), SPSS, SAS 9.3 Base/Stat --ERP - data storage and retrieval include: SAP, Teradata Assistant 15.0, SQL Server via SharePoint 365 (with connection to Office 365) --Probabilistic Modeling with predictive analytics: Excel Modeling, Palisade Decision Tools (@Risk) --Optimization: Excel’s Solver, LINDO Systems What’sBest • Marketing Business Risk --Processes flow and methology --Technology support and development • RAD (rapid application development)/Agile for the EUC (end user computing) specializing in the MS Office Apps. --VBA customization for Excel, Access, Word, Outlook, etc.(including Visual Studio 2010) --Tableau 8.2.2 (Alteryx) data visualization --SharePoint 365/2010 integration (database connection, forms, workflows, etc.) --Databases Support: MS Access Front End with legacy connections-Teradata, SQL Server, Oracle, SAP (Lendavo), PeopleSoft, FoxPro with data architecture and SQL queries --MS Office: 365/2010 (conversation path for Windows and Mac) • IS / Data analysis --liaison communication with upper management --strong mathematics background: Mathematica, Maple --a variety of associate specialists • Training / Support / Follow-Through twenty plus years of teaching, software application development and management consulting experience, training and support for all custom application development and MS Office applications including: --Documentation --Presentations --Help desk follow-up --Individual one on one support including customization and optimization --Software upgradesFinancial Analyst @ ...in the Finance Dept. for data analysis and visualization of SAP data via Teradata using: Tableau 9.0 with RRO (Revolution R Open) 3.2, Teradata SQL Assistant 15.0, Notepad++ 6.7, RExcel 3.2, etc. From July 2015 to Present (6 months) Risk Analyst - DATA INTELLIGENCE AND INFORMATION DESIGNER, @ Reliably managing risk…developing data discovery-fast analytics and visualization-in a social, mobile and analytical environment under the guidance of: Gramm–Leach–Bliley Act , Sarbanes-Oxley Act , FTC fraud guidelines, internal regulations, etc. including: -gathering Issues and Actions/Controls information and analyzing results against the company's risk management policies and the enterprise-wide risk management framework. -designing, implementing and maintaining an effective and appropriate enterprise wide risk management program, -providing information to Company's management for assessing and managing Company's operational risks. -BI - developing logistic regression, cluster analysis, predictive models and other segmentation models, but they certainly appreciate your uncanny ability to utilize those to lower their marketing costs and improve marketing effectiveness. Or perhaps they rely on you to provide analytics that stimulate sales, strengthen customer loyalty and generate purchases. IN GENERAL “...offering assistance for profitable use of…” Marketing Risk Business Department's information and effort to reliably manage risk with: Process and Control development and maintenance, data storage, data visualization, and descriptive and predictive analysis. Including: DEVELOPMENT PROCESS Following the Lean Transformation Model "Make things better through lean thinking and practice" with software development adhering to the principles of RAD (Rapid Application Development), RUP (Rational Unified Process), Six Sigma measure of quality, Agile principles for the EUC (end user community). SOFTWARE USED/SUPPORTED TABLEAU 8.2.2 with R 2.15.2 for: · MS Office 365/2010 SHAREPOINT 365/2010 From August 2014 to Present (1 year 5 months) Director/Analyst/Developer/Statistician @ “...providing assistance for profitable use of information.” From January 1996 to Present (20 years) Greater Chicago AreaAnalyst and Developer @ Supporting the workings of and developing additional features for user app: Portfolio Asset and Management Fees with MS Office 2010 (Excel and PowerPoint with a SharePoint 2010 Front End for users-approximately 100 nationwide). From August 2013 to August 2014 (1 year 1 month) Analyst @ full time and project based: Bosch Rexroth is one of the world’s leading specialists in the field of drive and control technologies. Under the brand name of Rexroth the company supplies more than 500,000 customers with tailored solutions for driving, controlling and moving. As The Drive & Control Company, Bosch Rexroth develops, produces and sells components and systems in more than 80 countries in the technology fields Electric Drives and Controls, Industrial Hydraulics, Mobile Hydraulics , Linear Technology, Assembly Technology and Pneumatics Project’s purpose: With a SAP backend, updating all Office Apps (Excel, Access) from 2003 to 2007 including stronger integration with SAP for the “last mile” (SAP to user) including: automation, data manipulation, database and query optimization and analytics. Multiple projects included: Distributor Pricing Info., CRM for Sales and Repairs Info., Supply Chain Management and Forecasting, Sales Information capturing, Sales SPA’s (special pricing adjustments), etc. Skills include: VBA code upgrade and optimization with SAP integration. . Database development with Access, Excel and SharePoint Designer with SharePoint 2007. From January 2013 to September 2013 (9 months) EUC Developer @ April to August 2012 and April to July 2013 …a quick update of my present project (Developer Lead / Analyst) at MillerCoors Revenue Management/Pricing includes (full time and project based): Office 2010-Access (schema development, import legacy data, VBA query design, customized moduls for automation). Excel (PT with BI and charts, customized functions for pricing details, customized routines with User Forms and VBA modules for automating tasks), using Word (documentation) and PowerPoint for training shared with development team and users via SharePoint. PROJECT OVERVIEW Development of IPM (Price Management Project- revenue management)-integrated billing pricing strategy to manage and execute frontline pricing of products to distributors-“delivering a single process and system to manage and approve field and corporate pricing decisions for the product portfolio… • Office 2010 with SharePoint Workspace 2010 • Connection to company data warehouses including SAP’s Vendavo enterprise price management/optimization system • Created and maintained a local data cube (Access) for connection to Planning Master Data • Creation of an Excel Master Planning file with the following modules: Planning, Execution, Communications, Reporting, Analysis (with BI PowerPivot) • Distribution to the USA market via SharePoint DEVELOPMENT VBA Programming for development and customization of the Microsoft Office Project desktop client applications (i.e., Excel, Access, Outlook, SharePoint, etc.) including: • Programming and automation • Data integration and enrichment • Data mining with customized reporting From April 2012 to August 2013 (1 year 5 months) Greater Chicago AreaReport Analyst/Developer (project based) Goverance Operations @ August to September 2012 Skills include: Office 2007 in a Windows 7 OS with Oracle 11g as the backend legacy data using b-Tree data structure indexes combined with survey data in PDF -- Access DBS work included: schema development, import legacy data, VBA automation, query design, customized modules for automation. VBA workings include: import PDF survey data files into Excel, run all Access temporary table creation queries under “one button” reference user import stored in tables (maintenance), user parameter driven queries for reporting (e.g., committee, chair, time, member information, etc.) Project’s purpose: …to monitor and report on “Conflict of Interest” for all committee members including: • Import returned PDF survey data through conversion to Excel and importing (VBA) into Access tables (normalizing) automation (one button) • Link to Oracle Member and Committee information • Architect schema in DBS to have: lookups, edits and reporting • Develop user forms and reports including “one button” automation of: import of survey data, searching for members and relative information and required reports From April 2012 to May 2013 (1 year 2 months) Developer / Analyst @ Project’s purpose: Using a rapid application development environment with a FASMI (Fast Analysis of Shared Multidimensional Information) philosophy to model business scenarios, including the ability to allow users to securely "write back" to the application's data repository (cube). Thus allowing features such as: sales planning, forecasting, modeling, and "what if" type analysis. Skills include Support and development for users in global Product Sales that included: planning (base, innovation, incremental, ) with Excel 2003/2007 and Oracle’s Essbase 11.1.2.2 with VBA functions: retrieves (EssVRetrieve ) and saves (EssVSendData and EsbCalc). Additional programming: Customizing Excel functionality including the Essbase Spreadsheet Toolkit to call VB functions in the API libraries via VBA. . Additional user support includes: offering users Smart View app for Office (Excel, PowerPoint, Word, and Outlook) collecting, managing, processing, and presenting multidimensional data for analysis and management. Supporting migration of sales support to IBM’s Cognos TM1-enterprise planning software for entire planning cycle, from target setting and budget rollout to reporting, analysis and reforecasting including: analyze data, model business requirements and collaborate on plans, budgets and forecasts to uncover hidden business options and optimize performance. From October 2012 to January 2013 (4 months) QC Analyst - App. Dev. Department @ Project’s purpose: Creating test scripts in Excel for a QC Expected Results tool to validate Oracle’s Insurance Insbridge Rating and Underwriting (11 g Release 2) engine (“an enterprise solution for product management, premium calculation & underwriting rules management…single point of rating truth…to meet regulatory requirements”) Skills include: Office 2003/2007 in a Windows XP/7 OS with XML data feeds from Oracle 11g Rel. 2 and a legacy system (TAP) into Excel (strong use of logical and lookup and reference functions) using SharePoint as a storage and collaboration for the team. VBA workings include: support QC xls with: alphabetize worksheets and create hyperlink TOC, XML import (Workbooks.OpenXML method), “go back to last tab”, ADODB.Connection with sql statement for querying other workbooks, Application.functions (vlookup-lookup and reference functions), etc. From August 2012 to October 2012 (3 months) Greater Chicago AreaDeveloper / Analyst @ • McDonald’s is considered one of the premier global training organizations • Developed MS Office interface for users to retrieve, operate and analyze training course information including: courses, offerings, locations, instructors, enrollment, evaluations, accounting, etc. Mindjet Manager 2012 was used for planning and diagrams. • VBA/DBS work included: database design and development with Access (schema design, modules and class modules development), imports from Web Applications (SurveyMonkey and Opinio), Business Intelligence; creation of data cubes for evaluation/”slicing and dicing” with OLAP pivot tables via Excel, mail merge for name badges, table tents, etc. with Word, module for emailing individual or class via Outlook, creating and implementing surveys via Outlook (“Use Voting Buttons”) and Access (“Collect data through email message”), etc. • An introduction to Alyterx: offering “business intelligence (BI) smart and extensible software applications” – analytics solutions for Data Artisans including geospatial and statistical modules. • Analysis included: Likert scale evaluations with: Descriptive Statistics, Five Number Summary, charting of frequency distributions, Chi Square calculation to test goodness of fit distribution and test for independence amongst survey questions (with an optional WILCOXON TEST for t values and a MANN WHITNEY TEST for a nonparametric alternative). • Coordination with IT department for legacy data integration (e.g., employee information). From November 2011 to May 2012 (7 months) Developer / Analyst @ “Chicago's premier social service agency serving adolescents, young adults and their families” • Maintain and continued development (schema extension, additional queries and reports) for a MS Access database used for weekly staff and client progress statistics. • Training for Database users. • Designed and created a remote electronic data collection form (to be filled in by staff off-site in a customized Excel form and transmitted to the shared network drive and programmatically uploaded to the master DBS). From 2009 to 2012 (3 years) Greater Chicago AreaDeveloper / Analyst @ "Your Complete Source of Authentic Mexican Foods” (project based and ongoing support) • Windows Development and Support & Training for all users (24 HQ and 12 offsite). • Developed MS Office interface for users to retrieve and analyze department information with legacy data (UNIX with a custom built BBX accounting system). • Developed plan-o-gram management analysis and recommendations application for Anglo Hispanic category management for Dominick’s Finer Foods. • Created and supporting a mobile salesman ordering application that includes a CRM (customer relationship management system in MS Access DBS with internet access for traffic, weather, mapping, etc. information) connected to MS Excel (via MS Query and VBA ADO) front-end bid application connected with MS Outlook for email communication in a MS Exchange Server 2008 network environment. • Developed and implemented web site redesign. • Assisted in upgrade to MS Small Business 2003 Server and implementation of users on the network with MS Office 2003/2007/2010. • Training for all PC Platform Applications. • Developed an interface for monthly product movement updates from largest distributor. From 1996 to 2012 (16 years) Developer / Analyst @ “The world’s leading producer of chemical grade phosphates.” (project based and ongoing support) Sr. Developer/ Analyst/DBA/(project based and ongoing support) • Support and Develop MS Office interface for users to retrieve and analyze legacy data (Oracle Database with SAP applications, etc.- including: ETQ, webLIMS, PQ Systems, SQCpack – process control software, Prisim, ETQ – document control software, etc.) in a Six Sigma enviorment. • Training for PC Platform Applications including Excel and Access. • Ongoing support for PC Platform Applications and databases. • Supported SAP company-wide upgrade connection to users desktops for MS Office • Working with outside consultants and association standards such as: IPEC (International Pharmaceutical Excipients Council), Six Sigma, Lean) From 1998 to 2011 (13 years) Greater Chicago Areadirector @ From 1991 to 2000 (9 years) Masters of Arts, Mathematics & Statistics @ Northeastern Illinois UniversityBachelors of Arts, Education @ MBI


Mark Assoc.’s Personal Email Address, Business Email, and Phone Number

are curated by ContactOut on this page.

10x your recruitment & sales conversations

Contact over 200M professionals
instantly by email or phone. Reveal
personal & work email addresses, as
well as phone numbers accurately with
our ContactOut Chrome extension.

In a nutshell

Mark Assoc.'s Personality Type

Introversion (I), Intuition (N), Thinking (T), Judging (J)

Average Tenure

4 year(s), 10 month(s)

Mark Assoc.'s Willingness to Change Jobs

Unlikely

Likely

Open to opportunity?

There's 85% chance that Mark Assoc. is seeking for new opportunities

Engage candidates 10x faster

Enjoy unlimited access and discover candidates outside of LinkedIn

Trusted by 400K users from

76% of Fortune 500 companies

Microsoft Nestle PWC JP Morgan Merck Rackspace WarnerMedia Randstad Yelp Google

The most accurate data ever

CCPA Compliant
GDPA Aligned
150M Personal Emails
300M Work Emails
50M Direct Dials
200M Professional Profiles
30M Company Profiles

Hire Anyone, Anywhere
with ContactOut today

Making remote or global hires? We can help.

  • 50 contacts/month
  • Works on standard LinkedIn only
  • Work emails, personal emails, mobile numbers
* 1 user per company limit

No credit card required

Try ContactOut for Free