SUMMARY:

• Ten years progressive experience as a SQL Server Developer/DBA with a primary focus on BI and reporting solutions utilizing SSIS/SSRS/SSAS. Strong DBA skills including T - SQL/stored procedure development
• OLTP/OLAP architecture and performance tuning. Intimate knowledge of tools, technologies, and best practices relating to BI. Demonstrated hands-on success completing projects and applying senior level technical skills to complex business problems resulting in higher productivity and lower costs. Excellent written, oral, and interpersonal communication skills.

TECHNICAL SKILLS:

Software/Technologies: MS SQL Server 2000/2005/2008 , SSAS, SSRS, SSIS, DTS, MS Performance Point, MDX, XML,, IIS, Crystal Reports 7/8,.Cognos Impromptu.

Operating Systems: Windows XP/Vista, Windows 2000/2003, Linux, Unix, OS/2.

PROFESSIONAL EXPERIENCE:

Confidential

Consultant - BI Developer/SQL Server 2000/2005 DBA

Responsibilities:

• Created and maintained multiple Data Marts based on external (DPN) and external (MLS) data using DTS/SSIS. Created multiple SSAS Cubes and Data Mining models used for internal reporting and BI. Created and maintained a 1,000+ user reporting system using SSRS. Trained FTE’s to maintain and enhance the reporting system. Installed and maintained multiple instances of SQL 2000/2005/2008 on local and remote servers.

Confidential

Consultant - SQL Server 2000 DBA/Developer, BI Analyst/Developer

Responsibilities:

• Architected and developed a comprehensive BI solution for the Internal Business Systems Reporting Group. Performed intensive data quality/process analysis. Extracted and documented relevant business rules. Designed a low cost Executive friendly front-end solution using Excel pivot tables, VBA, and ASP. .Developed a real time customer service cube using indexed views and ROLAP. Installed and administered SQL Server 2000/ Analysis Server development and production servers. Completed projects on time and under budget.

Confidential

Consultant - SQL Server 2000 DBA/Developer

Responsibilities:

• Designed and developed a T-SQL/DTS based Lead Management application that automates the lead distribution and scheduling of trade show/internet leads in the CRMS - resulting in a 20% increase in Q3 sales forecasts. Developed a CRM Data Mart with Analysis Services/MDX - giving executive management the ability to see real-time forecast numbers by product, channel, and lead source.
• Completed a CRM data quality initiative resulting in lower administration costs and higher prospect/customer contact accuracy. Created and implemented backup/recovery, coding, and design standards for SQL 2000 deployment.

Confidential

Consultant - SQL Server 7 DBA/Developer

Responsibilities:

• Principal Consultant for Peregrine's global Business Intelligence initiative, utilizing MS SQL Server and Cognos Enterprise suite. Performed process analysis/requirements for US Sales/Expense Data Mart..
• Designed and developed staging and star schemas. Designed and implemented ETL methodology ensuring clean/timely data. Installed and administered SQL Server 7 production servers. Educated primary stakeholders in the benefits of multidimensional analysis. Installed and administered Cognos PPW, IWR, Upfront and Access Manager. Delivered pilot Sales Forecast Data Mart on time, and under budget.

Confidential

Consultant - SQL Server 7 DBA/Developer

Responsibilities:

• Developed Data Mart / OLAP solution to track dropout rates during the Confidential .com checkout process using T-SQL, DTS and OLAP Services. Delivered the multidimensional results using ASP and MDX. Administered SQL 7 production Web Product Catalog. Developed ETL scripts for the Telesales Product Catalog conversion from SQL 7 to Oracle 8i.

Confidential

Consultant - SQL Server 7 DBA/Developer

Responsibilities:

• Assisted principles in defining a BI / DSS strategy. Created and put in motion an eight-step BI user methodology. Educated stakeholders in BI /DSS principles and technologies including data management / quality, methodology, multi-dimensional analysis, data warehouses / marts, OLAP, cubes etc
• Developed a prototype data mart using MS SQL Server 7 DTS and OLAP services. Migrated ISAM, Access, Excel and Oracle tables to SQL Server. Developed DTS packages using data transform / mapping, scripting to assist with data type conversion, and system job agent to schedule and run DTS packages. Developed front end to the data mart using ASP / MDX. Installed, configured, and administered SQL Server 7 development and production servers.

Confidential

Consultant - SQL/VB/ASP Developer

Responsibilities:

• Migrated a VB 5.0 client server application from Access/DAO to MS SQL Server 6.5/ADO. Transferred all SQL code in VB form modules to MS SQL stored procedures. Installed and tuned product at numerous client sites and on a variety of network operating systems and protocols. Migrated client/server product to Active-X documents allowing centralization of database servers and a reduction in capital costs.
• Created browser based (HTML, ASP, MS SQL Server) beta testing and technical support applications critical to the success of the client/server product. Developed data access components and ASP interfaces of http://www. Confidential .com using Visual Studio, ADO, and MS SQL Server. Responsible for project budget, resources and deadlines, ( MS Project).