Steph Pike Email & Phone Number

Las Vegas, Nevada Area

• Design detailed population health queries to determine trends and opportunities, provider performance reviews, specialty utilization, hospital readmissions using SQL and SAS.• Create monthly and quarterly reports to set organizational benchmarks and evaluate goals.• Perform ad-hoc analysis packages to address provider contract repricing and bundled surgical rates.• Analyze, define, and report on (Pre-Authorization) Utilization Review data trends across six separate health plans.• Investigate and report on data integrity for emergent situations and standard operating procedures.• Work closely with IT to design tables to develop SQL tables and stored procedures to support ongoing reporting needs.• Perform Quality Control checks on analytics packages.

Las Vegas Market

• Gather data and transform it into relevant information used by hospital executives to develop strategic plans and long term goals.• Participate in Lean Six Sigma initiatives by providing planning, coordination and analytical support on a variety of projects.• Create metrics portfolios to gauge and measure Rapid Improvement Event (RIE) success.• Analyze patient satisfaction and HCAHPS scores, in order to identify opportunities at each hospital campus.• Query data in Cerner Electronic Medical Record (EMR).• Collect and report Length of Stay (LOS) volumes on a monthly basis.• Research and design standard of work (SOW) process flows.• Work with key stakeholders and executive sponsors to develop analytical tools that review market share and profitability, expenses, operational volumes and service utilization.

Las Vegas, Nevada Area

• Led multidisciplinary teams to develop and implement automated solutions, using SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), and proprietary business applications.• Created detailed technical specification documentation set to clearly define business and technical project requirements.• Launched task based project plans with specified goals, prioritization, dependencies, vulnerabilities, resource availability, responsibilities, constraints, cushion, and timelines.• Developed test scenarios in the test database and conducted final user acceptance testing with internal and external clinical implementation teams to ensure code accuracy.• Researched and identified root causes of defects/bugs and developed solutions and process improvement plans.• Analyzed and researched current workflow needs to develop the business requirements for client implementation that adhere to HIPAA standards and ensure data integrity.• Designed effective, scalable strategic business process improvements (BPI) to solve business problems and replace manual procedures across multiple claims platforms to Extract, Transform, Load (ETL) data.• Performed employee training and skill evaluations, built training manuals and toolboxes.• Assisted management with candidate interviewing and selection.• Managed long and short term projects working with executive sponsors, stakeholders, and process owners while providing daily and weekly feedback and status reporting.• Accurately assessed the risks associated with client and provider focused solutions and presented to the internal business process owner utilizing Visio flow charts and/or SQL queries.

Las Vegas, Nevada Area

• Created project plans with specified goals, strategies, dependencies, vulnerabilities, responsibilities, and timelines.• Proactively managed and coordinated casino projects valued in excess of $250 million dollars, including new player loyalty program rollout, planning/construction for thrill ride Sky Jump, new restaurant venues, and hotel remodel/rebranding.• Coordinated integration of vendor tasks, tracked, and reviewed vendor deliverables.• Prepared project status reports and conducted status meetings with executive management team.• Researched competitor offerings and coordinated the annual Strategic Marketing plan across multiple properties and at the corporate level. • Participated in identifying, evaluating and selecting and recommending candidates, consultants, and private contractors and vendors for both corporate and property focused projects. • Created project reports and dashboards using SQL Server Business Intelligence Studio to track and monitor essential business data.• Analyzed focus group studies to understand target customer feedback and recommend new projects.

Las Vegas, Nevada Area

• Coordinated of the activities of multi-disciplinary, multi-state teams in the achievement of project objectives and outcomes. • Conducted interviews with hospital administration teams and physician groups in order to understand business practices and define the scope of the project.• Defined vulnerabilities, opportunities, and key performance indicators (KPI).• Developed project plans and presentations to work toward client goals, such as physician recruitment, hospital expansions, improvement of published health ratings, increased patient capture, and reduced migration.• Developed customer focused projects and tracked, measured and reported on project progress, resource, staff, assets and schedules and project metrics.• Created and documented descriptions of assigned projects and maintained detailed technical specifications.• Reviewed the project phase results and team performance, and adapted contingency plans as necessary to exceed performance goals.

Las Vegas, Nevada Area

• Managed 100+ employee unionized department working with both Teamsters and Culinary unions.• Assessed and resolved both employee and guest concerns in various fast-paced high-stress situations. Executed annual employee performance evaluations and developed motivational programs to help increase morale and decrease employee turnover.• Created payroll budget through effective forecasting to control labor and supply expenditures while keeping pace with customer volume.• Implemented proactive inventory management procedures for department to insure adequate supply levels on a just in time basis.

Project Management Certificate

Bachelor'S, Business Management

Dean's List