WALTER EARL ROPER

Bloomington, IL 62702

Home: 309-585-0227 Cell: 309- 660-1646 Email:

Candidate Profile:

Enterprise Data Analyst/Project Manager in the Medical/Clinical Systems & Business/Financial & space.I.T. Businesss Intelligence professional, excellent communicator wth Project Management Skills.Unique mix of people and technical skills.Strong work ethic,teamwork, leadership skills, flair for innovation with background in people leadershipproject management, Emphasis on Mathematical/Statistical SAS Business/Data Analysis, Database and Data Warehousing, BI.

GRADUATE SCHOOL 2004-2007

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

Rensselaer Polytechnic Institute WashingtonUniversity FlorissantValleyCollege

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

EDUCATIONASSOCIATIONS

University of Illinois – BA in Organizational/Political Science

- American Chem. Society - AMSTAT (Stats)- IEEE

Graduate Studies at University of Missouri at St. Louis’s HPC, SIU and under the direction of Prof. Robert Palank, Washington University School of Medicine, Researcher & St LCC. Focus has been from Project Management and Organizational/Business Needs to cost-saving, new interdisciplinary studies such as Bioinfomatics, SAS, Oracle/DB2, SQL Server, Chemistry, Bio, Data Mining, B.I - Crystal Reports, Java Programming in Visual Studio and Java SUN to Data Warehousing. With Washington University Staff worked on Molecular Biology Project, Biological Data Resources, Handling Nucleotide Sequences, DNA Sequence Analysis, EST's, SWISS-PROT, Entrez Gene, Single Protein Sequence Analysis, Molecular Modeling Visualization and Simulation and Phylogenic trees. Special focus on Compound Discovery.

Work has included CISCO Training and HPC (High Performance Computing) in cluster, statistical and visual computing with Los Alamos Labs, Intel and Dell Systems. Trained on migration to Informatica PowerCenter and Datamapper Exeros. Utilized for several weeks Informatica PowerCenter and Unix (ksh shells & VMWARE).

SKILLS:

Business:

MDM, Six Sigma, Project Management - SDLC/Object Orientation & Procedural, Object Oriented Technologies; Legal Research & Writing, Statistics; Financial Medical Claims & Annuties - 401(k).SAS, Regression testing, Probability & Statistics, Probability, Methods of Applied Statistics Statistical Techniques for Prediction and Data Mining, Discrete Mathematics, Forecasting, Bayesian Statistics.

Platforms & Languages: JAVA/XML; .NET, Visual Studio; SQL Server, Perl, JavaScript;, Linux, MVS

Programming Tools:

.NET, MOM, SQL; PL/SQL; TOAD; Oracle; Access, OLAP; ETL; Crystal Reports/Analytics Microstrategy; ODBC - Oracle Training in 8, 9, 10g, Access & SQL Server; DB2; SQL/VSAM - IDCAMS - Flat Files & datasets and Kimball vs. Inmon Data warehousing.

Software:

.NET, SQL ADS/DHCP, SAS, SAS/ACCESS, SAS STAT, GRAPH, MACRO/Programming; Data Structures. Assembled & maintained large data warehouse on an IBM pSeries & DB2/Windows 2003/IIs/Visual Studio/Oracle running on a Linux platform for major university system

CAREER JOURNAL

Gourmet Express Bloomington, IL

2008 – Present

  • Actively involved in Production Quality Control & extensive testing, statistical analysis of palletization statistics for products on Wal-Mart and Aldi Accounts on IBM MVS Mainframe/MS-SQL Servers. Statistical Data compiled directly led to setting an all time production record of 14,000 cases of product for customers. Staged and implemented using MATRIX (Allen-Bradley) embedded computer system using .NET/C++ via laptop to prepare thousands of pounds of various ingredients necessary for company’s on-time delivery of various frozen food products.

Hartford Life Hartford, CT

2002-2003Database & Application Consultant

  • Administered database testing, customization and management of data feeds for major insurance firm providing and selling insurance products through a large, complex network of a $400Million 401 (k) Plan.
  • Enhanced user interface SQL Server, NET, ASP.NET/C++ Visual Studio for 401(k), regaining status on Dalbar Website Ratings w/Ins. Sites
  • Performed statistical analysis of comparative financial data and adhoc queries against Oracle/SQL Server database for regression testing and data validation using SAS, B.O. - Crystal Reports.

PFIZER Cambridge, MA

1996 - 2002Senior Consultant

  • 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, Oncology, Pharmacology, Adverse Event Monitoring.

  • Managed development & operation of Oracle/IBM DB2/NT Servers 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.
  • 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, Boston, Cambridge, MA

1991 – 1996Applications 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 regulatorycontrols.
  • 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 financial status, client risk pools progress in 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 Science Applications International Corporation LaJolla, CA

1999-2000

Systems Engineer – all platforms - in LaJolla and Herndon VA & CT, for U.S. Navy Hospital Research Facilities.

1