William Glick Email & Phone Number

Newtown, Pa, Us

Pittsburgh, Pa, Us

• Product Engineering team for Highmark Individual Billing System responsible for health insurance premium bill account maintenance and invoice generation of Medicare, Medicaid, and commercial lines of business for multiple insurance plan partners• Created SQL scripts to maintain product business rules for supporting new product setups and customized system capabilities• Authored use case documents to explain project requirements and desired system behavior with many teams including impacted upstream and downstream systems, support representatives, management, and customer stakeholders• Identified cross project risks and dependencies and their project plan impacts• Served as scrum master for a cross functional agile development team responsible for scheduling and facilitating regular scrum ceremony meetings• Provided valuable input for long term project planning and resource allocations • Verified expected business and technical results from functional testing with database validations, UI screenshots, and file outputs• Confirmed system performance testing needs and regression testing scenarios with introduction of new features• Ensured completion of all project requirements traceability to meet SOC 2 compliance• Maintained security and privacy of data that contains PII or PHI• Acted as mentor to interns, new hires, and associate level teammates

Hartford, Connecticut, Us

• Individual healthcare product technology business analyst team responsible to coordinate Aetna business needs with external vendor development teams • Directed efforts to create and load plan management files for Affordable Care Act plans using data from multiple sources within Aetna and Coventry systems• Created data mapping documentation for integrations between new and unfamiliar systems• Primary legacy Coventry IT team owner for Individual product setup and maintenance tasks for broker and consumer sales portals• Coordinated meetings and communications between IT, business, and vendor representatives • Assisted support for and provided inputs in cross functional team meetings between internal business areas including benefits, actuarial, provider, pharmacy, and sales• Met all deliverable deadlines and contributed to successful Open Enrollment deployments• Responsible for ETL activities of all Aetna and Coventry plan template files to enrollment and sales vendors • Contributed and led testing efforts to integrate website directly to the federal healthcare exchange giving brokers and consumers the ability to enroll in subsidized insurance coverage

London, Gb

• Provided key contributions in projects and efforts to comply with Affordable Care Act health reform regulations• Seamlessly transitioned into a new company culture and immediately assisted with important testing activities to meet critical deadline dates• Actively participated in regular conference calls with business leadership, external vendors, and federal CMS representatives• Followed communications and regulations from frequently changing federal guidelines and informed teammates of key updates

Braddock, Pennsylvania, Us

• Case management platform that fulfills the operational needs of an entire organization with customers including family service organizations, foster care, drug/alcohol counseling, and inpatient home care facilities• Complied with all HIPAA health care privacy regulations• Performed system administration duties such as user setup, security access, data import/conversion, codebase management, and production deployment• Participated in multiple on-site customer meetings around the country to fully understand the operations of an organization and elicit requirements for the system to best meet their needs• Built and maintained complex SQL queries and stored procedures for batch processing and output reporting• Performed database administration tasks including performance optimization, environment set up and maintenance, and maintaining disaster recovery backup and restore procedures• Developed a customizable database import and mapping tool to assist with new client implementations allowing junior team members to perform many of my previous tasks• Monitored and optimized process performance across multiple test and production environments• Coordinated efforts for systematic product updates and enhancements through user feedback and industry analysis• Solely responsible for engineering, client setup, and support of billing and reconciliation systems including customizable claim data mapping, secure electronic insurance claim generation and reconciliation, and reporting tool integration as well as many output reports using those tools

• Contributed as junior member in a small stable software development team providing a wide range of software such as content management websites, school administration, and promotional item order entry• Worked directly with clients to define requirements, complete deliverables, and identify and resolve defects• Added positive value in the development of custom client-server applications while becoming familiar with SDLC steps and development tools