Sql Server Quality Assurance

Berhanu Beyene

**** ********** **. ****** ******, MD 20903 Mobile :240-***-**** *********@*****.***

SUMMARY

Over 2 years of experience extensive work designing, developing, and supporting large and complex SQL Server databases in production and development environments. I collaborated with the data management team, QA specialists, and security team to plan and execute database projects with a high level of efficiency. I'm interested in pursuing a SQL server database developer role within a company with growth potential.

WORK EXPERIENCE

Jr. SQL Server Developer July 2014 – Present

Eight O’clock Coffee, Landover, MD

Extracting data and build queries.

worked with Data Manipulation Language (DML), Data Definition Language (DDL) and Data Control Language(DCL)

Using log shipping for synchronization of database

Creating Database Objects – Schemas, Tables, Indexes (clustered and non-clustered), Views, User defined functions (UDFs), Cursors, Triggers, Stored Procedure, Constraints and Roles.

Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented

Moved files between the File Groups and partitioned the tables to improve the performance

Monitoring SQL server performance using profiler to find performance

Wrote complex stored procedures to process employee’s requirement and generating.

Experience in implementing High availability solutions like different Replication models (Snapshot and Transactional), Log shipping, Clustering and Mirroring on physical and virtual machines

Quality Assurance Technician July 2012 – June 2014

Eight O’clock Coffee, Landover, MD

Directly responsible for assuring and enabling the compliance and continuous improvement of product materials, manufacturing processes, and finished products.

Evaluating finished goods and Raw Material’s against Specifications

Revise and write standard operating procedures that may have to be updated or implemented

Organize raw material documentation and vendor information

Monitor and control Green coffee inventory and blend recipe

Organoleptic evaluation of Raw green coffee and Freshly packed product samples

Quality Control Verification

Data analysis

Participate in new product development/sensory evaluation; Commissioning evaluation

Prepare documentation for BRC certification

Conduct internal audit against BRC standard

Conduct monthly GMP audit

Communicate with operations team to resolve issues either through meetings or by tracing problems to their root cause in the Plant

Help train entry level technicians and operators

Participate in process control initiatives that cut cost and improve product quality

Instrument set up, calibration and support

Acquired experience in working for different modules such as SAP PP (Production Planning), SAP MM (Materials Management)

Provide training to the end users and ensured they are comfortable working on the SAP software

Food Microbiology Lab Assistant February 2012-May 2012

University of Maryland, College Park, MD

Assisted in making microbial media for growing microorganism in laboratory

Transferred bacteria on to media and tested, logged, recorded reaction to factors, such as temperature acidity, and salt content.

Computed percentage of salt and other factors using mathematical and chemical process interpret data.

Clean and sanitize laboratory surfaces and equipment

Quality Assurance Technician Intern June 2011- September 2011

Keany Produce, Landover, MD

Perform HACCP Monitoring and review HACCP recordkeeping

Conduct internal audits and prepare for third party audit

Carryout Sanitation monitoring and evaluate recordkeeping

Analyze sanitation monitoring using ATP/Bioluminescence assays

Study Shelf lives of fruits and vegetables

EDUCATION

Bachelor of Science May, 2012

Major: Food Science

University of Maryland, College Park, MD

Certifications

HACCP Certified March, 2011

University of Maryland

Internal Audit July, 2013

SAI Global

SKILLS

T-SQL, SAP, Microsoft Word, Microsoft power point, Microsoft Excel, Microsoft Access

Contact this candidate