Sql Server .Net Experience Data Development Project

Wosenie Bekele SeNBETA [pic]

San Diego, CA *****

Cell:619-***-****

abm7ny@r.postjobfree.com

SUMMARY

Experience in designing and implementing Relational Database Microsoft SQL

server 2005/2000 (Writing complex T-SQL, TRIGGERS, STORED PROCEDURES,

CONSTRAINTS and VIEWS) and SQL 2005 reporting services

Manage and administer the local area network (LAN), including all aspects of

maintenance (TCP-IP, DNS, DHCP, IIS and hardware upkeep);

Hands on experience in both windows and web application using C#, ADO.NET

with a strong Experience in SQL server 2000/2005

Experience with Object oriented Analysis, Design, Programming and performing

data modeling using the UML, IBM Rational Rose 2000

Experience on CLASS DIAGRAM, SEQUENCE DIAGRAM, COLLABORATION and other UML

using Rational Rose, Microsoft Visio

Software Testing Cycle(Test Plan, Development, Execution, Analyzing and

Defect Report)

On web based application development with .NET front end and SQL server

2000/2005

Strong experience on Microsoft SQL Server 2005 Reporting Services (SSRS) and

Crystal report 10.0 reporting service.

Create and design Reports Using ArcGIS 9.0 ESRI's ArcGIS version 9.0

Academic knowledge on web and windows application development with Java

related technologies such as J2EE, JSP, HTTP and JDBC.

Professional EXPERIENCE

John Hopkins university Program for International Education(JHPIEGO)

April 2006 to April 2009

Position: Database Administrator

Duty and responsibility

Modify existing databases and direct programmers and analysts to make

changes.

Test programs or databases, correct errors and make necessary modifications.

Plan, coordinate and implement security measures to safeguard information in

computer files against accidental or unauthorized damage, modification or

disclosure.

Coordinate and lead ETL data from different database sources, data cleaning,

preparation of statically and programmatically reports and, distribution of

reports.

Assist and guide data collection from multiples health care centers and

different organizations

Approve, schedule, plan, and supervise the data entry team train users and

partner organizations

Specify users and user access levels for each segment of database.

Develop/wrote stored procedures to mitigate customer's specific needs.

Review project requests describing database user needs to estimate time and

cost required to accomplish project.

Review procedures in database management system manuals for making changes to

database.

Work as a project team lead to coordinate database development and analysis

with.

Write and code logical and physical database descriptions and specify

identifiers of database to management system or direct others in coding

descriptions.

Review workflow charts developed by programmer analyst to understand tasks

computer will perform, such as updating and modifying records.

Work with systems developers in Baltimore to ensure that systems needs are

met to deliver program results as expected

Guide the development of work plans and new initiatives in TIMS in Ethiopia

Supervise the log files received from CDC and USAID partners work with data

annalist to verify the quality of data sent from those partners and hold

meeting for better quality work.

Develop data cleaning tools and Coordinate and lead data cleaning to have

quality data before moving the data to SIFo

analyze and prepare reports to JHPIGO office, partners, CDC office and USAID

and government office

Build compelling maps that help to visualize the distribution of work in

participant concentration in each region

Create and design Reports Using ArcGIS 9.0 ESRI's ArcGIS version 9.0 to

locate the active project location and to show the activity done in the given

areas. and create a thematically formatted maps

From 2006 to 2008 par time Consultant

Designed system requirements including Use case, Class diagram and Sequence

diagram.

Designed and Developed the ASP.NET web application using a three-tiered

architecture and MVC design pattern.

Integrating with Active directory to fetch user information of the

organization from AD Database.

Implemented the Web User Interface, Business logics, and Data Access

Components

Implemented with C#, ASP.NET, ADO.Net and SQL Server 2000 as back-end

database.

Designed and implemented relational database, and stored procedures, views,

and triggers in SQL Server 2000.

United State Aide for International Development(USAID)

April 2005 - March User system specialist

2006

Duty and responsibility

Encoding, editing & retrieving records on Lotus Smart Suite Data base

Collecting & Processing Data from SQL Server 2000/ Panasonic-Hyper Terminal

Application backend

Performs day-to-day operations to maintain optimal network performance.

Executes installation, modification, and maintenance of LAN components

including network cable, interface cards, operating systems and other network

utilities

Manage and administer the local area network (LAN), including all aspects of

maintenance (TCP-IP, DNS, DHCP, IIS and hardware upkeep);

Support users with email related issues on exchange server and web based

e-mail

Administer and maintain Microsoft Exchange Server 2003: configure new email

accounts and assist users with email related issues on server based and web

based e-mail

Prepare and maintain a disaster prevention and recovery system to mitigate

any failure resulting in network down time.

Provide trouble-shooting (software and hard ware) to all users online and

other support by remote connection, phone and email to field personnel;

Keep abreast of all organizational IT needs and report these in a coherent

and timely manner, recommending future cost effective development of IT

systems in support of overall organizational goals.

Provide input and technical expertise relating to the procurement,

installation, and repair of computer systems, services, accessories,

hardware, software, etc.;

Keep the network and all staff computer systems safe, secure and virus-free

in to maintain business continuity

EDUCATION

BSc Degree in Computer science from Addis Ababa University, School of

Information Science and Technology.

Associate Degree in Chemistry from Addis Ababa University, facility of

Natural science

Training and certifications

Certificate of excellence for passing the exam Installing, Configuring and

Administering Microsoft SQL Server 2005.

Certificate of excellence for passing the exam Designing Database solution by

using Microsoft SQL Server 2005.)

Certificate of achievement for attending implementing a Database on Microsoft

SQL Server 2005 Database Programming.

Certificate of achievement for attending-SQL Training

Certificate of achievement for attending on java programming

Certificate of achievement for attending on .NET 2005

Certificate of achievement for attending Arc GIS 9.0 and map info

Technical Skills

Programming Languages: C++, C#, Java, Java Script, .NET and Pascal and Data

structure

Databases: SQL 7.0/2000/2005, MS Access, PHP,

Tools: Microsoft office 2000/XP/2003, MS Visual Studio 6.0 and .NET,

ASP.NET, XML, C#, Crystal Report 9.0/10.

REFERENCES

Dr. Yassir Abduljewad

Mail:abm7ny@r.postjobfree.com,

James BonTempo

Mail:abm7ny@r.postjobfree.com

Jhpiego Baltimore

Mayes, Robert

Mail: abm7ny@r.postjobfree.com

Washington, DC

Contact this candidate