Benjamin Stringer, Mba, Mcsa Email & Phone Number

Nashville, Tennessee, United States

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… Show more 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

Chicago

Develop and manage enterprise data and business intelligence services.

Chicago, Il

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.

Chicago, Il

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

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… Show more 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

Greater Nashville Area, Tn

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… Show more 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

Greater Nashville Area, Tn

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… Show more 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

Osaka, Japan

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.

Yamagata, Japan

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.

Master Of Business Administration (Mba), Logistics, Materials, And Supply Chain Management

Bachelor Of Arts (B.A.), History

Dean's List, 3 semesters

Education record