Cleda U Smartt

Cell: 734-***-**** Home : 734-***-****

ac9qic@r.postjobfree.com www.linkedin.com/in/cledasmartt

Technically creative and detailed oriented with the ability to think outside the box with a commitment to excellence. Led project development teams and delivered outstanding results for clients such as Highmark, Blue Cross Blue Shield of Michigan, Visteon, General Motors, Internal EDS, Express Script, Sprint and State Farm Insurance.

EDUCATION

Master of Science, Computer Information Systems April 2012

Eastern Michigan University, College of Business

TECHNICAL and SOFT SKILLS

DB2/ZOS

IMS

MySQL

Visio

SQL

RMS

Teradata

BMC Tools

QMF

Rumba

Visual Studio

CA Tools

SPUFI

Endevor

Analysis

Cobol

TSO/ISPF

SAP

Design

CA7

JCL

Endevor

HP Service Manger

Microsoft Office

VSAM

ER Studio

Data Modelling

Project Management

FileAid

ChangeMan

Easytrieve

Xpediter

PROFESSIONAL EXPERIENCE

HTC Global Services Nov 2012 – Dec 2018

Database Administrator and Project Coordinator

Client: State Farm Insurance, Bloomington, IL

. Schedule work to be performed by team members.

. Schedule and facilitate team meetings.

. Document meeting minutes, action items, decisions, risks and issues.

. Monitor, analyze and follow up on open items.

. Create and update work plans and create status reports.

. Interface with all that is associated with the project.

. Work with Data Designer and developers to produce physical data design in BMC tool.

. Develop and maintain Agency Awards database, TPAR database, Agent Aspirant and

Agent Analytics.

. Design DB2 bi-temporal table for keeping current and history data.

. Perform SQL reviews through the BMC Performance and Tuning tool

. Create Image copy and reorg jobs through BMC DASD Management tool

. Create HP Service Manager Change Management Tasks and Requests

. Implement database backup and recovery procedures

. Grant access to developers

. Perform upgrades to databases, adding new structures or columns

. Maintain development, production and multiple test environments

. Manage database performance.

HP Enterprise Services (formerly EDS), Pontiac, MI Jan 2005 –April 2010

Database Administrator and Project Leader

Clients: SPRINT, Chevron, Checkfree, Phoenix, Avista, Severstal, Daimler Financial and Electrolux, Express Scripts Inc, General Motors

. Lead team meetings and write performance appraisal for DBAs.

. Worked with clients and account team on projects involving database design and

construction, data quality assessment, customer support and healthcare analysis.

. Knowledge of project management principles, concepts and practices

. Knowledge of system development lifecycle used for development of new systems and

enhancements to existing information systems

. IT concepts and operating principles of data communications and information systems

hardware and software

IBM, Southfield, MI June 2004 – November 2004

Client: Visteon

Database Administrator and Project Leader

Migrated Visteon DB2 databases from Ford Motor Company DB2 environment

. De-installed the use of BMC tools for database unloading, image copying, reorganization, etc

and replace them with IBM suite of tools. This resulted in considerable cost savings

. Knowledge of personal computers and personal computer software

. Knowledge of file maintenance and report generation methods

. Gather and analyze facts, draw conclusions, define problems, and suggest solutions

Sogeti, Farmington Hills, MI April 2003 – April 2004

Client: Visteon

Database Administrator and Project Leader

Responsible for all DB2 database administration activities in support of a new DB2 subsystem for Visteon

. Instructed application developers in DB2 application testing techniques.

. Lead project team with 5 DBAs

. Conduct training and informational sessions

. Communicate effectively, build consensus, facilitate working sessions, and negotiate

solutions and alternatives

. Prepare detail written instructions and documentation

. Analyze instructions and data

Epitec, Southfield, MI June 2000 – Dec 2002

Client: Blue Cross Blue Shield of Michigan

Database Administrator and Project Leader

. Worked with clients and account team on projects involving database design and

construction, data quality assessment and healthcare analysis.

. Designed, maintained, executed and document database tests and support user acceptance

testing.

. Maintain records, prepare reports, and conduct correspondence related to the work

. Maintain favorable public relations and perform problem/issue resolution

. Organize and coordinate the work of others

. Set priorities and assign work to other professionals

Highmark, Camphill, PA June 1981 – June 2000

Corporate Instructor, Database Administrator and Project leader

. Responsible for designing technical and soft-skills course materials and teaching set courses.

. Analyse and develop logical and physical databases for Data Warehouse project.

. Research, collect and evaluate project data necessary to meet project reporting and

evaluation requirements

. Develop, maintain, update and oversee project plans and schedules using tools establish by

company

. Maintain project issue and risk process and/or defect logs

. Maintain awareness of emerging technologies and project management techniques.

. Monitor project performance, report status, and facilitate the creation of action plans to

promote adherence to IT project schedules.

Contact this candidate