Guy Harrison Email & Phone Number

Sacramento, Ca, Us

Sacramento, Ca, Us

Information Services Manager to support SNAHC's clinical applications and business intelligence needs.

Sacramento, Ca, Us

Designed and developed company wide data analysis and reporting solutionsReviewed and analyzed data from multiple internal and external sourcesCommunicated analysis results and recommendations to senior managementDesigned new data collection models to better collect informationPerformed data profiling to identify anomaliesCoordinated with IT department to implement new modelsExtensive ability to acquire data from primary and secondary data sources and maintain databases/data systems.Identified, analyzed, and interpreted trends or patterns in complex data sets.Provided support to teams or management by collecting and analyzing data and reporting results.Ability to organize technical work; demonstrate excellent planning, problem-solving, analysis, documentation, presentation, and organization skills.Attended approved trainings and workshops to stay abreast of emerging and other relevant technologies.Compliant with all state and federal laws and regulations, as they pertain to position including; HIPAA, sexual harassment, Scope of Practice, OSHA etc.Other duties as assigned.

Using some of the best tools available I create dynamic and effective documents to communicate your message. Currently I use InDesign for the page layout (based on need and document size) , Photoshop and Illustrator are used in the creation of the graphical elements of the presentation. MS Word and other office suite applications can also be used, per the customer's request. PowerPoint presentations may also be created as standalone or integrated products.

Saint Louis, Mo, Us

Provide advanced analytical support and development to enable our medical plans take action in their pharmacy and medical formulary as well as negotiate rebates to improve member coverage and lower costs.Utilize a multidisciplinary standardized approach to identify, develop and implement long and short-term strategies in support of health plan financial and other business objectives. In-Scope data areas include medical claims, provider data, member data, clinical data, pharmacy claims, pharmaceutical therapies, and external reporting of Commercial, Exchange, Medicare and Medicaid plansReview data to determine operational impacts and needed actions; elevate issues, trends, areas for improvement and opportunities to managementModel data using MicroStrategy, Business Objects, Teradata, MS Excel, Access, SQL, and/or other data warehouse analytical toolsEnsure compliance with federal and state deliverable reporting requirements by performing data quality auditsActively involved in the leadership of an Employee Inclusion Group Mentorship program

Sacramento, California, Us

In response to an emergent need at SSF, I stepped to assist with support, analysis, and design recommendations for the automation of their core processes in assessing and managing the permanent housing needs of the local homeless population.

Sacramento, Ca, Us

Supported custom MS Access programing to print, label, package, distribute, deliver, bill, credit and mail approximately 2 million papers/periodicals each week Consulted with business users to analyze and gather requirements as part of the Process Reengineering of the paper’s core system. QA testing included documentation of as-is and design-future applications for operational and financial processesSQL, and Access used to profile, convert, and normalize existing data. Per project requirements, Excel functions used to import and prepare compare legacy and converted financial dataQuantify and annotate any differences after conversion processesActed independently, and as a team member, to lead the day-to-day operational functions as well as complete complex technical and analytical activities associated with the production, distribution, management, and financial monitoring of all publications

Linthicum, Md, Us

Provided wide range of analysis, GIS and operational business intelligence, data visualizations, and marketing services in self-directed, matrix structured HIPAA environment. Tools used were Crystal Reports, SQL server, Access, & Excel. Formats included formatted text, monarched PDF, ODBC, dBase, CSV, and unstructured file. Most of these reports required determination of data relationships. Developed 3-5 new reports requests each week, manually produced nearly 4,000 finished and formatted reports each year. Consulted with business users to create Business Objects Crystal Reports and MS-SQL reports, ad hoc and production, and other presentations using normalized, non-normalized, and non-relational data warehouses to meet management, marketing, and compliance requirements as well as RFPs. Outputs were formatted as text, Excel, PDF, PPT Presentations and graphicsDesigned, developed, tested, produced, documentation and reports and other documents for Operations, Compliance, Account Management, Sales, Provider Relations, and Marketing departments. Supported 8K employer groups and 3M covered lives.Using GeoAccess and Quest Analytics, developed GIS provider network reports for accessibility analysis and member utilization.Supported current end user customers as well as prospects by authoring, laying out, and producing professional quality presentations, reports, and training guides. Corporate publications for internal and external audiences. Applications used were Adobe’s InDesign, FrameMaker, Photoshop, Illustrator, Acrobat Pro, and MS Word, Excel, Visio. Improved customer retention by planning, developing, and delivering in-house training of standard Microsoft Office and Business Objects reporting applications to customer service and account management teams.Completed Requirement Analysis with stakeholders, ensuring appropriate development, training, and implementation of reports in cooperative and agile style.

Mclean, Virginia, Us

Managed, Implementations and Data Cleansing department with 2 direct reports. Completed data analysis, conversions, and implementations of student information systems, remotely and on-site. Technologies used included Clarity reports, MS Access and MS SQL queries and database warehouses for data standardization, InfoDriver OLAP data loads, and Oracle Environment.Partnered as a consultant, remotely and locally with business SMEs and end users to capture, analyze, de-dupe, enrich, translate, and document conversion and cleansing requirements from legacy data stores for approximately 200 implementations.Led Fit Gap and Business Process Reengineering of technical, functional, and organizational areas for wide range of school districts nationally, using on-site and remote methodologies. Defined, analyzed, designed, created, and implemented interfaces, moving data easily and efficiently between applications. Primary conversion tools were MS SQL, Access, and Excel, as required.Reduced implementation time 11% by developing policies and procedures and identifying and documenting reporting requirements and interfaces for all ETL, data cleansing, conversion and synchronizations using traditional waterfall and Agile methodologies. Improved processing time from 10-man hours to 10 minutes through development of data structure ETL conversion automation. Developed and presented technical and end-user training curriculum using ADDIE models.

Roseville, California, Us

Provided hardware, network and software support to students and staff in school district. Responsible for extracting, converting and formatting state mandated data elements for STAR testing as well other programs.Hardware and software support of LAN/WANs for a Windows and Apple environment.Standardized configuration, improved setup time by 70%. Established software imaging within district.Designed and created the district’s central web site.Supported administrative computing and student information systems. State compliance reportingResearched, procured, installed, and developed database for proximity security pass system.

Provided training and support to students, staff and faculty of law school. Developed, created and delivered training programs for staff and students.• Reduced Laptop Set-Up time by 80%. Configured desktop and laptop systems. Migrated internal customer systems.• Completed Systems Analysis and Design of a departmental database, • Programmed Access relational database for case tracking. • Assisted in the process design for telephone enrollment of students• Coordinated SupportMagic SQL Help Desk. • Created and taught end-user classes on Windows 95, WordPerfect, and MS PowerPoint to Staff/Faculty members. • Created and managed hands-on Training Lab — 1750 man/hours of training over a 6-week period.• Managed operations, setup, re-imaged systems between sessions, assisted in-class in three computer labs.

Us

Provided sales support, sold and delivered residential and commercial HVAC parts in retail and online environments.• Hardware and software support of LAN/WANs for a Windows and Apple environment.• Standardized configuration, improved setup time by 70%. Established software imaging within district.• Designed and created the district’s central web site.• Supported administrative computing and student information systems. State compliance reporting• Researched, procured, installed, and developed database for proximity security pass system.

Associate Of Arts (A.A.), Computer Information Systems

Health Care It Workforce Training Program, Health Care It Trainer

Certificate, Project Management

Certificate, Technical Communications

Education record