Subscribe to DSC Newsletter

Walter Earl Roper
  • Bloomington/Champaign Illinois
  • United States
Share on Facebook

Walter Earl Roper's Page

Profile Information

Technical, Consultant
Job Function:
Biostatistics, Finance, SAS
Short Bio:
Bloomington, IL 62702

Home: 309-585-0227

Cell: 309- 660-1646

Email: [email protected]

Business Analyst and I.T professional, with experience in the Financial and Pharmaceutical areas in enterprise environments. Excellent communicator, unique mix of people and technical skills. Strong work ethic, teamwork, leadership skills, flair for innovation with background in people leadership & project management, Emphasis on Mathmatical/Statistical Business/Data Analysis, Database and Data Warehousing, SQL – Triggers/Stored Procedures, BI.


University Consortium involved with the St. Louis RCGA – Regional Commerce and Growth Association

Rensselaer Polytechnic Institute Washington University Florissant Valley College

Master Data Management, Database Modeling, SQL & PL/SQL, Data Warehousing, Data Mining Algorithms.


University of Illinois

- Institute of Electrical and Electronic Engineers - AMSTAT (Stats)

PFIZER Cambridge, MA

Senior Consultant

 Managed development & operation of Oracle/IBM DB2 backend database systems.

 Designed data warehouse to extract key info on compounds & their characteristics for research and market implementation for future Clinical (Pre-Clinical) Trials 1-IV (Survival/Adverse Events - KM) and Adverse Events (Arisg).

 Implemented SAS programs to capture statistics/graphs for univariate and multivariate statistics.

 Statistical breakdown showing patient responses in various phases of drug dosages and SOP's that improve business operation. Assisted CRO's, CRA's & RN's with Data Collection - CRF's

 Achieved 20% speed increase on queries and 15% cost reduction by improving production time through formulated table layouts and analysis and scheduling methodologies with Oracle Discoverer, Informatica, Microstrategy, B.O./Crystal Reports with Data Mining methods.

 Created ER diagrams-table for Oracle/DB2 instances for data querying from various tools such as Business Objects - Crystal Reports, Brio Query, and Access/Excel.

 Managed data, designed database and enhanced performance; delivering applications and business processes aimed at helping clients reduce costs, enhance organizational flexibility, and improve business and IT performance internally and with CRO's using as EDC/Intense Clinical Lab Testing, Pharmacology, Adverse Event Monitoring.

 Performed technical support for Oracle products, including Quest SQL Navigator and Developer 2000
Supported database administrators and technical staff in ODBC setup and SQL connectivity

 Assisted setting up SAS PROCs to enable the completion of highly complex population studies

 Assigned to design forms; write, debug and revise PL/SQL Triggers; and support UNIX connectivity for Biometrics (BLAST)/SAS UNIX users

 Admin for Windows networks, and provided level 2 and 3 technical support of all Pfizer's clinical with such products as B.O. Crystal Rept., COGNOS.

EDS – Electronic Data Systems
Health Division
SED Program TX
Cambridge, MA

Applications Developer / Systems Administrator

 Productively gathered business solution claim information and captured large amounts of complex medical financial claims (risk pools) data to assess rates charges of risk pools saving the HMO about $3 million over a 5+ year period

 Systems Engineer for the database warehouse programmatic updates for statewide Medicare A & B reimbursement claims (principal component of a EDS’s $100 Million contract with BCBSMA) ensuring compliance to SLA requirements that helped avoid thousands of dollars in penalties,.

 Worked with physicians and pharmacist on data warehousing on formularies, ensuring quality control and compliance to state and federal and corporate regulatory controls.

 Presented mathematical and programmatic methods to HMO executives to enable better negotiation of contracts with physicians and clinics regarding Diagnosis using ICD Codes, Claim Processing and rate structures. Assisted accountants in producing a "Financial Results" document for HMO-Blue that accurately outlined its financial status, client risk pools progress within various departments for re-engineering project

 Designed data mining algorithms for extraction of data from the IBM mainframe, as well as providing analysis of hidden trends, financial information, benchmarks, medical claims data and health demographics for the HMO that achieved a four-star rating from HMO-Blue as noted in NEWSWEEK, June 24, 1996, putting it into the Top 20 Rating of HMO's.

SAIC LaJolla, CA

• Systems Engineer in La Jolla and Herndon VA & CT, for U.S. Navy Hospital Research Facilities.

Comment Wall

You need to be a member of AnalyticBridge to add comments!

Join AnalyticBridge

  • No comments yet!

On Data Science Central

© 2020 is a subsidiary and dedicated channel of Data Science Central LLC   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service