System Analyst
Current• Plan, design, and maintain an online training course that aids hundreds of TxDOT contract specialists. The course specializes in the contract entry process and certifies end users in their ability to manage, maintain, and close contracts in the Oracle PeopleSoft program. This has consequently lowered the number of PeopleSoft help request tickets by more than 50%.• Create dashboard analytics in the form of Tableau spreadsheets and SQL queries, which show accurate and complete data for the Contract Services Division of Texas. These analytics display turnover rates for over 30 employees, accounting data for over $50M in monthly expenses, and workflow management output for several teams. This allows for high value stake holders to make informed decisions that lead the organization towards maximum efficiency.• Plan, Develop, and maintain an online help desk (TxDOTNOW) that manages PeopleSoft user requests. This website replaced antiquated systems, increased help desk throughput by 98%, and categorized complaints to aid in overall customer satisfaction.• Write system manuals to provide training and education for end users on the contract entry process in the PeopleSoft Program. These manuals currently total to over 1000 pages, and are updated annually. Help desk requests for issues solved by the manuals’ instruction decreased by 25% after manual release date.