Quality Assurance Sql Server

Francis "Frank" Osei

**** ***** ******, ********. *****. 75181

Telephone; 469-***-****

E-mail: **********@*****.***

Objects, Project Management

Technical Skills:

MS Access (VBA), Visual Basic Application, ADO, DAO and ODBC, Strong SQL

Skills, Relational Database Design, Data Modeling (Mapping / Relational

Setup), SAP ABAP/Query, Development Tools, SQL Server, Oracle, Toad, SAS

Programming, VBScript, XML, ASP. Net, Business

Non-Technical Skills:

Strong business acumen

Excellent verbal, presentation and written communication skills

Team player with excellent inter-personal and leadership skills

Strong leadership, analytical and problem solving abilities

Succeed with minimal supervision.

Experience:

2010 -Present - Blockbuster Inc.

Senior Database Analyst

Extract, transform and load (ETL) Corporate Title Facts sheets Database

Restructured and automated the distribution of IBOs/Peger workload

Automated routine monthly reports and scripted scheduled monthly processes

2001-2010 Aerospace Insurance Managers. Dallas, TX

Programmer / Database / Business Analyst

Designed and developed of Structured Programming in Application Development

(Full Life Cycle) for Insurance (Underwriting and Claims), Account

Receivable and Reinsurance modules

Access (VBA) Programming

Front and Backend Data Development

Data Modeling

Defining field relationships, & maintaining database integrity

Retrieve, store and manipulate data using T-SQL, Oracle PL/SQL & Access

Complex Query

SQL Server Database maintenance, monitoring and purging log

files/transaction files

Creating complex SQL statements / scripts to access data from multiple

joined tables and multiple sources

Develop SQL scripts for Quality Assurance testing

Design SQL scripting modules that are standardized and reusable scripts for

future data extraction projects

Perform Mapping of data from various data formats to standard SQL staging

tables for conversion

Performance tuning, database creation (through script),

Build customized Data Collection Forms

Designed and generated routine and Ad hoc Reports for senior Management,

Regional and District outfits.

Statistical and mathematical Analysis

Work closely with Business Process Owners for process requirements

Met with customer groups to determine data requirements and modification to

data extracts

Knowledge of SOX Best Practices

Education:

University of Texas, Arlington, BBA (Information System Analysis, Business

Administration)

Reference Upon Request

Contact this candidate