SUMMARY OF SKILLS:

. Database Management (Microsoft SQL Server- 2008, 2008 R2,SQL Server

2012),

. Transact SQL, SQL Server Management Studio, SQL Server Reporting

Services, SQL Server Integration Services, Stored procedures, SQL

Server user defined functions,views, triggers

. Install and configure MS SQL Server, Visual Studio (including the

Business Intelligence)

. Data analysis, ETL processes, migrating data between servers,

databases and tables

. Database mail, SQL jobs/task automation

. Visual Studio, Business Intelligence BIDS, Report Builder 3.0

. Advanced MS Access database programming and administration

. The .NET Framework using ASP.NET (applications development), VB.NET,

C#

. Cascading Style Sheets (CSS), HTML

. Microsoft AJAX, jQuery, ADO.NET, LINQ,

. Advanced MS Access, MS Excel and other MS Office packages

. Key board typing speed: 50 wpm

EMPLOYMENT:

June 2013- Present Data Analyst/Developer, Citibank

Buffalo, NY

. Designing and administrating SQL Server databases

. Creating complex Stored Procedures for SQL Reporting Service and .NET

applications

. Writing complex queries and sub-queries according to user

requirements, creating multiple TSQL batches

. Creating and altering user defined functions in scalar and table forms

for SSRS and applications

. Performance management and query optimization

. Performing multiple table joins: inner, left, right, self joins

. Routine DDL and DML activities

. Creating SQL Server Views for users

. Task automation using SQL jobs, db mail, automating reports generation

and delivery

. Ensure database integrity and database normalization, monitoring SQL

performance by creating indexes, views and monitoring execution plans

. Technical and users documentation management

. Creating local and Server Reports for users through subscription:

tabular, drill through, matrix, charts, etc

. Schedule reports for monthly, weekly and daily consumption using SSRS:

tables, graphs, charts, gauges, data bars, etc

. Deploy/Publish reports for users

. Translating different user requirements into parameters in T-SQL and

SQL Reporting Services

. Developed C# and VB .NET applications for different projects for

Citibank

. Integration service projects: Extract Transform and Load (ETL) from

flat or other file sources for SQL Server usage in Citibank reports

. Upgraded a 2008 R2 SQL Server to 2012 with migrating all its data,

objects and logins

. Providing routine expertise support in the areas of data mining,

extraction and reporting

. Successfully, created and implemented a Global Activity Reporting

Database System (called EDM Metrics) for Citibank for daily, weekly,

monthly and quarterly activity and performance grading. This database

analyses an employee's efficiency (in %) for a given time period based

on standards set by Citibank.,,which is now being used among other

Citibank ISG groups. I am responsible for the overall development and

administration of the database. This system is being used by four

regions in Latin America, Europe, US and Asia

. Created a reporting system dashboard for management whereby all

regional leads can directly access the SSRS reports that I created

directly from the database

. Developed a Flexcube project management tool using the .NET framework,

MS SQL Server, and MS Integration Services for the aforementioned

regions

. Developed a Task Assignment and Management application for Citibank

using C# and SQL server as the backend. There are numerous automated

tasks involved in this database application which include a nightly

data transfer, auto email reports delivery, auto update to fields

based on conditions, etc

. Trouble shoot complex database and SQL Server problems, data

redundancy (anomalies), SQL Server versus SSRS connections and dataset

problems, etc

. Engage in UAT testing to support the release of applications for

production

August 2012-June 2013 Worksite Database Manager, Erie County Department

of Social Services Buffalo, NY

. Create and administer databases for county day to day routine tasks

. Responsible for worksite clients data analysis, and periodic

reporting

. Periodically creating the profiles of new clients and closing the

cases of old clients

. Database Administration works, making sure backups and recovery works

. Provide technical support in the areas of data management, structure,

reporting, etc for work sites

. Install, configure and maintain software programs

May 2012-August 2012 Market Information System Assistant, SEARS Holdings

Buffalo, NY

. Responsible for stock management using the SNIC technology

. Maintaining store database with Zero counts, stock at hand, etc

. Help maintain the marketing strategy of SEARS holdings by using SEARS

software

. Preparation of signs, marketing boards, pricing standards, etc

February 2011- April 2012 Volunteer, David Family

Inc, Washington DC

July 2008- January 2011 IT Assistant, DanChurchAid (DCA) Copenhagen,

Denmark and Addis Ababa, Ethiopia

. Designed, developed, and implemented reports using MS SQL

. Install, configure and maintain software programs

. Website applications and content management using the .NET framework

. Preparation of booklets, flyers and brochures using MS Publisher, etc

September 2001- July 2008 Grants and Relief Program Officer, World Vision

International, Addis Ababa, Ethiopia

EDUCATION:

Copenhagen University

Masters in Disaster Management

Thomas Edison State College

BA Computer Science, Student (Expected graduation April 2015)

Trocaire College

Certificate, Microsoft Web Developer (.NET Developer)

Haramaya University

Bachelor of Science in Extension Science

ATM Computer Training Center

Certificate in Personal Computers

Contact this candidate