PROFESSIONAL SUMMARY

Highly organized SQL Server dba/data warehouse developer, with a focus in ETL (Extract/Transform/Load),OLTP,OLAP,query optimization, data modeling, reporting services with experience in Sharepoint Services, and .net web applications.

• Exceptional problem solver, able to grasp complex systems and application problems, and break them down into smaller, easily executable solutions.
• Effectively collaborate with senior management to deliver software systems projects with substantial bottom-line impact.
• Exceptional work ethic, willing to do whatever it takes to complete critical tasks on schedule.
• Approach projects with enthusiasm, a positive attitude and a sense of urgency. Consistently exceeding performance expectations.

TECHNICAL SKILLS

Development/Tools: SQL,SSMS,SQL Profiler, Query Optimizer, Visual Studio 2002-2008
Databases: SQL Server 2000,2005, 2008, Oracle, Sybase, DB2
Software: MS Visual Studio 2005,SharePoint 3.0, MS Office, MS Reporting Services 2000/2005/2008, MS CRM 3.0

PROFESSIONAL CERTIFICATIONS

MCSE - Microsoft Certified Systems Engineer
MCDBA - Microsoft Certified Database Administrator SQL 2000

PROFESSION EXPERIENCE:

Confidential,2008-Present
Integration Architect/Database Developer

Confidental, engine for importing data from many sources "Oracle, SQL Server, Main Frame, Sybase etc..." to databases OLTP. Generate standardized SSRS reports to insure data quality. Performance tune sql queries and stored procedures with sql query optimization tool. Create Indexes and stored procedures to improve query and etl performance. Develop central repository for sql server health, state, and job monitoring with MSMQ notification. Architect and populate OLAP data mart for enterprise wide reporting. “SSIS” Set-up and configure sql logging shipping and sql mirroring environment. Database Administration 2005 migrating to 2008.
Environment: C#,VB.NET,SQL 2005-2008, XSLT,SSRS,SSIS 2005-2008,Log-Shipping, Clustering, HL7.

Confidential,2007- 2008
Enterprise Application Administrator

Database Administrator for all backend application databases, performance tuning, backup/recovery, sql programming. Design and populate OLAP database for SAS cubes from JDE using SSIS. Build SSIS API to transfer data from JD Edwards to MSCRM. CRM & SharePoint Admin/Configuration SQL Report Development Gather requirements for MOSS integration projects. Set-up, Design and implement solutions from start to finish as business moves to SharePoint. Install and configure integration points for CRM and MOSS “SSRS Integrated Mode, CRM Document Libraries, CRM Mobile”.

Confidential, 2004-2/2007

Administrator/Build custom .net 2.0 tools to assist in that administration of proprietary manufacturing web order entry. Develop and Maintain DTS etl jobs that populate sql data base from db2 for web order entry system. Development enviroment DBA back-up restore/ keep in sync with software migrations. Administrator Frontstep CRM system utilized as warranty service system. Developed and Maintain DTS jobs that populate CRM databases. Build and create Crystal reports for end users based on CRM data. Develop conversion strategyfor moving from Crystal to SSRS. Sharepoint 3.0 development, Administration and Integration”.net 2.0 application/ SSRS 2005”.

Confidential,
Developed and Maintain .net and dts etl for moving data from data repository. Implement SSRS 2000 for financial reporting for the bank monthly reporting. Support various internal .Net Apps and make code changes as needed.

Confidential,
Lead DBA set-up backup and recovery strategy. Implemented synchronization between application database MySql and billing database MSSQL. Adhoc reporting. MSSql server code reviews from .net developers. Architect sql database for new development. Design and program web based check program to print large volume of business checks, complete with up load and check security, built in to browser based print function. Database design and generation of stored procedures and views across a linked server. Create Views through distributed queries for billing purposes. Support for windows based application and web based solutions. Web Application lead for Video Conferencing solution built in C#, ActiveX, with java-script event handlers. Design dynamic pages using”AJAX”, C#, Java-script, CSS, J-Script, and HTML. Application handles live video conferencing, chat, application sharing with intuitivelayout and ease of use as primary objectives. Gathered business requirements for online streaming media applications for promotional marketing and broadcasts. Project Manager of all application development SDLC to implementation. Trouble shoots on and off site network, and hardware problems in high stress environment.

Environment: C#, MSSQL 2000-2005, VB.Net, WS 2000/2003, MYSQL

Confidential, 2001 2004
Data Analyst/Project Manager Out of Business
Key contributor in the administration & testing of SQL databases, and the development/integration of database software, Web-based applications and .Net GUIs supporting back-office financial, sales and marketing systems.

• Lead numerous concurrent systems/data analysis and e-commerce software projects, and support text, HTML and streaming video-based e-mail marketing campaigns in compliance with spam laws. Primary project liaison with end-user, marketing team and the BOD groups.
• Maintain the Internet-based large account auto-responder e-mail marketing system, as well as Web-casting, on-demand streaming video and a host of Internet marketing applications using ColdFusion, PHP and ASP.
• Member of the R& D team driving Internet-based projects. Also key player on the Business Analysis team with members including the CFO, COO, CEO, IT Manager and Lead Programmer.
• Produce custom SQL database reports for sales and marketing. Execute DTS imports and exports.
• Desktop/Application Support of 150 computers and terminal service users.
• Filled in as acting manager in COO’s absence.
• Develop pre-sales multimedia sales presentations.

Key Accomplishments:

• Perform marketing and financial analysis, and build custom SQL-based reports to streamline accounts payable/receivable processes and improve product/revenue forecasting. Train marketing staff in application use.
• Successfully delivered projects on schedule and within budget despite tight deadlines and limited resources.

Environment: Delphi, .Net, ColdFusion, PHP, ASP

EDUCATION
Bachelor of Bus ADM /Major Management Information Systems