Sql Server Quality Assurance

Sion Alemu

Cell # 571-***-****

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

OBJECTIVE

To obtain a challenging and rewarding position where I can apply my knowledge and experience, while being offered an opportunity for professional growth and advancement.

SKILLS AND QUALIFICATIONS

SQL scripting /Backup and recovery using MS SQL Server

Data Analysis

Data modeling and database designing skills

Expertise in writing Store Procedures, Views, Functions and Triggers using T-SQL

Experience with agile and scrum methodologies

Quality control and Quality assurance skills

Filing, retrieval, record keeping and organizational skills

EXPERIENCE

VENCORE/ DHS/ USCIS, Arlington, VA (June 2016 – July 2017)

Production Support DBA

Monitored several services such as Case transfer, Case Ingestion, Notice Generation, Card Production,

IBIS, Image services, Mainframe etc.

Manipulated Data using Pervasive software and MS SQL Scripting language

Monitored database activity and file usage to ensures necessary resources are present

Investigated and resolved technical database issues

Investigated and resolved database related issues for users using ServiceNow ticketing system

Conducted quality assurance activities such as peer reviews

Worked as part of a team and provided 24x7 support when required

Maintained security and integrity controls

Developed test plans to verify logic of new or modified programs

Developed database administration, user standards and procedures audits and modification,

and amends data in systems using SQL commands

Ad-Hoc reports

DUNATEK, Falls Church, VA (November 2015 – April 2016)

Database Administrator

Worked on the design and implementation of a back-end module for an inventory

management system using Microsoft SQL Server 2012 database environment

Developed store procedure and function to perform different back-end operation

Used SQL Indexes for improving query performance

Performed backups and restores of the database

Performed Normalization/ Denormalization techniques as needed

Designed the Entity Relationship (ER) models based upon the design documents

Experience in optimization tools such as SQL Profiler

Hands-on working experience installing, configuring, and upgrading SQL server

Upgraded SQL Server from SQL Server 2008R2 to SQL Server 2012

Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments

Scheduled SSIS Packages and batch jobs through SQL Server Agent

Created views for easier implementation on web pages and wrote triggers

GEORGE WASHINGTON HOSPITAL, Washington DC (October 2015- February 2016)

QA Validation Analyst / Medical Data Abstractor

Validated the accuracy of clinical information during data conversion

Tested data conversion, identified defects, analyzed and tracked errors using assigned toolset

Provided detailed and completed defect reports to the conversion experts and developers

Reprocessed clinical data to ensure the information is accurate and error proof

Regenerated PDF and sent the document to Document Management System (DMS)

KAISER PERMANENTE, Marlow Height MD (August 2012 – September 2015)

HIMS Doc Prep, Scan and QA Associate

Processed health information documents for scanning and record keeping in the database

Maintained specified quality and production standards

Suspend documents without identifiable document type or issues for review

Reviewed documents to insure appropriate frame, resolution, orientation and adjust accordingly

Performed quality assurance procedures

Generated Barcode for the processed documents

ZEROCHAOS / GOOGLE/ Remote (January 2015 – February 2015)

Google Advertisement Quality Rater

Analyzed and provided feedback on texts, web pages, and images for Google

Reviewed the search query results and rated them in terms of relevance

Used an online tool to examine data, provide feedback and analysis to Google

Reported and tracked the visual quality and content accuracy of Google advertisements

Dr. HEMA SUNDARAM DERMATOLOGY, COSMETIC & LASER SURGERY, Fairfax VA

(December 2011 – June 2012)

Billing Manager/Receptionist

Submitted, organized, and tracked all insurance claims filed by the health care provider

Translated codes into insurance companies’ preferred coding system

Verified insurance documents

Followed-up until payment received and managed collection activities when necessary

Assisted with various front desk tasks and supervised the front desk staff

BLUE NILE MEDICAL CENTER, Alexandria, VA (September 2007- April 2011)

Medical Receptionist

Managed front desk area and answered multiple line incoming calls

Scheduled patients for office visits, procedures and follow up Visits

Coordinated daily pharmaceutical related matters and prescription orders

Checked in and out patients and collected payments at the time of service

Entered\updated patient’s data in the company system

Verified insurance documents

Prepared referrals and pre-authorizations for specialist visit and procedures

SUPERIOR GLACIER, Washington, DC (November 2006 – June 2007)

Scan Associate/ Quality Analyst

Copied / Scanned Documents

Performed quality assurance check for all projects assigned

Monitored office supplies and ordered when necessary

Troubleshoot Scanner Hardware and Software as necessary

EDUCATION & CERTIFICATION

Northern Virginia Community College, Annandale, VA 2011

Medical Assisting, Diploma, Everest College, Arlington, VA 2006

Microsoft Office Certificate, Addis Ababa, Ethiopia 2003

High School Diploma, Addis Ababa, Ethiopia 2000

Contact this candidate