ROSALINDA F. MORENO
LAS CRUCES,NM
Summary
Dynamic professional in Business Computer Systems with a strong focus on database performance tuning and data warehousing strategies. Extensive experience mentoring teams, supporting enterprise systems, and driving successful technical initiatives.
Currently expanding into instructional design and teaching, leveraging a Master of Education in Educational Learning Technologies to create learner-centered experiences that translate complex technical systems into practical, real-world learning.
Overview
36
36
years of professional experience
Work History
Enterprise Database Administrator, Ld.
New Mexico State University
Las Cruces, USA
03.2024 - Current
- Monitored system performance and resolved database issues promptly.
- Tuned performance for Banner ODS migration to Oracle Cloud.
- Mentored lead programmer, enhancing performance and fostering collaboration within team.
Banner/ODS Administrator
New Mexico State University
Las Cruces, New Mexico
01.2005 - 07.2023
- Support and Oversee Banner Operational Data Store, Maintenance, Upgrades, and Patches.
- Provides ODS administration, monitors refreshes, loads, and freezes for HR, Finance, Financial Aid, Student, and General.
- Supported performance tuning of ODS database and reporting views, optimizing AMV9 nightly and weekend jobs, including refresh collections, loads, and freezes.
- Troubleshoot any problems encountered with ODS refreshes, loads, and freezes.
- Coordinate the scheduling of operational data store refreshes, loads, and freezes to ensure timely updates.
- Provide ODS support, which includes missing data in reporting, composite views, ODS tables, and banner and ODS materialized views.
- Developed AMV9 jobs for efficient data handling in the operational data store environment.
- Ensure the reliability and availability of the operational data store by checking nightly nets and resolving ODS refresh run-time errors.
- Perform DDL and DML to ODS and NMSU tables.
- ODS/Banner Upgrades and resolving problems in Banner ODS ETL control jobs.
- Provided support for testing after any Oracle upgrades or patches, this may include changes in Oracle parameters, Oracle stats and explain plans, set up parameters, schedule processes, run utilities, and maintain freeze data.
- Led ODS cleanup initiative by creating a timeline and implementing data management strategies, including schema migrations, table compression, and removal of freeze events.
- Created data marts in the ODS environment, using external tables and AMV9 jobs to repopulate tables weekly.
- Collaborated on team research to design and implement Oracle roles for specific tables related to Financial Aid and disability.
- Collaborated with a team on the HEST Curricula Project to ensure proper data transfer to ODS, scheduled refreshes and loads of the banner and ODS data.
- Worked with a group of Leads and developers in the planning, research, and testing of a new ERP Server migration from Solaris to Linux.
- Worked as a member of the Project Evaluation Team in defining: Project versus Operational, Project Intake Document, Project Charter, and GIT and GITFLOW Toolsets.
- Perform analysis on future ODS and Oracle enhancements, tools, and techniques.
- Provided documentation and training on Banner and ODS administration and Cognos Analytics 11.x.
Enterprise Programmer Analyst, Ld.
New Mexico State University
Las Cruces, USA
07.1997 - 07.2023
- Lead Administrator for Upgrading Cognos 10.2.2 to Cognos Analytics 11.1.7, applied upgrades and administration of the newly distributed Cognos Analytics 11.1.7.
- Led project timeline development, conducted research, and planned analytics projects, including analytics upgrades and single sign-on with 2FA SSO.
- Led 2FA project as administrator with IBM Persona IQ and NMSU, resolving issues to ensure implementation before June deadline.
- Supported Cognos Analytics through fix packs, NC table cleanup, security fixes, system performance tuning, report and dashboard deployments, user role development, AMV9 upgrades, SDK testing, and migration of Audit tables from SQL Server to Oracle.
- New Generic namespaces, loading Analytics users to new OIDC, renew credentials, and work with Persona IQ on Migration.
- Configured settings and managed startup/shutdown processes for nine servers across development, user test, and production environments.
- Worked with IBM and NMSU on sizing exercises on servers.
- Primary support for Cognos Analytics 11.
Programmer
City of Las Cruces
Las Cruces, USA
01.1990 - 07.1997
- Utilized Cobol, CICS, VSAM, JCL, and CMS for application development.
- Contributed to design of new online systems by writing new programs, modifying existing code, creating online screens, and developing online reports and batch production programs using CICS.
- Designed, tested, and implemented the New City Work Order System; Labor Model System; Sanitation Online System; and new Special Assessment Paving Online and monthly batch billing system.
- Enhanced functionality of RSVP (Retired Senior Volunteer Program) System by resolving issues with online screens and reporting capabilities.
- Designed and programmed various batch reports for use in the Budget process.
- Worked extensively in the business environment, writing applications.
- Conducted user training for RSVP, Budget, Sanitation Online, Work Order, Labor Model, Profs, WordPerfect, and CMS systems.
- Developed documentation and flowcharts for batch and online systems to support operational needs at City of Las Cruces.
- Maintained and assisted users with existing systems, including Fixed Assets, Federal Grants, Support Services, County Parcel System, Budget, and Payroll/Personnel System.
- Provided and assisted in the standby call for the online Police and MDT system, also standby call for production problem calls.
- Provided technical and user support to assist users with the new Banner Financial System.
- The City of Las Cruces provided training on Oracle Tools and Developer 2000 for the new Banner Finance System.
- Was involved in the implementation of the SCT Banner Finance System and assisted in the conversion of Financial Systems using SQL Tools to the SCT Banner Application.
Education
Master of Arts -
New Mexico State University
Las Cruces, NM05-2026
BBA - BUSINESS COMPUTER SYSTEMS
New Mexico State University
Las Cruces, NM05-1990
Skills
- Database technologies
- Database management systems
- database performance tuning
- Database design principles
- data modeling techniques
- Data warehousing strategies
- PL/SQL programming
- COBOL programming language
- CICS transaction server
- database project lifecycle
- git version control basics
- documentation for technical processes
- general operating systems: Windows, UNIX/Linux
Training
- Atomic UC4
- IBM Cognos 10
- IBM Cognos Framework Manager Metadata Models
- Java
- Groovy and Grails
- Ruby and Rails
- Working with Node.js
- Banner Workflow
- Linux Redirection Approaches and Process Control
- Kanban Training
- Agile Project Management Essentials
- Adopting an Agile Approach to Project Management
- Completion of Software Development Security Training
- Beginner GIT
- GIT Fundamentals
- Ellucian GIT Installation Overview
- Cognos Analytics 11 Data Marts and Dashboard training
- HEDW 2021 Virtual Conference
Database Knowledge
- SQL Server Administration 2000
- DB2
- Oracle 8.1.7
- 9i
- 10
- 11G
- Oracle Database 11g: New Features for Administrators
- Oracle Database 11g: Administer a Data Warehouse Ed 2.
- Oracle 12C
- Oracle 12c Performance Tuning
- Introduction Managing an Oracle Database 12c Instance
- Optimizing SQL Queries in Oracle
- Oracle Database 12c Fundamentals
Timeline
Enterprise Database Administrator, Ld.
New Mexico State University
03.2024 - Current
Banner/ODS Administrator
New Mexico State University
01.2005 - 07.2023
Enterprise Programmer Analyst, Ld.
New Mexico State University
07.1997 - 07.2023
Programmer
City of Las Cruces
01.1990 - 07.1997
Master of Arts -
New Mexico State University
BBA - BUSINESS COMPUTER SYSTEMS
New Mexico State University