Stacy Perron Landry Email and Phone Number

Part of the team onboarding Alation data governance software.

Serve as lead analyst on data migration teams ingesting healthcare payer data sets from various payers into Azure Databricks cloud environment and into Snowflake SDRP environment.Partner with business and IT resources for all steps of the data integration process, including requirements, profiling, cleansing, source to target mapping (STM), writing data transformations, validation, and end user setup and education.Perform root cause analysis, create solutions, and coordinate resolution for a wide variety of data issues.Present progress and findings in meetings with internal and external client technical teams and leadership.

Led business stakeholders, ETL developers, BI developers, and testers to identify reporting solutions to complex business needs for home health and hospice company with over 20,000 employees and operations in over thirty-seven states. Created full functional specifications based on my analysis, complete with SQL statements that provide the sources of the data, any special join or selection criteria, and other transformations needed. I coordinated and performed extensive testing to validate the integrity of the data.Solved the issue of disparate data sources as it related to care center locations. Served as Catalog Administrator and on the implementation team for Alation Data Catalog software. Helped to develop the data privacy and governance strategy and create the content. Created “glossaries” that define metrics, terms, processes, and dashboards. Wrote table and field definitions, as well as source mapping, for all the new star schema tables developed during the data warehouse redesign.Analyzed multiple source systems, the current reporting environment, and the current DataMart as part of duties serving as architect and product manager for the human resources data warehouse.Drafted multiple star schemas to address the reporting needs throughout the company.Facilitated continuous communication with the customers of our products. I fielded questions and initiated conversations about data that appeared inconsistent, features that are available and how to use them, current workflow challenges, new solutions coming soon, and any other topics requested by users.Utilized resources such as CMS documentation, best practices, internal resources with strong business knowledge, and skilled technical developers to create metrics that measure business performance. The metrics could be financial, regulatory, or operational in nature. Developed templates and policies around documentation.

Write detailed specifications for new data warehouse tables whose requirements originate with dashboards and reports.Research source systems and participate in developing subject specific dimensional tables. Create source to target mapping documents. Experience with PeopleSoft, Facets, HCHB.Write reports using SQL. Perform detailed testing of tables, dashboards, and reports. Serve as curator for the Alation data catalog tool.

• Redesigned the process for creating and maintaining a system of tables that include all of the Medicaid provider registry information.• Developed a data governance solution for department managed databases and systems, including establishing naming conventions, approval processes, and complete documentation.• Perform mapping and create technical requirements for reporting required by the Louisiana Department of Health.

• Performed thoughtful solution design to address the question of how to control outbound data, then created a team to begin sourcing data extracts from the enterprise data warehouse (EDW).• Promoted to team lead of the extract team, which included serving as Product Owner and Scrum Master in addition to existing analyst duties. • Delivered detailed business requirements and source to target mappings (STMs) based on collaboration with business owners, IT professionals, management, project teams, and other stakeholders.• Performed analysis and research for new extracts, including gathering requirements and specifications, working with the development team to create the extract, and assisting the quality assurance (QA) team with testing. • Designed a new process as part of the alternative payment initiative delivering member attribution data and other analytical measures to Accountable Care Organizations (ACOs), external analytics vendors, and other internal systems.• Using scaled agile framework (SAFe) guidelines, participated in the quarterly program increment (PI) planning and the resulting two-week sprints, bi-weekly demos, daily stand up meetings, sprint retros, and sprint planning. • Used Microsoft Team Foundation Server (TFS) board for planning and execution of agile projects, including writing detailed user stories. • Used SSRS and Teradata to write SQL queries to analyze and understand the data in the warehouse in order to design reports, to troubleshoot issues, and to answer business questions.• Used Erwin software for data modeling of relational database structure as it was being designed and implemented by the EDW team. • Partnered with Data Governance to manage and prioritize the backlog of extract transform and load (ETL) jobs that deliver complex data to multiple vendors and while maintaining privacy and compliance.

• Transitioned to work on the Data Excellence Program in September 2017. Began doing analysis and testing for extracts using the EDW as the primary source.• Performed quality assurance, system integration, and user acceptance testing on ETL data files and code change deployments.• Created and documented use cases, test cases, and testing results, including defect resolution and validation.• Wrote functional, technical, and business requirements for projects and maintain internal documentation on department processes and lessons learned.• Used Informatica programs, such as PowerCenter, Developer, and Data Validation Option (DVO), Teradata, and IceDQ to perform job requirements. • Served on the Facets Data Mart Governance committee, researching solutions for issues that arise in the data models and the ETL jobs.

• Gathered information and created requirements for reporting solutions to business needs. Worked with business operations management and technical resources to analyze data and design reports. • Established and led a team of business and technical resources for four years. The team collected and then loaded membership data from all groups as required for the Medicare Secondary Payer Section 111 reporting.• Designed and developed a daily productivity tracking report for all membership areas.• Developed the requirements and performed the data collection and analysis after data breaches within the industry. • Used Microsoft Excel, Microsoft Access, Power Pivot, and SQL Server to perform complex queries of data in Facets claims and enrollment system and PeopleSoft financial system.• Developed dashboards and data visualizations using Tableau business intelligence (BI) software.• Served on the Data Stewards Council as the Benefits Operations representative, assisting with the optimization of the company wide electronic data warehouse. • Performed peer reviews of requirements, SQL code, and report logic using Team Foundation Server (TFS).

• Led the project for configuration and implementation of Compliance 360 software. Served as administrator for the system.• Performed business intelligence analyses on internal compliance rates of federal, state, and Association mandates.• Created and presented written and graphical documentation for employees, managers, the senior management team, and the board of directors.• Participated in annual department budgeting, planning, and resource allocation.• Developed and implemented the new process for the annual risk assessment and the resulting strategic approach to departmental goals. • Established an electronic process for storing, tracking, and distributing laws and regulations for all areas of the company.• Created, reviewed, and revised process documentation with various operational areas to ensure compliance with contract provisions and federal and state laws and regulations.• Performed data gathering, analysis, and presentation as requested by management.• Supervised and trained interns and staff level consultants.• Trained and experienced in Healthcare Reform requirements. • Worked with cross functional teams to write business and technical requirements. • Planned, executed, and reported results from compliance audits and monitoring projects. • Extensive experience in HIPAA administrative simplification, privacy, and portability.• Extensive experience in Medicare Secondary Payer (MSP), including Section 111 reporting.• Extensive experience with learning complex laws, regulations, and contractual requirements and applying that knowledge in an operational setting.• Proven success in managing multiple projects and competing priorities with little oversight.