James Dionne

Evaluated emerging technologies in the field of
data management, recommending strategic
investments for long-term benefits.

Designed scalable and maintainable database
systems, anticipating future needs and growth
potential.

Collaborated with cross-functional teams to identify
business requirements and translate them into
technical specifications.

Conducted thorough assessments of current
database environments, identifying areas for
improvement and recommending strategic
enhancements.

Collaborated with Databricks and Microsoft to bring
world class solutions to complex data challenges.

• Designed and implemented Informatica ETL architecture to load and update the SSOT
• Created infrastructure to consolidate data and present that data to customer facing tools including EDI, customer websites, and reporting through MicroStrategy
• Constructed SSOT components including an ODS and EDWH
• Created detailed business processes to understand how data was organized and how data needed to be organized at the enterprise level
• Involved in selection process of enterprise reporting tool and enterprise ETL tool
• Developed requirements and listed them in importance based on required and nice to have which allowed the ability to develop a scoring method and eventually singled out the best choice for the company
• Replicated common data model and ETL architecture so that both environments (ODS and EDWH) acted in harmony with each other
• Converted Informatica PowerCenter architecture to Informatica IICS
• Developed initial Microstrategy implementation strategy
• Managed team of 6 Informatica on-shore and off-shore resources
• Involved in selection process for enterprise scheduling tool
• Implemented Control M to manage scheduling of ODS and EDWH Informatica workflows
• Adapted Control M to automate IICS task flows
• Discovered and documented enterprise-level data requirements and found best available technical solution to implement them
• Maintained system health by creating in-depth monitoring system
• Created SysAid workflow process for handling data quality and request tickets.

• SUPPORTING MAERSK)
• Designed and implemented the North American data warehouse
• Participated in the selection process of the ETL platform
• Participated in the selection process of the reporting platform
• Designed and implemented the ETL architecture to maintain the EDWH using Accentual Data Stage
• Developed reporting standards and reusable architecture for Hyperion Analyzer
• Deployed reporting solutions using Hyperion Analyzer
• Migrated original SQL Server EDWH to DB2
• Created and implemented best practices for common DB2 administrative tasks

• Developed click-stream data source into marketing strategy based on customer interest
• Automated existing processes using SSIS packages
• Developed SSIS Packages for new requirements
• Developed ETL standards and architecture
• SQL Server DBA
• Developed reports in SSRS, Tableau, and Qlikview
• Troubleshot complex data quality issues and found appropriate resolution
• Participated in evaluating Qlikview and Tableau reporting solutions.

• Automated manual reports using SSIS and SSRS
• Supported SQL Server and SSRS environments
• Developed requirements for new SSRS reports
• Developed SSIS packages based on output from requirement gathering sessions
• Participated in creating SSIS standards and architecture.

• Migrated a legacy intermodal ERP system and its user interfaces into a new SQL Server back end
• Developed a business process to document the migration of key ERP components
• Implemented SQL Server best practices for common administrative tasks