Victor Frank Email & Phone Number

St. Louis, Mo, Us

Monett, Missouri, Us

• Manage all our PeopleSoft systems (FSCM, HCM, HelpDesk, CRM) by performing a wide array of system administration tasks • Perform DBA related tasks with SQL Servers; backups, restores, security, and other SQL duties • Write SQL queries to use in data analysis and report writing• Analyze and tune the performance of long running and expensive queries causing slow response times with a database • Develop PowerShell scripts to automate tasks and provider quicker completion of tasks• Responsible for development migrations to our Production systems, acting as the gatekeeper to ensure 100% reliable environments • Mentor and educate others. Work with multiple teams in other departments• Monitor all Production systems and write automated reporting to provide 24/7 support • Apply Oracle critical updates and security fixes to patch java and security concerns • Provide reports and data when requested about system performance of a Production system • Provide day to day support for all users requests for any environment• Apply server and database level security for users • Manage security groups and setup for ease of applying security to server, shares, etc. • Customize our PeopleSoft environments and apply domain configurations appropriately • Administer WebLogic settings for our web servers, and tuxedo for our application servers • Setup all external integrations to our PeopleSoft systems (SSIS, messages, WSDLs) • Fully document all system administration policies, tasks, and project work • Completed a full application and tools upgrade on our FSCM, HCM, and CRM systems (Applications run 9.2 and tools 8.55)• Constantly keeping up with current technology trends and leading in new tool deployments• Board member of Quest Tech SIG: Share my knowledge to others at conferences and events

St. Louis, Mo, Us

• Main responsibility is to ensure our PeopleSoft systems are current and upgraded to the latest tools and application release• Support and administer all PeopleSoft systems (FSCM, HCM, Portal) on an Oracle database and Unix (AIX) OS• Primary administrator that researches and maps out the upgrade plan for tools and applications• Support production issues by using troubleshooting skills to resolve problems affecting the user's ability to perform their jobs• Currently planning out three upgrades at one time (Tools 8.55 for HCM, FSCM, iHub; Portal to iHub 9.1 application upgrade)• Responsible for development migrations to our Production systems• Routinely apply all HCM Tax Patches as they are released• Keep our PUM image environments current with the latest release from PeopleSoft• Compile and implement bug fixes from the PUM images into our PRD environments• Apply Oracle critical updates and security fixes to patch java and security concerns • Monitor all Production systems and resolve issues that our alerts may send out• Administer WebLogic settings for our web servers, and tuxedo for our application servers • Write detailed documents of problem resolutions, as well as all system upgrade plans• Automate tasks and alerts using Korn shell scripting in Unix environments

Monett, Missouri, Us

• Help manage all our PeopleSoft systems (FSCM, HCM, HelpDesk, CRM) by performing a wide array of system administration tasks • Perform DBA related tasks with SQL Servers; backups, restores, security, and other SQL duties • Responsible for development migrations to our Production systems, acting as the gatekeeper to ensure 100% reliable environments • Completed a full application and tools upgrade simultaneously on our CRM system. (Application from 8.9 to 9.1, and tools 8.50 to 8.53) • Apply Oracle critical updates and security fixes to patch java and security concerns • Monitor all Production systems and write automated reporting to provide 24/7 support • Analyze and tune the performance of long running and expensive queries causing slow response times with a database • Constantly keep management updated with all concerns of database and system reliability • Provide reports and data when requested about system performance of a Production system • Research all Oracle documentation on tools, patches, and updates when applying this to our systems • Provide day to day support for our developers and their requests for non-prd tiers • Apply server and database level security for users • Manage security groups and setup for ease of applying security to server, shares, etc. • Customize our PeopleSoft environments and apply domain configurations appropriately • Administer WebLogic settings for our web servers, and tuxedo for our application servers • Setup all external integrations to our PeopleSoft systems (SSIS, messages, WSDLs) • Complete all steps with messaging and Integration Broker so one system can interact with another and transfer data • Fully document all system administration policies, tasks, and project work • Write T-SQL queries for assisting with day to day monitoring and database support • Develop PowerShell scripts to automate tasks and provider quicker completion of tasks

Monett, Missouri, Us

• Ten years combined PeopleSoft development experience• Developed an array of applications utilizing SQL Server (Interfaces, Engines, reports, SQR, SQL Queries)• Tuned application processes to speed up the delivery of data and functionality to our end-users• Responsible for developing Financial and Budget reports for all types of users, including the CEO• Lead developer in our 2012 Hyperion project which became the new Budget system• Provided mentoring and leadership to entry-level developers• Supported the stability of our internal PeopleSoft systems (Finance, Budget)• Five years as lead developer for the Budget system with managerial responsibilities• Assisted with project scope, charters, and other project related documentation when necessary• Designed and developed our company’s ACH program to allow electronic payments to vendors• Worked with customers throughout entire development life-cycle to successfully deliver their requests• Responsible for efficiently planning, processing, and performing jobs with no managerial assistance• Strong and effective interpersonal skills and the ability to interact professionally with a diverse group of customers, clients, and staff

Springfield, Mo, Us

• Provided top level customer support to employees and executives• Designed specification documents by working hand in hand with end users• Responsible for researching new design techniques and cross-training other developers• Gained invaluable experience in how a non-profit Government municipal utility operates• Developed PeopleSoft applications for Finance, Purchasing, Inventory, and Human Resource systems• Developed billing and HR systems with technical skills that allowed CU customers’ bills to be collected• Provided recommendations to management concerning issues of productivity and developer practices• Prepared reports used for analysis by the utility to ensure the correct financial decisions were executed• Participated in volunteer activities for utility/community projects

Ozark, Mo, Us

• Developed web-based applications by implementing design specifications from start to finish• Provided advice, training, and technical support for various projects• Resolved time critical support issues to meet customer expectations• Implemented a project to integrate BeyondCompare as a versioning tool within the company• Daily duties consisted of client support, internal resolution, product development, and cross-training

Kansas City, Missouri, Us

• Developed healthcare applications that maintained patient data and returned search results faster• Interacted with AIX and Oracle environments using CCL (SQL), VB, and PL/SQL• Completed a project incorporating Netric’s Search Logic into the software for the first time• Resolved defects from previous code releases and worked with client sites to correct any issues

Springfield, Mo, Us

• Worked as an Intern while still attending school at Missouri State• Several various job tasks were assigned to gain knowledge of every department in IT• Implemented a 7.5 to 8.0 upgrade in PeopleSoft for both Finance and HCM• Developed in PeopleSoft, SQR, VB, Cobol, and other in-house applications that accessed a mainframe