Mike Mccord Email & Phone Number

• Design, develop, and maintain user-friendly data visualizations and dashboards using complex datasets from different sources.• Work and consult with sister companies to help develop Power Bi solutions that fit their specific business needs.• Implement best practices to ensure dashboard design consistency for the best user experience.• Visualize and develop BI solutions (Dashboards, Scorecards, Analytic reports, Power Bi reports) to show opportunities for revenue growth based on insurance data.• Ensure minimum downtime and maximum data hygiene by establishing alignment with IT and other allied functions.• Design and deliver end-user training and training materials for top management as well as operational teams; providing technical support as necessary.

• Develop operational Power Bi reports, dashboards, paginated reports and applications.• Help Understand business requirements to set functional specifications for reporting applications.• Help design and implement best practices for Power Bi development• Have experienced in tools and systems on MS SQL Server BI Stack, such as TSQL, Power Query, PowerBI, and DAX• Be able to quickly shape data into reporting and analytics solutions• Create functional reporting• Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more

Farmington Hills, Michigan, United States

• Craft and develop reports and dashboards using various BI platforms for various organizational metrics and indicators using best practices and industry standards.• Translate business requirements into high performance visualization that meets strategic and tactical business requirements.• Perform sampling of data to understand the character/quality of the data, and device processes to improve data quality.• Deliver training and mentorship to business partners focused on data analysis methodology reporting and tools.

• Translate business unit requirements into clear, accurate and concise functional requirements. Create models, specifications, diagrams and charts to be used by the Data Insight & Analytics team in developing BI and Data Warehouse solutions.• Collaborate with the Data Insight & Analytics team and other IT resources throughout the development lifecycle; enforcing and redefining requirements where necessary.• Investigate and troubleshoot problems. Collaborate with business units to determine root cause and appropriate functional solutions. Interact with the Data Insight & Analytics development team in the implementation of the solution and communicating with business units as required.• Design, build, and code operational and financial dashboards and visualizations to support ongoing improvement of business operations and strategy.• Work with a team of financial analysts to conduct data validation and verification for KPI reporting to ensure data and data access integrity.• Additional responsibilities as identified.

• Extracting data from source systems, compiling & aggregating source data in a centralized location, & loading cleaned data into existing databases to be used in existing recurring reports.• Ad hoc reporting & analysis as required by senior management including preparing recommendations & presenting findings.• Function as a Business Analyst. Liaise with department heads to review analysis results & find ways to improve performance & efficiency.• Work with management to develop additional core reports.• Learning new analytics tools, methods, etc.• Distributing reports to stakeholders & reviewing results with them.• Work with the Director of Brite Financial on an ongoing basis to maintain and strengthen our lease originations risk scoring models• Experienced data analyst working in subprime lending.• Compile important data to find trends in customer payments to determine likeliness of defaulting.• Create visual reports using DAX coding and Microsoft BI in order to analysis data.• Create views in SSMS and manage data using SQL querying• Present these reports to the CEO, CFO and COO on a weekly basis.

Ann Arbor

-Work with a team of doctors and engineers to help design medical devices.-Review project proposals and helped decide which start-up companies would get federal grants to support their product.-Collect and interpolate data on certain project proposals and devices.-Excel was mainly used with some SAS experience.-Major project is to help design, test, and collect data on a medical device that measured susceptibility to strokes in older patients. -Minor projects include creating and presenting slides shows and data on project proposals that would most impact on pediatric healthcare.

Dale Carnegie Course Completion, Complete

Actuarial Science, Mathematics

Activities and Societies: Sigma Chi Fraternity and Actuarial Science Club