Lance Cottrell Email & Phone Number

Product manager for data and analytics for hospitality business units within ALG which was aquired by Hyatt in November 2021.Develop and define strategic roadmap for data projects. Direct management of development team using agile practices to deliver projects on time and within budget, with a focus on a result driven solution for the business.Work with PMO team to define project goals and strategy, and engineering team to deploy and maintain solutions in production.Experience in SQL, and Azure environment for ETL pipelins and BI dashboards and reports.

Manage team of 3-4 Business Development Specialists.Responsible for providing team with daily guidance, managing workload, technical support, personal development, performance evaluations, and disciplinary action.Provide estimate for all analytic projects of effort and timeline. Focus on report customization, SQL queries, SSRS formatted reports, and Power BI dashboards.Assign and track effort of projects assigned to team and ensure on-time, within budget delivery.Work with clients to determine reporting needs with current solutions as well as future requirements.Work with internal teams to improve interdepartmental efficiencies.

Product Manager for reporting solutions.Ongoing, overlapping responsibility with existing role. Product management is assigned to dedicated SME’s at Enertia and not a separate department.Create development direction for analytic applications – focus on SSRS integration with ERP application.Develop guidelines, test cases, and use case for development team to utilize.Work directly with development team for technical requirements, design analysis, and test cases.Gather and compile client feedback for future enhancements – providing feedback to executive team for roadmap of development.Direct responsibility over QC/QA of reporting solutions during biannual releases.

Increased focus on integrated reporting solutions for ERP application – specialization on SSRS (SQL Server Reporting Services) formatted reports and SQL queries.Provide technical review for all reporting solution projects for effort and timeline.Manage timeline of all reporting projects, both internal and client paid projects.Responsible for client interactions and troubleshooting for all reporting needs – both legacy and new development.

Houston, Texas Area

Directly work with clients on implementation projects and long-term support solutions.Work with clients on-site and remotely on business and technical needs. Work with team to implement client on ERP solution including user training, conversion requirements, business process analysis, and reporting solutions.Focused on reporting solutions including determining technical needs, writing SQL queries, Active Report formatting, SSRS formatting, and working with clients throughout validation/implementation of solution.Work with development team to redesign integration reporting solution from Access to SSRS. Provided QC and beta testing assistance internally and clients.

Responsible for troubleshooting, analyzing, and supporting client’s usage of ERP system.Remotely manage client’s SQL Servers, including application updates, database queries, and maintaining services.Diagnose software concerns and communicate customer requests for future software modifications.

Houston, Texas Area

Increased responsibility, overlapping with pre-existing role, designing departmental training programs andprocesses.Taught company-wide internal training classes in both classroom and online settings.Diagnosed system problems and concerns both at customer sites and in-office.Development of implementation plan for Ford ACE (Automated Card Everyone) integrated application,including direct relationship with Ford representatives working towards an Authorized Vendor status.

Houston, Texas

Provide on-demand, on-site and off-site customer training and consulting by analyzing client's processes and providing customized solutions for ongoing and prospective business situations.Customization of Dealership Management Systems (DMS) systems to meet department manager's desired goals. Launch full software solutions, including full competitive conversions and add-on modules, and customized configuration based on manager discussions.Train department managers on control systems for software solutions, and customized reporting tools.Train end users on-site and remotely via WebEx on daily procedures.