Summary:

An abundance of knowledge and experience through trials/failures/success.

• Technology professional with 25 years of diverse IT experience.
• Emphasis in MS SQL Server, Data Integration, SharePoint/Office 365, CRM solutions.
• 15 years of full cycle web-based development using integrated and stand-alone tools.
• 15 years developing with VB / C / ASP style applications.
• 7 years of experience in data warehouse, data mart and Report development, architecture, data modeling, data cubing, design, mapping, extraction, migration, data validation, administration and design/development of various Enterprise Solutions.
• Strong .NET experience using Best Practice approaches.
• Solid understanding of Object-Oriented OO languages and tools.
• Experience as a DBA and a developer for SQL Server, Oracle.
• Experience and skills developing MS Office and VBA solutions.
• Experience in C using MFC, ATL and COM.
• Forever willing to learn teach something new.

Skills:

Technical:

• SQL Server All versions from 6.0 to 2012 TSQL/DTS/SSIS/SSRS/SSAS
• SharePoint All versions from 2003 to 2013
• MS Dynamics CRM 2011/4
• IIS, ASP.NET/ASP, VB.NET/VB, C , AZURE
• Visual Studio All versions from 6.0 to 2013 Ultimate
• JavaScript, VBScript, PowerShell
• ADO.NET/ADO, HTML/DHTML, XML XSL, XSLT, XPATH , MTS/COM/DCOM/COM
• Oracle 9i/8i/7.1.6/7.1.4/7.0.13 for UNIX and Personal Oracle 7.1.4 for NT w/CDE2 tools
• MS Visual Basic 6/5/4/3.0/2.0, Microsoft Visual C 6.0/5.0/4.0/2.0/1.0
• Windows All versions from 3.1 to 2012 R2
• HP UA UNIX SVR4, AT T UNIX SVR4, IBM AIX UNIX
• Novell NetWare 5.xx/4.xx/3.xx
• MS Office All versions from 95 to 2013
• MS-DOS 3.x through 6.x

Hardware:

• PC Servers w/Intel 64-bit, x86 processors, multi-processors, RISC processors, Desktops, Laptops Tablets. IBM 3600/4700, IBM 360/370, Burroughs B3900, Honeywell 2000, DEC PDP-10 and PDP-11, Burroughs B6800, Honeywell 2000, Burroughs B3500 and Hughes 4118

Professional Experience:

Confidential

Data Mart / Data Warehouse Consultant

• Provided daily interactive knowledge transfer to build a new Data Mart improving from previous attempts.
• Upgraded LON Data Mart Structure and ETL to support additional tables and data retentions strategy and finalize BI deliverables utilizing: SSAS Multidimensional MDX Tabular DAX SSDT SQL Server Data Tools SQL Server/ Change Data Capture CDC .
• Provided Best Practice/Naming conventions for database objects schemas, tables, views, etc. .

• Provided High Level Planning and Detailed Implementation on overall data integration.
• Provided Detailed Design for Database and ETL process.
• Led 6 member team in Agile SCRUM daily stand-ups for the following:
• The Kick off Sprint 06/19/14 07/03/14 2w focused on establishing the project framework including how project artifacts will be managed and setting up a planning tool to capture the detailed tasks as well as serving as the source for status reporting.
• 1st Sprint 07/07/14 07/25/14 3w focused on LON Data Mart development to modify both the Database and ETL programs and converting the existing historical snapshots into the new DDS Data Warehouse.
• 2nd Sprint 07/28/14 08/08/14 2w focused on LON Data Mart development to establish the Business Intelligence solution and the Analysis Services database will be created.
• 3rd Sprint 08/11/14 08/28/14 3w focused on implementation and completing any documentation related to run procedures, data quality assurance and process recovery, training, and change management process.

Confidential

Technical Business Systems Analyst

• Agile team environment.
• ETL End-to-End data validation using T-SQL
• Focused on creating high-performance T-SQL queries.
• Contracted to analyze mainframe COBOL code and file structures to derive and document the data item translations required to map to and from the new relational SQL database.
• Established data translations for complex SSIS packages.
• Assists and shares efficient T-SQL methods and techniques for data validation.
• Utilizes TFS/VSTS to report and corrections discrepancies for action by the rest of the team.
• Created source definitions from the operational sources and target definitions.
• Collaborated with team members to maintain consistent document standards for writing technical user stories.

Confidential

• Designing implementing a complete Business Process Management in the cloud using SQL Azure, SharePoint 2013 Online CRM Online.
• Prototyping SharePoint 2013 Online, Power Query and Power BI query capabilities.
• Awaiting more funding

Confidential

• Providing both general implementation level support for a small number of clients.
• Assisted in an SBS 2003 to SBS 2011 Essentials migration for a small insurance subrogation client that also involved a small SQL Server database transfer.
• Collaborated in a proposal for a Commercial Art and Graphic Design company that is comprised of an all MAC environment.
• Called upon in a few situations for some small client desktop support and consultation.

Confidential

• Project goal: Scaling up for projected growth in record volume.
• Currently in the initial stages of up-scaling their current ASP.NET/SQL Server 2005 application to the cloud using the Windows AZURE Platform.
• An initial database has been uploaded to the Windows AZURE SQL Database as a prototype in order to kick the tires on what's available with AZURE.
• The database prototype has been further extended to use Microsoft's Synchronization Framework in order to maintain a local copy of what is on the cloud.
• Also a very tiny introduction to using MVC has been embarked upon.
• We are currently taking a one-bite-at-a-time approach to use the knowledge gained from these activities in deciding what is next.

Confidential

• Project goal: Reduce the hardware footprint.
• Moving toward using Microsoft's Office 365 hosted environment.
• Separated the report queries from the OLTP database with SSAS Data Cubes.
• Migrated EXCEL PivotTables to SQL Server 2008 Data Cubes to be viewed in SharePoint 2010.
• Emails have been migrated from Rackspace Exchange to Exchange Online.
• On premise SharePoint 2007 has been migrated to SharePoint 2010 Online using a mix of WebDAV, ROBOCOPY and Outlook VBA routines.
• Addressed various on site server issues and applied Best Practice approaches.

Confidential

• Project goal: Replace sun-setting systems.
• Taking RONCARI's VB6/SQL Server 2000 INTELLIPARK point of sale system into an up-to-date technology platform in order to use the current version of .NET as well as utilizing SQL Server 2008 R2.
• Conducted an assessment of the current development effort to ascertain a percentage of completion COMPLETED vs. TO DO .
• Installed MS Dynamics POS 2009 on a development machine for evaluation and preliminary development purposes.
• Created a data dictionary for the current database to assist in the mapping of old data to new data.
• Designed developed SQL Cross-Tab queries for ultimately porting the query into more effective SSAS Data Cubes.
• Conducted requirements design session meetings to establish the details for architecting SharePoint dashboards utilizing SSAS Data Cubes.
• All of the current VB6 modules have been reviewed documented using automated tools.
• Installed implemented MS Enterprise Library 5.0 as a basis for putting solid development patterns best practices into effect.
• Introduced a new credit card reader system using INGENICO's i6780 credit card terminals.

Confidential

• Providing both general implementation level support for a small number of clients.
• Migrated systems to SBS 2011 for a small insurance subrogation client that included a SQL Server database transfer.
• Collaborated in a proposal for a Commercial Art and Graphic Design company that is comprised of an all MAC environment.

Confidential

Data Management Team

• Contracted to assist and support the Data Management team for all aspects of Data Management/Business Intelligence, Data Warehouse and Data Marts.
• Responsibilities included, but not limited to, maintaining SSIS, SSRS and SSAS updating, scheduling and email job notifications for success, warning and error conditions.
• Asked to replace the current OLTP Database SSRS Membership reports and provide more functionality/performance using more efficient OLAP Membership Data Cubes.
• Designed SSAS artifacts star schema, fact table measures and dimension tables using current reporting queries modified for to improve query speed.
• Membership Data Cube profiling included but not limited to age, geo location, occupation, family size, treatments and membership duration/renewals.
• Charged with pioneering the potential for using SQL Server 2012 Master Data Services and Data Quality Services within the current daily process.
• Asked to assess the current Database structures and ETL processes for improvements where it relates to the newer technologies.
• Developed routines to scour the current database servers for all of the technical metadata information.
• Also developed a method for capturing business metadata information, for each subject matter area, into a repository for a glossary reference by a potential wiki.
• Possess finely tuned techniques and methodologies for upsizing external data into SQL Server to include normalizing the data structures, data scrubbing, ETL and reporting.

Confidential

SharePoint 2010 Developer eBusiness SharePoint 2010

• Agile team environment
• Short term contract development using JScript and CAML queries to read SharePoint Lists on the intranet for redisplay on the extranet.
• Implemented BCS external content types to display the SQL Server information collected for company hardware/software inventory.
• Put into place a WCF .NET Service application to read Team Foundation Server updates for subsequent update to SharePoint list information.
• Installed, configured administered a development environment to facilitate local development.

Confidential

SharePoint 2007 / Dynamics CRM Developer

Dynamics CRM 4 2011 Project

• Member of a two person team designing and developing INSTEC's Retooling Customer Support Systems.
• Technical lead for company-wide CRM 4/2011 Implementation.
• Installed, configured administered CRM On Premise in multiple environments local CRM 4 CRM 2011 development .
• Performed JavaScript custom code C plug-in development fixing bugs and adding new functionality from scratch as per client requirements.
• Implemented C plug-in for CRM 4 to SharePoint 2007 integration.
• Executed, coordinated mapped entity data imports from CSV files using all available tools.
• Carried out parallel testing with the upgraded CRM 4 to 2011 Deployment Manager imported organization.

SharePoint 2007 Project

• Member of three person team designing and developing a replacement for a sun-setting REMEDY request management system.
• Technical lead for company-wide SharePoint 2007 Implementation.
• Installed, configured administered SharePoint in multiple environments local, development, testing production .
• Maintained system synchronizations using the Content Deployment Wizard CDW .
• Established scheduled backups Full Incremental using the STDADM utility.
• Implemented Business Data Catalog BDC importing from disparate systems containing contact, software distribution, work tracking time accounting information.
• Developed logical physical data models for the BDC's common data repository.