Nick Smith
Business Intelligence Manager at eSolutionsFirst- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
eSolutionsFirst
-
United States
-
Information Technology & Services
-
1 - 100 Employee
-
Business Intelligence Manager
-
Jan 2023 - Present
- Manages Data Engineers and BI Analysts responsible for the delivery of data solutions including the Azure data lake and reports in Business Objects and Power BI. - Lead demand management process with business partners and key stakeholders to determine priorities and timelines.
-
-
-
MSU Federal Credit Union
-
United States
-
Financial Services
-
500 - 600 Employee
-
Business Intelligence Manager
-
Aug 2019 - Jan 2023
East Lansing, MI - Lead BI team on Microsoft Power BI development, analytics best practices, and data training. In 2021, led implementation of Power BI to replace Tibco Spotfire. - Managed day-to-day operations of the business intelligence team including: scheduling, assignment of work, and reviewing completed reports to ensure projects are completed accurately and on time - Primary Power BI administrator that monitors gateway performance, workspace and pipeline deployment, and data refresh… Show more - Lead BI team on Microsoft Power BI development, analytics best practices, and data training. In 2021, led implementation of Power BI to replace Tibco Spotfire. - Managed day-to-day operations of the business intelligence team including: scheduling, assignment of work, and reviewing completed reports to ensure projects are completed accurately and on time - Primary Power BI administrator that monitors gateway performance, workspace and pipeline deployment, and data refresh schedules. - Developed reports and dashboards utilizing Power BI and deploys to the enterprise via the Power BI service. Experience with building star schema data models with Power Query. - Executed analytics that help the organization better understand member behavior and help predict member future behavior - Collaborated with end users to identify needs and opportunities for improved data management and delivery - Researched information to support strategic planning initiatives - Monitored BI and Data Warehouse industry trends, new product releases, technical advancements and other opportunities in the financial services space. Show less
-
-
-
Sparrow Health System
-
United States
-
Hospitals and Health Care
-
700 & Above Employee
-
Business Intelligence Manager
-
Jun 2016 - Aug 2019
Lansing, Michigan • Responsible for transforming a data analytics team from a traditional reporting team to a modern analytics BI team utilizing Tableau. Led a team of 15+ employees that included analysts, ETL developers, and data modelers. • Re-implemented Tableau from the ground up in 2017. This included improved administration features and folder architecture for enterprise BI deployment. It also included Tableau’s Ask Data functionality. • Responsible for Epic business intelligence and data… Show more • Responsible for transforming a data analytics team from a traditional reporting team to a modern analytics BI team utilizing Tableau. Led a team of 15+ employees that included analysts, ETL developers, and data modelers. • Re-implemented Tableau from the ground up in 2017. This included improved administration features and folder architecture for enterprise BI deployment. It also included Tableau’s Ask Data functionality. • Responsible for Epic business intelligence and data warehouse expansion and strategic direction. • Works closely with key business leaders to define critical information needs, providing guidance regarding availability of data, capability of systems to deliver information needs, and subject matter expertise regarding current systems and emerging technology. • Acts as liaison between business, clinical, and IT leadership regarding the identification of business-critical information and knowledge (e.g., customer and market data), and its usage and availability. • Building and executing productivity plans by reviewing work forecasts, determining productivity requirements, and partnering with customers and other leaders to properly plan resources.
-
-
IT Manager - Physicians Health Plan
-
Sep 2014 - Jun 2016
Lansing • Provide coaching, mentoring, and strategic direction to PHP IT team. Responsible for performance evaluations, recruitment, retention, and counseling for a team of 12 caregivers and 4 contractors. • Lead the teams responsible for ongoing development and support of PHP applications, reports, and data solutions. Maintain high standards and encourage process improvement with software development life cycle. • Maintain strong customer relationships across IT, PHP business teams and… Show more • Provide coaching, mentoring, and strategic direction to PHP IT team. Responsible for performance evaluations, recruitment, retention, and counseling for a team of 12 caregivers and 4 contractors. • Lead the teams responsible for ongoing development and support of PHP applications, reports, and data solutions. Maintain high standards and encourage process improvement with software development life cycle. • Maintain strong customer relationships across IT, PHP business teams and key PHP executive stakeholders. • Develop and implement IT strategic plans that support PHP strategic initiatives. Responsible for maintaining project prioritization and scope to effectively complete projects. • Manage a $3 million PHP IT budget that includes staffing, application maintenance and capital projects.
-
-
Senior Application Analyst/Business Intelligence Analyst
-
Sep 2011 - Sep 2014
Lansing, Michigan Area •Manage the ongoing development of the reporting and interface team that enables fact-based decision making and operational reporting at PHP. •Responsible for SAS Business Intelligence application and development. •Analyze business and technical processes within PHP IT and implement reporting and data solutions. •Develop reports and dashboards of key operational performance metrics for leadership. •Responsible for SAS Enterprise Business Intelligence administration of reporting… Show more •Manage the ongoing development of the reporting and interface team that enables fact-based decision making and operational reporting at PHP. •Responsible for SAS Business Intelligence application and development. •Analyze business and technical processes within PHP IT and implement reporting and data solutions. •Develop reports and dashboards of key operational performance metrics for leadership. •Responsible for SAS Enterprise Business Intelligence administration of reporting environment. •Prepare project plans for process improvement that include resource and cost estimates. •Lead changes to data warehouse performance improvements for reporting. Includes relational and dimensional databases.
-
-
-
Michigan State University
-
United States
-
Higher Education
-
700 & Above Employee
-
Business Intelligence Team Lead
-
Aug 2009 - Aug 2011
East Lansing, MI •Responsible for leading the Cognos BI 8.4 implementation for university enterprise reporting on Human Resources, Payroll, and Finance. Implementation date was January 2011. •Lead a team of eight MSU employees and four Cognos consultants to achieve business intelligence objectives for campus. •Collaborating with end users to identify requirements and improvements to enterprise reporting and delivery. •Defining and improving processes regarding reporting, presentation of data, and data… Show more •Responsible for leading the Cognos BI 8.4 implementation for university enterprise reporting on Human Resources, Payroll, and Finance. Implementation date was January 2011. •Lead a team of eight MSU employees and four Cognos consultants to achieve business intelligence objectives for campus. •Collaborating with end users to identify requirements and improvements to enterprise reporting and delivery. •Defining and improving processes regarding reporting, presentation of data, and data quality to improve accuracy, viability and value. •Advising, educating, and providing status reports to executive management and the project management office (PMO) regarding business intelligence initiatives. •Develop detailed project plans, including schedule creation, effort and resource planning, and synthesizing of plans across multiple projects. •Communicate project constraints, risks, and plans to various audiences on campus.
-
-
Workgroup Lead Finance Business Intelligence Team
-
May 2008 - Aug 2009
East Lansing, MI •Responsible for leading the work of two MSU employees •Consults with unit leaders and business staff across campus on accounting and financial reporting, areas of improvement, systems, key financial indicators, metrics, and trends. •Develop and deliver Finance Business Intelligence requests, using Cognos 8.4 report studio.
-
-
Management Analyst
-
Sep 2002 - May 2008
East Lansing, MI •Assisted with analyzing and projecting yearly benefits budget totaling over $200 million. •Responsible for administering and monitoring a $5 million departmental operational budget. •Provided strategic HR demographic and financial analyses, cost modeling and budget forecasting. •Analyzed and modeled health care issues, including cost reduction strategies, peer benchmarking, and vendor rate analysis. •Database development and implementation for various HR departments.
-
-
-
Auto-Owners Insurance
-
United States
-
Insurance
-
700 & Above Employee
-
Associate Actuarial Technician
-
May 2001 - Sep 2002
Lansing, Michigan Area •Database development and maintenance along with analyzing hurricane and earthquake exposure. •Reported Workers Compensation exposures to various insurance rating bureaus.
-
-
Education
-
Grand Valley State University
Bachelors of Business Administration, Finance -
Grand Valley State University
Bachelor of Business Administration (BBA), Finance