E l a i n e R e n e e D a v i s

EMPLOYMENT

Reporting Analyst

**/**/**** – 01/24/2024 Alabama One Credit Union Tuscaloosa, AL

Created Reports and Dashboards for our Keystone Database using Jaspersoft Studio.

Integral in converting 2 credit unions and 1 bank into our system. I did all the ETL work with data maps provided by the operations team.

Regularly performed mass entries, updates, and corrections to the data.

Created code snippets for use by myself and others to ensure that data across reports remained consistent.

Created and scheduled all recurring reports in Keystone.

Created data files for vendors.

Worked with team members across all departments of Alabama One. Database Reporting Analyst

02/06/2018 – 11/08/2019 Regions Birmingham, AL

Created Access database to track all Specialty Lending customers complete with data entry forms and reports.

Regularly mass imported and updated data in production database.

Queries ran in SAS, reporting in Excel. Advanced Excel usage including macros, vlookups and visual basic.

IT/Programmer Analyst II

05/13/2015 – 08/30/2017 UAB – Advancement Services Birmingham, AL

Provided most of the ad hoc and recurring reports for areas all over campus out of our Banner Advance Oracle database using the ODS and EDW schemas as well as direct Alumni tables and Student validation tables.

Main reporting tool is PL/SQL developer.

UAB is an Alpha and Beta site for Ellucian CRM. I did lots of data integrity checks for the conversion.

12352 George Newell Rd • Vance, Alabama 35490

Cell Phone: 205-***-**** • E-mail: ad4s90@r.postjobfree.com IT/Programmer Analyst II

09/21/2011 – 05/12/2015 UAB – HR Information Systems Birmingham, AL

Write/modify complex programs using PL/SQL and TOAD for oracle to produce reports used for various Human Resources entities and other areas of the campus and hospital.

Create Reports from the LMS (HealthStream) to very that employees have completed required courses.

Compile several reports monthly which contains data from no less than 4 sources.

Extensively document the procedures I use to produce the reports I am responsible for.

Worked on migrating data from Oracle EBS to MS SQL server using SSIS. IT/Data Resources Analyst

12/1/2008 – 08/10/2010 UA – Office of the University Registrar Tuscaloosa, AL

Write/modify complex programs using PL/SQL and TOAD for oracle to produce reports used all over campus from the Banner Student Database.

Used Dreamweaver to modify and add pages to the University Registrar’s website using HTML, CSS, and JavaScript. I am familiar with MySQL and PHP for collecting data online.

Processed security requests for access to Banner Student data.

Created and modified reports on TideBytes (Crystal Reports) for use both within the Registrar’s Office and across campus.

Worked with OIT to troubleshoot problems that occurred with student accounts as well as internal problems.

Created data files for external vendors.

Data Resources Coordinator

12/19/2005 – 11/30/2008 UA – Center for Teaching & Learning Tuscaloosa, AL

Programming Languages: MySQL, Transact SQL, and Visual Basic

Advanced knowledge of MS Office software: Word, Access, Excel, PowerPoint, and Outlook

Worked with all departments of the CTL to provide reporting as well as computer support. Advancement Information Systems Programmer

08/26/2002 – 12/19/2005 UA – Advancement Services Tuscaloosa, AL

Write/modify system configuration and complex programs to meet Millennium database end user needs and maximize system productivity using in-depth knowledge of system software and database structure. Develop complex queries and reports pertinent to major gift and annual fund-raising programs and alumni activities.

Coordinate or provide all instructional training to, and assist, over 180 Millennium database users to ensure effective use of the client/server system—including query management, report generation, and links to word processing, spreadsheet, graphic, relational database, and statistical analysis programs.

Coordinate response to all report requests sent to Advancement Services by University personnel and non-University organizations, by coordination the report tasks assigned to the other Advancement Information Systems Programmer, the Advancement Services Programmer, and the Alumni Office programming staff.

Assist the manager, Area Technology and Computer Support in developing management database applications, incorporating system modifications, and performing other tasks as assigned.

Alumni Programmer

7/11/2000 – 8/26/2002 UA – Alumni Affairs Tuscaloosa, AL

Programming Languages: Transact SQL, Visual Basic, C++

Utilizes several reporting tools including Crystal Decisions, MS Access, and R & R

Responsible for over 30 routine monthly reports which are produced using Crystal Reports, MS Access, MS Excel, or a combination of which with information taken from our SQL database.

Responsible for 7 weekly reports that track and ensure data entry accuracy and production. EDUCATION

1995 - 1998 University of Alabama at Birmingham Birmingham, AL Bachelor of Science Major: Biology Minor: Chemistry 1991 - 1995 Shelton State Community College Tuscaloosa, AL Associate in Science Pre-Cytotechnology

General Biology Student of the Year Award

Who’s Who Among American Junior Colleges

Dean’s/President’s list for four or more consecutive terms VOLUNTEER EXPERIENCE

While at Shelton I was an active member of their Chemistry Club. At times I was the only member. Dr. Andrea Wallace was the Advisor for the club. For over two years we traveled the City and County schools, putting on Chemistry Demonstrations for K-6th graders. Some weeks we did as many as six shows. Dr. Wallace and I did many demonstrations when there was just the two of us.

We were also able to put on a chemistry camp for sixth grade students one summer where we brought kids into the chemistry lab at Shelton and Shelton Chemistry Students supervised and guided the kids through their own experiments.

PUBLICATIONS

I have had two abstracts published by the American College of Rheumatology and they appear in their 63rd Annual Scientific Meeting Journal. These were both written in 1999 while I was working for the LUMINA Study. It should be noted that I am listed there by my maiden name of R Gregory. They are as follows:

A Comparison Between a Vertical and Horizontal Visual Analog Scale to Measure Disease Activity for Patients with SLE. I was second author on this abstract. The first author on that abstract, Kemi T. Brooks presented it during the ACR Poster Session C: Health and Services Outcomes II.

Unexpected Lack of Occurrence of Fibromyalgia Among a Cohort of SLE Patients from Three Ethnic Groups. I was first author on this abstract and it was accepted for oral presentation. I presented it during the ARHP Concurrent Session: Ethnicity and Outcomes.

Contact this candidate