Conversion Tool Lead:•Design, implement, and support a large scale ETL application used for all client Workday conversion activities. The application is used to validate and correct conversion data, transform and load data to the Workday system using Workday web services, and provide a wide range of reports used for data analysis and audits.•Supervise a team of database and Java developers and manage all database and web application change requests throughout the software development life cycle.•Work with business owners and functional teams to formalize new technical requirements for the application, provide timing and cost estimates for new functionality, and resource planning.•Collaborate with IT Operations teams on server upgrades and architecture changes required for the application.•Create and maintain all online documentation of the application and support end users by assisting with issue resolution and providing client specific solutions and customizations.•Perform daily database management tasks including: New database creation; User security management; Create and modify database objects such as Tables, Views, Procedures, Functions, Synonyms, and Sequences; Monitor database performance and troubleshoot issues Client Data Conversion Team Lead:•Managed five direct reports. Established workload, oversaw annual performance and compensation activities, provided raise and promotion recommendations, provided career path guidance, and disciplinary actions as needed. •Worked closely with the client to define the conversion strategy and methodology for a full scale Workday conversion involving HCM, Payroll History, Compensations, Absence, and Benefits data.•Led a conversion team of six Workday consultants through multiple client build iterations. •Accountable for seeing the client conversion to a successful completion.

•Product lead for a large Oracle data warehouse that housed HRMS, Talent, Payroll, and Staffing data from multiple sources applications including PeopleSoft. •Worked with outside application teams to define and design new standard interface files that were used over all client warehouses. •Managed the quarterly roll-out of new releases to fifteen client teams. •Ensured quick resolutions for all product related defects and acted as the subject matter expert for all client team analysts who supported and implemented new client warehouses. •Provided solutions for all client customizations, acted as the escalation point for client teams throughout implementation projects, verified that client teams followed documented standardized processes in order to guarantee a successful and stable system.

•Directly responsible for implementing and supporting client Oracle data warehouses.•Gathered data requirements for all outbound systems, identified required source systems, created formal business requirement documents, oversaw the development and testing of all inbound and outbound interfaces, and performed internal user acceptance testing. •Provided cost estimates for client customizations, created custom SQL based reports, investigated and resolved data related issues.•Performed database management for the client specific Oracle databases as well as owning all trigger and trigger table objects that were created on the clients HRMS database.

•Ongoing PeopleSoft technical support, performing data analysis and corrections, leading training for staff, automating processes through PL/SQL and Oracle Portal, providing web-based applications and data reports for campus staff.•Created an application using Access to house advertised job openings, track applicants, and generate internal and government reports•Successfully designed and built a fiscal year budget analysis tool used by the entire university to budget salaries of over 30 million dollars. The project included the creation of PL/SQL programs, and various database objects for reporting and updating budget lines. •Project lead for a large-scale PeopleSoft data cleanup project. Project included in depth data analysis on all HRMS data, acquiring sign-off from business owners on cleanup approach, creation of cleanup programs, testing, and execution in the production environment.

•Responsible for maintaining computer and networking products on the main and satellite campuses.•Worked with software and hardware vendors for new purchases and resolve issues with existing applications and hardware.•Provided hardware and software support to all faculty and staff.•Implemented campus wide OS and software upgrades.•Put together a comprehensive plan for new computer lab build outs including required hardware, networking, and software needs.

•Led a team of five system analysts through a large HR ERP implementation built on a mainframe DB2 database while also managing ongoing client delivery. •Implementation responsibilities included gathering client requirements, creating a detailed project plan, reviewing and approving system analyst development, and driving the project to a successful completion.•Ongoing responsibilities included overseeing a team of two systems analysts, performing ongoing client database administration, creating and maintaining file interfaces and reports coded in SAS, providing cost estimates for change orders, and consulting the client on impacts for requested system enhancements.