TrentonCreate account
OR
Trenton J. Gibbs317-728-9063 | gibbst48@gmail.com | 14926 Riverdale Dr E, Apt#10, Carmel, IN 46033OBJECTIVETo obtain a full-time or Contract to hire position that challenges me to utilize my database management, System Administration, and Information Technology skills for the growth of an organization as well as further my IT experience. EDUCATION May 2018Purdue University, West Lafayette, INBachelor of Science in Computer Information & Technology Minor in Organizational Leadership & SupervisionLicenses/Certificates August 2019• Interim Secret Security Clearance from the Department of DefenseSKILLSET SUMMARY• System Administration• Imaging• Microsoft Active Directory• C#• SQL• Database Backup & Recovery• Server Cloning/Creation• ERP Administration• IT Project ManagementApplications• Microsoft Visual Studio• SQL Server Reporting Services • NetBeans• VMware• SQL Server• Oracle• FoxPro• Microsoft Access• Active DirectoryNOTABLE PROJECTSIntern Database Design Project • Created a database with a front and back end in Microsoft Access that maintains all information and documents for employee training. The database allows the front office to view and edit information on when a new employee has been trained, training description, trainer, and various department specific documents training. Various reports can be generated based on criteria.Object Oriented Programming Project• A program written in C# in Visual Studio. The program allowed students to enter information about their classes into a windows form that wrote the information collected in the input boxes to a file that is imported into Google Calendar and automatically builds a schedule for the student.WORK EXPERIENCECSCI Consulting, Indianapolis, IN August 2019 – Present Analyst• Obtained Secret Security Clearance• Use ACL (Audit Command Language) Analytics software to develop coding scripts for reconciliation processes to ensure reconciliations exist in accordance with auditing standards.• Perform reconciliation validation and gap analysis assessment for General Ledger Systems and provide recommendations to the client (D.F.A.S).• Analyze unmatched transactions to determine trends and identify root cause buckets and anomalies within data sets.• Provide auditable workbooks and deliverables to the client to assist with variance research and analysis.Freedman Seating Company, Chicago, IL May 2018 – August 2019 IT Developer• Help Desk tickets which range from serving as an ERP System Admin, System Admin, or Database Admin• Develop custom database reports that support Accounting, Sales, HR, Shipping, and Production.• Create or suggest new emerging technologies/features that could improve/automate processes.• Create technical documentation and diagrams for projects and end users• Software Installations & Local Group Policy creations• Authentication and authorization, directory services, system management and system security• Remediated IR IncidentPiezo Technologies, Indianapolis, IN May 2017 – August 2017 Quality Assurance Intern• Employee and Training data entry for the HR department• Created and updated databases for the company (example above in “Notable Projectsâ€)• Performed administrative tasks such as converting paper files to computer files and recording and analyzing production procedures for new documentationsExamples of Use of skills & applicationsFreedman Seating Company, IT Developer May 2018 – August 2019• Use SQL to troubleshoot user input mistakes in company’s ERP & CRM System, Made2Manage by Aptean, via Microsoft SQL Server Management Studio or Oracle SQL Developer.o Transact-SQL,PL/SQL,SQL• Use SQL to create and update custom reports or to alter and recreate unknown code for existing reports in Made2Mange to either save company money on additional licenses by moving reports offline or avoid extra costs for report alterations. The reports support all departments within the company and are created based on user wants/feedback using SQL Server Reporting Services.• Use SQL in Card Studio, to create and maintain Employee ID Database. The database houses all employees’ full names, pictures, employee ID numbers, department numbers, hire date, status (active/terminated), and is used to create or disable ID’s.• Use SQL Server Studio to create database documentation, including data standards, procedures and definitions for the data dictionary of the company’s’ databases as well as to manage the security and disaster recovery aspects of the databases.• Technical Writing – Used to create SOW’s, white pages for projects, and user manuals for end users to use for reports UI’s that I created.• IR Incident Remediation – Within a team; Identified affected PC’s and servers, took them offline scanned and reimaged them before putting them back on to our domain. Also personally lead and taught a group of Technical and non-technical personal on remediation procedures in order to help speed up the process.Piezo Technologies, Quality Assurance Intern May 2017 – August 2017• Used SQL in Microsoft Access to create and update databases for Piezo (Intern Database Design Project example above in “Notable Projectsâ€)• Used SQL to generate reports on employee training status and detailed information such ascontact info, interview documentation, salary, and spouse information.