James Warren

Assignment at Arkansas BlueCross BlueShield in Little Rock, AR, for Stratice Consulting  Earnest in learning existing legacy processes, specific insurance sources health plans information, etc., within ABCBS, in EBI Systems & Informatics – Special Projects: a team of onsite and offshore colleagues of programmers all of whom were from India/South Asia  Used SAS PROC SQL Pass-Through Facility and coding for accessing, processing and manipulating data tables and views directly via DB2 DWH database(s)  Assigned to and completed comparison testing and associated research on ad-hocs and projects, including for CPC+ (Comprehensive Primary Care Plus) data analysis and automation development for reporting  Worked for the first time with SAS Stored Processes (STP) and Stored Process portals, and with managed care plans data  Used Base SAS (with Windows SAS Enterprise Guide and Windows SAS 9.4 versions), SAS Macro variables (including with SAS date functions) and some SAS Output Delivery System (ODS) in automating batch coding and results including providing such reporting for federal contract FEP customer service support department  Cooperated with offshore members of our SAS team, and onsite with and under our SAS team lead, Shilpa Kamtekar

 Transformed administrative health care claims and eligibility records into datasets and some reports  Processed with reporting on private payer, self-insured, commercial health care data within the course of normal duties  Used Base SAS (Windows SAS Enterprise Guide (EG), and OpenVMS versions), SAS Macro variables (including with SAS date functions) and some SAS Output Delivery System (ODS) in producing coding and results  Utilized ICD-9/10 Diagnosis, ICD-9/10 Procedure, CPT, HCPCS, NDC, Revenue and other such medical codes  Collaborated with HealthSCOPE Benefits staff, clients, brokers, PBMs and vendors to develop and help ensure clear understanding of requirements associated with service requests and projects; worked under the leadership of BJ Canada, Director, Data Quality  Developed, moved, improved and implemented SAS programs with projects  Recommended procedural and data flow changes to increase the accuracy, effectiveness, and efficiency of products and services delivered by the IT Development team  Automation and documentation of programs and coding output

Assignment at HealthSCOPE Benefits in Little Rock, AR, for TEKsystems  Self-motivated in learning the contract company's specific, enterprise industry knowledge and existing legacy production processes; coded and navigated in, and imported from, HealthAxis unidata into MS Excel and SAS for reports and loading  Proposed and developed new approaches and ideas to integrate complex source data into more industry-standard production processes  Used Base SAS (Windows SAS Enterprise Guide (EG), and OpenVMS versions), SAS Macro variables (including with SAS date functions) and some SAS Output Delivery System (ODS) in producing coding and results  Utilized ICD-9/10 Diagnosis, ICD-9/10 Procedure, CPT, HCPCS, NDC, Revenue and other such medical codes  Collaborated with contract assignment company staff, clients, brokers, PBMs and vendors to ensure clear understanding of requirements associated with service requests and projects

 Programmed using Base SAS (PC Windows and Unix/Linux versions), SAS Macro libraries and some SAS Output Delivery System (ODS) specifically in producing coding, data analytic programs and results for Arkansas Payment Improvement Initiatives (APII) Patient Centered Medical Home (PCMH) releases reports, additional tasks as assigned and ad-hocs  Programmed using SAS PROC SQL Pass-Through Facility (explicit and implicit) for efficiently accessing and processing data directly via Oracle database  Researched and applied in programming in SAS utilizing HEDIS, ICD-9/10 Diagnosis, ICD-9/10 Procedure, CPT, HCPCS, NDC, Revenue and other such medical codes  Engaged and worked with team and division, as well as with contractors, consultants and customers, serving as a key team member, advocate for innovation, and knowledge-matter resource  Identified and resolved technical issues through problem solving, research and analysis with team, as a primary resource  Used and shared technical knowledge with the team, plus built subject matter knowledge and skills with customer data  Mentored and helped newer hires and other team members  Proactively updated and communicated status with manager

 Supported account team with SAS programs and SQL scripts to perform production processes per requirements, developing and incorporating improvements  Used and learned Oracle PL/SQL: developed scripts for aggregating huge volumes of online data into manageable structures, lending itself to insights through reporting for analytics  Used SAS Macro libraries and some SAS Output Delivery System (ODS) coding specifically in the list management, credit card portfolio marketing campaigns on-site with the client in Wilmington, DE  Used SAS PROC SQL Pass-Through Facility (explicit and implicit) for efficiently accessing, processing and manipulating data directly on Oracle database(s) and Teradata data warehouse  Used SAS Macro language programming extensively to make programs more secure with parameterization and automation in production  Participated in the automation and development of custom applications  Provided client with results and analysis from requested ad-hoc queries  Used and learned Tableau Software, acting as both a Tableau user and administrator, for reporting and analytics being referenced by the client

 Researched and worked on quantitative projects using SAS to produce reports for default servicing operations  Used SAS/CONNECT inc. with PROC UPLOAD and PROC DOWNLOAD to access and modify programs in the shared environment; some SAS/ACCESS OLE/ODBC methods used as well  Used SAS ODS coding for some reports, applications, and other tools developed for the business  Used Base SAS and began to really use SAS Macro language  Provided clients of supported business units with results and analysis from requested ad-hoc queries  Met with internal customers to clarify and develop business needs into specifications requirements, and then coded programs for computing jobs; modified existing programs as necessary

Coordinated processes, standards, and procedures to ensure service level stability with Problem/Change Management. Chaired daily bridge calls.  Successfully transitioned into private sector; learned position for Little Rock and Chicago  Selected to relocate after first year for FIS STC Certegy integration Systems Assurance Team Lead and Training:  Served as key resource for 100+ staff across various FIS departments/locations  Adapted Certegy to FIS technology; improved efficiency/effectiveness of information access and documentation

Mentored and promoted by John Fortney, PhD, recognized national leader in rural health services research and former Director/Department of Health Services Research, Psychiatry, UAMS.  Used Base SAS for many years on important reports and projects; became very proficient with it • Utilized and converted source data to SAS data sets for Analysis using SAS/STAT procedures  Retrieved data from flat files, and extracted data from database(s) using SAS PROC SQL and other procedures  Used SAS/ACCESS to interface with the data sources via OLE and ODBC Programmer Coordinator:  Awarded additional role in 2001; organized and led statistical and database programmers as a working group  Convened group meetings; served as a programmers' advocate and facilitator between faculty and programmers  Conducted programmer recruitment and coordinated annual evaluations  Consulted with/sought out SAS users groups to research best practices; attended 2004 SAS Users Group International Conference  Created Programming Standards and Tips database cooperatively with team Training:  Coached several employees one-on-one in SAS and related tasks, etc.; led group trainings of 15-20 including staff and PhD/MD primary researchers  Created and compiled curriculum/materials for various trainings of two hours to months in length Project Management:  Participated in evaluation of highly visible Department of Veterans Affairs(VA) clinics location/access program outcomes/objectives  Assisted in research, programming, analysis, and presentation of grant funded studies concerning access, delivery, and effectiveness of mental health care throughout Arkansas, regionally, and nationally  Administered the development of several VA projects and day-to-day accumulation and maintenance of associated, necessary data