Objective
DBA/Datawarehouse Architect


Summary

please call for resume references

7 years SQL Server development
5 years SQL Server DBA
5 years Data Warehouse OLAP

1099 corp or independent Contract please.

A seasoned database administrator with strong analysis skills and a proven track record of full life cycle development. Mature business and technical vision with superior communications skills to analyze needs with senior management. Design, model, code and implement cost effective solutions with an inherent sense of urgency. Ability to manage multiple complex projects. Innovative and creative problem solver who is dedicated to translating business objectives into sophisticated technical solutions. Excellent SQL query skills with 8 years SQL Server and 7 years development and production DBA experience in highly available OLTP and DSS SQL Server environments 6.5/7.0/2000. Superior aptitude for understanding and acquiring new programming languages and platforms. Ability to perform with minimal supervision. Extensive Big 4/5/6 consultant experience with iterative, full life cycle enterprise development methodology and project management for Decision Support Systems with an emphasis on Data Warehousing and CRM ; custom ETL processes to support those systems and web centric reporting tools that satisfy user information requirements.


Employment

2004 -  2005
Senior SQL Server DBA

Designed and built all database objects for web enabled analytical dimensional and relational financial reporting solution for CFO, senior management.
Mentoring and knowledge transfer of database system specific facilities and internal structure in MS SQL Server 2000 SQL Server, Analysis Services and Proclarity offering best practice advice for new system design, security model, high availability options using MS Cluster Services.

stored procedures, MDX expressions and other database objects in MS SQL Server or 2000.
Coded DTS packages in DTS Designer to facilitate ETL.
Monitored and benchmarked system workloads on staging, development and production servers.
Analyzed data requirements and participated in design reviews.
Developed high level systems process diagrams and physical infrastructure that propose a new technical architecture.
Built star schemas, constructed and synchronized logical and physical design models, data flow analysis.
Designed, documented and coded all database objects ; stored procedures, triggers, index selection and performance tuning.
Created gap analysis, system requirements, business rules and logic, detailed design documents.
Coded ASP forms and calls to server objects using Visual Studio .Net.
Documented run book for change management, operations and QA staff.

2003 -  2004
Senior SQL Server DBA/ Database Architect

Performed an emergency stabilization and optimization methodology to OLTP Client, Server Enterprise Applications on a Microsoft, IBM and CISCO Infrastructure Platform utilizing RAID, SAN and MS Cluster Services technology.
Performed a gap analysis to document application insufficiencies.
Knowledge transfer of SQL Server facilities and internal structure.
Use Microsoft MOF Best Practice SMFs and their methodology to recommend and document a scalable software, hardware and network solution defined.

Analyzed system requirements with senior management, engineers and other stakeholders ;
Documentation of backup, recovery plans.
Built DTS packages to archive closed batch data for improved performance, capacity planning and trending.
Knowledge transfer of best practice of reporting structure, performance metrics, base lining, trend analysis, performance degradation and network utilization.
Responsible for availability and operations plans to insure robust design, streamlined workflows and enhanced performance.

2003 -  2004
Subject Matter Expert/ Solution Architect

Designed a Operations Management system for the monitoring of POS, MS SQL Server 2000 Exchange and IIS Servers in 50 cities in 17 foreign countries using Microsoft Operations Manager and SQL Server 2000 transferring Microsoft best practices under the MOF framework.
Knowledge transfer of MOM and SQL Server facilities and internal structure.
Use Microsoft MSF Best Practice SMFs and their methodology to architect a scalable software, hardware and network solution.

Analyzed system requirements with senior management, end users and other stakeholders ;
Documentation of all replication setup issues and using complex SQL Server merge replication.
Built DTS packages to archive performance and event data for capacity planning and trending.
Knowledge transfer of best practice of reporting structure, performance metrics, base lining, trend analysis, performance degradation and network utilization.
Responsible for writing and executing test plans to insure robust design and performance.

2003 -  2003
Touchstone Partners

Designed and coded interface and database objects for web enabled OLAP, ROLAP application in Cognos 7.1 Suite and SQL Server 7, SQL 2000.
Coded VBScript DTS packages in Visual Basic 6 and DTS Designer to streamline ETL.
Knowledge transfer of database specific facilities and internal structure.
Responsible for all database objects on multiple servers in the Development, Component Test and Product Test environments.
Conducted design reviews and code walkthroughs with client developers.
Responsible for all replication setup issues and documentation using SQL Server Replication ; ETL of legacy data.

Coded all stored procedures, triggers, UDFs, MDX expressions and other database objects in MS SQL Server 7.0/2000. Conducted user interviews to determine business requirements.

Analyzed data requirements with senior management, end users and other stakeholders ;
Constructed and synchronized Logical and Physical Design models and sub models, data flow analysis, script generation of Physical Design Models using Erwin 4.
Documented business rules and logic in Database Requirements and Detail Designs.
Administered Cognos 7.1 Power Play, Impromptu, IWR, Query Servers in both design and production environments. Installed all software and upgrades.

2002 -  2003
CHX Specialists

Designed and built database objects for web enabled analytical OLAP warehouse solution.
Knowledge transfer of OLAP specific facilities and internal structure in MS SQL Server 2000, SQL Server Analysis Services and Microstrategy 7.

Coded all stored procedures, MDX expressions and other database objects in MS SQL Server 7.0/2000.
Coded DTS packages in Visual Basic 6 and DTS Designer to facilitate ETL.
Monitored production servers responsible for scheduled DTS tasks.
Analyzed data requirements and participated in design reviews.
Developed high level systems process diagrams and physical infrastructure that propose a new technical architecture.
Built star schemas, constructed and synchronized logical and physical design models, data flow analysis.
Designed and coded multidimensional expressions to query OLAP cubes.
Documented business rules and logic.
Built Pivot Tables in Excel to prototype cube functionality.

2001 -  2002
Senior SQL Server DBA

Designed, coded and tested Intranet CRM solution using IBM DB2 and Microsoft SQL Server SQL Server Analysis Services.
Mentoring and knowledge transfer of OLAP specific facilities and internal structure to end users.

Coded all stored procedures, MDX expressions and other database objects in MS SQL Server 2000.
Designed and coded DTS packages in Visual Basic 6 to facilitate ETL from DB2 under OS/390
Monitored all production and development servers ; maintenance, tuning of existing SQL statements and procedures.
Analyzed and documented data requirements and participated in design reviews.

Modeled ER Diagrams for summary tables ; star schemas, constructed and synchronized logical and physical design models, data flow analysis using ERWin.
Designed and coded multidimensional expressions to query OLAP cubes in SQL Server Analysis Services.
Coded ASP forms and calls to server objects using Visual Studio 6.
Built Pivot Tables in Excel to deploy user defined cube functionality.

2001 -  2001
Senior SQL Server DBA

Designed and built database objects for web enabled analytical OLAP warehouse solution.
Knowledge transfer of OLAP specific facilities and internal structure in MS SQL Server 2000 SQL Server Analysis Services.

Coded all stored procedures, MDX expressions and other database objects in MS SQL Server 7.0/2000.
Coded DTS packages in Visual Basic 6 and DTS Designer to facilitate ETL.
Monitored production servers responsible for scheduled DTS tasks.
Analyzed data requirements and participated in design reviews.
Developed high level systems process diagrams and physical infrastructure that propose a new technical architecture.
Built star schemas, constructed and synchronized logical and physical design models, data flow analysis.
Designed and coded multidimensional expressions to query OLAP cubes.
Documented business rules and logic.
Coded ASP forms and calls to server objects using Cold Fusion 4.
Built Pivot Tables in Excel to prototype cube functionality.

2000 -  2001
Data Architect

Designed and coded interface and database objects for n-tier database intranet application in Visual Basic 6 and SQL Server 7.
Knowledge transfer of database specific facilities and internal structure.
Responsible for all database objects on multiple servers in the Development, Component Test and Product Test environments.
Monitored and tuned database objects using Profiler, Query Analyzer.
Provided developer support and mentoring for n-tier applications using Visual Basic 6 COM+, DCOM, ASP, TCP/IP on MTS.
Installed and deployed MTS.
Conducted design and code walkthroughs with client developers.
Responsible for all replication setup issues and documentation using Data Mirror ; ETL of legacy financial data from DB2 and Oracle.
Conducted user interviews to determine business requirements.
Analyzed data requirements and participated in design reviews.
Built Entity Relational Diagrams
Constructed and synchronized Logical and Physical Design Models and module sub models, data flow analysis, script generation of Physical Design Models using Sybase Power Designer.
Documented business rules and logic.

1999 -  2000
Database Administrator

Designed and coded database objects for wireless Java extranet solutions in SQL Server 7.0 Sybase SQL Anywhere for Windows CE, Sybase Adaptive Server 11.5
Knowledge transfer of database specific facilities and internal structure
Conducted user interviews to determine business requirements
Analyzed data requirements and participated in design reviews
Built Entity Relational Diagrams
Constructed and synchronized Logical and Physical design models, data flow analysis, Script generation of Physical Design models using Erwin.
Documented business rules and logic.
Conducted design and code walkthroughs with client developers.
Resolved ODBC issues.
Designed and implemented complex replication schema with Sybase Replication Server between wireless mobile databases using SQL Anywhere, SQL remote technology and wireless Orinoco hubs to data repositories in Sybase Adaptive Server 11.5 and SQL Server 7.0.

1998 -  1999
SQL Server Database Administrator

Conducted user interviews to determine business requirements.
Analyzed data requirements and participated in design reviews.
Designed and modeled scalable online relationship marketing databases for Internet and extranet deployment.
Managed team of 4 developers using VB 5/6 - Inter Dev to build ASP for online record updates and reporting.
Responsible for all administration duties, performance and index tuning, SQL queries and stored procedures.
Capacity planning.

1996 -  1998
DBA

Designed, developed and implemented SQL Server database solutions to support currency tracking systems for JD Edwards 1 World financial modules using Microsoft Access 2.0/97 Visual Basic 4/5 SQL Server 6.0/6.5 Crystal Reports 5.
Conducted user interviews to determine business requirements.
Analyzed data requirements and participated in design reviews.
Responsible for all database administration of development and production environments for these databases.

1994 -  1996
Database Analyst

Built databases in Access 2.0 and Visual FoxPro to provide management and planning applications for Purchasing, Production, Human s, Logistics and Training departments.

Performed needs and skills assessment of end users.
Trained end users in Microsoft Office products and Lotus Notes.

1991 -  1994
Analyst

Assisted in the implementation of EDS payroll and Personnel Management System using Cobol under IMS Database.

Graduated Cum Laude.

1998 -  Present

2000 -  Present

Education