BI supervisor in the Northeast Region within RSM. Providing business intelligence, data integration and migration solutions within the public sector, retail and manufacturing industries.

BI and Technical Consultant in the Cloud division for a gold-certified Microsoft Dynamics solutions provider.Key Responsibilities• Work through and support Solver implementations, both internal to Sopris and for clients. o Gather reporting requirements from clients. o Create SSIS packages to pull from various data sources, both on-prem and cloud. o Set up and configure Solver data warehouse environments.• Maintain Microsoft Dynamics AX/365 F&O… Show more BI and Technical Consultant in the Cloud division for a gold-certified Microsoft Dynamics solutions provider.Key Responsibilities• Work through and support Solver implementations, both internal to Sopris and for clients. o Gather reporting requirements from clients. o Create SSIS packages to pull from various data sources, both on-prem and cloud. o Set up and configure Solver data warehouse environments.• Maintain Microsoft Dynamics AX/365 F&O implementations. o Promote custom code, platform updates and hotfixes from development through environment chain (build > UAT > production). o Perform refreshes of development/test environments from production. o Create custom data entities in D365F&O for importing and exporting data.• Support SQL Server database environments o Optimize stored procedure/query performance and troubleshoot slowness and other issues.Key Accomplishments• Successfully configured system integrations between Power BI and D365F&O.• Implemented Solver data warehouse configurations/installations for the small, midsize and large clients. o Data warehouse implementations involved dimension and fact data for financial and operational reporting (General Ledger, AP, AR, Fixed Assets, Projects).• Created solution to integrate Solver on-premise data warehouse with D365 F&O which utilizes data entities and Azure SQL.• Configured automated regression testing and test plans for clients to support One Version service updates for D365 F&O.• Developed Power BI reports end-to-end (from data modeling to graphical visualizations), both internal to Sopris and also for external clients. Show less

Key Responsibilities• Develop and maintain various database systems and applications in development, test and production silo environments.• Create and deploy SSRS reports on numerous data sources within the organization.• Maintain and update SSIS packages that run on a nightly basis.• Write T-SQL queries and stored procedures for various CRUD and ETL operations.Key Accomplishments• Implemented BI360 data warehouse which allows for a single source of reporting on… Show more Key Responsibilities• Develop and maintain various database systems and applications in development, test and production silo environments.• Create and deploy SSRS reports on numerous data sources within the organization.• Maintain and update SSIS packages that run on a nightly basis.• Write T-SQL queries and stored procedures for various CRUD and ETL operations.Key Accomplishments• Implemented BI360 data warehouse which allows for a single source of reporting on multi-company and multi-currency financial data within Minitab.• Supported upgrade of Microsoft Dynamics Great Plains 2010 to 2013 R2. Modified custom codeto ensure compatibility for the upgrade of SQL Server 2008 R2 to SQL Server 2014.• Coordinated the migration of subscription data for an update to Quality Trainer, a subscription-based web product. Successfully executed a mass update of hundreds of thousands of rows with virtually no impact to the user community.• Created and deployed SSRS reports for internal users that included product trial, launch and activation data.• Wrote front-end web application with a SQL Server database back-end, which stored data about all of Minitab’s products and releases. Show less