Michael Roca Email & Phone Number

Charlotte, Nc, Us

- Building multi-client SQL-based scheduled audits to reduce client workload and costs- Leading daily & weekly client interactions to gather new feed requirements, resolve arising issues, and review audits- Building, executing, and maintaining ETL file feeds- In one ad hoc audit, cross validated 1000 new client data points against known issues, existing client data, and employee eligibility & benefits- In a single implementation, engaged combinatorics logic, client & industry requirements to develop 500,000 valid permutations of benefit plans and classes- Day-to-Day Applications: bswift (Employee Benefits Platform), SQL Server, MS Office 365

Chicago, Il, Us

- Develop & maintain EDI file feeds, incoming and outgoing, both manual and automated, for 150+ clients- Generated over $300,000 in annual revenue in a single project by onboarding 5,000 lives- Onboarded over 50,000 lives in a single project with benefits, dependents, and beneficiaries- Proactively auditing data anomalies. In one typical audit, identified 1000 potential errors totaling $750k in annual revenue- Initiate sessions with clients and internal departments to gather new feed requirements, resolve arising issues, propose audits, and define data hand-offs- Create ad-hoc and scheduled Excel-based client-facing reports presenting data in a business-friendly manner- Owner, developer, and problem solver of 15+ SQL, Access, and Excel-based subsystems- Coaching coworkers in data analysis best practices- Day-to-Day Applications: SQL Server 2005-2017, MS Office 365, FileZilla

Kennesaw, Ga, Us

- Designed, developed, and managed over 15 daily, monthly, and quarterly data-focused reports for both internal and external clients- Performed ad-hoc data analysis/operations research across departments and disciplines- Utilized Crystal Reports software to produce client-facing quality quarterly PDF reports- Managed a multi-department process review of 100+ Standard Operation Procedures- Day-to-Day Applications: Crystal Reports, MS Access, MS Excel