Brian Ginoza Email & Phone Number

Denver, Co, Us

• Utilized previous analyst skills to maintain and improve training environments• Designed and conducted training on basic SQL commands to new Academy students• Utilize Windows Event Viewer, IIS, Application Configuration files, and MS SQL• Resolve issues with application installs on Windows 2008/2012 servers• Collaborate with other departments for resolution and implementation of issues, custom work, and core product • Analyze client product questions to provide answers to client specific needs Collaborate with consultants, Instructional design, Product Dev team to update training material • Work with Product development team to identify potential product application enhancements• Teach internal and external customers how to configure and navigate healthcare applications: QNXT, Encounter Data Manager (EDM), Encounter Data Manager Edge Server (EDMX), Claims Workflow, Appeals and Grievance Workflow, UM Workflow, ClaimSphere, and StarServ• Conduct product training session, both on-site or via WebEx and/or GoTo Meeting applications• Design training material for new products or client requested custom training with Instructional design• Maintain application environment to keep current with healthcare and product changes

Englewood, Co

• Developed SQL comparison scripts to compare data entered by Certificate Test takers test database against a Gold copy database.• Developed SQL scripts to examine client security database to find and terminate access to users no longer needing access• Create SQL scripts using Joins (Inner, Outer, and Cross), CTE’s (Common Table Expressions), Temp Tables, Table Variables and Stored Procedures and Dynamic SQL • Diagnose issues with deployed SSRS reports and SSIS packages • Use SOAP UI to build and test REST and Web services call to examine responses sent from requests • Used VBA to take a list past list of data into Excel and transform them into a comma delimited list in parenthesis for use in SQL IN operator • Utilize Windows Event Viewer, IIS, Application Configuration files, and MS SQL• Resolve issues with application installs on Windows 2008/2012 servers• Examine Health Care X12 files and XML files for possible data or structure issues• Participate in monthly maintenance activities to ensure applications was functional after server updates applied and rebooted.• Available during Go-live week for troubleshooting when needed after hours and on weekends• Maintain application environment to keep current with healthcare and product changes• Remained on-call for specified time period as needed• Received Power Star and “I Got Caught” Rewards for Core Value recognition and support

Loveland, Co

• Manage personal cases in Case Management systems Salesforce and iSupport• Remote into Hosted and Customer’s servers to troubleshoot IIS, Application, and SQL issues• Run SQL select statements to investigate data in MS SQL 2005/2008 Databases• Run SQL Traces to help identify issues during specific processes in the Software's User Interface• Manipulate DB data if required to resolve issues that cannot be resolved via a software fix or customer data fix• Adjust Custom Stored Procedures or Views to meet customer specification on data exports from Database to third party software• Verify Users Group Memberships in Active Directory• Work with customers to explain issues with the data they are providing or to inform them of resolution or escalation of issue to Development team• Help fellow team members in diagnosing their cases as time or priority dictates.• Help build training documentation and knowledge base for Software Support team.• Create Full Database Backups as needed for Crystal Reports team • Deploy custom crystal reports to customers machine• Identify issues with Database Data or with Crystal reports SQL Statements when resolving reports issues• Maintain Product Services running under Windows Services Console• Verify Application Services running and restart as necessary• Use Windows Event Viewer• Set up Scheduled Tasks• Deploy and modify batch files• Reset Passwords in Applications and Case Management Systems• Received multiple "Software Stars" Received when customers return survey for closed cases with maximum rating• Awarded Glass Trophy for “Customer Focus”

• Clarify specifications for T1 order from client• Set proper expectations for delivery of T1 install• Place order and resolve any issues with order placement restrictions• Monitor Order and escalate as due dates for process steps are reached• Co-ordinate T1 cutover with Customer and T1 Engineer when T1 is ready• Place orders to reserve and turn up customer requested 800 numbers• Hold weekly Work-In-Progress calls with Customer to discuss on-going projects• Create and monitor service outage tickets with Provisioning Centers