R. James Roy Iii Email & Phone Number

Port Orchard, WA, US

Greater Seattle Area

Everett, WA

• Socialized and successfully implemented Agile project management practices as the first business analyst hire at Funko.
• Designed and implemented an ETL framework to aggregate point of sale data from a variety of sources and formats from major retailers (e.g., Walmart, Amazon, Target, etc.) resulting in a normalized data set that was.
• Designed and implemented a MS SQL Server framework for identifying and mapping incongruous data points from external sources to corrected internal data points resulting in an increase from a 28% match rate to a 97%.
• Created data visualizations and executive dashboards using Power BI and Tableau to identify sales trends and forecasts for point of sales data.
• Created and maintained an Atlassian Confluence site which detailed information pertaining to department planning, processes, tools, resources, and project requirements.
• Implemented and hosted Excel, Power BI, and other technology training sessions to empower users and reduce need for ad hoc reporting freeing technical resources for more advanced projects.

Greater Seattle Area

• Assisted in the implementation and integration of third-party platforms with legacy business systems resulting in the capability for Premera to enter the healthcare exchange market in WA, OR, and AK.
• Developed business and technical requirements for multiple projects including a user account creation service, a Single Sign On (SSO) service, and the definition of multiple data exchanges and interfaces.
• Lead and facilitated Joint Application Development (JAD) sessions to elicit, document, and define requirements for complex projects and large-scale initiatives with significant business impacts.
• Managed requirements across the lifecycle of multiple high impact projects to ensure end user satisfaction, business stakeholder buy-in, and scope integrity

Chicago, IL

• Supported vice presidents, national directors, account executives, clients, and call centers by providing subject matter expertise for a continuum of e-healthcare solutions, creating call center workflows, identifying.
• Partnered with healthcare networking contractors, provider engagement teams, and multiple national call centers by providing product support for e-healthcare solutions, documentation, training, and requirements.
• Assisted in e-healthcare product implementation and development for multiple clients covering millions of members across national markets including Premera, Regence, LifeWise, and regional Anthem BCBS plans.
• Managed and developed a call center team of ~20 employees resulting in the highest audit and customer satisfaction scores in the department.
• Created batch testing tools that reduced manual testing time by 80% and additionally automated repetitious data entry tasks which eliminated entry errors and reduced task time by 55%.