Project Manager Data

GENE TARATUT

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

LANGHORNE, PA **053

215-***-**** (home)

267-***-**** (cell)

E-Mail: *******@*****.***

SUMMARY: Over 19 years of experience in the Information Systems

industry. Career accomplishments have included the system

analysis, technical design, application development, data

conversion, coding, testing and support of a number of

successfully projects in the Telecommunication, Finance,

Mortgage, Brokerage, and Pharmaceutical areas. Thrives in an

environment that requires the ability to learn new skills and

successfully apply them to solve business problems.

HARDWARE: PC Systems: IBM Compatibles

Client Server: SunOS 5.8, Sun Solaris Sparc 2, 5, 2000, SGI,

Iris Indigo, IBM 3600/4700

Mainframe: IBM 30xx, 43xx

SOFTWARE: OS: MS-Windows, Windows NT, MS-DOS, OS2, UNIX (Sun Solaris

and SGI Irix), MVS, VM/CMS, TSO, ISPF, And DOS/VSE,

Open VMS

Database: Access, Oracle (8.x, 9.2), DB2 (mainframe & PC), MS

SQL server,

Languages: SAS Base, SAS SQL, SAS Macro, SAS Access, SAS EG

4.3, PL/SQL, SQL*Loader, Easytrieve, COBOL, CICS, JCL,

APL, VB 6.0, VB.NET, ASP.NET, SQL, BRIO 8.0, Informatica

8.1,Business Objects 5.1.6Librarian, Panvalet, Micro

Focus COBOL.

Utilities: IBM UTILITIES, File-AID, INFOMAN, AWR, ENDEVOR,

INTERTEST, XPEDITER, VIASOFT, PRF-Platinum Report

Facility, SAS Data Studio, SAS DM System, TOAD, Q+E

Database Editor 8.0.1.4., MS-Visual Source Safe,

Microsoft Office, MS Visio., LSH

EXPERIENCE:

03/13- Present GlaxoSmithKline (GSK)

Philadelphia, PA

Consultant for Artech, Inc.

. As a Sr.Business Financial Analyst for Transparency Data and

Operation Reporting Team (TDOR) performed basic statistical analyses

for projects and reports.

. Created and presented quality dashboards based on analyzed data.

. Was responsible for validation of business requirements and systems

capability to produce accurate and complete reporting starting from

data collection, aggregation and allocation inclusive of data

correction requirements.

. Performed as a technical expertise regarding complex data models and

database design development.

. Ran validation reports using SAS with Oracle database. Created PL/SQL

Store Procedures to run Monthly, Quarterly, and Yearly reports.

07/12- 02/13 ICON Clinical Research

North Wales, PA

Data Integration & Standardization (DIS)

. As a Principal SAS DIS Programmer independently managed multiple

projects ensuring that timelines and budget are met and

deliverables are of sufficient quality.

. Was responsible for annotation of case report forms (CRF's) in

accordance with CDISC published or sponsor specific guidelines with

appropriate metadata to reflect case report tabulation (CRT) data

sets.

. Reviewed CRF annotations created by other DIS programmers, created

CRT data set specifications per CDISC or sponsor specified

requirements.

. Developed and modified SAS programs, macros and procedures that

produce tables, figures, listings and derived datasets that summarize

results of clinical trial projects according to Statistical Analysis

Plan (SAP).

. Validated data sets and listings per formal, documented QC process.

. Transferred data from Oracle database to SAS data sets and

generated SAS Edit checks programs for data validation (range and

cross-table logical checking, finding of outliers).

. Served as a technical resource within DIS and DM departments,

contributed to departmental SOPs and WPs.

Gene

Taratut

Page 2.

01/12- 06/12 ICON Clinical Research

North Wales, PA

Consultant for InSource, Inc.

. As a Sr.SAS Programmer developed and modified SAS programs that

produce tables, figures, listings and derived datasets that summarize

results of clinical trial projects according to Statistical Analysis

Plan (SAP).

. Verified SAS datasets containing clinical data from external sources.

Wrote and executed SAS programs in support of Clinical Data Management

(DM) department to clean and lock a database. Participated in UAT of

clinical trial data collection system.

. Rewrote numerous clinical studies SAS programs and Macros in order to

run with SAS Enterprise Guide on UNIX.

. Created Company's Migration strategy and FAQ (Frequently Asked

Questions) documents for supporting and training of 600 SAS users at

the transition period from SAS Windows to SAS EG on UNIX environment.

. Acted as a technical consultant to DBAs and biostatisticians by

contributing toward process improvement, ensuring that SAS programs

adhere to SOPs, guidelines, and specifications.

09/11 - 12/11 PERSHING, Inc.

King of Prussia, PA

Consultant for ACS, Inc.

. As a Sr.Business Analyst, was responsible for undertaking of the pre-

production tasks in the PNC and Met Life data conversion process:

analyzing client data, developing specifications, producing conversion

samples, and engineering a production plan. Communicated with PMO and

customers during the project.

. Provided pre-implementation support in analyzing data samples and

identified potential risk factors, reconciled conflicts, decomposed

high level information into details. Worked closely with the system

architect to define the scope and functions of application systems.

. Ran detailed analysis of sample data provided by customers in order

to develop project specifications, map

account data to internal APL, OSP, Albridge and CDB systems,

initiated test conversions.

. Based on the data analysis for conversion process established

timeframes and tracking of outstanding issues.

. Monitored progress and maintain responsibility for delivering

projects on time. Assisted to clients in UAT Testing.

. Conducted extensive QA on all data load and conversion development.

Assisted clients in UAT Testing.

. Participated in conference calls with clients to gather, define

business requirements for production.

11/06 - 02/11 RADIAN Insurance Guaranty, Inc.

Philadelphia, PA

IT Solution Delivery-ETL

. As a Sr. Business Analyst/ Systems Developer joined Radian Group in

2006 and then assumed the role of IT SAS support for all Oracle-based

SAS applications, such as Credit Risk Management Analytical Platform,

Capital Markets, and Data Warehouse.

. Was responsible for processing of more than 1.5 billion records of

historical information, utilizing SAS, SQL,

COBOL and Hyperion tools on UNIX and Open VMS platforms, used by

a community of 55 analysts.

. Supported the SAS IT infrastructure as the primary contact for all

technical and administrative SAS issues.

. Performed the role as subject matter expert for SAS IT

infrastructure. Worked with the Analytics IT group

to support daily production and test environments. Created business and

functional specifications for new development and all modifications to

existing process as part of the SDLC.

. Performed data acquisition and data integrity check of internal and

external mortgage data to be loaded into

the company Data Warehouse and DataMart. Developed test scripts to

validate results before posting. Provided client's training

to facilitate UAT Testing. Created segmentation reports using Excel

Pivot tables.

. As a member of ETL team was in charge for Daily, Monthly, and

Quarterly SAS jobs.

. Designed and maintained 50+ mappings/sessions/workflows for

extraction, transformation and load (ETL) between external sources and

reporting Data Warehouse by using Informatica in MS Windows/ Oracle and

SQL Server databases. Developed and implemented the coding of

Informatica Mappings (from source-to-target) for the different stages

of ETL. Fixed mappings. debugged the sessions by utilizing the logs of

the sessions.

. As a Project Manager managed Legacy Portfolio by analyzing reserves

calculation as a future loss with delinquent population. Was

responsible for all aspects of loan-level

delinquency/default/prepayment models.

Gathered requirements, engaged with business partners and developed

requirements documentation. Reviewed and analyzed data, escalated

unresolved issues to the next level. Provided performance reports and

recommendations for Senior Management.

Gene

Taratut

Page 3.

03/04 - 10/06 BRACCO Diagnostics Inc.

Princeton, NJ

Customer Fulfillment, Supply Chain

Management and IS department

Consultant for Technology Brokers, Inc.

. As a Sr. Business Analyst/ Developer was responsible for data

conversion from Bristol Myers Squibb(BMS) as a direct sale provider

to 3PL provider -UPS: Developed and Implemented data conversion

strategy, created inventory of data to be converted, worked with

vendors and users to solve application issues for new interfaces.

. Was responsible for data mapping, data archiving, field mapping,

data definitions, and data conversion of Customer Master, Order

Management, Chargeback, A/P, A/R, GL processing.

. Designed and wrote SAS programs, Unix Shell Scripts and Procedures.

Coordinated with DBA to create new tables in IBIS data warehouse for

new interfaces. Created SAS datasets and macro libraries. Promoted

code from development environment to production. Tested batch jobs

and scheduled jobs with Crontab.

. Extracted data from Oracle database to SAS data sets and

generated SAS Edit checks programs for data validation.

. Provided programming support for clinical trial data reporting and

regulatory submissions. Created derived-analysis SAS datasets.

Executed analyses specified in SAP and RAP under the guidance of the

statistician.

. Created SAS macros to submit CDISC procedure to export and import an

XML document in CDISC ODM

format based on SDTM standards.

02/03-03/04 MBNA Newark, DE

Portfolio Conversion Team Support (PCTS)

Consultant for HSI, Inc.

. As a Sr. Project Analyst supported 5 major projects of data

conversion for new purchased accounts from other financial institutes

in the form of data mapping, testing and data validation using SAS and

COBOL.

. Developed strategy plan for acquiring 12M new accounts from UK

ensuring quality and timeliness of project.

. Reviewed field to field data mapping requirements supplied by

project managers. Wrote SAS queries to verify the accuracy

of mapped data, analyzed data and developed new set of testing

programs to identify possible exceptions.

. Prepared unit test plans/scenarios and evaluating results

against plans.

. Developed set of reporting programs, generated Ad-Hoc analyses

and reporting to satisfy business requests.

. Automated reporting procedures for each conversion by using SAS

Macros.

02/99-02/03 FLEET Credit Card Services Horsham, PA

Customer Development & Risk Management (CDRM)

Volume Marketing Group (VMG)

. As a Sr. Project Manager/Analyst was responsible for major credit

policy projects. Conducted research related to customers of Fleet

Boston unit, including project design, data collection, analysis,

summary of findings, recommendations and presentation of results.

Developed QC processes to ensure the reporting integrity.

. Was involved in full life cycle implementation of two Data Marts

(Campaign Management and Marketing) by using SAS Macros and SAS SQL for

data extraction from ORACLE database. Scheduled and monitored batch

Data Mart jobs, space consumption on the system. Developed PL/SQL

modules.

. Extracted customers from Fleet Credit Card Services Database for

Direct Mail and Telemarketing campaigns following in-house client's

select criteria. Projects included fee-based and non-fee based

incentive Credit Card promotions based on the FICO scores, utilization,

etc. (such as travel packages, insurance, magazine subscription and

sweepstakes). Assured the achievement of high quality results within

timeline and budget.

. Interfaced with user groups to help meet their short and long term

info needs (ran requested Ad Hoc reports).

. Provided campaign-tracking information on a monthly basis. Created

internal Risk model on campaigns responders. Developed internal

campaign management reporting capabilities.

. Designed and wrote SAS programs for analysis of portfolio performance.

09/97-01/99 THE VANGUARD GROUP Malvern, PA

Integrated Marketing Information System (IMIS)

Vanguard Brokerage System (VBS)

Consultant for BIT, Inc.

Gene

Taratut

Page 4.

. As a Senior Programmer/Analyst has been involved in software design

and development, inspections, extensive unit testing and system

testing for IMIS and VBS Systems utilizing COBOL II, DB2, VSAM, CICS,

JCL, SAS

. Analyzed system requirements and developed system test plan, test

cases, and test procedures. Established the test environment; modified

JCL, defined and validated system test data.

. Executed system tests, documented exceptions, analyzed and reported

results.

. Interfaced with representatives of Marketing group and Vanguard

Brokerage System. Supported Marketing group requests to retrieve data

from the DB2 database based on specified criteria. Monitored batch

jobs.

01/96-09/97 LOCKHEED MARTIN COMPANY Wayne, PA

Enterprise Information System (EIS)

Consultant for SGC Consulting

. As a Senior Systems Integration Analyst supported the Cost Management

System (CMS), which is a common enterprise-wide financial application

implemented at five businesses.

. Was responsible for the technical correctness and completeness of

integrated systems designs, and participated

with customers in the strategic design process-translating business

needs into technical systems solutions

. Responsibilities included software design and development, code

reviews, extensive unit and integration testing, interfacing with

customers and PMO, Ad Hoc development of SAS programs to implement

customer promotions in rapidly changing business environment (the

programs provided data retrieval from corporate database, processing

according to business requirements, presentation of data for business

analysis by marketing manager).

10/94-01/96 GTE DATA SERVICES, INC. Tampa, FL

Consultant for COMPUTER HORIZONS CORP.

. As a Programmer Analyst performed analysis of business

requirements, developed, designed, and implemented

Treatment sub-application for the Customer Billing Services System

using DB2, COBOL II, VSAM, JCL, SAS.

. Interacted with Business Process Analysts during the design

phases, gathered requirements, engaged with clients

and developed requirements documentation.

. Provided CBSS production support and on-line applications of

the Internal Information Management (IIM).

EDUCATION:

1980-1984 MOSCOW UNIVERSITY OF TELECOMMUNICATION Moscow,

Russia

BS in Computer Science and Telecommunication Engineering.

REFERENCES: Available upon request.

Contact this candidate