Susan Davis

Experience

• 

  Guardian Automotive

  Sept 1997 - Mar 2004

  Business Analyst

  Designed, developed and implemented a database system that consolidated business data from multiple departments enabling easier access to information for analysis utilizing the development life cycle.*Gathered key data associated with customers, programs, parts, part process, manufacturing locations, piece prices, volumes from sales, engineering, and operations departments to create the initial database and user interface design.*Designed a tool that captured part engineering change information such as milestone dates, design and tooling changes and associated costs, piece price and cost changes*Developed a querying tool that enabled the users to do ad hoc reporting for sales and volume forecasting using the data captured in the other modules of the program.*Defined the process flow and designed the database and interface for a quote cost analysis tool.*Created reports as defined by the business needs of the company utilizing SQL and Crystal Reports. Show less

• 

  Ensemble Chimes Global

  Sept 2004 - Jan 2008

  Administered, maintained, and analyzed corporate data primarily utilizing SQL to extract data from Oracle databases. Position required a full understanding of the data model of the customer databases, customer-specific data configurations, as well as the front-end interface, in order to ensure data integrity.*Organized/populated new customer data into production and test databases.*Wrote code for migration of data from one database into a new database for upgrades.*Participated in deployment of upgrades to production databases.*Wrote code for administration and analysis of production data.*Provided impromptu data extracts to management and customers.*Documented results of analysis and changes.*Identified areas for process improvement and application deficiencies.*Wrote code for reports and other various report changes.*Assisted quality group by testing and troubleshooting new software developments. *Coordinated activities of DA group in the absence of manager. Show less

  • Data Analyst, Lead

    Sept 2004 - Jan 2008

  • Data Analyst, Lead

    Sept 2004 - Jan 2008
• 

  Adecco

  Mar 2008 - Jan 2011

  Technical and business consultant for new and existing client integration requests. Advised clients, internal business and technical teams on integration concepts and solutions. Assisted clients in implementing third party integrations and data exchange processes between Vendor Management Software (VMS) tools, client and corporate systems. Integration tools included data feeds, timesheet imports, single sign-on (SSO), and spend management products.*Defined, documented client-specific integration and exception processes for integration feeds and data exchange routines. Trained support staff on these processes. Integration feed data types included client users, associates, cost centers, work sites, timesheets, and invoices.*Developed Access databases to assist with analysis, data formatting and processing of integration processes.*Analyzed complex data integration issues between the VMS and spend management tools and worked with the client, VMS partner, and internal teams to implement issue resolutions.*Developed resolution process for rejected invoices from client’s spend management tool and supported ongoing analysis of rejected invoices.*Streamlined the exception handling processes across clients for existing integration projects; developed Access databases to simplify the error analysis.*Analyzed, resolved client data integration issues as part of the issue resolution processes for a multiple of feeds and data exchange processes across clients.*Designed a data exchange process to update client’s cost centers in the vendor management software with a monthly cost center validation file.*Served on large data conversion project initiated by the client that changed how the data was transmitted between the vendor management system and the client’s spend management tools. Analyzed the data from both systems in order to prepare for the conversion. Monitored and resolved data issues that occurred after the conversion. Show less Provided second tier customer support to client, vendors, and associate users by investigating, documenting and communicating issue resolutions and product questions from both internal and external customers for the various supported VMS solutions. Also developed external solutions to support the integrity of client data within the vendor management software.*Processed and resolved client data issues related to the vendor management software.*Streamlined a process utilizing Microsoft Access that manages the error resolution of data between a client's internal resource system and the vendor management software.*Developed a standard process to maintain data cohesion between the client's business structure and the vendor management software. Customized this process to meet the individual needs of multiple clients.*Wrote VB code to enhance and fix known issues to the file transfer protocol script used to exchange and manipulate files from one server to another.*Wrote SQL code to fix known issues and add new queries for data reporting on legacy software.*Processed weekly and monthly SSQ reports for clients on legacy software.*Assisted team members in organizing and creating documentation of standard resolutions for client issues within the vendor management software. This included documentation to utilize the VMS software’s integration functionality.*Managed multiple projects to implement complex configuration changes or additions for several clients within the vendor management software. Show less

  • Integration Analyst, Solutions Support

    Aug 2009 - Jan 2011

  • Analyst, Solutions Support Data

    Mar 2008 - Aug 2009
• 

  SAP Fieldglass

  Dec 2010 - Nov 2023

  • Senior Production Engineer

    Jul 2014 - Nov 2023

  • Production Engineer

    Dec 2010 - Jul 2014