Profile EDW data sources, document and present to data scientists and management.Develop data visualizations using Tableau.Create data requirements and complete user acceptance testing in test and production environments. Working to become a subject matter expert in customer complaint, engineering, crash, telematics, survey, and research data to support data scientists in identifying emerging vehicle safety issues.

Gathered Business Requirements and Managed I.T. Projects.Met with end users to identify process issues after ERP system went into production and was liaison between business units and software provider.Met with stakeholders to identify reporting needs and define priorities.Fulfilled data requests using SQL and Crystal Reports.Developed SQL scripts to globally update database records.Resolved data issues by identifying root cause, documenting, communicating process improvements and training end users. Met with vendors and consultants to evaluate capabilities and compare costs for I.T. projects including hardware and software upgrades and consulting.Supervised I.T. contractors and provided status updates to senior management.

Produced data files for automotive U.S. and Canada digital advertising campaigns. Created Business Requirement Document for each data project.Extracted data using Toad (SQL) and SAP CRM.Set up HTML email creative and link tracking in SAP system.Customized HTML creative for marketing events and activated for automated deployment upon receipt of data from the supplier.

Produced analytics reports for automotive digital advertising campaigns. Created reports for email metrics and sales matching using Toad (SQL).Extracted data and developed reports using Cognos and Excel. Converted business requirements into efficient data solutions for General Motors CRMBuilt flowcharts to extract data for campaigns using Unica Campaign.Experience building flowcharts individually as well as working on a team developing a lead re-contact system that included data load dependencies, cleansing and automation.Presented final flowcharts, counts and data files in quality check meetings.Designed and presented use cases for testing solutions before implementation.Validated data prior to campaign execution.Emphasis on incentive, dealer and customer data accuracy.Trained associates one-on-one and in large groups how to use software tools (Unica, Toad, Analytics Workstation and SAS).Created documentation for processes related to extracting data and generating reports.

Gathered business requirements and created custom Crystal Reports.Designed reports for business and education departments.Converted legacy reports from version 9 to XI.Enterprise system implementation, conversion and process development.Liaison between software vendor and Cranbrook to convert legacy systems into integrated Oracle database system.Managed database technical support issues and upgrades.Business Objects Intelligence report server administration.Trained users to run reports and properly change data values such as date formats when using report parameters.Developed and led end user training classes.Explain IT policies for newly hired employees.Trained employees how to write simple queries and run/export reports.

Provided Level I Help Desk Support for network connectivity, hardware and software issues.