SUMMARY:

• An IT professional and technology evangelist with over 25 years of experience with Microsoft platforms for business intelligence, application development and SQL development and administration supporting a variety of industries. Most recently transformed how Active Directory and Exchange migrations are scheduled and executed with a custom application. Previously created a tool specifically for end user desktop migrations with similar features. These tools are both valuable in saving costs over off - the-shelf products and reusability. This creative thinking in streamlining migrations has led to many recognition s for innovation as well as the
• Business Analyst, Developer and Project Manager. Has an incredibly broad skill set including Business Intelligence, .Net, ASP.Net, JavaScript, SQL, Teradata and Network Infrastructure, and VMWare. Leverages an efficient blend of technologies to design and communicate the right solution for the problem. Manages expectations and able to tailor conversations for stakeholders of all levels.

TECHNICAL SKILLS:

Languages & Development Tools: SQL Server SSIS/SSAS/T-SQL, C# (ASP.Net, Winform Applications), PowerShell, VBScript, WMI, SMO

Database Management Systems: SQL Server v6.5 through v2016, Teradata

PROFESSIONAL EXPERIENCE:

Confidential

SQL SME

Responsibilities:

• Created a tool for requirements gathering/recording and end-to-end testing to improve the efficiency of communications and promote governance for a custom SQLaaS consulting engagement.
• Created .Net Winforms application that can be used for SQL Server configuration requirement collection, saving of that configuration and later testing that configuration against the newly developed live SQL Server.
• Application used to streamline conversations with a DBA and isolate puppet developer from direct contact with the DBA to reinforce governance and roles within the project.
• Used Systrack to collect an inventory of software and version installed on every enterprise desktop and processed into a central dimensional database with SQL Server SSIS.
• Collected inventory of hardware and user assignment from multiple system and loaded to central database.
• Created analytical reports showing version spread and hardware requirements vs. existing hardware to identify potential issues during deployment.
• Assisted in identifying true needs for software and versions to collapse the licensing, negotiating volume licensing when able.
• Worked with team to deploy to virtual desktops reducing cost of hardware.
• Custom solution was reused extensively to carry out end-user-desktop migrations.
• Leveraged SQL Server SSIS for staging and transforming fairly low quality data from a variety of sources into a very solid database, the database being the heart of n-Tier architecture.
• Developed a C# Winforms application in Visual Studio 2015 for users to perform the tasks of migration scheduling and communications delivery.
• Worked with migration counterparts to directing them to create PowerShell scripts which execute the operational components of the migration and provide execution logging and feedback to the central migration database.
• Automated reports to provide visibility into all aspects of the migration and progress.
• Trained users on the use of the migration scheduling tool
• Responsible for the design of an all-encompassing solution that ties together user interfaces, reporting, execution statistics, generation of data files consumed by the PowerShell migration scripts
• Added a role-based user interface to support a different user experience for users with different project responsibilities.
• Created a 4 node environment with 2 High Availability (HA) nodes within each of 2 geographically separated Disaster Recovery (DR) sites
• Created an environment that contained multiple AlwaysOn Availability Groups (AAGs) that could fail over independently of each other.
• Created PowerShell scripting to orchestrate failovers, using a reusable PowerShell function library.
• Replaced an inefficient VBScript based ETL solution (20 hours run time) to a flexible SSIS solution gathering data from various data sources (employees/users, devices/computers, applications/usage, etc.) and directly connecting to systems eliminating the need for interim data file extracts with a load time of less than 2 minutes.
• Redesigned central database to a dimensional model to support reporting through robust analytical tools like Excel PowerPivot.
• Built an application in C#.Net to support end-user manipulation of the solution data to complete the rationalization phase.
• Constructed a solution using Microsoft’s MAP Toolkit. Using the data gathered by this tool, selected key items from the tool’s database to create a dimensional model to support use of Excel PowerPivot to browse data and make decisions related to a SQL Server migration of over 13000 databases spread across over 400 instances on over 250 servers spanning 9 domains.

Confidential

ETL Developer

Responsibilities:

• Managed several fairly complex ETL scenarios to flow data from sources to dimension and fact tables and ultimately the solution cube.
• Leveraged an ETL framework which speeds development and allows for reporting against the ETL processing and database driven configurations to meet client requirements to standardize and package deployments.
• Leveraged Windows scripting to automate scheduling and execution of nightly processing.
• Performed SSIS ETL Framework setup and configuration.
• Conducted SSIS package development.
• Developed scripts to support initiation of SQL jobs and running of batch processes.
• Developed SSIS deployment strategy.
• Loaded select business terms into IBM Business Glossary.
• Set-up/configured data quality rules on select data items, using IBM Information Analyzer.
• Created reports for monitoring data quality, using IBM Information Analyzer.
• Created a stored procedure based solution to extract data from various healthcare systems, apply business logic and load to an application database to assign Confidential ts to a 4 tier classification system allowing the client hospital to target Confidential ts in an underserved community with quality care opportunities.
• Created an application to manage the Definitive Software Library (DSL) component of 2 EUC Windows migration projects. Application was created quickly with MS Access using SQL Server as the data back-end leveraging MS Access as the application development platform for this quick turnaround delivery.
• Created applications with form controls managing event actions with VBA.
• Created Excel front-end with embedded ADO controls to manage data import from Teradata to populate worksheets in a fairly large workbook critical to a business process replacing a cut and paste process with a solution managed entirely through form controls.
• Integrated client’s database helper code module to provide global access to database functions across VBA in all worksheets in a large workbook.
• Created queries and stored procedures using Teradata in support of an application sourcing data from this platform
• SQL Assistant client.
• Integrated Teradata connection (ODBC configuration) into a Microsoft Excel application using VBA and ADO to retrieve and populate data in the application.
• Loaded select business terms into IBM Business Glossary.
• Set-up/configured data quality rules on select data items, using IBM Information Analyzer.
• Created reports for monitoring data quality, using IBM Information Analyzer

Confidential

Application Architect

Responsibilities:

• Developed load process using SSIS in conjunction with a standardized data file format.
• Performed interface design and data modeling (Interface between file upload application and data load component).
• Conducted deep analysis of previous vendor solution and data quality.
• Performed SSIS package development.
• Developed C# components in packages to perform specific advanced tasks.

Confidential

Application/Business Intelligence Architect

Responsibilities:

• EDI Messaging
• Coordinated with EDI Team
• Assisted in determining appropriate message type
• Created dimensional data model.
• Created SSIS packages to load staged message data.

Confidential

SQL Server DBA - Assessment

Responsibilities:

• Conducted a thorough SQL Server Assessment
• WMI Scripting to collect performance data
• Loaded to database
• Developed reports on performance metrics
• Provided a detailed analysis of SQL Server environment with recommendations for adhering to best practices

Confidential

SQL Server DBA - Tuning/Troubleshooting

Responsibilities:

• Responding to a decrease in performance in client’s SharePoint hosted Outlook applications, investigated network, application design, infrastructure maintenance and patch strategy to find opportunities for improvement in each area. Upon visually looking at SQL Server Current Activity it was apparent that the client had started running an internally developed application that consumed over 95% of the entire server’s resources in a shared environment. Once the process was stopped the server performance returned to normal.

Confidential

Application/BI Architect

Responsibilities:

• .Net Framework 2.0
• C# .Net
• MDX
• Office Web Components
• JavaScript

Confidential

BI Solutions

Responsibilities:

• Created reports and utilities for a Unitrac (CRM)
• SQL Server 7.0/2005
• Java
• WebLogic
• Created a threaded mass-mailing utililty to send emails from Unitrac data from company leaders to their clients with personalized content

Confidential

Management Reporting

Responsibilities:

• Cognos Impromptu
• Cognos PowerPlay
• SQL Server 6.5
• MS Access Reporting

Confidential

Quality Assurance

Responsibilities:

• Software testing and bug tracking
• Support for Gerber CAD/CAM software and hardware products

Confidential

Chinese Mandarin Cryptologic Linguist

Responsibilities:

• Communications operator
• Qualifications and examiner
• Ground Mission Analyst leading Chinese operators during live missions