Training and delivery of Microsoft and 3rd party Curriculum at Microsoft training centers and onsite corporate training. Specializing in SQL Server 2005, 2008, 2012, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, BizTalk Server, SharePoint Administration, .NET development(C# / Visual Basic .NET) and Active Directory.

* Manage 8 SQL / SSIS / BizTalk Developers* Create and manage SSIS packages for Client Analytics* Perform data cleansing and conversion based on client requirements* Migration of SQL 2000 DTS packages to DSTSX SSIS to run under SQL Server 2008 R2* Automated DTS packages to execute without intervention* Increase performance of SQL queries and currently running ETL jobs* Design and build Data Warehouse for pharmaceutical analytics* Performed Administration of BizTalk 2009 Servers

* Design and Administration of ETL SQL Server Farm.* Managing, Creating, Deploying and Scheduling SSIS packages for daily execution.* Develop SSIS packages for custom KPI application without the use of SSAS/SSRS.* Assist in SSIS Development for Salesforce.com initiative.* 24/7 SSIS application support.* Converted Business Objects Reports to SQL Server Reporting Services* Assisted in design of Transactional Data Mart (Star Schema) for data migration on SQL Server 2008* Preparation of data on Oracle, Netezza and SQL Server 2000 and 2008 for migration to SQL Server 2008* Migration of data from Oracle and Netezza to SQL Server 2008 using SQL Server Integration Service (SSIS / ETL)* Performance monitoring and tuning of SSIS packages and queries.

- Lead designer and developer for SQL Server 2000-2005 conversion.- Managed multi-terabyte data storage system- Experience gathering requirements, and designing to product specifications- Responsible for data base query and index performance monitoring and tuning using SQL Trace, Apex Database tools and Quest Database management suite- Isolated problem queries by creating and monitoring server side SQL Trace- Managed backup and recovery for multi-terabyte systems using Idera SQL Safe- Managed SQL Databases with Apex SQL suite of utilities- Provided data masking for development using Net 2000 Data Masker- Applied service packs and hot fixes for SQL Server 2000 and SQL Server 2005- Provided capacity planning and analysis- Migrated SQL Server 2000 to Microsoft SQL Server 2005- Migrated SQL Server DTS / DTSX from SQL Server 2000 to SQL Server 2005- Designed documented and created ETL / SSIS applications gather data from OLTP databases on SQL Server, DB2 on AS400 and Oracle into OLAP cubes- Created custom .NET scripts for administration and performance of DTSX packages.- Implemented database resizing and table partitioning on SQL Server 2005- Implemented database purge operation for rapidly growing transactional databases- Setup and managed Transactional and Merge Replication- Database monitoring and setting up automated disaster recovery- Configured scripts for remote deployment and migration- Set up self monitoring and self healing; calls were sent out to / via Blackberry devices.- Designed migration to SQL 2008

Training and delivery of Microsoft and 3rd party Curriculum

Training and delivery of Microsoft and 3rd party Curriculum

Report directly to CEO and CFO.* Planned, installed and managed corporate network.* Developed and created software engineering team of 14* Actively participated in design of Parts Online software* Designed and managed the development of Parts Online for small engine and home appliance industry.* Supervised the design of document management software.* Planned, installed and managed internet connectivity and security for company * Designed and Implemented « terabyte Microsoft SQL Server 7.0 database for online parts lookup application.* Designed, Developed and Implemented Analysis database for Q&A of small engine and appliance manufacturers.* Managed backup and recovery of SQL Server and Exchange Server.* Implemented Merge replication to support parts and diagram updates.* Designed and implemented Internet Service Provider organizational unit for custom web design clients.* Provided 24/7 on call support for application and mail servers* Supervised development of Internet e-commerce software.