* Build and update backend data services using Microsoft SQL Server, SSIS and SQL* Develop and update reports using SQL Server Reporting Services

Design and develop data transformations and models to support Bose Financial data warehouse.• Build financial data models in Snowflake using dbt to support financial reporting.• Migrate the data warehouse from SQL Server to Snowflake while transitioning the SSIS ETL code to the dbt ELT process.• Work on team to design, test and implement Snowflake and dbt working environments and processes.• Provide support in business enablement by leveraging the Microsoft BI stack (SQL, SSIS, SSAS, SSRS, PowerBI) to drive data and reporting efficiencies globally.

Worked on data integration projects that populated BCBS data warehouses. • Developed three Microsoft data warehouse applications using SSIS, SSMS, Visual Studio, Netezza, and Excel (Hospital Data Mart, Retentions Data Mart, and Medical Expense Reporting Data Mart). • Provided ongoing support and enhancements for all three data warehouses. • Assisted in the upgrade of SQL data warehouses to SSMS 2016, VS 2017, and new Windows Servers. • Developed and supported ETL projects utilizing Oracle Data Integrator and Netezza. • Assisted in the upgrade of ODI 11g code to ODI 12.

Worked on the Data Warehouse/Business Intelligence team to provide ETL solutions to Gilbane’s Enterprise Data Warehouse.• Daily management and development of processes to bring data into Gilbane’s EDW from various systems throughout the company using Microsoft SQL Server Integration Services (SSIS).• Redesigned the nightly data load process to improve performance so data was ready by 7AM.• Performed additional tasks to improve the system such as automated documentation, change tracking in the EDW, and the creation of an EDW metadata database to assist in design and development.

Worked on the Customer Engineering team for the Workforce Analytics product. Provided analysis and solutions to customer issues that were delivered in service packs and patches. • Designed and developed a BI solution to monitor and report on ETL performance of customers that allowed Kronos to be proactive to performance issues.• Gained experience developing solutions with MicroStrategy, Microsoft SSRS, SQL Server, Visual Studio, and Accurev.

Provided solutions to users based on project requirements using Microsoft BI tools, Visual Basic 6.0, VB.NET on the client side, and Universe Database on the server side. Integrated various other technologies such as Hyperion, SQL Server, and Microsoft Office products.• Designed and built a Business Intelligence solution based on Microsoft Technologies such as SQL Server 2008R2, SSIS, SSRS, SSAS, Power BI and Sharepoint. Converted old system of reports in Hyperion to the new Microsoft BI solution. • Designed the relational schema for the new ‘Office Appraisal’ application and implemented it in SQL Server 2008. Designed and configured the ETL processes to load the data from the old ‘Office Appraisal’ system using SQL Server Integration Services. • Rewrote the internal tracking system that keeps track of all signed out programming files and moves the project through the life cycle from development to test and production.

Provided customer support for the Tower IDM Suite and various workflow products. Performed installs, software integration, upgrades, custom programming, and provided informal training. • Installed and configured Tower’s first and largest volume Document Processing system using the new Enterprise Capture Solution which was used for references and demos that led to future customers. • Used skills in UNIX, Windows, programming, and databases to install, configure and upgrade the IDM Suite on several profitable accounts. Required to quickly adapt to changing environments with flexibility and agility while working with various organizations.• Participated with the Pre-Sales team through the building of demo systems, attending Pre-Sales conference calls and performing acceptance testing with customers to assist in closing many large deals.