Quality Assurance Data

Yuri Abashkin

Frederick, MD *****

E-mail: abkanr@r.postjobfree.com

SUMMARY: Ph.D., Oracle Certified Professional(OCP), Microsoft Certified

Technology Specialist(MCTS), 15+ years of IT experience with the 7 last

years emphasizing Data Management and Data Analysis that involve the

planning, development, implementation, and administration of systems for

the acquisition, storage, and retrieval of data and data interpretation.

Creative problem solver with the ability to multitask effectively and to

play multiple roles on a project. Working experience in

scientific/biomedical/health care environment.

OBJECTIVE: Challenging, creative position - Data Architect, Data Manager,

Data Modeler/ Data Warehouse Analyst/DBA - in data management and analysis

that would allow me to fully utilize my background and enhance my skills

for benefits of the company/Government agency.

EDUCATION:

Ph.D. in Physico-Mathematical Sciences, Moscow State University, Russia

M.S. in Engineering Physics, Moscow Physical Technical Institute, Russia

CERTIFICATIONS:

Oracle:

. Oracle Certified Professional(OCP): Oracle Database 11g Administrator

. Oracle Certified Professional(OCP): Oracle Database 10g Administrator

. Oracle Certified Associate(OCA): Oracle PL/SQL Developer

. Oracle Certified Associate(OCA): Oracle Application Server 10g

Administrator

Microsoft:

. Microsoft Certified Technology Specialist (MCTS): SQL Server 2008

Business Intelligence Development and Maintenance

. Microsoft Certified Technology Specialist (MCTS): SQL Server 2005

Implementation and Maintenance

Other courses:

. Pursuing PMP certification: "Project Management Essentials"(14

credits), "Advanced Project Management"(14 Credits), Project

Management Institute, MD

. "Oracle 10g: Database Administration Workshop II", Montgomery

College Information Technology Institute, MD

PROFFESIONAL SKILLS:

. Translating business/IT/scientific objectives into technological

solutions.

. Databases: Oracle (9i, 10g, 11g), SQL Server ( 2005, 2008);

. Data Warehouses: Knowledge of various data warehouse systems and

architectures;

MS Business Intelligence Development Studio (BIDS); Proclarity

software as a reporting tool for multidimensional databases (Cubes);

. Operating Systems and Servers: UNIX(AIX, Solaris, Linux ), Windows

Legacy /XP/Server 2003, Apache Server;

. Programming: SQL, PL/SQL, PHP, HTML, Fortran, exposure to object-

oriented programming (OOP)

. Related Tools and Techniques:

. Oracle SQL Developer, Schemester, Oracle Enterprise Manager (OEM),

TOAD, OEM Grid Control;

. Oracle Backup and recovery (RMAN, Flashback, Export/Import);

. Oracle Tuning (AWR, ADDM, StatsPack, OEM advisors), Data Loading,

DBCA;

. Familiarity with Oracle Database High Availability Solutions: Data

Guard, RAC, Oracle Replication (Streams);

. MS OfficeSuite 2003/2007: Outlook, Word, Excel, Access, PowerPoint,

Visio. Microsoft SharePoint;

. Installation: Oracle 10g, 11g; SQL Server 2005, 2008, MS Visual Studio

2008;

. Installation and configuration: Oracle Application Server 10g

including infrastructure components and some middle-tier components;

. Migration Oracle 9i > 10g>11g; MS SQL 2005 > Oracle 10g;

. Proven written skills in presentations of the results of data

analyses: summary reports, graphs, statements, documentation, manuals,

tutorials;

. Section 508, HIPAA compliance awareness. Experience working with HCPCS

and ICD coding.

EXPERIENCE:

. 12/2009 - Present US Department of Veterans Affairs, Veterans Health

Administration Central Office (on-site Federal contractor),

Washington, DC - Data Warehouse Analyst/Modeler

Maintain relationships with customers with diverse needs. Work closely

with Veterans Affairs (VA) Central Office team managing and monitoring

VA databases, ensuring quality assurance and performing data analysis

required to answer specific administrative management and clinical

outcome questions;

Use Integration Services (SSIS), Analytic Services (SSAS) of MS

Business Intelligence Development Studio (BIDS) and Reporting Services

of Proclarity software to develop Data Marts, multidimensional

databases (Cubes) and, consequently, Data Warehouse solutions for a

number of Veterans Health Administration (VHA) related projects that

facilitate and speed up data retrieval and data analysis;

Conduct ad hoc queries against large data sets of VHA National Data

Systems as requested by Congress and other oversight bodies.

. 2004 - 08/2009 Advanced Biomedical Computing Center, SAIC, National

Cancer Institute, Frederick, MD - Development DBA/Staff Scientist

Database design, development and implementation (user requirements,

logical and physical design, resource and capacity planning,

milestones and timetable, implementation in Unix and Windows

environments);

Managing and monitoring Oracle 10g, 11g and MS SQL 2005 databases,

data quality assurance, data security;

Conducting data analyses and interpretations; preparing reports,

documentation, manuals;

Databases tuning, migration/upgrading Oracle version (including VLDB),

backup, data transfer/loading;

Database/data migration between different servers and platforms;

Design of data gathering instruments, development and implementation

of customer database PHP loaders;

Development and implementation of dynamic web-based tools/interfaces

for databases;

Consulting staff in using various application tools for database

developing and monitoring;

. 1996 - 2004 Computational group of Advanced Biomedical Computing

Center, SAIC, National Cancer Institute, Frederick, MD - Scientist

II/ Associate Scientist

Analysis of various statistical and biochemical software packages and

computational methodologies with the aim to provide recommendations to

the management and end users. Beta testing of the software.

Development, implementation and application of various programming

packages to model reactivity of biological systems. Fortran, C, C++

programming on supercomputer servers (Cray, SGI systems). The results

are reflected in number of publications and presentations.

. 1993-1996 Structural Biochemistry Program, Biomedical Supercomputing

Center, PRI/DynCorp, National Cancer Institute, Frederick, MD -

Visiting Scientist.

Calculation of various statistical and structural properties of model

biological systems using a number of computational tools.

MAIN ACCOMPLISHMENTS AS A PROJECT/TEAM LEADER:

. Tracking system of medical electronic consult clones for prosthetic

patients/clients was created based on the corporate data warehouse

with the aim to monitor timeliness of the patient requests;

. A data warehouse was developed and implemented for analysis and data

mining of clothing allowances for Veterans. The data warehouse is used

as an element of fraud prevention system in distribution of the

government benefits;

. Conducting ad hoc queries against a number of VHA National Data

Systems: a) Corporate Data Warehouse (MS SQL based), b) National

Prosthetic Patient Database (MS SQL based), c) Vital Status Data Sets

that contain scrambled and real SSN (SAS format on an IBM S/390

mainframe with z/OS operating system)).

. System Development Life Cycle (SDLC) of Image database for mouse

cancer project. The research project includes planning, analysis,

design, implementation of the database, interface and loader,

maintenance and customer training;

. Database for HIV drug structure and properties (consulting,

implementation, data integrity). The database is used to answer

administrative, pharmacokinetic and clinical outcome questions;

. Data mining of chemical databases for optimal fluorescence molecular

properties in support of the biomedical nanoprobe project.

Contact this candidate