Engaged with stakeholders to collect and record their reporting needs, performed data analysis, developed scripts to expand and refine the Foundation’s multi-dimensional data warehouse, and upheld the integrity and operation of the data warehouse and its associated reporting systems.Starting in 2019, collaborated with external vendors to transition data from the old system to Salesforce CRM, following the Agile methodology. Constructed a new data warehouse to preserve the integrity and functionality of the Salesforce CRM platform. Collaborated with business and product owners to gather requirements, offer technical guidance, and manage expectations to ensure the solution meet all their needs Conducted data analysis, loaded and extracted data, and performed other tasks related to managing information in the fundraising database and associated systems Created and developed tables, stored procedures, views, functions, and complex queries using the data warehouse and reporting infrastructure to improve the automation of the reporting environment Supplied reports, guidelines, and performance monitoring for crucial aspects of data integrity in the fundraising systems. Kept track of monthly metrics that assisted in defining and monitoring data integrity over time Gained experience working with a third-party vendor as part of the agile software development life cycle during system migration. Managed and maintained data process deployment and release pipelines using CI/CD tools Actively utilized the data warehouse environment to enable efficient delivery of data exports and imports for vendors, other departments within VCH, and the end-user community Offered expertise on data integration to Foundation employees, and provided coaching and advice to end users and team members.

Reported to IT Development Manager and worked closely with cross functional departments, held direct accountability for the design, development, testing, and documenting of a variety of software systems and applications to ensure the daily successful operation of all kinds of financial activities. Played a key role in the successful creation and upkeep of various software systems, which included systems for banking and insurance, intranet pages for administrative tasks at the branch and head office level, and tools for wealth management statements and financial planning Participated in the design and development of internal web pages using Microsoft Visual Studio 2008, ASP.NET, and web services. Some examples of these web pages include forms for branch daily tasks and IT purchasing and ordering system, and deposit broker application Created a variety of user reports such as claim and underwriting reports for Coast Insurance, and branch activity and accounting reports for financial management using Microsoft SQL Business Intelligence Development Studio. Also automated the report generation process using Microsoft SSIS packages Conducted quality assurance tests to ensure that new applications adhere to software development standards and business requirements Provided technical support during system implementation, which included on-site help, remote user support, and support outside of regular working hours. Consistently received positive feedback.