Sql Server Data

JAMAL ETAHIRI (********@*******.***)

US Citizen

I have 10+ years of experience as an Excel and Access Developer; I have

extensive experience in data analysis, design, development, implementation,

testing, documenting database processes, creation and maintenance of VBA

code and applications and 5+ years of SQL Server experience.

I possess a proven experience analyzing problems, developing and

simplifying procedures and recommending innovative solutions. I have proven

ability to work effectively with colleagues and management. Have very

extensive knowledge of Microsoft office tools. I am committed to the

highest level of professional and personal excellence.

EDUCATION

RCH Technical Institute Renton, Washington

Associate Degree in Computer Programming

Paul Valery University Montpellier, France

License A.E.S / G.S.E.O. Human Resources & Marketing

CERTIFICATION

George Washington University

Project Leadership, Management and Communications

SKILLS

. MS Access: Design, code, debug, documenting process and test

Access Databases.

. VBA: Automating MS office applications using scripts, Macros and

functions.

. SQL: Scripts, Stored Procedures, SSIS/DTS, Database Objects

. Data Mining, Data Analysis

. Design Excel reports, Excel Apps, KPIs and dashboards.

. Design Power Point Presentation

. Conversion of VBA code, Excel files and Access databases from

previous versions to newer versions (2003, 2007,2010,2013)

. Connecting Excel and Access to SQL databases

EXPERIENCE

Microsoft, Corp Redmond, Washington

February 2014 - April 2014

Data Administrator (Short Term Contract for temporary process)

. Update partner accounts in NG CRM based on changes happening in

MPL, MPN, Current State CRM, communicated by DMS.

. Daily bulk migration of Partner created and updated

opportunities/PGOs through PSX, from current state to NG CRM as

partner deal.

Boeing Aerospace Operations, Inc Everett, Washington

February 2008 - December 2013Data Analyst and VBA/Excel/Access Developer

. Developed VBA/Excel applications and Access databases linked to

SQL to generate data for 787 ALIT Group.

. Communicated with the team members to properly identify system

requirements, milestones and deadlines are met.

. Designed Excel based reports with ODBC connections to SQL or

Access databases.

. Developed Excel applications and GUIs to manipulate data and

backups to SQL Databases.

. Created VBA programs to automatically update Excel workbooks,

encompassing class and program modules and external data queries.

. Develop GUI interfaces using Open Database Connectivity (ODBC) to

connect to Database Management Systems

. Utilized VBA scripts to build user defined functions and features

into Excel and ensured to match data by using common

characteristics found within the data set.

. Ensured smooth transition of support, enhancement, and

maintenance.

. Ensured maximum performance of processes in coordination with

internal IT teams

. Developed SQL scripts and SSIS packages on a SQL Server database

. Created SQL Database Objects like Tables, Stored Procedures and

Views

. Conversion of data into MS SQL server using DTS packages

. Data migration between different environments

Honors/awards

Pride @ Boeing: Recognizing exceptional

performance award October, 2010

AT&T / Cingular Redmond, Washington March

1999 - November 2007

Data Analyst and VBA/Excel/Access Developer

. Developed applications using VBA and Excel macros and numeric

functions to satisfy business needs.

. Analyzed requirements from business stakeholders to define and

document functional processes and translate them into functional

and technical specifications while processing the data using

complex Excel routines.

. Gathered and evaluated end user requirements for data and reports

needs developed using Excel.

. Supported customer needs by creating multiple Access databases

and ad-hoc reports to process raw data, and wrote SQL queries to

pull data from the company's main databases.

. Was responsible on tracking National E-911 emergency statistics

to generate reports for senior leadership.

. Designed ad-hoc and scheduled reports in Excel to analyze and

summarize emergency metrics 911data at a national level and

followed up with regional and local market managers to improve

their metrics.

Honors/awards

AT&T Wireless: National Operations GPGS Award

November, 2004

AT&T Wireless: National Operations GPGS Award

April, 20

[pic]

Contact this candidate