OBJECTIVE

• To be successful at continually developing professional and interpersonal skills while leveraging the many years of experience programming ERP, custom OLTP and OLAP systems.
• To have the ability to share design and development knowledge of enterprise business systems in a collaborative software development lifecycle.
• Most importantly to contribute directly to the bottom line by implementing clear and concise architecture using the latest technologies and the Microsoft Development, database and BI stack.

TECHNICAL SKILLS

• IT Project Management
• VB.NET
• ASP.NET
• C#
• X++
• C/SIDE Navision
• MS Dynamics CRM
• MVC
• Object Oriented Design
• SharePoint 2003,2007,2010
• SQL Server DBA (All Versions)
• SQL Server Integration Services
• MS Reporting Services
• Modeling Relational/Dimensional
• Master Data Management
• T - SQL
• Data Integration
• Data Migration
• XML
• MS Analysis Server 2000/2005
• Active Server Pages
• HTML/DHTML/JavaScript/CSS
• Visual Basic/VBScript
• MicroStrategy Architect

PROFESSIONAL EXPERIENCE

Confidential

Data Architect

Responsibilities:

• Develop Android, iOS mobile applications using Xamarin forms
• Develop outdoorindustryjobs.com MVC application for, Apeel.io
• Designed and developed Brooklyn Brewery’s Enterprise Data Warehouse in the cloud using Azure SQL database. Extracting data from MS Dynamics D365 running SSIS ETL in Azure Data Factory.
• Designed and developed Advantage Dental’s Enterprise Data Warehouse using SQL Server 2014, SSIS 2016 and MicroStrategy 10.4.
• Collaborated on design for subject specific STAR schema using best practices and Oracle Data Modeling tools.
• Created source to target maps defining transformations and data flow from source OLTP systems through staging and data warehouse environments.
• Developed SSIS ETL design patterns for Staging and EDW processes, controller packages and instance packages for the Staging and EDW environments.
• Designed surrogate key mapping mechanism to track OLTP artifacts throughout the EDW
• Designed interactive dashboard analysis patterns in MicroStrategy for company KPI, developed instances of those patterns for company KPI. Created custom analysis based on user requirements.
• Created Development, QA and Production environments for SQL Server, SSIS, EDW and MicroStrategy as well as collaborated on a change control processes for promoting changes.
• Analyzed query plans and created indexes to optimize query execution
• Developed MS CRM integration for mapping application; Extracted data from MS CRM Cloud using CData ODBC drivers into custom database and integrated account data with location data. Integrated data was then used to source a GEO JSON file that was to be used for mapping UI.

Confidential

Information Technology Consultant

Responsibilities:

• Analyzed current master data management practices, developed processes and procedures for auditing master records in order to create thorough and comprehensive data collection policies.
• Implemented migration of existing legacy data into new Point of Sale system for 6 retail locations.
• Developed documentation designed to template drive the creation of a new retail locations.
• Managed the daily Information technology needs of 6 retail locations, including 18 POS terminals, integrated peripherals and administration of integrated seed to sale software application.

Confidential

SalesForce to MS CRM conversion Consultant

Responsibilities:

• Analyzed current SalesForce features in comparison with MS CRM 2015, developed plan for data migration and customization of MS CRM application to bring over the desired customizations into the target CRM system as well as develop newly requested customizations.
• Created data maps for data entities from SalesForce to MS CRM data entities.
• Developed and modified existing screens/forms processes and workflows in MS CRM 2015.
• Developed Scribe data transformations to migrate data from SalesForce application into MS CRM 2015

Confidential

Information Technology Consultant

Responsibilities:

• Created sales/production analysis dashboards on the iPad using MicroStrategy for a large global manufacturing company used by members of the executive branch down to the shop floor.
• Responsible for all aspects of MicroStrategy Business Intelligence platform installation/configuration/development for ManageForce clients.
• Architect duties included gathering user requirements, designing data flows and data structures, and developing all modeling schema objects and reporting objects to support user requirements
• Plan and execute upgrade of MicroStrategy software.
• Projects involved sourcing data from Dynamics AX, SAP, JD Edwards and other custom transaction schemas
• Projects utilized the following MicroStrategy features extensively: drill templates, complex dashboard documents, dynamic/multi-level prompting, complex filters and metrics, custom groups, thresholds and alerts
• Projects entailed the sourcing, dimensional modeling, ETL of sales, inventory, financial, purchasing, manufacturing and pricing data from various disparate transaction systems into enterprise data warehouse using SSIS.
• Responsible for analysis and documentation of business processes, developed software development lifecycle list and document templates for SharePoint 2010.
• Created custom SharePoint 2010 applications using event receivers, web parts, timer jobs, power shell scripting, content types, external content types, InfoPath consuming WCF, REST services.
• Ported Classic ASP applications to ASP.Net MVC3 C# with Entity Framework using LINK, JQuery and CSS.
• Responsible for providing Microsoft SQL Server database administration services to ManageForce clients, including troubleshooting and performance tuning, scheduled and unscheduled maintenance.

Confidential

Navision ERP Software Manager

Responsibilities:

• Responsible for management of Microsoft Dynamics Navision ERP system, including documentation, customization, maintenance and upgrades.
• Performed upgrade of highly customized instance of Navision 5.0 to Navision 2009, including integration of several add-ons.
• Implemented SharePoint 2007, created documentation templates and document libraries for creating and managing enterprise business process documentation.
• Created change management process in SharePoint to document and track ERP issues from detection through to completion and implementation in the live ERP system.
• Coordinated and managed MBS vendor relationship to support enhancements and upgrades to Dynamics NAV ERP system.

Confidential

Enterprise Applications Architect

Responsibilities:

• Technical lead for Microsoft.Net based windows, web applications and distributed application framework components such as web services and IIS hosted components.
• Database administration duties include, design hardware configuration for optimum database I/O. Query profiling and tuning for optimal query execution and application performance. Creation of maintenance and disaster recovery planning for 50 SQL 2000 and 2005 database servers.
• Lead migration from SharePoint 2003 to MOSS 2007 for corporate Intranet portal. Created SOX compliant approval process workflow to automate development/documentation change control process using InfoPath and MOSS 2007.
• Implemented OO distributed application standards for enterprise business applications using CSLA object framework and Visual Studio.NET 2003 Enterprise Architect.
• Designed and developed custom CRM using ASP.NET, VB.NET and CSLA for 250 + user call center.
• Designed and developed ASP.Net applications and reporting infrastructure used to manage compliance and report data for the National Highway Traffic Safety Administration’s Transportation Recall Enhancement, Accountability, and Documentation Act.
• Designed and developed a mapping and routing system for finding Monaco Coach dealers and service centers using MapPoint.Net web service.
• Designed and developed an ad-hoc query designer tool for graphically creating reports using OO methodology with XML object persistence in enterprise storage systems to share reports with other users, as well as provide security mechanisms to prevent unauthorized access to sensitive data.
• Responsible for the creation of various interfaces between business partners for exchanging financial, customer and product information using standard EDI, web services, FILE, SQL, HTTP and SOAP interfaces..
• Designed and architected EDW using Star/Snowflake schema design principles for subject specific data marts including ETL processes using T-SQL, DTS and SSIS, developed incremental synchronization processes from Oracle to SQL Server.
• Lead migration of enterprise reporting infrastructure from Cognos, MS Reporting Services to MicroStrategy acted as project designer/architect role.
• Create and maintain enterprise reports using MS Reporting Services, designed and developed MS OLAP and Cognos analysis cubes.
• Planned and executed the migration of enterprise Crystal Reports to MS Reporting Services.
• Assisted in the definition and implementation of standard development processes, procedures as well as documented and implemented development guidelines and coding standards.
• Assisted in the implementation of PeopleSoft/JD Edwards, created enterprise application interfaces to enable interoperability between JDE and legacy ERP systems, created JDE reports, enhanced stock JDE interactive applications.