Benjamin Stringer, MBA, MCSA

Experience

• 

  Japan Exchange and Teaching Program(me) (JET)

  Aug 1999 - Jul 2001

  Assitant Language Teacher (ALT)

  Assisted with middle school English instruction for 270 students. Led classes at 3 lower schools and 3 kindergartens. Helped at the town hall with administrative tasks when needed.- Interpreted correspondences from Japanese to English for Mikawa-McMinnville Sister Cities Project.

• 

  Bayer Yakuhin, LTD.

  Jan 2005 - Jun 2005

  New Product Marketing Intern

  Performed market research of the Japanese market for a major multinational pharmaceutical company. Assimilated and wrote the market launch plan for an end-stage renal disease medication.

• 

  Nissan North America

  Jul 2006 - Aug 2009

  Created, maintained, and distributed inventory and sales reports as part of the Mix Management team. Created ad hoc reports as needed. Coordinated with the Production Ordering group in order to manage and maintain data on the mainframe.- Created and maintained VBA-based reports that interfaced with several database systems including a legacy mainframe system and SQL databases.- Created ad hoc report identifying problem accessory items for committee presentation.- Analyzed proposed sales rate figures against historical trends on upcoming models and highlighting items with budgetary risk. Show less Serve as the liaison between two national sales companies that form Nissan North America. Focus on the Mexican sales and production divisions. Coordinate production orders between the U.S. and Mexican entities. Evaluate forecasts for possible risk.- Investigated a discrepancy between the Mexican reported production for US markets and the US reported figures. Identified a 1.5K mismatch. Set up accounting process to reconcile these figures in the future.- Created several flexible VBA-based tools to evaluate sales and production plans and automate routine administrative procedures. Show less

  • Vehicle Operations Specialist

    Oct 2007 - Aug 2009

  • Regional Production Planning Specialist

    Jul 2006 - Sept 2007
• 

  Emdeon

  Aug 2008 - Jan 2011

  Strategic Reporting Analyst II

  Created and maintained reports tracking various human resources metrics on full time employees and contractors. Worked both inside and outside the department to collect data and deliver reports.- Built Access database with graphical user interface that ran flexible reports on the current company profile. This permits generalist and recruiters to run their own reporting on demand.- Worked across departments to collect data, build, and maintain reporting on company-wide contractor usage and estimated spend by month. Due to the balkanized nature of the organization attempts over 7 years to assemble this overview failed.- Built and maintain report summarizing current requisitions and contractor totals.- Coded several Oracle packages to facilitate reporting.- Self-taught Oracle HR tables and structures to have better information access and more flexible reporting.- Created Access database to run data validation checks against Oracle before data loads. Included VBA coding to run custom queries and pull results from Oracle into Access tables. Show less

• 

  SP Plus Corporation (SP+)

  Jan 2011 - Jun 2017

  Create and maintain databases and ETL processes in SQL Server 2005 and 2008. Learn and document legacy systems. Troubleshoot production issues as they arise working with the support team. Support UltiPro suite of applications including BackOffice, .NET Portal, SQL Server database, and custom peripheral applications. Provide close support for payroll and benefits during weekly processing process. Create custom processes to import time and attendance data based on business needs.-Migrated entire HR system to a new server platform-Created and coded data export process for company-wide data integration effort

  • Database Developer

    Nov 2014 - Jun 2017

  • Technical Support Analyst

    Jan 2011 - Nov 2014
• 

  National Restaurant Association

  Jun 2017 - Sept 2018

  Senior Database Developer

  Supported existing systems in SQL Server 2008 R2 and 2012. Migrated environments to 2017 platform, including SSRS reports, SSAS cubes, and SSIS packages. Created ad hoc reports from complex and interrelated systems for business users based on direct conversations and BA requirements. Created and managed outbound files to clients

• 

  Singenuity

  Oct 2018 - now

  Senior Database Developer

  Responsible for SQL Server Azure production and development instances. Recommend design changes for new features and bug fixes. Create and maintain a series of complex reports in a constantly changing environment. Performance tune queries and procedures. Create and maintain development environments. Create C# console apps and Powershell Runbooks to facilitate data imports and system maintenance. Work on the API code base as needed. Balance competing needs of development and maintenance on resources.-Created and maintained Powershell Runbooks solution to copy and sanitize production database down to development environments-Created configurable webjob to automatically log and fix broken messages for critical workflow, reducing manual intervention and speeding up fixes for common problems from hours to minutes.-Created and maintain Github repository and branches to keep track of database changes, merging production hotfixes back down into development environments-Oversee work of junior database developers, instructing in T-SQL and the particulars of the database structure Show less