Byron Welch Email & Phone Number

California, United States

Magellan Health Care was acquired by Prime Therapeutics in Dec 2022

Richmond, Virginia Area

* Acts as Enhancements Team Lead managing enhancement requests using agile Kanban methodology to ensure fast response to user enhancement and problem resolution requests.* Works with team to develop Dimensional reporting model * Implemented Cognos 10 and Cognos 11 reporting solutions including the design, creation, and administration of end user reports* Creates epic / user stories to support Agile development via JIRA* Serve as a conduit between the user community and the software development team* Turn business requirements into functional technical specifications

Manages the California Medicaid business Intelligence group

• Acted as principle data architect for IBM Emptoris Contract Management reporting system development during the transition from Business Objects to Cognos• Served as a principle database designer implementing a dimensional model• Worked with team to develop Data Stage ETL and define source to target mappings• Worked with team to design a dynamic model builder resulting in a custom product for each client with no manual intervention• Implemented Cognos 10 and Cognos 11 reporting solutions including the design, creation, and administration of end user reports• Create epic / user stories to support Agile development via JIRA• Serve as a conduit between the user community and the software development team• Turn business requirements into functional technical specifications• Train reporting staff and customers on Cognos best practices• Manage code fix identification and promotion• Act as a consulting resource for other analytical development and business groups working with finance, sales, operations, and services• Serve as Cognos technical consultant for the reporting L3 group• Test, validate, and troubleshoot data issues• Work with business users to create test cases to validate data• Manage customer interaction to provide speedy resolution of issues• IBM Blue Diamond certified to handle personal and confidential data

• Provided data architecture design assistance with new data mart projects • Designed dimensional models for the existing relational Data Warehouse• Worked with IT and Business users to determine source to target mappings• Created dashboards in Cognos using both native dashboard capability and Workspace Advanced• Designed, created and administered end user reports using Cognos• Tested, documented and implemented reporting systems• Turned business requirements into functional technical specifications• Served as administrator for Development, QA, and Production environments• Acted as a consulting resource for other analytical development / business groups• Managed Code promotion between Production, Development, and test environments• Worked with finance group to evaluate TM1 and cube technology• Worked with a team to evaluate SQL Server vs. Cognos reporting• Worked with a team to evaluate SQL Server vs. home grown ETL• Negotiated Cognos contract upgrade details

• Provided design assistance with new Data Warehouse projects• Created reports / dashboards using Siebel Analytics• Created reports / dashboards using Cognos • Designed PowerPlay cubes and frameworks to meet reporting requirements• Assisted users in designing complex reports• Designed and conducted custom training for business users worldwide• Worked with the Finance Director to deliver reports /dashboards to meet management financial report objectives• Worked with Warehouse management teams to deliver reports/dashboards

• Provided design assistance with new Data Warehouse projects• Designed PowerPlay cubes and Impromptu catalogs to meet business requirements• Turned business requirements into functional technical specifications• Assisted users in designing complex Cognos reports• Advised technical users on new Cognos functionality• Designed custom training for business users• Created and presented Cognos class lectures and exercises• Analyzed business processes / made technology suggestions for business issues• Developed an interface to the public web site that automatically formatted reports for delivery as web pages to automate the publishing of public records information

Maintained production systems

In-house Projects Team Leader• Accomplished Project Manager • Worked with clients to assess project scope and resource requirements• Scheduled/supervised consultants for projects• Assisted in the creation of customized training materials for Cognos• Created and implemented documentation standards• Created and administered training plans for staff• Applied for and received training grants from the state of Rhode Island to supplement training budgets Senior Consultant• Provided Y2K remediation on HP3000, Unix, VAX, RS6000, and Windows • Acted as software support contact person with COGNOS• Analyzed and created business requirements documents• Documented issues relating to missing and inaccurate data• Designed PowerPlay cubes and Impromptu catalogs