James Bourque Email & Phone Number

United States

United States

• Migrating client ERP (SAP, Oracle, EPIC, JDE, …) payment data, agent jobs and related processes/SSIS packages from SQL 2008 to SQL 2016. During migration made product improvements in data processing time and space requirements.• Built and maintained SQL 2016 scripts, SSIS packages, indexes, and complex queries for data analysis and extraction on different projects and related tasks.• Provided support for on-boarding new clients including import process development, data cleansing and troubleshooting data issues.• Researched applying columnstore and in-memory tables to data load/preparation processes to optimize data loads.• Installed and configured SQL server for staging and production servers.• Provided general office operations troubleshooting support where needed.

Holliston, Massachusetts

• Designed and maintained, logical and physical models of centralized data warehouse and associated data marts along with supportive staging databases. • Developed full and incremental ETL data loads. All of which resulted in more effective and timely functional reporting and summary level data analysis to support senior management and director strategic decision making. • Working with department managers and corporate directors created reports using various presentation/visualization tools selected based on need and appropriate fit. • Administered and maintained Microsoft Dynamics GP corporate wide environment from server setup of Windows Server in Hyper-V environment, SQL Server install, upgrades and migration, GP client installs and troubleshooting ensuring 24x7 uptime resulting in more effective/optimal use across multiple offices and departments.• Provided customized Microsoft Dynamics GP solutions to support corporate-wide short and long-term objectives. Solutions included front-end customizations using MSVS Dexterity (C#) add-ins supported by back-end SQL database changes. • Administered entire SQL server environment including but not limited to backups, regularly scheduled maintenance, and performance monitoring of all databases ranging from line of business applications (custom built or commercial) and data warehouse.• Collaborated with department managers and directors to design, develop and maintain several custom line-of-business applications to support daily operations for manufacturing, sales, finance, purchasing and payroll.• Worked with executives to establish IT budgets, strategic planning, and create SOP documents.• Trained and supervised IT personnel on troubleshooting network, endpoint, and application level issues resulting in prompt resolutions and proactive pattern detection of potentially greater issues.

Greater Boston Area

Burlington, Ma

Greater Boston Area