Assefa Dender

**** *********** ****** ***** ****: 703-***-****

Alexandria, VA 2231

ac53f6@r.postjobfree.com

Database administrator/Developer

Professional Experience

To secure a position in the organization that offers challenge and opportunity for my career development and at the same time serve the organization to the best of my capabilities. I would like to gain new skills while utilizing my current area of expertise as a Database Administrator/Developer with in a positive team environment.

Team Lead/Senior Database system developer - Consultant July 2017 to Sep 2017

Department of Homeland Security US Citizenship and Immigration Service – PAE, Inc Washington District Office, Fairfax

Designed and deployed custom tabs, validation rules, and workflow rules to automate business logic and defined related tasks, time-triggered tasks, email alerts and field updates to implement the business logic.

Performs information includes application, petitions, forms, supplemental documentation DHS decisions, and other documents. Repositioned the Case feed filters which gives support agents a more streamlined way of creating, managing, and viewing cases.

Performed database tasks in an accurate and timely fashion according to team production standards.

Completed work assignment within the system.

Performed standard database tasks according to team minimum production, accuracy standards and examine data records.

Assisting and respond to request from customer with preformatted response document or create files and document based on research of the issue. Review File Requests and Ready for routine appropriates responded.

Provided support for database backup/restore and database transfer activity from test environment to production environment.

Created external tables to load data from various files supplied by data supplier.

Created reports and dashboards to monitor weekly and monthly activities.

Repositioned the Case feed filters which gives support agents a more streamlined way of creating, managing, and viewing cases. And to keep the detailed and accurate records of customer interactions.

Database System Adminstrator - Consultant October 2011 to July 2017

Department of Homeland Security US Citizenship and Immigration Service/ FciFederal, Inc Fairfax, VA

Inspected and recorded incoming database in CIS index for completeness, accuracy of codes and other potential problems in processing. Hands on experience and outstanding knowledge of high availability SQL Server solutions, including SQL Server Log shipping, Mirroring and SQL Server clustering (Active/Active and Active/Passive. Proficient in SQL programming, physical database design, and SQL Performance tuning, replication.

Extensively worked on Data migration, Data cleansing and Data Staging of operational sources using excel reports processes and providing data mining features for data warehouses.

Created database objects, with Index and Functions developed procedures for implementing application functionality at database for Performance Improvement.

Performed standard data entry tasks according to team minimum production, accuracy standards and examine data records.

Assisted and responded to request from customer with preformatted response document or create files and document based on research of the issue.

Reviewed File Requests and Ready for routine appropriates responded.

Used online document tracking system to receive e-mail, distributed work assignment and completed work in system.

Database manage/Office support - Consultant March 2010 to July 2011

Department of Homeland Security US Citizenship and Immigration Service, (TDEC)

Created external tables to load data from various files supplied by data supplier.

Performing physically interfiling the materials in to paper location within each file.

Functioning include arranging the material for placement in the files or other disposition.

Performed attending and assisting with ceremonies common functions contractors do at ceremonies include handing operation audio and video.

Prepared file for work or retirement by removing paper clips, Staples, local tags and coversheets, or other unnecessary pages.

Updated the naturalization certificate make sure marked with the date and time of ceremony preformed.

Responsible for perform daily office tasks such as filing, recording, marinating, records, copying, posting and variety of other office duties

Use a computer terminal to update DHS automated system.

Performed all tasks with reviewing all files for current fingerprints name checks and IBIS.

SNAP all files that need updated fingerprints.

Routed all rap sheets to proper locations and annotating the clerical sheet with update information on the rap sheet.

Assisted distributing files to the appropriate division and retire files as needed.

General office worker- Office Support – Consultant May 2008, to March 2010

Department of US Citizenship and Immigration Service, (CMI, Inc),

Provide clerical and administrative support in the processing of forms and applications used in the adjudication and adjustment of status of aliens. Administer and assess different performance metrics of the operations

Coordinated with the operations team to suggest improvements to increase performance

Utilized business intelligence tools such as Mission Control to retrieve data and perform analytical tasks for demand prediction, supply matching, and supply positing

Created reports for the Chief Executive Officer

Assisted manager with event planning for marketing campaign

Performed all clerical tasks related to naturalization ceremonies, including the scheduling, preparation and distribution of certificates and retrieval of documentation from applicants

Responsible for the quality assurance of files prior to file retirement

Responsible to manage file rooms in the areas of file movement for proper identification of its accountability.

Conducted and analyzed yearly customer surveys and suggested various improvement approaches in improving customer satisfaction.

Certifications

Passing 70-462: Administering Microsoft SQL Server 2012/2014 Databases Candidate ID MS0616616669 and Registration 321479733

Microsoft Certified Professional (MCP)

Tools and Technologies

Microsoft Office Suite

Microsoft SQL Server 2012

Education

B.S - Computer Science/Network Administration - Strayer University, Arlington, VA

Bachelor of Commerce in Business Administration & Business Entrepreneurship University of Poona, Pune, India

Data base training SQL Developer, Business intelligence (BI) Database Administrator (DBA), DunaTek Training Center, Silver Spring, MD

TRAINING

Database Architecture and Administration

MSSQL 2012: Backup and Recovery

MSSQL 2012: Performance Tuning

MSSQL 2004: Network Administration

MSSQL 2012: Database Administration

MSSQL 2012: Backup and Recovery

MSSQL 2012 Business intelligence (BI) SSIS,SSRS,SSIS

Contact this candidate