Garrett Mccormack Email & Phone Number

Portland, Me

• Business owner and liaison to customer and internal partners for Eligibility File Feeds by conducting meetings, providing business interpretation of file layout, and coordinating all phases of testing of the data file.• Provide review of data received, including trends and discrepancies, to ensure information received is accurate for a smooth benefits/leave experience for the customer.• Volunteered to lead new process of customized file onboarding to better meet the complex needs of our customers.SPECIAL PROJECTSSharePoint CRM – Developed using JavaScript/HTML for managing work and creating metrics to better understand trends with internal and external partners. Built reports using Power BI to analyze the data to support business needs such as staffing models, cycles of work, year-end tracking, and best practices. Continued maintenance support to meet the changing needs of the business.Salesforce - SME for transition from SharePoint CRM to Salesforce. Generated documents for Salesforce Agile Team regarding business needs. Tested, implemented P&Ps, provided demos for peers and partners. Built team reports, lists and dashboards. Added components to team dashboards to assist with data integrity.

Portland, Maine Area

• Develop technical documents that describe workflows to educate team members on industry protocols• Write SQL queries and display results in an understandable format to support team’s reporting needs• Cross train agile roles for better team flexibility• Build C# knowledge base and implement code changes. One code change was a credit care checksum function that verified if a credit card number was valid once entered before accepting values.• Provide demos to users and management on upcoming code releases to optimize utilization of new workflows• Provide support to users and management after code implementations

Portland, Maine Area

• Create, update and migrate Microsoft Access databases to increase department efficiency• Write SQL queries to answer user questions and help develop next steps based on results• Create and maintain department spreadsheets that allow for better organization and collaboration• Serve as point of contact for peers and management regarding all aspects of technical issuesSPECIAL PROJECTSTriage Tracker Tool – Allows the building of profiles by managers for each subordinate that, based on work capacity, will tell manager who to distribute work to – Designed business logic while working with managers and implemented logs for future inquiry to better understand the amount of work coming in.Licensing Database - Allows for easy creation of profiles for each elderly care facility with link to image of facility license. Could search using multiple parameters.Gate Keeper Database - A one time use database that's purpose was to stagger letters going out to LTC clients/caregivers regarding new EFT deposit of benefits. It had 2 main functions. Function 1 was to create list of client/caregivers to mail out letters informing of change. Function 2 kept track of letters received back with EFT information to be processed by EFT Team.LTC Claims Reporting database - Provide aggregate claims payment reports to employers regarding their Group LTC policies.

Portland, Maine Area

• Trusted with company credit card to order and manage medical record request for benefits area• Facilitated claims with average of 97% out of 100% accuracy while developing technical abilities above

Lewiston/Auburn, Maine Area

• Designed front-end user interface with an emphasis on usability.• Layout created with Dreamweaver, Photoshop, Fireworks and Illustrator• Used HTML, CSS, JavaScript and PHP