OBJECTIVE

A dynamic and challenging position with growth opportunity in any

organization where I can apply my experience in database administration,

database programming and development, Data Warehouse/BI and data analysis.

SUMMARY

. Over 13 years of experience as an Access/SQL Server Database Programmer

and Application Developer

. Over 5 years of experience in development of applications using ASP.NET,

VB.NET, C#, SQL Server DBA and SQL Server 2012

. Experienced in database design and development using VB.Net, ASP.Net, T-

SQL, ETL, SQL Server DTS, SSAS, SSIS, SSRS, OLAP

. Experienced in different phases of software development cycle including

Programming, Testing, Documentation, and Presentation to clients and

preparing customer specifications as part of software technical

requirements and Customer support

. Experience in Database Analysis/Design/Normalization/Manipulation

processes using SQL Server and MS Access

. Knowledge of, and experience with:

- Logical data models and physical data models, full SDLC

- Corporate and application network connectivity and hardware

architecture

. Team player with good interpersonal skills; thrive well within the group

environment.

TECHNICAL SKILLS

Languages: ASP.NET, VB.NET, C#

Scripting Languages: ASP, VBA, VB Script, JavaScript

Markup Languages: HTML, DHTML, XML, XSL and XSLT

GUI: Visual Studio.NET 2003, 2005, 2008, 2012, SQL Server 2005, 2008, 2012

(SSMS, SSIS, SSRS, SSAS, BIDS, XMLA, MDX), SQL Server 2000

(T-SQL, DTS, Query Analyzer), TFS (Team Foundation Server)

2012, MS Visual SourceSafe, Subversion SVN, MS Access

(VBA). Xcelsius 2008, SAP BI 4, Dashboards 4

Component Technologies: COM / DCOM and MTS

Reporting Tools: Crystal Reports 9.0, Data Reports, CFML (Cold Fusion), SQL

Server Reporting Tools

Web Design Tools: Macromedia Flash MX/Fireworks & Dream Weaver, Adobe

Photoshop, Visual Studio Front Page, BI Tools.

Server Technologies: SQL Server (7-2012), IIS6, Oracle 10g, Netware,

MySQL

Operating Systems: Windows (NT, 2003, 2008, 2012 Server; XP, 7),

Windows Advanced Server, Windows 2000, 98/95/NT/Me, MS-Dos,

IBM PC, MAC, AS400

PROFESSIONAL EXPERIENCE

Merkle, Inc.

Columbia, MD

SQL (Database) Developer/Warehouse Analyst

May 2014 to July 2014

. Database development in SQL Server 2005/2008 R2 environment with

complex queries and stored procedure

. SQL Server Database administration and performance tuning

. SSIS Package development and maintenance with BIDS (Business

Intelligence Development Studio)

. Analysis and ETL of Salesforce CRM data using SOQL, Workday

Financials/Epicor HCM data with SSIS

. Data Warehouse Data Store management in SQL Server 2005/2008 R2

environment

HMSHost, Inc.

Bethesda, MD

Data Warehouse Analyst June

2010 to February 2014

. 3-staff team development and deployment of Corporate BI Dashboard with

Xcelsius and SAP BOXI r3.1 using BO universes and Web Services, Adobe

Flash and C#.NET as semantic layer-with Full SDLC

. Dashboard ETL Design and development with SQL Server and SSIS 2008

using BIDS and with disparate data sources

. Dashboard ETL maintenance with SSIS 2008, SSMS 2008 and T-SQL complex

store Procedures, Oracle SQL Developer

. Data Warehouse cubes maintenance with SQL Server 2000 & 2012 with DTS

and SSAS 2000, 2012

. BI reporting with SAP Business Objects WebI reports using Universes

and SQL Server SSRS

. Data Warehouse parallel upgrade from SQL Server 2000 to SQL Server

2012 with team members using SQL Data Tools, SSAS, TFS 2012-Full SDLC.

. WebI Reporting Application support and maintenance using ASP.NET and

BO universes.

. Team Lead for offshore team for SAP Dashboard 4 upgrade.

CONSULTING (May 2004 - 2010)

AQUILENT, Inc.

Laurel, MD

SQL Server DBA April 2008

to May 2010

. EPS (E-Procurement System) Database and application support at DOL,

Washington D.C.

. ETL support for NCFMS replacement of DOLAR$ at DOL (Department of

Labor), Washington D.C

. SQL Server Security enforcement, Performance, and tuning - SQL

Profiler, Index tuning for NUMI application at VA (vha.med.va.gov)

. Configuration and installation of Windows 2003 and SQL Server 2005 2-

Node Cluster off-site for production DR for VA NUMI project.

. Implementation of SSRS 2005 Reporting Services at DOL for departmental

r reporting

. Data migration and SQL Server 2005 upgrades at DOL

GDS (Denex Dental)

Rockville, MD

SQL Server DBA August

2007 to April 2008

. Implemented automated Daily NAS recovery model: Full and T-Log backup

. SQL Server Security enforcement, Performance, and tuning - SQL

Profiler, Index tuning.

. Data quality Control, SSIS packages, complex stored procedures and T-

SQL Programming.

. Reporting Server reporting, Data migration

. SQL Server 2005 Upgrades

Constellation Energy Group.

Baltimore, MD

SQL Developer/DBA

May 2007 to Aug 2007

. Large Volume DB and High Availability: database backup and

recoverability, Log Shipping, NAS backup, SQL Server Clustering.

. SQL Server Security enforcement, Performance, and tuning - SQL

Profiler, Index tuning.

. Data quality Control, ETL, complex stored procedures and T-SQL

Programming

. Collaborations with offshore DBA team member for proper maintenance

schedules and to enforce zero-downtown so systems are on 24/7

InPhonic, Inc.

Largo, MD

SQL Report Writer

December 2006 to May 2007

. Financial Systems report design and creation for business intelligence

. SQL Server 2000 reporting using: Report Designer, Visual Studio .NET

2003, and DTS for ETL packages and Cubes design, data mining

. Ad-hoc reports creation using complex stored procedures and data

aggregation for Data warehouse using SQL Query Analyzer; collaboration

with Dashboard (BI) reporting using Qlikview team.

Wolpoff & Abramson, LLP

Rockville, MD

Database Developer October 2006

to December 2006

. On-going Data warehouse project for Business Intelligence, reporting,

and analysis

. SQL Server 2005 development using: SSAS, SSIS SSMS, and BIDS for ETL

packages and Cubes design

. Data extraction from mainframe flat files to Relational Database--

onward to Data Warehouse modeling

SunTrust Mortgage & Loans

Richmond, VA

Database Developer

May 2006 - September 2006

. ETL (Extraction, Transformation and Load) Project to meet Federal

Government Loans and Mortgage compliance regulation

. Created DTS Package that extracts, transforms, and load data for

COGNOS cubes that tracks loan sources and ageing

. Collaborated with COGNOS Analysts to implement business rules in T-SQL

queries and stored procedures

. Optimized the T-SQL queries and stored procedures and reduced job run-

time by 45%

. Created documentation for project and push to production as well as

presentation for training

ChainDrugStore.Net.

Alexandria, VA

Database Developer March

2006 to May 2006

. Created report (with T-SQL) that tracks the workflow process for

pharmaceutical trade show

. Collaborated with web development team with T-SQL queries and stored

procedures for C#.NET web application

. Optimized the T-SQL queries and stored procedures for SQL Server 2005

as well as .NET 2.0 using Visual SourceSafe

Hogan & Hartson LLP.

Washington, D.C.

Database Administrator\Developer January

2006 to March 2006

. Created ETL and DTS Packages between heterogeneous databases--

InterAction CRM and SydneyPlus applications

. Upsized MS Access data to SQL Server 2000 for in-house CRM application

for firm's global employees

. Optimized the MS Access CRM application for T-SQL queries and stored

procedures

Federal Agricultural Mortgage Corporation

Washington, D.C.

Database Administrator October 2005 to

December 2005

. Analyzed database architecture and security and presented report on

better architecture and security

. Implemented better database design, introduced proper SQL Server

security using NT authentication, use of roles and groups

. Implementation of business rules using stored procedures and roles;

Replication for Data availability and off-site data redundancy

. Created and maintained Scheduled Backup and Maintenance schedules for

system performance

MERKLE Direct Marketing

Lanham, MD

Database Developer June 2005

to September 2005

. Data warehousing, data cleansing, database programming with debugging.

Successfully managed large volume (millions) of data

. Designed and developed stored procedures, triggers, and data

transformation processes using Transact SQL and Data Transformation

Services

. SQL programming on backend and front-end configuration for Epiphany

reporting

. Large database design and optimization, data extraction, DTS Packages

T-SQL programming, data extraction

. Design and develop reports for delivering business information

MCI

Ashburn, VA

Senior Application Developer-Consulting May

2004 to June 2005

. Analyzed and made recommendations on project based on data analysis

. Upsized MS Access database to SQL Server 2000 - Improved data

integrity, security and robustness Created DTS packages using T-SQL

scripts, Stored Procedures, Triggers, Functions, and Cursors

. Client-Server database applications development and programming using

MS Access and Visual Basic 6 as Front ends

. Collaborated with web development team to deploy HR management

application on-line in record time

FTE (July 1996 - May 2004)

INFOTEX Corporation

Riverdale, MD

Web Application Developer July

2002 to May 2004

. Developed and maintained e-commerce web sites for company's clients

using ASP, ASP.NET and JavaScript

. Client-Server Database applications development and programming using

MS Access (VBA) and Visual Basic as Front Ends

. Computer Technician, Network installation Consultant

ITECH Services

Frederick, MD

Database Operations Manager December 2000

to May 2002

. Dual DBA and Developer roles: Logical and physical design, and

deployment of database on SQL Server

. Improved and maintained an Access 2000 CRM application for company,

using VBA--a cost-cutting decision

. Upsized MS Access database to SQL Sever 2000, for improved robustness,

security and data integrity

. Cut down time by more than 60%, and increased productivity, security,

and data integrity. Created advanced SP and DTS.

. Managerial--team Lead for the development team that developed

company's web site and data-driven web portal, for thousands of

students and clients from across the country

. Created and maintained Scheduled Backup and Recovery plan;

troubleshoot and database tuning

CREATIVE Computers, Inc

Torrance, CA

Data Analyst/Junior DBA

July 1996 - December 2000

. Executed daily operations of departmental database programming,

scheduled Backup and Recovery, and scheduled maintenance using SQL

Server 6.5 and 7 as junior DBA

. Supervised and executed daily and monthly operations of sales

commission reports using Microsoft FoxPro2.6.

. Created and implemented call center phone reports and statistics using

FoxPro and Excel through VBA programming

. Initiated, tested and implemented electronic reporting through

intranet for the sales department, thereby saving company 25% on

reporting cost

. Provided technical support to customers for both pre-sale and post-

sale assistance on both PC and MAC computers as Tech Support

Technician.

EDUCATION AND CERTIFICATION

El Camino College, Torrance, CA - AA in General Studies

Federal Polytechnic, Ilaro, Nigeria - HND (BSc Equivalent) in Mechanical

Engineering.

Microsoft MCP; Novell CNA (Certified Network Administrator); A+, Apple Gold

Certified.

. Completed Windows 2000 Installation and Implementation course.

. Completed SQL Server Analysis Services (SSAS 2012) for Business

Intelligence Course.

. Completed OCP (Oracle Certified Professional) Oracle 9i classes.

. Now preparing for Oracle (OCP) DBA Exams.

Status: US Citizen.

Contact this candidate