Sql Developer Resume Profile
BACKGROUND
Possess 15 years of experience with extensive and diversified knowledge in Ellucian/Datatel's higher education administrative software in Student, HR/Payroll and Financial systems on Windows, SQL, Unix and UniData systems. I possess excellent Investigative, Research, Analytical and QA/Testing skills and work effectively in all levels of an organization. I have in-depth knowledge and experience with implementing and integrating 3rd party solutions with technical knowledge of programming languages, operating systems, databases, reporting tools and web applications. I have experience with systems integration, custom data imports/exports and automation with scripts and programs. I am proficient in Datatel's development tools using Envision, Colleague Studio, UniBasic, UniQuery, UniObjects and TOOL Kit. I train staff on setup, using ERP resources and creating/managing custom reports and programs. I pride myself on keeping up-to-date on latest technology and trends in higher education, ERP and web related technologies.
EXPERIENCE
Confidential
- Worked with over two dozen clients using SQL, Unix/Linux and UniData
- Provide Functional consultation to clients using Ellucian Datatel Colleague ERP
- Provide Technical consultation to clients using Ellucian Datatel Colleague ERP
- Provide Programming support using Envision in Studio and Toolkit
Confidential
- Provide implementation, integration, testing, training and post implementation support to clients
- Assess client requirements and develop/rollout implementation/integration plan
- Implement custom solutions to meet client's special needs
- Developed real-time Payment system integration to Datatel Financial system for UniData, SQL and Oracle
- Created middleware communication bridge between external java connection and Datatel Application, Envision and Database layers - full access to Student, HR/Payroll and Financial systems
- Provide real-time integration to Accounts Receivable transactions, Balance retrievals, Status Updates, Budget Adjustments and program Enrollment/Deactivation
- Developed multiple payment, invoice and deposit options
- Created balance by Term, date range and Current Outstanding Balance
- Created detailed transaction logs and dynamic transaction links to Payment System
Confidential
- Implement and train users on using 3rd party web reporting tool - Entrinsik Informer 3.x and 4.x
- Assess acquisition of HR's selection and hiring solution
- Develop training material and train IT staff/end users to effectively use the ERP
- Assisted App Dev Manager with managing/installing Datatel software updates
- Ensure usability and stability of Datatel ERP system including resolving bugs introduced by updates
- Participate in team meetings and weekly committee meetings to define and meet stakeholder's needs
- Perform system and database administration tasks
Confidential
- Provide consulting, implementation and project mgmt services on school projects with various departments
- Implement and integrate 3rd party solutions - Online Applications, Reporting, Assessment, ACCESS
- Implement Student, HR/Payroll and Financial solutions to better utilize available technology solutions
- Created reports and programs to enhance the functionality of Student, HR/Payroll and Financial systems
- Automate communications with students using Communications Management through scripts
- Trained staff on using and supporting Student, HR/Payroll and Financial systems
- Created and implemented custom database to track int'l Students/documents and ACCESS students
- Advised and processed requests for implementation/programming/system enhancements
Confidential
- Provide consulting, implementation and project mgmt services on school projects with various departments
- Implement and integrate 3rd party solutions - Address Validation, Online Applications, Reporting, Assessment
- Implement Student, HR/Payroll and Financial solutions to better utilize available technology solutions
- Implement HR Leave tracking and processing and Communications Management
- Integrate external CAPP Testing system to use student's test data and equivalencies
- Created reports and programs to enhance the functionality of Student, HR/Payroll and Financial systems
- Developed and implemented automation scripts to streamline repetitive tasks
- Automate imports/exports and email communications with students, faculty and staff
- Trained staff on using and supporting Student, HR/Payroll and Financial systems
- Created programs to cleanup data and maintain data integrity
- Conduct meetings with department managers to address timelines and deliverables
- Advised and processed requests for programming/system enhancements
Confidential
- Implemented Datatel's HR/Payroll systems, setup codes/reports and trained users
- Converted pay history, benefits, leave accruals data from legacy and import to ERP system
- Consult with IS staff, project and dept. managers in implementation, conversion and programming support
- Participate in Project Management, CORE and HR Implementation Team meetings to address IS support and develop strategies to reach college's goals
- Create and develop custom programs to support Colleague R16 Student, HR and Financial System
- Assist project managers in development of system enhancements and implementation of HR module
- Manage Task List, report progress and assign Service Requests to programming staff
- Create front-end screens and Envision Batch Reports for end users
- Assist with data conversion from Legacy and QSS Systems
Confidential
- Managed development team and provide directions to implementing support/services
- Planned, loaded, configured and managed Datatel patches, modules and Unidata RDBMS
- Developed programs/reports in R13/15 to track and maintain prospects, applicants and student information
- Managed implementation teams to plan and prepare for conversion to R16
- Conducted user group/Implementation Team meetings and advise/trained end users on using modules, programs and reports
- Developed and managed application, module security and access rights
- Implemented FedEx PowerShip mass mailing system, developed programs to format and export data, documented procedures and trained users
- Analyzed, developed and implemented programs to import electronic files that automated data entry