SUMMARY:

• 10 years experience with database design, development, support and administration within SQL DBMS environments. SQL Server 2008, 2005, 2000, and 7.
• 10 years experience writing and structuring T-SQL in the creation of tables, views, functions, and stored procedures within SQL Management Studio and SQL Query Analyzer.
• 10 years experience in all phases of SDLC; requirements gathering and analysis, software and database design, development, implementation, testing and maintenance.
• 8 years experience designing and maintaining web applications utilizing; VB.NET, ASP.NET.
• 5 years experience developing and supporting SQL 2008/2005 SSRS reports.
• 2 years experience developing and supporting SQL 2008/2005 SSIS packages.

PROFESSIONAL EXPERIENCE:

Confidential,Business Intelligence Specialist 04/11 - Present
Business Intelligence / Data analyst responsible for developing and maintaining Tableau dashboards.

• Installed, configured, maintained Tableau Environments; DEV, QA, and Production.
• Responsible for maintaining User and Group permissions across servers and dashboards.
• Extracted data from SQL Server 2008 into data marts, views, and/or flat files for Tableau workbook consumption using T-SQL.
• Designed and published visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.

Microsoft Corporation - CompCon Tech Contract
Operations Support Specialist 09/10 - 04/11
Developed and maintained routing rules for Microsoft\'s premier global technical support tool, MSSolve.

• Directly responsible for developing, testing and troubleshooting routing rules for new and existing Microsoft products.
• Associated new rules to respective products within Microsoft\'s Supportability Business Intelligence System (SBIS) database.
• Analyzed misroutes for possible errors and resolutions.

Confidential,Business Intelligence Analyst / Report Developer 12/09 - 7/10
Analyzed data and developed business reports supporting Field Services.

• Responsible for Weekly Advance and Monthly Commission Payroll processing and reporting.
• Authored stored procedures used in ad-hoc and subscription based SQL 2008 SSRS reports.
• Designed and maintained SSRS reports used to analyze sales, compensation, and earnings data.
• Designed and maintained Tableau 5.1 reports used to graphically analyze business data.
• Updated and manage Corporate Field Services Website.

Confidential,Business Intelligence Analyst / Report Developer 6/09 - 12/09
Developed complex health care reports based on managed data imports.

• Gathered, analyzed and defined business rules used in report requirement documents.
• Designed and supported SQL 2005 ETL / SSIS processes.
• Designed, deployed and maintained Crystal Reports 10 reports.

Confidential,LLC
Data Warehouse Developer / Business Intelligence Analyst 6/08 - 3/09
Maintained data warehouse daily operations. Authored Ad-hoc and subscription based reports.

• Installed and configured SQL Server 2005 instances for data warehouse implementation.
• Assisted in the development and implementation of data warehouse and data marts.
• Assisted in the design and support of ETL jobs and SSIS packages.
• Gathered, analyzed and defined business rules used in report requirement documents.
• Authored complex stored procedures used in ad-hoc and subscription based SSRS reports.
• Designed, deployed and maintained SSRS reports.

Confidential,SQL Developer 2/08 - 4/08
Supported front end application developers with database design, stored procedure changes, and reporting.

• Created and updated SQL 2005 stored procedures as required by developers.
• Designed and implemented SQL 2005 database schema and stored procedures.
• Authored data rich web reports using SQL 2005 Reporting Services.

Confidential,Sr. Programmer Analyst 12/05 - 2/08
Designed and maintained .NET web applications and SQL databases supporting title order-count and revenue reporting systems.

• Administered and maintained SQL 2000 and FoxPro databases used to support a high profile order-count and financial reporting ColdFusion web application.
• Designed and supported ETL import/export processes.
• Supported over 450 end users worldwide via telephone, email and company ticket system.
• Responsible for updating web application code and queries based on business requirements.
• Rewrote legacy reporting application into .NET 2.0 Framework using VB/ASP.NET.
• Assisted in the design and implementation of SQL 2005 database used to support revised order-count and financial reporting .NET web application.
• Initiated the conversion of FoxPro reports to SQL 2005 SSRS.

Confidential,Information Technology Analyst IV 4/00 - 5/05
Designed and maintained .NET web applications and SQL databases supporting medical informatics and clinical information systems.

• Worked closely with LSU Doctors and Clinical Principals to establish, evaluate and define business and system requirements.
• Designed VB/ASP.NET web portal store front, SQL 2000 database, and stored procedures used for keeping track of department scheduling, inventory, documents, and personnel.
• Assisted in SQL 2000 table design and VB/ASP.NET application development supporting an audit trail of a clinical patient record system for the Juvenile Justice System.
• Designed VB/ASP.NET web reporting tool and SQL 2000 database where HL-7 data was mined for demographic data from the 9 Louisiana public hospitals for the LSU Disease Management Database in order to report on health issues across the state.
• Developed and deployed VB6 desktop computerized patient record application, supporting SQL 7 database, and stored procedures on Windows 2K used to replace paper based data collection for the Diabetic Foot Project of Baton Rouge.

EDUCATION:

Diploma in Network Management / MCSE Course
Associate of Occupational Studies / Computer Information Systems
Bachelor of Science / Chemistry (ACS Certified Curriculum)
Dale Carnegie Training - Course in Effective Speaking and Human Relations

CERTIFICATIONS:

• Microsoft Certified Database Administrator (MCDBA) : SQL Server 2000
• Microsoft Certified Solutions Developer (MCSD) : Visual Basic 6