William Christensen Email & Phone Number

Corpus Christi, Tx, Us

Led Regulatory reporting, Strategic Analytics, Business Intelligence, and Data Science teams, setting the strategy and direction for the Enterprise Analytics teams. Demonstrated expertise in eliciting business requirements from various stakeholders and partnered with VP and other leaders to develop and execute the roadmap. Directly led the technical and people management of data & analytics teams, ensuring technical excellence with reports, dashboards, and other analytical products. Possessed expert data visualization skills (Power BI, Qlik Sense) and SQL skills, with a working knowledge of R or Python. Collaborated with other leaders to develop and execute analytical strategies, while showcasing strong Project & Product Management skills. Demonstrated knowledge of Data Warehouse design and structure (Dimensional Modeling Techniques) and developed detailed workplans for execution of strategies/goals, presenting them to senior leadership. Worked in conjunction with other directors and senior leadership of the health system to ensure accurate data and information availability throughout the organization. Oversaw analytics systems and processes for data extraction, validation, interpretation, and presentation, including submission of data to outside entities, clinical quality data and analytics, and business operations data and analytics. Made and implemented decisions compatible with organizational goals, maintaining composure, effectiveness, and flexibility under pressure. Led the code review process to ensure quality output and utilized predictive analytics to identify high-risk members and incorporate findings into dimension models in Caboodle (Enterprise Data Warehouse). Demonstrated understanding and interpretation of key trends in the healthcare industry (Medical, Pharmacy, Dental, Vision) and ensured high-quality data governance through data standardization, metric definition, and establishing the source of truth on data.

Led a diverse team comprising Data Architects, Business Intelligence Developers, and Clinical Business Analysts to devise solutions aimed at transforming intricate business data from disparate systems into actionable insights. Functioned as the primary technical escalation point for BI-related issues, adeptly communicating complex technical information to non-technical audiences. Collaborated with a spectrum of highly technical resources, including IT departments, subject matter experts (SMEs), and consulting groups, particularly for projects involving reporting, dashboards, or significant data components. Established comprehensive documentation and best practice examples encompassing SQL, Power BI, Qlik, Excel, SSRS, SSIS, SSAS, SlicerDicer, and data warehouse development, serving as a guiding resource to ensure solution quality and consistency. Implemented robust processes and procedures to minimize errors, enhance quality, streamline communication, and cultivate a knowledge base, notably through DevOps initiatives and SQL Agent validation jobs. Provided mentorship to new members within the Business Intelligence, Data Analytics, and Decision Support teams, fostering coordination and standardization across the shared Epic environment. Explored emerging technologies to streamline BI workflows and tools, with a focus on predictive modeling using Python, R, and Power BI. Championed the adoption of Caboodle as the enterprise data warehouse (EDW) for the Health System, orchestrating seamless coordination between the Hospital and Health Plan. Developed strategies to address variances identified by Epic build check queries, proactively resolving Caboodle data issues by identifying root causes from sources such as Clarity or Chronicles. Spearheaded the initial rollout of Power BI to replace Qlik Sense as the enterprise BI tool, ushering the organization into a new era of enhanced analytics, modeling, and BI tool consolidation.

Corpus Christi, Texas, Us

Led the Health Plan portion of the Qlik Sense BI implementation team to roll out a new enterprise BI solution for the Health System. Partnered with the business, both hospital and health plan, to review existing reports and dashboards to translate current processes and identify opportunities to enhance functionality outlined in the specification documentation. Converted specification files into actionable technical requirements and design, created and validated data solutions including views, stored procedures, CTEs, user defined functions, SSIS interface extracts, dashboard components, SSRS and Crystal Reports. Led an initiative to transition custom Crystal reporting from the Clarity relation database to SSRS using the star schema Caboodle data warehouse, significantly reducing development time and errors. Developed custom Data Model Components (DMCs) to load data from third party systems and Clarity, as well as, extending Epic released models in our enterprise data warehouse (Caboodle) using SSIS and TSQL. Performance tuned SQL object to ensure timely completion of nightly jobs and efficiency of Ad-Hoc reporting. Functioned as a general escalation point for technical data issues related to ETL, Clarity, Caboodle, SSRS, SSIS, Qlik Sense and Power BI.

Corpus Christi, Tx, Us

Mentor Level 1 and 2 Programmer/Analysts in the use and best practices regarding BI tools and architecture including Data Modeling Techniques for Data Warehousing, Cognos Framework Manager, Cognos Report Studio, SQL Server Management Studio, Visual Studio, SSIS, SSRS and SSAS. Develop, performance tune and maintain: queries, stored procedures, triggers, and functions. Convert project specifications into flowcharts and diagrams to illustrate the sequence of steps a program must follow and describe logical operations involved. Convert project specifications, using flowcharts and diagrams, into sequence of detailed instructions and logical steps for coding into C#, T-SQL and ASP.net. Streamline and automate system processes to minimize duplication of data entry by end users. Research, solve, and optimize SQL Server and .Net integration problems/performance. Read manuals, periodicals, and technical reports to learn the latest ways to develop programs that meet user requirements.

Irving, Tx, Us

Manage a team of HRIS developers, analysts and IT resources to ensure project budgets, goals, project plans, and schedules are adhered to and meet customer needs and objectives. Develop requirements, design processes, test and implement new technological solutions that will be used in the SSC, including (but not limited to) telephony, case management, knowledge management, interface management, benefits, payroll, compensation and workforce management (scheduling). Plan and coordinate the installation, configuration and testing of hardware and software components. Deliver ongoing management of vendor relationship to ensure technical solutions are achieving stated objectives. Provide hands on guidance to the development team with coding issues related to stored procedures, user defined functions, interfaces, reports, HR metrics, SSIS packages, HR portal and ASP.NET MVC websites.

Irving, Tx, Us

Design and lead all technical aspects of HR Shared Services Portal project, extending the existing enterprise Service Management (SM) software delivery and solution beyond IT. Code enhancements to the HR Service Portal (JavaScript, Jelly, XML) including SOAP / REST API web services to transfer data from various external sites and present the information in a manner consistent with the existing Enterprise look and feel (Marketing CSS). Create and use update sets to move solutions between ServiceNow instances. Maintain and optimize Knowledge Base and Service Catalog. Implement dynamic workflows with approvals. Create and configure SLA notification / alerts, dashboard, record producers, roles, groups. Build and manage User Interface (UI) policies, data policies, UI actions, business rules, reports, import sets and client scripts. Make adjustments to HTML pages to achieve aesthetic requirements outlined by the design team.

Irving, Tx, Us

Design, write, document and optimize database applications using MS SQL Server (T-SQL), Oracle SQL Developer (PL/SQL), Microsoft Access, VBA to convert multiple independent payroll systems and third party applications into a new enterprise standardized format, including benefits, compensation, job codes and various other pay practices. Write scripts, reports, ad-hoc SQL queries, format data extracts, develop maintenance tools from multiple complex systems for: conversion process, transaction identification\maintenance and data validation. Coordinate efforts within the organization's executive, management, support teams, development staff, and functional owners to ensure system integrity with change control procedures related to modifications to applications, database software, and other system utilities.

Irving, Tx, Us

Perform assigned activities in the following areas: Network Operations Center, Network Applications Services, and Host and Storage Services. Responsible for mainframe, server and midrange system maintenance and support, database administration, system availability, system performance and capacity monitoring. Administration of the eCHRISTUS.net technical infrastructure, including file servers, network operating systems, IP services, directory, file and print services; the NOC’s systems monitoring and management systems; the various mainframes, minicomputers and file servers that comprise the Hospital Information Systems; other application servers and host systems; data storage and backup/recovery systems; tape and media management; security and environment management; the network-based application software management and distribution system; and corporate anti-virus and email systems including related IP services such as DNS and SMTP.

Irving, Tx, Us

Responsible for all phases of instructional design including conducting the analysis, design, development, implementation, and evaluation phases for computer-based and traditional education and training for medium to high complexity IT projects. Serve as the education project resource to customers throughout the system, collaborating with system-wide, multi-functional teams, and L&D team members to design high quality, cost effective learning solutions. Manage service request work across the Healthcare business- both clinical and business service lines, with a primary focus on understanding the impact regulatory, HITECH and other clinical implementations will have on the Business Service Line.

Corpus Christi, Texas, Us

Implement database solutions to improve Finance, HR, and Nursing Department's strategic and operational plans by providing leadership with metrics, reports, analytical support, financial analysis and education. Update and audit database systems (McKesson, Kronos, BidShift, Meditech) for multiple hospitals on a monthly basis, maintain cost allocation, productivity, batch processes and troubleshoot system/interface problems. Translate flow charts, decision tables or other instructions into scripts and windows applications. Maintain existing programs; analyze, review and rewrite programs to increase operating efficiency or to adapt new requirements.

Corpus Christi, Tx, Us

Perform daily, weekly, and monthly systems administration duties including analyze, troubleshoot, resolve issues with operational tasks related to storage management, provisioning, backup processes & backup jobs on ES40, Informix Student and Finance Databases, Windows servers, and Apache Web server. Create and maintain Unix accounts for all CCISD Pentamation Sunguard users. Write, edit and run Korn Shell scripts to print large reports such as student attendance, report cards, progress reports, and custom reports. Analyze, code and document computer programs.

San Antonio, Texas, Us

Install and support all currently utilized technology, including PC's (hardware, software, and operating systems), networks, e-mail, voice mail, internet/intranet access, POS systems, fax machines, managers' workstations, wireless headsets, modems, credit/debit systems, AS/400 connections and applications, JD Edwards connections and applications, and other computer-related technologies installed in the restaurants or administrative offices.