Robert Rose
Excel Pivot Charts, Power BI
Data Analyst
AGILE, ISO9001, ITIL,
KPI Dashboards
Michigan (ready to relocate)
*************@*****.***
Other Information
Data Analyst Skills
oExcel
Pivot, Advanced Forumulas, VBA
oAlteryx
Work flows, macros, ETL
Practices
oService Request Management Process
ITIL
oQuality Assurance
ISO9001
oProblem Solving
oCredible
Hardware and Software Skills
oNetwork Troubleshooting
Shell commands, scripts, WireShark
oMicrosoft
SQL
C++
VB and VBA
oTest Automation AutoIT, Selenium, HP QTP/UTF
Certifications
ITIL Foundations, HIPPA, MRW, CompTIA ITF+, CompTIA A+, Alteryx
EDUCATION
Cass Tech High School HVAC
Macomb Community College
Oakland University
Rochester Hills, MI – 2011
Bachelor of Integrative Studies with minor in MIS
SUMMARY
Supported Customers resolving incidents within SLA and proactively monitoring databases, logs, and enterprise tools for data patterns then raising awareness of findings.
PROFESSIONAL EXPERIENCE
COVID Retirement
Dec 2021 to Present
Ford via Epitec
Oct 2014 To Nov 2021
Data Analyst
Having read only access to hundreds of design engineer Bill of Material Excel files
oUsed tab data to understand part cost and clarify business patterns in the electric car industry.
oUsed tab data to understand part volume and clarify business trends in the electric car industry.
oAnalyzed data through Alteryx macros and VBA to refresh standard pivot trend charts, pareto charts, Venn Diagrams to communicate findings to management while promoting best practices
oCreated work flows and VBA to analyze data then build ad hoc reports collaborating with cross-functional global teams
Prepared Standard Operating Procedure with process models, entity relationship diagrams, governance, test plans, and training documentation.
Ensured Quality per ISO 9001 and all Customer Support Policies, Standards, and Procedures by executing all checklists including peer reviews then reminded customers about secure practices.
Following ISO9001, ITIL, PmBoK, and AGILE practices I attend weekly meetings with Program Manager, Database Programmers, and Program Analysts to discuss data issues, change management, and deadlines.
Managed Credentials for enterprise tools