Tim Johnson Email & Phone Number

Louisville, Ky, Us

Louisville, Ky

• Lead on Group Security duties , researching and defining procedures and changes• SME on transition project to move users from old to new Portal• Trained new team member• Resolve 5 to 15 (or more) tickets each week for multiple internal or external groups• Temporary Admin on Service Now• Admin on FrontRange’s HEAT ticketing software• Manage vendor relationships with third party developers of inventory management system (CIMS), terminal software developers and others• Support, troubleshoot and maintain CIMS and manage, test and implement upgrades to application, backend and database• Develop and run ad hoc queries and reports for CIMS team for process and data fixes• Researched and solved 2-year ongoing performance issue around CIMS database log• Wrote stored procedure for updating billing IDs in transaction processing system• Developing new custom reporting for merchants who use CIMS to provide better detail and consolidation of data from multiple merchants under a single master merchant• Support, troubleshoot and maintain Visual Manufacturing software for Card Production and Accounting• Develop for and support BRFOPS application for ordering card data, ensuring accuracy and consistency for those orders• Support and develop updates for Visual Manufacturing, reports and custom macros• Support and develop changes to SQL database, Access frontend, invoices and reports for invoicing system• Migrating Access databases to SQL Server for performance, data and integration improvements• SME team member for CIMS rewrite team• Responsible for research, testing and implementation for the move from physical to virtual servers for current CIMS software implementation• Responsible for changes to transaction processing invoicing system for ecommerce changes• Led the successful transition to new warehouses and their integration with SVS in Europe• Lead consultant on VeriFone terminal software update project• QA Tester on VeriFone terminal software project

Louisville, Kentucky Area

I handle all FOCCUS testing for couples looking to be married. My wife and I are sometimes a Sponsor Couple for engaged couples as well. I preach all the Masses twice a month. I am involved with the Boy Scouts as Chaplain and Institiutional Representative for the Cub Scouts. I also perform Baptisms when needed and funeral vigils, funeral services and the committal services when I can for the families who are in need of a minister at those difficult times.

Linn Station Road Office

• Developed SQL Server database and code to automate reporting, importing data from Oracle servers using SSIS packages and stored procedures• Designed SharePoint pages for reporting data for Insight Business• Updated and further enhanced CAPEX/Maintenance Excel tool to accommodate expanded time-frame and further data validation and reporting requirements• Coded automated updating of project pages and reporting pages in Excel VBA

• Updated Oracle SQL code used in Benefits Workstation• Coded and ran QA queries and comparisons• Worked with and guided offshore developers on implementation project• Validated work done by offshore team• Updated queries used in data validation processes

• Gathered requirements for multiple projects that would automate ongoing manual processes• Developed spreadsheet/database interfaces to automate reporting processes for financial analysts• Updated and streamlined primary analytical tool used by department to track and budget maintenance dollars

• Researched, designed and wrote short term Agent Incentive database to pay 1700 agents bi-weekly• Lead in Phase I of design and implementation of new commission receivable and incentive payment system called OPAS• Developed Local Marketing Expenses Database for local and remote users• Rewrote Appointment Execution reports for better accuracy and reliability for field sales management up through senior management• Performed ad hoc data analysis for customers at all levels up to senior management• Advised on implementation of new web based reporting system• Developed several automated processes to load, process and report on sales incentives• Used Access to automate custom pivot tables and charts created in Excel• Updated and fixed errors in existing Human Resources Access database• Helped IT partners understand business’ needs, requirements, systems and data• Provided code samples to IT partners on several projects to explain how a task could be done• Supported several programs and systems developed in house and externally using Access and SQL Server• Designed and developed database to manage contractors and analyze current usage and future needs• Automated import of daily downloads from mainframe systems• Designed and developed database to help increase member retention in 2009 and 2010 campaign years• Wrote Vision and Scope documents for two phases of OPAS project• Wrote System Requirements documents for two phases of OPAS project• Wrote Use Cases for two phases of OPAS project• Developed test scenarios, scripts and fixed datasets for use in testing OPAS project• Helped business team develop use cases and test cases based on system requirements for OPAS project• Performed data validation on test cases in OPAS Project• Executed test cases for OPAS and other projects on an as needed basis

• Created new documentation for users and updated system documentation• Created a time tracking tool used by developers and support personnel to log time and activities and automatically send logs to various recipients at the user’s discretion• Updated Check Request System to eliminate confirmation for sending an email notification and added more error trapping code to be more robust• Updated Competitor Tracking database reporting and for easier user maintenance of lookup tables• Updated and fixed problems in Underwriting database. Was in process of adding auditing capability and security when contract ended• Updated Atlas Adjustments database to reflect data and system changes• On each project gathered requirements and tested each item with specific datasets

• Developed supply chain Weekly Planning Tool and co-developed Intransit Tool in SQL Server, Access and Excel for a $1 billion plus product line• Co-designed and documented Functional and Technical Specifications• Mapped process to account for variations in supply in planning process• Created Access control panel to automate separate planning spreadsheets from empty templates• Headed the migration from Access back end to MSDE to SQL Server 2000. • Developed data validation procedures to verify data integrity• Developed queries and VBA procedures to map and manipulate various data inputs and outputs

• Upgraded and maintained custom Access program to track customers, merchants and billing activities• Defined business rules and process requirements to design new procedures• Rewrote monthly billing procedures and product management modules to enable an on-demand billing process capturing previously unbilled amounts averaging $50,000 per month• Developed end-user tools for the creation of new and custom products to replace developer intervention• Used Access reporting tools to create custom reports and procedures for a variety of data analysis situations, including export for analysis in Microsoft Excel• Developed custom procedures in Access VBA in conjunction with Zip tools to maintain relevant data backups related to the custom application

• Used Access to create interfaces to accounting process using data stored on SQL Server to review and approve custom adjustments to other in-house reporting systems• Worked closely with the SME to turn requirements and rules into a user configurable application • Developed user tool to create custom queries on the fly for generating data for Access reporting tools. • Created complete documentation for user and developers on all processes/interfaces

• Conceived and executed NT network upgrades, changes and reconfiguration. • Responsible for troubleshooting, setup and maintenance of web related projects, PCs and servers • Installed/Upgraded/Transferred and helped maintain several Microsoft SQL Server 6.5 and 7.0 systems• Administered users and security on new SQL Server systems at multiple locations• Updated Access/SQL Server based Plant Maintenance System used to track maintenance issues in the plant using custom forms, extensive queries, VBA procedures and user-based security• Supported and updated Access/SQL Server based Purchasing System used to track accounting functions related to Purchasing and Accounts Payable and Receivable using custom forms, extensive queries, VBA procedures and user-based security• Developed custom Access reporting tools based on user-entered criteria• Developed a code-only (executes on the command line only) Visual Basic application for gathering data from an Oracle RDB server and transferring to an SQL server on an automated schedule• Set up a development and test Internet Information Server box for programmers• Rewrote Zeon’s Texas and Mississippi Plant Lab Systems from Ideo platform to Access 2000 using SQL Server backend