Ian Weiting

• Design and optimize SSIS-based ETL pipelines supporting enterprise justice data systems • Develop complex T-SQL stored procedures and transformation logic for multi-layered data processing • Cleanse, standardize, and transform legacy data for integration into modern reporting platforms • Diagnose and resolve issues in legacy codebases, improving data reliability and maintainability • Refactor and standardize ETL processes to reduce technical debt and improve consistency across systems • Implement data validation and defaulting strategies to ensure data quality across large datasets • Collaborate across teams using TFS and Visual Studio to manage versioning and coordinated deployments Key Contributions • Established coding methodology for the Tickets data domain within the broader justice dataset • Identified and corrected legacy data and logic issues during system modernization efforts • Improved stability and handoff readiness of SSIS projects by resolving errors, warnings, and inconsistent implementations

• Designed technical solutions and supporting documentation for new feature development across enterprise systems • Interpreted and applied ISO standards to ensure compliance within system design and implementation • Developed hybrid solutions to support interoperability between legacy and modern infrastructures • Enabled continued operation of legacy systems while integrating with newer technologies

• Developed and optimized T-SQL stored procedure ETL processes, including QA and validation workflows • Designed and extended presentation datasets sourced from Oracle systems for downstream reporting • Built and refined relational data models to support data warehouse integration • Analyzed and redesigned defaulting logic to improve data consistency and reliability • Managed code versioning and deployment using TFS across database objects and related architecture Key Contributions • Identified and resolved critical data issues within core source systems impacting data warehouse population

Took time away from full-time work to provide care for terminally ill family members.

• Design and build custom wood-based projects for events and private clients • Manage end-to-end process including concept design, material selection, construction, and delivery

• Managed data volumes and system performance for SAP financial systems within an enterprise environment • Designed and supported data integration processes between SAP and downstream systems using Informatica and file-based transfers (CSV/FTP) • Developed solutions to address data growth, performance bottlenecks, and system constraints across platforms • Collaborated with architects, DBAs, infrastructure teams, and vendors to implement scalable and efficient data management practices • Partnered with internal business units and external vendors (SAP, IBM, Informatica, Documentum) to deliver optimized technical solutions Key Contributions • Implemented enterprise data management processes including archiving, data retention, and regulatory controls across multiple platforms • Established standards for data handling, operational processes, and system performance to support long term scalability and compliance

• Led and developed a team of 4–6 analysts and developers supporting enterprise data processing and BI systems • Directed design, enhancement, and support of ETL processes within the data warehouse using Informatica and SQL • Developed solutions for system issues, performance bottlenecks, and ongoing data processing improvements • Collaborated with architects, DBAs, developers, and infrastructure teams to implement best practices and scalable solutions • Partnered with internal business units and vendors (Informatica, Cognos, IBM, DataConnect) to deliver efficient and reliable data solutions Key Contributions • Expanded and scaled the team from 2 to 6 members to support growing enterprise data and application demands • Led the rewrite of over 40% of legacy ETL code, significantly improving data quality and processing performance • Established and enforced development, operational, and support standards across ETL and BI systems

• Designed and delivered technical solutions for enterprise systems including Interactive Voice Recognition (IVR) and investment management platforms • Led deployment of custom applications and infrastructure components across multiple environments • Identified and resolved network and data bottlenecks impacting third-party system integrations • Consolidated and streamlined data processes using Informatica ETL across SQL Server, Access, and DB2 environments • Reduced manual processing through data integration and automation initiatives Key Contributions • Delivered all solutions ahead of schedule with no post-implementation rework required

• Designed and administered SQL Server databases across OLTP and OLAP environments • Built and maintained enterprise data warehouse solutions using DTS-based ETL processes • Automated data extraction, transformation, and loading using T-SQL, BCP, and DTS • Developed custom applications and reporting solutions using VB.NET, Access, SAS, and Crystal Reports • Designed and managed reporting layers, including OLAP cubes and ad-hoc reporting capabilities • Implemented data security and access controls within reporting and intranet environments • Coordinated project design, documentation, and delivery across data and reporting initiatives Key Contributions • Designed and implemented a multi-stage OLTP/OLAP data warehouse with full reporting and ad-hoc analysis capabilities

While unemployed for a short stretch during Covid I went back to NAIT to refresh skills.