John long resume - April 2014
Download as DOCX, PDF1 like446 views
This document is a resume for John Long listing his experience in managed care information systems. It summarizes his roles as a data analyst contractor for Fresh & Easy Neighborhood Market, MemorialCare Health Foundation, and Inland Empire Health Plan where he provided analytical support, developed procedures to automate processes, administered databases, and designed dashboards and reports. It also lists his experience as a business analyst at Southern California Edison and as a database and reporting analyst at Inter Valley Health Plan where he created customized reports and helped with system conversions.
John long resume - April 2014
- 1. Page 1 of 2 John Long 9146 Timberline LN #M Rancho Cucamonga, CA 91730 909-434-5258 www.linkedin.com/in/johnlong2009 johnlong_2009@yahoo.com Managed Care Information Systems experience Skilled & Experienced Data Analyst MS Access and Excel Expert Customized Dashboard Development Data Validation, Auditing & Trending Specialized in Data Mining and Reporting Ad-Hoc Reporting for Business Decisions Fresh & Easy Neighborhood Market, Inc. Campus Kitchen FinanceData Analyst Contractor 11/201303/2014 Provide analytical & administrative support on all financial data systems. Developed new procedure, which automated nearly 50% of a time critical weekly financial process. Oracle Financials - SQL- PeopleSoft. MemorialCare Health Foundation Functional Analyst Contractor 12/2012 11/2013 Administration and support of MemorialCares EMR Portal (EpicCare Link), and its entire network of Managed Care contracted vendors. Support and train all Site Admins on EMR access, online referral system, navigation, and Epic Tapestry workflow logic. PeopleSoft non-employee administration, including Epic Hyperspace (hybrid) users. Inland Empire Health Plan Application Support Specialist - Contractor 12/2011 11/2012 Comprehensive database management, supporting all Claims department forms, macros, and task automation. Documentation of flow logic to support all work Collaborate with clients to analyze large quantities of data, develop reporting templates, ad-hoc queries, as well as perform data validation and audits. Design or enhance workflow procedures whenever possible, and present documentation with flowcharts to management.
- 2. Page 2 of 2 Redesigned the Configuration Database Issue Log to incorporate decision making logic, automatically assign and route all Issues to the correct department and unit within IEHP. Identified/rewrote all reports associated with this database. Oversaw the successful conversion of all Claims databases during SQL 2008 upgrade. Developed and monitored production batch and ad-hoc jobs as required, ensuring proper functioning and completion of critical business operations. Designed & developed a Configuration Unit Dashboard utilized by management to monitor and track key data from over 9 databases, with independent reports. Work closely with managers and SMEs to scope out project needs and feasibility. Afterwards meet with end users to demonstrate, trains, and solicit feedback. Research specific client requirements to determine wants versus needs. Analyze workflow data, system and reporting specifications to produce desired results. Southern California Edison Business Analyst II- Contractor 06/2011 09/2011 SAP Role Mapping duties for over 18,000 SCE TDBU users. Designed new procedures and formulas for the biweekly data sync, between SAP and Casewise,which produced a 20% reduction in completion time. Ensure all SCE security policies and procedures strictly adhered to and enforced. Inter Valley Health Plan Database & Reporting Analyst 01/1992 - 09/2009 Provided statistical and analytical reports on Capitation, Utilization, Member Services, Provider Services, Pharmacy and Claims data for internal users. Consistent history of quickly and accurately producing results as directed. Designed screen and report layouts customized for each users department using FACETS data and Crystal Reports/Business Objects. Served vital role in the FACETS reporting (v4.41) conversion project, by redesigning and eliminating redundant existing business reports utilizing Business Objects XI. Highly Skilled with MS Access, Excel (2000-2013), PowerPoint Visio, Project, Crystal Reports, SAP Business Objects XI, VMware, SharePoint, and SQL Server 2008 R2. Designed, and managed the Operations Departments Help Desk software. Integrated results into departments Process Improvement Database. Education: CLC, Anaheim CA Mainframe Computer Operations & Management