IBM Sterling
Ryan Holloway
Mooresville
Summary
Motivated and results-driven Analyst with a proven track record in data analytics and process mapping. Adept at identifying business needs and developing innovative solutions that enhance accuracy and efficiency. Expertise in working with diverse data formats and translating complex data into actionable insights, as well as establishing automated processes for monitoring and error alerts. Committed to driving business effectiveness through strategic recommendations based on comprehensive data findings. Eager to leverage analytical skills to contribute to organizational success and optimize operational performance.
Overview
11
11
years of professional experience
1
1
Certification
Work History
EDI Analyst
Lowe’s Companies Inc.
07.2019 - Current
- Architected and maintained complex automation and integration scripts using Python, C#, and XSLT, significantly improving system efficiency, reducing manual intervention, and increasing throughput across multiple EDI workflows.
- Developed Python-based automated jobs leveraging Selenium for web-driven processing, data validation, and regression testing of partner portals and internal applications, increasing processing accuracy and reducing cycle time.
- Led end-to-end performance monitoring and optimization, proactively identifying system bottlenecks, conducting root-cause analysis, and collaborating with developers and infrastructure teams to implement scalable, long-term fixes.
- Oversaw full lifecycle involvement in the SDLC, including requirements analysis, technical design review, development, QA validation, deployment planning, and ongoing production support for mission-critical EDI systems.
- Designed and maintained EDI mappings (850, 856, 870, 846 and 860) scripting frameworks to ensure accurate data transformation and partner compliance.
- Engineered advanced SQL Server and PostgreSQL queries, stored procedures, and database structures to support high-volume EDI transactions, data validation, and downstream analytics.
- Built and orchestrated automated workflows using tools such as Bizlink, and Python-based custom utilities to support daily EDI operations and exception handling.
- Supported and enhanced AS400 (iSeries) workflows, including data extraction, job scheduling, and integration with modern EDI platforms.
- Managed secure AS2 trading partner connections, VAN and SFTP connections
EDI Analyst
Continental Benefits
07.2018 - 07.2019
- Wrote and maintained custom scripts to increase system efficiency and performance time.
- Monitored and tested application performance to identify potential bottlenecks, develop solutions, and collaborate with developers on solution implementation.
- Participated in all phases of system development life cycle, from requirements analysis through system implementation.
- Worked with Rx Director to resolve claim and accumulator problems, improve operations and provide exceptional customer service.
- Developed mapping in automation software for NCPDP, 834 and custom files (pipe-delimited, tab-delimited, CSV, space width and etc.) Mapping in generally done in C# and XML/XSLT.
- Used Microsoft SQL and PostgreSQL in creating sophisticated queries and creating/ adding databases.
- Worked with software such as; pilotfish, visual cron, visual studio, ultra edit and PostgreSQL for creating automated jobs, mapping and creating scripts.
TRS Service Specialist
Continental Benefits
06.2016 - 06.2018
- Review records of member and root causes with Aetna advocates
- Build relationships with Aetna and HMOs (Blue Essentials BCBS, Firstcare and Scott and White)
- Worked closely reviewing discrepancies and trends with Aetna and HMOs between Javelina data and their system data through 834 files.
- Set up weekly meetings with Aetna and HMOs in providing solutions to certain trends or issues that occur and preparing for open enrollment file testing
- Reviewed over inbound and outbound 834 files for updates and advisement to TPA (Third Part Admins) or Benefit Admins
- Root caused issues with members that require investigation of why member was not updated properly either due from error on file, manual or TPA/Benefit Admin in order to resolve issue and prevent future errors from occurring
Auditor
Embassy Suites
01.2015 - 06.2016
- Coordinated, managed and implements projects for auditor and examiner evaluations.
- Analyzed accounting systems for efficiency and effectiveness.
- Performed strategic planning, execution and finalization of audits.
- Prepared working papers, reports and supporting documentation for audit findings.
- Gathered and analyzed financial data to determine improvement efforts.
- Completed audit papers by thoroughly documenting audit tests and findings.
- Organized all taxed exempt information making sure every part was in order for federal/state tax exempts.
- Closing out business day and reassuring every account is in order and correct.
- Facilitated financial and operational audits, working with internal and external managers to communicate recommendations or issues surrounding audits.
Education
Bachelor of Science degree - Computer Science – Management Information Systems
Bellevue University
Bellevue, NE04-2026
High School Diploma - undefined
Spoto High School
Riverview, FL01-2009
Skills
- Data quality assurance
- Clear technical documentation
- Workflow analysis
- Strategic problem analysis
- Data analysis expertise
- SQL proficiency across multiple platforms
- Python development
- Data structuring
- Application scenarios
- System diagnostics expertise
- Network troubleshooting
- Business workflow evaluation
- Implementation of security protocols
- Proficient in Microsoft Visual Studio
- Data-driven insights
- Product lifecycle management
- Proficient in organization techniques
- Risk assessment
Certification
- Certification in JavaScript
- Certification in CSS and HTML
- Certification in SQL
- Certification in Python
Software
Rithum
PilotFish
Timeline
EDI Analyst
Lowe’s Companies Inc.
07.2019 - Current
EDI Analyst
Continental Benefits
07.2018 - 07.2019
TRS Service Specialist
Continental Benefits
06.2016 - 06.2018
Auditor
Embassy Suites
01.2015 - 06.2016
High School Diploma - undefined
Spoto High School
Bachelor of Science degree - Computer Science – Management Information Systems
Bellevue University