SUSAN MORRISON (214)299-4770-H

srdmorrison@gmail.com

Technology| Profitable Business & Program Development | Strategic Planning Research & Analysis | Healthcare Advocacy |MLM| Complex Problem Solving | Methodology & Process Improvement

HIGHLIGHTS

Focused analyst that consistently demonstrates expertise in the ability to extract requirements from project stake holders in Medicaid and Medicare health programs for the purpose of identifying challenges and automating choke points in business processes. Analytical mindset that challenges and automates varying systems in business processes.

Experienced professional with business development experience in supporting a wide range of strategic planning by research and analysis of complex problems and implementing profitable programs and methodologies.

Proven ability to analyze complex problems and implement profitable programs and methodologies using a wide range of strategic planning and business development experience

Healthcare advocate that possesses clinical knowledge of Behavioral Health Care, Intellectual Disabilities, and Medical business processes which enables the ability to expedite business processes.

Exceptional Communication Skills with the proven ability to communicate between both the technical and business community bridging the gap in creating exceptional business solutions.

EXPERIENCE

UT Southwestern Medical CenterBusiness Database Analyst May 2014 – May, 2016 Highlight and cleanse data by performing database ETL of data from epic SQL Server EPIC system to oracle star schema

data warehouse and into MS Excel spreadsheets and SSRS reports. This enabled physicians and researchers to make additionally effective business decisions and answered healthcare questions.

Contributed and participated in milestone reporting meetings with lead investigator for clinical research team and in research group meetings to develop studies to reduce for ALS, obesity and breast cancer to improve healthcare outcomes.

Developed standard operating procedures to aid with functional and technical requirements for improving customer satisfaction to better meet their goals.

Created detailed descriptions of user needs, program functions and steps required to develop and modify database SQL to automate and improve processes for efficiency.

Created test plans for SQL development for error reduction. Updated Training on ICD-10 coding system to prepare to enhance and transition reporting.

Molina HealthcareHealthcare Analyst November 2012 – May 2014 Led, created, and analyzed areas of impact for ICD-10 conversion to improve accuracy of reporting and meet new

guideline requirements and allow Molina to meet new coding standards. Retrieve data from integrated reporting repository using T-SQL to develop reports on cases such as invalid diagnoses,

CPT and ICD-9 trends, member enrollment provider network status, and medical claims reports for use of economic forecasting and planning on Trizetto QNXT 4.81 platform for Medicaid and Medicare claims that would enhance business decisions.

Created, updated and presented monthly utilization reports for senior management. Tracked and analyzed monthly Key performance indicators for benchmarking, trends and variable compensation purposes

Create unit and system integration testing plan for team of 11 analysts in San Antonio and Dallas cities to remove errors on implementation.

MHMR of Tarrant CountyBusiness Analyst • US November 2011 – November 2012 Reviewed, analyzed and evaluate existing business systems, processes and data structures for improvement to install a

new CMS system that would improve processes and increase accuracy of medical processes. Developed, supported reporting needs in Crystal Reports 2011 to assist staff in making better decisions. Wrote detailed descriptions of existing data structures and created data models and data maps to accelerate

processes of business systems. Designed and support information technology procedures with respect to functional and technical requirements by

refining details and removing bottlenecks in customer needs. Wrote detailed descriptions of user needs, program functions and steps required to develop and modify computer

programs to automate processes.

RNA Health Information SystemsBusiness Data Analyst • US August 2009 – May 2010 Analyzed and supported pharmacy system needs, troubleshooting software and hardware system problems for

accuracy. Analyzed and modified pharmacy store or sale data items for pricing. Analyzed and resolved correct CPT and Diagnosis code errors for claims processing with pharmacies processing with

TRICARE and other insurance companies. Gathered Requirements, wrote programs and implemented system modifications on UNIX and Windows

pharmacy systems. Deliver reports of system updates.

Wellness Intl*Business Programmer/Data Analyst • US January 2004 – February 2009 Provided analysis and support for all of multilevel marketing(MLM) company systems of order entry, shipping,

returns, distributor support and reporting in ACUCOBOL, HTML, SQL, MS Word, MS EXCEL and UNIX. Maintained problem tracking in Access database for system support. Migrated and maintained Business Objects universes and reports. Delivered SQL reports to users in EXCEL to assist in management reporting and downloaded access data and imported

into Excel for reporting to management and users. Created test plans and performed unit and system testing for my projects and assisted with testing of team member's

projects. Improved reporting efficiency for reporting visualization by converting COBOL reports to Crystal reports in visual

studio for use in web reporting. Analyzed incoming UPS shipping data for load to SQL Server 2008 Database for archiving or processing of incoming

and outgoing data and management reports. Gathered client requirements, business needs and project objectives, via feedback sessions and client input.

SunTrust BankBusiness Analyst • US August 2003 – Dec, 2003 Created test plans and tracked performance test against live data. Constructed FrontPage launch page for trend reporting. Constructed product loan and deposit reports in Webfocus 5.21 against DB2 tables. Create a MRE environments for webfocus. Gathered Requirements, wrote programs and implemented system modifications on UNIX and Windows pharmacy

systems. Deliver reports of system updates.

Texas InstrumentsAnalyst/Programmer/ Tester • US January 1993 – March 2003 Added order comment enhancement capacity to batch and online EDI Order Entry System with screen updates

capability against DB2 data in IMS environment on a MVS system. Reduced order confusion by 60%. Built, tested, installed, maintained and supported 500 graphical web based reports that updated weekly in Business

Objects following full SDLC procedure and on an Oracle platform.

Developed and manually coded FOCUS reports to be web enabled allowing them to be reviewed as flat reports on the mainframe as well as manually enhanced graphical HTML reports on the web

Regularly peer audited projects for installation per SEI requirements. This included standard assessment for error checking routines, JCL standardization, code and installation signoff approval. Reduced failure of batch and online job failure by 60%. It also provided a 30% recovery improvement by ensuring the documentation of all enhancements in each system module.

Created/Updated HTML for Business Objects reports

SKILLS

T-SQL, PL/SQL, CMMI Waterfall and Agile SDLC, Business Objects, Crystal Reports XI, SQL Server 2012, UNIX/Linux, MS Excel, MS Word, MS Access, MS PowerPoint, HTML FrontPage, MVS, TSO, ISPF, ACUCOBOL COBOL, COBOL II, FLEXGEN, Expeditor FOCUS, JCL, SPUFI Fileaid, QNEXT 5 1, SSRS AbendAid, IDCAMS, MS Project, WEBFOCUS, MRE, Lotus Notes MS VISIO, VB net, Redcap, I2B2, SharePoint, UNIX, Tableau training, data mining training, and PC SAS

EDUCATION

Amberton UniversityMaster of Science Managerial Science In Progress Amberton University Dallas, TX Master of Science, Managerial Science

Southern UniversityBachelor of Science MIS 1987 - 1992 Southern University Baton Rouge, LA. Bachelor of Science, MIS

PERSONAL INTERESTS

CPR, First Aid, and AED (American Red Cross) May 2014 Troop Leader, Girl Scouts of America (GSA) August, 2012 - May, 2013 Christian Education Instructor, August 2012 - September 2014