Contract – Maricopa County Nov 2021 – PresentBusiness/Data/Programmer Analyst• Manage project to convert over 300 reports from prior assessor application to new application• Tracked project using Trello Kanban board• Create stored procedures, functions, views, tables in SMSS• Create reports in SSRS• Create data extracts for outside agencies based on file layout and specificationsContract – MV Transportation Jan 2020 – Oct 2022Business/Data/Programmer Analyst – part time on as needed basis• T-Sql programming create and support complex operational reports• Front end support for Lawson/Infor products

• Responsible for leading the deployment, implementation, training, documentation, reporting and maintenance of all business applications• Provide leadership and expertise for enterprise business systems that include human resources, finance, enterprise portal, business intelligence, data warehousing, content management, workflow automation, and customer management • Effective problem-solving, negotiation, and decision-making skills to influence management, as well as internal and external partners • Ability to analyze, understand and effectively communicate between business requirements and technical design• Manage projects to ensure they can deliver the benefits outlined in business cases and will meet expectations• Create scripts for data integration between applications • Maintain reporting data warehouse• Custom reporting for Lawson / Infor Financials and HR using Sql Stored Procedures and Sql Server Reporting Services• Create and maintain Excel VBA macros for financial budgeting and for ETL purposes for importing data into Sql Server data warehouse• Support for Infor / Lawson applications including Finance, HCM and Workforce Management (WFM)• Manage SDLC and maintenance of internal applications for legacy time and attendance and employee performance

• Beta tested and implemented Lawson Business Intelligence for forty hospitals• Analyzed and documented end user requirements and processes• Created test plans for dashboards and reports• Customized security code • Developed Crystal Reports for HR, Finance, Supply Chain Management and Grants• Lawson upgrade project from 9 to 9.01

• Design, develop and maintain custom reporting for Lawson• Responsible for Lawson Portal Bookmark Administration• Responsible for application interfaces that import into Lawson• Manage reporting data warehouse on Sql Server• Created and maintain security around the report access based on end user location and security level• Upgrade and implementation of Lawson 7.x to 8.x, 8.x to 9.0