OLGA KOVCHEGOVA 917-***-**** (cell); udv981@r.postjobfree.com udv981@r.postjobfree.com

SUMMARY: Programmer and Statistician with extensive and strong background. Experienced in Programming Mathematics Statistics Modeling. 17 years in SAS. SOFTWARE: SAS Base SAS Macro SAS STAT SAS Graph SQL C dBase IV Paradox/PAL Excel HTML WINDOWS UNIX shell scripting MVS/TSO/JCL

EXPERIENCE:

February 2004 present Project Manager ARK Statistical Consulting LLC (SAS Base Macro SQL Excel HTML)

Provide consultations in statistical analysis modeling and SAS programming. Created designed and developed

algorithms for automation modeling on PC. Developed Automatic Systems for Modeling that create models and scoring programs (SAS/ PC). Assignments completed:

Provided programming and analytical services to BANK OF AMERICA MERRILL LYNCH

- Developed method formulas algorithm and programs for Liability and Equity Expense Reports preparations corresponding to FAS123R rules; used the Theory of Probability and Calculus to get proper formulas of Forfeiture Rate Discount Factor and various adjustments. Design write and test macros and programs to automate process of financial reporting. Wrote macros to automate cancellations accelerations and exercises calculations. For cases when proc import not able to import data properly wrote program-generator to generate programs for proper reading CSV files as comma delimited. Wrote programs for automatic consistency check of conditions and other tables. Wrote macros and programs to transform Expense Forecasting DTA EPS dilution and A240 reports. Prepared methodological documentations wrote proposals prepared documentation of final product. Provided consultations in SAS and Statistics. (SAS Enterprise Guide SAS Base SAS Macros SQL SAS IML ODS Excel MS Word);

- Provided modeling and programming services to BANK OF AMERICA. Created models. Applied logistic regression Chi Square and other statistical tests. Wrote programs of data organization. Participated in Customer Risk Balance Transfer & BT Gamer projects. Mapped Consumer to Small Business variables.

(SAS Base SAS Macro STAT SAS SQL and DB2 SQL TERADATA ETL ODS UNIX)

Provided programming and analytical services to THOMSON REUTERS (THOMSON MEDSTAT)

- Participated in CMS MIC project. Audit corrected and rewrote programs for investigation of errors or fraud in

pharmaceutical Medicaid claims. (SAS Base SAS Macro SAS SQL Oracle PL/SQL)

- Participated in IHA (Integrated Healthcare Association) project P4P ( Pay-For-Performance) and CMS project BQI (Better Quality Information). Wrote program- generator which reads standard Cobol layout and writes SAS programs for data reading. Designed and developed multiple programs of Data Quality Control (automatic and deep QC) and Data Completeness Check. Analyzed data completed Data Reviews designed changes into Quality Control process and Data Review forms. Wrote programs of HEDIS measures calculation and DCG input files creation for Relative Risk calculation. Designed and developed library of macros and reporting system to produce combine reports of various nature multiple statistics over Health Plans and Provider Organizations.

(SAS Base SAS Macro SAS STAT Excel Windows XP SAS SQL ETL ODS)

Provided programming and analytical services to AMERICAN EXPRESS

- Wrote SAS programs and Unix scripts. Increased efficiency improved utilization convenience and prepared to production a large system of programs for assembling data and multiple models scoring. Created method of missing information finding and restoration by iterative search of unique identifiers. Designed and developed macros and programs of automatic restoration award industry classification information according to this method.

- Re-designed and developed list management and suppression management systems. Wrote programs for statistical analysis and visualization of list- and suppression- codes dynamics over campaigns. Wrote SAS programs and Unix scripts. Applied Spearman and other statistical tests. Wrote and ran programs for campaign management for mailing lists creation. (SAS Base SAS Macro SAS STAT SAS SQL ETL ODS Unix Windows XP)

Provided programming and analytical services to Health Services Advisory Group (HSAG).

Developed programs of statistical analysis reporting data mining and sampling. Responsible for analysis and reporting of the Federal projects (task 1a Secondary Prevention of Osteoporosis Decease Nursing Homes; task 1c Hospitals); participated in State/Regional projects. Conducted deep analyses of CMS documentation; discovered issues. Designed and developed convenient methodic of classification hospitals based on their Appropriate Care Measure and composite measures performance. Wrote macros for Macro Library wrote macro of automatic Quality Control. Applied cluster analysis Student and other statistical tests. (SAS Base Macro SAS Graph SQL Excel)

Provided programming and analytical services to ROYAL HEALTH CARE. Wrote programs for HEDIS

measures calculation and reporting. Created Program Generator: the program which writes programs for creation

Utilization Management and Case Management SAS Data Warehouses by reading flat files of various layouts

into SAS Data sets. Implemented wide range of HEDIS and ad-hoc projects. (SAS Base Macro SQL Excel HTML)

June 00 Jan 04 Senior Programmer Analyst Marketing Information Technology / Experian Marketing Solutions

(SAS BASE SAS Macro Statistics SAS SQL SYNCSORT MW300 TSO/MVS/ISPF/JCL)

* Responsibilities included algorithm and program development statistical analysis and modeling.

Implemented a wide range of programs and projects for America On Line American Express Microsoft

Pitney Bowes Guinness CBA Media Diageo and others. Wrote programs with complex logic used advanced

macros. Wrote programs for direct- and telemarketing campaigns lists creation. Developed macro subroutines for

Library of Statistical Macros. Developed programs of statistical analysis modeling segmentation and reporting.

Applied linear and logistic regression Chi Square and other statistical tests. Developed programs of data

splitting by iterative application of Kolmogorov-Smirnov test and confidence interval test. Designed program of

automatic implementation of statistical analysis reformatting and regression after the very first step ( CHI s).

April 98 June 00 Senior Programmer Analyst NYU Medical Center MIS department

(SAS BASE SAS Macro Statistics VSAM MVS/TSO/ISPF/JCL WINDOWS)

* Responsibilities included algorithm and program development project management and implementation. Developed a wide range of SAS programs in order to produce reports and files with patient medical demographic physician insurance account billing and payment information.

* Developed a system of programs in order to get information from a wide range of VSAM files (PBAR) and

create files with the information for Decision Support System (TSI).

* Created and wrote module in SAS developed convenient interface for Y2K compliance of SAS programs. Developed macro functions in order to replace SAS informats for reading date information from files of

American Health Ware System (Eagle 2000). Revised programs for Y2K compliance.

August 96 - April 98 Assistant Manager in Statistical Analysis HIP Health Plan of New York

Medical Economics & Data Analysis division.

(SAS BASE SAS Macro Statistics MVS/TSO/ISPF/JCL WINDOWS)

* Responsibilities included project management and implementation; data investigation and statistical analysis; algorithm and program development; providing consultation and support in SAS Statistics algorithm and program development to the staff of the Medical Economics and Data Analysis Department.

* Provided statistical analysis for long term Quality Improvement studies "Mammograms" "Diabetes" and "Non-users" for NCQA. Created programs to produce various kinds of enrollment reports.

Wrote programs with complex logic in order to get proper information from heavy coded eligibility file.

* Developed programs for HEDIS measures calculation and reporting.

* Participated in a wide range of projects with purpose to investigate analyze and solve problems organize and store information and to produce reports such as "Immunization" "Medicare" "Benefits and co-payment" "Population Assessment" "Re-credentialling" Physician Profile "Monthly Membership Files" etc.

* Used various statistical methods and tests: analysis of variance linear and logistic

regressions survival analysis t-test z-test chi square direct and indirect adjustment.

* Managed projects wrote proposals prepared documentation for final product.

November 95 - August 96 Programmer/Analyst Comp-U-Card International Stamford CT

(SAS BASE SAS Macro SAS SCL SAS SQL C /Unix MVS/TSO/ISPF/JCL WINDOWS)

* Implemented projects for Citibank Chase Manhattan Bank First USA AT&T

First Card MBNA America Sears Amoco Oil Texaco Oil HSN ATV.

* Wrote programs of statistical analysis and data preparation. Used statistical methods and procedures for

analysis and data validation. Developed algorithms and programs for calculation distances between

observations of vendor and customer files using corresponding latitudes/longitudes and for analysis

and selection based on these distances.

August 95 - November 95 Consultant Information Technology Partners New York

(Paradox PAL MS DOS)

* Developed applications wrote debugged and tested scripts procedures made queries

forms and reports to provide services for Eastbourne Loss Prevention Inc.

Developed and installed loss prevention systems for Bon Marche (Seattle WA) and

Macy's (Newark NJ). Revised system for Macy's (CA).

May 93 August 95 Programmer Albert Einstein College of Medicine Department of Epidemiology NY

(SAS dBASE IV Paradox PAL Paradox for WINDOWS Object PAL)

* Wrote programs of statistical analysis and FDA reporting.

Participated in HAPI and Kidney Stone Blood Pressure studies.

Designed and developed applications for data entry and data management;

* Acted as database manager.

EDUCATION: Master's degree in Mathematics M. V. Lomonosov Moscow State University Russia

PUBLICATIONS: 4 research papers in Statistics and its application published in USA.

UNITED STATES CITIZEN

Contact this candidate