Nick Smith Email & Phone Number

Bath Township, MI, US

Bath, MI

Chicago, Illinois, United States

Voted the #1 consulting provider on G2 for Business Intelligence and Power BI,Collectiv’s experts are highly skilled across the Microsoft data stack and highlyspecialized in planning and forecasting.

- 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.

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.

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 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.
• 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.

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 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.

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 environment.
• Prepare project plans for process improvement that include resource and cost estimates.

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 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.

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.

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.

Lansing, Michigan Area

• Database development and maintenance along with analyzing hurricane and earthquake exposure.
• Reported Workers Compensation exposures to various insurance rating bureaus.

Bachelors Of Business Administration, Finance, 3.86

Activities and Societies: •Phi Kappa Phi Honor Society •Beta Gamma Sigma Business Honor Society

Bachelor Of Business Administration (Bba), Finance