Mersedeh M. Arvaneh

***** **** **** **.

Tampa, FL 33647

Phone: 813-***-**** Cell: 949-***-****

E-Mail: ablh6d@r.postjobfree.com

U.S.Citizen

Skills

* 5+ years working experience in Manufacturing (Behr Process Corp. /Masco &

Allergan Manufacturing facility)

* Relational Database modeling, normalization, design, tuning and

development expert

* Microsoft Office Products (Project, Excel, ACCESS, Power Point & Outlook)

* Taught Microsoft ACCESS, MS EXCEL, Crystal Report & MS-SQL to different

Client such as ALLERGAN R & D

* Microsoft Project 2003 (worked on more than 10 projects)

* Microsoft Visio 2003 (designed more than 20 business-flowcharts, reverse-

engineered many databases

* Microsoft SQL Express, Microsoft SQL 2005 (Certified MCDBA via Chapman

University)

* Crystal Report, SQL report and ACCESS reporting expert

* Regulatory/ Compliance Expert

* IT SOP Technical Writer

Summary of Qualifications

* Excellent working knowledge of Microsoft ACCESS as database back-end and

front-end, Import/Export from/to ACCESS, ACCESS report writing, ACCESS

query designer, ODBC, OLE-DB, ADO programming and VBA programming.

* Excellent working experience of Microsoft ACCESS on building Therapeutic

Areas DB, Investigators DB, Laboratory management systems DB,IRB forms and

reports, Clinical equipments/assets DB and more.

* Designed, developed, coded 50+ Microsoft ACCESS. Connected ACCESS to VB,

to Excel via VBA programming and to MS SQL via ODBC and DSN-LESS connection

* Converted many file formats into ACCESS tables such as flat files, Comma

Delimited files, CSV or Excel files

*Excellent working knowledge of compliance, regulatory affairs and

guidelines (EPA, FDA and HIPPA) through training, SOP training, SOP

development, business analysis and data auditing.

*Actively analyzed data and provided solutions/recommendations in response

to anticipated/unanticipated fluctuations in the company's business affairs

*Performed analysis of data sources and processes to ensure data integrity,

unity and accuracy

* Have proven track record of ability to work independently and as part of

a collaborative team with end users to assist in defining strategic

solutions that solve business issues and enhance corporate performance

*Facilitated requirements gathering from non-technical business personnel

COTS software compliance validation expertise

*Have written numerous Clinical-IT SOPs such as disaster recovery, backup

and restore SOP, compliance planning, change control, server qualification,

workstation qualification, IQ, PQ, OQ and Validation Master Plan

*4+ Database design (logical & physical) experience, database developments,

ADO Programming, Database modeling, Data warehousing (clinical database

model)

*3+ years workflow and business process design

*3+ working knowledge of regulatory guidelines and policies, functional

policies, procedures, processes, standards and / or legislative issues (FDA

and 21 Part 11)

*Working knowledge of EPA regulations (CH2M Hill) and FDA regulatory

requirements, including 21 CFR Part 11 and Systems validation (ALLERGAN),

GLP and GMP format (ALLERGAN) and GCP format (ClinAssure, Inc.)

Excellent working knowledge of QuickBooks Enterprise, Bill Quick Enterprise

and financial principles

*Excellent working knowledge of process improvement, workflow, benchmarking

and / or evaluation processes

LIMS (Laboratory Information Management System) Integration expert

Work History

Oct 2009-Aug 2010, Health Information Technology Analyst, OCHPA, Irvine CA

May 2009-Aug 2009, United Health Group (via Robert Half Technology), SAS

Programmer, Santa Ana CA

Oct 2007-Sep 2008, Sr. Clinical Systems Analyst, ClinAssure Inc., Irvine CA

Oct 2006-May 2007, Clinical Data Auditor, ALLERGAN (via Great Lakes

Research), Irvine CA

Aug 2003-May 2006, Project Manager/Systems Integrator, ALLERGAN (via AB

Controls), Irvine CA

Jul 1999- May 2006, Various Projects (Project Manager, Sr. Analyst) via AB

Controls, Irvine CA (Contractor) Clients: Amgen, Allergan, Pfizer

2002, Statistical Programmer (Contractor), John Harold/Scantron, Tustin CA

2001, Sr. Database Designer (Contractor), Pacific Life Insurance, Newport

Beach CA

1999 - 2001, Sr. Systems Analyst (Contractor, Perm) Analyst MASCO Corp/Behr

Process

Aug 1997-Jul 1999, System Engineer/Analyst (Contractor, Perm), CH2M Hill,

Santa Ana CA

Hands-On Experience

*Workflow design, Systems Process Design

*Erwin (UML), Smart Draw, Visio, Microsoft Project Expert (have developed

more than 15 synopsis per IT and Clinical and budgeting/cost projects),

working on PMP certification

*Microsoft Office 2003 Expert, Microsoft ACCESS Expert, Gantt charts, Pivot

charts Expert

*QuickBooks and Bill Quick experience

*Beckman LIMS, WinLIMS experience

Education & Certifications

HIMSS (Health Information Management Society) HIT Training and

certification, 2010

Project Management Certification Track, Cal State Fullerton Extension,

Fullerton, CA 2008

20+ different GCP (Good Clinical Practice) Training, ClinAssure, 2007-2008

10+ different Quality and GLP (Good Laboratory Practice) Training,

Allergan, 2003-2005

MCDBA Certification Track (7 months, GPA 4.0), Chapman University, Orange,

CA 2003

Microsoft SQL 7.0, New Horizon, Santa Ana CA 2000

Crystal Report 9.0 training, ExecuTrain, 2000

M.S. Industrial Information Systems Management, Azad University, Tehran,

Iran 1992

GPA 3.7 of 4.0

B.S. Computer Science (Software Engineering), National University, Tehran,

Iran 1989

GPA 3.54 of 4.0

References

Excellent references upon request

Contact this candidate