Experience

Parker University

• United States
• Higher Education
• 300 - 400 Employee

• Director of Enterprise Applications

  • Dec 2019 - Present



HealthAxis Group

• United States
• Software Development
• 100 - 200 Employee

• Database Developer

  • Aug 2018 - Mar 2020

  • Design, develop and implement database SSIS process based on customer requirements. • Create SSIS packages using BIML. • Identify any issues related to SQL queries, SSIS packages and SQL jobs and provide corrective measures. • Create complex functions, scripts, and stored procedures to support development. • Design, develop and implement database SSIS process based on customer requirements. • Create SSIS packages using BIML. • Identify any issues related to SQL queries, SSIS packages and SQL jobs and provide corrective measures. • Create complex functions, scripts, and stored procedures to support development.



Texas Wesleyan University

• Higher Education
• 300 - 400 Employee

• Manager, Business Applications Support

  • May 2014 - May 2018

  • Maintains the Student and Finance ERP on Ellucian Colleague and MS SQL Database • Make decisions and suggestions on applications to implement into our current system • Negotiated terms of contracts for products and agreements • Manage, hire, mentor and train a team of application programmers • Manage projects outlining timeline and resources to ensure a timely and successful completion • Lead meetings and gather specifications from users to fulfill their needs and requirements • Transformed business requirements into new front-end forms, Envision routines, computed columns, rules, and ELF processes for the UT, Core, HR, and Student (including AR and FA), modules in Colleague, an enterprise application suite • Performed basic SSL certificate management and configuration within IIS 7 for web services integration • Created ETL routines with SQL Server Integration Services to exchange data between the main ERP and other applications • Design of 100+ reports for units across the university using SQL Server Reporting Services • Created T-SQL views, functions, and stored procedures to simplify and standardize report writing and ETL tasks. • Maintain software written in ASP.NET on MVC framework, some python code, and Ellucian envision • Manage a small team of programmers assisting them with prioritizing task and programming logic • Act as Business Analyst to ensure project completion with accuracy and on schedule • Creates user documentation • Create MS SQL jobs, view, function, procedures to maintain integrations of business applications and data export/import • Manages multiple projects to ensure a satisfactory and timely completion • Use SQL Server Integration Services (SSIS) to schedule and run web service task that runs process in the system • Use C# and Python code to run web service task for data integration Show less



Texas Woman's University

• United States
• Higher Education
• 700 & Above Employee

• Senior Integration Analyst

  • May 2008 - May 2014

  • Maintains the Student and Finance System on the Colleague and Oracle Database• Mentor and train new hires in our oracle and colleague system• Design an ASP.NET website using C# to calculate tuition estimates• Create subroutines and batch process using Datatel Envision to satisfy university needs• Create UI screen in Colleague • Troubleshoot problems/issues with Colleague process or screen to ensure problem resolution• Writes rules used by registration processors, financial aid system, Communications Management, and accounts receivable• Evaluates and make recommendations on system efficiency• Creates user documentation on custom processes • Works with users to discuss and determine system problems and resolutions• Manages multiple projects to ensure a satisfactory and timely completion• Creates and maintains SQL Reports using SQL Server Reporting Services (SSRS) connecting to an Oracle database• Use SQL Server Integration Services (SSIS) to schedule and control the population of data from Colleague tables to custom Oracle tables maintaining data integrity • Use SQL Server Analysis Services (SSAS) to create cubes that allows users to have the freedom to evaluate the data more independently• Created Envision process that runs Oracle functions and Oracle procedures from Colleague• Creates and designs Envision processes using Colleague Studio or Colleague Toolkit Show less

• Integration Analyst

  • Aug 2006 - May 2008

  • Maintained the Student System on the Colleague Database• Work with team to convert Unidata database to an Oracle Database• Cleaned current files with corrupt data using AE editor• Create and maintain custom and delivered colleague files, computed columns, and data fields• Ran the Colleague scanners (CDSU and CDSR) to determine the colleague files that need to be cleaned up before the files can be moved into oracle (ODS)• Played a key role in the modification and the implementation of WebAdvisor• Evaluated and made recommendations on system efficiency• Created end-user documentation• Created custom programs to satisfy user needs • Designed and developed Envision processes using the Colleague ToolKit• Managed multiple projects to ensure a satisfactory and timely completion• Contributed in modifying and rewriting the Texas Higher Education Coordinating Board reports Show less



Lone Star College

• United States
• Higher Education
• 700 & Above Employee

• System Analyst

  • Feb 2005 - Aug 2006

  • Analyzed, designed, tested, prepared for installation, documented and maintained new and existing computer application programs which have a moderate to high degree of complexity in areas such as GL and AR/CR • Analyzed, evaluated and made recommendations concerning existing information technology/systems processes and the development of new procedures, standards, tools and techniques • Worked as a team member on complex projects; effectively interfaces with technical and non-technical personnel • Assisted other staff in researching technical problems and complex designs in order to develop staff capabilities • Maintained patches from vendor; Datatel • Responsible for the analysis of existing and future software in order to implement design improvements • Met with college administrators and staff to evaluate Colleague issues • Designed programs using Datatel Envision, UniBasic, and UniQuery Show less