Alan Querubin Email & Phone Number

Costa Mesa, California, United States

Greater Los Angeles Area

Irvine

 Provide 2nd level support 24/7, for both internal and external third-party applications Identify and document system exceptions to identify software bugs and work with developers to provide a permanent solution. Work directly with software development teams to ensure quick resolutions to software issues Coordinate resolution of application issues with end users and developers. Work closely with Developers on production related issues. Wrote and executed SQL queries for reporting and research purposes. Create, monitor and update defects in Team Foundation Server (TFS), JIRA, and KACE ticketing system. Field incoming help requests from end-users via telephone, e-mail and help desk in a timely manner. Work with warehouse staff to correct any customer order issues. Grant and manage permissions for internal and external applications. Monitor website and warehouse systems Warehouse Management System (WMS) and Warehouse Control System (WCS). Wrote and updated process support documentation.

Irvine

 Analyze and interview clients for requirements to determine best approach for configuration, design and implementation. Define and deploy operational requirements and system goals based off of conducted analysis and agreed upon recommendations Prepare and deliver reports, recommendations or alternatives in an effort to streamline processes and improve operational efficiencies Created and executed test plans by identification/generation of test participants Coordinated and collaborated with client representatives, IT analysts and other teams to ensure a successful database implementation for new and existing clients Provide outstanding client support and responding to escalations in a timely manner. This includes asking pertinent questions and gathering relevant information from the client, troubleshooting, root cause analysis and impact analysis combined with identifying and driving the approach to address the issues Compiled internal documentation to keep track of changes to the systemRun configuration reports  Assists in training current staff and new hires as necessary Comply with HIPPA regulations and maintain confidentiality at all times

Greater Los Angeles Area

-Communicate data file requirements to clients' business and technical contacts-Oversee the collection and accuracy of all data files collected from clients-Built, configure, and maintain client web based applications using internal administrative tools-Build and configure all client enrollment forms-Build and maintain custom sites utilizing internal platform resources-Performed continuous quality assurance testing of site configurations and client data-Managed multiple implementations concurrently-Coordinated continuous implementation support -Communicated effectively with both internal and external clients-Created and maintain documentation of current and future processes-Facilitate client trainings of web based applications-Create and maintain Google Analytics profiles and goals

Irvine

 Use professional concepts, implement software in various environments Analyze enhanced requirements and create process documentation, diagrams and feature specifications Analyze customer configurations and think out of the box to resolve issues Understand and configure software interfacing products Research application questions, assist with setting up testing scenarios Follow practices and procedures in analyzing a variety of business situations or data requiring a review of a variety of factors Utilize technical ability to prioritize issues and respond appropriately to multiple critical situations

Los Angeles

 Analyze, organize, and ensure completeness of product implementation on client sites Build, organize, and manage clients’ carrier’s sites during development, staging, and production release phases Maintain direct interaction with Client Service Managers during production releases  Facilitate in providing adequate knowledge transfer through training clients of DRX’s web based platform  Document processes tailored towards certain features/services offered by the client  Validate and facilitate in training client’s and carrier’s plan data

Whittier, California

 Collect and analyze data on the Action Communities for Health Innovation and Environmental Change (A.C.H.I.E.V.E) grant project in partnership with City of La Mirada Manage assessment database in the Community Health Assessment and Group Evaluation (CHANGE) tool kit Assist in identify areas for improvement in the City of La Mirada on the Community Action Plan Order and organize health education materials Create tool box for Walking School Bus (WSB) Program for Whittier Health CenterAssist in creating visual aids in form of poster board.

Orange County, California Area

 Research and analyze evidence-based practices in underserved communities  Research and analyze non-profit hospitals in Orange County from public domains: Office of Statewide Health Planning and Development (OSHPD) and GUIDESTAR - OSHPD: Hospital’s Community Benefit Plans and Community Benefit Reports - GUIDESTAR: Forms 990 Received from IRS Create Community Benefit Programs Among Non-Profit Hospitals in Orange County - Microsoft PowerPoint Organize and scan documents for Healthy for Life Program Data entry - Microsoft Excel - Community Benefit Inventory for Social Accountability (CBISA)-Lyon Software Analyze data for Healthy for Life Program - IBM Statistical Packages for the Social Science (SPSS) software