Sql Server Analyst

Wendell J. Nieuwendam

**** ********* **

Tampa, FL 33624

Home: 813-***-****

********@*******.***

Cell: 813-***-****

[pic]

Experience:

eMason Corp.

Tampa, Florida

**/** - **/**

DBA Developer/Data Analyst

. Manage and support all database activities and processes of client

data Suntrust bank, Green Tree and FNMA loan processing web based

system. Support web based application for financial processes and loan

modification programs.

. Managed and worked on daily client production issues in a fast paced

environment to make sure that client needs are meet on time without

delaying critical daily processes. Also responsible for rotating

nightly shift monitoring overnight job activity processes that are

critical to our client needs in the financial industry.

. Member of calc team and solution design. Develop and maintain the team

database projects and production support.

. Manage SQL 2008 R2 server and support more than 50 SQL instances using

tools such as Spotlight, Redgate, IDERA and other company developed

tools. Also created DTS\SSIS automated packages Integration Services.

Manage and maintain data ware house structure, database objects and

elements needed to support client needs.

. Ensure that data integrity using features of RDBMS such as physical

integrity and internal structures are implemented. Write T-SQL code

and create stored procedures, queries and triggers for DEV team to

support application development.

. Responsible for defining and maintaining best guidelines and standards

for metadata, data modeling and data management. Translate business

requirements into long-term data architecture solutions, including

logical, conceptual and physical models.

. Use technical tools from MS Visual Studio 10 and 12 for research,

trouble shooting and data analysis. Develop complex T-SQL code for

various business requirements and reporting needs.

. Project team member during upgrades and migration of various large

databases from SQL Server 2000 to 2005 and SQL Server 2005 to 2008.

. Business Objects and Crystal Reports - installation, report

development, publication, and training.

CareCentrix.

Tampa, Florida

08/09 - 07/10

DBA/Data Analyst/Reports Developer (Consultant)

. Data Analyst coordinating medical records processing and load into MS

SQL 2005 database. Plan, design and implement application database

code objectives, such as stored procedures and views using MS SQL

2005.

. Build and maintain T-SQL scripts, indexes and complex query procedures

for data analysis and extraction. Assist developing DTS/SSIS packages

for IT department. Apply changes to documentation of Software Product

Life Cycle process.

. Worked with Centene and Cigna medical billing data making sure state

and federal requirements are implemented and processed. Automate

manual billing system applications using Access and Excel 2007.

Develop accurate management reporting system by integrating already

existing modules with their current MS SQL 2005 database.

. Research and apply technical solutions using MS Business Intelligence

architecture in MS SQL 2005, Excel and Access 2007. Work with business

development, application developers and production teams across

functional units to identify business needs and solutions options.

MobileTec International.

Tampa, Florida

10/04 - 08/09

Systems Analyst/ Programmer Analyst

. Developed and deployed Public Safety software for Law Enforcement

Agencies and Security facilities in the US and Canada.

. Programmed and automated Excel spread sheets and reports using VBA and

Macros.

. Programmed SQL queries scripts, stored procedures, triggers and

indexes using MS SQL 2005 database.

. Worked with programmers and network engineers to develop syntax and

algorithms software requirements.

. Programmed majority of corporate reports using tools like Crystal

Reports XI and MS SQL 2005 reporting services.

. Responsible for the legal data migration and data conversion of Law

Enforcement agencies and Security facilities records from Oracle

database 9 to MS SQL 2005 database.

. Managed IBM AIX technology project for the NYC Sheriff Department.

Deployed a communication switch to interface with the State's

mainframe computer. Conduct project development meetings with various

law enforcement agencies.

Wendell J. Nieuwendam

[pic]

Thompson Publishing Group. Tampa,

Florida

05/99 - 10/04

Sr. Systems Analyst

. Managed Government Legislative Publishing database system using MS SQL

2000.

. Programmed and customized customer tracking database in Access 2000.

. Developed various management reports using Crystal 8.0, Excel

2000\2003 VBA, and Access 2000\2003 VBA. Used ODBC connectivity

between SQL server and report writer.

. Managed daily activities and special projects for the Maryland

Telemarketing Division.

Accomplishments: Developed and implemented a complete reporting system

using Crystal Report, Access 2003 database, and MS Query utilities SQL

syntax. Create technical documents to support product design requirements.

Aegon USA.

St Petersburg, Florida

11/97 - 05/99

Systems and Control Analyst

. Responsible for Viper/Oracle job stream and daily record processing

for investment portfolios and annuities.

. Programmed PL/SQL queries using Oracle database reports. Created UNIX

scripts for emergency processes for systems failures during disaster

recovery.

Goldman Sachs Corp.

Princeton, New Jersey

10/91 - 10/97

Financial Analyst (Team Leader)

. Primarily responsible for the development and implementation of

automated securities and financial reporting systems.

. Managed the company main database system using FoxPro 5.0 on Windows

NT network environment.

. Worked with commodity brokers and Foreign Exchange traders from Europe

and Asia to improve trading systems.

Education:

Saint Peter's University (Jesuit)

Jersey City, New Jersey

MBA - Management Information Systems - 1997

International Business

The Metropolitan College of New York New York, New

York

BA - Business Administration - Accounting and Finance - 1989

Manhattan Career Institute New

York, New York

Computer Programming - COBOL I & II and "C++" - 1984

Qualifications:

Computer Hardware: Dell Microsoft Exchange Server 2003 & Microsoft

Enterprise Server 2008

IBM AIX RISK 6000 P V5.2 LINUX

Computer Software: Microsoft SQL Server 2000\2005\2008 R2\2012 R2,

T-SQL, SSIS/BIDS/SSAS, Visual Studio 8 & 10 & 12

MS Office 2003/2007/2012, MS

Project 2007, MS Visio 20003/2007/2012, Crystal Report 9.0 and XI

Spotlight (Monitoring), RedGate

Tool belt, SQL Compare, SAS, IDERA

Adobe Pro 9.0, QuickBooks,

UML\RUP, XML, ASP.NET, VBA + VBScript, HIPPAA

Certifications: Microsoft Cert. Windows Server 2003, SQL

Server 2005 Developer, Cigna Health compliance.

CSM - Certified Scrum Master,

Agile Methodology, SDLC/ALM - Application Life Cycle Management.

Languages: Dutch.

Activities: Football, Soccer and Basketball.

Contact this candidate