Customer Service Data

MICHAEL ALEXANDER

FILEMAKER DATABASE DEVELOPER/BUSINESS INTELLIGENCE SYSTEMS ANALYST/WAREHOUSE & DISTRIBUTION ANALYST

Specializing in Business Intelligence Reporting and Warehouse Operations

EXPERIENCE

2016+ Freelance FileMaker Developer / Business Intelligence Consultant

FileMaker Developer

oAssisting companies and individuals in database design and layouts.

oTraining in FileMaker development including layouts, designs and calculations.

Business Intelligence Consultant

oAssisting companies in the use of Business Intelligence platforms and best fit visual displays and dash-boards.

oIdentifying best fit database solutions set forth by data requirements.

oAssisting in Integrated Development Environment (IDE) solutions.

oIdentification of business related KPI’s and KPM’s to best fit areas of concern.

2014-2016 Ashley Furniture Industries Arcadia, WI

Business Intelligence Systems Analyst

oAssisted DBA's in creating OLAP and ROLAP cubes based on business needs using Kimball methodology.

Requirements set forth by the business as outlined in the BRD/FRD that would be created with the business.

oProject Manager of numerous projects simultaneously.

oDesigned and created OLAP cube specifications as scoped out by business.

To include drafted ad-hock reports from original data source and created in SSMS or SSRS to verify data contained in OLAP/ROLAP cubes, assisted in SSIS/SSAS/ETL.

oWorked with business entities to best-fit Business Intelligence reporting needs to analysis needed.

Preferred by business, Excel was selected as the front-end program, but some other tools such as Performance Point (SharePoint) or Tableau were used.

oCreated Dashboards for Financial Reporting.

Reports utilized by financial analysts as well as Customer Service sections such as Returns and Allowances or Customer Service.

oTrained class of 30 students on basic Excel to advanced Excel using MDX cube calculations and Power Pivot (DAX).

oCreated Shewhart Control charts (3-Sigma) in various BI tools.

In many cases, these charts with the upper and lower control limits would have to be calculated into the selected BI tool for use.

oAnalysis of BI tools to find best fit for projects (to include working with BI companies to determine best cost effective system).

Utilization of BI SIG meetings (Business Intelligence Special Interest Groups) or hands on testing.

oITIL trained with Service Now usage.

oSystems used: Excel, Tableau, Report Builder (SSRS), VS SSAS/SSIS (Basic ETL), Performance Point, Power Pivot, Power Query, Power Map, Visual Studio, Sequel Server Management Studio, HighJump, R (Basic)/MDX/DAX/SQL.

2010-2014 Ashley Furniture Industries Arcadia WI

Warehouse Administrator

oAnalysis of product life cycles in Warehouse and usage (Supply Chain analysis).

oWorked with management to create dashboards.

Interactive dashboards in various Business Intelligence tools, mainly SSRS type reports in Excel using OLAP cubes as a data source (MDX/DAX/Cube Formulas).

oCreated reports to monitor Key Performance Measures and Key Performance Indicators.

KPM's and KPI's were monitored thru SharePoint and Excel.

oSet up large video wall with 4 monitors to display Sigma charts to employees using MATROX technology.

Six and Three Sigma charts as well as Excel bar charts and pie charts.

oReduced Shipping and Receiving damages by 75% thru data analysis.

oReduced Shipping and Receiving errors by 90%.

oIncreased performance by 20%.

oReduced Transfer errors by 90%.

oReduced Inventory data entry errors by 50%.

oTraveled off site performing individual training for Warehouse staff in Excel and other BI tools.

This training was on a one on one basis and was scheduled by warehouse Sr. management.

oDesigned and created Share Point site for Management including the addition of Performance Point and Excel.

oMonitored Intermodal activities of product.

Included the arrival of product from port to facility and from inner US site to inner US site via semi or train.

oMonitored Credits, Returns and Allowances with use of self-developed analysis reports in Excel.

To include the analysis of the employees who were at fault for the credit/return or allowance and would track occurrences for that employee to determine if disciplinary action were required.

oCreated File Maker database to record and track employee Health and Safety occurrences (HRMS).

oCreated reports from HighJump extracts (Supply Chain).

oAssisted in management decisions regarding efficiency and proficiency.

oSystems used: Excel, Power Point, Power Pivot, Performance Point, Share Point, Report Builder.

2006-2010 Ashley Furniture Industries Orlando, FL

Inventory Supervisor/Data Analyst

oElectronically monitored inventory for entry errors and/or data discrepancies.

oPerformed scheduled cycle counts to ensure inventory accuracy.

Brought inventory accuracy from 60% starting year to 100% accuracy by end of one-year period.

oExposed large theft operation within facility that caused over a six-digit figure in lost inventory annually.

oReduced Warehouse damages by 70%.

oReduced Receiving error entries by 80%.

oReduced Shipping errors by 70%.

oCreated new warehouse layout for inventory that improved efficiency and performance.

Use of availability and usage to create ABC demand routes.

oMonitored two off site facilities electronically for discrepancies and data errors.

oManaged the selling of product to store customers directly thru the consumer or thru customer service department.

oManaged the selling of product to employees and vendors.

Selling of discontinued items to employees.

Selling of damaged or discontinued items to vendors.

oCreated dashboards and reports for upper management.

oCreation of KPI's and KPM's.

Creation of usage reports and customer sales reports.

Financial Reports.

oData analysis and data mining to expose order entries and/or data entries.

1995-2005 ODL Zeeland, MI

Product Planner/Material handler/Purchaser/Scheduler

oLine Supervisor.

Monitored line of twenty employees.

Set up special orders per customer orders.

Ensured proper BOM's used.

Performed quality checks on materials and chemicals used.

oSpecial Order Specialist.

Set up special orders for customers following BOM supplied by orders.

Packaging and shipping of special orders.

oDie Tech.

Set up injection molding die's to follow customer orders.

oPurchaser/Buyer.

Maintained purchasing of materials (and PPE’s) used within the department.

Purchased raw materials used by company to produce quality products thru various vendors.

Maintained and scheduled raw material shipments (internal and outsourced) for production runs.

oPlanner/Scheduler.

Scheduled production runs on thirteen lines in accordance to proper MRP guidelines.

Reduced on hand inventory while still meeting customer needs.

Created production runs based on customer orders and specifications.

Maintained outsourced production to third parties.

Ordered raw material to be sent.

Set up shipping of tools and dies used for production run.

Scheduled movement of materials and tools used via third party carriers.

Set up shipping of materials to be used.

Set up orders to by run.

Set up of shipping completed orders to companies to fulfill orders.

oFileMaker Developer.

Created FileMaker Pro program to assist in the identification of glass patterns.

Created FileMaker Pro program to assist in the scheduling of production runs to best utilize machine efficiency.

oWarehouse Layout.

Assisted in the inventory layout of new facility to best utilize performance.

Assisted in layout of production lines to best utilize space and operations.

1991-1994 U.S. ARMY US and abroad

U.S. Special Forces Group (Airborne) 1st of the 5th - Alpha Co.

Fort Campbell, KY

EDUCATION

1996-1998 Davenport University Holland, MI

Associates Degree in Science specializing in Business Management.

CERTIFICATES

August 3rd, 2010: Mindsharp Summits for SharePoint 2010 Power End User (Beta) - Mindsharp

November 21st, 2016: Interprofessional Healthcare Informatics – University of Minnesota

Currently Active: Data Science – John Hopkins University

oThe Data Scientist Tool Box – Nov. 3rd 2016

oR Programming – Currently Active

Currently Active: Data Warehousing for Business Intelligence – University of Colorado

oDatabase Management Essentials – Dec. 14th 2016

oData Warehouse Concepts, Design and Data Integration – Currently Active

Currently Active: Algorithms – Stanford University

Currently Active: Data Visualization with Tableau – University of Colorado (Davis)

oFundamentals of Visualization with Tableau – Dec 16th 2016

oEssential Design Principles for Tableau – April 1st 2017

Currently Active: Microsoft Professional Program Certificate in Data Science

oData Science Orientation – Jan 1st 2017

oAnalyzing and Visualizing Data with Excel – Jan 27th 2017

oQuerying with Transact-SQL – Feb. 8th 2017

oStatistical Thinking for Data Science and Analytics – Currently Active

NOTES

I specialize in creating Excel Dashboards using MDX and DAX. With the use of Power Pivot, I have found that most any database can be created and maintained fairly easily with a highly dynamic, user-friendly interface. My belief is that it is to easy to make something complicated and all to commonplace to do so, but to make something easy and user friendly is creativity and a must in operations. With knowledge in both Warehouse Management and IT, I have found it relatively easy to work with the business on business matters and produce dashboards and reports that can assist greatly in business decisions. Whilst I know how to conjure the entire BI line, I find that working with the business in data visualization is my most comfortable area.

E-MAIL *******************@*****.***

HTTPS://WWW.LINKEDIN.COM/IN/MICHAEL-ALEXANDER

VILLE PLATTE, LA, 70586 • PHONE 1-337-***-****

Contact this candidate