Michael Chartier Email & Phone Number

Portland, Oregon, US

• Developed new Data Validation process for payment processing for identifying data issuesprior to final payment processing. This process reduces data issues and lost time that typically impact payment processing when.
• Developed SSIS process for data imports in Government secured environments.
• Daily work on complex data issues for client data including Stored procedure updates, mass updates for production data and other data requirements.

Portland, Oregon, US

Developed new Job Control Process for handling all new file imports. Includes new Staging tables, Job Control tables and a new generic SSIS process that reduces time to deploy new import files from days to hours. Will be used to replace old DTS import processing and older SSIS packages so that all import processing is standardized

Vancouver, WA, US

• Created an integrated business solution in SQL server using raw data from Qwest to analyze and determine Ethernet solutions for Integra enterprise access services. This process replicated a manual system of Excel.
• Created a business solution in SQL server that replicates a process for FCC reporting based on Excel and Access databases. Identified data sources requirements including Census Block data and GIS mapping needs..

Portland, Oregon, US

• Supports the Goldmine Customer Relationship Management (CRM) System including CRM functionality, training and governance of data quality and system performance.
• Performs analysis and data manipulation of source data to support planning, evaluation, programs, finance, marketing and administration.
• Develop, test and publish Crystal reports that support business needs. Actively involved in migration of Crystal Reports to SAP Business Objects reporting model.
• Provided ETO recognized savings data in support of Utility usage data for Utility customer empowerment project (OPOWER).
• Actively involved in Geographic Information System (GIS) technology tosupport Legislature needs for reporting and mapping using georeferenced data points for more accurate association of site locations to Legislative.
• Develops data models, processes and data warehouses for supporting specific business needs including Utility Usage data and ETO Trade Ally Programs.

New York, New York, US

• Created a new data model and a custom software application for automating data import processing, data scrubbing and the validation of original client data. Included tracking of initial data from client to final.
• Developed and supported software application for importing, updating, reconciling and reporting for all payment processing. Bank file processing included data transformation, validation and updating in SQL server.
• Extracted, transformed and loaded original client data for payment processing of Federal Trade Commission consumer protection settlements requiring a separate and secure environment. Processed, updated and reconciled.
• Worked collaboratively with various departments to identify and meet their data analysis needs including data audits, reconciliation of claims and data analysis of security data using SQL and TSQL queries. Created.
• Imported, prepared and transformed data in support of large high profile Class Action settlements including multi-phased, multi-year cases.
• Used Visio for data modeling and database reverse engineering to create new database schemas for Class Action settlement case requiring multi-language import and processing of claims. Required ability to toggle.

Created and supported software application for managing the logistics and shipping of large computer systems for data warehousing.Created and supported software application for internal auditing process for equipment certification.Created and supported software application for Engineering software development milestones and processes.Supported Logistics.